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

Line 17: l_user_id number := fnd_profile.value('USER_ID');

13: l_err_num VARCHAR2(30) := '';
14: l_err_msg VARCHAR2(1000) := '';
15: l_return_boolean BOOLEAN := FALSE;
16: l_exception_message VARCHAR2(240) := '';
17: l_user_id number := fnd_profile.value('USER_ID');
18: l_login_id number := fnd_profile.value('LOGIN_ID');
19: l_sob_id NUMBER;
20: -- ----------------------------------------------------------------------------
21: -- |---------------------------< delete_cancel_line>--------------------------|

Line 18: l_login_id number := fnd_profile.value('LOGIN_ID');

14: l_err_msg VARCHAR2(1000) := '';
15: l_return_boolean BOOLEAN := FALSE;
16: l_exception_message VARCHAR2(240) := '';
17: l_user_id number := fnd_profile.value('USER_ID');
18: l_login_id number := fnd_profile.value('LOGIN_ID');
19: l_sob_id NUMBER;
20: -- ----------------------------------------------------------------------------
21: -- |---------------------------< delete_cancel_line>--------------------------|
22: -- ----------------------------------------------------------------------------

Line 85: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');

81: l_tfl_ovn ota_finance_lines.object_version_number%type;
82: l_new_fl ota_finance_lines.finance_line_id%type;
83: l_user_name fnd_user.user_name%type;
84:
85: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');
86:
87: l_different_hours number(11,3);
88: l_event_date date;
89: l_current_date date;

Line 215: l_booking_status_type_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');

211: -- Bug # 2707198
212:
213:
214: --Enh#1753511 HDSHAH
215: l_booking_status_type_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
216: l2_event_status := 'A';
217: OTA_EVT_API_UPD2.UPDATE_EVENT (
218: P_EVENT => 'STATUS',
219: P_EVENT_ID => l_event_id,

Line 427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
428: -- Define local variable for status
429: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;
430:
431: -- Define local variable for lines

Line 451: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');

447: l_new_fl ota_finance_lines.finance_line_id%type;
448: l_return_status varchar2(1):= 'T';
449: e_validation_error exception;
450:
451: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');
452:
453: l_different_hours number(11,3);
454: l_event_date date;
455: l_current_date date;

Line 480: --fnd_profile.VALUE('PER_BUSINESS_GROUP_ID');

476: WHERE
477: (daemon_flag = 'Y' OR daemon_flag IS NULL) and
478: daemon_type is not null and
479: business_group_id = l_business_group_id;
480: --fnd_profile.VALUE('PER_BUSINESS_GROUP_ID');
481: -- FOR UPDATE nowait;
482:
483: -- Define status cursor
484:

Line 558: -- l_status_name := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');

554:
555: BEGIN
556:
557: hr_utility.set_location('Entering:'|| l_proc, 5);
558: -- l_status_name := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
559: l_status_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
560: l_auto_waitlist := Fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
561:
562: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Start test of concurrent program');

Line 559: l_status_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');

555: BEGIN
556:
557: hr_utility.set_location('Entering:'|| l_proc, 5);
558: -- l_status_name := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
559: l_status_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
560: l_auto_waitlist := Fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
561:
562: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Start test of concurrent program');
563: IF l_single_business_group_id is not null then

Line 560: l_auto_waitlist := Fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');

556:
557: hr_utility.set_location('Entering:'|| l_proc, 5);
558: -- l_status_name := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
559: l_status_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
560: l_auto_waitlist := Fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
561:
562: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Start test of concurrent program');
563: IF l_single_business_group_id is not null then
564: l_business_group_id := l_single_business_group_id;

Line 566: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

562: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Start test of concurrent program');
563: IF l_single_business_group_id is not null then
564: l_business_group_id := l_single_business_group_id;
565: ELSE
566: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
567: END IF;
568:
569: OPEN C_ENROLLMENT;
570: LOOP

Line 1164: p_user_id := fnd_profile.value('USER_ID');

1160: failure exception;
1161: l_proc varchar2(72) := g_package||'initial_cancel_enrollment';
1162:
1163: BEGIN
1164: p_user_id := fnd_profile.value('USER_ID');
1165: p_login_id := fnd_profile.value('LOGIN_ID');
1166:
1167: ota_cancel_api.cancel_enrollment(p_user_id,
1168: p_login_id);

Line 1165: p_login_id := fnd_profile.value('LOGIN_ID');

1161: l_proc varchar2(72) := g_package||'initial_cancel_enrollment';
1162:
1163: BEGIN
1164: p_user_id := fnd_profile.value('USER_ID');
1165: p_login_id := fnd_profile.value('LOGIN_ID');
1166:
1167: ota_cancel_api.cancel_enrollment(p_user_id,
1168: p_login_id);
1169: EXCEPTION