APPS.INV_INV_LOVS dependencies on FND_PROFILE

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

603: FROM mtl_transaction_reasons
604: WHERE reason_name LIKE (p_reason)
605: AND nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE
606: -- nsrivast, invconv , transaction reason security
607: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
608: OR
609: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
610: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
611: AND

Line 1195: AND NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) = 1 -- IF INV: Material Status Support is set to Yes

1191: -- the lot_status only if the parameter is set to 1.
1192: SELECT allow_different_status INTO l_allow_different_status FROM mtl_parameters WHERE organization_id = p_organization_id;
1193:
1194: IF p_status_id IS NOT NULL AND p_status_id <> 0
1195: AND NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) = 1 -- IF INV: Material Status Support is set to Yes
1196: AND l_allow_different_status = 1 THEN -- If Allow Different Lot status is set to 1
1197: l_status_id := p_status_id;
1198: ELSE
1199: l_status_id := '%';

Line 2314: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2310: l_values_or_ids CONSTANT VARCHAR2(1) := 'V';
2311: l_flex_code CONSTANT VARCHAR2(10) := 'GL#';
2312: l_appl_short_name CONSTANT VARCHAR2(10) := 'SQLGL';
2313: l_operation CONSTANT VARCHAR2(20) := 'FIND_COMBINATION';
2314: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2315:
2316: BEGIN
2317:
2318: fnd_flex_key_api.set_session_mode('seed_data');