APPS.IEU_WP_UI_COMP_CATG_PKG dependencies on IEU_WP_UI_COMP_CATG_B

Line 17: cursor C is select ROWID from IEU_WP_UI_COMP_CATG_B

13: p_ui_comp_catg_code in varchar2,
14: p_ui_comp_catg_label in varchar2,
15: p_ui_comp_catg_desc in varchar2
16: ) is
17: cursor C is select ROWID from IEU_WP_UI_COMP_CATG_B
18: where UI_COMP_CATG_ID = P_UI_COMP_CATG_ID;
19:
20: begin
21: insert into IEU_WP_UI_COMP_CATG_B (

Line 21: insert into IEU_WP_UI_COMP_CATG_B (

17: cursor C is select ROWID from IEU_WP_UI_COMP_CATG_B
18: where UI_COMP_CATG_ID = P_UI_COMP_CATG_ID;
19:
20: begin
21: insert into IEU_WP_UI_COMP_CATG_B (
22: UI_COMP_CATG_ID,
23: OBJECT_VERSION_NUMBER,
24: CREATED_BY,
25: CREATION_DATE,

Line 94: from ieu_wp_ui_comp_catg_b

90: ) is
91: cursor c is select
92: object_version_number,
93: ui_comp_catg_code
94: from ieu_wp_ui_comp_catg_b
95: where ui_comp_catg_id = p_ui_comp_catg_id
96: for update of ui_comp_catg_id nowait;
97: recinfo c%rowtype;
98:

Line 152: update IEU_WP_UI_COMP_CATG_B set

148: p_ui_comp_catg_label in varchar2,
149: p_ui_comp_catg_desc in varchar2
150: ) is
151: begin
152: update IEU_WP_UI_COMP_CATG_B set
153: object_version_number = object_version_number+1,
154: ui_comp_catg_code = p_ui_comp_catg_code,
155: last_update_date = p_last_update_date,
156: last_updated_by = p_last_updated_by,

Line 193: delete from ieu_wp_ui_comp_catg_b

189: if (sql%notfound) then
190: raise no_data_found;
191: end if;
192:
193: delete from ieu_wp_ui_comp_catg_b
194: where ui_comp_catg_id = p_ui_comp_catg_id;
195:
196: if (sql%notfound) then
197: raise no_data_found;

Line 209: from ieu_wp_ui_comp_catg_b b

205: begin
206: delete from IEU_WP_UI_COMP_CATG_TL t
207: where not exists
208: (select null
209: from ieu_wp_ui_comp_catg_b b
210: where b.ui_comp_catg_id = t.ui_comp_catg_id);
211:
212: update ieu_wp_ui_comp_catg_tl t
213: set (ui_comp_catg_label, ui_comp_catg_desc)