DBA Data[Home] [Help]

APPS.OTA_CFS_INS dependencies on OTA_CONFERENCE_SERVERS_B

Line 89: insert into ota_conference_servers_b

85: --
86: --
87: -- Insert the row into: ota_conference_servers
88: --
89: insert into ota_conference_servers_b
90: (conference_server_id
91: ,url
92: ,type
93: ,owc_site_id

Line 217: Cursor C_Sel1 is select ota_conference_servers_b_s.nextval from sys.dual;

213: Procedure pre_insert
214: (p_rec in out nocopy ota_cfs_shd.g_rec_type
215: ) is
216: --
217: Cursor C_Sel1 is select ota_conference_servers_b_s.nextval from sys.dual;
218: --
219: Cursor C_Sel2 is
220: Select null
221: from ota_conference_servers_b

Line 221: from ota_conference_servers_b

217: Cursor C_Sel1 is select ota_conference_servers_b_s.nextval from sys.dual;
218: --
219: Cursor C_Sel2 is
220: Select null
221: from ota_conference_servers_b
222: where conference_server_id =
223: ota_cfs_ins.g_conference_server_id_i;
224: --
225: l_proc varchar2(72) := g_package||'pre_insert';

Line 243: fnd_message.set_token('TABLE_NAME','ota_conference_servers_b');

239: --
240: -- The primary key values are already in use.
241: --
242: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
243: fnd_message.set_token('TABLE_NAME','ota_conference_servers_b');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel2;
247: --