APPS.HR_EFC_INFO dependencies on HR_EFC_INFO

Line 1: PACKAGE BODY hr_efc_info AS

1: PACKAGE BODY hr_efc_info AS
2: /* $Header: hrefcinf.pkb 120.0 2005/05/31 00:01:00 appldev noship $ */
3: --
4: -- Local Variables
5: --

Line 27: g_package varchar2(30) := 'hr_efc_info.';

23: g_recal_step_30 CONSTANT NUMBER := 2;
24: g_recal_step_40 CONSTANT NUMBER := 1;
25: g_recal_step_50 CONSTANT NUMBER := 1;
26: --
27: g_package varchar2(30) := 'hr_efc_info.';
28: g_name VARCHAR2(30);
29: g_bg NUMBER;
30: g_last_currency_code varchar2(15) := null;
31: g_return_currency_code varchar2(15) := null;

Line 213: (hr_efc_info.get_bg_currency(p_bg)

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
217: (p_currency

Line 244: (hr_efc_info.get_bg_currency(p_bg)

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
248: (p_currency

Line 266: RETURN hr_efc_info.get_bg_currency(p_bg);

262: --
263: BEGIN
264: --
265: IF (p_currency IS NULL) THEN
266: RETURN hr_efc_info.get_bg_currency(p_bg);
267: ELSE
268: RETURN p_currency;
269: END IF;
270: END check_abs_currency;

Line 281: RETURN hr_efc_info.get_bg_currency(p_bg);

277: --
278: BEGIN
279: --
280: IF (p_currency IS NULL) THEN
281: RETURN hr_efc_info.get_bg_currency(p_bg);
282: ELSE
283: RETURN p_currency;
284: END IF;
285: END check_aei_currency;

Line 305: IF hr_efc_info.validate_hr_summary

301: -- Return NULL
302: l_return := NULL;
303: ELSE
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)

Line 309: (hr_efc_info.get_bg_currency(p_bg)

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
313: l_return := p_value;

Line 327: RETURN hr_efc_info.get_bg_currency(p_bg);

323: -- ----------------------------------------------------------------------------
324: FUNCTION check_num_currency(p_bg IN NUMBER) RETURN varchar2 IS
325: --
326: BEGIN
327: RETURN hr_efc_info.get_bg_currency(p_bg);
328: END check_num_currency;
329: --
330: -- ----------------------------------------------------------------------------
331: -- |--------------------------< convert_ppy_value >---------------------------|

Line 539: p_get_chunk := hr_efc_info.get_chunk;

535: END IF;
536: CLOSE csr_fetch_details;
537: --
538: -- Get chunk size
539: p_get_chunk := hr_efc_info.get_chunk;
540: --
541: END get_action_details;
542: --
543: -- ----------------------------------------------------------------------------

Line 617: l_bg := hr_efc_info.get_bg;

613: WHERE pbg.business_group_id = p_bg;
614: --
615: BEGIN
616: --
617: l_bg := hr_efc_info.get_bg;
618: open csr_bg_name(l_bg);
619: fetch csr_bg_name into l_bg_name;
620: close csr_bg_name;
621: --

Line 1493: l_chunk := hr_efc_info.get_chunk;

1489: END IF;
1490: CLOSE csr_get_action;
1491: --
1492: -- Get chunk size, so we process in chunks
1493: l_chunk := hr_efc_info.get_chunk;
1494: l_del_tab_sql := replace(l_del_tab_sql,'',l_chunk);
1495: --
1496: -- For each _efc table, delete the appropriate rows
1497: FOR c1 IN csr_get_efc_tables LOOP

Line 1665: END hr_efc_info;

1661: --
1662: END process_cross_bg_data;
1663: --
1664: --
1665: END hr_efc_info;