APPS.WMS_TASK_DISPATCH_LOV dependencies on FND_PROFILE

Line 8: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

4:
5: -- Global constant holding the package name
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_LOV';
8: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
9: g_gtin_code_length NUMBER := 14;
10:
11:
12: PROCEDURE mydebug(msg in varchar2)

Line 934: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'

930: WHERE reason_type=p_reason_type
931: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
932: AND reason_name LIKE (p_concat_segments)
933: -- nsrivast, invconv , transaction reason security
934: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
935: OR
936: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
937: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
938: AND

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

1051: p_Organization_Id IN NUMBER,
1052: p_concat_segments IN VARCHAR2)
1053: IS
1054:
1055: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1056: BEGIN
1057: IF (l_debug = 1) THEN
1058: mydebug('In get_device_lov');
1059: END IF;

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

1081: (x_devices OUT NOCOPY t_genref,
1082: p_Employee_Id IN NUMBER,
1083: p_concat_segments IN VARCHAR2)
1084: IS
1085: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1086: BEGIN
1087: IF (l_debug = 1) THEN
1088: mydebug('In get_device_lov');
1089: END IF;

Line 1530: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'

1526: 'UM', l_um_allowed,
1527: 'PL', l_pl_allowed) = 1
1528: AND reason_name LIKE p_concat_segments || '%'
1529: -- nsrivast, invconv , transaction reason security
1530: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1531: OR
1532: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1533: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1534: AND

Line 1563: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'

1559: 'UM', l_um_allowed,
1560: 'PL', l_pl_allowed) = 1
1561: AND reason_name LIKE p_concat_segments || '%'
1562: -- nsrivast, invconv , transaction reason security
1563: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1564: OR
1565: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1566: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1567: AND