APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FND_LANGUAGES

Line 557: FND_LANGUAGES L

553: , L.LANGUAGE_CODE
554: , USERENV('LANG')
555: FROM FND_NEW_MESSAGES M1,
556: FND_NEW_MESSAGES M2,
557: FND_LANGUAGES L
558: WHERE L.INSTALLED_FLAG IN ('I', 'B')
559: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME
560: AND M1.LANGUAGE_CODE (+)= L.LANGUAGE_CODE
561: AND M2.MESSAGE_NAME (+)= l_interface_cols_tbl(i).USER_HINT_FND_MESSAGE_NAME

Line 878: , FND_LANGUAGES L

874: FROM FEM_XDIM_DIMENSIONS_VL D
875: , FEM_DIM_ATTRIBUTES_B A
876: , FEM_DIM_ATTRIBUTES_TL B
877: , FND_NEW_MESSAGES M
878: , FND_LANGUAGES L
879: WHERE L.INSTALLED_FLAG IN ('I', 'B')
880: AND D.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
881: AND D.DIMENSION_ID = A.DIMENSION_ID
882: AND A.ATTRIBUTE_VARCHAR_LABEL = dt_changed_rec.ATTRIBUTE_VARCHAR_LABEL

Line 1045: , FND_LANGUAGES L

1041: FROM FEM_XDIM_DIMENSIONS_VL D
1042: , FEM_DIM_ATTRIBUTES_B A
1043: , FEM_DIM_ATTRIBUTES_TL B
1044: , FND_NEW_MESSAGES M
1045: , FND_LANGUAGES L
1046: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1047: AND D.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
1048: AND D.DIMENSION_ID = A.DIMENSION_ID
1049: AND A.ATTRIBUTE_VARCHAR_LABEL = changed_rec.ATTRIBUTE_VARCHAR_LABEL

Line 1259: , FND_LANGUAGES L

1255: FROM FEM_XDIM_DIMENSIONS_VL D
1256: , FEM_DIM_ATTRIBUTES_B A
1257: , FEM_DIM_ATTRIBUTES_TL B
1258: , FND_NEW_MESSAGES M
1259: , FND_LANGUAGES L
1260: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1261: AND D.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
1262: AND D.DIMENSION_ID = A.DIMENSION_ID
1263: AND A.ATTRIBUTE_VARCHAR_LABEL = changed_rec.ATTRIBUTE_VARCHAR_LABEL

Line 1383: FROM FND_LANGUAGES L

1379: , l_max_sequence_num
1380: , 274
1381: , L.LANGUAGE_CODE
1382: , USERENV('LANG')
1383: FROM FND_LANGUAGES L
1384: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1385:
1386: END LOOP;
1387:

Line 1575: , FND_LANGUAGES L

1571: , DT.SOURCE_LANG
1572: FROM FEM_DIMENSIONS_TL DT
1573: , FEM_DIMENSIONS_B DB
1574: , FND_NEW_MESSAGES M
1575: , FND_LANGUAGES L
1576: WHERE DB.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
1577: AND DT.DIMENSION_ID = DB.DIMENSION_ID
1578: AND M.APPLICATION_ID= 274
1579: AND M.MESSAGE_NAME = 'FEM_ADI_MEMBER_LAYOUT'

Line 1705: FND_LANGUAGES L

1701: , SYSDATE
1702: , L.LANGUAGE_CODE
1703: , USERENV('LANG')
1704: FROM FND_NEW_MESSAGES M,
1705: FND_LANGUAGES L
1706: WHERE M.MESSAGE_NAME = 'LAY_LB_HEADER'
1707: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
1708: AND L.INSTALLED_FLAG IN ('I', 'B');
1709:

Line 1839: FND_LANGUAGES L

1835: , SYSDATE
1836: , L.LANGUAGE_CODE
1837: , USERENV('LANG')
1838: FROM FND_NEW_MESSAGES M,
1839: FND_LANGUAGES L
1840: WHERE M.MESSAGE_NAME = 'LAY_LB_LINE'
1841: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
1842: AND L.INSTALLED_FLAG IN ('I', 'B');
1843:

Line 2452: FND_LANGUAGES L

2448: , SYSDATE
2449: , l_user_id
2450: , SYSDATE
2451: FROM FND_NEW_MESSAGES M,
2452: FND_LANGUAGES L
2453: WHERE M.MESSAGE_NAME = 'FEM_ADI_MEMBER_INTEGRATOR'
2454: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
2455: AND L.INSTALLED_FLAG IN ('I', 'B');
2456: END IF;

Line 2559: FROM FEM_DIMENSIONS_TL D, FND_NEW_MESSAGES M, FND_LANGUAGES L

2555: , l_user_id
2556: , SYSDATE
2557: , l_user_id
2558: , SYSDATE
2559: FROM FEM_DIMENSIONS_TL D, FND_NEW_MESSAGES M, FND_LANGUAGES L
2560: WHERE D.DIMENSION_ID = l_dimension_id
2561: AND M.APPLICATION_ID= 274
2562: AND M.MESSAGE_NAME = 'FEM_ADI_MEMBER_INTERFACE'
2563: AND M.LANGUAGE_CODE = D.LANGUAGE