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 776: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

772: END IF;
773:
774: IF l_event_status in ('F') THEN
775:
776: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web
777: (p_web_booking_status_type => 'WAITLISTED'
778: ,p_business_group_id => ota_general.get_business_group_id);
779:
780: l_booking_status_used := 'WAITLISTED';

Line 784: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

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

Line 793: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

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

Line 802: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

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

Line 809: l_booking_status_row := ota_learner_enroll_ss.Get_Booking_Status_for_web

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

Line 819: RAISE ota_learner_enroll_ss.g_mesg_on_stack_exception ;

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

Line 824: WHEN ota_learner_enroll_ss.g_mesg_on_stack_exception THEN

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

Line 900: l_cancel_boolean := ota_learner_enroll_ss.Chk_Event_Cancelled_for_Person(

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

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

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

Line 920: ota_learner_enroll_ss.cancel_finance(l_booking_id);

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