[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,
2411: -- rows that we return from the cursor (i.e. one
2412: -- for each assignment/pre-payment).
2413: select pay_assignment_actions_s.nextval
2414: into lockingactid
2415: from dual;
2416: --
2417: -- insert the action record.
2418: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid);
2419: --
2761: -- rows that we return from the cursor (i.e. one
2762: -- for each assignment/pre-payment).
2763: select pay_assignment_actions_s.nextval
2764: into lockingactid
2765: from dual;
2766: --
2767: -- insert the action record.
2768: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid);
2769: --
3067: -- insert master actions
3068: if (prev_person_id is null or prev_person_id <> person_id) then
3069: select pay_assignment_actions_s.nextval
3070: into lockingactid
3071: from dual;
3072:
3073: -- insert into pay_assignment_actions.
3074: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3075:
3085: if(prev_assignid is null OR prev_assignid <> assignid) then
3086: -- get a value for the action id that is locking.
3087: select pay_assignment_actions_s.nextval
3088: into lockingactid
3089: from dual;
3090: --
3091: -- insert into pay_assignment_actions.
3092: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3093: end if;
3360: if(prev_assignid is null OR prev_assignid <> assignid) then
3361: -- get a value for the action id that is locking.
3362: select pay_assignment_actions_s.nextval
3363: into lockingactid
3364: from dual;
3365: --
3366: -- insert into pay_assignment_actions.
3367: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3368: end if;
3854: prev_pactid <> lpactid) then
3855: -- get a value for the action id that is locking.
3856: select pay_assignment_actions_s.nextval
3857: into lockingactid
3858: from dual;
3859: --
3860: -- insert into pay_assignment_actions.
3861: insact(lockingactid,assignid,pactid,rand_chunk,greid);
3862: end if;
4056: if(prev_assignid is null OR prev_assignid <> assignid) then
4057: -- get a value for the action id that is locking.
4058: select pay_assignment_actions_s.nextval
4059: into lockingactid
4060: from dual;
4061: --
4062: -- insert into pay_assignment_actions.
4063: insact(lockingactid,assignid,pactid,rand_chunk,greid);
4064: end if;
4161: --
4162: -- Get an assignment_action_id.
4163: select pay_assignment_actions_s.nextval
4164: into asgactid
4165: from dual;
4166: --
4167: if preasgid is null or preasgid <> assignid then
4168: -- Insert an assignment action for each action.
4169: insact(asgactid,assignid,pactid,rand_chunk,null,null);
4475: --
4476: -- Get an assignment_action_id.
4477: select pay_assignment_actions_s.nextval
4478: into lockingactid
4479: from dual;
4480: --
4481: -- Insert an assignment action for each action.
4482: insact(lockingactid,assignid,pactid,rand_chunk,greid,null);
4483: --
4535:
4536: -- Get an assignment_action_id.
4537: select pay_assignment_actions_s.nextval
4538: into lockingactid
4539: from dual;
4540: --
4541: -- Insert an assignment action for each action.
4542: insact(lockingactid,assignid,pactid,rand_chunk,greid,null);
4543: --
4606: --
4607: -- Get an assignment_action_id.
4608: select pay_assignment_actions_s.nextval
4609: into lockingactid
4610: from dual;
4611: --
4612: -- Insert an assignment action for the action
4613: insact(lockingactid,assignid,pactid,1,greid);
4614: --
4997: -- rows that we return from the cursor (i.e. one
4998: -- for each assignment/pre-payment).
4999: select pay_assignment_actions_s.nextval
5000: into lockingactid
5001: from dual;
5002: --
5003: -- insert the action record.
5004: insact(lockingactid,assignid,pactid,rand_chunk,greid,prepayid);
5005: --
5334: end if;
5335: --
5336: select pay_assignment_actions_s.nextval
5337: into l_asg_act_id
5338: from dual;
5339: --
5340: -- insert the action
5341: --
5342: insert into pay_assignment_actions