APPS.INV_UI_RCV_LOVS dependencies on FND_PROFILE

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

1042: FROM mtl_transaction_reasons
1043: WHERE NVL(disable_date,SYSDATE + 1) > SYSDATE
1044: AND reason_name LIKE (p_reason_code)
1045: -- nsrivast, invconv , transaction reason security
1046: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1047: OR
1048: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1049: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1050: AND

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

3193:
3194: IS
3195: -- Changes for GTIN CrossRef Type
3196: --
3197: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
3198: g_gtin_code_length NUMBER := 14;
3199: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
3200: l_from_lpn_id VARCHAR2(400) := p_from_lpn_id;
3201:

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

7172: x_Items OUT NOCOPY t_genref,
7173: p_Organization_Id IN NUMBER default null ,
7174: p_Concatenated_Segments IN VARCHAR2 default null )
7175: IS
7176: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
7177: g_gtin_code_length NUMBER := 14;
7178: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
7179: BEGIN
7180: open x_items for

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

7485: )
7486:
7487: IS
7488:
7489: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
7490: g_gtin_code_length NUMBER := 14;
7491: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
7492:
7493: BEGIN

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

8317: --Bug No: 5246626:Added the procedures Print_debug and GET_RCV_SHP_FLEX_DETAILS
8318:
8319: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
8320:
8321: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8322:
8323: BEGIN
8324: IF (l_debug = 1) THEN
8325: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'inv_ui_rcv_lovs', p_level => p_level);