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 FND_PROFILE

Line 233: l_source_of_booking := fnd_profile.value('OTA_DEFAULT_ENROLLMENT_SOURCE');

229: l_delegate_id := p_person_id;
230: l_person_address_type := 'I';
231: l_corespondent := 'S';
232: --l_source_of_booking := 'E'; Bug 5580960: removed hardcoding. Now Source of Booking will be decided by profile value OTA_DEFAULT_ENROLLMENT_SOURCE
233: l_source_of_booking := fnd_profile.value('OTA_DEFAULT_ENROLLMENT_SOURCE');
234:
235: l_restricted_assignment_id := CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id
236: ,p_event_id => p_event_id);
237:

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

453: ,p_delegate_person_id => l_delegate_id
454: ,p_delegate_contact_id => p_delegate_contact_id
455: ,p_booking_id => l_booking_id);
456:
457: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
458: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
459: l_user := FND_PROFILE.value('USER_ID');
460:
461: IF (l_cancel_boolean) THEN

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

454: ,p_delegate_contact_id => p_delegate_contact_id
455: ,p_booking_id => l_booking_id);
456:
457: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
458: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
459: l_user := FND_PROFILE.value('USER_ID');
460:
461: IF (l_cancel_boolean) THEN
462: --

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

455: ,p_booking_id => l_booking_id);
456:
457: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
458: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
459: l_user := FND_PROFILE.value('USER_ID');
460:
461: IF (l_cancel_boolean) THEN
462: --
463: -- Delegate has a Cancelled status for this event, hence

Line 801: l_minimum_advance_notice := NVL(TO_NUMBER(fnd_profile.value('OTA_CANCEL_HOURS_BEFORE_EVENT')), 0);

797: lf_object_version_number,
798: l_sequence_number,
799: l_cancelled_flag ;
800:
801: l_minimum_advance_notice := NVL(TO_NUMBER(fnd_profile.value('OTA_CANCEL_HOURS_BEFORE_EVENT')), 0);
802: l_hours_until_class_starts := 0;
803: IF ( l_course_start_date IS NOT NULL ) THEN
804: 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);
805: END IF;

Line 1552: AND( nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

1548: SELECT a.assignment_id
1549: FROM per_all_assignments_f a
1550: WHERE a.person_id = p_delegate_id
1551: --Modified for bug#5032859
1552: AND( nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
1553: OR
1554: NVL(p_course_start_date,trunc(sysdate)) BETWEEN
1555: a.effective_start_date AND a.effective_end_date
1556: )

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

1928: l_owner_id;
1929: CLOSE event_csr;
1930:
1931: IF l_owner_id IS NULL THEN
1932: l_owner_id := fnd_profile.value('OTA_DEFAULT_EVENT_OWNER');
1933: END IF;
1934:
1935: OPEN c_user(l_owner_id);
1936: FETCH c_user INTO l_username;

Line 1964: l_minimum_advance_notice := NVL(TO_NUMBER(fnd_profile.value('OTA_CANCEL_HOURS_BEFORE_EVENT')), 0);

1960: 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);
1961: End If;
1962:
1963: IF finance_csr%found THEN
1964: l_minimum_advance_notice := NVL(TO_NUMBER(fnd_profile.value('OTA_CANCEL_HOURS_BEFORE_EVENT')), 0);
1965:
1966: IF l_transfer_status = 'ST' OR
1967: l_cancelled_flag = 'Y' OR
1968: l_content_player_status IS NOT NULL OR

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

2006: */
2007: --
2008: -- Initialize workflow setings
2009: --
2010: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
2011: --
2012: IF (p_waitlist_size > 0) THEN
2013: IF (l_hours_until_class_starts >= l_auto_waitlist_days) THEN
2014: l_daemon_flag := 'Y';

Line 2444: l_current_userid NUMBER := fnd_profile.value('USER_ID');

2440: IS
2441:
2442: l_proc VARCHAR2(72) := g_package || 'get_wf_attr_for_cancel_ntf';
2443:
2444: l_current_userid NUMBER := fnd_profile.value('USER_ID');
2445: l_display_person_id fnd_user.employee_id%TYPE;
2446:
2447: CURSOR person_username_csr (p_person_id IN NUMBER) IS
2448: SELECT user_name

Line 2488: p_current_username := fnd_profile.value('USERNAME');

2484: hr_utility.set_location('Entering:'||l_proc, 10);
2485: --Enable multi messaging
2486: hr_multi_message.enable_message_list;
2487:
2488: p_current_username := fnd_profile.value('USERNAME');
2489:
2490: -- Get the current user name
2491: OPEN person_username_csr (p_person_id);
2492: FETCH person_username_csr INTO p_current_person_name;