APPS.GMA_EDITEXT_ATTACH_MIG dependencies on FND_LANGUAGES

Line 49: FROM SY_PARA_CDS_TL T, FND_LANGUAGES L

45: T.LANG_CODE,
46: T.PARA_DESC,
47: T.SOURCE_LANG,
48: T.LANGUAGE
49: FROM SY_PARA_CDS_TL T, FND_LANGUAGES L
50: WHERE t.TABLE_NAME=x_table_name
51: AND t.paragraph_code = x_paragraph_code
52: AND t.sub_paracode = x_sub_paracode
53: AND t.language = l.language_code

Line 95: -- Enable all languages if not in FND_LANGUAGES

91:
92:
93: l_para_count := l_para_count + 1;
94:
95: -- Enable all languages if not in FND_LANGUAGES
96: GMA_EDITEXT_ATTACH_MIG.Fnd_Document_Set_Languages
97: (
98: p_text_code => p_text_code,
99: p_sy_para_cds_table_name => p_sy_para_cds_table_name,

Line 299: FROM SY_PARA_CDS_TL B, FND_LANGUAGES L

295: B.PARAGRAPH_CODE,
296: B.SUB_PARACODE,
297: B.PARA_DESC,
298: B.language
299: FROM SY_PARA_CDS_TL B, FND_LANGUAGES L
300: WHERE L.INSTALLED_FLAG IN ('B')
301: AND B.PARAGRAPH_CODE=x_paragraph_code
302: AND B.SUB_PARACODE=x_sub_paracode
303: AND B.TABLE_NAME=x_table_name --'IC_ITEM_MST'

Line 527: UPDATE FND_LANGUAGES

523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);
524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);
525: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_lang_code);
526:
527: UPDATE FND_LANGUAGES
528: set installed_flag='I'
529: WHERE
530: language_code=l_language
531: AND installed_flag not in('I','B');