APPS.IEU_WORK_PANEL_PUB dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 33: l_enumID ieu_uwq_sel_enumerators.sel_enum_id%type;

29: sql_stmt varchar2(2000);
30: l_property_id ieu_wp_param_props_b.property_id%type;
31: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
32: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
33: l_enumID ieu_uwq_sel_enumerators.sel_enum_id%type;
34: l_applId ieu_wp_action_maps.application_id%type;
35: l_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
36: TYPE c_cursor5 IS REF CURSOR;
37: c_ref c_cursor5;

Line 41: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c

37: c_ref c_cursor5;
38: -- find enough information for reordering later after delete
39: CURSOR c_cursor2 is
40: SELECT DISTINCT a.sel_enum_id, b.application_id, c.maction_def_type_flag
41: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c
42: WHERE a.enum_type_uuid = b.action_map_code
43: AND c.maction_def_key = LTRIM(RTRIM(r_action_key))
44: AND b.action_param_set_id IN (SELECT action_param_set_id
45: FROM ieu_wp_act_param_sets_b

Line 165: r_node_id IN ieu_uwq_sel_enumerators.sel_enum_id%type)

161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: r_Lang IN ieu_wp_act_param_sets_tl.language%type,
164: r_Action_Label IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type,
165: r_node_id IN ieu_uwq_sel_enumerators.sel_enum_id%type)
166: As
167: v_cursor1 NUMBER;
168: v_cursor NUMBER;
169: v_numrows1 NUMBER;

Line 192: FROM ieu_uwq_sel_enumerators

188: AND ACTION_PARAM_SET_LABEL = LTRIM(RTRIM(r_Action_Label))
189: AND action_param_set_id IN (SELECT action_param_set_id
190: FROM ieu_wp_action_maps
191: WHERE action_map_code IN (SELECT enum_type_uuid
192: FROM ieu_uwq_sel_enumerators
193: WHERE sel_enum_id = LTRIM(RTRIM(r_node_id))
194: )
195: );
196:

Line 200: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c

196:
197: -- find enough information for reordering later after delete
198: CURSOR c_cursor2 is
199: SELECT DISTINCT b.application_id, c.maction_def_type_flag
200: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c
201: WHERE a.enum_type_uuid = b.action_map_code
202: AND a.sel_enum_id = r_node_id
203: AND c.maction_def_id IN (SELECT wp_action_def_id
204: FROM ieu_wp_act_param_sets_b

Line 285: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

281: DELETE FROM ieu_wp_action_maps
282: WHERE action_param_set_id = cur_rec.action_param_set_id AND
283: action_map_type_code = 'NODE' AND
284: action_map_code IN
285: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
286: WHERE sel_enum_id = r_node_id);
287:
288: --3.
289: IF (l_num_map_entries = 1) THEN