APPS.OTA_TPM_INS dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 86: -- Insert the row into: ota_training_plan_members

82: --Bug3507060
83: -- Set the Is_Per_Trng_Plan global variable
84: --l_boolean := OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_rec.training_plan_id);
85: --
86: -- Insert the row into: ota_training_plan_members
87: --
88: insert into ota_training_plan_members
89: (training_plan_member_id
90: ,training_plan_id

Line 88: insert into ota_training_plan_members

84: --l_boolean := OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_rec.training_plan_id);
85: --
86: -- Insert the row into: ota_training_plan_members
87: --
88: insert into ota_training_plan_members
89: (training_plan_member_id
90: ,training_plan_id
91: ,activity_version_id
92: ,activity_definition_id

Line 250: Cursor C_Sel1 is select ota_training_plan_members_s.nextval from sys.dual;

246: ) is
247: --
248: l_proc varchar2(72) := g_package||'pre_insert';
249: --
250: Cursor C_Sel1 is select ota_training_plan_members_s.nextval from sys.dual;
251: --
252: Cursor C_Sel2 is
253: Select null
254: from ota_training_plan_members

Line 254: from ota_training_plan_members

250: Cursor C_Sel1 is select ota_training_plan_members_s.nextval from sys.dual;
251: --
252: Cursor C_Sel2 is
253: Select null
254: from ota_training_plan_members
255: where training_plan_member_id =
256: ota_tpm_ins.g_training_plan_member_id_i;
257: --
258: l_exists varchar2(1);

Line 434: (p_module_name => 'OTA_TRAINING_PLAN_MEMBERS'

430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'OTA_TRAINING_PLAN_MEMBERS'
435: ,p_hook_type => 'AI');
436: --
437: end;
438: --