APPS.OTA_FNS_INS dependencies on OTA_FRM_NOTIF_SUBSCRIBERS

Line 93: -- Insert the row into: ota_frm_notif_subscribers

89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: ota_fns_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Insert the row into: ota_frm_notif_subscribers
94: --
95: insert into ota_frm_notif_subscribers
96: (forum_id
97: ,business_group_id

Line 95: insert into ota_frm_notif_subscribers

91: ota_fns_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Insert the row into: ota_frm_notif_subscribers
94: --
95: insert into ota_frm_notif_subscribers
96: (forum_id
97: ,business_group_id
98: ,object_version_number
99: ,person_id

Line 175: /*Cursor C_Sel1 is select ota_frm_notif_subscribers_s.nextval from sys.dual;

171: Procedure pre_insert
172: (p_rec in out nocopy ota_fns_shd.g_rec_type
173: ) is
174: --
175: /*Cursor C_Sel1 is select ota_frm_notif_subscribers_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from ota_frm_notif_subscribers

Line 179: from ota_frm_notif_subscribers

175: /*Cursor C_Sel1 is select ota_frm_notif_subscribers_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from ota_frm_notif_subscribers
180: where forum_id =
181: ota_fns_ins.g_forum_id_i
182: or person_id =
183: ota_fns_ins.g_person_id_i

Line 209: fnd_message.set_token('TABLE_NAME','ota_frm_notif_subscribers');

205: --
206: -- The primary key values are already in use.
207: --
208: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
209: fnd_message.set_token('TABLE_NAME','ota_frm_notif_subscribers');
210: fnd_message.raise_error;
211: End If;
212: Close C_Sel2;
213: --

Line 303: (p_module_name => 'OTA_FRM_NOTIF_SUBSCRIBERS'

299: --
300: when hr_api.cannot_find_prog_unit then
301: --
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'OTA_FRM_NOTIF_SUBSCRIBERS'
304: ,p_hook_type => 'AI');
305: --
306: end;
307: --

Line 320: l_forum_id ota_frm_notif_subscribers.forum_id%TYPE;

316: ,p_rec in out nocopy ota_fns_shd.g_rec_type
317: ) is
318: --
319: l_proc varchar2(72) := g_package||'ins';
320: l_forum_id ota_frm_notif_subscribers.forum_id%TYPE;
321: l_person_id ota_frm_notif_subscribers.person_id%TYPE;
322: l_contact_id ota_frm_notif_subscribers.contact_id%TYPE;
323:
324: --

Line 321: l_person_id ota_frm_notif_subscribers.person_id%TYPE;

317: ) is
318: --
319: l_proc varchar2(72) := g_package||'ins';
320: l_forum_id ota_frm_notif_subscribers.forum_id%TYPE;
321: l_person_id ota_frm_notif_subscribers.person_id%TYPE;
322: l_contact_id ota_frm_notif_subscribers.contact_id%TYPE;
323:
324: --
325: Begin

Line 322: l_contact_id ota_frm_notif_subscribers.contact_id%TYPE;

318: --
319: l_proc varchar2(72) := g_package||'ins';
320: l_forum_id ota_frm_notif_subscribers.forum_id%TYPE;
321: l_person_id ota_frm_notif_subscribers.person_id%TYPE;
322: l_contact_id ota_frm_notif_subscribers.contact_id%TYPE;
323:
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);