eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_MANDATORY_ENR_REQ_MEMBERS

Line 176: FROM ota_mandatory_enr_req_members

172: RETURN Boolean IS
173:
174: CURSOR lrnr_already_selected IS
175: SELECT assignment_id
176: FROM ota_mandatory_enr_req_members
177: WHERE
178: person_id = p_person_id
179: AND event_id = p_event_id
180: AND create_enrollment = 'Y';

Line 272: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,

268: END learner_belongs_to_child_org;
269:
270:
271:
272: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
273: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
274: req_event_id IN ota_events.event_id%type,
275: req_enr_prereq_type IN varchar2,
276: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,

Line 273: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,

269:
270:
271:
272: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
273: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
274: req_event_id IN ota_events.event_id%type,
275: req_enr_prereq_type IN varchar2,
276: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
277: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,

Line 276: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,

272: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
273: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
274: req_event_id IN ota_events.event_id%type,
275: req_enr_prereq_type IN varchar2,
276: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
277: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,
278: l_numberof_records_processed IN OUT NOCOPY NUMBER) IS
279:
280: CURSOR csr_get_assignment_info(l_person_id NUMBER) IS

Line 277: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,

273: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
274: req_event_id IN ota_events.event_id%type,
275: req_enr_prereq_type IN varchar2,
276: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
277: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,
278: l_numberof_records_processed IN OUT NOCOPY NUMBER) IS
279:
280: CURSOR csr_get_assignment_info(l_person_id NUMBER) IS
281: SELECT paf.organization_id,

Line 353: INSERT INTO ota_mandatory_enr_req_members(mandatory_enr_request_id,person_id,assignment_id,error_message,creation_date,completed_course_prereq,completed_competence_prereq,create_enrollment,event_id,organization_id,business_group_id)

349: END IF;
350: l_completed_crs_prereq := lrnr_completed_crs_prereq;
351: l_completed_comp_prereq := lrnr_completed_comp_prereq;
352:
353: INSERT INTO ota_mandatory_enr_req_members(mandatory_enr_request_id,person_id,assignment_id,error_message,creation_date,completed_course_prereq,completed_competence_prereq,create_enrollment,event_id,organization_id,business_group_id)
354: VALUES(req_mandatory_enr_request_id,l_person_id,l_assignment_info.assignment_id,NULL,sysdate,l_completed_crs_prereq,l_completed_comp_prereq,
355: l_create_enrollment,req_event_id,l_assignment_info.organization_id,l_assignment_info.business_group_id);
356: l_numberof_records_processed := l_numberof_records_processed + 1;
357: END IF;--learner_is_notSelected

Line 551: --All the records to be processed are now present IN ota_mandatory_enr_req_members with create_enrollment = 'Y'.

547:
548: END LOOP;
549:
550: COMMIT;
551: --All the records to be processed are now present IN ota_mandatory_enr_req_members with create_enrollment = 'Y'.
552: --The records which cannot be created due to unfulfilled course/competence prereq have the respective flags set to 'N'
553: --and create_enrollment IS set to 'N'
554:
555:

Line 616: ota_mandatory_enr_req_members reqmembers,

612: reqmembers.ERROR_MESSAGE,
613: reqmembers.ORGANIZATION_ID,
614: reqmembers.BUSINESS_GROUP_ID
615: FROM
616: ota_mandatory_enr_req_members reqmembers,
617: ota_mandatory_enr_requests requests
618: WHERE
619: requests.conc_program_request_id = l_conc_reqId
620: AND requests.mandatory_enr_request_id = reqmembers.mandatory_enr_request_id

Line 641: l_error_message ota_mandatory_enr_req_members.error_message%type;

637: AND nvl(pcaf.effective_end_date,sysdate+1)
638: AND trunc(sysdate) BETWEEN nvl(assg.effective_start_date,trunc(sysdate))
639: AND nvl(assg.effective_end_date,trunc(sysdate+1));
640:
641: l_error_message ota_mandatory_enr_req_members.error_message%type;
642: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
643: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
644: l_booking_status ota_booking_status_types_tl.name%type;
645:

Line 642: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;

638: AND trunc(sysdate) BETWEEN nvl(assg.effective_start_date,trunc(sysdate))
639: AND nvl(assg.effective_end_date,trunc(sysdate+1));
640:
641: l_error_message ota_mandatory_enr_req_members.error_message%type;
642: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
643: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
644: l_booking_status ota_booking_status_types_tl.name%type;
645:
646: l_request_rec get_all_mandatory_enr_requests%rowtype;

Line 708: UPDATE ota_mandatory_enr_req_members

704: ,p_is_mandatory_enrollment => 'Y');
705: EXCEPTION
706: WHEN OTHERS THEN
707: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
708: UPDATE ota_mandatory_enr_req_members
709: SET error_message = l_error_message
710: WHERE person_id = l_req_member_rec.person_id
711: AND event_id = l_req_member_rec.event_id
712: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;

Line 722: UPDATE ota_mandatory_enr_req_members

718:
719: IF l_booking_id IS NOT NULL THEN
720: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
721: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
722: UPDATE ota_mandatory_enr_req_members
723: SET error_message = NULL
724: WHERE person_id = l_req_member_rec.person_id
725: AND assignment_id = l_req_member_rec.assignment_id
726: AND event_id = l_req_member_rec.event_id

Line 734: UPDATE ota_mandatory_enr_req_members

730: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
731: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
732: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
733:
734: UPDATE ota_mandatory_enr_req_members
735: SET error_message = l_error_message
736: WHERE person_id = l_req_member_rec.person_id
737: AND event_id = l_req_member_rec.event_id
738: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;

Line 852: FROM ota_mandatory_enr_req_members reqm

848: and conc_program_request_id = p_conc_reqId ;
849:
850: CURSOR csr_get_error_learners(p_event_id IN number) IS
851: SELECT COUNT(distinct person_id)
852: FROM ota_mandatory_enr_req_members reqm
853: WHERE reqm.event_id = p_event_id
854: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL);
855:
856:

Line 859: FROM ota_mandatory_enr_req_members reqm

855:
856:
857: CURSOR csr_get_successful_learners(p_event_id IN number) IS
858: SELECT COUNT( distinct person_id)
859: FROM ota_mandatory_enr_req_members reqm
860: WHERE reqm.event_id = p_event_id
861: AND(reqm.create_enrollment = 'Y' and reqm.error_message IS NULL);
862:
863: l_error_learners NUMBER := 0;