APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FEM_DIMENSIONS_TL

Line 1572: FROM FEM_DIMENSIONS_TL DT

1568: , l_login_id
1569: , SYSDATE
1570: , DT.LANGUAGE
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

Line 2314: FEM_DIMENSIONS_TL.DIMENSION_NAME%TYPE index by BINARY_INTEGER;

2310: l_msg_count NUMBER ;
2311: l_msg_data VARCHAR2(2000) ;
2312:
2313: TYPE l_dim_name_tbl_type is TABLE of
2314: FEM_DIMENSIONS_TL.DIMENSION_NAME%TYPE index by BINARY_INTEGER;
2315:
2316: TYPE l_dim_lang_tbl_type is TABLE of
2317: FEM_DIMENSIONS_TL.LANGUAGE%TYPE index by BINARY_INTEGER;
2318:

Line 2317: FEM_DIMENSIONS_TL.LANGUAGE%TYPE index by BINARY_INTEGER;

2313: TYPE l_dim_name_tbl_type is TABLE of
2314: FEM_DIMENSIONS_TL.DIMENSION_NAME%TYPE index by BINARY_INTEGER;
2315:
2316: TYPE l_dim_lang_tbl_type is TABLE of
2317: FEM_DIMENSIONS_TL.LANGUAGE%TYPE index by BINARY_INTEGER;
2318:
2319: TYPE l_dim_src_lang_tbl_type is TABLE of
2320: FEM_DIMENSIONS_TL.SOURCE_LANG%TYPE index by BINARY_INTEGER;
2321:

Line 2320: FEM_DIMENSIONS_TL.SOURCE_LANG%TYPE index by BINARY_INTEGER;

2316: TYPE l_dim_lang_tbl_type is TABLE of
2317: FEM_DIMENSIONS_TL.LANGUAGE%TYPE index by BINARY_INTEGER;
2318:
2319: TYPE l_dim_src_lang_tbl_type is TABLE of
2320: FEM_DIMENSIONS_TL.SOURCE_LANG%TYPE index by BINARY_INTEGER;
2321:
2322: BEGIN
2323: --
2324: SAVEPOINT Dim_WebADI_Metadata_Pvt ;

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