APPS.GMI_RESERVATION_UTIL dependencies on FND_PROFILE

Line 1866: l_debug_level VARCHAR2(240) := fnd_profile.value ('ONT_DEBUG_LEVEL');

1862:
1863: l_api_name CONSTANT VARCHAR2 (30) := 'PrintLn';
1864: l_location VARCHAR2(255);
1865: l_log UTL_FILE.file_type;
1866: l_debug_level VARCHAR2(240) := fnd_profile.value ('ONT_DEBUG_LEVEL');
1867: l_time VARCHAR2(10);
1868: l_file_name VARCHAR2(80);
1869:
1870: BEGIN

Line 2347: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')

2343: , oe_transaction_types_tl tt
2344: , mtl_sales_orders mtl
2345: WHERE mtl.segment1 = to_char(soh.order_number)
2346: AND mtl.segment2 = tt.name
2347: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
2348: -- AND tt.language = userenv('LANG') -- OPM bug 3770264
2349: AND tt.language = (select language_code -- OPM bug 3770264
2350: from fnd_languages
2351: where installed_flag = 'B')

Line 3780: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')

3776: -- AND tt.language = userenv('LANG') -- OPM bug 3770264
3777: AND tt.language = (select language_code -- OPM bug 3770264
3778: from fnd_languages
3779: where installed_flag = 'B')
3780: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
3781: AND tt.transaction_type_id = soh.order_type_id
3782: AND sol.header_id = soh.header_id;
3783: Cursor get_uom IS
3784: Select item_um, item_um2

Line 3918: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')

3914: oe_transaction_types_tl tt
3915: Where sol.line_id = p_line_id
3916: AND mtl.segment1 = to_char(soh.order_number)
3917: AND mtl.segment2 = tt.name
3918: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
3919: --AND tt.language = userenv('LANG') -- OPM bug 3770264
3920: AND tt.language = (select language_code -- OPM bug 3770264
3921: from fnd_languages
3922: where installed_flag = 'B')

Line 4469: l_epsilon := to_number(NVL(FND_PROFILE.VALUE('IC$EPSILON'),0)) ;

4465: --
4466: -- BUG 3581429 Added the following anonymous block
4467: --
4468: BEGIN
4469: l_epsilon := to_number(NVL(FND_PROFILE.VALUE('IC$EPSILON'),0)) ;
4470: n := (-1) * round(log(10,l_epsilon));
4471: EXCEPTION
4472: WHEN OTHERS THEN
4473: n := 9;

Line 4480: l_ALLOW_OPM_TRUNCATE_TXN := nvl(fnd_profile.value ('ALLOW_OPM_TRUNCATE_TXN'),'N');

4476: GMI_reservation_Util.PrintLn('converted_qty '|| l_converted_qty);
4477: --
4478: -- Bug 3776538 - See if the converted qty should be trucated rather than rounded!
4479: --
4480: l_ALLOW_OPM_TRUNCATE_TXN := nvl(fnd_profile.value ('ALLOW_OPM_TRUNCATE_TXN'),'N');
4481: GMI_Reservation_Util.PrintLn('Profile: ALLOW_OPM_TRUNCATE_TXN '||l_ALLOW_OPM_TRUNCATE_TXN);
4482: IF (l_ALLOW_OPM_TRUNCATE_TXN = 'Y') THEN
4483: l_converted_qty:=trunc(l_converted_qty, l_TRUNCATE_TO_LENGTH);
4484: GMI_reservation_Util.PrintLn('converted_qty after truncating '|| l_converted_qty);