DBA Data[Home] [Help]

APPS.GMS_LD_PKG dependencies on DUAL

Line 422: from dual;

418: IF (FIRST_RECORD) then
419:
420: select gms_encumbrance_groups_s.nextval
421: into l_encumbrance_grp
422: from dual;
423:
424: l_org_id := TrxRec.org_id;
425: l_exp_ending_date := TrxRec.expenditure_ending_date;
426: l_system_linkage_fn := TrxRec.system_linkage;

Line 464: from dual;

460: --PROC_FUNDS_CHECK_ENC ;
461:
462: select gms_encumbrance_groups_s.nextval
463: into l_encumbrance_grp
464: from dual;
465:
466: l_org_id := TrxRec.org_id;
467: l_exp_ending_date := TrxRec.expenditure_ending_date;
468: l_system_linkage_fn := TrxRec.system_linkage;

Line 1232: from dual;

1228: if l_gen_seq = 'Y' then
1229:
1230: select gms_encumbrances_s.nextval
1231: into l_enc_id
1232: from dual;
1233:
1234: gms_encumbrances_pkg.insert_row (x_rowid => l_rowid,
1235: x_encumbrance_id => l_enc_id,
1236: x_last_update_date => sysdate,

Line 1331: from dual;

1327: END IF; -- Bug 3035863
1328:
1329: select gms_encumbrance_items_s.nextval
1330: into l_enc_item_id
1331: from dual;
1332:
1333: savepoint SAVE_ENC_ADL_REC ;
1334:
1335: /* Modified the following insert call by passing attributes instead of NULL for bug 3646187*/