1 PACKAGE pay_ca_eoy_rl1_amend_arch AS
2 /* $Header: pycarl1ca.pkh 120.0.12000000.1 2007/01/17 17:19:39 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_ca_eoy_rl1_amend_arch
21
22 Description : This procedure is used by Provincial YE Amendment Pre-Process
23 to archive data for RL1 Amendment Paper Report.
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 21-OCT-2003 SSouresr 115.0 Created.
30 */
31
32
33 PROCEDURE get_payroll_action_info(p_payroll_action_id in number
34 ,p_end_date out nocopy date
35 ,p_start_date out nocopy date
36 ,p_business_group_id out nocopy number
37 ,p_pre_org_id out nocopy number
38 ,p_person_id out nocopy number
39 ,p_asg_set out nocopy number
40 ,p_year out nocopy varchar2
41 );
42
43
44 PROCEDURE eoy_range_cursor(p_payroll_action_id in number
45 ,p_sqlstr out nocopy varchar2);
46
47 PROCEDURE eoy_action_creation(p_payroll_action_id in number
48 ,p_start_person_id in number
49 ,p_end_person_id in number
50 ,p_chunk in number);
51
52
53 FUNCTION get_parameter(name in varchar2,
54 parameter_list varchar2) return varchar2;
55
56 g_min_chunk number:= -1;
57 g_archive_flag varchar2(1) := 'N';
58 g_bal_act_id number:= -1;
59
60 END pay_ca_eoy_rl1_amend_arch;