APPS.OTA_ENROLL_IN_TRAINING_SS dependencies on OTA_GENERAL

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

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

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

367: IF l_event_status in ('F') THEN
368:
369: l_booking_status_row := Get_Booking_Status_for_web
370: (p_web_booking_status_type => 'WAITLISTED'
371: ,p_business_group_id => ota_general.get_business_group_id);
372:
373: l_booking_status_used := 'WAITLISTED';
374:
375: ELSIF l_event_status in ('P') THEN

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

375: ELSIF l_event_status in ('P') THEN
376:
377: l_booking_status_row := Get_Booking_Status_for_web
378: (p_web_booking_status_type => 'REQUESTED'
379: ,p_business_group_id => ota_general.get_business_group_id);
380:
381: l_booking_status_used := 'REQUESTED';
382:
383: ELSIF l_event_status = 'N' THEN

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

384:
385: IF l_maximum_internal_attendees is null then
386: l_booking_status_row := Get_Booking_Status_for_web
387: (p_web_booking_status_type => 'PLACED'
388: ,p_business_group_id => ota_general.get_business_group_id);
389:
390: l_booking_status_used := 'PLACED';
391:
392: ELSE

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

393:
394: IF l_maximum_internal_allowed > 0 THEN
395: l_booking_status_row := Get_Booking_Status_for_web
396: (p_web_booking_status_type => 'PLACED'
397: ,p_business_group_id => ota_general.get_business_group_id);
398:
399: l_booking_status_used := 'PLACED';
400:
401: ELSIF l_maximum_internal_allowed <= 0 THEN

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

400:
401: ELSIF l_maximum_internal_allowed <= 0 THEN
402: l_booking_status_row := Get_Booking_Status_for_web
403: (p_web_booking_status_type => 'WAITLISTED'
404: ,p_business_group_id => ota_general.get_business_group_id);
405:
406: l_booking_status_used := 'WAITLISTED';
407:
408: END IF;

Line 673: ,p_business_group_id => ota_general.get_business_group_id

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

Line 736: ,p_business_group_id => ota_general.get_business_group_id

732: ota_tdb_api_ins2.Create_Enrollment(p_booking_id => l_booking_id
733: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
734: ,p_delegate_person_id => l_delegate_id
735: ,p_contact_id => null
736: ,p_business_group_id => ota_general.get_business_group_id
737: ,p_event_id => p_event_id
738: ,p_date_booking_placed => trunc(sysdate)
739: ,p_corespondent => 'S' --l_corespondent
740: ,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(