APPS.OTA_TPS_INS dependencies on OTA_TRAINING_PLANS

Line 82: -- Insert the row into: ota_training_plans

78: p_rec.object_version_number := 1; -- Initialise the object version
79: --
80: ota_tps_shd.g_api_dml := true; -- Set the api dml status
81: --
82: -- Insert the row into: ota_training_plans
83: --
84: insert into ota_training_plans
85: (training_plan_id
86: ,time_period_id

Line 84: insert into ota_training_plans

80: ota_tps_shd.g_api_dml := true; -- Set the api dml status
81: --
82: -- Insert the row into: ota_training_plans
83: --
84: insert into ota_training_plans
85: (training_plan_id
86: ,time_period_id
87: ,plan_status_type_id
88: ,organization_id

Line 252: Cursor C_Sel1 is select ota_training_plans_s.nextval from sys.dual;

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

Line 256: from ota_training_plans

252: Cursor C_Sel1 is select ota_training_plans_s.nextval from sys.dual;
253: --
254: Cursor C_Sel2 is
255: Select null
256: from ota_training_plans
257: where training_plan_id =
258: ota_tps_ins.g_training_plan_id_i;
259: --
260: l_exists varchar2(1);

Line 442: (p_module_name => 'OTA_TRAINING_PLANS'

438: --
439: when hr_api.cannot_find_prog_unit then
440: --
441: hr_api.cannot_find_prog_unit_error
442: (p_module_name => 'OTA_TRAINING_PLANS'
443: ,p_hook_type => 'AI');
444: --
445: end;
446: --