DBA Data[Home] [Help]

APPS.HR_EFC_INFO dependencies on HR_CURRENCY_PKG

Line 146: -- IF hr_currency_pkg.efc_is_ncu_currency(l_currency) THEN

142: BEGIN
143: --
144: l_currency := get_bg_currency(p_bg);
145: --
146: -- IF hr_currency_pkg.efc_is_ncu_currency(l_currency) THEN
147: -- l_valid := 'Y';
148: -- END IF;
149: -- The above has been commented out, to allow processing for business
150: -- groups that are based on non-NCU currency codes.

Line 157: ELSIF hr_currency_pkg.efc_is_ncu_currency(l_currency) THEN

153: -- Error will already have been raised if cannot find BG currency.
154: -- fnd_message.set_name('PER','PER_52702_EFC_BG_CURR_IS_NULL');
155: -- fnd_message.raise_error;
156: null;
157: ELSIF hr_currency_pkg.efc_is_ncu_currency(l_currency) THEN
158: l_valid := 'Y';
159: ELSE
160: -- Currency is non-NCU currency (and may be 'EUR')
161: l_valid := 'N';

Line 183: IF hr_currency_pkg.efc_is_ncu_currency(p_currency_code) THEN

179: --
180: IF ((p_currency_code <> g_last_currency_code) OR
181: (g_last_currency_code IS NULL)) THEN
182: -- Fetch return currency code
183: IF hr_currency_pkg.efc_is_ncu_currency(p_currency_code) THEN
184: g_return_currency_code := 'EUR';
185: ELSE
186: g_return_currency_code := p_currency_code;
187: END IF;

Line 212: l_return := hr_currency_pkg.efc_convert_varchar2_amount

208: l_return := NULL;
209: ELSE
210: IF p_currency IS NULL THEN
211: -- Use bg's currency
212: l_return := hr_currency_pkg.efc_convert_varchar2_amount
213: (hr_efc_info.get_bg_currency(p_bg)
214: ,p_value);
215: ELSE
216: l_return := hr_currency_pkg.efc_convert_varchar2_amount

Line 216: l_return := hr_currency_pkg.efc_convert_varchar2_amount

212: l_return := hr_currency_pkg.efc_convert_varchar2_amount
213: (hr_efc_info.get_bg_currency(p_bg)
214: ,p_value);
215: ELSE
216: l_return := hr_currency_pkg.efc_convert_varchar2_amount
217: (p_currency
218: ,p_value);
219: END IF;
220: END IF;

Line 243: l_return := hr_currency_pkg.efc_convert_varchar2_amount

239: l_return := NULL;
240: ELSE
241: IF p_currency IS NULL THEN
242: -- Use bg's currency
243: l_return := hr_currency_pkg.efc_convert_varchar2_amount
244: (hr_efc_info.get_bg_currency(p_bg)
245: ,p_value);
246: ELSE
247: l_return := hr_currency_pkg.efc_convert_varchar2_amount

Line 247: l_return := hr_currency_pkg.efc_convert_varchar2_amount

243: l_return := hr_currency_pkg.efc_convert_varchar2_amount
244: (hr_efc_info.get_bg_currency(p_bg)
245: ,p_value);
246: ELSE
247: l_return := hr_currency_pkg.efc_convert_varchar2_amount
248: (p_currency
249: ,p_value);
250: END IF;
251: END IF;

Line 308: l_return := hr_currency_pkg.efc_convert_varchar2_amount

304: -- Check whether or not we want to convert
305: IF hr_efc_info.validate_hr_summary
306: (p_context1,p_context2,p_bg) = 'Y' THEN
307: -- Convert according to BG's currency
308: l_return := hr_currency_pkg.efc_convert_varchar2_amount
309: (hr_efc_info.get_bg_currency(p_bg)
310: ,p_value);
311: ELSE
312: -- We dont want to convert, return original value

Line 344: IF hr_currency_pkg.efc_is_ncu_currency(p_currency) THEN

340: --
341: IF p_value IS NULL THEN
342: l_return := NULL;
343: ELSE
344: IF hr_currency_pkg.efc_is_ncu_currency(p_currency) THEN
345: l_return := hr_currency_pkg.efc_convert_number_amount
346: (p_currency
347: ,p_value);
348: ELSE

Line 345: l_return := hr_currency_pkg.efc_convert_number_amount

341: IF p_value IS NULL THEN
342: l_return := NULL;
343: ELSE
344: IF hr_currency_pkg.efc_is_ncu_currency(p_currency) THEN
345: l_return := hr_currency_pkg.efc_convert_number_amount
346: (p_currency
347: ,p_value);
348: ELSE
349: -- return value unchanged.

Line 1235: AND hr_currency_pkg.efc_is_ncu_currency(p_currency))) THEN

1231: -- be counted.
1232: IF ((nvl(p_old_value,hr_api.g_varchar2) <>
1233: nvl(p_new_value,hr_api.g_varchar2)) OR
1234: (p_old_value = '0' AND p_new_value = '0'
1235: AND hr_currency_pkg.efc_is_ncu_currency(p_currency))) THEN
1236: -- Value has changed - check if we need to add/update a row
1237: IF ((p_currency = p_last_curr) OR (p_last_curr IS NULL)) THEN
1238: -- Increment count and return
1239: p_count := p_count + 1;