APPS.OTA_LCI_INS dependencies on OTA_LP_CAT_INCLUSIONS

Line 90: -- Insert the row into: ota_lp_cat_inclusions

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

Line 92: insert into ota_lp_cat_inclusions

88: --
89: --
90: -- Insert the row into: ota_lp_cat_inclusions
91: --
92: insert into ota_lp_cat_inclusions
93: (learning_path_id
94: ,category_usage_id
95: ,primary_flag
96: ,start_date_active

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

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

Line 222: from ota_lp_cat_inclusions

218:
219: --
220: Cursor C_Sel2 is
221: Select null
222: from ota_lp_cat_inclusions
223: where learning_path_id =
224: ota_lci_ins.g_learning_path_id_i
225: or category_usage_id =
226: ota_lci_ins.g_category_usage_id_i;

Line 249: fnd_message.set_token('TABLE_NAME','ota_lp_cat_inclusions');

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

Line 392: (p_module_name => 'OTA_LP_CAT_INCLUSIONS'

388: --
389: when hr_api.cannot_find_prog_unit then
390: --
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'OTA_LP_CAT_INCLUSIONS'
393: ,p_hook_type => 'AI');
394: --
395: end;
396: --

Line 409: l_learning_path_id OTA_LP_CAT_INCLUSIONS.learning_path_id%TYPE;

405: ,p_rec in out nocopy ota_lci_shd.g_rec_type
406: ) is
407: --
408: l_proc varchar2(72) := g_package||'ins';
409: l_learning_path_id OTA_LP_CAT_INCLUSIONS.learning_path_id%TYPE;
410: l_category_usage_id OTA_LP_CAT_INCLUSIONS.category_usage_id%TYPE;
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);

Line 410: l_category_usage_id OTA_LP_CAT_INCLUSIONS.category_usage_id%TYPE;

406: ) is
407: --
408: l_proc varchar2(72) := g_package||'ins';
409: l_learning_path_id OTA_LP_CAT_INCLUSIONS.learning_path_id%TYPE;
410: l_category_usage_id OTA_LP_CAT_INCLUSIONS.category_usage_id%TYPE;
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: