APPS.ICX_CAT_FPI_UPGRADE dependencies on FND_LANGUAGES

Line 375: FROM fnd_languages

371: stored_in_column
372: FROM icx_cat_descriptors_tl
373: WHERE rt_category_id = cpRtCategoryId
374: AND language = (SELECT language_code
375: FROM fnd_languages
376: WHERE installed_flag = 'B');
377:
378: xRtDescriptorIds DBMS_SQL.NUMBER_TABLE;
379: xKeys DBMS_SQL.VARCHAR2_TABLE;

Line 1313: FROM fnd_languages

1309: UPDATE ICX_CAT_ITEMS_TLP
1310: SET description = gITItemDescriptions(i)
1311: WHERE rt_item_id = gITRtItemIds(i)
1312: AND language = (SELECT language_code
1313: FROM fnd_languages
1314: WHERE installed_flag = 'B');
1315:
1316: COMMIT;
1317:

Line 1369: FROM fnd_languages

1365: FROM ICX_POR_CATEGORIES_TL cat
1366: WHERE cat.key = gCITemplateIds(i) || '_tmpl'
1367: AND cat.type = 3
1368: AND cat.language = (SELECT language_code
1369: FROM fnd_languages
1370: WHERE installed_flag = 'B');
1371:
1372: COMMIT;
1373:

Line 1615: FROM fnd_languages

1611: SELECT cat.rt_category_id
1612: FROM icx_cat_categories_tl cat
1613: WHERE cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE
1614: AND cat.language = (SELECT language_code
1615: FROM fnd_languages
1616: WHERE installed_flag = 'B')
1617: AND EXISTS (SELECT 'category attributes'
1618: FROM icx_por_descriptors_tl des
1619: WHERE des.rt_category_id = cat.rt_category_id)

Line 1888: FROM fnd_languages

1884: 'create missing purchasing item prices');
1885:
1886: xErrLoc := 101;
1887: SELECT language_code INTO xLanguage
1888: FROM fnd_languages
1889: WHERE installed_flag = 'B';
1890:
1891: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1892: 'base language:' ||xLanguage);