eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYGTN_PKG dependencies on PAY_PAYGTN_PKG

Line 1: PACKAGE BODY PAY_PAYGTN_PKG AS

1: PACKAGE BODY PAY_PAYGTN_PKG AS
2: /* $Header: pypaygtn.pkb 120.10.12010000.6 2008/08/12 08:52:04 kagangul ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5: --

Line 150: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

146: hr_utility.trace('reached range_cursor');
147:
148:
149: select ppa.legislative_parameters,
150: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
151: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
152: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
153: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
154: ppa.start_date,

Line 151: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

147:
148:
149: select ppa.legislative_parameters,
150: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
151: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
152: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
153: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
154: ppa.start_date,
155: ppa.effective_date,

Line 152: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),

148:
149: select ppa.legislative_parameters,
150: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
151: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
152: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
153: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
154: ppa.start_date,
155: ppa.effective_date,
156: ppa.business_group_id

Line 153: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),

149: select ppa.legislative_parameters,
150: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
151: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
152: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
153: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
154: ppa.start_date,
155: ppa.effective_date,
156: ppa.business_group_id
157: into leg_param,

Line 229: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

225: select ppa.legislative_parameters,
226: ppa.business_group_id,
227: ppa.start_date,
228: ppa.effective_date,
229: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
230: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
231: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
232: from pay_payroll_actions ppa
233: where ppa.payroll_action_id = pactid;

Line 230: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

226: ppa.business_group_id,
227: ppa.start_date,
228: ppa.effective_date,
229: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
230: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
231: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
232: from pay_payroll_actions ppa
233: where ppa.payroll_action_id = pactid;
234:

Line 231: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

227: ppa.start_date,
228: ppa.effective_date,
229: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
230: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
231: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
232: from pay_payroll_actions ppa
233: where ppa.payroll_action_id = pactid;
234:
235: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the

Line 435: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

431: select ppa.legislative_parameters,
432: ppa.business_group_id,
433: ppa.start_date,
434: ppa.effective_date,
435: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
436: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
437: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
438: from pay_payroll_actions ppa
439: where ppa.payroll_action_id = pactid;

Line 436: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

432: ppa.business_group_id,
433: ppa.start_date,
434: ppa.effective_date,
435: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
436: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
437: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
438: from pay_payroll_actions ppa
439: where ppa.payroll_action_id = pactid;
440:

Line 437: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

433: ppa.start_date,
434: ppa.effective_date,
435: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
436: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
437: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
438: from pay_payroll_actions ppa
439: where ppa.payroll_action_id = pactid;
440:
441: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the

Line 742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);

738: from pay_payroll_actions ppa
739: where ppa.payroll_action_id = p_payroll_action_id;
740:
741: g_payroll_action_id := p_payroll_action_id;
742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);

Line 743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);

739: where ppa.payroll_action_id = p_payroll_action_id;
740:
741: g_payroll_action_id := p_payroll_action_id;
742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);

Line 744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);

740:
741: g_payroll_action_id := p_payroll_action_id;
742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);

Line 745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);

741: g_payroll_action_id := p_payroll_action_id;
742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);

Line 746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);

742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');

Line 747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);

743: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
751:

Line 748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);

744: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
751:
752: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);

Line 749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);

745: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
751:
752: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);
753: p_ded_bal_status1 := pay_us_payroll_utils.check_balance_status(p_start_date

Line 750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');

746: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
747: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
748: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
749: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
750: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
751:
752: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);
753: p_ded_bal_status1 := pay_us_payroll_utils.check_balance_status(p_start_date
754: ,p_business_group_id

Line 1150: g_proc_name := 'PAY_PAYGTN_PKG.';

1146: end ARCHIVE_DEINIT;
1147:
1148: BEGIN
1149: -- hr_utility.trace_on(NULL,'trc_pypaygtn');
1150: g_proc_name := 'PAY_PAYGTN_PKG.';
1151:
1152: END PAY_PAYGTN_PKG;

Line 1152: END PAY_PAYGTN_PKG;

1148: BEGIN
1149: -- hr_utility.trace_on(NULL,'trc_pypaygtn');
1150: g_proc_name := 'PAY_PAYGTN_PKG.';
1151:
1152: END PAY_PAYGTN_PKG;