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 1357: FROM DUAL;

1353: 'BLANKET RELEASE' ,'NR',
1354: 'CONTRACT' ,'NC',
1355: 'NR')
1356: INTO l_document_type
1357: FROM DUAL;
1358:
1359: EXCEPTION
1360: WHEN NO_DATA_FOUND THEN
1361: ec_debug.pl(0,

Line 1457: FROM DUAL;

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

Line 1684: FROM DUAL;

1680:
1681: xProgress := 'POOB-10-1590';
1682: BEGIN
1683: SELECT ece_poo_line_s.NEXTVAL INTO l_line_fkey
1684: FROM DUAL;
1685:
1686: EXCEPTION
1687: WHEN NO_DATA_FOUND THEN
1688: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_POO_LINE_S');

Line 1926: FROM DUAL;

1922:
1923: xProgress := 'POOB-10-1670';
1924: BEGIN
1925: SELECT ece_poo_shipment_s.NEXTVAL INTO l_shipment_fkey
1926: FROM DUAL;
1927:
1928: EXCEPTION
1929: WHEN NO_DATA_FOUND THEN
1930: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_POO_SHIPMENT_S');

Line 2883: FROM DUAL;

2879: 'BLANKET RELEASE' ,'NR',
2880: 'CONTRACT' ,'NC',
2881: 'NR')
2882: INTO l_document_type
2883: FROM DUAL;
2884:
2885: EXCEPTION
2886: WHEN NO_DATA_FOUND THEN
2887: ec_debug.pl(0,

Line 3507: FROM DUAL;

3503: 'PLANNED','SCHEDULED',
3504: 'BLANKET','BLANKET'),
3505: po_type)
3506: INTO l_document_type,l_document_subtype
3507: FROM DUAL;
3508:
3509: EXCEPTION
3510: WHEN NO_DATA_FOUND THEN
3511: ec_debug.pl(0,'EC','ECE_DECODE_FAILED','PROGRESS_LEVEL',xProgress,'CODE',document_type);

Line 3784: FROM DUAL;

3780: -- Get Project FKEY
3781: xProgress := 'POOB-40-1220';
3782: BEGIN
3783: SELECT ece_po_project_info_s.NEXTVAL INTO l_project_fkey
3784: FROM DUAL;
3785:
3786: EXCEPTION
3787: WHEN NO_DATA_FOUND THEN
3788: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_PO_PROJECT_INFO_S');

Line 4503: FROM DUAL;

4499:
4500: xProgress := 'POOB-60-1170';
4501: /* BEGIN
4502: SELECT ece_attachment_headers_s.NEXTVAL INTO n_header_fkey
4503: FROM DUAL;
4504:
4505: EXCEPTION
4506: WHEN NO_DATA_FOUND THEN
4507: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_ATTACHMENT_HEADERS_S');

Line 5199: FROM DUAL;

5195: xProgress := 'POOB-70-1620';
5196: ec_debug.pl(3,'xProgress: ',xProgress);
5197:
5198: SELECT ece_attachment_details_s.NEXTVAL INTO n_detail_fkey
5199: FROM DUAL;
5200: if ec_debug.G_debug_level = 3 then
5201: ec_debug.pl(3,'n_detail_fkey: ',n_detail_fkey);
5202: end if;
5203: EXCEPTION