APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_ALLOC_BR_DIMENSIONS

Line 46: | assigned in fem_alloc_br_dimensions for the

42: | deletion of map rule contents minus the helper records
43: | instead of DeleteObjectDefinition.
44: | 2-JUL-07 RFlippo Bug#6146396 Set any dimension cols in the Mapping Output list
45: | = "SAME_AS_SOURCE" if they don't have a default
46: | assigned in fem_alloc_br_dimensions for the
47: | default rule
48: | 7-JUL-07 RFlippo Bug#6179151 Modify so that for Adj rules, the default
49: | is VALUE
50: | 6-JUL-07 RFlippo Need to get a unique object name for the snapshot objects.

Line 158: FROM fem_alloc_br_dimensions

154: WHERE table_name = p_tgt_table
155: AND column_property_code = 'MAPPING_UI_OUTPUT'
156: AND column_name NOT IN (
157: SELECT alloc_dim_col_name
158: FROM fem_alloc_br_dimensions
159: WHERE object_definition_id = p_obj_def_id
160: AND function_seq = p_func_seq);
161:
162: cursor c_bal_dimcol (p_obj_def_id IN VARCHAR2, p_func_seq IN NUMBER) is

Line 169: FROM fem_alloc_br_dimensions

165: WHERE table_name = 'FEM_BALANCES'
166: AND column_property_code = 'MAPPING_UI_OUTPUT'
167: AND column_name NOT IN (
168: SELECT alloc_dim_col_name
169: FROM fem_alloc_br_dimensions
170: WHERE object_definition_id = p_obj_def_id
171: AND function_seq = p_func_seq);
172:
173: v_rule_type_code VARCHAR2(30);

Line 213: insert into fem_alloc_br_dimensions (

209:
210: FOR func_seq IN c_tgttab (p_object_definition_id) LOOP
211: -- do the insert for the "non post to balances" records
212: FOR dimcol IN c_dimcol (p_object_definition_id, func_seq.function_seq, func_seq.table_name) LOOP
213: insert into fem_alloc_br_dimensions (
214: OBJECT_DEFINITION_ID
215: ,FUNCTION_SEQ
216: ,ALLOC_DIM_COL_NAME
217: ,POST_TO_BALANCES_FLAG

Line 238: insert into fem_alloc_br_dimensions (

234:
235: -- do the insert for the post_to_balances record if 'Y' for post_to_ledger_flg
236: IF func_seq.post_to_ledger_flg = 'Y' THEN
237: FOR baldimcol IN c_bal_dimcol (p_object_definition_id, func_seq.function_seq) LOOP
238: insert into fem_alloc_br_dimensions (
239: OBJECT_DEFINITION_ID
240: ,FUNCTION_SEQ
241: ,ALLOC_DIM_COL_NAME
242: ,POST_TO_BALANCES_FLAG

Line 1091: assigned in fem_alloc_br_dimensions for the

1087:
1088: HISTORY:
1089: 6/26/2007 Rflippo Bug#6146396 Set any dimension cols in the Mapping Output list
1090: = "SAME_AS_SOURCE" if they don't have a default
1091: assigned in fem_alloc_br_dimensions for the
1092: default rule
1093:
1094: *************************************************************************/
1095:

Line 1987: ' FROM fem_alloc_br_dimensions'||

1983: /* get br_dimensions data */
1984: v_sql := 'SELECT function_seq, alloc_dim_col_name, post_to_balances_flag, '||
1985: 'function_cd, alloc_dim_usage_code, dimension_value, dimension_value_char,'||
1986: 'percent_distribution_code'||
1987: ' FROM fem_alloc_br_dimensions'||
1988: ' WHERE object_definition_id = :1'||
1989: ' ORDER BY function_seq, alloc_dim_col_name, post_to_balances_flag';
1990:
1991: OPEN cv_get_ruledimdata FOR v_sql USING p_map_rule_obj_def_id;