1 package pay_ca_eoy_rl1_archive AUTHID CURRENT_USER as
2 /* $Header: pycarlar.pkh 120.1.12020000.2 2012/11/21 11:21:58 sbachu 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 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 10-Apr-2009 sapalani 115.6 6768167 Added function gen_rl1_pdf_seq.
37 20-Nov-2012 sbachu 115.7 13564765 Slip number changes for extra slip
38 for the same employee.
39 */
40 --
41 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
42 INDEX BY BINARY_INTEGER;
43 TYPE number_data_type_table IS TABLE OF NUMBER
44 INDEX BY BINARY_INTEGER;
45 g_min_chunk number:= -1;
46 g_archive_flag varchar2(1) := 'N';
47 g_rl1_last_slip_number number := 0;
48
49 procedure eoy_range_cursor(pactid in number,
50 sqlstr out nocopy varchar2);
51
52 procedure eoy_action_creation(pactid in number,
53 stperson in number,
54 endperson in number,
55 chunk in number);
56 procedure eoy_archive_data(p_assactid in number, p_effective_date in date);
57 procedure eoy_archinit(p_payroll_action_id in number);
58 FUNCTION gen_rl1_pdf_seq(p_aaid in number,
59 p_reporting_year in varchar2,
60 p_jurisdiction in varchar2,
61 called_from in varchar2)
62 return varchar2;
63 /*Bug 13564765 */
64 FUNCTION gen_rl1_slip_no(p_payroll_action_id number)
65 return varchar2;
66 --
67 end pay_ca_eoy_rl1_archive;