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
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
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
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
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;
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
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