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 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 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 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 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 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 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 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 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 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: