APPS.FEM_BR_DIM_LDR_PVT dependencies on FEM_DIM_LOAD_DIM_PARAMS

Line 33: DELETE FROM fem_dim_load_dim_params WHERE loader_obj_def_id=p_obj_def_id;

29: ,p_module => c_module_pkg||'.'||l_api_name
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

Line 93: INSERT INTO fem_dim_load_dim_params(

89: ,p_module => c_module_pkg||'.'||l_api_name
90: ,p_msg_text => 'Begining Procedure'
91: );
92:
93: INSERT INTO fem_dim_load_dim_params(
94: loader_obj_def_id
95: ,dimension_id
96: ,created_by
97: ,creation_date

Line 112: FROM fem_dim_load_dim_params

108: ,nvl(p_created_by,fnd_global.user_id )
109: ,nvl(p_creation_date,sysdate)
110: ,fnd_global.login_id
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

Line 188: SELECT COUNT(*) no_of_rows FROM fem_dim_load_dim_params WHERE loader_obj_def_id = p_obj_def_id

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:
191: IF l_no_of_rows > 0 THEN
192: l_exists := 'Y';