DBA Data[Home] [Help]

APPS.INV_GRADE_PKG dependencies on FND_PROFILE

Line 7: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3:
4: PROCEDURE print_debug(p_err_msg VARCHAR2,
5: p_level NUMBER default 4)
6: IS
7: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8: BEGIN
9: IF (l_debug = 1) THEN
10: inv_mobile_helper_functions.tracelog
11: (p_err_msg => p_err_msg,

Line 33: g_eres_enabled varchar2(1):= NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');

29: , p_secondary_quantity IN NUMBER
30: ) IS
31: -- BEGIN SCHANDRU INVERES
32: l_grade_update_id NUMBER := NULL;
33: g_eres_enabled varchar2(1):= NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
34:
35: -- END SCHANDRU INVERES
36:
37: --Global Lot ER Start,added varaibles below for call to quantity tree

Line 55: l_global_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N'); --Global Lot ER

51: l_msg_count pls_integer;
52: l_msg_data varchar2(4000);
53: --Global Lot ER End
54:
55: l_global_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N'); --Global Lot ER
56: l_orgid NUMBER; --Global Lot ER
57: --Global Lot ER Start
58: CURSOR get_all_orgid(p_item_id IN NUMBER, p_lot_number IN VARCHAR2) IS
59: SELECT organization_id