APPS.OTA_TRNG_PLAN_COMP_SS dependencies on OTA_TRNG_PLAN_UTIL_SS

Line 97: l_enroll_type := ota_trng_plan_util_ss.get_enroll_status(p_person_id,p_contact_id,rec.training_plan_member_id);

93:
94: LOOP
95:
96: -- Modified for Bug#3479186
97: l_enroll_type := ota_trng_plan_util_ss.get_enroll_status(p_person_id,p_contact_id,rec.training_plan_member_id);
98:
99: IF l_enroll_type = 'A' THEN
100: l_member_status_type := 'OTA_COMPLETED';
101: ELSIF ( l_enroll_type = 'P'

Line 222: l_enroll_status := ota_trng_plan_util_ss.get_enroll_status (p_person_id => rec.person_id,

218: FOR rec IN csr_tpm
219: LOOP
220:
221: hr_utility.set_location(' Step:'|| l_proc, 20);
222: l_enroll_status := ota_trng_plan_util_ss.get_enroll_status (p_person_id => rec.person_id,
223: -- Modified for Bug#3479186
224: p_contact_id => rec.contact_id,
225: p_training_plan_member_id => rec.training_plan_member_id);
226: IF ( l_enroll_status = 'P'

Line 453: l_enroll_type := ota_trng_plan_util_ss.get_enroll_status(p_person_id,NULL,p_training_plan_member_id);

449:
450: if p_mode='APPROVE' then
451:
452: -- Modified for Bug#3479186
453: l_enroll_type := ota_trng_plan_util_ss.get_enroll_status(p_person_id,NULL,p_training_plan_member_id);
454:
455: IF l_enroll_type = 'A' THEN
456: l_member_status_type := 'OTA_COMPLETED';
457: ELSIF ( l_enroll_type = 'P'

Line 631: l_complete_ok := ota_trng_plan_util_ss.chk_complete_plan_ok(rec1.training_plan_id);

627:
628: BEGIN
629: FOR rec1 in csr_tp_with_tpc LOOP
630: l_plan_status_type_id :=rec1.plan_status_type_id;
631: l_complete_ok := ota_trng_plan_util_ss.chk_complete_plan_ok(rec1.training_plan_id);
632: IF l_complete_ok = 'S'
633: AND rec1.plan_status_type_id = 'ACTIVE'
634: -- Bug3499850 AND rec1.additional_member_flag = 'N' THEN
635: THEN

Line 704: l_complete_ok := ota_trng_plan_util_ss.chk_complete_plan_ok(rec1.training_plan_id);

700:
701: BEGIN
702: FOR rec1 in csr_tp_with_tpc LOOP
703: l_plan_status_type_id :=rec1.plan_status_type_id;
704: l_complete_ok := ota_trng_plan_util_ss.chk_complete_plan_ok(rec1.training_plan_id);
705: IF l_complete_ok = 'S'
706: AND rec1.plan_status_type_id = 'ACTIVE'
707: -- Bug3499850 AND rec1.additional_member_flag = 'N' THEN
708: THEN