1 package pay_ca_payroll_arch as
2 /* $Header: pycapyar.pkh 120.0.12010000.1 2008/07/27 22:15:25 appldev ship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, in *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 16-AUG-2001 vpandya 115.0 Created.
30 22-Jan-2002 vpandya 115.1 Added dbdrv to meet new standard.
31 23-Jan-2002 vpandya 115.2 Replace variable p_assactid with
32 p_xfr_action_id in archive_data
33 12-Jun-2002 vpandya 115.3 Added PL/SQL table, to populate
34 Tax data and one variable
35 gv_jurisdiction_cd.
36 17-Jun-2002 vpandya 115.4 Added jurisdiction_cd column in
37 def_bal PL/SQL table.
38 18-Feb-2003 vpandya 115.5 Added nocopy for gscc.
39 10-Mar-2003 vpandya 115.6 Added variables
40 gn_gross_earn_def_bal_id and
41 gn_payments_def_bal_id.
42 02-Aug-2004 ssattini 115.7 3498653 Added run_def_bal_id column in
43 def_bal PL/SQL table.
44 */
45 --
46
47 PROCEDURE py_range_cursor( p_payroll_action_id in number
48 ,p_sqlstr out nocopy varchar2);
49
50 PROCEDURE py_action_creation( p_payroll_action_id in number
51 ,p_start_assignment_id in number
52 ,p_end_assignment_id in number
53 ,p_chunk in number);
54
55 PROCEDURE py_archive_data(p_xfr_action_id in number,
56 p_effective_date in date);
57
58
59 PROCEDURE py_archinit(p_payroll_action_id in number);
60
61 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
62 INDEX BY BINARY_INTEGER;
63 TYPE number12_2_data_type_table IS TABLE OF NUMBER(15,2)
64 INDEX BY BINARY_INTEGER;
65
66 TYPE def_bal IS RECORD ( bal_name varchar2(240),
67 disp_sequence number(10),
68 bal_type_id number(10),
69 pymt_def_bal_id number(10),
70 gre_ytd_def_bal_id number(10),
71 tg_ytd_def_bal_id number(10),
72 run_def_bal_id number(10),
73 jurisdiction_cd varchar2(30));
74
75 TYPE def_bal_tbl IS TABLE OF def_bal INDEX BY BINARY_INTEGER;
76
77 TYPE tax_name IS RECORD ( language varchar2(30),
78 lookup_code varchar2(30),
79 meaning varchar2(80));
80
81 TYPE tax_tbl IS TABLE OF tax_name INDEX BY BINARY_INTEGER;
82
83 g_min_chunk number:= -1;
84 g_archive_flag varchar2(1) := 'N';
85 g_bal_act_id number:= -1;
86
87 gn_gross_earn_def_bal_id number := 0;
88 gn_payments_def_bal_id number := 0;
89
90 gv_jurisdiction_cd varchar2(30) := NULL;
91
92 end pay_ca_payroll_arch;