[Home] [Help]
1348: object_type,
1349: pactid,
1350: status,
1351: chunk,
1352: pay_assignment_actions_s.nextval,
1353: 1
1354: from dual;
1355: else
1356: insert into pay_assignment_actions (
1372: assignid,
1373: pactid,
1374: status,
1375: chunk,
1376: pay_assignment_actions_s.nextval,
1377: prepayid,
1378: 1,
1379: greid,
1380: source_act,
1662: --
1663: -- want to insert an assignment action for each of the
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.
1865: /* process the insert of assignment actions */
1866: /* logic prevents more than one action per assignment */
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.
2003: /* process the insert of assignment actions */
2004: /* logic prevents more than one action per assignment */
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.
2409: if inasgset then
2410: -- we need to insert one action for each of the
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.
2759: --
2760: -- we need to insert one action for each of the
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.
3065: if (mult_asg_flag = 'Y')
3066: then
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.
3083: /* process the insert of assignment actions */
3084: /* logic prevents more than one action per assignment */
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.
3358: /* process the insert of assignment actions */
3359: /* logic prevents more than one action per assignment */
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.
3852: /* logic prevents more than one action per assignment */
3853: if(prev_assignid is null OR prev_assignid <> assignid OR
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.
4054: /* process the insert of assignment actions */
4055: /* logic prevents more than one action per assignment */
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.
4159: exit when beecur%notfound;
4160: 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
4473: exit when costedacts%notfound;
4474: --
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.
4533:
4534: if (not_paid = 0) then
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.
4604: end if;
4605: close qpcur ;
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
4995: --
4996: -- we need to insert one action for each of the
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.
5332: end if;
5333: --
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