APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on ICX_CAT_ATTRIBUTES_TL

Line 7600: FROM icx_cat_attributes_tl

7596: -- Cursor to check the searchable for some of the descritpors that can never be made
7597: -- searchable in R12.
7598: CURSOR checkSrchbleForSpecAttrsCsr IS
7599: SELECT attribute_id, key
7600: FROM icx_cat_attributes_tl
7601: WHERE key IN ('PURCHASING_CATEGORY',
7602: 'THUMBNAIL_IMAGE',
7603: 'SUPPLIER_SITE',
7604: 'PICTURE',

Line 7639: FROM icx_cat_attributes_tl

7635: SELECT 1
7636: INTO l_is_attr_already_upgraded
7637: FROM dual
7638: WHERE EXISTS (SELECT 'attribute records'
7639: FROM icx_cat_attributes_tl
7640: WHERE attribute_id > 100);
7641: EXCEPTION
7642: WHEN NO_DATA_FOUND THEN
7643: l_is_attr_already_upgraded := -1;

Line 7686: INSERT INTO icx_cat_attributes_tl

7682:
7683: l_err_loc := 1700;
7684: COMMIT;
7685:
7686: INSERT INTO icx_cat_attributes_tl
7687: (
7688: attribute_id, language, source_lang,
7689: attribute_name, description, rt_category_id, type,
7690: sequence, key,

Line 7713: AND NOT EXISTS (SELECT NULL FROM icx_cat_attributes_tl des2

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)
7716: );
7717:

Line 7722: 'No: of rows inserted into icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);

7718: l_err_loc := 300;
7719: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7720: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7721: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7722: 'No: of rows inserted into icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);
7723: END IF;
7724:
7725: IF (l_is_attr_already_upgraded = -1) THEN
7726: l_err_loc := 400;

Line 7748: UPDATE icx_cat_attributes_tl

7744: END IF;
7745:
7746: l_err_loc := 800;
7747: FORALL i IN 1..l_attribute_id_tbl.COUNT
7748: UPDATE icx_cat_attributes_tl
7749: SET searchable = 0
7750: WHERE attribute_id = l_attribute_id_tbl(i);
7751:
7752: l_err_loc := 850;

Line 7756: 'No: of rows updated with searchable=0 in icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);

7752: l_err_loc := 850;
7753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7755: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7756: 'No: of rows updated with searchable=0 in icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);
7757: END IF;
7758: END IF;
7759:
7760: l_err_loc := 900;