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_FPI_UPGRADE dependencies on ICX_POR_EXT_ITEM

Line 273: IF pTemplateItem.hash_value > ICX_POR_EXT_ITEM.NULL_NUMBER THEN

269: xHashValue PLS_INTEGER;
270: xTemplateItem tTemplateItemRecord;
271: BEGIN
272: xErrLoc := 100;
273: IF pTemplateItem.hash_value > ICX_POR_EXT_ITEM.NULL_NUMBER THEN
274: RETURN TRUE;
275: END IF;
276:
277: xHashString := pTemplateItem.template_id || pTemplateItem.rt_item_id;

Line 307: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findTemplateItemCache-'||

303:
304: RETURN FALSE;
305: EXCEPTION
306: when others then
307: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findTemplateItemCache-'||
308: xErrLoc||' '||SQLERRM);
309: raise ICX_POR_EXT_UTL.gException;
310: END findTemplateItemCache;
311:

Line 317: IF pTemplateItem.hash_value = ICX_POR_EXT_ITEM.NULL_NUMBER THEN

313: xErrLoc PLS_INTEGER := 100;
314: BEGIN
315: xErrLoc := 100;
316:
317: IF pTemplateItem.hash_value = ICX_POR_EXT_ITEM.NULL_NUMBER THEN
318: RETURN;
319: END IF;
320:
321: xErrLoc := 200;

Line 325: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putTemplateItemCache-'||

321: xErrLoc := 200;
322: gTemplateItemCache(pTemplateItem.hash_value) := pTemplateItem;
323: EXCEPTION
324: when others then
325: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putTemplateItemCache-'||
326: xErrLoc||' '||SQLERRM);
327: raise ICX_POR_EXT_UTL.gException;
328: END putTemplateItemCache;
329:

Line 562: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,

558:
559: */
560: -- Cursor for all item records: subtable records and price list lines
561: CURSOR cItemRecords(p_rt_item_id IN NUMBER) IS
562: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
563: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
564: pl.vendor_product_num supplier_part_num,
565: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
566: 7 type, -- template_contracts

Line 563: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

559: */
560: -- Cursor for all item records: subtable records and price list lines
561: CURSOR cItemRecords(p_rt_item_id IN NUMBER) IS
562: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
563: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
564: pl.vendor_product_num supplier_part_num,
565: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
566: 7 type, -- template_contracts
567: greatest(pl.last_update_date,

Line 565: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

561: CURSOR cItemRecords(p_rt_item_id IN NUMBER) IS
562: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
563: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
564: pl.vendor_product_num supplier_part_num,
565: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
566: 7 type, -- template_contracts
567: greatest(pl.last_update_date,
568: ph.last_update_date) last_update_date,
569: -- pcreddy : Bug # 3234875 : Price type should be TEMPLATE

Line 601: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,

597: AND sub.orc_contract_id = ph.po_header_id
598: AND sub.orc_contract_line_id = pl.po_line_id
599: AND prl.suggested_vendor_id = pv.vendor_id (+)
600: UNION ALL
601: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
602: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
603: pl.vendor_product_num supplier_part_num,
604: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
605: 6 type, -- contracts

Line 602: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

598: AND sub.orc_contract_line_id = pl.po_line_id
599: AND prl.suggested_vendor_id = pv.vendor_id (+)
600: UNION ALL
601: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
602: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
603: pl.vendor_product_num supplier_part_num,
604: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
605: 6 type, -- contracts
606: greatest(pl.last_update_date,

Line 604: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

600: UNION ALL
601: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
602: NVL(ph.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
603: pl.vendor_product_num supplier_part_num,
604: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
605: 6 type, -- contracts
606: greatest(pl.last_update_date,
607: ph.last_update_date) last_update_date,
608: ph.type_lookup_code price_type, -- 'BLANKET' or 'QUOTATION'

Line 610: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,

606: greatest(pl.last_update_date,
607: ph.last_update_date) last_update_date,
608: ph.type_lookup_code price_type, -- 'BLANKET' or 'QUOTATION'
609: pl.item_description item_description,
610: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
611: ph.rate_type,
612: ph.rate_date,
613: ph.rate,
614: pv.segment1 supplier_number,

Line 630: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,

626: AND sub.orc_contract_id = ph.po_header_id
627: AND sub.orc_contract_line_id = pl.po_line_id
628: AND ph.vendor_id = pv.vendor_id (+)
629: UNION ALL
630: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
631: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
632: prl.suggested_vendor_product_code supplier_part_num,
633: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
634: 5 type, -- templates

Line 631: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

627: AND sub.orc_contract_line_id = pl.po_line_id
628: AND ph.vendor_id = pv.vendor_id (+)
629: UNION ALL
630: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
631: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
632: prl.suggested_vendor_product_code supplier_part_num,
633: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
634: 5 type, -- templates
635: greatest(prl.last_update_date,

Line 633: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

629: UNION ALL
630: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
631: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
632: prl.suggested_vendor_product_code supplier_part_num,
633: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
634: 5 type, -- templates
635: greatest(prl.last_update_date,
636: prh.last_update_date) last_update_date,
637: 'TEMPLATE' price_type,

Line 667: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,

663: prl.org_id is NULL OR
664: prl.org_id = sub.orc_operating_unit_id)
665: AND prl.suggested_vendor_id = pv.vendor_id (+)
666: UNION ALL
667: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
668: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
669: prl.suggested_vendor_product_code supplier_part_num,
670: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
671: 4 type, -- internal templates

Line 668: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

664: prl.org_id = sub.orc_operating_unit_id)
665: AND prl.suggested_vendor_id = pv.vendor_id (+)
666: UNION ALL
667: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
668: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
669: prl.suggested_vendor_product_code supplier_part_num,
670: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
671: 4 type, -- internal templates
672: greatest(prl.last_update_date,

Line 670: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

666: UNION ALL
667: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
668: NVL(prl.suggested_vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
669: prl.suggested_vendor_product_code supplier_part_num,
670: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
671: 4 type, -- internal templates
672: greatest(prl.last_update_date,
673: prh.last_update_date) last_update_date,
674: 'INTERNAL_TEMPLATE' price_type,

Line 704: NVL(prl.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

700: prl.org_id is NULL OR
701: prl.org_id = sub.orc_operating_unit_id)
702: UNION ALL
703: SELECT prl.buyer_id org_id,
704: NVL(prl.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
705: item.a3 supplier_part_num,
706: NVL(pvs.vendor_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
707: 3 type, -- Bulk Loaded
708: prl.last_update_date last_update_date,

Line 706: NVL(pvs.vendor_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

702: UNION ALL
703: SELECT prl.buyer_id org_id,
704: NVL(prl.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
705: item.a3 supplier_part_num,
706: NVL(pvs.vendor_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
707: 3 type, -- Bulk Loaded
708: prl.last_update_date last_update_date,
709: --Bug#3148018
710: --For lines with contract_reference_num, should have a price_type

Line 714: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) template_id,

710: --For lines with contract_reference_num, should have a price_type
711: --of CONTRACT
712: decode(prl.contract_reference_num, null, 'BULKLOAD', 'CONTRACT') price_type,
713: TO_CHAR(NULL) item_description,
714: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) template_id,
715: TO_CHAR(NULL) rate_type,
716: TO_DATE(NULL) rate_date,
717: TO_NUMBER(NULL) rate,
718: TO_CHAR(NULL) supplier_number,

Line 734: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,

730: AND prl.supplier_site = pvs.vendor_site_code (+)
731: AND prl.supplier_id = pvs.vendor_id (+)
732: AND prl.buyer_id = pvs.org_id (+)
733: UNION ALL
734: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
735: NVL(pasl.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
736: pasl.primary_vendor_item supplier_part_num,
737: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
738: 2 type, -- ASLs

Line 735: NVL(pasl.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

731: AND prl.supplier_id = pvs.vendor_id (+)
732: AND prl.buyer_id = pvs.org_id (+)
733: UNION ALL
734: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
735: NVL(pasl.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
736: pasl.primary_vendor_item supplier_part_num,
737: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
738: 2 type, -- ASLs
739: pasl.last_update_date last_update_date,

Line 737: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

733: UNION ALL
734: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
735: NVL(pasl.vendor_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
736: pasl.primary_vendor_item supplier_part_num,
737: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
738: 2 type, -- ASLs
739: pasl.last_update_date last_update_date,
740: 'ASL' price_type,
741: TO_CHAR(NULL) item_description,

Line 742: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) template_id,

738: 2 type, -- ASLs
739: pasl.last_update_date last_update_date,
740: 'ASL' price_type,
741: TO_CHAR(NULL) item_description,
742: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) template_id,
743: TO_CHAR(NULL) rate_type,
744: TO_DATE(NULL) rate_date,
745: TO_NUMBER(NULL) rate,
746: TO_CHAR(NULL) supplier_number,

Line 767: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,

763: FROM financials_system_params_all fspa
764: WHERE fspa.org_id = sub.orc_operating_unit_id
765: AND rownum = 1))
766: UNION ALL
767: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
768: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
769: TO_CHAR(NULL) supplier_part_num,
770: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
771: 1 type, -- Master Items

Line 768: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,

764: WHERE fspa.org_id = sub.orc_operating_unit_id
765: AND rownum = 1))
766: UNION ALL
767: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
768: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
769: TO_CHAR(NULL) supplier_part_num,
770: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
771: 1 type, -- Master Items
772: msi.last_update_date last_update_date,

Line 770: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,

766: UNION ALL
767: SELECT NVL(sub.orc_operating_unit_id, ICX_POR_EXT_ITEM.NULL_NUMBER) org_id,
768: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_id,
769: TO_CHAR(NULL) supplier_part_num,
770: TO_NUMBER(ICX_POR_EXT_ITEM.NULL_NUMBER) supplier_site_id,
771: 1 type, -- Master Items
772: msi.last_update_date last_update_date,
773: DECODE(sub.search_type, 'SUPPLIER',
774: 'PURCHASING_ITEM', 'INTERNAL_ITEM') price_type,

Line 944: IF xTemplateIds(i) <> TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) THEN

940: -- Template_contract
941: xActiveFlag := 'Y';
942: ELSIF xTypes(i) = 6 THEN
943: -- Contract
944: IF xTemplateIds(i) <> TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) THEN
945: -- Contract with template reference
946: xActiveFlag := 'N';
947: -- Clear template_id
948: xTemplateIds(i) := TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER);

Line 948: xTemplateIds(i) := TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER);

944: IF xTemplateIds(i) <> TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) THEN
945: -- Contract with template reference
946: xActiveFlag := 'N';
947: -- Clear template_id
948: xTemplateIds(i) := TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER);
949: ELSE
950: xActiveFlag := 'Y';
951: END IF;
952: ELSIF (xTypes(i) in (4, 5)) THEN

Line 1043: xTemplateIds(i) := TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER);

1039: gITItemDescriptions(xCount) := xItemDescriptions(i);
1040: END IF;
1041: IF xTypes(i) = 6 THEN
1042: -- Clear template_id for Contract
1043: xTemplateIds(i) := TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER);
1044: END IF;
1045: xErrLoc := 320;
1046: -- Set active flag
1047: xActiveFlag := 'Y';

Line 1053: IF (xTemplateIds(i) <> TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER)) THEN

1049: xType := 0;
1050: END IF;
1051:
1052: -- Set global PL/SQL tables for template headers for an item
1053: IF (xTemplateIds(i) <> TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER)) THEN
1054: -- Check for duplicate records
1055: xTemplateItem.template_id := xTemplateIds(i);
1056: xTemplateItem.rt_item_id := xRtItemId;
1057: IF NOT findTemplateItemCache(xTemplateItem) THEN

Line 1154: NVL(item.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1150: extractor_updated_flag, last_update_login, last_updated_by, last_update_date,
1151: created_by, creation_date, request_id,
1152: program_application_id, program_id, program_update_date)
1153: SELECT gIRtItemIds(i), gIOldRtItemIds(i), gIOrgIds(i),
1154: NVL(item.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1155: item.A1, gISupplierPartNums(i), '##NULL##',
1156: item.orc_item_id, item.orc_item_num,
1157: gIExtractorUpdatedFlags(i),
1158: gUpgradeUserId, gUpgradeUserId, sysdate,

Line 1185: NVL(item.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1181: ctx_desc, last_update_login, last_updated_by, last_update_date,
1182: created_by, creation_date, request_id,
1183: program_application_id, program_id, program_update_date)
1184: SELECT gIRtItemIds(i), tl.language, gIOrgIds(i),
1185: NVL(item.supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1186: item.item_source_type, item.search_type,
1187: gIRtCategoryIds(i), cat.category_name,
1188: item.orc_item_id, item.orc_item_num,
1189: item.A1, gISupplierPartNums(i), '##NULL##',

Line 1433: NVL(sub.orc_asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1429: created_by, creation_date, request_id,
1430: program_application_id, program_id, program_update_date)
1431: SELECT gEPRtItemIds(i), gEPPriceTypes(i),
1432: gEPActiveFlags(i), 1,
1433: NVL(sub.orc_asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1434: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines

Line 1434: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1430: program_application_id, program_id, program_update_date)
1431: SELECT gEPRtItemIds(i), gEPPriceTypes(i),
1432: gEPActiveFlags(i), 1,
1433: NVL(sub.orc_asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1434: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),

Line 1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1431: SELECT gEPRtItemIds(i), gEPPriceTypes(i),
1432: gEPActiveFlags(i), 1,
1433: NVL(sub.orc_asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1434: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),

Line 1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1432: gEPActiveFlags(i), 1,
1433: NVL(sub.orc_asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1434: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),

Line 1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),

1434: NVL(sub.orc_supplier_site_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1441: NVL(sub.orc_template_line_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1442: NVL(item.orc_item_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

Line 1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),

1435: NVL(sub.orc_contract_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1441: NVL(sub.orc_template_line_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1442: NVL(item.orc_item_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1443: sub.orc_category_id, gEPOrgIds(i),

Line 1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),

1436: NVL(sub.orc_contract_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1441: NVL(sub.orc_template_line_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1442: NVL(item.orc_item_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1443: sub.orc_category_id, gEPOrgIds(i),
1444: sub.search_type, sub.unit_price,

Line 1441: NVL(sub.orc_template_line_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),

1437: -- PCREDDY: 3234875 : No template id for Contract lines
1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1441: NVL(sub.orc_template_line_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1442: NVL(item.orc_item_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1443: sub.orc_category_id, gEPOrgIds(i),
1444: sub.search_type, sub.unit_price,
1445: sub.currency, sub.unit_of_measure,

Line 1442: NVL(item.orc_item_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1438: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1439: NVL(sub.orc_template_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1440: DECODE(gEPPriceTypes(i), 'BLANKET', TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1441: NVL(sub.orc_template_line_id, TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER))),
1442: NVL(item.orc_item_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1443: sub.orc_category_id, gEPOrgIds(i),
1444: sub.search_type, sub.unit_price,
1445: sub.currency, sub.unit_of_measure,
1446: sub.functional_price, sub.orc_supplier_site_code,

Line 1519: ICX_POR_EXT_ITEM.NULL_NUMBER,

1515: created_by, creation_date, request_id,
1516: program_application_id, program_id, program_update_date)
1517: SELECT gBPRtItemIds(i), gBPPriceTypes(i),
1518: gBRActiveFlgs(i), 1,
1519: ICX_POR_EXT_ITEM.NULL_NUMBER,
1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),
1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),

Line 1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),

1516: program_application_id, program_id, program_update_date)
1517: SELECT gBPRtItemIds(i), gBPPriceTypes(i),
1518: gBRActiveFlgs(i), 1,
1519: ICX_POR_EXT_ITEM.NULL_NUMBER,
1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),
1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,

Line 1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),

1517: SELECT gBPRtItemIds(i), gBPPriceTypes(i),
1518: gBRActiveFlgs(i), 1,
1519: ICX_POR_EXT_ITEM.NULL_NUMBER,
1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),
1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,
1525: ICX_POR_EXT_ITEM.NULL_NUMBER,

Line 1522: ICX_POR_EXT_ITEM.NULL_NUMBER,

1518: gBRActiveFlgs(i), 1,
1519: ICX_POR_EXT_ITEM.NULL_NUMBER,
1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),
1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,
1525: ICX_POR_EXT_ITEM.NULL_NUMBER,
1526: ICX_POR_EXT_ITEM.NULL_NUMBER, gBPOrgIds(i),

Line 1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),

1519: ICX_POR_EXT_ITEM.NULL_NUMBER,
1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),
1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,
1525: ICX_POR_EXT_ITEM.NULL_NUMBER,
1526: ICX_POR_EXT_ITEM.NULL_NUMBER, gBPOrgIds(i),
1527: 'SUPPLIER', prl.unit_price,

Line 1524: ICX_POR_EXT_ITEM.NULL_NUMBER,

1520: NVL(gBPSupplierSiteIds(i), ICX_POR_EXT_ITEM.NULL_NUMBER),
1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,
1525: ICX_POR_EXT_ITEM.NULL_NUMBER,
1526: ICX_POR_EXT_ITEM.NULL_NUMBER, gBPOrgIds(i),
1527: 'SUPPLIER', prl.unit_price,
1528: prl.currency_code, prl.uom,

Line 1525: ICX_POR_EXT_ITEM.NULL_NUMBER,

1521: NVL(prl.contract_reference_id, ICX_POR_EXT_ITEM.NULL_NUMBER),
1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,
1525: ICX_POR_EXT_ITEM.NULL_NUMBER,
1526: ICX_POR_EXT_ITEM.NULL_NUMBER, gBPOrgIds(i),
1527: 'SUPPLIER', prl.unit_price,
1528: prl.currency_code, prl.uom,
1529: NULL, -- Leave functional_price as NULL

Line 1526: ICX_POR_EXT_ITEM.NULL_NUMBER, gBPOrgIds(i),

1522: ICX_POR_EXT_ITEM.NULL_NUMBER,
1523: TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER),
1524: ICX_POR_EXT_ITEM.NULL_NUMBER,
1525: ICX_POR_EXT_ITEM.NULL_NUMBER,
1526: ICX_POR_EXT_ITEM.NULL_NUMBER, gBPOrgIds(i),
1527: 'SUPPLIER', prl.unit_price,
1528: prl.currency_code, prl.uom,
1529: NULL, -- Leave functional_price as NULL
1530: prl.supplier_site,

Line 1787: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,

1783: created_by, creation_date, request_id,
1784: program_application_id, program_id, program_update_date)
1785: SELECT p.rt_item_id, 'INTERNAL_ITEM',
1786: 'N', 1,
1787: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1788: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1789: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1790: mi.inventory_item_id,
1791: p.mtl_category_id, p.org_id,

Line 1788: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,

1784: program_application_id, program_id, program_update_date)
1785: SELECT p.rt_item_id, 'INTERNAL_ITEM',
1786: 'N', 1,
1787: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1788: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1789: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1790: mi.inventory_item_id,
1791: p.mtl_category_id, p.org_id,
1792: 'INTERNAL',

Line 1789: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,

1785: SELECT p.rt_item_id, 'INTERNAL_ITEM',
1786: 'N', 1,
1787: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1788: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1789: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1790: mi.inventory_item_id,
1791: p.mtl_category_id, p.org_id,
1792: 'INTERNAL',
1793: mi.list_price_per_unit unit_price,

Line 1938: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,

1934: created_by, creation_date, request_id,
1935: program_application_id, program_id, program_update_date)
1936: SELECT xRtItemIds(i), 'PURCHASING_ITEM',
1937: 'N', 1,
1938: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1939: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1940: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1941: mi.inventory_item_id,
1942: mic.category_id mtl_category_id, xOrgIds(i),

Line 1939: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,

1935: program_application_id, program_id, program_update_date)
1936: SELECT xRtItemIds(i), 'PURCHASING_ITEM',
1937: 'N', 1,
1938: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1939: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1940: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1941: mi.inventory_item_id,
1942: mic.category_id mtl_category_id, xOrgIds(i),
1943: 'SUPPLIER',

Line 1940: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,

1936: SELECT xRtItemIds(i), 'PURCHASING_ITEM',
1937: 'N', 1,
1938: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1939: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1940: ICX_POR_EXT_ITEM.NULL_NUMBER, ICX_POR_EXT_ITEM.NULL_NUMBER,
1941: mi.inventory_item_id,
1942: mic.category_id mtl_category_id, xOrgIds(i),
1943: 'SUPPLIER',
1944: mi.list_price_per_unit unit_price,

Line 2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,

2325: -- Upgrade POR_FAVORITE_LIST_LINES
2326: PROCEDURE upgradeFavoriteList IS
2327: CURSOR cFavoriteListLines IS
2328: SELECT rowid,
2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,
2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,
2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,
2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,

Line 2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,

2326: PROCEDURE upgradeFavoriteList IS
2327: CURSOR cFavoriteListLines IS
2328: SELECT rowid,
2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,
2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,
2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,
2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,
2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,

Line 2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,

2327: CURSOR cFavoriteListLines IS
2328: SELECT rowid,
2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,
2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,
2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,
2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,
2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,
2335: price_list_id,

Line 2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,

2328: SELECT rowid,
2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,
2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,
2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,
2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,
2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,
2335: price_list_id,
2336: rt_item_id

Line 2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,

2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,
2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,
2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,
2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,
2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,
2335: price_list_id,
2336: rt_item_id
2337: FROM por_favorite_list_lines

Line 2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,

2330: nvl(source_doc_line_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_line_id,
2331: nvl(asl_id, ICX_POR_EXT_ITEM.NULL_NUMBER) asl_id,
2332: nvl(template_name, to_char(ICX_POR_EXT_ITEM.NULL_NUMBER)) template_id,
2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,
2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,
2335: price_list_id,
2336: rt_item_id
2337: FROM por_favorite_list_lines
2338: WHERE rt_item_id IS NOT NULL;