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_DELEGATE_BOOKING_API dependencies on FND_PROFILE

Line 205: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');

201: begin
202:
203: if(p_finance_header_id is null) then
204:
205: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
206: l_user := FND_PROFILE.value('USER_ID');
207:
208: open bg_to;
209: fetch bg_to into l_business_group_id_to,

Line 206: l_user := FND_PROFILE.value('USER_ID');

202:
203: if(p_finance_header_id is null) then
204:
205: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
206: l_user := FND_PROFILE.value('USER_ID');
207:
208: open bg_to;
209: fetch bg_to into l_business_group_id_to,
210: l_sponsor_organization_id,

Line 821: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');

817: p_booking_deal_type => p_booking_deal_type,
818: p_object_version_number => l_dummy,
819: p_finance_line_id => p_finance_line_id);
820:
821: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
822: if l_automatic_transfer_gl = 'Y' AND p_finance_line_id IS NOT NULL THEN
823: UPDATE ota_finance_lines SET transfer_status = 'AT'
824: WHERE finance_line_id = p_finance_line_id;
825: end if;

Line 1454: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));

1450: --bug# 5231470 first date format changed from DD-MON-YYYY to DD/MM/YYYY
1451: l_hours_until_class_starts := 24*(to_date(to_char(l_course_start_date, 'DD/MM/YYYY')
1452: ||''||l_course_start_time, 'DD/MM/YYYYHH24:MI') - SYSDATE);
1453:
1454: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
1455: --
1456: OPEN csr_get_waitlist_count(l_event_id);
1457: FETCH csr_get_waitlist_count INTO l_waitlist_count;
1458: IF (csr_get_waitlist_count%FOUND)

Line 2437: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');

2433: --bug 603768 changes starts
2434: --Send ntf to class owner if any enrollment has been cancelled
2435: --or deleted or class changed
2436: l_old_event_id := ota_tdb_shd.g_old_rec.event_id;
2437: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
2438: l_waitlist_size := ota_utility.students_on_waitlist(l_old_event_id);
2439:
2440: if (l_auto_waitlist = 'Y' and l_waitlist_size > 0) then
2441:

Line 2452: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));

2448: if ( l_course_start_date is not null ) then
2449: l_hours_until_class_starts := 24*(to_date(to_char(l_course_start_date, 'DD-MM-YYYY')||''||l_course_start_time, 'DD/MM/YYYYHH24:MI') - SYSDATE);
2450: end if;
2451:
2452: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
2453:
2454: if (l_hours_until_class_starts <= nvl(l_auto_waitlist_days,0) )then
2455:
2456: OPEN sys_date_csr;

Line 2461: l_owner_id := fnd_profile.value('OTA_DEFAULT_EVENT_OWNER');

2457: FETCH sys_date_csr INTO l_sysdate;
2458: CLOSE sys_date_csr;
2459:
2460: if (l_owner_id is null) then
2461: l_owner_id := fnd_profile.value('OTA_DEFAULT_EVENT_OWNER');
2462: end if;
2463:
2464: OPEN fnduser_csr(l_owner_id);
2465: FETCH fnduser_csr INTO l_username;

Line 2984: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');

2980: end;
2981:
2982: -- 6063768 changes starts
2983: --Send ntf to class owner if any enrollment has been deleted
2984: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
2985: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
2986:
2987: if (l_auto_waitlist is not null and l_auto_waitlist = 'Y' ) then
2988:

Line 2985: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));

2981:
2982: -- 6063768 changes starts
2983: --Send ntf to class owner if any enrollment has been deleted
2984: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
2985: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
2986:
2987: if (l_auto_waitlist is not null and l_auto_waitlist = 'Y' ) then
2988:
2989: OPEN booking_csr (p_booking_id);

Line 3018: l_owner_id := fnd_profile.value('OTA_DEFAULT_EVENT_OWNER');

3014: FETCH sys_date_csr INTO l_sysdate;
3015: CLOSE sys_date_csr;
3016:
3017: if (l_owner_id is null) then
3018: l_owner_id := fnd_profile.value('OTA_DEFAULT_EVENT_OWNER');
3019: end if;
3020:
3021: OPEN fnduser_csr(l_owner_id);
3022: FETCH fnduser_csr INTO l_username;