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_LEARNER_ENROLL_SS dependencies on OTA_GENERAL

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

312: IF l_event_status in ('F','P') THEN
313:
314: l_booking_status_row := Get_Booking_Status_for_web
315: (p_web_booking_status_type => 'WAITLISTED'
316: ,p_business_group_id => ota_general.get_business_group_id);
317:
318: l_booking_status_used := 'WAITLISTED';
319:
320: /* ELSIF l_event_status in ('P') THEN

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

320: /* ELSIF l_event_status in ('P') THEN
321:
322: l_booking_status_row := Get_Booking_Status_for_web
323: (p_web_booking_status_type => 'REQUESTED'
324: ,p_business_group_id => ota_general.get_business_group_id);
325:
326: l_booking_status_used := 'REQUESTED';*/
327:
328: ELSIF l_event_status = 'N' THEN

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

329:
330: IF l_maximum_internal_attendees is null then
331: l_booking_status_row := Get_Booking_Status_for_web
332: (p_web_booking_status_type => 'PLACED'
333: ,p_business_group_id => ota_general.get_business_group_id);
334:
335: l_booking_status_used := 'PLACED';
336:
337: ELSE

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

338:
339: IF l_maximum_internal_allowed > 0 OR l_maximum_external_allowed > 0 THEN
340: l_booking_status_row := Get_Booking_Status_for_web
341: (p_web_booking_status_type => 'PLACED'
342: ,p_business_group_id => ota_general.get_business_group_id);
343:
344: l_booking_status_used := 'PLACED';
345:
346: ELSIF l_maximum_internal_allowed <= 0 OR l_maximum_external_allowed <= 0 THEN

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

345:
346: ELSIF l_maximum_internal_allowed <= 0 OR l_maximum_external_allowed <= 0 THEN
347: l_booking_status_row := Get_Booking_Status_for_web
348: (p_web_booking_status_type => 'WAITLISTED'
349: ,p_business_group_id => ota_general.get_business_group_id);
350:
351: l_booking_status_used := 'WAITLISTED';
352:
353: END IF;

Line 527: ,p_business_group_id => ota_general.get_business_group_id

523: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
524: ,p_delegate_person_id => l_delegate_id
525: ,p_delegate_contact_id => null
526: ,p_contact_id => null
527: ,p_business_group_id => ota_general.get_business_group_id
528: ,p_event_id => p_event_id
529: --,p_date_booking_placed => trunc(sysdate)
530: ,p_date_booking_placed => sysdate
531: ,p_corespondent => l_corespondent

Line 592: ,p_business_group_id => ota_general.get_business_group_id

588: ,p_delegate_person_id => l_delegate_id
589: ,p_delegate_contact_id => p_delegate_contact_id
590: ,p_customer_id => l_customer_id
591: ,p_contact_id => null
592: ,p_business_group_id => ota_general.get_business_group_id
593: ,p_event_id => p_event_id
594: --,p_date_booking_placed => trunc(sysdate)
595: ,p_date_booking_placed => sysdate
596: ,p_corespondent => l_corespondent

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

1408: Begin
1409:
1410: l_booking_status_row := Get_Booking_Status_for_web
1411: (p_web_booking_status_type => 'PLACED'
1412: ,p_business_group_id => ota_general.get_business_group_id);
1413:
1414: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
1415:
1416: IF ota_tdb_bus2.other_bookings_clash(

Line 1493: l_per_organization_id := ota_general.get_business_group_id;

1489: ELSE
1490: CLOSE C_GET_ORG_ID;
1491: END IF;
1492: ELSE
1493: l_per_organization_id := ota_general.get_business_group_id;
1494: END IF;
1495: if l_per_organization_id = l_evt_organization_id then
1496: l_return_value := '-1';
1497: else

Line 2213: and business_group_id = ota_general.get_business_group_id;

2209: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2210: is
2211: SELECT activity_version_id,end_date from ota_activity_versions
2212: where Activity_version_id = l_activity_id
2213: and business_group_id = ota_general.get_business_group_id;
2214:
2215:
2216: CURSOR C_GET_OFR_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2217: is

Line 2220: and business_group_id = ota_general.get_business_group_id;

2216: CURSOR C_GET_OFR_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2217: is
2218: SELECT 1 from ota_offerings
2219: where Activity_version_id = l_activity_id
2220: and business_group_id = ota_general.get_business_group_id;
2221:
2222:
2223: l_return_value varchar2(10):='V';
2224: l_date Date;

Line 2287: and business_group_id = ota_general.get_business_group_id;

2283: CURSOR C_GET_OFR_DET(l_offering_id OTA_OFFERINGS.offering_id%type)
2284: is
2285: SELECT offering_id,end_date from ota_offerings
2286: where offering_id = l_offering_id
2287: and business_group_id = ota_general.get_business_group_id;
2288:
2289:
2290: CURSOR C_GET_EVT_ATTACHED(l_offering_id OTA_OFFERINGS.offering_id%type)
2291: is

Line 2294: and business_group_id = ota_general.get_business_group_id;

2290: CURSOR C_GET_EVT_ATTACHED(l_offering_id OTA_OFFERINGS.offering_id%type)
2291: is
2292: SELECT 1 from ota_events
2293: where parent_offering_id = l_offering_id
2294: and business_group_id = ota_general.get_business_group_id;
2295:
2296:
2297: l_return_value varchar2(10):='V';
2298: l_date Date;

Line 2370: and business_group_id=ota_general.get_business_group_id;

2366: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone) sys_date
2367: from ota_events
2368: where event_id = l_event_id
2369: and event_type in ('SCHEDULED','SELFPACED')
2370: and business_group_id=ota_general.get_business_group_id;
2371:
2372: l_return_value varchar2(10):='V';
2373: l_stDate Date;
2374: l_endDate Date;

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

2606: Begin
2607:
2608: l_booking_status_row := Get_Booking_Status_for_web
2609: (p_web_booking_status_type => 'CANCELLED'
2610: ,p_business_group_id => ota_general.get_business_group_id);
2611:
2612: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
2613: RETURN l_booking_status_type_id;
2614: End getCancellationStatusId;