APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_TMP_ITEMCAT

Line 2189: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;

2185: ITEM_CATALOG_GROUP_ID = -1 AND
2186: ATTR_ID = -1 AND
2187: APPLICATION_ID = -1;
2188:
2189: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2190: COMMIT;
2191:
2192: --
2193: -- if list of item catalog group is empty or stub views are used then just return

Line 2234: INSERT INTO CZ_IMP_TMP_ITEMCAT(run_id, item_catalog_group_id)

2230: END IF;
2231:
2232: END LOOP;
2233:
2234: INSERT INTO CZ_IMP_TMP_ITEMCAT(run_id, item_catalog_group_id)
2235: SELECT p_run_id,item_catalog_group_id
2236: FROM (SELECT DISTINCT item_catalog_group_id
2237: FROM TABLE(CAST(l_prev_item_catalog_tbl AS SYSTEM.CZ_ITEM_CATALOG_TBL)) WHERE item_catalog_group_id IS NOT NULL);
2238:

Line 2259: CZ_IMP_TMP_ITEMCAT itemtypes

2255: FOR attr IN(SELECT attr_group_id, attr_group_name||'.'||attr_name AS attribute_name,
2256: DECODE(data_type_code,'N',DECIMAL_TYPE,'C',TEXT_TYPE,'A',TL_TEXT_TYPE,TEXT_TYPE) AS property_type,
2257: database_column,description,apcprops.item_catalog_group_id,apcprops.default_value
2258: FROM CZ_EXV_APC_PROPERTIES apcprops,
2259: CZ_IMP_TMP_ITEMCAT itemtypes
2260: WHERE apcprops.item_catalog_group_id=itemtypes.item_catalog_group_id AND
2261: itemtypes.run_id=p_run_id
2262: ORDER BY attr_group_id)
2263: LOOP

Line 2285: DELETE FROM CZ_IMP_TMP_ITEMCAT where run_id=p_run_id;

2281:
2282: END LOOP;
2283:
2284: IF l_attr_name_tbl.COUNT = 0 THEN
2285: DELETE FROM CZ_IMP_TMP_ITEMCAT where run_id=p_run_id;
2286: RETURN;
2287: END IF;
2288:
2289: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2295: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)

2291: 'APC meta data have been retrieved ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2292: fnd_log.LEVEL_STATEMENT);
2293: END IF;
2294:
2295: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)
2296: LOOP
2297: IF l_hier_item_cat_tbl.EXISTS(ii.item_catalog_group_id) THEN
2298:
2299: l_item_cat_tbl := l_hier_item_cat_tbl(ii.item_catalog_group_id);

Line 2369: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)

2365: G_EGO_APPLICATION_ID);
2366:
2367: COMMIT;
2368:
2369: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)
2370: LOOP
2371: IF l_attr_item_cat_tbl.EXISTS(ii.item_catalog_group_id) THEN
2372: l_attr_list_temp_tbl := l_attr_item_cat_tbl(ii.item_catalog_group_id);
2373:

Line 2474: 'CZ_IMP_TMP_ITEMCAT itemtypes '||

2470: END IF;
2471:
2472: ---Bug Fix - 8519380
2473: l_sql := 'SELECT apcpropvals.* FROM CZ_EXV_ITEM_APC_PROP_VALUES apcpropvals,'||
2474: 'CZ_IMP_TMP_ITEMCAT itemtypes '||
2475: 'WHERE apcpropvals.item_catalog_group_id = itemtypes.item_catalog_group_id '||
2476: 'AND EXISTS (SELECT NULL FROM CZ_EXV_ITEMS '||
2477: 'WHERE inventory_item_id = apcpropvals.inventory_item_id '||
2478: ' AND organization_id = '|| p_org_id ||

Line 2651: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;

2647:
2648: -- close cursor
2649: DBMS_SQL.CLOSE_CURSOR(l_cursor);
2650:
2651: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2652: COMMIT;
2653:
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

Line 2662: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;

2658: END IF;
2659:
2660: EXCEPTION
2661: WHEN OTHERS THEN
2662: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2663: COMMIT;
2664: l_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'EXTR_APC_PROPERTIES',11276,p_run_id);
2665: RAISE;
2666: END EXTR_APC_PROPERTIES;