hot_fix_308558_entityvalidation.exp.20090428005738

Simulation of MUTEX and SEMAPHORES.

REM
REM Table ENTITY_VALIDATION_LIST_R
REM
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 1, TO_DATE('18-07-2008 19:42:51','DD-MM-YYYY HH24:MI:SS'), 'AMOUNT', 1000227, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 2, TO_DATE('30-07-2008 12:32:53','DD-MM-YYYY HH24:MI:SS'), 'PAYMENT_RECEIVED_DATE', 1000678, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 3, TO_DATE('20-09-2008 16:33:45','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_4', 1000679, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 4, TO_DATE('18-07-2008 19:42:52','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_2', 1000695, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 5, TO_DATE('18-07-2008 19:42:52','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_3', 1000696, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 6, TO_DATE('18-07-2008 19:42:52','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_6', 1000682, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 7, TO_DATE('18-07-2008 19:42:53','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_7', 1000683, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 8, TO_DATE('18-07-2008 19:42:53','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_8', 1000684, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 9, TO_DATE('18-07-2008 19:42:53','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_9', 1000685, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 10, TO_DATE('18-07-2008 19:42:53','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_10', 1000130, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000603, 11, TO_DATE('07-08-2008 07:02:39','DD-MM-YYYY HH24:MI:SS'), 'PAYMENT_LOCATION_CODE', 1001775, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 1, TO_DATE('07-08-2008 06:21:08','DD-MM-YYYY HH24:MI:SS'), 'AMOUNT', 1000227, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 2, TO_DATE('30-07-2008 12:06:52','DD-MM-YYYY HH24:MI:SS'), 'PAYMENT_RECEIVED_DATE', 1000678, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 3, TO_DATE('30-07-2008 12:43:48','DD-MM-YYYY HH24:MI:SS'), 'CURRENCY_ID', 1001196, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 4, TO_DATE('20-09-2008 16:35:36','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_1', 1000688, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 5, TO_DATE('20-09-2008 16:35:36','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_2', 1000698, NULL, 1);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 6, TO_DATE('20-09-2008 16:35:36','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_3', 1000699, NULL, 1);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 7, TO_DATE('20-09-2008 16:35:36','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_4', 1000679, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 8, TO_DATE('30-07-2008 12:43:49','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_5', 1000681, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 9, TO_DATE('30-07-2008 12:43:49','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_6', 1000682, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 10, TO_DATE('30-07-2008 12:43:49','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_7', 1000683, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 11, TO_DATE('30-07-2008 12:43:49','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_8', 1000684, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 12, TO_DATE('30-07-2008 12:43:49','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_9', 1000685, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 13, TO_DATE('30-07-2008 12:43:50','DD-MM-YYYY HH24:MI:SS'), 'GENERAL_10', 1000130, NULL, 0);
insert into ENTITY_VALIDATION_LIST_R values (47655, 1000604, 14, TO_DATE('07-08-2008 06:21:08','DD-MM-YYYY HH24:MI:SS'), 'PAYMENT_LOCATION_CODE', 1001775, NULL, 0);

REM
REM Table ENTITY_VALIDATION_R
REM
insert into ENTITY_VALIDATION_R values (47655, 1000603, 'cam.pai_SysGeneratedPayments', 'EV for System Generated Payments
$Revision: 1.7 $', TO_DATE('20-04-2009 23:38:10','DD-MM-YYYY HH24:MI:SS'), 11, 901, 'PAYMENT', NULL, NULL, 1000535, '{
cam.fPAYTUBalExpServExpActExp&();                   #Updates the Balance Expiry, Service Expiry and Activation Expiry dates.
cam.fSOSEmergencyRechargeBalance&();                #Checks for the SOS Balance.

if (is_defined(evOldPaydGeneral4$) && is_defined(evPaydGeneral4$))
{
    cam.fCAM_UpdateFreeMinutesStatus&(); #check of the amount stored in the 慣hreshold Value of the Account Balance