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

Line 345: IF p_document_type IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,

341: xOperatingUnit hr_operating_units.name%TYPE;
342: xInventoryOrg hr_all_organization_units.name%TYPE;
343: xItemNum VARCHAR2(2000);
344: BEGIN
345: IF p_document_type IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,
346: ICX_POR_EXT_ITEM.CONTRACT_TYPE,
347: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE,
348: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
349: THEN

Line 346: ICX_POR_EXT_ITEM.CONTRACT_TYPE,

342: xInventoryOrg hr_all_organization_units.name%TYPE;
343: xItemNum VARCHAR2(2000);
344: BEGIN
345: IF p_document_type IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,
346: ICX_POR_EXT_ITEM.CONTRACT_TYPE,
347: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE,
348: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
349: THEN
350: xOperatingUnit := getOperatingUnit(p_org_id);

Line 347: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE,

343: xItemNum VARCHAR2(2000);
344: BEGIN
345: IF p_document_type IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,
346: ICX_POR_EXT_ITEM.CONTRACT_TYPE,
347: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE,
348: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
349: THEN
350: xOperatingUnit := getOperatingUnit(p_org_id);
351: IF p_internal_item_num IS NULL THEN

Line 348: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)

344: BEGIN
345: IF p_document_type IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,
346: ICX_POR_EXT_ITEM.CONTRACT_TYPE,
347: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE,
348: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
349: THEN
350: xOperatingUnit := getOperatingUnit(p_org_id);
351: IF p_internal_item_num IS NULL THEN
352: IF p_supplier_part_num = TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) THEN

Line 352: IF p_supplier_part_num = TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) THEN

348: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
349: THEN
350: xOperatingUnit := getOperatingUnit(p_org_id);
351: IF p_internal_item_num IS NULL THEN
352: IF p_supplier_part_num = TO_CHAR(ICX_POR_EXT_ITEM.NULL_NUMBER) THEN
353: xItemNum := p_description;
354: ELSE
355: xItemNum := p_supplier_part_num;
356: END IF;

Line 361: IF p_document_type IN (ICX_POR_EXT_ITEM.CONTRACT_TYPE,

357: ELSE
358: xItemNum := p_internal_item_num;
359: END IF;
360:
361: IF p_document_type IN (ICX_POR_EXT_ITEM.CONTRACT_TYPE,
362: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
363: THEN
364: xReport := constructMessage(p_status,
365: xOperatingUnit, p_contract_num,

Line 362: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)

358: xItemNum := p_internal_item_num;
359: END IF;
360:
361: IF p_document_type IN (ICX_POR_EXT_ITEM.CONTRACT_TYPE,
362: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
363: THEN
364: xReport := constructMessage(p_status,
365: xOperatingUnit, p_contract_num,
366: xItemNum, p_supplier_site_code);

Line 371: ELSIF p_document_type IN (ICX_POR_EXT_ITEM.ASL_TYPE,

367: ELSE
368: xReport := constructMessage(p_status,
369: xOperatingUnit, p_template_id, xItemNum);
370: END IF;
371: ELSIF p_document_type IN (ICX_POR_EXT_ITEM.ASL_TYPE,
372: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE,
373: ICX_POR_EXT_ITEM.INTERNAL_ITEM_TYPE)
374: THEN
375: xInventoryOrg := getInventoryOrg(

Line 372: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE,

368: xReport := constructMessage(p_status,
369: xOperatingUnit, p_template_id, xItemNum);
370: END IF;
371: ELSIF p_document_type IN (ICX_POR_EXT_ITEM.ASL_TYPE,
372: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE,
373: ICX_POR_EXT_ITEM.INTERNAL_ITEM_TYPE)
374: THEN
375: xInventoryOrg := getInventoryOrg(
376: p_inventory_organization_id);

Line 373: ICX_POR_EXT_ITEM.INTERNAL_ITEM_TYPE)

369: xOperatingUnit, p_template_id, xItemNum);
370: END IF;
371: ELSIF p_document_type IN (ICX_POR_EXT_ITEM.ASL_TYPE,
372: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE,
373: ICX_POR_EXT_ITEM.INTERNAL_ITEM_TYPE)
374: THEN
375: xInventoryOrg := getInventoryOrg(
376: p_inventory_organization_id);
377:

Line 378: IF p_document_type = ICX_POR_EXT_ITEM.ASL_TYPE THEN

374: THEN
375: xInventoryOrg := getInventoryOrg(
376: p_inventory_organization_id);
377:
378: IF p_document_type = ICX_POR_EXT_ITEM.ASL_TYPE THEN
379: xReport := constructMessage(p_status,
380: xInventoryOrg, p_supplier,
381: p_internal_item_num);
382: ELSE

Line 1659: p_contract_line_id <> ICX_POR_EXT_ITEM.NULL_NUMBER)

1655: RETURN INACTIVE_TEMPLATE;
1656: END IF;
1657:
1658: IF (p_contract_line_id IS NOT NULL AND
1659: p_contract_line_id <> ICX_POR_EXT_ITEM.NULL_NUMBER)
1660: THEN
1661: xStatus := getContractLineStatus(p_contract_line_id, p_test_mode);
1662: IF xStatus = VALID_FOR_EXTRACT THEN
1663: RETURN VALID_FOR_EXTRACT;

Line 1892: 'AND p.org_id = nvl(prh.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

1888: 'po_reqexpress_lines_all prl ';
1889: END IF;
1890: xString := xString ||
1891: 'WHERE p.rowid = :row_id ' ||
1892: 'AND p.org_id = nvl(prh.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
1893: 'AND p.template_id = prh.express_name '||
1894: 'AND p.org_id = nvl(prl.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
1895: 'AND p.template_id = prl.express_name '||
1896: 'AND p.template_line_id = prl.sequence_num ';

Line 1894: 'AND p.org_id = nvl(prl.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

1890: xString := xString ||
1891: 'WHERE p.rowid = :row_id ' ||
1892: 'AND p.org_id = nvl(prh.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
1893: 'AND p.template_id = prh.express_name '||
1894: 'AND p.org_id = nvl(prl.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
1895: 'AND p.template_id = prl.express_name '||
1896: 'AND p.template_line_id = prl.sequence_num ';
1897: EXECUTE IMMEDIATE xString
1898: INTO l_express_name,

Line 1953: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

1949: 'WHERE p.rowid = :row_id ' ||
1950: 'AND p.contract_id = t.po_header_id '||
1951: 'AND p.org_id = t.organization_id '||
1952: 'AND t.vendor_site_id = pvs.vendor_site_id (+) '||
1953: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
1954: 'AND t.purchasing_org_id = fsp2.org_id '|| -- Centralized proc Impacts
1955: 'AND p.inventory_item_id = mi.inventory_item_id (+) '||
1956: 'AND p.inventory_item_id = mi2.inventory_item_id (+) '|| -- Centralized proc Impacts
1957: 'AND fsp.inventory_organization_id = NVL(mi.organization_id, '||

Line 2004: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

2000: 'financials_system_params_all fsp ';
2001: END IF;
2002: xString := xString ||
2003: 'WHERE p.rowid = :row_id ' ||
2004: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
2005: 'AND fsp.inventory_organization_id = pasl.owning_organization_id '||
2006: 'AND pasl.item_id = mi.inventory_item_id '||
2007: 'AND pasl.owning_organization_id = mi.organization_id '||
2008: 'AND p.asl_id = pasl.asl_id ';

Line 2037: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

2033: 'financials_system_params_all fsp ';
2034: END IF;
2035: xString := xString ||
2036: 'WHERE p.rowid = :row_id ' ||
2037: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
2038: 'AND fsp.inventory_organization_id = mi.organization_id '||
2039: 'AND p.inventory_item_id = mi.inventory_item_id ';
2040: EXECUTE IMMEDIATE xString
2041: INTO l_local_purchasing_enabled,

Line 2064: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

2060: 'financials_system_params_all fsp ';
2061: END IF;
2062: xString := xString ||
2063: 'WHERE p.rowid = :row_id ' ||
2064: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||
2065: 'AND fsp.inventory_organization_id = mi.organization_id '||
2066: 'AND p.inventory_item_id = mi.inventory_item_id ';
2067: EXECUTE IMMEDIATE xString
2068: INTO l_internal_order_enabled

Line 2100: IF pDocumentType IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,

2096: pLoadInternalItem IN VARCHAR2)
2097: RETURN NUMBER
2098: IS
2099: BEGIN
2100: IF pDocumentType IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,
2101: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE)
2102: THEN
2103: IF (pLoadTemplateLine = 'Y' AND
2104: pStatus = VALID_FOR_EXTRACT)

Line 2101: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE)

2097: RETURN NUMBER
2098: IS
2099: BEGIN
2100: IF pDocumentType IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,
2101: ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE)
2102: THEN
2103: IF (pLoadTemplateLine = 'Y' AND
2104: pStatus = VALID_FOR_EXTRACT)
2105: THEN

Line 2106: IF pDocumentType = ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE THEN

2102: THEN
2103: IF (pLoadTemplateLine = 'Y' AND
2104: pStatus = VALID_FOR_EXTRACT)
2105: THEN
2106: IF pDocumentType = ICX_POR_EXT_ITEM.INTERNAL_TEMPLATE_TYPE THEN
2107: IF pLoadInternalItem = 'Y' THEN
2108: RETURN 1;
2109: END IF;
2110: RETURN 0;

Line 2117: IF pDocumentType IN (ICX_POR_EXT_ITEM.CONTRACT_TYPE,

2113: END IF;
2114: RETURN 0;
2115: END IF;
2116:
2117: IF pDocumentType IN (ICX_POR_EXT_ITEM.CONTRACT_TYPE,
2118: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
2119: THEN
2120: IF (pLoadContract = 'Y' AND
2121: pStatus = VALID_FOR_EXTRACT)

Line 2118: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)

2114: RETURN 0;
2115: END IF;
2116:
2117: IF pDocumentType IN (ICX_POR_EXT_ITEM.CONTRACT_TYPE,
2118: ICX_POR_EXT_ITEM.GLOBAL_AGREEMENT_TYPE)
2119: THEN
2120: IF (pLoadContract = 'Y' AND
2121: pStatus = VALID_FOR_EXTRACT)
2122: THEN

Line 2128: IF pDocumentType IN (ICX_POR_EXT_ITEM.ASL_TYPE,

2124: END IF;
2125: RETURN 0;
2126: END IF;
2127:
2128: IF pDocumentType IN (ICX_POR_EXT_ITEM.ASL_TYPE,
2129: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE)
2130: THEN
2131: IF (pLoadItemMaster = 'Y' AND
2132: pStatus = VALID_FOR_EXTRACT)

Line 2129: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE)

2125: RETURN 0;
2126: END IF;
2127:
2128: IF pDocumentType IN (ICX_POR_EXT_ITEM.ASL_TYPE,
2129: ICX_POR_EXT_ITEM.PURCHASING_ITEM_TYPE)
2130: THEN
2131: IF (pLoadItemMaster = 'Y' AND
2132: pStatus = VALID_FOR_EXTRACT)
2133: THEN

Line 2139: IF pDocumentType = ICX_POR_EXT_ITEM.INTERNAL_ITEM_TYPE THEN

2135: END IF;
2136: RETURN 0;
2137: END IF;
2138:
2139: IF pDocumentType = ICX_POR_EXT_ITEM.INTERNAL_ITEM_TYPE THEN
2140: IF (pLoadInternalItem = 'Y' AND
2141: pStatus = VALID_FOR_EXTRACT)
2142: THEN
2143: RETURN 1;