eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EL_ENROLL_SS dependencies on OTA_GENERAL

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

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

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

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

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

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

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

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

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

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

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

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

Line 682: ,p_business_group_id => ota_general.get_business_group_id

678: ota_tdb_api_ins2.Create_Enrollment(p_booking_id => l_booking_id
679: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
680: ,p_delegate_person_id => l_delegate_id
681: ,p_contact_id => null
682: ,p_business_group_id => ota_general.get_business_group_id
683: ,p_event_id => p_event_id
684: ,p_date_booking_placed => trunc(sysdate)
685: ,p_corespondent => 'S' --l_corespondent
686: ,p_internal_booking_flag => 'Y'

Line 744: ,p_business_group_id => ota_general.get_business_group_id

740: ota_tdb_api_ins2.Create_Enrollment(p_booking_id => l_booking_id
741: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
742: ,p_delegate_person_id => l_delegate_id
743: ,p_contact_id => null
744: ,p_business_group_id => ota_general.get_business_group_id
745: ,p_event_id => p_event_id
746: ,p_date_booking_placed => trunc(sysdate)
747: ,p_corespondent => 'S' --l_corespondent
748: ,p_internal_booking_flag => 'Y'

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

1531: Begin
1532:
1533: l_booking_status_row := Get_Booking_Status_for_web
1534: (p_web_booking_status_type => 'PLACED'
1535: ,p_business_group_id => ota_general.get_business_group_id);
1536:
1537: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
1538:
1539: IF ota_tdb_bus2.other_bookings_clash(

Line 2132: and developer_organization_id=ota_general.get_business_group_id;

2128: is
2129: /* Modified for Bug#3585535
2130: SELECT activity_version_id,end_date from ota_activity_versions
2131: where Activity_version_id = l_activity_id
2132: and developer_organization_id=ota_general.get_business_group_id;
2133: */
2134: SELECT activity_version_id, end_date
2135: FROM ota_activity_versions tav, ota_activity_definitions tad
2136: WHERE tav.activity_id = tad.activity_id

Line 2137: AND tad.business_group_id = ota_general.get_business_group_id

2133: */
2134: SELECT activity_version_id, end_date
2135: FROM ota_activity_versions tav, ota_activity_definitions tad
2136: WHERE tav.activity_id = tad.activity_id
2137: AND tad.business_group_id = ota_general.get_business_group_id
2138: AND tav.activity_version_id = l_activity_id;
2139:
2140:
2141: CURSOR C_GET_EVT_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)

Line 2145: and business_group_id=ota_general.get_business_group_id;

2141: CURSOR C_GET_EVT_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2142: is
2143: SELECT 1 from ota_events
2144: where Activity_version_id=l_activity_id
2145: and business_group_id=ota_general.get_business_group_id;
2146:
2147:
2148:
2149: l_return_value varchar2(10):='V';

Line 2224: and business_group_id=ota_general.get_business_group_id ;

2220: enrolment_end_date
2221: from ota_events
2222: where event_id = l_event_id
2223: and event_type in ('SCHEDULED','SELFPACED')
2224: and business_group_id=ota_general.get_business_group_id ;
2225:
2226:
2227: l_return_value varchar2(10):='V';
2228: l_stDate Date;