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 315: ,p_business_group_id => ota_general.get_business_group_id);

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

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

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

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

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

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

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

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

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

Line 526: ,p_business_group_id => ota_general.get_business_group_id

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

Line 591: ,p_business_group_id => ota_general.get_business_group_id

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

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

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

Line 1492: l_per_organization_id := ota_general.get_business_group_id;

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

Line 2212: and business_group_id = ota_general.get_business_group_id;

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

Line 2219: and business_group_id = ota_general.get_business_group_id;

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

Line 2286: and business_group_id = ota_general.get_business_group_id;

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

Line 2293: and business_group_id = ota_general.get_business_group_id;

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

Line 2362: and business_group_id = ota_general.get_business_group_id ;

2358: SELECT event_id,event_status,course_start_date,course_end_date,enrolment_start_date, enrolment_end_date, course_end_time
2359: from ota_events
2360: where event_id = l_event_id
2361: and event_type in ('SCHEDULED','SELFPACED')
2362: and business_group_id = ota_general.get_business_group_id ;
2363:
2364:
2365: l_return_value varchar2(10):='V';
2366: l_stDate Date;

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

2598: Begin
2599:
2600: l_booking_status_row := Get_Booking_Status_for_web
2601: (p_web_booking_status_type => 'CANCELLED'
2602: ,p_business_group_id => ota_general.get_business_group_id);
2603:
2604: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
2605: RETURN l_booking_status_type_id;
2606: End getCancellationStatusId;