APPS.IEU_WORK_PROVIDER_PUB dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 24: r_enumId IN ieu_uwq_sel_enumerators.sel_enum_id%type)

20:
21: PROCEDURE DeleteNode(x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: r_enumId IN ieu_uwq_sel_enumerators.sel_enum_id%type)
25: As
26: v_cursor1 NUMBER;
27: v_cursor NUMBER;
28: v_numrows1 NUMBER;

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: cursor c_cursor is
37: select distinct a.action_param_set_id

Line 38: from ieu_wp_action_maps a, ieu_uwq_sel_enumerators b

34: l_applId ieu_wp_action_maps.application_id%type;
35: l_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
36: cursor c_cursor is
37: select distinct a.action_param_set_id
38: from ieu_wp_action_maps a, ieu_uwq_sel_enumerators b
39: where b.sel_enum_id = r_enumId
40: and a.action_map_code = b.enum_type_uuid;
41: begin
42: fnd_msg_pub.delete_msg();

Line 57: ' (select enum_type_uuid from ieu_uwq_sel_enumerators '||

53:
54: -- start real work
55: -- d.
56: Execute IMMEDIATE ' delete from ieu_wp_node_section_maps where enum_type_uuid in '||
57: ' (select enum_type_uuid from ieu_uwq_sel_enumerators '||
58: ' where sel_enum_id = :1 ) '
59: USING r_enumId;
60:
61: -- c.

Line 88: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||

84: END loop;
85:
86: -- b.
87: EXECUTE IMMEDIATE ' delete from fnd_profile_options_tl where profile_option_name '||
88: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||
89: ' where sel_enum_id = :1 ) '
90: USING r_enumId;
91: EXECUTE IMMEDIATE ' delete from fnd_profile_options_tl where profile_option_name '||
92: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||

Line 92: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||

88: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||
89: ' where sel_enum_id = :1 ) '
90: USING r_enumId;
91: EXECUTE IMMEDIATE ' delete from fnd_profile_options_tl where profile_option_name '||
92: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||
93: ' where sel_enum_id = :1 ) '
94: USING r_enumId;
95: EXECUTE IMMEDIATE ' delete from fnd_profile_options where profile_option_name '||
96: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||

Line 96: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||

92: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||
93: ' where sel_enum_id = :1 ) '
94: USING r_enumId;
95: EXECUTE IMMEDIATE ' delete from fnd_profile_options where profile_option_name '||
96: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||
97: ' where sel_enum_id = :1 ) '
98: USING r_enumId;
99: EXECUTE IMMEDIATE ' delete from fnd_profile_options where profile_option_name '||
100: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||

Line 100: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||

96: ' in (select work_q_enable_profile_option from ieu_uwq_sel_enumerators '||
97: ' where sel_enum_id = :1 ) '
98: USING r_enumId;
99: EXECUTE IMMEDIATE ' delete from fnd_profile_options where profile_option_name '||
100: ' in (select work_q_order_profile_option from ieu_uwq_sel_enumerators '||
101: ' where sel_enum_id = :1 ) '
102: USING r_enumId;
103:
104: -- a.

Line 107: ' from ieu_uwq_sel_enumerators where sel_enum_id = :1 )'

103:
104: -- a.
105: EXECUTE IMMEDIATE 'delete from fnd_lookup_values where (lookup_type, lookup_code) in '||
106: ' (select work_q_label_lu_type, work_q_label_lu_code ' ||
107: ' from ieu_uwq_sel_enumerators where sel_enum_id = :1 )'
108: USING r_enumId;
109: EXECUTE IMMEDIATE ' delete from ieu_uwq_sel_enumerators '||
110: ' where sel_enum_id = :1 '
111: USING r_enumId;

Line 109: EXECUTE IMMEDIATE ' delete from ieu_uwq_sel_enumerators '||

105: EXECUTE IMMEDIATE 'delete from fnd_lookup_values where (lookup_type, lookup_code) in '||
106: ' (select work_q_label_lu_type, work_q_label_lu_code ' ||
107: ' from ieu_uwq_sel_enumerators where sel_enum_id = :1 )'
108: USING r_enumId;
109: EXECUTE IMMEDIATE ' delete from ieu_uwq_sel_enumerators '||
110: ' where sel_enum_id = :1 '
111: USING r_enumId;
112:
113: EXCEPTION