APPS.OTA_ACI_INS dependencies on OTA_ACT_CAT_INCLUSIONS

Line 90: -- Insert the row into: ota_act_cat_inclusions

86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ota_aci_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ota_act_cat_inclusions
91: --
92: insert into ota_act_cat_inclusions
93: (activity_version_id
94: ,activity_category

Line 92: insert into ota_act_cat_inclusions

88: ota_aci_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ota_act_cat_inclusions
91: --
92: insert into ota_act_cat_inclusions
93: (activity_version_id
94: ,activity_category
95: ,object_version_number
96: ,event_id

Line 224: Cursor C_Sel1 is select ota_act_cat_inclusions_s.nextval from sys.dual;

220: ) is
221:
222: /*
223: --
224: Cursor C_Sel1 is select ota_act_cat_inclusions_s.nextval from sys.dual;
225: --
226: Cursor C_Sel2 is
227: Select null
228: from ota_act_cat_inclusions

Line 228: from ota_act_cat_inclusions

224: Cursor C_Sel1 is select ota_act_cat_inclusions_s.nextval from sys.dual;
225: --
226: Cursor C_Sel2 is
227: Select null
228: from ota_act_cat_inclusions
229: where activity_version_id =
230: ota_aci_ins.g_activity_version_id_i
231: or category_usage_id =
232: ota_aci_ins.g_category_usage_id_i;

Line 255: fnd_message.set_token('TABLE_NAME','ota_act_cat_inclusions');

251: --
252: -- The primary key values are already in use.
253: --
254: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
255: fnd_message.set_token('TABLE_NAME','ota_act_cat_inclusions');
256: fnd_message.raise_error;
257: End If;
258: Close C_Sel2;
259: --

Line 396: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'

392: --
393: when hr_api.cannot_find_prog_unit then
394: --
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'
397: ,p_hook_type => 'AI');
398: --
399: end;
400: --

Line 413: l_activity_version_id ota_act_cat_inclusions.activity_version_id%TYPE;

409: ,p_rec in out nocopy ota_aci_shd.g_rec_type
410: ) is
411: --
412: l_proc varchar2(72) := g_package||'ins';
413: l_activity_version_id ota_act_cat_inclusions.activity_version_id%TYPE;
414: l_category_usage_id ota_act_cat_inclusions.category_usage_id%TYPE;
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);

Line 414: l_category_usage_id ota_act_cat_inclusions.category_usage_id%TYPE;

410: ) is
411: --
412: l_proc varchar2(72) := g_package||'ins';
413: l_activity_version_id ota_act_cat_inclusions.activity_version_id%TYPE;
414: l_category_usage_id ota_act_cat_inclusions.category_usage_id%TYPE;
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: