APPS.WMS_SHIPPING_LOVS dependencies on FND_PROFILE

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

81: , p_source_header_id IN NUMBER
82: , p_parent_delivery_detail_id IN NUMBER
83: , p_order_line IN VARCHAR2
84: ) IS
85: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
86: BEGIN
87: OPEN x_orderline_lov FOR
88: SELECT DISTINCT
89: oel.line_id

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

143: p_order_number IN VARCHAR2,
144: p_equipment_id IN NUMBER := NULL,
145: p_sign_on_emp_id IN NUMBER,
146: p_zone IN VARCHAR2 := NULL) IS
147: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
148: BEGIN
149:
150: OPEN x_orderline_lov FOR
151: SELECT DISTINCT oeh.order_number

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

204: p_pick_slip_number IN VARCHAR2 ,
205: p_equipment_id IN NUMBER := NULL,
206: p_sign_on_emp_id IN NUMBER,
207: p_zone IN VARCHAR2 := NULL ) IS
208: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
209: BEGIN
210:
211: OPEN x_pickslip_lov FOR
212: SELECT DISTINCT mmtt.pick_slip_number