461: , l_user_id
462: , SYSDATE
463: , l_user_id
464: , SYSDATE
465: FROM FEM_TABLES_TL T, FND_NEW_MESSAGES M, FND_LANGUAGES L
466: WHERE T.TABLE_NAME = p_table_name
467: AND M.APPLICATION_ID= 274
468: AND M.MESSAGE_NAME = 'FEM_ADI_TABLES_INTERFACE'
469: AND M.LANGUAGE_CODE = T.LANGUAGE
600: , SYSDATE
601: , l_user_id
602: , 0
603: , SYSDATE
604: FROM FEM_TABLES_TL T, FND_NEW_MESSAGES M, FND_LANGUAGES L
605: WHERE T.TABLE_NAME = p_table_name
606: AND M.APPLICATION_ID= 274
607: AND M.MESSAGE_NAME = 'FEM_ADI_TABLES_MAPPING'
608: AND M.LANGUAGE_CODE = T.LANGUAGE
730: , l_login_id
731: , SYSDATE
732: , T.LANGUAGE
733: , T.SOURCE_LANG
734: FROM FEM_TABLES_TL T,FND_NEW_MESSAGES M,FND_LANGUAGES L
735: WHERE T.TABLE_NAME = p_table_name
736: AND M.APPLICATION_ID= 274
737: AND M.MESSAGE_NAME = 'FEM_ADI_TABLES_LAYOUT'
738: AND M.LANGUAGE_CODE = T.LANGUAGE
860: , l_login_id
861: , SYSDATE
862: , L.LANGUAGE_CODE
863: , USERENV('LANG')
864: FROM FND_NEW_MESSAGES M,
865: FND_LANGUAGES L
866: WHERE M.MESSAGE_NAME = 'LAY_LB_HEADER'
867: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
868: AND L.INSTALLED_FLAG IN ('I', 'B');
994: , l_login_id
995: , SYSDATE
996: , L.LANGUAGE_CODE
997: , USERENV('LANG')
998: FROM FND_NEW_MESSAGES M,
999: FND_LANGUAGES L
1000: WHERE M.MESSAGE_NAME = 'LAY_LB_LINE'
1001: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
1002: AND L.INSTALLED_FLAG IN ('I', 'B');
1459: , L.LANGUAGE_CODE
1460: , TL.SOURCE_LANG
1461: FROM FEM_TAB_COLUMNS_B TB
1462: , FEM_TAB_COLUMNS_TL TL
1463: , FND_NEW_MESSAGES M
1464: , FND_LANGUAGES L
1465: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1466: AND TB.COLUMN_NAME = new_rec.column_name
1467: AND TB.TABLE_NAME = l_table_name -- substr(p_interface_code,0,instr(p_interface_code,'_INTF')-1)
1507: , L.LANGUAGE_CODE
1508: , TL.SOURCE_LANG
1509: FROM FEM_TAB_COLUMNS_B TB
1510: , FEM_TAB_COLUMNS_TL TL
1511: , FND_NEW_MESSAGES M
1512: , FND_LANGUAGES L
1513: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1514: AND TB.COLUMN_NAME = new_rec.column_name
1515: AND TB.TABLE_NAME = l_table_name -- substr(p_interface_code,0,instr(p_interface_code,'_INTF')-1)
1954: , l_interface_cols_tbl(i).SEQUENCE_NUM
1955: , 274
1956: , L.LANGUAGE_CODE
1957: , USERENV('LANG')
1958: FROM FND_NEW_MESSAGES M1,
1959: FND_NEW_MESSAGES M2,
1960: FND_LANGUAGES L
1961: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1962: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME
1955: , 274
1956: , L.LANGUAGE_CODE
1957: , USERENV('LANG')
1958: FROM FND_NEW_MESSAGES M1,
1959: FND_NEW_MESSAGES M2,
1960: FND_LANGUAGES L
1961: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1962: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME
1963: AND M1.LANGUAGE_CODE (+)= L.LANGUAGE_CODE