DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_GENERAL

Line 779: ,p_business_group_id => ota_general.get_business_group_id);

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';
782:
783: /*ELSIF l_event_status in ('P') THEN

Line 787: ,p_business_group_id => ota_general.get_business_group_id);

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';*/
790:
791: ELSIF l_event_status = 'N' THEN

Line 796: ,p_business_group_id => ota_general.get_business_group_id);

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';
799:
800: ELSE

Line 805: ,p_business_group_id => ota_general.get_business_group_id);

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';
808:
809: ELSIF l_maximum_internal_allowed <= 0 OR l_maximum_external_allowed <= 0 THEN

Line 812: ,p_business_group_id => ota_general.get_business_group_id);

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';
815:
816: END IF;

Line 978: ,p_business_group_id => ota_general.get_business_group_id

974: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
975: ,p_delegate_person_id => l_delegate_id
976: ,p_delegate_contact_id => null
977: ,p_contact_id => null
978: ,p_business_group_id => ota_general.get_business_group_id
979: ,p_event_id => p_event_id
980: -- ,p_date_booking_placed => trunc(sysdate)
981: ,p_date_booking_placed => sysdate
982: ,p_corespondent => l_corespondent

Line 1049: ,p_business_group_id => ota_general.get_business_group_id

1045: ,p_delegate_person_id => l_delegate_id
1046: ,p_delegate_contact_id => p_delegate_contact_id
1047: ,p_customer_id => l_customer_id
1048: ,p_contact_id => null
1049: ,p_business_group_id => ota_general.get_business_group_id
1050: ,p_event_id => p_event_id
1051: -- ,p_date_booking_placed => trunc(sysdate)
1052: ,p_date_booking_placed => sysdate
1053: ,p_corespondent => l_corespondent