APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_LEARNER_ACCESS_UTIL

Line 471: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));

467:
468: hr_utility.set_location(' Entering:'||l_proc, 5);
469:
470: FOR request IN get_all_mandatory_enr_requests(p_conc_request_id) LOOP
471: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));
472: IF request.usergroup_id IS NULL THEN
473: FOR learner IN csr_get_learners (request.person_id, request.organization_id, request.job_id, request.position_id, request.org_structure_version_id, request.event_id, request.enr_prereq_type,l_event_start_date) LOOP
474: create_request_member_record(learner.person_id,request.mandatory_enr_request_id,request.event_id,request.enr_prereq_type,learner.completed_crs_prereq,learner.completed_comp_prereq,l_numberof_records_processed);
475: END LOOP;--END FOR learner IN csr_get_learners

Line 478: usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));

474: create_request_member_record(learner.person_id,request.mandatory_enr_request_id,request.event_id,request.enr_prereq_type,learner.completed_crs_prereq,learner.completed_comp_prereq,l_numberof_records_processed);
475: END LOOP;--END FOR learner IN csr_get_learners
476: ELSE
477: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
478: usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
479: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
480: sql_stmnt :='SELECT * FROM(
481: SELECT
482: ppf.person_id person_id