APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on ICX_CAT_DESCRIPTORS_TL

Line 7567: FROM icx_cat_descriptors_tl

7563: l_suffix := l_suffix + 1;
7564: BEGIN
7565: SELECT 1
7566: INTO l_temp
7567: FROM icx_cat_descriptors_tl
7568: WHERE UPPER(key) = l_newKey;
7569: EXCEPTION
7570: WHEN NO_DATA_FOUND THEN
7571: --The current l_newKey is distinct, return it

Line 7588: FROM icx_cat_descriptors_tl

7584: -- PURCHASING_CATEGORY
7585: -- ITEM_REVISION
7586: CURSOR checkIcxCatDescriptorsTlCsr IS
7587: SELECT rt_descriptor_id, UPPER(key)
7588: FROM icx_cat_descriptors_tl
7589: WHERE UPPER(key) IN ('SOURCE',
7590: 'SHOPPING_CATEGORY',
7591: 'PURCHASING_CATEGORY',
7592: 'ITEM_REVISION')

Line 7671: ', to :' || l_new_key || ' in icx_cat_descriptors_tl for rt_descriptor_id :' ||

7667: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7669: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7670: 'changing descriptor key from:' || l_key_tbl(i) ||
7671: ', to :' || l_new_key || ' in icx_cat_descriptors_tl for rt_descriptor_id :' ||
7672: l_rt_descriptor_id_tbl(i));
7673: END IF;
7674: END IF;
7675: END LOOP;

Line 7679: UPDATE icx_cat_descriptors_tl

7675: END LOOP;
7676:
7677: l_err_loc := 1600;
7678: FORALL i IN 1..l_upd_rt_descriptor_id_tbl.COUNT
7679: UPDATE icx_cat_descriptors_tl
7680: SET key = l_upd_key_tbl(i)
7681: WHERE rt_descriptor_id = l_upd_rt_descriptor_id_tbl(i);
7682:
7683: l_err_loc := 1700;

Line 7711: icx_cat_descriptors_tl des1

7707: des1.rebuild_flag, des1.section_tag,
7708: DECODE(des1.type, 2, 'PO_ATTRIBUTE_VALUES_TLP', 'PO_ATTRIBUTE_VALUES'),
7709: des1.stored_in_column
7710: FROM
7711: icx_cat_descriptors_tl des1
7712: WHERE des1.rt_descriptor_id > 100
7713: AND NOT EXISTS (SELECT NULL FROM icx_cat_attributes_tl des2
7714: WHERE des1.rt_descriptor_id = des2.attribute_id
7715: AND des1.language = des2.language)