eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FND_TABLE_OF_VARCHAR2_30

Line 20: g_initialized_table FND_TABLE_OF_VARCHAR2_30

16: -- Declare Object types --
17: --------------------------
18: --
19: -- Initialized table to clean above two collections.
20: g_initialized_table FND_TABLE_OF_VARCHAR2_30
21: := FND_TABLE_OF_VARCHAR2_30() ;
22: --
23: -- Declare variables to hold Map table column values.
24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30

Line 21: := FND_TABLE_OF_VARCHAR2_30() ;

17: --------------------------
18: --
19: -- Initialized table to clean above two collections.
20: g_initialized_table FND_TABLE_OF_VARCHAR2_30
21: := FND_TABLE_OF_VARCHAR2_30() ;
22: --
23: -- Declare variables to hold Map table column values.
24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30
25: := FND_TABLE_OF_VARCHAR2_30() ;

Line 24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30

20: g_initialized_table FND_TABLE_OF_VARCHAR2_30
21: := FND_TABLE_OF_VARCHAR2_30() ;
22: --
23: -- Declare variables to hold Map table column values.
24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30
25: := FND_TABLE_OF_VARCHAR2_30() ;
26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30

Line 25: := FND_TABLE_OF_VARCHAR2_30() ;

21: := FND_TABLE_OF_VARCHAR2_30() ;
22: --
23: -- Declare variables to hold Map table column values.
24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30
25: := FND_TABLE_OF_VARCHAR2_30() ;
26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;

Line 26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30

22: --
23: -- Declare variables to hold Map table column values.
24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30
25: := FND_TABLE_OF_VARCHAR2_30() ;
26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30

Line 27: := FND_TABLE_OF_VARCHAR2_30() ;

23: -- Declare variables to hold Map table column values.
24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30
25: := FND_TABLE_OF_VARCHAR2_30() ;
26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;

Line 28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30

24: g_dim_varchar_label_tbl FND_TABLE_OF_VARCHAR2_30
25: := FND_TABLE_OF_VARCHAR2_30() ;
26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;
32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30

Line 29: := FND_TABLE_OF_VARCHAR2_30() ;

25: := FND_TABLE_OF_VARCHAR2_30() ;
26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;
32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30
33: := FND_TABLE_OF_VARCHAR2_30() ;

Line 30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30

26: g_interface_col_name_tbl FND_TABLE_OF_VARCHAR2_30
27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;
32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30
33: := FND_TABLE_OF_VARCHAR2_30() ;
34: TYPE

Line 31: := FND_TABLE_OF_VARCHAR2_30() ;

27: := FND_TABLE_OF_VARCHAR2_30() ;
28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;
32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30
33: := FND_TABLE_OF_VARCHAR2_30() ;
34: TYPE
35: g_not_null_attr_val_type

Line 32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30

28: g_attribute_name_tbl FND_TABLE_OF_VARCHAR2_30
29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;
32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30
33: := FND_TABLE_OF_VARCHAR2_30() ;
34: TYPE
35: g_not_null_attr_val_type
36: IS TABLE OF VARCHAR2(4000)

Line 33: := FND_TABLE_OF_VARCHAR2_30() ;

29: := FND_TABLE_OF_VARCHAR2_30() ;
30: g_attribute_data_type_tbl FND_TABLE_OF_VARCHAR2_30
31: := FND_TABLE_OF_VARCHAR2_30() ;
32: g_not_null_attr_name_tbl FND_TABLE_OF_VARCHAR2_30
33: := FND_TABLE_OF_VARCHAR2_30() ;
34: TYPE
35: g_not_null_attr_val_type
36: IS TABLE OF VARCHAR2(4000)
37: INDEX BY PLS_INTEGER ;

Line 645: l_attr_intf_col_name_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30

641: l_map_data_type_tbl l_data_type_tbl_typ;
642: l_map_attr_var_label_tbl l_attr_varchar_label_tbl_typ;
643:
644:
645: l_attr_intf_col_name_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30
646: ( 'P_ATTRIBUTE1'
647: , 'P_ATTRIBUTE2'
648: , 'P_ATTRIBUTE3'
649: , 'P_ATTRIBUTE4'

Line 809: FROM TABLE(CAST(g_changed_dt_intf_col_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF

805: SELECT REF.column_value AS INTERFACE_COL
806: , DATA_TYPE
807: , MAP.ATTRIBUTE_VARCHAR_LABEL
808: , ATTRIBUTE_REQUIRED_FLAG
809: FROM TABLE(CAST(g_changed_dt_intf_col_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF
810: , FEM_WEBADI_DIM_ATTR_MAPS MAP
811: , FEM_DIM_ATTRIBUTES_B A
812: WHERE MAP.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
813: AND MAP.INTERFACE_COL = REF.column_value

Line 975: FROM TABLE(CAST(g_changed_intf_col_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF

971: SELECT REF.column_value AS INTERFACE_COL
972: , DATA_TYPE
973: , MAP.ATTRIBUTE_VARCHAR_LABEL
974: , ATTRIBUTE_REQUIRED_FLAG
975: FROM TABLE(CAST(g_changed_intf_col_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF
976: , FEM_WEBADI_DIM_ATTR_MAPS MAP
977: , FEM_DIM_ATTRIBUTES_B A
978: WHERE MAP.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
979: AND MAP.INTERFACE_COL = REF.column_value

Line 1290: FROM TABLE(CAST(l_attr_intf_col_name_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF

1286: -- Maintain remaining interface columns if they are missing
1287: -----------------------------------------------------------------------------
1288: FOR intf_rec IN (
1289: SELECT REF.column_value AS INTERFACE_COL_NAME
1290: FROM TABLE(CAST(l_attr_intf_col_name_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF
1291: WHERE NOT EXISTS
1292: (
1293: SELECT INTERFACE_COL_NAME
1294: FROM BNE_INTERFACE_COLS_B

Line 1454: l_header_block_cols FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30

1450: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1451: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1452: l_interface_seq_num BNE_LAYOUT_COLS.SEQUENCE_NUM%TYPE;
1453:
1454: l_header_block_cols FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30
1455: ( 'P_DIMENSION_VARCHAR_LABEL'
1456: , 'MEMBER_GROUP_VALIDATOR'
1457: , 'P_LEDGER_ID'
1458: , 'P_CALENDAR_DISPLAY_CODE');

Line 1460: l_line_block_cols FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30

1456: , 'MEMBER_GROUP_VALIDATOR'
1457: , 'P_LEDGER_ID'
1458: , 'P_CALENDAR_DISPLAY_CODE');
1459:
1460: l_line_block_cols FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30
1461: ( 'P_MEMBER_NAME'
1462: , 'P_MEMBER_DISPLAY_CODE'
1463: , 'P_MEMBER_DESCRIPTION'
1464: , 'P_DIMENSION_GROUP_DISPLAY_CODE');

Line 1930: FROM TABLE(CAST(l_header_block_cols AS FND_TABLE_OF_VARCHAR2_30))

1926: WHERE I.APPLICATION_ID = 274
1927: AND I.INTERFACE_CODE = p_interface_code
1928: AND I.INTERFACE_COL_NAME IN (
1929: SELECT column_value
1930: FROM TABLE(CAST(l_header_block_cols AS FND_TABLE_OF_VARCHAR2_30))
1931: )
1932: )
1933: AND BLOCK_ID <> l_header_block_id;
1934:

Line 1952: FROM TABLE(CAST(l_header_block_cols AS FND_TABLE_OF_VARCHAR2_30))

1948: WHERE APPLICATION_ID = 274
1949: AND INTERFACE_CODE = p_interface_code
1950: AND INTERFACE_COL_NAME IN (
1951: SELECT column_value
1952: FROM TABLE(CAST(l_header_block_cols AS FND_TABLE_OF_VARCHAR2_30))
1953: )
1954: AND NOT EXISTS
1955: (
1956: SELECT 1

Line 2036: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))

2032: WHERE I.APPLICATION_ID = 274
2033: AND I.INTERFACE_CODE = p_interface_code
2034: AND I.INTERFACE_COL_NAME IN (
2035: SELECT column_value
2036: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))
2037: )
2038: )
2039: AND BLOCK_ID <> l_line_block_id;
2040:

Line 2080: FROM TABLE(CAST(l_header_block_cols AS FND_TABLE_OF_VARCHAR2_30))

2076: WHERE I.APPLICATION_ID = 274
2077: AND I.INTERFACE_CODE = p_interface_code
2078: AND (I.INTERFACE_COL_NAME IN (
2079: SELECT column_value
2080: FROM TABLE(CAST(l_header_block_cols AS FND_TABLE_OF_VARCHAR2_30))
2081: )
2082: OR
2083: I.INTERFACE_COL_NAME IN (
2084: SELECT column_value

Line 2085: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))

2081: )
2082: OR
2083: I.INTERFACE_COL_NAME IN (
2084: SELECT column_value
2085: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))
2086: )
2087: OR I.INTERFACE_COL_NAME LIKE 'P_ATTRIBUTE%'
2088: )
2089: );

Line 2154: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))

2150: )
2151: )
2152: AND INTERFACE_COL_NAME IN (
2153: SELECT column_value
2154: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))
2155: )
2156: AND NOT EXISTS
2157: ( SELECT 1
2158: FROM BNE_LAYOUT_COLS LC

Line 2799: g_interface_col_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;

2795: --
2796: END IF ;
2797: --
2798: -- Initialize object types
2799: g_interface_col_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2800: g_attribute_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2801: g_attribute_data_type_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2802: --
2803: g_global_val_tbl.DELETE ;

Line 2800: g_attribute_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;

2796: END IF ;
2797: --
2798: -- Initialize object types
2799: g_interface_col_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2800: g_attribute_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2801: g_attribute_data_type_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2802: --
2803: g_global_val_tbl.DELETE ;
2804: --

Line 2801: g_attribute_data_type_tbl := FND_TABLE_OF_VARCHAR2_30() ;

2797: --
2798: -- Initialize object types
2799: g_interface_col_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2800: g_attribute_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2801: g_attribute_data_type_tbl := FND_TABLE_OF_VARCHAR2_30() ;
2802: --
2803: g_global_val_tbl.DELETE ;
2804: --
2805: -- Bulk collect all attribute mappings into

Line 2976: l_data_type_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30() ;

2972: l_cnt_rec NUMBER := 0 ;
2973: l_gap_logic_req BOOLEAN := FALSE ;
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

Line 2977: l_attr_label_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30() ;

2973: l_gap_logic_req BOOLEAN := FALSE ;
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

Line 5058: g_not_null_attr_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;

5054: -- Retrieve user's langauge value.
5055: --
5056: g_session_language := USERENV('LANG') ;
5057: --
5058: g_not_null_attr_name_tbl := FND_TABLE_OF_VARCHAR2_30() ;
5059: g_not_null_attr_val_tbl.DELETE ;
5060:
5061: -- Bug#6446663 - Begin
5062: g_attribute_vs_display_code := FND_TABLE_OF_VARCHAR2_255() ;