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 FEM_WEBADI_DIM_ATTR_MAPS

Line 634: FEM_WEBADI_DIM_ATTR_MAPS.DATA_TYPE%TYPE INDEX BY BINARY_INTEGER;

630: TYPE l_sequence_num_tbl_typ IS TABLE OF
631: BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE INDEX BY BINARY_INTEGER;
632:
633: TYPE l_data_type_tbl_typ IS TABLE OF
634: FEM_WEBADI_DIM_ATTR_MAPS.DATA_TYPE%TYPE INDEX BY BINARY_INTEGER;
635:
636: TYPE l_attr_varchar_label_tbl_typ IS TABLE OF
637: FEM_WEBADI_DIM_ATTR_MAPS.ATTRIBUTE_VARCHAR_LABEL%TYPE
638: INDEX BY BINARY_INTEGER;

Line 637: FEM_WEBADI_DIM_ATTR_MAPS.ATTRIBUTE_VARCHAR_LABEL%TYPE

633: TYPE l_data_type_tbl_typ IS TABLE OF
634: FEM_WEBADI_DIM_ATTR_MAPS.DATA_TYPE%TYPE INDEX BY BINARY_INTEGER;
635:
636: TYPE l_attr_varchar_label_tbl_typ IS TABLE OF
637: FEM_WEBADI_DIM_ATTR_MAPS.ATTRIBUTE_VARCHAR_LABEL%TYPE
638: INDEX BY BINARY_INTEGER;
639:
640: l_map_sequence_num_tbl l_sequence_num_tbl_typ;
641: l_map_data_type_tbl l_data_type_tbl_typ;

Line 749: FROM FEM_WEBADI_DIM_ATTR_MAPS M

745: AND I.INTERFACE_COL_NAME LIKE 'P_ATTRIBUTE%'
746: AND NOT EXISTS
747: (
748: SELECT 1
749: FROM FEM_WEBADI_DIM_ATTR_MAPS M
750: WHERE M.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
751: AND M.INTERFACE_COL = I.INTERFACE_COL_NAME
752: )
753: )

Line 793: -- FEM_WEBADI_DIM_ATTR_MAPS table.

789:
790:
791: -----------------------------------------------------------------------------
792: -- Update those interface column whose data type has changed in
793: -- FEM_WEBADI_DIM_ATTR_MAPS table.
794: -----------------------------------------------------------------------------
795:
796: IF (g_changed_dt_intf_col_tbl.COUNT > 0) THEN
797:

Line 810: , FEM_WEBADI_DIM_ATTR_MAPS MAP

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
814: AND A.DIMENSION_ID = p_dimension_id

Line 976: , FEM_WEBADI_DIM_ATTR_MAPS MAP

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
980: AND A.DIMENSION_ID = p_dimension_id

Line 2044: -- Delete those columns that are not stored in the FEM_WEBADI_DIM_ATTR_MAPS

2040:
2041: -----------------------------------------------------------------------------
2042: -- Assign value to the BNE_LAYOUT_COLS for the line block
2043: -----------------------------------------------------------------------------
2044: -- Delete those columns that are not stored in the FEM_WEBADI_DIM_ATTR_MAPS
2045: DELETE BNE_LAYOUT_COLS
2046: WHERE APPLICATION_ID = 274
2047: AND INTERFACE_CODE = p_interface_code
2048: AND INTERFACE_SEQ_NUM IN

Line 2057: FROM FEM_WEBADI_DIM_ATTR_MAPS M

2053: AND I.INTERFACE_COL_NAME LIKE 'P_ATTRIBUTE%'
2054: AND NOT EXISTS
2055: (
2056: SELECT 1
2057: FROM FEM_WEBADI_DIM_ATTR_MAPS M
2058: WHERE M.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
2059: AND M.INTERFACE_COL = I.INTERFACE_COL_NAME
2060: )
2061: );

Line 2224: FROM FEM_WEBADI_DIM_ATTR_MAPS M

2220: WHERE APPLICATION_ID = 274
2221: AND IC.INTERFACE_CODE = p_interface_code
2222: AND EXISTS
2223: ( SELECT 1
2224: FROM FEM_WEBADI_DIM_ATTR_MAPS M
2225: WHERE M.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
2226: AND M.INTERFACE_COL = INTERFACE_COL_NAME
2227: )
2228: AND NOT EXISTS

Line 2770: fem_webadi_dim_attr_maps AttrMaps

2766: AttrMaps.interface_col
2767: , AttrMaps.attribute_varchar_label
2768: , AttrMaps.data_type
2769: FROM
2770: fem_webadi_dim_attr_maps AttrMaps
2771: WHERE
2772: AttrMaps.dimension_varchar_label = p_dimension_varchar_label ;
2773: --
2774: BEGIN

Line 2991: , fem_webadi_dim_attr_maps attrmap

2987: , dimattr.attribute_data_type_code
2988: FROM
2989: fem_dim_attributes_b dimattr
2990: , fem_xdim_dimensions_vl xdim
2991: , fem_webadi_dim_attr_maps attrmap
2992: WHERE
2993: attrmap.dimension_varchar_label = p_dimension_varchar_label
2994: AND xdim.dimension_varchar_label = attrmap.dimension_varchar_label
2995: AND dimattr.dimension_id = xdim.dimension_id

Line 3017: fem_webadi_dim_attr_maps attrmap

3013: AND NOT EXISTS
3014: ( SELECT
3015: attrmap.attribute_varchar_label
3016: FROM
3017: fem_webadi_dim_attr_maps attrmap
3018: WHERE
3019: attrmap.dimension_varchar_label = xdim.dimension_varchar_label
3020: AND attrmap.attribute_varchar_label = dimattr.attribute_varchar_label
3021: )

Line 3035: fem_webadi_dim_attr_maps attrmap

3031: MINUS
3032: SELECT
3033: TO_NUMBER( SUBSTR( attrmap.interface_col, 12 ) ) col_map_seq
3034: FROM
3035: fem_webadi_dim_attr_maps attrmap
3036: WHERE
3037: attrmap.dimension_varchar_label = p_dimension_varchar_label ;
3038: --
3039: BEGIN

Line 3073: fem_webadi_dim_attr_maps attrmap

3069: -- Delete records present in Mapping table but not in
3070: -- FEM_DIM_ATTRIBUTES_B table.
3071: DELETE
3072: FROM
3073: fem_webadi_dim_attr_maps attrmap
3074: WHERE
3075: attrmap.dimension_varchar_label = p_dimension_varchar_label
3076: AND attrmap.attribute_varchar_label NOT IN
3077: ( SELECT

Line 3117: fem_webadi_dim_attr_maps attrmap

3113: IF ( g_changed_dt_intf_col_tbl.COUNT >= 1 )
3114: THEN
3115: FORALL l_indx IN 1..g_changed_dt_intf_col_tbl.COUNT
3116: UPDATE
3117: fem_webadi_dim_attr_maps attrmap
3118: SET
3119: attrmap.data_type = l_data_type_tbl(l_indx)
3120: WHERE
3121: attrmap.dimension_varchar_label = p_dimension_varchar_label

Line 3153: fem_webadi_dim_attr_maps attrmap

3149: INTO
3150: l_max_attr_seq
3151: , l_cnt_rec
3152: FROM
3153: fem_webadi_dim_attr_maps attrmap
3154: WHERE
3155: attrmap.dimension_varchar_label = p_dimension_varchar_label ;
3156: --
3157: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 3238: fem_webadi_dim_attr_maps

3234: --
3235: -- Now Bulk insert attributes in mapping table.
3236: FORALL l_indx IN 1..l_attr_label_tbl.COUNT
3237: INSERT INTO
3238: fem_webadi_dim_attr_maps
3239: ( interface_col
3240: , dimension_varchar_label
3241: , attribute_varchar_label
3242: , data_type

Line 3289: fem_webadi_dim_attr_maps

3285: END LOOP ;
3286: -- Now bulk insert records in MApping table.
3287: FORALL l_indx IN 1..l_attr_label_tbl.COUNT
3288: INSERT INTO
3289: fem_webadi_dim_attr_maps
3290: ( interface_col
3291: , dimension_varchar_label
3292: , attribute_varchar_label
3293: , data_type

Line 6218: DELETE FROM fem_webadi_dim_attr_maps;

6214: FEM_ENGINES_PKG.User_Message (
6215: p_app_name => 'FEM'
6216: ,p_msg_text => 'Deleting attr maps');
6217:
6218: DELETE FROM fem_webadi_dim_attr_maps;
6219:
6220: FEM_ENGINES_PKG.User_Message (
6221: p_app_name => 'FEM'
6222: ,p_msg_text => 'Deleted...');