APPS.IEU_UWQ_MEDIA_TYPES_SEED_PKG dependencies on IEU_UWQ_MEDIA_TYPES_B

Line 6: CURSOR c IS SELECT 'X' FROM ieu_uwq_media_types_b

2: /* $Header: IEUSEEDB.pls 120.1 2005/06/23 02:40:28 appldev ship $ */
3:
4: PROCEDURE Insert_Row (p_uwq_media_types_rec IN uwq_media_types_rec_type) IS
5:
6: CURSOR c IS SELECT 'X' FROM ieu_uwq_media_types_b
7: WHERE media_type_id = p_uwq_media_types_rec.media_type_id;
8:
9: l_dummy CHAR(1);
10:

Line 14: INSERT INTO ieu_uwq_media_types_b (

10:
11: BEGIN
12:
13: -- API body
14: INSERT INTO ieu_uwq_media_types_b (
15: media_type_id,
16: created_by,
17: creation_date,
18: last_updated_by,

Line 95: UPDATE ieu_uwq_media_types_b SET

91: PROCEDURE Update_Row (p_uwq_media_types_rec IN uwq_media_types_rec_type) IS
92:
93: BEGIN
94: -- API body
95: UPDATE ieu_uwq_media_types_b SET
96: last_updated_by = p_uwq_media_types_rec.last_updated_by,
97: last_update_date = p_uwq_media_types_rec.last_update_date,
98: last_update_login = p_uwq_media_types_rec.last_update_login,
99: media_type_uuid = p_uwq_media_types_rec.media_type_uuid,

Line 233: from IEU_UWQ_MEDIA_TYPES_B B

229: begin
230: delete from IEU_UWQ_MEDIA_TYPES_TL T
231: where not exists
232: (select NULL
233: from IEU_UWQ_MEDIA_TYPES_B B
234: where B.MEDIA_TYPE_ID = T.MEDIA_TYPE_ID
235: );
236:
237: update IEU_UWQ_MEDIA_TYPES_TL T set (

Line 306: delete from IEU_UWQ_MEDIA_TYPES_B

302: if (sql%notfound) then
303: raise no_data_found;
304: end if;
305:
306: delete from IEU_UWQ_MEDIA_TYPES_B
307: where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID;
308:
309: if (sql%notfound) then
310: raise no_data_found;

Line 332: from IEU_UWQ_MEDIA_TYPES_B

328:
329:
330: cursor c is select
331: MEDIA_TYPE_UUID
332: from IEU_UWQ_MEDIA_TYPES_B
333: where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID
334: for update of MEDIA_TYPE_ID nowait;
335: recinfo c%rowtype;
336: