1 package pay_ca_payroll_arch AUTHID CURRENT_USER as
2 /* $Header: pycapyar.pkh 120.0.12020000.2 2012/07/04 21:54:18 amnaraya 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 20-Feb-2012 abellur 115.8 13029997 Added g_assignment_id, g_printed
45 to support/archive third party
46 XML checks.
47 */
48 --
49
50 PROCEDURE py_range_cursor( p_payroll_action_id in number
51 ,p_sqlstr out nocopy varchar2);
52
53 PROCEDURE py_action_creation( p_payroll_action_id in number
54 ,p_start_assignment_id in number
55 ,p_end_assignment_id in number
56 ,p_chunk in number);
57
58 PROCEDURE py_archive_data(p_xfr_action_id in number,
59 p_effective_date in date);
60
61
62 PROCEDURE py_archinit(p_payroll_action_id in number);
63
64 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
65 INDEX BY BINARY_INTEGER;
66 TYPE number12_2_data_type_table IS TABLE OF NUMBER(15,2)
67 INDEX BY BINARY_INTEGER;
68
69 TYPE def_bal IS RECORD ( bal_name varchar2(240),
70 disp_sequence number(10),
71 bal_type_id number(10),
72 pymt_def_bal_id number(10),
73 gre_ytd_def_bal_id number(10),
74 tg_ytd_def_bal_id number(10),
75 run_def_bal_id number(10),
76 jurisdiction_cd varchar2(30));
77
78 TYPE def_bal_tbl IS TABLE OF def_bal INDEX BY BINARY_INTEGER;
79
80 TYPE tax_name IS RECORD ( language varchar2(30),
81 lookup_code varchar2(30),
82 meaning varchar2(80));
83
84 TYPE tax_tbl IS TABLE OF tax_name INDEX BY BINARY_INTEGER;
85
86 g_min_chunk number:= -1;
87 g_archive_flag varchar2(1) := 'N';
88 g_bal_act_id number:= -1;
89
90 gn_gross_earn_def_bal_id number := 0;
91 gn_payments_def_bal_id number := 0;
92
93 gv_jurisdiction_cd varchar2(30) := NULL;
94
95 -- 13029997 introduced for 3rd party checks, changes start
96 g_assignment_id number :=0;
97 g_printed varchar2(500);
98 -- 3rd party checks changes end
99
100 end pay_ca_payroll_arch;