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 456: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2432: IS
2433:
2434: l_proc VARCHAR2(72) := g_package || 'get_wf_attr_for_cancel_ntf';
2435:
2436: l_current_userid NUMBER := fnd_profile.value('USER_ID');
2437: l_display_person_id fnd_user.employee_id%TYPE;
2438:
2439: CURSOR person_username_csr (p_person_id IN NUMBER) IS
2440: SELECT user_name

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

2476: hr_utility.set_location('Entering:'||l_proc, 10);
2477: --Enable multi messaging
2478: hr_multi_message.enable_message_list;
2479:
2480: p_current_username := fnd_profile.value('USERNAME');
2481:
2482: -- Get the current user name
2483: OPEN person_username_csr (p_person_id);
2484: FETCH person_username_csr INTO p_current_person_name;