eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_PREPROC_PVT dependencies on PO_HEADERS

Line 355: FROM po_headers_interface PHI

351: CURSOR c_interface_headers IS
352: SELECT PHI.interface_header_id,
353: PHI.process_code,
354: PHI.request_id
355: FROM po_headers_interface PHI
356: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
357: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
358: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
359: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id

Line 414: UPDATE po_headers_interface PHI

410: -- If batch id is specified, update the records that match the batch id but
411: -- do not have org_id specified.
412: IF (PO_PDOI_PARAMS.g_request.batch_id IS NOT NULL) THEN
413:
414: UPDATE po_headers_interface PHI
415: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
416: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
417: AND PHI.org_id IS NULL;
418:

Line 450: UPDATE po_headers_interface

446:
447: d_position := 30;
448: -- Header level assignment
449: FORALL i IN 1..l_intf_header_id_tbl.COUNT
450: UPDATE po_headers_interface
451: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
452: process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS,
453: processing_round_num = NULL, -- reset processing number
454: request_id = FND_GLOBAL.conc_request_id,

Line 702: FROM po_headers_interface

698: -- Check action code
699: SELECT interface_header_id, action
700: BULK COLLECT
701: INTO l_reject_tbl, l_action_tbl
702: FROM po_headers_interface
703: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
704: AND (action IS NULL
705: OR
706: (PO_PDOI_PARAMS.g_request.document_type IN

Line 740: p_table_name => 'PO_HEADERS_INTERFACE',

736: d_position := 20;
737: PO_PDOI_ERR_UTL.add_fatal_error
738: ( p_interface_header_id => l_reject_tbl(i),
739: p_error_message_name => l_message_name,
740: p_table_name => 'PO_HEADERS_INTERFACE',
741: p_column_name => 'ACTION',
742: p_column_value => l_action_tbl(i),
743: p_token1_name => 'VALUE',
744: p_token1_value => l_action_tbl(i));

Line 826: FROM po_headers_interface PHI

822: l_vendor_id_tbl,
823: l_clm_source_document_disp_tbl,
824: l_clm_source_document_id_tbl,
825: l_doc_type_tbl
826: FROM po_headers_interface PHI
827: WHERE vendor_id IS NULL
828: AND po_header_id IS NULL -- if po_header_id is already provided,
829: -- skip vendor_id derivation as it is
830: -- not needed

Line 874: UPDATE po_headers_interface

870:
871: d_position := 20;
872: -- Update vendor_id to headers interface
873: FORALL i IN 1..l_intf_header_id_tbl.COUNT
874: UPDATE po_headers_interface
875: SET vendor_id = l_vendor_id_tbl(i)
876: WHERE interface_header_id = l_intf_header_id_tbl(i)
877: AND l_vendor_id_tbl(i) IS NOT NULL;
878:

Line 894: p_table_name => 'PO_HEADERS_INTERFACE',

890:
891: PO_PDOI_ERR_UTL.add_fatal_error
892: ( p_interface_header_id => l_intf_header_id_tbl(i),
893: p_error_message_name => 'PO_PDOI_DERV_ERROR',
894: p_table_name => 'PO_HEADERS_INTERFACE',
895: p_column_name => 'VENDOR_ID',
896: p_column_value => l_vendor_id_tbl(i),
897: p_token1_name => 'COLUMN_NAME',
898: p_token1_value => l_column_name,

Line 987: FROM po_headers_interface

983: expiration_date,
984: vendor_doc_num
985: BULK COLLECT INTO l_interface_header_id_tbl, l_vendor_id_tbl,
986: l_start_date_tbl, l_end_date_tbl, l_vendor_doc_num_tbl
987: FROM po_headers_interface
988: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
989: AND action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE;
990:
991: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN

Line 1011: p_table_name => 'PO_HEADERS_INTERFACE',

1007: d_position := 30;
1008: PO_PDOI_ERR_UTL.add_fatal_error
1009: ( p_interface_header_id => l_interface_header_id_tbl(i),
1010: p_error_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
1011: p_table_name => 'PO_HEADERS_INTERFACE',
1012: p_column_name => 'START_DATE',
1013: p_column_value => l_start_date_tbl(i),
1014: p_token1_name => 'COLUMN_NAME',
1015: p_token1_value => 'START_DATE'

Line 1027: p_table_name => 'PO_HEADERS_INTERFACE',

1023: IF (TRUNC(l_start_date_tbl(i)) > TRUNC(NVL(l_end_date_tbl(i), l_start_date_tbl(i)))) THEN
1024: PO_PDOI_ERR_UTL.add_fatal_error
1025: ( p_interface_header_id => l_interface_header_id_tbl(i),
1026: p_error_message_name => 'PO_PDOI_INVALID_START_DATE',
1027: p_table_name => 'PO_HEADERS_INTERFACE',
1028: p_column_name => 'START_DATE',
1029: p_column_value => l_start_date_tbl(i),
1030: p_token1_name => 'VALUE',
1031: p_token1_value => l_start_date_tbl(i)

Line 1056: FROM po_headers POH

1052: INTO l_orig_po_header_id_tbl,
1053: l_orig_closed_code_tbl,
1054: l_orig_cancel_flag_tbl,
1055: l_orig_ga_tbl
1056: FROM po_headers POH
1057: WHERE vendor_id = l_vendor_id_tbl(i)
1058: AND quote_vendor_quote_number = l_vendor_doc_num_tbl(i)
1059: AND TRUNC(l_start_date_tbl(i)) >= TRUNC(NVL(start_date, SYSDATE))
1060: AND TRUNC(NVL(l_end_date_tbl(i), SYSDATE)) <= TRUNC(NVL(end_date, SYSDATE));

Line 1076: FROM po_headers POH

1072: INTO l_orig_po_header_id_tbl,
1073: l_orig_closed_code_tbl,
1074: l_orig_cancel_flag_tbl,
1075: l_orig_ga_tbl
1076: FROM po_headers POH
1077: WHERE vendor_id = l_vendor_id_tbl(i)
1078: AND vendor_order_num = l_vendor_doc_num_tbl(i)
1079: AND TRUNC(l_start_date_tbl(i)) >= TRUNC(NVL(start_date, SYSDATE));
1080: -- for issue 14458735

Line 1125: p_table_name => 'PO_HEADERS_INTERFACE',

1121: IF (l_error_message_name IS NOT NULL) THEN
1122: PO_PDOI_ERR_UTL.add_fatal_error
1123: ( p_interface_header_id => l_interface_header_id_tbl(i),
1124: p_error_message_name => l_error_message_name,
1125: p_table_name => 'PO_HEADERS_INTERFACE',
1126: p_column_name => 'VENDOR_DOC_NUM',
1127: p_column_value => l_vendor_doc_num_tbl(i),
1128: p_token1_name => 'DOC_NUMBER',
1129: p_token1_value => l_vendor_doc_num_tbl(i)

Line 1187: UPDATE po_headers_interface

1183: d_position := 150;
1184:
1185: -- Set original header id
1186: FORALL i IN 1..l_final_orig_header_id_tbl.COUNT
1187: UPDATE po_headers_interface
1188: SET original_po_header_id = l_final_orig_header_id_tbl(i)
1189: WHERE interface_header_id = l_final_intf_header_id_tbl(i);
1190:
1191: d_position := 160;

Line 1266: po_headers_all POH

1262: INTO l_rel_exists
1263: FROM DUAL
1264: WHERE EXISTS (SELECT 'Exists std PO ref the orig GA'
1265: FROM po_lines_all POL,
1266: po_headers_all POH
1267: WHERE POL.from_header_id = p_po_header_id
1268: AND POL.po_header_id = POH.po_header_id
1269: AND POH.creation_date >= l_exp_date);
1270:

Line 1277: p_table_name => 'PO_HEADERS_INTERFACE',

1273: IF (l_rel_exists = 'Y') THEN
1274: PO_PDOI_ERR_UTL.add_fatal_error
1275: ( p_interface_header_id => p_interface_header_id,
1276: p_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
1277: p_table_name => 'PO_HEADERS_INTERFACE',
1278: p_column_name => 'EFFECTIVE_DATE',
1279: p_column_value => p_new_doc_start_date
1280: );
1281:

Line 1300: p_table_name => 'PO_HEADERS_INTERFACE',

1296: IF (l_rel_exists = 'Y') THEN
1297: PO_PDOI_ERR_UTL.add_fatal_error
1298: ( p_interface_header_id => p_interface_header_id,
1299: p_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
1300: p_table_name => 'PO_HEADERS_INTERFACE',
1301: p_column_name => 'EFFECTIVE_DATE',
1302: p_column_value => p_new_doc_start_date
1303: );
1304:

Line 1362: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;

1358: l_col_name PO_INTERFACE_ERRORS.column_name%TYPE;
1359: l_col_value PO_INTERFACE_ERRORS.column_value%TYPE;
1360: l_token_name VARCHAR2(100);
1361: l_token_value VARCHAR2(100);
1362: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;
1363:
1364: l_skip_cat_upload_chk VARCHAR2(1);
1365:
1366: l_status_rec PO_STATUS_REC_TYPE;

Line 1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;

1368:
1369: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1370: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1371:
1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1373:
1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1375: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1376:

Line 1400: FROM po_headers_interface

1396: l_end_date_tbl,
1397: l_po_header_id_tbl,
1398: l_vendor_doc_num_tbl,
1399: l_document_num_tbl
1400: FROM po_headers_interface
1401: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1402: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
1403:
1404: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN

Line 1438: FROM po_headers POH

1434: SELECT DECODE(MAX(POH.po_header_id), NULL, 'N', 'Y'),
1435: NVL(MAX(POH.consigned_consumption_flag), 'N')
1436: INTO l_existing_header,
1437: l_consigned_consumption_flag
1438: FROM po_headers POH
1439: WHERE POH.po_header_id = l_po_header_id_tbl(i)
1440: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type;
1441:
1442: IF (l_existing_header = 'N' OR l_consigned_consumption_flag = 'Y') THEN

Line 1506: FROM po_headers_all

1502: -- po_header_id, we attempt to derive document number
1503: -- from po_header_id
1504: SELECT NVL(MIN(segment1), 'UNKNOWN')
1505: INTO l_doc_num_for_msg_dsp
1506: FROM po_headers_all
1507: WHERE po_header_id = l_po_header_id_tbl(i);
1508:
1509: PO_PDOI_ERR_UTL.add_fatal_error
1510: ( p_interface_header_id => l_interface_header_id_tbl(i),

Line 1512: p_table_name => 'PO_HEADERS_INTERFACE',

1508:
1509: PO_PDOI_ERR_UTL.add_fatal_error
1510: ( p_interface_header_id => l_interface_header_id_tbl(i),
1511: p_error_message_name => l_message_name,
1512: p_table_name => 'PO_HEADERS_INTERFACE',
1513: p_column_name => 'PO_HEADER_ID',
1514: p_column_value => l_po_header_id_tbl(i),
1515: p_token1_name => 'DOC_NUMBER',
1516: p_token1_value => l_doc_num_for_msg_dsp

Line 1546: FROM po_headers POH

1542: NVL(POH.consigned_consumption_flag, 'N')
1543: BULK COLLECT
1544: INTO l_orig_po_header_id_tbl,
1545: l_orig_consumption_flag_tbl
1546: FROM po_headers POH
1547: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1548: AND POH.vendor_order_num = l_vendor_doc_num_tbl(i)
1549: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1550: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

Line 1569: FROM po_headers POH

1565: NVL(POH.consigned_consumption_flag, 'N')
1566: BULK COLLECT
1567: INTO l_orig_po_header_id_tbl,
1568: l_orig_consumption_flag_tbl
1569: FROM po_headers POH
1570: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1571: AND POH.quote_vendor_quote_number = l_vendor_doc_num_tbl(i)
1572: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1573: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

Line 1598: FROM po_headers POH

1594: NVL(POH.consigned_consumption_flag, 'N')
1595: BULK COLLECT
1596: INTO l_orig_po_header_id_tbl,
1597: l_orig_consumption_flag_tbl
1598: FROM po_headers POH
1599: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1600: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1601: NVL(l_vendor_doc_num_tbl(i),
1602: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))

Line 1623: FROM po_headers POH

1619: NVL(POH.consigned_consumption_flag, 'N')
1620: BULK COLLECT
1621: INTO l_orig_po_header_id_tbl,
1622: l_orig_consumption_flag_tbl
1623: FROM po_headers POH
1624: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1625: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1626: NVL(l_vendor_doc_num_tbl(i),
1627: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))

Line 1678: p_table_name => 'PO_HEADERS_INTERFACE',

1674:
1675: PO_PDOI_ERR_UTL.add_fatal_error
1676: ( p_interface_header_id => l_interface_header_id_tbl(i),
1677: p_error_message_name => l_message_name,
1678: p_table_name => 'PO_HEADERS_INTERFACE',
1679: p_column_name => l_col_name,
1680: p_column_value => l_col_value,
1681: p_token1_name => l_token_name,
1682: p_token1_value => l_token_value

Line 1730: p_table_name => 'PO_HEADERS_INTERFACE',

1726: d_position := 160;
1727: PO_PDOI_ERR_UTL.add_fatal_error
1728: ( p_interface_header_id => l_interface_header_id_tbl(i),
1729: p_error_message_name => l_message_name,
1730: p_table_name => 'PO_HEADERS_INTERFACE',
1731: p_column_name => l_col_name,
1732: p_column_value => l_col_value,
1733: p_token1_name => l_token_name,
1734: p_token1_value => l_token_value

Line 1763: UPDATE po_headers_interface

1759:
1760: d_position := 180;
1761: -- Set po header id (document to update)
1762: FORALL i IN 1..l_final_intf_header_id_tbl.COUNT
1763: UPDATE po_headers_interface
1764: SET po_header_id = l_final_po_header_id_tbl(i)
1765: WHERE interface_header_id = l_final_intf_header_id_tbl(i);
1766:
1767: d_position := 190;

Line 1829: FROM po_headers POH,

1825: BULK COLLECT
1826: INTO l_po_header_id_tbl,
1827: l_reject_list,
1828: l_vendor_doc_num_tbl
1829: FROM po_headers POH,
1830: po_headers_interface PHI
1831: WHERE POH.vendor_id = PHI.vendor_id
1832: AND POH.quote_vendor_quote_number = PHI.vendor_doc_Num
1833: AND TRUNC (NVL(PHI.effective_date, SYSDATE)) >=

Line 1830: po_headers_interface PHI

1826: INTO l_po_header_id_tbl,
1827: l_reject_list,
1828: l_vendor_doc_num_tbl
1829: FROM po_headers POH,
1830: po_headers_interface PHI
1831: WHERE POH.vendor_id = PHI.vendor_id
1832: AND POH.quote_vendor_quote_number = PHI.vendor_doc_Num
1833: AND TRUNC (NVL(PHI.effective_date, SYSDATE)) >=
1834: TRUNC (NVL(POH.start_date, SYSDATE))

Line 1853: FROM po_headers POH,

1849: BULK COLLECT
1850: INTO l_po_header_id_tbl,
1851: l_reject_list,
1852: l_vendor_doc_num_tbl
1853: FROM po_headers POH,
1854: po_headers_interface PHI
1855: WHERE POH.vendor_id = PHI.vendor_id
1856: AND POH.vendor_order_num = PHI.vendor_doc_Num
1857: AND TRUNC (NVL(PHI.effective_date, SYSDATE)) >=

Line 1854: po_headers_interface PHI

1850: INTO l_po_header_id_tbl,
1851: l_reject_list,
1852: l_vendor_doc_num_tbl
1853: FROM po_headers POH,
1854: po_headers_interface PHI
1855: WHERE POH.vendor_id = PHI.vendor_id
1856: AND POH.vendor_order_num = PHI.vendor_doc_Num
1857: AND TRUNC (NVL(PHI.effective_date, SYSDATE)) >=
1858: TRUNC (NVL(POH.start_date, SYSDATE))

Line 1875: p_table_name => 'PO_HEADERS_INTERFACE',

1871: FOR i IN 1..l_reject_list.COUNT LOOP
1872: PO_PDOI_ERR_UTL.add_fatal_error
1873: ( p_interface_header_id => l_reject_list(i),
1874: p_error_message_name => 'PO_PDOI_CATG_ALREADY_EXISTS',
1875: p_table_name => 'PO_HEADERS_INTERFACE',
1876: p_column_name => 'VENDOR_DOC_NUM',
1877: p_column_value => l_vendor_doc_num_tbl(i),
1878: p_token1_name => 'DOC_NUMBER',
1879: p_token1_value => l_vendor_doc_num_tbl(i)

Line 1935: UPDATE po_headers_interface

1931: END IF;
1932:
1933: -- For ORIGINAL, ADD or REPLACE action, new document will be created
1934: -- Need to assign a new po_header_id
1935: UPDATE po_headers_interface
1936: SET po_header_id = PO_HEADERS_S.nextval
1937: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1938: AND po_header_id IS NULL
1939: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 1936: SET po_header_id = PO_HEADERS_S.nextval

1932:
1933: -- For ORIGINAL, ADD or REPLACE action, new document will be created
1934: -- Need to assign a new po_header_id
1935: UPDATE po_headers_interface
1936: SET po_header_id = PO_HEADERS_S.nextval
1937: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1938: AND po_header_id IS NULL
1939: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1940: PO_PDOI_CONSTANTS.g_ACTION_ADD,

Line 2202: (SELECT PH.style_id FROM po_headers_all PH

2198:
2199: /* PDOI for Complex PO Project: Logic for creating Pay items: Start */
2200: BEGIN
2201: SELECT Nvl(DECODE(PHI.po_header_id,NULL,PHI.style_id,
2202: (SELECT PH.style_id FROM po_headers_all PH
2203: WHERE PH.po_header_id = PHI.po_header_id)),1),
2204: -- In 'UPDATE' mode, the style_id corresponding to the base PO
2205: -- needs to be considered.
2206: PLI.interface_line_id,

Line 2209: FROM po_headers_interface PHI,

2205: -- needs to be considered.
2206: PLI.interface_line_id,
2207: po_line_locations_interface_s.currval
2208: INTO l_style_id, l_interface_line_id, l_interface_line_location_id
2209: FROM po_headers_interface PHI,
2210: po_lines_interface PLI
2211: WHERE PLI.rowid = l_rowid_tbl(i)
2212: AND PLI.interface_header_id = PHI.interface_header_id;
2213: EXCEPTION

Line 3165: FROM po_lines_interface PLI,po_headers_interface phi

3161: l_intf_line_id_tbl,
3162: l_line_num_disp_tbl,
3163: l_clm_info_flag_tbl,
3164: l_po_header_id_tbl
3165: FROM po_lines_interface PLI,po_headers_interface phi
3166: WHERE PLI.processing_id = PO_PDOI_PARAMS.g_processing_id
3167: AND PLI.interface_header_id = phi.interface_header_id
3168: ORDER BY PLI.interface_header_id, PLI.line_num_display;
3169: