DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_GENERAL

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

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

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

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

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

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

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

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

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

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

Line 977: ,p_business_group_id => ota_general.get_business_group_id

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

Line 1047: ,p_business_group_id => ota_general.get_business_group_id

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