APPS.FEM_BR_DIM_LDR_PVT dependencies on FEM_DIM_LOAD_HIER_PARAMS

Line 34: DELETE FROM fem_dim_load_hier_params WHERE loader_obj_def_id=p_obj_def_id;

30: ,p_msg_text => 'Begining Procedure'
31: );
32:
33: DELETE FROM fem_dim_load_dim_params WHERE loader_obj_def_id=p_obj_def_id;
34: DELETE FROM fem_dim_load_hier_params WHERE loader_obj_def_id=p_obj_def_id;
35: FEM_ENGINES_PKG.Tech_Message (
36: p_severity => fnd_log.level_procedure
37: ,p_module => c_module_pkg||'.'||l_api_name
38: ,p_msg_text => 'Ending Procedure'

Line 115: INSERT INTO fem_dim_load_hier_params(

111: ,0
112: FROM fem_dim_load_dim_params
113: WHERE loader_obj_def_id = p_source_obj_def_id;
114:
115: INSERT INTO fem_dim_load_hier_params(
116: loader_comp_id
117: ,loader_obj_def_id
118: ,dimension_id
119: ,hier_obj_id

Line 139: FROM fem_dim_load_hier_params

135: ,nvl(p_created_by,fnd_global.user_id )
136: ,nvl(p_creation_date,sysdate)
137: ,fnd_global.login_id
138: ,0
139: FROM fem_dim_load_hier_params
140: WHERE LOADER_OBJ_DEF_ID = p_source_obj_def_id;
141:
142: FEM_ENGINES_PKG.Tech_Message (
143: p_severity => fnd_log.level_procedure

Line 186: (SELECT COUNT(*) no_of_rows FROM fem_dim_load_hier_params WHERE loader_obj_def_id = p_obj_def_id

182: ,p_msg_text => 'Begining Function'
183: );
184:
185: SELECT SUM(no_of_rows) INTO l_no_of_rows FROM
186: (SELECT COUNT(*) no_of_rows FROM fem_dim_load_hier_params WHERE loader_obj_def_id = p_obj_def_id
187: UNION
188: SELECT COUNT(*) no_of_rows FROM fem_dim_load_dim_params WHERE loader_obj_def_id = p_obj_def_id
189: );
190: