APPS.OTA_TPM_BUS1 dependencies on OTA_TRAINING_PLANS

Line 25: FROM OTA_TRAINING_PLANS

21: l_proc VARCHAR2(72) := g_package|| 'chk_training_plan_id';
22: --
23: CURSOR csr_training_plan_id IS
24: SELECT NULL
25: FROM OTA_TRAINING_PLANS
26: WHERE training_plan_id = p_training_plan_id
27: AND business_group_id = p_business_group_id;
28: BEGIN
29: --

Line 270: l_plan_start_date ota_training_plans.start_date%TYPE;

266: --
267: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';
268: l_api_updating BOOLEAN;
269: l_business_group_id ota_training_plan_members.business_group_id%TYPE;
270: l_plan_start_date ota_training_plans.start_date%TYPE;
271: l_plan_end_date ota_training_plans.end_date%TYPE;
272: l_version_start_date DATE;
273: l_version_end_date DATE;
274: l_exists VARCHAR2(1);

Line 271: l_plan_end_date ota_training_plans.end_date%TYPE;

267: l_proc VARCHAR2(72) := g_package|| 'activity_definition_id';
268: l_api_updating BOOLEAN;
269: l_business_group_id ota_training_plan_members.business_group_id%TYPE;
270: l_plan_start_date ota_training_plans.start_date%TYPE;
271: l_plan_end_date ota_training_plans.end_date%TYPE;
272: l_version_start_date DATE;
273: l_version_end_date DATE;
274: l_exists VARCHAR2(1);
275:

Line 296: FROM ota_training_plans otp

292: WHERE oav.activity_version_id = p_activity_version_id;
293: --
294: CURSOR csr_plan_date_range IS
295: SELECT otp.start_date, otp.end_date
296: FROM ota_training_plans otp
297: WHERE training_plan_id = p_training_plan_id;
298: /* select ptp.start_date, ptp.end_date
299: from per_time_periods ptp
300: ,ota_training_plans tps

Line 300: ,ota_training_plans tps

296: FROM ota_training_plans otp
297: WHERE training_plan_id = p_training_plan_id;
298: /* select ptp.start_date, ptp.end_date
299: from per_time_periods ptp
300: ,ota_training_plans tps
301: where tps.time_period_id = ptp.time_period_id
302: and tps.training_plan_id = p_training_plan_id;*/
303: --
304: --

Line 996: PROCEDURE chk_tpc_tp_actver_dates (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

992: -- |---------------------------< chk_tpc_tp_actver_dates >----------------------------|
993: -- ----------------------------------------------------------------------------
994:
995:
996: PROCEDURE chk_tpc_tp_actver_dates (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
997: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
998: ,p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE
999: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
1000: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE

Line 1008: FROM ota_training_plans otp

1004: l_proc VARCHAR2(72) := g_package|| 'chk_tpc_tp_actver_dates';
1005:
1006: CURSOR csr_comp_tpc_tp_dates IS
1007: SELECT 1,otp.start_date,decode(otp.end_date,null,'',otp.end_date)
1008: FROM ota_training_plans otp
1009: WHERE otp.training_plan_id = p_training_plan_id
1010: AND ( otp.start_date > p_earliest_start_date
1011: OR ( otp.end_date IS NOT NULL
1012: AND otp.end_date < p_target_completion_date) );