DBA Data[Home] [Help]

APPS.OTA_LP_NOTIFY_SS dependencies on OTA_LEARNER_ENROLL_SS

Line 67: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

63: l_person_id per_all_people_f.person_id%type;
64: l_contact_id number;
65: l_contact_name HZ_PARTIES.party_name%TYPE;
66:
67: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
68: l_role_name wf_roles.name%type;
69: l_role_display_name wf_roles.display_name%type;
70:
71: l_process_display_name varchar2(240);

Line 279: --l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_person_id);

275:
276: IF l_person_id IS NOT NULL THEN
277: --Commented for Bug 9976677,as it doesn't retrieve rows for terminated learners.Since the use of below call is only to
278: --retrieve person full name,using csr_get_person_name
279: --l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_person_id);
280:
281: --Modified for bug#4644019
282: /*SELECT user_name INTO l_user_name
283: FROM fnd_user