APPS.ECE_POCO_TRANSACTION dependencies on DUAL

Line 73: FROM DUAL;

69: xProgress := 'POCO-10-1004';
70: BEGIN
71: SELECT ece_output_runs_s.NEXTVAL
72: INTO iRun_id
73: FROM DUAL;
74:
75: EXCEPTION
76: WHEN NO_DATA_FOUND THEN
77: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_OUTPUT_RUNS_S');

Line 1314: FROM DUAL;

1310: 'BLANKET RELEASE' ,'NR',
1311: 'CONTRACT' ,'NC',
1312: 'NR')
1313: INTO l_document_type
1314: FROM DUAL;
1315:
1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: ec_debug.pl(0,

Line 1411: FROM DUAL;

1407: xProgress := 'POCOB-10-1480';
1408: BEGIN
1409: SELECT ece_poco_header_s.NEXTVAL
1410: INTO l_header_fkey
1411: FROM DUAL;
1412:
1413: EXCEPTION
1414: WHEN NO_DATA_FOUND THEN
1415: ec_debug.pl(0,

Line 1602: FROM DUAL;

1598:
1599: xProgress := 'POCOB-10-1590';
1600: BEGIN
1601: SELECT ece_poco_line_s.NEXTVAL INTO l_line_fkey
1602: FROM DUAL;
1603:
1604: EXCEPTION
1605: WHEN NO_DATA_FOUND THEN
1606: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_POCO_LINE_S');

Line 1911: FROM DUAL;

1907:
1908: xProgress := 'POCOB-10-1670';
1909: BEGIN
1910: SELECT ece_poco_shipment_s.NEXTVAL INTO l_shipment_fkey
1911: FROM DUAL;
1912:
1913: EXCEPTION
1914: WHEN NO_DATA_FOUND THEN
1915: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_POCO_SHIPMENT_S');

Line 2824: FROM DUAL;

2820: 'BLANKET RELEASE' ,'NR',
2821: 'CONTRACT' ,'NC',
2822: 'NR')
2823: INTO l_document_type
2824: FROM DUAL;
2825:
2826: EXCEPTION
2827: WHEN NO_DATA_FOUND THEN
2828: ec_debug.pl(0,