[Home] [Help]
1350: status,
1351: chunk,
1352: pay_assignment_actions_s.nextval,
1353: 1
1354: from dual;
1355: else
1356: insert into pay_assignment_actions (
1357: assignment_action_id,
1358: assignment_id,
1381: object_id,
1382: object_type,
1383: start_date,
1384: end_date
1385: from dual;
1386: end if;
1387: end insact;
1388: --
1389: --------------------------------- proccash ---------------------------------
1664: -- rows that we return from the cursor, i.e. one for
1665: -- each assignment/pre-payment.
1666: select pay_assignment_actions_s.nextval
1667: into lockingactid
1668: from dual;
1669: --
1670: -- insert the action record.
1671: -- Note, insert as complete, because we need no further processing.
1672: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid,'C');
1867: if(prev_assignid is null OR prev_assignid <> assignid) then
1868: -- get a value for the action id that is locking.
1869: select pay_assignment_actions_s.nextval
1870: into lockingactid
1871: from dual;
1872: --
1873: -- insert into pay_assignment_actions.
1874: insact(lockingactid,assignid,pactid,rand_chunk,greid);
1875: end if;
2005: if(prev_prepayid is null OR prev_prepayid <> l_prepayid) then
2006: -- get a value for the action id that is locking.
2007: select pay_assignment_actions_s.nextval
2008: into lockingactid
2009: from dual;
2010: --
2011: -- insert into pay_assignment_actions.
2012: insact(lockingactid => lockingactid,
2013: pactid => pactid,
2417: -- rows that we return from the cursor (i.e. one
2418: -- for each assignment/pre-payment).
2419: select pay_assignment_actions_s.nextval
2420: into lockingactid
2421: from dual;
2422: --
2423: -- insert the action record.
2424: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid);
2425: --
2767: -- rows that we return from the cursor (i.e. one
2768: -- for each assignment/pre-payment).
2769: select pay_assignment_actions_s.nextval
2770: into lockingactid
2771: from dual;
2772: --
2773: -- insert the action record.
2774: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid);
2775: --
3073: -- insert master actions
3074: if (prev_person_id is null or prev_person_id <> person_id) then
3075: select pay_assignment_actions_s.nextval
3076: into lockingactid
3077: from dual;
3078:
3079: -- insert into pay_assignment_actions.
3080: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3081:
3091: if(prev_assignid is null OR prev_assignid <> assignid) then
3092: -- get a value for the action id that is locking.
3093: select pay_assignment_actions_s.nextval
3094: into lockingactid
3095: from dual;
3096: --
3097: -- insert into pay_assignment_actions.
3098: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3099: end if;
3368: if(prev_assignid is null OR prev_assignid <> assignid) then
3369: -- get a value for the action id that is locking.
3370: select pay_assignment_actions_s.nextval
3371: into lockingactid
3372: from dual;
3373: --
3374: -- insert into pay_assignment_actions.
3375: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3376: end if;
3862: prev_pactid <> lpactid) then
3863: -- get a value for the action id that is locking.
3864: select pay_assignment_actions_s.nextval
3865: into lockingactid
3866: from dual;
3867: --
3868: -- insert into pay_assignment_actions.
3869: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3870: end if;
4064: if(prev_assignid is null OR prev_assignid <> assignid) then
4065: -- get a value for the action id that is locking.
4066: select pay_assignment_actions_s.nextval
4067: into lockingactid
4068: from dual;
4069: --
4070: -- insert into pay_assignment_actions.
4071: insact(lockingactid,assignid,pactid,rand_chunk,greid);
4072: end if;
4169: --
4170: -- Get an assignment_action_id.
4171: select pay_assignment_actions_s.nextval
4172: into asgactid
4173: from dual;
4174: --
4175: if preasgid is null or preasgid <> assignid then
4176: -- Insert an assignment action for each action.
4177: insact(asgactid,assignid,pactid,rand_chunk,null,null);
4485: --
4486: -- Get an assignment_action_id.
4487: select pay_assignment_actions_s.nextval
4488: into lockingactid
4489: from dual;
4490: --
4491: -- Insert an assignment action for each action.
4492: insact(lockingactid,assignid,pactid,rand_chunk,greid,null);
4493: --
4550:
4551: -- Get an assignment_action_id.
4552: select pay_assignment_actions_s.nextval
4553: into lockingactid
4554: from dual;
4555: --
4556: -- Insert an assignment action for each action.
4557: insact(lockingactid,assignid,pactid,rand_chunk,greid,null);
4558: --
4621: --
4622: -- Get an assignment_action_id.
4623: select pay_assignment_actions_s.nextval
4624: into lockingactid
4625: from dual;
4626: --
4627: -- Insert an assignment action for the action
4628: insact(lockingactid,assignid,pactid,1,greid);
4629: --
5012: -- rows that we return from the cursor (i.e. one
5013: -- for each assignment/pre-payment).
5014: select pay_assignment_actions_s.nextval
5015: into lockingactid
5016: from dual;
5017: --
5018: -- insert the action record.
5019: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid);
5020: --
5349: end if;
5350: --
5351: select pay_assignment_actions_s.nextval
5352: into l_asg_act_id
5353: from dual;
5354: --
5355: -- insert the action
5356: --
5357: insert into pay_assignment_actions