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_ALL

Line 2263: --as these are already set in po_headers_all

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;
2267: g_po_hdrs_int_rec.currency_code := null;

Line 2689: --as these are already set in po_headers_all

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;
2693: g_po_hdrs_int_rec.currency_code := null;

Line 3039: l_document_type_code po_headers_all.type_lookup_code%TYPE := '';

3035: l_source_organization_id NUMBER := NULL;
3036: l_source_subinventory VARCHAR2(10) := '';
3037: l_document_header_id NUMBER := NULL;
3038: l_document_line_id NUMBER := NULL;
3039: l_document_type_code po_headers_all.type_lookup_code%TYPE := '';
3040: l_document_line_num NUMBER := NULL;
3041: l_buyer_id NUMBER := NULL;
3042: l_vendor_product_num po_lines_all.vendor_product_num%TYPE := '';
3043: l_purchasing_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE := '';

Line 4763: --i.e. we are not touching the values that are alreay present in po_headers_all

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;
4767: g_po_hdrs_int_rec.cpa_reference := null;

Line 5355: -- Reason for joining back to po_headers_all is:

5351: END checkUpdateInGBPAForDelta;
5352:
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

Line 5358: -- Reason for outer join with po_headers_all, because there may be items in

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,
5362: upg.po_header_id, po_line_id, ph.org_id

Line 5363: FROM icx_cat_r12_upgrade upg, po_headers_all ph

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,
5362: upg.po_header_id, po_line_id, ph.org_id
5363: FROM icx_cat_r12_upgrade upg, po_headers_all ph
5364: WHERE NOT EXISTS (SELECT 'x'
5365: FROM icx_cat_items_b itemsB, icx_cat_item_prices prices
5366: WHERE itemsB.rt_item_id = prices.rt_item_id
5367: AND upg.rt_item_id = prices.rt_item_id

Line 5483: --i.e. we are not touching the values that are alreay present in po_headers_all

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;
5487: g_po_hdrs_int_rec.cpa_reference := null;