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_BULK_ENROLL_UTIL dependencies on OTA_LEARNER_ENROLL_SS

Line 147: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web

143:
144: l_maximum_internal_allowed := nvl(l_max_internal,l_max_enroll) - nvl(l_enrolled_places,0);
145:
146: IF l_event_status = 'F' THEN
147: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web
148: (p_web_booking_status_type => 'WAITLISTED'
149: ,p_business_group_id => 81);
150:
151: p_booking_status_id := l_booking_status_row.booking_status_type_id;

Line 159: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web

155: p_status_message := 'NOSTATUS';
156: END IF;
157:
158: ELSIF l_event_status in ('P') THEN
159: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web
160: (p_web_booking_status_type => 'REQUESTED'
161: ,p_business_group_id => 81);
162:
163: p_booking_status_id := l_booking_status_row.booking_status_type_id;

Line 172: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web

168: END IF;
169:
170: ELSIF l_event_status = 'N' THEN
171: IF l_maximum_internal_allowed > 0 THEN
172: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web
173: (p_web_booking_status_type => 'PLACED'
174: ,p_business_group_id => 81);
175: p_booking_status_id := l_booking_status_row.booking_status_type_id;
176: IF p_booking_status_id IS NOT NULL THEN

Line 183: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web

179: p_status_message := 'NOSTATUS';
180: END IF;
181:
182: ELSE
183: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_For_Web
184: (p_web_booking_status_type => 'WAITLISTED'
185: ,p_business_group_id => 81);
186: p_booking_status_id := l_booking_status_row.booking_status_type_id;
187: IF p_booking_status_id IS NOT NULL THEN

Line 615: l_ext_lrnr_details ota_learner_enroll_ss.csr_ext_lrnr_Details%ROWTYPE;

611: l_organization_id OTA_DELEGATE_BOOKINGS.organization_id%TYPE := NULL;
612: l_assignment_id OTA_DELEGATE_BOOKINGS.delegate_assignment_id%TYPE := NULL;
613: l_email_address OTA_DELEGATE_BOOKINGS.delegate_contact_email%TYPE := NULL;
614: l_person_address_type VARCHAR2(1);
615: l_ext_lrnr_details ota_learner_enroll_ss.csr_ext_lrnr_Details%ROWTYPE;
616: l_customer_id HZ_CUST_ACCOUNT_ROLES.cust_account_id%type := NULL;
617: l_corespondent VARCHAR2(1) := NULL;
618: l_source_of_booking VARCHAR2(30) := NULL; --Bug 5580960 : Incleased the SIZE.
619: l_enrollment_type VARCHAR2(1) := 'S';

Line 695: -- l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);

691:
692: l_restricted_assignment_id := p_assignment_id;
693:
694: --Modified for bug#5579345
695: -- l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
696: OPEN csr_get_assignment_details;
697: FETCH csr_get_assignment_details INTO l_person_details;
698: IF csr_get_assignment_details%NOTFOUND THEN
699: CLOSE csr_get_assignment_details;

Line 719: l_ext_lrnr_details := ota_learner_enroll_ss.Get_ext_lrnr_Details(p_delegate_contact_id);

715:
716: ELSE
717: l_internal_booking_flag := 'N';
718: l_person_address_type := null;
719: l_ext_lrnr_details := ota_learner_enroll_ss.Get_ext_lrnr_Details(p_delegate_contact_id);
720: l_customer_id := l_ext_lrnr_details.customer_id;
721: END IF;
722:
723: -- -----------------------------------------------

Line 777: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

773:
774: --Create enrollments in Waitlisted status for planned class
775: IF l_event_status in ('F','P') THEN
776:
777: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web
778: (p_web_booking_status_type => 'WAITLISTED'
779: ,p_business_group_id => ota_general.get_business_group_id);
780:
781: l_booking_status_used := 'WAITLISTED';

Line 785: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

781: l_booking_status_used := 'WAITLISTED';
782:
783: /*ELSIF l_event_status in ('P') THEN
784:
785: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web
786: (p_web_booking_status_type => 'REQUESTED'
787: ,p_business_group_id => ota_general.get_business_group_id);
788:
789: l_booking_status_used := 'REQUESTED';*/

Line 794: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

790:
791: ELSIF l_event_status = 'N' THEN
792:
793: IF l_maximum_internal_attendees is null then
794: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web
795: (p_web_booking_status_type => 'PLACED'
796: ,p_business_group_id => ota_general.get_business_group_id);
797:
798: l_booking_status_used := 'PLACED';

Line 803: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

799:
800: ELSE
801:
802: IF l_maximum_internal_allowed > 0 OR l_maximum_external_allowed > 0 THEN
803: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web
804: (p_web_booking_status_type => 'PLACED'
805: ,p_business_group_id => ota_general.get_business_group_id);
806:
807: l_booking_status_used := 'PLACED';

Line 810: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

806:
807: l_booking_status_used := 'PLACED';
808:
809: ELSIF l_maximum_internal_allowed <= 0 OR l_maximum_external_allowed <= 0 THEN
810: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web
811: (p_web_booking_status_type => 'WAITLISTED'
812: ,p_business_group_id => ota_general.get_business_group_id);
813:
814: l_booking_status_used := 'WAITLISTED';

Line 820: RAISE ota_learner_enroll_ss.g_mesg_on_stack_exception ;

816: END IF;
817: END IF;
818: IF l_booking_status_row.booking_Status_type_id is null then
819: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
820: RAISE ota_learner_enroll_ss.g_mesg_on_stack_exception ;
821: END IF ;
822: END IF;
823:
824: EXCEPTION

Line 825: WHEN ota_learner_enroll_ss.g_mesg_on_stack_exception THEN

821: END IF ;
822: END IF;
823:
824: EXCEPTION
825: WHEN ota_learner_enroll_ss.g_mesg_on_stack_exception THEN
826: --
827: -- Store the technical message which will have been seeded
828: -- if this exception has been raised. This will be used to provide
829: -- the code.

Line 901: l_cancel_boolean := ota_learner_enroll_ss.Chk_Event_Cancelled_for_Person(

897: -- Check to see if delegate has a booking status of CANCELLED for
898: -- this event, if cancelled l_cancel_boolean is set to true
899: -- FIX for bug 900679
900: --
901: l_cancel_boolean := ota_learner_enroll_ss.Chk_Event_Cancelled_for_Person(
902: p_event_id => p_event_id
903: ,p_delegate_person_id => l_delegate_id
904: ,p_delegate_contact_id => p_delegate_contact_id
905: ,p_booking_id => l_booking_id);

Line 918: l_object_version_number := OTA_LEARNER_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);

914: -- we must update the existing record by changing Cancelled
915: -- to Requested status
916: --
917:
918: l_object_version_number := OTA_LEARNER_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);
919:
920: /* Call Cancel procedure to cancel the Finance if person Re-enroll */
921: ota_learner_enroll_ss.cancel_finance(l_booking_id);
922:

Line 921: ota_learner_enroll_ss.cancel_finance(l_booking_id);

917:
918: l_object_version_number := OTA_LEARNER_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);
919:
920: /* Call Cancel procedure to cancel the Finance if person Re-enroll */
921: ota_learner_enroll_ss.cancel_finance(l_booking_id);
922:
923:
924: -- ----------------------------------------------------------------
925: -- Delegate has no record for this event, hence create a record