DBA Data[Home] [Help]

APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FND_TABLE_OF_NUMBER

Line 2978: l_avlbl_attrseq_tbl FND_TABLE_OF_NUMBER := FND_TABLE_OF_NUMBER() ;

2974: l_used_seq_flag BOOLEAN := FALSE ;
2975: --
2976: l_data_type_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30() ;
2977: l_attr_label_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30() ;
2978: l_avlbl_attrseq_tbl FND_TABLE_OF_NUMBER := FND_TABLE_OF_NUMBER() ;
2979: --
2980: -- Retrieve all mappings for which datatypes are not matching
2981: -- with corresponding record in dim attribute table for the
2982: -- input dimension varchar label.

Line 3030: TABLE( CAST( g_sequences_tbl AS FND_TABLE_OF_NUMBER ) ) avlble_seq

3026: IS
3027: SELECT
3028: VALUE(avlble_seq) col_map_seq
3029: FROM
3030: TABLE( CAST( g_sequences_tbl AS FND_TABLE_OF_NUMBER ) ) avlble_seq
3031: MINUS
3032: SELECT
3033: TO_NUMBER( SUBSTR( attrmap.interface_col, 12 ) ) col_map_seq
3034: FROM