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_INTERFACE

Line 307: FROM po_headers_interface PHI

303: CURSOR c_interface_headers IS
304: SELECT PHI.interface_header_id,
305: PHI.process_code,
306: PHI.request_id
307: FROM po_headers_interface PHI
308: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
309: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
310: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
311: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id

Line 366: UPDATE po_headers_interface PHI

362: -- If batch id is specified, update the records that match the batch id but
363: -- do not have org_id specified.
364: IF (PO_PDOI_PARAMS.g_request.batch_id IS NOT NULL) THEN
365:
366: UPDATE po_headers_interface PHI
367: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
368: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
369: AND PHI.org_id IS NULL;
370:

Line 402: UPDATE po_headers_interface

398:
399: d_position := 30;
400: -- Header level assignment
401: FORALL i IN 1..l_intf_header_id_tbl.COUNT
402: UPDATE po_headers_interface
403: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
404: process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS,
405: processing_round_num = NULL, -- reset processing number
406: request_id = FND_GLOBAL.conc_request_id,

Line 654: FROM po_headers_interface

650: -- Check action code
651: SELECT interface_header_id, action
652: BULK COLLECT
653: INTO l_reject_tbl, l_action_tbl
654: FROM po_headers_interface
655: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
656: AND (action IS NULL
657: OR
658: (PO_PDOI_PARAMS.g_request.document_type IN

Line 692: p_table_name => 'PO_HEADERS_INTERFACE',

688: d_position := 20;
689: PO_PDOI_ERR_UTL.add_fatal_error
690: ( p_interface_header_id => l_reject_tbl(i),
691: p_error_message_name => l_message_name,
692: p_table_name => 'PO_HEADERS_INTERFACE',
693: p_column_name => 'ACTION',
694: p_column_value => l_action_tbl(i),
695: p_token1_name => 'VALUE',
696: p_token1_value => l_action_tbl(i));

Line 768: FROM po_headers_interface PHI

764: INTO l_intf_header_id_tbl,
765: l_vendor_name_tbl,
766: l_vendor_num_tbl,
767: l_vendor_id_tbl
768: FROM po_headers_interface PHI
769: WHERE vendor_id IS NULL
770: AND po_header_id IS NULL -- if po_header_id is already provided,
771: -- skip vendor_id derivation as it is
772: -- not needed

Line 793: UPDATE po_headers_interface

789:
790: d_position := 20;
791: -- Update vendor_id to headers interface
792: FORALL i IN 1..l_intf_header_id_tbl.COUNT
793: UPDATE po_headers_interface
794: SET vendor_id = l_vendor_id_tbl(i)
795: WHERE interface_header_id = l_intf_header_id_tbl(i)
796: AND l_vendor_id_tbl(i) IS NOT NULL;
797:

Line 813: p_table_name => 'PO_HEADERS_INTERFACE',

809:
810: PO_PDOI_ERR_UTL.add_fatal_error
811: ( p_interface_header_id => l_intf_header_id_tbl(i),
812: p_error_message_name => 'PO_PDOI_DERV_ERROR',
813: p_table_name => 'PO_HEADERS_INTERFACE',
814: p_column_name => 'VENDOR_ID',
815: p_column_value => l_vendor_id_tbl(i),
816: p_token1_name => 'COLUMN_NAME',
817: p_token1_value => l_column_name,

Line 906: FROM po_headers_interface

902: expiration_date,
903: vendor_doc_num
904: BULK COLLECT INTO l_interface_header_id_tbl, l_vendor_id_tbl,
905: l_start_date_tbl, l_end_date_tbl, l_vendor_doc_num_tbl
906: FROM po_headers_interface
907: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
908: AND action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE;
909:
910: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN

Line 930: p_table_name => 'PO_HEADERS_INTERFACE',

926: d_position := 30;
927: PO_PDOI_ERR_UTL.add_fatal_error
928: ( p_interface_header_id => l_interface_header_id_tbl(i),
929: p_error_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
930: p_table_name => 'PO_HEADERS_INTERFACE',
931: p_column_name => 'START_DATE',
932: p_column_value => l_start_date_tbl(i),
933: p_token1_name => 'COLUMN_NAME',
934: p_token1_value => 'START_DATE'

Line 946: p_table_name => 'PO_HEADERS_INTERFACE',

942: IF (TRUNC(l_start_date_tbl(i)) > TRUNC(NVL(l_end_date_tbl(i), l_start_date_tbl(i)))) THEN
943: PO_PDOI_ERR_UTL.add_fatal_error
944: ( p_interface_header_id => l_interface_header_id_tbl(i),
945: p_error_message_name => 'PO_PDOI_INVALID_START_DATE',
946: p_table_name => 'PO_HEADERS_INTERFACE',
947: p_column_name => 'START_DATE',
948: p_column_value => l_start_date_tbl(i),
949: p_token1_name => 'VALUE',
950: p_token1_value => l_start_date_tbl(i)

Line 1043: p_table_name => 'PO_HEADERS_INTERFACE',

1039: IF (l_error_message_name IS NOT NULL) THEN
1040: PO_PDOI_ERR_UTL.add_fatal_error
1041: ( p_interface_header_id => l_interface_header_id_tbl(i),
1042: p_error_message_name => l_error_message_name,
1043: p_table_name => 'PO_HEADERS_INTERFACE',
1044: p_column_name => 'VENDOR_DOC_NUM',
1045: p_column_value => l_vendor_doc_num_tbl(i),
1046: p_token1_name => 'DOC_NUMBER',
1047: p_token1_value => l_vendor_doc_num_tbl(i)

Line 1105: UPDATE po_headers_interface

1101: d_position := 150;
1102:
1103: -- Set original header id
1104: FORALL i IN 1..l_final_orig_header_id_tbl.COUNT
1105: UPDATE po_headers_interface
1106: SET original_po_header_id = l_final_orig_header_id_tbl(i)
1107: WHERE interface_header_id = l_final_intf_header_id_tbl(i);
1108:
1109: d_position := 160;

Line 1195: p_table_name => 'PO_HEADERS_INTERFACE',

1191: IF (l_rel_exists = 'Y') THEN
1192: PO_PDOI_ERR_UTL.add_fatal_error
1193: ( p_interface_header_id => p_interface_header_id,
1194: p_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
1195: p_table_name => 'PO_HEADERS_INTERFACE',
1196: p_column_name => 'EFFECTIVE_DATE',
1197: p_column_value => p_new_doc_start_date
1198: );
1199:

Line 1218: p_table_name => 'PO_HEADERS_INTERFACE',

1214: IF (l_rel_exists = 'Y') THEN
1215: PO_PDOI_ERR_UTL.add_fatal_error
1216: ( p_interface_header_id => p_interface_header_id,
1217: p_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
1218: p_table_name => 'PO_HEADERS_INTERFACE',
1219: p_column_name => 'EFFECTIVE_DATE',
1220: p_column_value => p_new_doc_start_date
1221: );
1222:

Line 1318: FROM po_headers_interface

1314: l_end_date_tbl,
1315: l_po_header_id_tbl,
1316: l_vendor_doc_num_tbl,
1317: l_document_num_tbl
1318: FROM po_headers_interface
1319: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1320: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
1321:
1322: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN

Line 1430: p_table_name => 'PO_HEADERS_INTERFACE',

1426:
1427: PO_PDOI_ERR_UTL.add_fatal_error
1428: ( p_interface_header_id => l_interface_header_id_tbl(i),
1429: p_error_message_name => l_message_name,
1430: p_table_name => 'PO_HEADERS_INTERFACE',
1431: p_column_name => 'PO_HEADER_ID',
1432: p_column_value => l_po_header_id_tbl(i),
1433: p_token1_name => 'DOC_NUMBER',
1434: p_token1_value => l_doc_num_for_msg_dsp

Line 1596: p_table_name => 'PO_HEADERS_INTERFACE',

1592:
1593: PO_PDOI_ERR_UTL.add_fatal_error
1594: ( p_interface_header_id => l_interface_header_id_tbl(i),
1595: p_error_message_name => l_message_name,
1596: p_table_name => 'PO_HEADERS_INTERFACE',
1597: p_column_name => l_col_name,
1598: p_column_value => l_col_value,
1599: p_token1_name => l_token_name,
1600: p_token1_value => l_token_value

Line 1648: p_table_name => 'PO_HEADERS_INTERFACE',

1644: d_position := 160;
1645: PO_PDOI_ERR_UTL.add_fatal_error
1646: ( p_interface_header_id => l_interface_header_id_tbl(i),
1647: p_error_message_name => l_message_name,
1648: p_table_name => 'PO_HEADERS_INTERFACE',
1649: p_column_name => l_col_name,
1650: p_column_value => l_col_value,
1651: p_token1_name => l_token_name,
1652: p_token1_value => l_token_value

Line 1681: UPDATE po_headers_interface

1677:
1678: d_position := 180;
1679: -- Set po header id (document to update)
1680: FORALL i IN 1..l_final_intf_header_id_tbl.COUNT
1681: UPDATE po_headers_interface
1682: SET po_header_id = l_final_po_header_id_tbl(i)
1683: WHERE interface_header_id = l_final_intf_header_id_tbl(i);
1684:
1685: d_position := 190;

Line 1748: po_headers_interface PHI

1744: INTO l_po_header_id_tbl,
1745: l_reject_list,
1746: l_vendor_doc_num_tbl
1747: FROM po_headers POH,
1748: po_headers_interface PHI
1749: WHERE POH.vendor_id = PHI.vendor_id
1750: AND POH.quote_vendor_quote_number = PHI.vendor_doc_Num
1751: AND TRUNC (NVL(PHI.effective_date, SYSDATE)) >=
1752: TRUNC (NVL(POH.start_date, SYSDATE))

Line 1772: po_headers_interface PHI

1768: INTO l_po_header_id_tbl,
1769: l_reject_list,
1770: l_vendor_doc_num_tbl
1771: FROM po_headers POH,
1772: po_headers_interface PHI
1773: WHERE POH.vendor_id = PHI.vendor_id
1774: AND POH.vendor_order_num = PHI.vendor_doc_Num
1775: AND TRUNC (NVL(PHI.effective_date, SYSDATE)) >=
1776: TRUNC (NVL(POH.start_date, SYSDATE))

Line 1793: p_table_name => 'PO_HEADERS_INTERFACE',

1789: FOR i IN 1..l_reject_list.COUNT LOOP
1790: PO_PDOI_ERR_UTL.add_fatal_error
1791: ( p_interface_header_id => l_reject_list(i),
1792: p_error_message_name => 'PO_PDOI_CATG_ALREADY_EXISTS',
1793: p_table_name => 'PO_HEADERS_INTERFACE',
1794: p_column_name => 'VENDOR_DOC_NUM',
1795: p_column_value => l_vendor_doc_num_tbl(i),
1796: p_token1_name => 'DOC_NUMBER',
1797: p_token1_value => l_vendor_doc_num_tbl(i)

Line 1853: UPDATE po_headers_interface

1849: END IF;
1850:
1851: -- For ORIGINAL, ADD or REPLACE action, new document will be created
1852: -- Need to assign a new po_header_id
1853: UPDATE po_headers_interface
1854: SET po_header_id = PO_HEADERS_S.nextval
1855: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1856: AND po_header_id IS NULL
1857: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,