1 package pay_ca_eoy_rl1_archive as
2 /* $Header: pycarlar.pkh 120.0.12000000.1 2007/01/17 17:24:27 appldev noship $ */
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 14-JAN-2000 mmukherj 110.0 Created.
30 10-NOV-2001 vpandya 115.1 Added set veify off at top as per
31 GSCC
32 12-NOV-2001 vpandya 115.2 Added dbdrv line at top
33 27-DEC-2001 vpandya 115.4 Added check_file in dbdrv
34 02-DEC-2002 vpandya 115.5 Added nocopy with out parameter
35 as per GSCC.
36 */
37 --
38 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
39 INDEX BY BINARY_INTEGER;
40 TYPE number_data_type_table IS TABLE OF NUMBER
41 INDEX BY BINARY_INTEGER;
42 g_min_chunk number:= -1;
43 g_archive_flag varchar2(1) := 'N';
44 g_rl1_last_slip_number number := 0;
45
46 procedure eoy_range_cursor(pactid in number,
47 sqlstr out nocopy varchar2);
48
49 procedure eoy_action_creation(pactid in number,
50 stperson in number,
51 endperson in number,
52 chunk in number);
53 procedure eoy_archive_data(p_assactid in number, p_effective_date in date);
54 procedure eoy_archinit(p_payroll_action_id in number);
55 --
56 end pay_ca_eoy_rl1_archive;