1 package pay_ca_archive AUTHID CURRENT_USER as
2 /* $Header: pycaarch.pkh 120.0.12000000.1 2007/01/17 16:44:59 appldev noship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation US Ltd., *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation USA Ltd, *
19 * USA. *
20 * *
21 ******************************************************************
22
23 Change List
24 -----------
25 Date Name Vers Bug No Description
26 ----------- ---------- ----- ------- -----------------------------------
27 06-MAY-1999 pganguly 40.0 Created.
28 23-NOV-1999 jgoswami 110.1 Changed script to make it
29 adcheck driver complient
30 11-MAR-2002 pganguly 115.1 Added new procedure to create
31 /delete assignment sets for Mass
32 ROE.
33 31-DEC-2002 pganguly 115.2 Added nocopy for GSCC.
34 03-MAR-2003 pganguly 115.3 Added a record/table type variable
35 declaration for ROE Box 17C.
36 */
37 --
38 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
39 INDEX BY BINARY_INTEGER;
40
41 procedure range_cursor(pactid in number,
42 sqlstr out nocopy varchar2);
43 procedure archinit(p_payroll_action_id in number);
44
45 procedure action_creation(pactid in number,
46 stperson in number,
47 endperson in number,
48 chunk in number);
49
50 procedure archive_data(p_assactid in number,
51 p_effective_date in date);
52
53 procedure create_asg_set_records(p_assignment_set_name in varchar2,
54 p_assignment_id in number,
55 p_business_group_id in number);
56
57 procedure delete_asg_set_records(p_assignment_set_name in varchar2,
58 p_assignment_id in number,
59 p_business_group_id in number);
60
61 TYPE rec_box17c IS RECORD(code varchar2(1),
62 balance_name varchar2(80));
63
64 TYPE tab_box17c is table of rec_box17c
65 index by binary_integer;
66
67 box17c_bal_table tab_box17c;
68
69
70 end pay_ca_archive;