700:
701: /* Bug 3966257. Removed tolerance calculations. */
702:
703: ln_max_rate := x_rate * (1 + NVL(allowance_rec.exchange_rate_allowance,0)/100);
704: lv_inverse_rate := fnd_profile.VALUE('DISPLAY_INVERSE_RATE');
705:
706: IF ln_max_rate is null OR ln_max_rate = 0 THEN
707: return to_number(null);
708: ELSIF lv_inverse_rate = 'Y' THEN
1713: *=======================================================================*/
1714: FUNCTION get_default_security_profile(p_user_id IN NUMBER) RETURN NUMBER IS
1715:
1716: CURSOR profile_cur IS
1717: SELECT FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
1718: FROM FND_USER u,
1719: FND_USER_RESP_GROUPS g,
1720: FND_RESPONSIBILITY r,
1721: FND_FORM_FUNCTIONS f
2372: lv_payment_due_from_prof VARCHAR2(100);
2373: lv_payment_due_from VARCHAR2(100);
2374:
2375: BEGIN
2376: lv_payment_due_from_prof := FND_PROFILE.VALUE('SSE_CC_PAYMENT_DUE_FROM');
2377:
2378: IF p_trx_id IS NULL THEN
2379: RETURN lv_payment_due_from_prof;
2380: END IF;
2762: l_n_resp_appl_id := WF_ENGINE.GetItemAttrNumber(l_item_type,
2763: l_item_key,
2764: 'APPLICATION_ID');
2765:
2766: lv_return_value := fnd_profile.VALUE_SPECIFIC(p_profile_name,
2767: l_n_user_id,
2768: l_n_resp_id,
2769: l_n_resp_appl_id,
2770: l_n_org_id);