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_ITEM dependencies on ICX_POR_EXT_DIAG

Line 1320: ', status: ' || ICX_POR_EXT_DIAG.getStatusString(gCurrentPrice.status) ||

1316: ', functional_price: ' || gCurrentPrice.functional_price ||
1317: ', contract_num: ' || gCurrentPrice.contract_num ||
1318: ', contract_line_num: ' || gCurrentPrice.contract_line_num ||
1319: ', global_agreement_flag: ' || gCurrentPrice.global_agreement_flag ||
1320: ', status: ' || ICX_POR_EXT_DIAG.getStatusString(gCurrentPrice.status) ||
1321: ', primary_category_id: ' || gCurrentPrice.primary_category_id ||
1322: ', primary_category_name: ' || gCurrentPrice.primary_category_name ||
1323: ', template_category_id: ' || gCurrentPrice.template_category_id ||
1324: ', price_rt_item_id: ' || gCurrentPrice.price_rt_item_id ||

Line 1343: RETURN ICX_POR_EXT_DIAG.getPriceReport(

1339:
1340: FUNCTION getPriceReport RETURN VARCHAR2
1341: IS
1342: BEGIN
1343: RETURN ICX_POR_EXT_DIAG.getPriceReport(
1344: gCurrentPrice.document_type,
1345: gCurrentPrice.org_id,
1346: gCurrentPrice.inventory_organization_id,
1347: gCurrentPrice.status,

Line 3266: gCurrentPrice.status := ICX_POR_EXT_DIAG.CATEGORY_NOT_EXTRACTED;

3262: -- Check if Category/Template Header is extracted
3263: IF (gCurrentPrice.document_type <> GLOBAL_AGREEMENT_TYPE AND
3264: gCurrentPrice.primary_category_id IS NULL)
3265: THEN
3266: gCurrentPrice.status := ICX_POR_EXT_DIAG.CATEGORY_NOT_EXTRACTED;
3267: ELSIF (gCurrentPrice.document_type IN (TEMPLATE_TYPE,
3268: INTERNAL_TEMPLATE_TYPE) AND
3269: gCurrentPrice.template_category_id IS NULL)
3270: THEN

Line 3271: IF gCurrentPrice.status = ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT THEN

3267: ELSIF (gCurrentPrice.document_type IN (TEMPLATE_TYPE,
3268: INTERNAL_TEMPLATE_TYPE) AND
3269: gCurrentPrice.template_category_id IS NULL)
3270: THEN
3271: IF gCurrentPrice.status = ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT THEN
3272: -- Don't set template line last run date so that after classification
3273: -- extraction is run, this template line will still be picked up.
3274: gSetTemplateLastRunDate := FALSE;
3275: END IF;

Line 3276: gCurrentPrice.status := ICX_POR_EXT_DIAG.TEMPLATE_HEADER_NOT_EXTRACTED;

3272: -- Don't set template line last run date so that after classification
3273: -- extraction is run, this template line will still be picked up.
3274: gSetTemplateLastRunDate := FALSE;
3275: END IF;
3276: gCurrentPrice.status := ICX_POR_EXT_DIAG.TEMPLATE_HEADER_NOT_EXTRACTED;
3277: END IF;
3278:
3279: IF ICX_POR_EXT_DIAG.isValidExtPrice(
3280: gCurrentPrice.document_type, gCurrentPrice.status,

Line 3279: IF ICX_POR_EXT_DIAG.isValidExtPrice(

3275: END IF;
3276: gCurrentPrice.status := ICX_POR_EXT_DIAG.TEMPLATE_HEADER_NOT_EXTRACTED;
3277: END IF;
3278:
3279: IF ICX_POR_EXT_DIAG.isValidExtPrice(
3280: gCurrentPrice.document_type, gCurrentPrice.status,
3281: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts,
3282: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines,
3283: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master,

Line 4532: IF (gCurrentPrice.status = ICX_POR_EXT_DIAG.UNPURCHASABLE_OUTSIDE) THEN

4528:
4529: -- Delete all price rows from ICX_CAT_ITEM_PRICES for an inventory item.
4530:
4531: IF gCurrentPrice.document_type = PURCHASING_ITEM_TYPE THEN
4532: IF (gCurrentPrice.status = ICX_POR_EXT_DIAG.UNPURCHASABLE_OUTSIDE) THEN
4533: xErrLoc := 200;
4534: xIndex := gDIPurchasingItemIds.COUNT + 1;
4535: gDIPurchasingItemIds(xIndex) := gCurrentPrice.internal_item_id;
4536: gDIPurchasingOrgIds(xIndex) := gCurrentPrice.org_id;

Line 4537: ELSIF (gCurrentPrice.status = ICX_POR_EXT_DIAG.ITEM_NO_PRICE) THEN

4533: xErrLoc := 200;
4534: xIndex := gDIPurchasingItemIds.COUNT + 1;
4535: gDIPurchasingItemIds(xIndex) := gCurrentPrice.internal_item_id;
4536: gDIPurchasingOrgIds(xIndex) := gCurrentPrice.org_id;
4537: ELSIF (gCurrentPrice.status = ICX_POR_EXT_DIAG.ITEM_NO_PRICE) THEN
4538: xErrLoc := 240;
4539: xIndex := gDINullPriceItemIds.COUNT + 1;
4540: gDINullPriceItemIds(xIndex) := gCurrentPrice.internal_item_id;
4541: gDINullPriceOrgIds(xIndex) := gCurrentPrice.org_id;

Line 5613: 'DECODE(doc.status, ' || ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT ||

5609: -- Here we can set active_flag for ITEM because it is based on
5610: -- inventory_item_id + org_id, not rt_item_id
5611: IF pType = 'ITEM' THEN
5612: xSelectStr := xSelectStr ||
5613: 'DECODE(doc.status, ' || ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT ||
5614: ', ICX_POR_EXT_ITEM.getItemActiveFlag(doc.internal_item_id, doc.org_id), ' ||
5615: 'NULL) active_flag, ';
5616: ELSE
5617: xSelectStr := xSelectStr ||

Line 5724: 'ICX_POR_EXT_DIAG.getTemplateLineStatus(prl.express_name, '||

5720: 'prl.item_revision, '||
5721: 'prl.line_type_id, '||
5722: 'prl.suggested_buyer_id buyer_id, '||
5723: 'TO_CHAR(NULL) global_agreement_flag, '||
5724: 'ICX_POR_EXT_DIAG.getTemplateLineStatus(prl.express_name, '||
5725: 'prl.sequence_num, prl.org_id, prh.inactive_date, '||
5726: 'prl.po_line_id, '''||ICX_POR_EXT_TEST.gTestMode||''') status ';
5727: xViewStr2 :=
5728: 'FROM icx_por_loader_values l, ';

Line 5960: 'ICX_POR_EXT_DIAG.getContractLineStatus(pl.po_line_id, '''||

5956: 'pl.item_revision, '||
5957: 'pl.line_type_id, '||
5958: 'ph.agent_id buyer_id, '||
5959: 'ph.global_agreement_flag, '||
5960: 'ICX_POR_EXT_DIAG.getContractLineStatus(pl.po_line_id, '''||
5961: ICX_POR_EXT_TEST.gTestMode||''') status ';
5962: xViewStr2 :=
5963: 'FROM icx_por_loader_values l, ';
5964: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

Line 6159: 'ICX_POR_EXT_DIAG.getASLStatus(pasl.asl_id, '||

6155: 'TO_CHAR(NULL) item_revision, '||
6156: 'TO_NUMBER(NULL) line_type_id, '||
6157: 'TO_NUMBER(NULL) buyer_id, '||
6158: 'TO_CHAR(NULL) global_agreement_flag, '||
6159: 'ICX_POR_EXT_DIAG.getASLStatus(pasl.asl_id, '||
6160: 'pasl.disable_flag, pasl.asl_status_id, '||
6161: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||
6162: ''') status ';
6163: xViewStr2 :=

Line 6273: 'ICX_POR_EXT_DIAG.getPurchasingItemStatus(mi.purchasing_enabled_flag, '||

6269: 'TO_NUMBER(NULL) line_type_id, '||
6270: 'TO_NUMBER(NULL) buyer_id, '||
6271: 'TO_CHAR(NULL) global_agreement_flag, '||
6272: 'DECODE(type.document_type, '||PURCHASING_ITEM_TYPE||', '||
6273: 'ICX_POR_EXT_DIAG.getPurchasingItemStatus(mi.purchasing_enabled_flag, '||
6274: 'mi.outside_operation_flag, '||
6275: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||'''), '||
6276: 'ICX_POR_EXT_DIAG.getInternalItemStatus(mi.internal_order_enabled_flag, '''||
6277: ICX_POR_EXT_TEST.gTestMode||''')) status ';

Line 6276: 'ICX_POR_EXT_DIAG.getInternalItemStatus(mi.internal_order_enabled_flag, '''||

6272: 'DECODE(type.document_type, '||PURCHASING_ITEM_TYPE||', '||
6273: 'ICX_POR_EXT_DIAG.getPurchasingItemStatus(mi.purchasing_enabled_flag, '||
6274: 'mi.outside_operation_flag, '||
6275: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||'''), '||
6276: 'ICX_POR_EXT_DIAG.getInternalItemStatus(mi.internal_order_enabled_flag, '''||
6277: ICX_POR_EXT_TEST.gTestMode||''')) status ';
6278: xViewStr2 :=
6279: 'FROM icx_por_loader_values l, ';
6280: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

Line 6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||

6400: 'AND ds3.category_key = ic3.key (+) '||
6401: 'AND ic3.type (+) = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||
6402: 'AND ic3.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6403: 'AND (p.rowid IS NOT NULL OR '||
6404: 'ICX_POR_EXT_DIAG.isValidExtPrice(doc.document_type, doc.status, '''||
6405: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6406: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6407: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||
6408: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item||''') = 1)';

Line 6546: 'ICX_POR_EXT_DIAG.getGlobalAgreementStatus(t.enabled_flag, '||

6542: 'ip.org_id, '||
6543: 'ip.contract_num ) rate, '||
6544: -- bug 2912717: populate line_type, rate info. for GA
6545: 'ip.line_type_id line_type_id, '||
6546: 'ICX_POR_EXT_DIAG.getGlobalAgreementStatus(t.enabled_flag, '||
6547: 'pvs.purchasing_site_flag, '||
6548: 'pvs.inactive_date, '||
6549: 'mi.purchasing_enabled_flag, '||
6550: 'mi.outside_operation_flag, '||

Line 6618: 'ICX_POR_EXT_DIAG.isValidExtPrice('||GLOBAL_AGREEMENT_TYPE||', '||

6614: 'AND doc.OrganizationId = p.org_id (+) '||
6615: 'AND doc.ContractLineId = p.contract_line_id (+) '||
6616: 'AND p.price_type (+) = ''GLOBAL_AGREEMENT'' '||
6617: 'AND (p.rowid IS NOT NULL OR '||
6618: 'ICX_POR_EXT_DIAG.isValidExtPrice('||GLOBAL_AGREEMENT_TYPE||', '||
6619: 'doc.status, '''||
6620: ICX_POR_EXTRACTOR.gLoaderValue.load_contracts||''', '''||
6621: ICX_POR_EXTRACTOR.gLoaderValue.load_template_lines||''', '''||
6622: ICX_POR_EXTRACTOR.gLoaderValue.load_item_master||''', '''||

Line 6692: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' status, '||

6688: 'TO_CHAR(NULL) item_revision, '||
6689: 'TO_NUMBER(NULL) line_type_id, '||
6690: 'TO_NUMBER(NULL) buyer_id, '||
6691: 'TO_CHAR(NULL) global_agreement_flag, '||
6692: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' status, '||
6693: 'TO_NUMBER(NULL) primary_category_id, '||
6694: 'TO_CHAR(NULL) primary_category_name, '||
6695: 'TO_NUMBER(NULL) template_category_id, '||
6696: 'TO_NUMBER(NULL) price_rt_item_id, '||

Line 7402: 'AND ICX_POR_EXT_DIAG.getPriceStatus(p.price_type, p.rowid, '''||

7398: 'icx_cat_categories_tl ic '||
7399: 'WHERE p.price_type IN (''TEMPLATE'', ''INTERNAL_TEMPLATE'', ' ||
7400: ' ''BLANKET'', ''QUOTATION'', ''GLOBAL_AGREEMENT'', ''ASL'', ' ||
7401: ' ''PURCHASING_ITEM'', ''INTERNAL_ITEM'') ' ||
7402: 'AND ICX_POR_EXT_DIAG.getPriceStatus(p.price_type, p.rowid, '''||
7403: ICX_POR_EXT_TEST.gTestMode||''') <> '||
7404: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' '||
7405: 'AND p.template_id||''_tmpl'' = ic.key (+) '||
7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||

Line 7404: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' '||

7400: ' ''BLANKET'', ''QUOTATION'', ''GLOBAL_AGREEMENT'', ''ASL'', ' ||
7401: ' ''PURCHASING_ITEM'', ''INTERNAL_ITEM'') ' ||
7402: 'AND ICX_POR_EXT_DIAG.getPriceStatus(p.price_type, p.rowid, '''||
7403: ICX_POR_EXT_TEST.gTestMode||''') <> '||
7404: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' '||
7405: 'AND p.template_id||''_tmpl'' = ic.key (+) '||
7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
7407: 'AND ic.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';
7408: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN