APPS.INV_INV_LOVS dependencies on FND_PROFILE

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

625: FROM mtl_transaction_reasons
626: WHERE reason_name LIKE (p_reason)
627: AND nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE
628: -- nsrivast, invconv , transaction reason security
629: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
630: OR
631: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
632: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
633: AND

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

1215: -- the lot_status only if the parameter is set to 1.
1216: SELECT allow_different_status INTO l_allow_different_status FROM mtl_parameters WHERE organization_id = p_organization_id;
1217:
1218: IF p_status_id IS NOT NULL AND p_status_id <> 0
1219: AND NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) = 1 -- IF INV: Material Status Support is set to Yes
1220: AND l_allow_different_status = 1 THEN -- If Allow Different Lot status is set to 1
1221: l_status_id := p_status_id;
1222: ELSE
1223: l_status_id := '%';

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

2340: l_values_or_ids CONSTANT VARCHAR2(1) := 'V';
2341: l_flex_code CONSTANT VARCHAR2(10) := 'GL#';
2342: l_appl_short_name CONSTANT VARCHAR2(10) := 'SQLGL';
2343: l_operation CONSTANT VARCHAR2(20) := 'FIND_COMBINATION';
2344: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2345:
2346: BEGIN
2347:
2348: fnd_flex_key_api.set_session_mode('seed_data');