[Home] [Help]
1741: xActiveFlag VARCHAR2(1) := 'N';
1742: BEGIN
1743: SELECT 'N'
1744: INTO xActiveFlag
1745: FROM dual
1746: WHERE EXISTS (SELECT 'documents'
1747: FROM icx_cat_item_prices p
1748: WHERE p.org_id = p_org_id
1749: AND p.inventory_item_id = p_inventory_item_id
1864: -- If an active bulkload price is deleted, should set
1865: -- ASL back to active
1866: SELECT 'A'
1867: INTO xActiveFlag
1868: FROM dual
1869: WHERE EXISTS (SELECT 'ASL prices'
1870: FROM icx_cat_item_prices
1871: WHERE rt_item_id = p_rt_item_id
1872: AND price_type = 'ASL')
3374: THEN
3375: xErrLoc := 620;
3376: SELECT icx_por_itemid.nextval
3377: INTO xRtItemId
3378: FROM dual;
3379: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
3380: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
3381: 'Create new rt_item_id: ' || xRtItemId);
3382: END IF;
3450:
3451: xErrLoc := 620;
3452: SELECT icx_por_itemid.nextval
3453: INTO xRtItemId
3454: FROM dual;
3455: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
3456: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
3457: 'Create new rt_item_id: ' || xRtItemId);
3458: END IF;
6296: 'mtl_units_of_measure_tl muom, '||
6297: '(SELECT '||PURCHASING_ITEM_TYPE||' document_type, '||
6298: '''PURCHASING_ITEM'' price_type, '||
6299: '''SUPPLIER'' price_search_type '||
6300: 'FROM dual '||
6301: 'UNION ALL '||
6302: 'SELECT '||INTERNAL_ITEM_TYPE||' document_type, '||
6303: '''INTERNAL_ITEM'' price_type, '||
6304: '''INTERNAL'' price_search_type '||
6301: 'UNION ALL '||
6302: 'SELECT '||INTERNAL_ITEM_TYPE||' document_type, '||
6303: '''INTERNAL_ITEM'' price_type, '||
6304: '''INTERNAL'' price_search_type '||
6305: 'FROM dual) type '||
6306: -- Bug#3213218/3163334 : pcreddy - Check for the load flag to be 'Y'.
6307: 'WHERE ( (l.load_item_master = ''Y'' AND ' ||
6308: ' l.item_master_last_run_date IS NULL) OR ' ||
6309: ' (l.load_internal_item = ''Y'' AND ' ||
7490: FORALL i IN 1..gDPLocalRtItemIds.COUNT
7491: INSERT INTO icx_cat_extract_gt
7492: (rt_item_id, type)
7493: SELECT gDPLocalRtItemIds(i), 'ACTIVE_FLAG'
7494: FROM dual
7495: WHERE gDPLocalRtItemIds(i) IS NOT NULL;
7496:
7497: clearTables(xActionMode);
7498: