APPS.IEU_WP_PROPERTIES_PKG dependencies on IEU_WP_PROPERTIES_B

Line 24: cursor C is select ROWID from IEU_WP_PROPERTIES_B

20: p_not_valid_flag in varchar2,
21: p_property_label in varchar2,
22: p_property_description in varchar2
23: ) is
24: cursor C is select ROWID from IEU_WP_PROPERTIES_B
25: where PROPERTY_ID = P_property_id;
26:
27: begin
28: insert into IEU_WP_PROPERTIES_B (

Line 28: insert into IEU_WP_PROPERTIES_B (

24: cursor C is select ROWID from IEU_WP_PROPERTIES_B
25: where PROPERTY_ID = P_property_id;
26:
27: begin
28: insert into IEU_WP_PROPERTIES_B (
29: PROPERTY_ID,
30: OBJECT_VERSION_NUMBER,
31: CREATED_BY,
32: CREATION_DATE,

Line 128: from ieu_wp_properties_b

124: VALUE_OVERRIDE_FLAG,
125: VALUE_TRANSLATABLE_FLAG,
126: FORM_ITEM_PROPERTY_FLAG,
127: NOT_VALID_FLAG
128: from ieu_wp_properties_b
129: where property_id = p_property_id
130: for update of property_id nowait;
131: recinfo c%rowtype;
132:

Line 200: update IEU_WP_PROPERTIES_B set

196: p_property_label in varchar2,
197: p_property_description in varchar2
198: ) is
199: begin
200: update IEU_WP_PROPERTIES_B set
201: object_version_number = object_version_number+1,
202: last_update_date = p_last_update_date,
203: last_updated_by = p_last_updated_by,
204: last_update_login = p_last_update_login,

Line 248: delete from ieu_wp_properties_b

244: if (sql%notfound) then
245: raise no_data_found;
246: end if;
247:
248: delete from ieu_wp_properties_b
249: where property_id = p_property_id;
250:
251: if (sql%notfound) then
252: raise no_data_found;

Line 264: from ieu_wp_properties_b b

260: begin
261: delete from IEU_WP_PROPERTIES_TL t
262: where not exists
263: (select null
264: from ieu_wp_properties_b b
265: where b.property_id = t.property_id);
266:
267: update ieu_wp_properties_tl t
268: set (property_label, property_description)