APPS.OTA_ILEARNING2 dependencies on FND_PROFILE

Line 68: l_auto_transfer varchar2(4) := FND_PROFILE.VALUE('OTA_SSHR_AUTO_GL_TRANSFER');

64: l_cur_tdb_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_ID%TYPE;
66: l_status_type OTA_BOOKING_STATUS_TYPES.TYPE%type;
67: l_date_booking_placed OTA_DELEGATE_BOOKINGS.DATE_BOOKING_PLACED%TYPE;
68: l_auto_transfer varchar2(4) := FND_PROFILE.VALUE('OTA_SSHR_AUTO_GL_TRANSFER');
69: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
70: l_finance_header_ovn OTA_FINANCE_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
71: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE;
72:

Line 69: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');

65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_ID%TYPE;
66: l_status_type OTA_BOOKING_STATUS_TYPES.TYPE%type;
67: l_date_booking_placed OTA_DELEGATE_BOOKINGS.DATE_BOOKING_PLACED%TYPE;
68: l_auto_transfer varchar2(4) := FND_PROFILE.VALUE('OTA_SSHR_AUTO_GL_TRANSFER');
69: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
70: l_finance_header_ovn OTA_FINANCE_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
71: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE;
72:
73: cursor cur_get_booking_id is

Line 262: l_booking_status_type_id := FND_PROFILE.VALUE('OTA_ILEARNING_DEFAULT_ATTENDED');

258:
259: FOR status_type in csr_booking_status(l_cur_booking_status_type_id)
260: LOOP
261: if status_type.type <> 'A' then
262: l_booking_status_type_id := FND_PROFILE.VALUE('OTA_ILEARNING_DEFAULT_ATTENDED');
263: if l_booking_status_type_id is null then
264: FND_FILE.PUT_LINE(FND_FILE.LOG,'You must enter a default Attended Enrollment Status for the profile OTA:Default Attended Enrollment Status.');
265: p_message := 'ERROR: Default booking_status_type_id not found ';
266: -- dbms_output.put_line(p_message);