APPS.IEU_WP_UI_COMPONENTS_PKG dependencies on IEU_WP_UI_COMPONENTS_B

Line 20: cursor C is select ROWID from IEU_WP_UI_COMPONENTS_B

16: p_property_class in varchar2,
17: p_ui_comp_label in varchar2,
18: p_ui_comp_desc in varchar2
19: ) is
20: cursor C is select ROWID from IEU_WP_UI_COMPONENTS_B
21: where UI_COMP_ID = P_UI_COMP_ID;
22:
23: begin
24: insert into IEU_WP_UI_COMPONENTS_B (

Line 24: insert into IEU_WP_UI_COMPONENTS_B (

20: cursor C is select ROWID from IEU_WP_UI_COMPONENTS_B
21: where UI_COMP_ID = P_UI_COMP_ID;
22:
23: begin
24: insert into IEU_WP_UI_COMPONENTS_B (
25: UI_COMP_ID ,
26: OBJECT_VERSION_NUMBER,
27: CREATED_BY,
28: CREATION_DATE,

Line 109: from ieu_wp_ui_components_b

105: ui_comp_catg_code,
106: form_comp_code,
107: form_comp_avail_no,
108: property_class
109: from ieu_wp_ui_components_b
110: where ui_comp_id = p_ui_comp_id
111: for update of ui_comp_id nowait;
112: recinfo c%rowtype;
113:

Line 173: update IEU_WP_UI_COMPONENTS_B set

169: p_ui_comp_label in varchar2,
170: p_ui_comp_desc in varchar2
171: ) is
172: begin
173: update IEU_WP_UI_COMPONENTS_B set
174: object_version_number = object_version_number+1,
175: ui_comp_catg_code = p_ui_comp_catg_code,
176: form_comp_code = p_form_comp_code,
177: form_comp_avail_no = p_form_comp_avail_no,

Line 217: delete from ieu_wp_ui_components_b

213: if (sql%notfound) then
214: raise no_data_found;
215: end if;
216:
217: delete from ieu_wp_ui_components_b
218: where ui_comp_id = p_ui_comp_id;
219:
220: if (sql%notfound) then
221: raise no_data_found;

Line 233: from ieu_wp_ui_components_b b

229: begin
230: delete from IEU_WP_UI_COMPONENTS_TL t
231: where not exists
232: (select null
233: from ieu_wp_ui_components_b b
234: where b.ui_comp_id = t.ui_comp_id);
235:
236: update ieu_wp_ui_components_tl t
237: set (ui_comp_label, ui_comp_desc)