APPS.OTA_CANCEL_TRAINING_SS dependencies on FND_PROFILE

Line 54: l_current_username VARCHAR2(80):= fnd_profile.value('USERNAME');

50: --
51: IS
52: --
53: l_proc VARCHAR2(72) := 'ota_cancel_enrollment_ss.create_enroll_wf_process';
54: l_current_username VARCHAR2(80):= fnd_profile.value('USERNAME');
55: l_current_userid NUMBER := fnd_profile.value('USER_ID');
56: l_display_person_id fnd_user.employee_id%TYPE;
57: l_current_person_name VARCHAR2(80);
58: l_person_displayname per_all_people_f.full_name%TYPE;

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

51: IS
52: --
53: l_proc VARCHAR2(72) := 'ota_cancel_enrollment_ss.create_enroll_wf_process';
54: l_current_username VARCHAR2(80):= fnd_profile.value('USERNAME');
55: l_current_userid NUMBER := fnd_profile.value('USER_ID');
56: l_display_person_id fnd_user.employee_id%TYPE;
57: l_current_person_name VARCHAR2(80);
58: l_person_displayname per_all_people_f.full_name%TYPE;
59: l_creator_displayname per_all_people_f.full_name%TYPE;

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

455: l_owner_id;
456: CLOSE event_csr;
457: --
458: IF l_owner_id IS NULL THEN
459: l_owner_id := fnd_profile.value('OTA_DEFAULT_EVENT_OWNER');
460: END IF;
461:
462:
463: OPEN c_user(l_owner_id);

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

484: --End Bug 2700158--
485:
486: IF finance_csr%found THEN
487: --
488: l_minimum_advance_notice := NVL(TO_NUMBER(fnd_profile.value('OTA_CANCEL_HOURS_BEFORE_EVENT')), 0);
489: --
490: --l_hours_until_class_starts := 24*(to_date(to_char(l_course_start_date, 'DD-MON-YYYY')||''||l_course_start_time, 'DD/MM/YYYYHH24:MI') - SYSDATE);
491:
492:

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

543: CLOSE finance_csr;
544: --
545: -- Initialize workflow setings
546: --
547: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
548: --
549: IF (p_waitlist_size > 0) THEN
550: --
551: IF (l_hours_until_class_starts >= l_auto_waitlist_days) THEN