APPS.OTA_NHS_INS dependencies on OTA_NOTRNG_HISTORIES

Line 87: -- Insert the row into: ota_notrng_histories

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: ota_nhs_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ota_notrng_histories
88: --
89: insert into ota_notrng_histories
90: ( nota_history_id,
91: person_id,

Line 89: insert into ota_notrng_histories

85: ota_nhs_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ota_notrng_histories
88: --
89: insert into ota_notrng_histories
90: ( nota_history_id,
91: person_id,
92: contact_id,
93: trng_title,

Line 239: Cursor C_Sel1 is select ota_notrng_histories_s.nextval from sys.dual;

235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: Procedure pre_insert(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
238: --
239: Cursor C_Sel1 is select ota_notrng_histories_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from ota_notrng_histories

Line 243: from ota_notrng_histories

239: Cursor C_Sel1 is select ota_notrng_histories_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from ota_notrng_histories
244: where nota_history_id =
245: ota_nhs_ins.g_nota_history_id_i;
246: --
247: l_exists varchar2(1);

Line 265: fnd_message.set_token('TABLE_NAME','ota_notrng_histories');

261: --
262: -- The primary key values are already in use.
263: --
264: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
265: fnd_message.set_token('TABLE_NAME','ota_notrng_histories');
266: fnd_message.raise_error;
267: End If;
268: Close C_Sel2;
269: --

Line 423: (p_module_name => 'OTA_NOTRNG_HISTORIES'

419: --
420: when hr_api.cannot_find_prog_unit then
421: --
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'OTA_NOTRNG_HISTORIES'
424: ,p_hook_type => 'AI');
425: --
426: end;
427: