APPS.OTA_CCI_INS dependencies on OTA_CERT_CAT_INCLUSIONS

Line 90: -- Insert the row into: ota_cert_cat_inclusions

86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: --
89: --
90: -- Insert the row into: ota_cert_cat_inclusions
91: --
92: insert into ota_cert_cat_inclusions
93: (category_usage_id
94: ,certification_id

Line 92: insert into ota_cert_cat_inclusions

88: --
89: --
90: -- Insert the row into: ota_cert_cat_inclusions
91: --
92: insert into ota_cert_cat_inclusions
93: (category_usage_id
94: ,certification_id
95: ,object_version_number
96: ,start_date_active

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

213: (p_rec in out nocopy ota_cci_shd.g_rec_type
214: ) is
215: --
216: /*
217: Cursor C_Sel1 is select ota_cert_cat_inclusions_s.nextval from sys.dual;
218: --
219: Cursor C_Sel2 is
220: Select null
221: from ota_cert_cat_inclusions

Line 221: from ota_cert_cat_inclusions

217: Cursor C_Sel1 is select ota_cert_cat_inclusions_s.nextval from sys.dual;
218: --
219: Cursor C_Sel2 is
220: Select null
221: from ota_cert_cat_inclusions
222: where category_usage_id =
223: ota_cci_ins.g_category_usage_id_i
224: or certification_id =
225: ota_cci_ins.g_certification_id_i;

Line 248: fnd_message.set_token('TABLE_NAME','ota_cert_cat_inclusions');

244: --
245: -- The primary key values are already in use.
246: --
247: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
248: fnd_message.set_token('TABLE_NAME','ota_cert_cat_inclusions');
249: fnd_message.raise_error;
250: End If;
251: Close C_Sel2;
252: --

Line 385: (p_module_name => 'OTA_CERT_CAT_INCLUSIONS'

381: --
382: when hr_api.cannot_find_prog_unit then
383: --
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'OTA_CERT_CAT_INCLUSIONS'
386: ,p_hook_type => 'AI');
387: --
388: end;
389: --

Line 402: l_certification_id OTA_CERT_CAT_INCLUSIONS.certification_id%TYPE;

398: ,p_rec in out nocopy ota_cci_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package||'ins';
402: l_certification_id OTA_CERT_CAT_INCLUSIONS.certification_id%TYPE;
403: l_category_usage_id OTA_CERT_CAT_INCLUSIONS.category_usage_id%TYPE;
404:
405: --
406: Begin

Line 403: l_category_usage_id OTA_CERT_CAT_INCLUSIONS.category_usage_id%TYPE;

399: ) is
400: --
401: l_proc varchar2(72) := g_package||'ins';
402: l_certification_id OTA_CERT_CAT_INCLUSIONS.certification_id%TYPE;
403: l_category_usage_id OTA_CERT_CAT_INCLUSIONS.category_usage_id%TYPE;
404:
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);