APPS.ECE_POO_TRANSACTION dependencies on DUAL

Line 77: FROM DUAL;

73: xProgress := 'POO-10-1020';
74: BEGIN
75: SELECT ece_output_runs_s.NEXTVAL
76: INTO iRun_id
77: FROM DUAL;
78:
79: EXCEPTION
80: WHEN NO_DATA_FOUND THEN
81: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_OUTPUT_RUNS_S');

Line 1353: FROM DUAL;

1349: 'BLANKET RELEASE' ,'NR',
1350: 'CONTRACT' ,'NC',
1351: 'NR')
1352: INTO l_document_type
1353: FROM DUAL;
1354:
1355: EXCEPTION
1356: WHEN NO_DATA_FOUND THEN
1357: ec_debug.pl(0,

Line 1453: FROM DUAL;

1449: xProgress := 'POOB-10-1480';
1450: BEGIN
1451: SELECT ece_poo_header_s.NEXTVAL
1452: INTO l_header_fkey
1453: FROM DUAL;
1454:
1455: EXCEPTION
1456: WHEN NO_DATA_FOUND THEN
1457: ec_debug.pl(0,

Line 1651: FROM DUAL;

1647:
1648: xProgress := 'POOB-10-1590';
1649: BEGIN
1650: SELECT ece_poo_line_s.NEXTVAL INTO l_line_fkey
1651: FROM DUAL;
1652:
1653: EXCEPTION
1654: WHEN NO_DATA_FOUND THEN
1655: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_POO_LINE_S');

Line 1893: FROM DUAL;

1889:
1890: xProgress := 'POOB-10-1670';
1891: BEGIN
1892: SELECT ece_poo_shipment_s.NEXTVAL INTO l_shipment_fkey
1893: FROM DUAL;
1894:
1895: EXCEPTION
1896: WHEN NO_DATA_FOUND THEN
1897: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_POO_SHIPMENT_S');

Line 2850: FROM DUAL;

2846: 'BLANKET RELEASE' ,'NR',
2847: 'CONTRACT' ,'NC',
2848: 'NR')
2849: INTO l_document_type
2850: FROM DUAL;
2851:
2852: EXCEPTION
2853: WHEN NO_DATA_FOUND THEN
2854: ec_debug.pl(0,

Line 3474: FROM DUAL;

3470: 'PLANNED','SCHEDULED',
3471: 'BLANKET','BLANKET'),
3472: po_type)
3473: INTO l_document_type,l_document_subtype
3474: FROM DUAL;
3475:
3476: EXCEPTION
3477: WHEN NO_DATA_FOUND THEN
3478: ec_debug.pl(0,'EC','ECE_DECODE_FAILED','PROGRESS_LEVEL',xProgress,'CODE',document_type);

Line 3751: FROM DUAL;

3747: -- Get Project FKEY
3748: xProgress := 'POOB-40-1220';
3749: BEGIN
3750: SELECT ece_po_project_info_s.NEXTVAL INTO l_project_fkey
3751: FROM DUAL;
3752:
3753: EXCEPTION
3754: WHEN NO_DATA_FOUND THEN
3755: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_PO_PROJECT_INFO_S');

Line 4470: FROM DUAL;

4466:
4467: xProgress := 'POOB-60-1170';
4468: /* BEGIN
4469: SELECT ece_attachment_headers_s.NEXTVAL INTO n_header_fkey
4470: FROM DUAL;
4471:
4472: EXCEPTION
4473: WHEN NO_DATA_FOUND THEN
4474: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');

Line 5166: FROM DUAL;

5162: xProgress := 'POOB-70-1620';
5163: ec_debug.pl(3,'xProgress: ',xProgress);
5164:
5165: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey
5166: FROM DUAL;
5167: if ec_debug.G_debug_level = 3 then
5168: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5169: end if;
5170: EXCEPTION