APPS.HR_GENERAL dependencies on HR_GENERAL

Line 1: package body HR_GENERAL as

1: package body HR_GENERAL as
2: /* $Header: hrgenral.pkb 120.3.12010000.2 2008/10/07 08:21:44 nerao ship $ */
3: ------------------------------------------------------------------------------
4: /*
5: +==============================================================================+

Line 242: := substrb(hr_general.decode_lookup ('NAME_TRANSLATIONS','PAY VALUE')

238: -- ever be longer than 30 chars but the "meaning" column of the lookups table
239: -- is length 80, so the following substrb is included as a fail-safe.
240: --
241: c_pay_value constant varchar2(80)
242: := substrb(hr_general.decode_lookup ('NAME_TRANSLATIONS','PAY VALUE')
243: ,1,80);
244: c_money_unit constant varchar2(255)
245: := hr_general.decode_lookup ('UNITS','M');
246: g_dummy number (1); -- dummy variable for select statements

Line 245: := hr_general.decode_lookup ('UNITS','M');

241: c_pay_value constant varchar2(80)
242: := substrb(hr_general.decode_lookup ('NAME_TRANSLATIONS','PAY VALUE')
243: ,1,80);
244: c_money_unit constant varchar2(255)
245: := hr_general.decode_lookup ('UNITS','M');
246: g_dummy number (1); -- dummy variable for select statements
247: g_calling_context varchar2(30); -- global variable used by get_calling_context
248: -- and set_calling_context
249: -- ---------------------------------------------------------------------------

Line 664: hr_utility.set_location ('HR_GENERAL.LOCATION_VALID',1);

660: v_location_valid boolean;
661: --
662: begin
663: --
664: hr_utility.set_location ('HR_GENERAL.LOCATION_VALID',1);
665: --
666: open csr_location;
667: fetch csr_location into g_dummy;
668: v_location_valid := csr_location%found;

Line 748: hr_utility.set_location ('hr_general.default_currency_code',1);

744: --
745: v_default_currency varchar2(255) := null;
746: --
747: begin
748: hr_utility.set_location ('hr_general.default_currency_code',1);
749: --
750: -- Find the user-specified default currency
751: --
752: open csr_legislation;

Line 1207: l_effective_date := hr_general.effective_date;

1203: --
1204: BEGIN
1205:
1206: IF p_effective_date is null THEN
1207: l_effective_date := hr_general.effective_date;
1208: ELSE
1209: l_effective_date := p_effective_date;
1210: END IF;
1211: --

Line 1249: l_effective_date := hr_general.effective_date;

1245: nvl(phn.date_to,c_effective_date);
1246:
1247:
1248: begin
1249: l_effective_date := hr_general.effective_date;
1250: open csr_phones1(l_effective_date);
1251: fetch csr_phones1 into l_per_phones_phone;
1252: close csr_phones1;
1253: return l_per_phones_phone;

Line 1533: -- hr_general.set_calling_context(p_calling_context => 'FORMS');

1529: commit ;
1530: end if;
1531:
1532: -- Bug no 581122 - Part of fix
1533: -- hr_general.set_calling_context(p_calling_context => 'FORMS');
1534:
1535: end init_forms;
1536: --------------------------------------------------------------------------------
1537: --

Line 1542: l_proc varchar2(72) := 'hr_general.chk_geocodes_installed';

1538: function chk_geocodes_installed
1539: return varchar2
1540: is
1541: --
1542: l_proc varchar2(72) := 'hr_general.chk_geocodes_installed';
1543: --
1544: l_exists varchar2(1);
1545: --
1546: -- Declare cursor.

Line 1588: l_proc varchar2(72) := 'hr_general.chk_maintain_tax_records';

1584: function chk_maintain_tax_records
1585: return varchar2
1586: is
1587: --
1588: l_proc varchar2(72) := 'hr_general.chk_maintain_tax_records';
1589: --
1590: l_dtw4_profile_option_value VARCHAR2(3);
1591: begin
1592: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1601: (hr_general.chk_geocodes_installed ='Y' and

1597: l_dtw4_profile_option_value);
1598: --
1599: IF hr_utility.chk_product_install(p_product =>'Oracle Payroll',
1600: p_legislation => 'US') OR
1601: (hr_general.chk_geocodes_installed ='Y' and
1602: NVL(l_dtw4_profile_option_value,'Y') = 'Y' ) THEN
1603: return 'Y';
1604: else
1605: return 'N';

Line 1975: and effective_end_date = hr_general.end_of_time;

1971: cursor csr_position is
1972: select position_definition_id
1973: from hr_all_positions_f
1974: where position_id = p_position_id
1975: and effective_end_date = hr_general.end_of_time;
1976: --
1977: v_position_definition_id number(20) := null;
1978: --
1979: begin

Line 2177: end HR_GENERAL;

2173: end if;
2174:
2175: end get_xbg_profile;
2176: --------------------------------------------------------------
2177: end HR_GENERAL;