APPS.ICX_POR_EXT_ITEM dependencies on ICX_POR_EXT_CLASS

Line 2837: AND c.type = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE);

2833: WHERE rt_item_id = xRtItemIds(i)
2834: AND EXISTS (SELECT 'template header'
2835: FROM icx_cat_categories_tl c
2836: WHERE c.rt_category_id = ci.rt_category_id
2837: AND c.type = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE);
2838:
2839: xErrLoc := 560;
2840: ICX_POR_EXT_UTL.extAFCommit;
2841: END LOOP;

Line 6367: 'AND ic1.type = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||

6363: xWhereStr :=
6364: 'WHERE ic1.key = ds1.category_key '||
6365: 'AND ds1.external_source_key = doc.category_key '||
6366: 'AND ds1.external_source = ''Oracle'' ' ||
6367: 'AND ic1.type = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||
6368: 'AND ic1.language = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';
6369: IF pType = 'TEMPLATE' THEN
6370: xWhereStr := xWhereStr ||
6371: 'AND doc.template_id||''_tmpl'' = ds2.external_source_key (+) '||

Line 6374: 'AND ic2.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||

6370: xWhereStr := xWhereStr ||
6371: 'AND doc.template_id||''_tmpl'' = ds2.external_source_key (+) '||
6372: 'AND ds2.external_source (+) = ''Oracle'' ' ||
6373: 'AND ds2.category_key = ic2.key (+) '||
6374: 'AND ic2.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
6375: 'AND ic2.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' '||
6376: 'AND doc.template_id = p.template_id (+) '||
6377: 'AND doc.template_line_id = p.template_line_id (+) ';
6378: ELSIF pType = 'CONTRACT' THEN

Line 6401: 'AND ic3.type (+) = '||ICX_POR_EXT_CLASS.CATEGORY_TYPE||' '||

6397: 'AND i.rt_item_id (+) = p.rt_item_id '||
6398: 'AND to_char(p.mtl_category_id) = ds3.external_source_key (+) '||
6399: 'AND ds3.external_source (+) = ''Oracle'' ' ||
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||''', '''||

Line 7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||

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
7409: xString := xString ||
7410: 'AND p.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';