APPS.IEO_SVR_TYPES_SEED_PKG dependencies on IEO_SVR_TYPES_B

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

2: /* $Header: IEOSEEDB.pls 115.8 2003/01/02 17:07:23 dolee ship $ */
3:
4: PROCEDURE Insert_Row (p_svr_types_rec IN uwq_svr_types_rec_type) IS
5:
6: CURSOR c IS SELECT 'X' FROM ieo_svr_types_b
7: WHERE type_id = p_svr_types_rec.type_id;
8:
9: l_dummy CHAR(1);
10:

Line 14: INSERT INTO ieo_svr_types_b (

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

Line 87: UPDATE ieo_svr_types_b SET

83: PROCEDURE Update_Row (p_svr_types_rec IN uwq_svr_types_rec_type) IS
84:
85: BEGIN
86: -- API body
87: UPDATE ieo_svr_types_b SET
88: last_updated_by = p_svr_types_rec.last_updated_by,
89: last_update_date = p_svr_types_rec.last_update_date,
90: last_update_login = p_svr_types_rec.last_update_login,
91: type_uuid = p_svr_types_rec.type_uuid,

Line 208: from IEO_SVR_TYPES_B B

204: begin
205: delete from IEO_SVR_TYPES_TL T
206: where not exists
207: (select NULL
208: from IEO_SVR_TYPES_B B
209: where B.TYPE_ID = T.TYPE_ID
210: );
211:
212: update IEO_SVR_TYPES_TL T set (