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.17 2011/10/14 15:43:55 sgotlasw ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5: --

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

152: hr_utility.trace('reached range_cursor');
153:
154:
155: select ppa.legislative_parameters,
156: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
157: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
158: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
159: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
160: ppa.start_date,

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

153:
154:
155: select ppa.legislative_parameters,
156: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
157: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
158: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
159: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
160: ppa.start_date,
161: ppa.effective_date,

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

154:
155: select ppa.legislative_parameters,
156: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
157: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
158: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
159: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
160: ppa.start_date,
161: ppa.effective_date,
162: ppa.business_group_id

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

155: select ppa.legislative_parameters,
156: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
157: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
158: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
159: pay_paygtn_pkg.get_parameter('PPA_FINDER',ppa.legislative_parameters),
160: ppa.start_date,
161: ppa.effective_date,
162: ppa.business_group_id
163: into leg_param,

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

234: select ppa.legislative_parameters,
235: ppa.business_group_id,
236: ppa.start_date,
237: ppa.effective_date,
238: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
239: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
240: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
241: from pay_payroll_actions ppa
242: where ppa.payroll_action_id = pactid;

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

235: ppa.business_group_id,
236: ppa.start_date,
237: ppa.effective_date,
238: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
239: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
240: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
241: from pay_payroll_actions ppa
242: where ppa.payroll_action_id = pactid;
243:

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

236: ppa.start_date,
237: ppa.effective_date,
238: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
239: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
240: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
241: from pay_payroll_actions ppa
242: where ppa.payroll_action_id = pactid;
243:
244: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the

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

440: select ppa.legislative_parameters,
441: ppa.business_group_id,
442: ppa.start_date,
443: ppa.effective_date,
444: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
445: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
446: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
447: from pay_payroll_actions ppa
448: where ppa.payroll_action_id = pactid;

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

441: ppa.business_group_id,
442: ppa.start_date,
443: ppa.effective_date,
444: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
445: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
446: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
447: from pay_payroll_actions ppa
448: where ppa.payroll_action_id = pactid;
449:

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

442: ppa.start_date,
443: ppa.effective_date,
444: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
445: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
446: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
447: from pay_payroll_actions ppa
448: where ppa.payroll_action_id = pactid;
449:
450: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the

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

747: from pay_payroll_actions ppa
748: where ppa.payroll_action_id = p_payroll_action_id;
749:
750: g_payroll_action_id := p_payroll_action_id;
751: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
752: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);

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

748: where ppa.payroll_action_id = p_payroll_action_id;
749:
750: g_payroll_action_id := p_payroll_action_id;
751: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
752: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);

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

749:
750: g_payroll_action_id := p_payroll_action_id;
751: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
752: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);

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

750: g_payroll_action_id := p_payroll_action_id;
751: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
752: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
758: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);

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

751: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
752: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
758: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
759: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');

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

752: p_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
758: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
759: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
760:

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

753: p_gre_id := pay_paygtn_pkg.get_parameter('TRANSFER_GRE',l_param);
754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
758: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
759: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
760:
761: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);

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

754: p_sort1 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT1',l_param);
755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
758: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
759: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
760:
761: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);
762: p_ded_bal_status1 := pay_us_payroll_utils.check_balance_status(p_start_date

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

755: p_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
756: p_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
757: p_ppa_finder := pay_paygtn_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
758: p_template_code := pay_paygtn_pkg.get_parameter('TRANSFER_TEMPLATE',l_param);
759: p_asg_flag := nvl(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
760:
761: hr_utility.trace('p_asg_flag in archive_init='||p_asg_flag);
762: p_ded_bal_status1 := pay_us_payroll_utils.check_balance_status(p_start_date
763: ,p_business_group_id

Line 1159: g_proc_name := 'PAY_PAYGTN_PKG.';

1155: end ARCHIVE_DEINIT;
1156:
1157: BEGIN
1158: -- hr_utility.trace_on(NULL,'trc_pypaygtn');
1159: g_proc_name := 'PAY_PAYGTN_PKG.';
1160:
1161: END PAY_PAYGTN_PKG;

Line 1161: END PAY_PAYGTN_PKG;

1157: BEGIN
1158: -- hr_utility.trace_on(NULL,'trc_pypaygtn');
1159: g_proc_name := 'PAY_PAYGTN_PKG.';
1160:
1161: END PAY_PAYGTN_PKG;