APPS.OTA_TRNG_ENROLL_SS dependencies on OTA_GENERAL

Line 345: -- ,p_business_group_id => ota_general.get_business_group_id);

341: -- so get the ID for the seeded status.
342: --
343: -- l_booking_status_row := Get_Booking_Status_for_web(
344: -- p_web_booking_status_type => 'REQUESTED'
345: -- ,p_business_group_id => ota_general.get_business_group_id);
346:
347: -- ELSE
348:
349: -- The enrollment doesn't need mangerial approval so check the mode

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

363: IF l_event_status in ('F') THEN
364:
365: l_booking_status_row := Get_Booking_Status_for_web
366: (p_web_booking_status_type => 'WAITLISTED'
367: ,p_business_group_id => ota_general.get_business_group_id);
368:
369: l_booking_status_used := 'WAITLISTED';
370:
371: ELSIF l_event_status in ('P') THEN

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

371: ELSIF l_event_status in ('P') THEN
372:
373: l_booking_status_row := Get_Booking_Status_for_web
374: (p_web_booking_status_type => 'REQUESTED'
375: ,p_business_group_id => ota_general.get_business_group_id);
376:
377: l_booking_status_used := 'REQUESTED';
378:
379: ELSIF l_event_status = 'N' THEN

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

380:
381: IF l_maximum_internal_attendees is null then
382: l_booking_status_row := Get_Booking_Status_for_web
383: (p_web_booking_status_type => 'PLACED'
384: ,p_business_group_id => ota_general.get_business_group_id);
385:
386: l_booking_status_used := 'PLACED';
387:
388: ELSE

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

389:
390: IF l_maximum_internal_allowed > 0 THEN
391: l_booking_status_row := Get_Booking_Status_for_web
392: (p_web_booking_status_type => 'PLACED'
393: ,p_business_group_id => ota_general.get_business_group_id);
394:
395: l_booking_status_used := 'PLACED';
396:
397: ELSIF l_maximum_internal_allowed <= 0 THEN

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

396:
397: ELSIF l_maximum_internal_allowed <= 0 THEN
398: l_booking_status_row := Get_Booking_Status_for_web
399: (p_web_booking_status_type => 'WAITLISTED'
400: ,p_business_group_id => ota_general.get_business_group_id);
401:
402: l_booking_status_used := 'WAITLISTED';
403:
404: END IF;

Line 674: ,p_business_group_id => ota_general.get_business_group_id

670: ota_tdb_api_ins2.Create_Enrollment(p_booking_id => l_booking_id
671: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
672: ,p_delegate_person_id => l_delegate_id
673: ,p_contact_id => null
674: ,p_business_group_id => ota_general.get_business_group_id
675: ,p_event_id => p_event_id
676: ,p_date_booking_placed => trunc(sysdate)
677: ,p_corespondent => 'S' --l_corespondent
678: ,p_internal_booking_flag => 'Y'

Line 737: ,p_business_group_id => ota_general.get_business_group_id

733: ota_tdb_api_ins2.Create_Enrollment(p_booking_id => l_booking_id
734: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
735: ,p_delegate_person_id => l_delegate_id
736: ,p_contact_id => null
737: ,p_business_group_id => ota_general.get_business_group_id
738: ,p_event_id => p_event_id
739: ,p_date_booking_placed => trunc(sysdate)
740: ,p_corespondent => 'S' --l_corespondent
741: ,p_internal_booking_flag => 'Y'

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

1520: Begin
1521:
1522: l_booking_status_row := Get_Booking_Status_for_web
1523: (p_web_booking_status_type => 'PLACED'
1524: ,p_business_group_id => ota_general.get_business_group_id);
1525:
1526: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
1527:
1528: IF ota_tdb_bus2.other_bookings_clash(