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.ICX_CAT_R12_UPGRADE_PVT dependencies on PO_HEADERS_INTERFACE

Line 12: g_interface_source_code po_headers_interface.interface_source_code%TYPE := 'CATALOG R12 UPGRADE';

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ICX_CAT_R12_UPGRADE_PVT';
9: g_GBPA_hdr_count PLS_INTEGER := 0;
10: g_total_row_count PLS_INTEGER := 0;
11: g_PDOI_batch_id NUMBER;
12: g_interface_source_code po_headers_interface.interface_source_code%TYPE := 'CATALOG R12 UPGRADE';
13: g_process_code po_headers_interface.process_code%TYPE := 'NEW';
14: g_new_GBPA_description CONSTANT VARCHAR2(35) := 'R12 Upgrade of Bulk-Loaded Content.';
15: g_total_bulkld_row_count PLS_INTEGER := 0;
16: g_total_ext_row_count PLS_INTEGER := 0;

Line 13: g_process_code po_headers_interface.process_code%TYPE := 'NEW';

9: g_GBPA_hdr_count PLS_INTEGER := 0;
10: g_total_row_count PLS_INTEGER := 0;
11: g_PDOI_batch_id NUMBER;
12: g_interface_source_code po_headers_interface.interface_source_code%TYPE := 'CATALOG R12 UPGRADE';
13: g_process_code po_headers_interface.process_code%TYPE := 'NEW';
14: g_new_GBPA_description CONSTANT VARCHAR2(35) := 'R12 Upgrade of Bulk-Loaded Content.';
15: g_total_bulkld_row_count PLS_INTEGER := 0;
16: g_total_ext_row_count PLS_INTEGER := 0;
17:

Line 32: action po_headers_interface.action%TYPE,

28:
29: TYPE g_po_hdrs_int_rec_type IS RECORD
30: (
31: interface_header_id NUMBER,
32: action po_headers_interface.action%TYPE,
33: org_id NUMBER,
34: document_type_code po_headers_interface.document_type_code%TYPE,
35: budget_account_segment1 po_headers_interface.budget_account_segment1%TYPE,
36: po_header_id NUMBER,

Line 34: document_type_code po_headers_interface.document_type_code%TYPE,

30: (
31: interface_header_id NUMBER,
32: action po_headers_interface.action%TYPE,
33: org_id NUMBER,
34: document_type_code po_headers_interface.document_type_code%TYPE,
35: budget_account_segment1 po_headers_interface.budget_account_segment1%TYPE,
36: po_header_id NUMBER,
37: approval_status po_headers_interface.approval_status%TYPE,
38: vendor_id NUMBER,

Line 35: budget_account_segment1 po_headers_interface.budget_account_segment1%TYPE,

31: interface_header_id NUMBER,
32: action po_headers_interface.action%TYPE,
33: org_id NUMBER,
34: document_type_code po_headers_interface.document_type_code%TYPE,
35: budget_account_segment1 po_headers_interface.budget_account_segment1%TYPE,
36: po_header_id NUMBER,
37: approval_status po_headers_interface.approval_status%TYPE,
38: vendor_id NUMBER,
39: vendor_site_id NUMBER,

Line 37: approval_status po_headers_interface.approval_status%TYPE,

33: org_id NUMBER,
34: document_type_code po_headers_interface.document_type_code%TYPE,
35: budget_account_segment1 po_headers_interface.budget_account_segment1%TYPE,
36: po_header_id NUMBER,
37: approval_status po_headers_interface.approval_status%TYPE,
38: vendor_id NUMBER,
39: vendor_site_id NUMBER,
40: currency_code po_headers_interface.currency_code%TYPE,
41: cpa_reference NUMBER,

Line 40: currency_code po_headers_interface.currency_code%TYPE,

36: po_header_id NUMBER,
37: approval_status po_headers_interface.approval_status%TYPE,
38: vendor_id NUMBER,
39: vendor_site_id NUMBER,
40: currency_code po_headers_interface.currency_code%TYPE,
41: cpa_reference NUMBER,
42: created_language po_headers_interface.created_language%TYPE,
43: comments po_headers_interface.comments%TYPE
44: );

Line 42: created_language po_headers_interface.created_language%TYPE,

38: vendor_id NUMBER,
39: vendor_site_id NUMBER,
40: currency_code po_headers_interface.currency_code%TYPE,
41: cpa_reference NUMBER,
42: created_language po_headers_interface.created_language%TYPE,
43: comments po_headers_interface.comments%TYPE
44: );
45:
46: TYPE g_po_line_attrval_int_rec_type IS RECORD

Line 43: comments po_headers_interface.comments%TYPE

39: vendor_site_id NUMBER,
40: currency_code po_headers_interface.currency_code%TYPE,
41: cpa_reference NUMBER,
42: created_language po_headers_interface.created_language%TYPE,
43: comments po_headers_interface.comments%TYPE
44: );
45:
46: TYPE g_po_line_attrval_int_rec_type IS RECORD
47: (

Line 114: currency_code po_headers_interface.currency_code%TYPE,

110: (
111: org_id NUMBER,
112: vendor_id NUMBER,
113: vendor_site_id NUMBER,
114: currency_code po_headers_interface.currency_code%TYPE,
115: cpa_reference NUMBER,
116: language po_headers_interface.created_language%TYPE,
117: interface_header_id NUMBER,
118: po_header_id NUMBER,

Line 116: language po_headers_interface.created_language%TYPE,

112: vendor_id NUMBER,
113: vendor_site_id NUMBER,
114: currency_code po_headers_interface.currency_code%TYPE,
115: cpa_reference NUMBER,
116: language po_headers_interface.created_language%TYPE,
117: interface_header_id NUMBER,
118: po_header_id NUMBER,
119: upg_created_language po_headers_interface.created_language%TYPE,
120: upg_cpa_reference NUMBER

Line 119: upg_created_language po_headers_interface.created_language%TYPE,

115: cpa_reference NUMBER,
116: language po_headers_interface.created_language%TYPE,
117: interface_header_id NUMBER,
118: po_header_id NUMBER,
119: upg_created_language po_headers_interface.created_language%TYPE,
120: upg_cpa_reference NUMBER
121: );
122:
123: g_current_gbpa_hdr_rec g_current_gbpa_hdr_rec_type;

Line 128: --INSERT po_headers_interface

124:
125: ----------------------------------------------------
126: -- Global PL/SQL Tables --
127: ----------------------------------------------------
128: --INSERT po_headers_interface
129: gIHInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
130: gIHActionTbl DBMS_SQL.VARCHAR2_TABLE;
131: gIHOrgIdTbl DBMS_SQL.NUMBER_TABLE;
132: gIHDocumentTypeCodeTbl DBMS_SQL.VARCHAR2_TABLE;

Line 238: --INSERT po_headers_interface

234: )
235: IS
236: BEGIN
237: IF (p_action_mode IN ('ALL', 'INSERT_INT_HDRS')) THEN
238: --INSERT po_headers_interface
239: gIHInterfaceHeaderIdTbl.DELETE;
240: gIHActionTbl.DELETE;
241: gIHOrgIdTbl.DELETE;
242: gIHDocumentTypeCodeTbl.DELETE;

Line 369: --INSERT po_headers_interface

365: l_string VARCHAR2(4000);
366: BEGIN
367: l_string := 'logPLSQLTableRow('||p_action_mode||')['||p_index||']--';
368: IF (p_action_mode = 'INSERT_INT_HDRS') THEN
369: --INSERT po_headers_interface
370: l_string := l_string || ' gIHInterfaceHeaderIdTbl: ' ||
371: ICX_CAT_UTIL_PVT.getTableElement(gIHInterfaceHeaderIdTbl, p_index) || ', ';
372: l_string := l_string || ' gIHActionTbl: ' ||
373: ICX_CAT_UTIL_PVT.getTableElement(gIHActionTbl, p_index) || ', ';

Line 606: -- INSERT po_headers_interface

602: l_err_loc := 400;
603:
604: IF (p_action_mode = 'INSERT_INT_HDRS') THEN
605: l_err_loc := 500;
606: -- INSERT po_headers_interface
607: l_log_string := ' gIHInterfaceHeaderIdTbl: ' ||
608: ICX_CAT_UTIL_PVT.getTableElement(gIHInterfaceHeaderIdTbl, p_index) || '; ';
609: FND_LOG.string(p_log_level, l_module_name, l_log_string);
610:

Line 1021: SELECT po_headers_interface_s.NEXTVAL

1017: l_api_name CONSTANT VARCHAR2(30) := 'getNextInterfaceHdrIdFromSeq';
1018: l_err_loc PLS_INTEGER;
1019: BEGIN
1020: l_err_loc := 100;
1021: SELECT po_headers_interface_s.NEXTVAL
1022: INTO l_interface_header_id
1023: FROM DUAL;
1024:
1025: l_err_loc := 110;

Line 1385: INSERT INTO po_headers_interface

1381: l_err_loc := 130;
1382: l_action_mode := 'INSERT_INT_HDRS';
1383: -- Note: Copy of CPA attributes to GBPA will be done by PO.
1384: FORALL i in 1..gIHInterfaceHeaderIdTbl.COUNT
1385: INSERT INTO po_headers_interface
1386: (interface_header_id, batch_id, interface_source_code, process_code,
1387: action, org_id, document_type_code, budget_account_segment1, po_header_id,
1388: approval_status, vendor_id, vendor_site_id, currency_code,
1389: cpa_reference, created_language, comments, vendor_name, vendor_site_code)

Line 1409: 'No: of rows inserted into po_headers_interface:' ||SQL%ROWCOUNT);

1405: l_err_loc := 150;
1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1408: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1409: 'No: of rows inserted into po_headers_interface:' ||SQL%ROWCOUNT);
1410: END IF;
1411: END IF;
1412:
1413: l_err_loc := 160;

Line 2117: icx_cat_items_b itemsb, po_headers_interface phi

2113: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2114: itemsb.catalog_name, itemtlp.primary_category_id,
2115: getPOAttrValuesTLPAction(p.contract_line_id, '-2' ,-2, p.org_id, itemtlp.language)
2116: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2117: icx_cat_items_b itemsb, po_headers_interface phi
2118: WHERE p.price_type IN ('BLANKET', 'QUOTATION')
2119: AND p.contract_line_id >= p_start_po_line_id
2120: AND itemtlp.rt_item_id = p.rt_item_id
2121: AND itemsb.rt_item_id = p.rt_item_id

Line 2135: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi

2131: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2132: itemsb.catalog_name, itemtlp.primary_category_id,
2133: getPOAttrValuesTLPAction(p.contract_line_id, '-2' ,-2, p.org_id, itemtlp.language)
2134: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2135: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi
2136: WHERE p.price_type IN ('BLANKET', 'QUOTATION')
2137: AND p.contract_line_id >= p_start_po_line_id
2138: AND itemtlp.rt_item_id = p.rt_item_id
2139: AND itemsb.rt_item_id = p.rt_item_id

Line 2262: --For moving the extracted item attributes, the following will be null in po_headers_interface

2258: g_po_hdrs_int_rec.document_type_code := l_price_type_tbl(i);
2259: g_po_hdrs_int_rec.budget_account_segment1 := null;
2260: g_po_hdrs_int_rec.po_header_id := l_po_header_id_tbl(i);
2261: --Will have some value when moving bulk-loaded items
2262: --For moving the extracted item attributes, the following will be null in po_headers_interface
2263: --as these are already set in po_headers_all
2264: g_po_hdrs_int_rec.approval_status := null;
2265: g_po_hdrs_int_rec.vendor_id := null;
2266: g_po_hdrs_int_rec.vendor_site_id := null;

Line 2543: icx_cat_items_b itemsb, po_headers_interface phi

2539: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2540: itemsb.catalog_name, itemtlp.primary_category_id,
2541: getPOAttrValuesTLPAction(-2, p.template_id, p.template_line_id, p.org_id, itemtlp.language)
2542: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2543: icx_cat_items_b itemsb, po_headers_interface phi
2544: WHERE p.price_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
2545: AND p.rt_item_id >= p_start_rt_item_id
2546: AND itemtlp.rt_item_id = p.rt_item_id
2547: AND itemsb.rt_item_id = p.rt_item_id

Line 2562: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi

2558: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2559: itemsb.catalog_name, itemtlp.primary_category_id,
2560: getPOAttrValuesTLPAction(-2, p.template_id, p.template_line_id, p.org_id, itemtlp.language)
2561: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2562: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi
2563: WHERE p.price_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
2564: AND p.rt_item_id >= p_start_rt_item_id
2565: AND itemtlp.rt_item_id = p.rt_item_id
2566: AND itemsb.rt_item_id = p.rt_item_id

Line 2683: -- Just used by data migration to get the interface header id from po_headers_interface

2679: l_err_loc := 1100;
2680: g_po_hdrs_int_rec.interface_header_id := l_interface_header_id;
2681: g_po_hdrs_int_rec.action := 'REQTEMPLATE';
2682: g_po_hdrs_int_rec.org_id := l_org_id_tbl(i);
2683: -- Just used by data migration to get the interface header id from po_headers_interface
2684: g_po_hdrs_int_rec.budget_account_segment1 := l_req_template_name_tbl(i);
2685: g_po_hdrs_int_rec.document_type_code := null;
2686: g_po_hdrs_int_rec.po_header_id := null;
2687: --Will have some value when moving bulk-loaded items

Line 2688: --For moving the extracted item attributes, the following will be null in po_headers_interface

2684: g_po_hdrs_int_rec.budget_account_segment1 := l_req_template_name_tbl(i);
2685: g_po_hdrs_int_rec.document_type_code := null;
2686: g_po_hdrs_int_rec.po_header_id := null;
2687: --Will have some value when moving bulk-loaded items
2688: --For moving the extracted item attributes, the following will be null in po_headers_interface
2689: --as these are already set in po_headers_all
2690: g_po_hdrs_int_rec.approval_status := null;
2691: g_po_hdrs_int_rec.vendor_id := null;
2692: g_po_hdrs_int_rec.vendor_site_id := null;

Line 2921: -- and dummy lines in po headers interface for each express_name and org_id

2917: --1. Process Blankets and Quotations:
2918: -- Populate po headers, lines, attributes and attributes_tlp interface tables.
2919: --2. Process Requisition templates:
2920: -- populate po attributes and attributes_tlp interface tables
2921: -- and dummy lines in po headers interface for each express_name and org_id
2922: -- and dummy lines in po_lines interface for each line in a requisition template (express_name).
2923: processBlanketsAndQuotes;
2924:
2925: l_err_loc := 200;

Line 4639: -- We need to insert rows in po_headers_interface, po_lines_interface, po_attr_values_interface

4635: l_po_interface_header_id_tbl(i) IS NOT NULL AND
4636: g_current_gbpa_hdr_rec.interface_header_id = l_po_interface_header_id_tbl(i)))
4637: THEN
4638: -- i.e. both the interface_header_id from the lines cursor and from the headers cursors are the same
4639: -- We need to insert rows in po_headers_interface, po_lines_interface, po_attr_values_interface
4640: -- and po_attr_values_tlp_interface
4641: -- IF interface_header_id from the headers cursor is null then insert into icx_cat_r12_upgrade table
4642: -- IF interface_header_id from the headers cursor is not null then update icx_cat_r12_upgrade table
4643: IF (l_firstRow) THEN

Line 4762: --The rest of the values can be inserted as null in po_headers_interface

4758: g_po_hdrs_int_rec.budget_account_segment1 := null;
4759: g_po_hdrs_int_rec.po_header_id := l_po_header_id_tbl(i);
4760: g_po_hdrs_int_rec.approval_status := 'IN PROCESS';
4761: g_po_hdrs_int_rec.org_id := g_current_gbpa_hdr_rec.org_id;
4762: --The rest of the values can be inserted as null in po_headers_interface
4763: --i.e. we are not touching the values that are alreay present in po_headers_all
4764: g_po_hdrs_int_rec.vendor_id := null;
4765: g_po_hdrs_int_rec.vendor_site_id := null;
4766: g_po_hdrs_int_rec.currency_code := null;

Line 5357: -- populated in po_headers_interface for its processing

5353: PROCEDURE checkDeleteInGBPAForDelta
5354: IS
5355: -- Reason for joining back to po_headers_all is:
5356: -- pomigratecatalog code is dependant on the org_id being
5357: -- populated in po_headers_interface for its processing
5358: -- Reason for outer join with po_headers_all, because there may be items in
5359: -- catalog that was never migrated due to errors, so they will have po_header_id as null
5360: CURSOR getDeletedItemPricesInCatlgCsr IS
5361: SELECT rt_item_id, po_interface_header_id, po_interface_line_id,

Line 5471: --and populate a line in po_headers_interface

5467: --in po_lines_interface with DELETE action
5468: --And also delete the row from icx_cat_r12_upgrade.
5469: IF (l_prev_po_header_id <> l_po_header_id_tbl(i)) THEN
5470: --po_header_id has changed, so get the next interfaceHeaderId
5471: --and populate a line in po_headers_interface
5472: l_interface_header_id := getNextInterfaceHdrIdFromSeq;
5473:
5474: l_err_loc := 210;
5475: g_po_hdrs_int_rec.interface_header_id := l_interface_header_id;

Line 5482: --The rest of the values can be inserted as null in po_headers_interface

5478: g_po_hdrs_int_rec.budget_account_segment1 := null;
5479: g_po_hdrs_int_rec.po_header_id := l_po_header_id_tbl(i);
5480: g_po_hdrs_int_rec.approval_status := 'IN PROCESS';
5481: g_po_hdrs_int_rec.org_id := l_org_id_tbl(i);
5482: --The rest of the values can be inserted as null in po_headers_interface
5483: --i.e. we are not touching the values that are alreay present in po_headers_all
5484: g_po_hdrs_int_rec.vendor_id := null;
5485: g_po_hdrs_int_rec.vendor_site_id := null;
5486: g_po_hdrs_int_rec.currency_code := null;

Line 6113: FROM po_headers_interface phi

6109: FORALL i IN 1..p_interface_header_id.COUNT
6110: UPDATE icx_cat_r12_upgrade upg
6111: SET (po_header_id, created_language) =
6112: (SELECT po_header_id, created_language
6113: FROM po_headers_interface phi
6114: WHERE phi.interface_header_id = upg.po_interface_header_id)
6115: WHERE upg.po_interface_header_id = p_interface_header_id(i);
6116:
6117: l_err_loc := 300;

Line 7790: -- Get it from the po_headers_interface

7786: ICX_CAT_UTIL_PVT.setBatchSize;
7787:
7788: l_err_loc := 300;
7789: -- Get the next batch_id for PDOI
7790: -- Get it from the po_headers_interface
7791: -- Cannot use the API PO_PDOI_UTL.get_next_batch_id because
7792: -- this is not available in 11.5.9 and 11.5.10
7793: SELECT NVL(MAX(batch_id), 0) + 1
7794: INTO g_PDOI_batch_id

Line 7795: FROM po_headers_interface;

7791: -- Cannot use the API PO_PDOI_UTL.get_next_batch_id because
7792: -- this is not available in 11.5.9 and 11.5.10
7793: SELECT NVL(MAX(batch_id), 0) + 1
7794: INTO g_PDOI_batch_id
7795: FROM po_headers_interface;
7796:
7797: l_err_loc := 400;
7798: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7799: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,