DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on FND_PROFILE

Line 2325: l_percent := NVL(Fnd_Profile.Value('AMS_APPROVAL_CUTOFF_PERCENT'),0)/100 ;

2321: IF l_offer_type IN ('SCAN_DATA','LUMPSUM') THEN
2322: l_percent := 1;
2323: ELSE
2324: -- Why is it NVL(profile,0)/100 should it not be NVL(profile,100)/100
2325: l_percent := NVL(Fnd_Profile.Value('AMS_APPROVAL_CUTOFF_PERCENT'),0)/100 ;
2326: END IF;
2327:
2328: Get_line_amounts
2329: ( p_activity_id => p_activity_id,

Line 7148: l_auto_amount := NVL(Fnd_Profile.Value_Specific(name => 'AMS_AUTO_APPROVAL_AMOUNT',

7144: FETCH res_user_csr INTO l_user_id;
7145: CLOSE res_user_csr;
7146:
7147: -- Get the auto approval amount of the approver
7148: l_auto_amount := NVL(Fnd_Profile.Value_Specific(name => 'AMS_AUTO_APPROVAL_AMOUNT',
7149: user_id => l_user_id),0);
7150:
7151: IF l_auto_amount > 0 THEN
7152: