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.

[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_MANDATORY_ENR_REQ_MEMBERS

Line 384: FROM ota_mandatory_enr_req_members

380: RETURN Boolean IS
381:
382: CURSOR lrnr_already_selected IS
383: SELECT assignment_id
384: FROM ota_mandatory_enr_req_members
385: WHERE
386: person_id = p_person_id
387: AND event_id = p_event_id
388: AND create_enrollment = 'Y';

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

608: END learner_belongs_to_child_org;
609:
610:
611:
612: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
613: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
614: req_event_id IN ota_events.event_id%type,
615: req_enr_prereq_type IN varchar2,
616: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,

Line 613: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,

609:
610:
611:
612: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
613: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
614: req_event_id IN ota_events.event_id%type,
615: req_enr_prereq_type IN varchar2,
616: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
617: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,

Line 616: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,

612: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
613: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
614: req_event_id IN ota_events.event_id%type,
615: req_enr_prereq_type IN varchar2,
616: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
617: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,
618: l_numberof_records_processed IN OUT NOCOPY NUMBER) IS
619:
620: CURSOR csr_get_assignment_info(l_person_id NUMBER) IS

Line 617: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,

613: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
614: req_event_id IN ota_events.event_id%type,
615: req_enr_prereq_type IN varchar2,
616: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
617: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,
618: l_numberof_records_processed IN OUT NOCOPY NUMBER) IS
619:
620: CURSOR csr_get_assignment_info(l_person_id NUMBER) IS
621: SELECT paf.organization_id,

Line 693: INSERT INTO ota_mandatory_enr_req_members(mandatory_enr_request_id,person_id,assignment_id,error_message,creation_date,

689: END IF;
690: l_completed_crs_prereq := lrnr_completed_crs_prereq;
691: l_completed_comp_prereq := lrnr_completed_comp_prereq;
692:
693: INSERT INTO ota_mandatory_enr_req_members(mandatory_enr_request_id,person_id,assignment_id,error_message,creation_date,
694: completed_course_prereq,completed_competence_prereq,create_enrollment,event_id,organization_id,business_group_id)
695: VALUES(req_mandatory_enr_request_id,l_person_id,l_assignment_info.assignment_id,NULL,sysdate,l_completed_crs_prereq,
696: l_completed_comp_prereq, l_create_enrollment,req_event_id,l_assignment_info.organization_id,l_assignment_info.business_group_id);
697: l_numberof_records_processed := l_numberof_records_processed + 1;

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

1133:
1134: END LOOP;
1135:
1136: COMMIT;
1137: --All the records to be processed are now present IN ota_mandatory_enr_req_members with create_enrollment = 'Y'.
1138: --The records which cannot be created due to unfulfilled course/competence prereq have the respective flags set to 'N'
1139: --and create_enrollment IS set to 'N'
1140:
1141:

Line 1732: ota_mandatory_enr_req_members reqmembers,

1728: reqmembers.ERROR_MESSAGE,
1729: reqmembers.ORGANIZATION_ID,
1730: reqmembers.BUSINESS_GROUP_ID
1731: FROM
1732: ota_mandatory_enr_req_members reqmembers,
1733: ota_mandatory_enr_requests requests
1734: WHERE
1735: requests.conc_program_request_id = l_conc_reqId
1736: AND requests.mandatory_enr_request_id = reqmembers.mandatory_enr_request_id

Line 1757: l_error_message ota_mandatory_enr_req_members.error_message%type;

1753: AND nvl(pcaf.effective_end_date,sysdate+1)
1754: AND trunc(sysdate) BETWEEN nvl(assg.effective_start_date,trunc(sysdate))
1755: AND nvl(assg.effective_end_date,trunc(sysdate+1));
1756:
1757: l_error_message ota_mandatory_enr_req_members.error_message%type;
1758: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
1759: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1760: l_booking_status ota_booking_status_types_tl.name%type;
1761:

Line 1758: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;

1754: AND trunc(sysdate) BETWEEN nvl(assg.effective_start_date,trunc(sysdate))
1755: AND nvl(assg.effective_end_date,trunc(sysdate+1));
1756:
1757: l_error_message ota_mandatory_enr_req_members.error_message%type;
1758: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
1759: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1760: l_booking_status ota_booking_status_types_tl.name%type;
1761:
1762: l_request_rec get_all_mandatory_enr_requests%rowtype;

Line 1824: UPDATE ota_mandatory_enr_req_members

1820: ,p_is_mandatory_enrollment => 'Y');
1821: EXCEPTION
1822: WHEN OTHERS THEN
1823: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
1824: UPDATE ota_mandatory_enr_req_members
1825: SET error_message = l_error_message
1826: WHERE person_id = l_req_member_rec.person_id
1827: AND event_id = l_req_member_rec.event_id
1828: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;

Line 1838: UPDATE ota_mandatory_enr_req_members

1834:
1835: IF l_booking_id IS NOT NULL THEN
1836: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
1837: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1838: UPDATE ota_mandatory_enr_req_members
1839: SET error_message = NULL
1840: WHERE person_id = l_req_member_rec.person_id
1841: AND assignment_id = l_req_member_rec.assignment_id
1842: AND event_id = l_req_member_rec.event_id

Line 1850: UPDATE ota_mandatory_enr_req_members

1846: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
1847: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1849:
1850: UPDATE ota_mandatory_enr_req_members
1851: SET error_message = l_error_message
1852: WHERE person_id = l_req_member_rec.person_id
1853: AND event_id = l_req_member_rec.event_id
1854: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;

Line 2141: FROM ota_mandatory_enr_req_members reqm

2137: and conc_program_request_id = p_conc_reqId ;
2138:
2139: CURSOR csr_get_error_learners(p_event_id IN number) IS
2140: SELECT COUNT(distinct person_id)
2141: FROM ota_mandatory_enr_req_members reqm
2142: WHERE reqm.event_id = p_event_id
2143: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL);
2144:
2145:

Line 2148: FROM ota_mandatory_enr_req_members reqm

2144:
2145:
2146: CURSOR csr_get_successful_learners(p_event_id IN number) IS
2147: SELECT COUNT( distinct person_id)
2148: FROM ota_mandatory_enr_req_members reqm
2149: WHERE reqm.event_id = p_event_id
2150: AND(reqm.create_enrollment = 'Y' and reqm.error_message IS NULL);
2151:
2152: l_error_learners NUMBER := 0;