2: /* $Header: IEOSEEDB.pls 115.0 2000/01/19 10:10:02 pkm 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:
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,
81: PROCEDURE Update_Row (p_svr_types_rec IN uwq_svr_types_rec_type) IS
82:
83: BEGIN
84: -- API body
85: UPDATE ieo_svr_types_b SET
86: last_updated_by = p_svr_types_rec.last_updated_by,
87: last_update_date = p_svr_types_rec.last_update_date,
88: last_update_login = p_svr_types_rec.last_update_login,
89: type_uuid = p_svr_types_rec.type_uuid,