APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_JP_EMPDET_ARCHIVE_PKG

Line 1: package body per_jp_empdet_archive_pkg as

1: package body per_jp_empdet_archive_pkg as
2: /* $Header: pejpearc.pkb 120.34 2011/06/23 04:00:31 keyazawa noship $ */
3: --
4: c_package constant varchar2(30) := 'per_jp_empdet_archive_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;

Line 4: c_package constant varchar2(30) := 'per_jp_empdet_archive_pkg.';

1: package body per_jp_empdet_archive_pkg as
2: /* $Header: pejpearc.pkb 120.34 2011/06/23 04:00:31 keyazawa noship $ */
3: --
4: c_package constant varchar2(30) := 'per_jp_empdet_archive_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: g_range_person varchar2(80);
8: g_ext_proc_name varchar2(150);

Line 160: per_jp_empdet_archive_pkg.g_detail_debug := p_yn;

156: begin
157: --
158: if p_yn is not null then
159: --
160: per_jp_empdet_archive_pkg.g_detail_debug := p_yn;
161: --
162: else
163: --
164: open csr_hidden_debug;

Line 170: per_jp_empdet_archive_pkg.g_detail_debug := l_hidden_debug;

166: close csr_hidden_debug;
167: --
168: if l_hidden_debug = 'Y' then
169: --
170: per_jp_empdet_archive_pkg.g_detail_debug := l_hidden_debug;
171: --
172: end if;
173: --
174: end if;

Line 201: l_detail_debug varchar2(1) := per_jp_empdet_archive_pkg.g_detail_debug;

197: is
198: --
199: l_proc varchar2(80) := c_package||'init_pact';
200: --
201: l_detail_debug varchar2(1) := per_jp_empdet_archive_pkg.g_detail_debug;
202: --
203: cursor csr_action
204: is
205: select /*+ ORDERED */

Line 406: l_detail_debug varchar2(1) := per_jp_empdet_archive_pkg.g_detail_debug;

402: is
403: --
404: l_proc varchar2(80) := c_package||'range_code';
405: --
406: l_detail_debug varchar2(1) := per_jp_empdet_archive_pkg.g_detail_debug;
407: --
408: begin
409: --
410: if g_debug then

Line 1567: and decode(ppa.action_type,'R','TRM',nvl(per_jp_empdet_archive_pkg.get_fuzzy_proc_type(paa.assignment_action_id),'X')) = 'TRM'

1563: and ppa.payroll_action_id = paa.payroll_action_id
1564: and ppa.effective_date <= l_effective_date_proc
1565: and ppa.action_type in ('R','Q')
1566: and nvl(ppa.element_set_id,-1) in (c_trm_ele_set_id,-1)
1567: and decode(ppa.action_type,'R','TRM',nvl(per_jp_empdet_archive_pkg.get_fuzzy_proc_type(paa.assignment_action_id),'X')) = 'TRM'
1568: and not exists(
1569: select /*+ ORDERED */
1570: null
1571: from pay_action_interlocks pai_v,

Line 2548: end per_jp_empdet_archive_pkg;

2544: -- end if;
2545: ----
2546: --end deinitialize_code;
2547: --
2548: end per_jp_empdet_archive_pkg;