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 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 975: FROM po_headers POH

971: INTO l_orig_po_header_id_tbl,
972: l_orig_closed_code_tbl,
973: l_orig_cancel_flag_tbl,
974: l_orig_ga_tbl
975: FROM po_headers POH
976: WHERE vendor_id = l_vendor_id_tbl(i)
977: AND quote_vendor_quote_number = l_vendor_doc_num_tbl(i)
978: AND TRUNC(l_start_date_tbl(i)) >= TRUNC(NVL(start_date, SYSDATE))
979: AND TRUNC(NVL(l_end_date_tbl(i), SYSDATE)) <= TRUNC(NVL(end_date, SYSDATE));

Line 995: FROM po_headers POH

991: INTO l_orig_po_header_id_tbl,
992: l_orig_closed_code_tbl,
993: l_orig_cancel_flag_tbl,
994: l_orig_ga_tbl
995: FROM po_headers POH
996: WHERE vendor_id = l_vendor_id_tbl(i)
997: AND vendor_order_num = l_vendor_doc_num_tbl(i)
998: AND TRUNC(l_start_date_tbl(i)) >= TRUNC(NVL(start_date, SYSDATE))
999: AND TRUNC(NVL(l_end_date_tbl(i), SYSDATE)) <= TRUNC(NVL(end_date, SYSDATE));

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 1184: po_headers_all POH

1180: INTO l_rel_exists
1181: FROM DUAL
1182: WHERE EXISTS (SELECT 'Exists std PO ref the orig GA'
1183: FROM po_lines_all POL,
1184: po_headers_all POH
1185: WHERE POL.from_header_id = p_po_header_id
1186: AND POL.po_header_id = POH.po_header_id
1187: AND POH.creation_date >= l_exp_date);
1188:

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 1280: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;

1276: l_col_name PO_INTERFACE_ERRORS.column_name%TYPE;
1277: l_col_value PO_INTERFACE_ERRORS.column_value%TYPE;
1278: l_token_name VARCHAR2(100);
1279: l_token_value VARCHAR2(100);
1280: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;
1281:
1282: l_skip_cat_upload_chk VARCHAR2(1);
1283:
1284: l_status_rec PO_STATUS_REC_TYPE;

Line 1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;

1286:
1287: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1288: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1289:
1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1291:
1292: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1293: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1294:

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 1356: FROM po_headers POH

1352: SELECT DECODE(MAX(POH.po_header_id), NULL, 'N', 'Y'),
1353: NVL(MAX(POH.consigned_consumption_flag), 'N')
1354: INTO l_existing_header,
1355: l_consigned_consumption_flag
1356: FROM po_headers POH
1357: WHERE POH.po_header_id = l_po_header_id_tbl(i)
1358: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type;
1359:
1360: IF (l_existing_header = 'N' OR l_consigned_consumption_flag = 'Y') THEN

Line 1424: FROM po_headers_all

1420: -- po_header_id, we attempt to derive document number
1421: -- from po_header_id
1422: SELECT NVL(MIN(segment1), 'UNKNOWN')
1423: INTO l_doc_num_for_msg_dsp
1424: FROM po_headers_all
1425: WHERE po_header_id = l_po_header_id_tbl(i);
1426:
1427: PO_PDOI_ERR_UTL.add_fatal_error
1428: ( p_interface_header_id => l_interface_header_id_tbl(i),

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 1464: FROM po_headers POH

1460: NVL(POH.consigned_consumption_flag, 'N')
1461: BULK COLLECT
1462: INTO l_orig_po_header_id_tbl,
1463: l_orig_consumption_flag_tbl
1464: FROM po_headers POH
1465: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1466: AND POH.vendor_order_num = l_vendor_doc_num_tbl(i)
1467: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1468: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

Line 1487: FROM po_headers POH

1483: NVL(POH.consigned_consumption_flag, 'N')
1484: BULK COLLECT
1485: INTO l_orig_po_header_id_tbl,
1486: l_orig_consumption_flag_tbl
1487: FROM po_headers POH
1488: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1489: AND POH.quote_vendor_quote_number = l_vendor_doc_num_tbl(i)
1490: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1491: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

Line 1516: FROM po_headers POH

1512: NVL(POH.consigned_consumption_flag, 'N')
1513: BULK COLLECT
1514: INTO l_orig_po_header_id_tbl,
1515: l_orig_consumption_flag_tbl
1516: FROM po_headers POH
1517: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1518: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1519: NVL(l_vendor_doc_num_tbl(i),
1520: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))

Line 1541: FROM po_headers POH

1537: NVL(POH.consigned_consumption_flag, 'N')
1538: BULK COLLECT
1539: INTO l_orig_po_header_id_tbl,
1540: l_orig_consumption_flag_tbl
1541: FROM po_headers POH
1542: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1543: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1544: NVL(l_vendor_doc_num_tbl(i),
1545: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))

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 1747: FROM po_headers POH,

1743: BULK COLLECT
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)) >=

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 1771: FROM po_headers POH,

1767: BULK COLLECT
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)) >=

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,

Line 1854: SET po_header_id = PO_HEADERS_S.nextval

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,
1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,