APPS.ECE_SPSO_TRANS1 dependencies on DUAL

Line 67: FROM sys.dual;

63: xProgress := 'SPSO-10-1005';
64: BEGIN
65: SELECT ece_output_runs_s.NEXTVAL
66: INTO p_run_id
67: FROM sys.dual;
68: EXCEPTION
69: WHEN NO_DATA_FOUND THEN
70: ec_debug.pl ( 0,
71: 'EC',

Line 337: FROM sys.dual;

333: xProgress := 'SSSO-10-1005';
334: BEGIN
335: SELECT ece_output_runs_s.NEXTVAL
336: INTO p_run_id
337: FROM sys.dual;
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: ec_debug.pl ( 0,
341: 'EC',

Line 1231: FROM sys.dual;

1227: xProgress := 'SPSOB-10-1440';
1228: BEGIN
1229: SELECT ece_spso_headers_s.nextval
1230: INTO l_header_fkey
1231: FROM sys.dual;
1232: EXCEPTION
1233: WHEN NO_DATA_FOUND THEN
1234: ec_debug.pl ( 0,
1235: 'EC',

Line 1525: FROM sys.dual;

1521: BEGIN
1522: xProgress := 'SPSOB-10-1550';
1523: SELECT ece_spso_items_s.nextval
1524: INTO l_item_fkey
1525: FROM sys.dual;
1526: EXCEPTION
1527: WHEN NO_DATA_FOUND THEN
1528: ec_debug.pl ( 0,
1529: 'EC',

Line 2104: dual;

2100: ece_spso_item_det_s.currval
2101: into
2102: l_transaction_number
2103: from
2104: dual;
2105: ECE_SPSO_X.populate_extension_item_det(l_transaction_number,
2106: rec_item.schedule_id,
2107: rec_item.schedule_item_id);
2108:

Line 2181: dual;

2177: ece_spso_item_det_s.currval
2178: into
2179: l_transaction_number
2180: from
2181: dual;
2182: ECE_SPSO_X.populate_extension_item_det(l_transaction_number,
2183: rec_item.schedule_id,
2184: rec_item.schedule_item_id);
2185:

Line 2273: dual;

2269: ece_spso_item_det_s.currval
2270: into
2271: l_transaction_number
2272: from
2273: dual;
2274: ECE_SPSO_X.populate_extension_item_det(l_transaction_number,
2275: rec_item.schedule_id,
2276: rec_item.schedule_item_id);
2277:

Line 2333: dual;

2329: ece_spso_item_det_s.currval
2330: into
2331: l_transaction_number
2332: from
2333: dual;
2334: ECE_SPSO_X.populate_extension_item_det(l_transaction_number,
2335: rec_item.schedule_id,
2336: rec_item.schedule_item_id);
2337: