DBA Data[Home] [Help]

APPS.OTA_TPM_BUS1 dependencies on OTA_TRAINING_PLANS

Line 9: -- Validates that the training_plan_id exists in ota_training_plans

5: -- ----------------------------------------------------------------------------
6: -- {Start Of Comments}
7: --
8: -- Description:
9: -- Validates that the training_plan_id exists in ota_training_plans
10: -- and with the business_group_id.
11: --
12: -- Prerequisites:
13: -- Both this parameter and the business_group_id are present.

Line 450: Procedure chk_tpc_tp_actver_dates(p_training_plan_id in ota_training_plans.training_plan_id%type

446: -- {End Of Comments}
447: -- ----------------------------------------------------------------------------
448:
449:
450: Procedure chk_tpc_tp_actver_dates(p_training_plan_id in ota_training_plans.training_plan_id%type
451: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
452: ,p_activity_version_id in ota_training_plan_members.activity_version_id%type
453: ,p_earliest_start_date in ota_training_plan_members.earliest_start_date%TYPE
454: ,p_target_completion_date in ota_training_plan_members.target_completion_date%type