DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_AU_PAYSLIP_ARCHIVE

Line 1: package body pay_au_payslip_archive as

1: package body pay_au_payslip_archive as
2: /* $Header: pyauparc.pkb 120.11.12020000.4 2012/12/25 01:46:00 mingyhua ship $ */
3: /* +===================================================================+
4: Copyright (c) 2002 Oracle Corporation Australia Ltd
5: Melbourne, Australia

Line 93: g_package constant varchar2(60) := 'pay_au_payslip_archive.'; -- Global to store package name for tracing.

89: */
90:
91: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type; -- Global to store last archive payroll action id
92:
93: g_package constant varchar2(60) := 'pay_au_payslip_archive.'; -- Global to store package name for tracing.
94:
95: --------------------------------------------------------------------
96: --
97: -- This procedure returns a sql string to select a range

Line 1373: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);

1369: l_object_version_number_1 NUMBER ;
1370:
1371: BEGIN
1372: lv_procedure_name := '.archive_offset_payment_method';
1373: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1374: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1375: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1376: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1377:

Line 1449: hr_utility.set_location('Leaving pay_au_payslip_archive'|| lv_procedure_name,100);

1445: p_action_information30 => null
1446: );
1447: end loop;
1448: close c_net_pay;
1449: hr_utility.set_location('Leaving pay_au_payslip_archive'|| lv_procedure_name,100);
1450: END archive_offset_payment_method;
1451: --
1452: --------------------------------------------------------------------------------------
1453: --

Line 2038: end pay_au_payslip_archive;

2034: hr_utility.set_location('Error in '||l_procedure,999999);
2035: raise;
2036: end archive_code;
2037:
2038: end pay_au_payslip_archive;