APPS.FEM_WEBADI_HIER_UTILS_PVT dependencies on FEM_HIERARCHIES_T

Line 159: FROM FEM_HIERARCHIES_T

155:
156: BEGIN
157: SELECT STATUS
158: INTO l_status
159: FROM FEM_HIERARCHIES_T
160: WHERE HIERARCHY_OBJECT_NAME = p_hierarchy_object_name
161: AND HIER_OBJ_DEF_DISPLAY_NAME = p_hierarchy_obj_def_disp_name;
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN NULL;

Line 171: fem_hierarchies_t

167: THEN
168:
169: INSERT
170: INTO
171: fem_hierarchies_t
172: ( hierarchy_object_name
173: , folder_name
174: , language
175: , dimension_varchar_label

Line 212: fem_hierarchies_t hier

208: ELSIF (l_status <> 'LOAD')
209: THEN
210:
211: UPDATE
212: fem_hierarchies_t hier
213: SET
214: hier.hierarchy_type_code = p_hierarchy_type_code
215: , hier.multi_top_flag = p_multi_top_flag
216: , hier.multi_value_set_flag = p_multi_value_set_flag

Line 1393: l_grp_seq_enfrced_code fem_hierarchies_t.group_sequence_enforced_code%TYPE ;

1389: l_return_status VARCHAR2(1) ;
1390: l_msg_count NUMBER ;
1391: l_msg_data VARCHAR2(2000) ;
1392: --
1393: l_grp_seq_enfrced_code fem_hierarchies_t.group_sequence_enforced_code%TYPE ;
1394: --
1395: --
1396: BEGIN
1397: --