APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_TMP_ITEMCAT

Line 2127: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;

2123: ITEM_CATALOG_GROUP_ID = -1 AND
2124: ATTR_ID = -1 AND
2125: APPLICATION_ID = -1;
2126:
2127: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2128: COMMIT;
2129:
2130: --
2131: -- if list of item catalog group is empty or stub views are used then just return

Line 2172: INSERT INTO CZ_IMP_TMP_ITEMCAT(run_id, item_catalog_group_id)

2168: END IF;
2169:
2170: END LOOP;
2171:
2172: INSERT INTO CZ_IMP_TMP_ITEMCAT(run_id, item_catalog_group_id)
2173: SELECT p_run_id,item_catalog_group_id
2174: FROM (SELECT DISTINCT item_catalog_group_id
2175: FROM TABLE(CAST(l_prev_item_catalog_tbl AS SYSTEM.CZ_ITEM_CATALOG_TBL)) WHERE item_catalog_group_id IS NOT NULL);
2176:

Line 2197: CZ_IMP_TMP_ITEMCAT itemtypes

2193: FOR attr IN(SELECT attr_group_id, attr_group_name||'.'||attr_name AS attribute_name,
2194: DECODE(data_type_code,'N',DECIMAL_TYPE,'C',TEXT_TYPE,'A',TL_TEXT_TYPE,TEXT_TYPE) AS property_type,
2195: database_column,description,apcprops.item_catalog_group_id,apcprops.default_value
2196: FROM CZ_EXV_APC_PROPERTIES apcprops,
2197: CZ_IMP_TMP_ITEMCAT itemtypes
2198: WHERE apcprops.item_catalog_group_id=itemtypes.item_catalog_group_id AND
2199: itemtypes.run_id=p_run_id
2200: ORDER BY attr_group_id)
2201: LOOP

Line 2223: DELETE FROM CZ_IMP_TMP_ITEMCAT where run_id=p_run_id;

2219:
2220: END LOOP;
2221:
2222: IF l_attr_name_tbl.COUNT = 0 THEN
2223: DELETE FROM CZ_IMP_TMP_ITEMCAT where run_id=p_run_id;
2224: RETURN;
2225: END IF;
2226:
2227: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2229: 'APC meta data have been retrieved ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2230: fnd_log.LEVEL_STATEMENT);
2231: END IF;
2232:
2233: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)
2234: LOOP
2235: IF l_hier_item_cat_tbl.EXISTS(ii.item_catalog_group_id) THEN
2236:
2237: l_item_cat_tbl := l_hier_item_cat_tbl(ii.item_catalog_group_id);

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

2303: G_EGO_APPLICATION_ID);
2304:
2305: COMMIT;
2306:
2307: FOR ii IN (SELECT item_catalog_group_id FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id)
2308: LOOP
2309: IF l_attr_item_cat_tbl.EXISTS(ii.item_catalog_group_id) THEN
2310: l_attr_list_temp_tbl := l_attr_item_cat_tbl(ii.item_catalog_group_id);
2311:

Line 2411: 'CZ_IMP_TMP_ITEMCAT itemtypes '||

2407: fnd_log.LEVEL_STATEMENT);
2408: END IF;
2409:
2410: l_sql := 'SELECT apcpropvals.* FROM CZ_EXV_ITEM_APC_PROP_VALUES apcpropvals,'||
2411: 'CZ_IMP_TMP_ITEMCAT itemtypes '||
2412: 'WHERE apcpropvals.item_catalog_group_id = itemtypes.item_catalog_group_id AND inventory_item_id IS NOT NULL ORDER BY INVENTORY_ITEM_ID';
2413: --
2414: -- define cursor and dynamically describe columns of this cursor
2415: --

Line 2581: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;

2577:
2578: -- close cursor
2579: DBMS_SQL.CLOSE_CURSOR(l_cursor);
2580:
2581: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2582: COMMIT;
2583:
2584: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2585: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

Line 2592: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;

2588: END IF;
2589:
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: DELETE FROM CZ_IMP_TMP_ITEMCAT WHERE run_id=p_run_id;
2593: COMMIT;
2594: l_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'EXTR_APC_PROPERTIES',11276,p_run_id);
2595: RAISE;
2596: END EXTR_APC_PROPERTIES;