APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on FND_PROFILE

Line 14: v_user_id number := fnd_profile.value('USER_ID');

10: v_err_num VARCHAR2(30) := '';
11: v_err_msg VARCHAR2(1000) := '';
12: v_return_boolean BOOLEAN := FALSE;
13: v_exception_message VARCHAR2(240) := '';
14: v_user_id number := fnd_profile.value('USER_ID');
15: v_login_id number := fnd_profile.value('LOGIN_ID');
16: v_sob_id NUMBER;
17: l_success VARCHAR2(1);
18: l_err_num VARCHAR2(30) := '';

Line 15: v_login_id number := fnd_profile.value('LOGIN_ID');

11: v_err_msg VARCHAR2(1000) := '';
12: v_return_boolean BOOLEAN := FALSE;
13: v_exception_message VARCHAR2(240) := '';
14: v_user_id number := fnd_profile.value('USER_ID');
15: v_login_id number := fnd_profile.value('LOGIN_ID');
16: v_sob_id NUMBER;
17: l_success VARCHAR2(1);
18: l_err_num VARCHAR2(30) := '';
19: l_err_msg VARCHAR2(1000) := '';

Line 44: l_value fnd_profile_option_values.profile_option_value%TYPE;

40: l_upd_header VARCHAR2(1);
41: l_upd_line VARCHAR2(1);
42: l_pay_desc VARCHAR2(35) := 'ota_paying_cc_batch_generated';
43: l_rec_desc VARCHAR2(35) := 'ota_receiving_cc_batch_generated';
44: l_value fnd_profile_option_values.profile_option_value%TYPE;
45: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%type;
46: l_exist varchar2(1);
47: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
48: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

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

44: l_value fnd_profile_option_values.profile_option_value%TYPE;
45: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%type;
46: l_exist varchar2(1);
47: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
48: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
49: l_business_group_id ota_delegate_bookings.business_group_id%type:= null;
50:
51: ---*** New variables declared for Bug#2457158
52: l_booking_id ota_delegate_bookings.booking_id%TYPE;

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

339:
340: IF l_single_business_group_id is not null then
341: l_business_group_id := l_single_business_group_id;
342: ELSE
343: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
344: END IF;
345:
346: --
347: --

Line 350: /* FND_PROFILE.GET('GL_SET_OF_BOOKS_ID', l_value); */

346: --
347: --
348: -- Get Set of Books ID
349: --
350: /* FND_PROFILE.GET('GL_SET_OF_BOOKS_ID', l_value); */
351: v_sob_id := nvl(to_number(l_value),0);
352: --
353: --
354: /*======================================================================+