APPS.GMI_RESERVATION_PVT dependencies on FND_PROFILE

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

341: --
342: -- BUG 3581429 Added the following anonymous block
343: --
344: BEGIN
345: l_epsilon := to_number(NVL(FND_PROFILE.VALUE('IC$EPSILON'),0)) ;
346: n := (-1) * round(log(10,l_epsilon));
347: EXCEPTION
348: WHEN OTHERS THEN
349: n := 9;

Line 1002: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');

998: l_orig_conv_to_new_rsv_qty NUMBER;
999: l_new_rsv_to_item_um_qty NUMBER;
1000: l_new_rsv_to_item_um_qty2 NUMBER;
1001: l_default_lot_quantity NUMBER;
1002: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');
1003: l_old_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1004: l_old_mtl_rsv_tbl_count NUMBER;
1005: x_error_code NUMBER;
1006:

Line 1914: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');

1910: l_inventory_item_id NUMBER;
1911: l_is_noctl BOOLEAN := FALSE;
1912: l_def_trans_qty NUMBER := 0;
1913: l_def_trans_qty2 NUMBER := 0;
1914: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');
1915: /* Bug 3297382 shipset declarations */
1916: l_shipset_id NUMBER;
1917: l_source_header_id NUMBER;
1918: l_shipset_reserved VARCHAR2(1);

Line 2055: -- l_is_grade_ctl := FND_PROFILE.VALUE('IC$AVAILABLE_BY_GRADE');

2051: CLOSE get_whse_code;
2052:
2053: gmi_reservation_util.PRINTLN('Value of Whse Code is '||l_whse_code);
2054: -- Get value of profile
2055: -- l_is_grade_ctl := FND_PROFILE.VALUE('IC$AVAILABLE_BY_GRADE');
2056:
2057:
2058: -- Bug 2499153. Get item ctl.
2059: OPEN get_item_ctl;

Line 2074: l_chk_inv := FND_PROFILE.VALUE('GML_CHK_INV_PICK_REL');

2070: Open get_inventory_item_id;
2071: Fetch get_inventory_item_id into l_inventory_item_id;
2072: Close get_inventory_item_id;
2073:
2074: l_chk_inv := FND_PROFILE.VALUE('GML_CHK_INV_PICK_REL');
2075:
2076:
2077:
2078: gmi_reservation_util.println('check profile GML_CHK_INV_PICK_REL is '||l_chk_inv);

Line 2947: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');

2943: l_source_line_id NUMBER;
2944: l_def_trans_qty NUMBER := 0;
2945: l_def_trans_qty2 NUMBER := 0;
2946: l_shipset_qty_avl NUMBER := 1;
2947: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');
2948: --Bug 3551144
2949: l_high_lev_res_qty NUMBER := 0;
2950: l_high_lev_res_qty2 NUMBER := 0;
2951: l_real_high_lev_res_qty NUMBER := 0;