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.8.12010000.2 2008/08/06 06:49:01 ubhat ship $ */
3: /* +===================================================================+
4: Copyright (c) 2002 Oracle Corporation Australia Ltd
5: Melbourne, Australia

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

79: */
80:
81: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type; -- Global to store last archive payroll action id
82:
83: g_package constant varchar2(60) := 'pay_au_payslip_archive.'; -- Global to store package name for tracing.
84:
85: --------------------------------------------------------------------
86: --
87: -- This procedure returns a sql string to select a range

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

1204: l_object_version_number_1 NUMBER ;
1205:
1206: BEGIN
1207: lv_procedure_name := '.archive_offset_payment_method';
1208: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1209: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1210: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1211: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1212:

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

1280: p_action_information30 => null
1281: );
1282: end loop;
1283: close c_net_pay;
1284: hr_utility.set_location('Leaving pay_au_payslip_archive'|| lv_procedure_name,100);
1285: END archive_offset_payment_method;
1286: --
1287: --------------------------------------------------------------------------------------
1288: --

Line 1743: end pay_au_payslip_archive;

1739: when others then
1740: hr_utility.set_location('Error in '||l_procedure,999999);
1741: raise;
1742: end archive_code;
1743: end pay_au_payslip_archive;