PACKAGE: APPS.PAY_IE_P45_ARCHIVE

Source

1 PACKAGE pay_ie_p45_archive AS
2 /* $Header: pyiep45.pkh 120.2.12010000.1 2008/07/27 22:50:36 appldev ship $ */
3 /*
4 **
5 **  Copyright (C) 1999 Oracle Corporation
6 **  All Rights Reserved
7 **
8 **  IE P45 Archive Package body
9 **
10 **  Change List
11 **  ===========
12 **
13 **  Date        Author   Reference Description
14 **  -----------+--------+---------+-------------
15 **  05 APR 2002 abhaduri  N/A      Created
16 **  01 JUN 2002 viviswan           XML Report
17 **                                 procedure added
18 **  05 DEC 2002 viviswan           no copy changes
19 **  06 JUL 2005 sgajula   4468864  Added archive_deinit
20 **  14 FEB 2006 sgajula   5005788  Changed get_arc_bal_value for
21 **                                 Performance.
22 ------------------------------------------------
23 */
24 
25 PROCEDURE archinit (p_payroll_action_id IN NUMBER);
26 
27 PROCEDURE range_cursor (pactid IN NUMBER,
28                         sqlstr OUT nocopy VARCHAR2);
29 
30 PROCEDURE action_creation (pactid in number,
31                            stperson in number,
32                            endperson in number,
33                            chunk in number);
34 
35 PROCEDURE archive_code (p_assactid in number,
36                         p_effective_date in date);
37 
38 PROCEDURE archive_deinit (p_payroll_action_id IN NUMBER);
39 
40 FUNCTION get_lookup_meaning(
41                      p_lookup_type    in varchar2
42                     ,p_lookup_code    in varchar2 ) return varchar2;
43 
44 FUNCTION get_arc_bal_value(
45                      p_assignment_action_id  in number
46 		    ,p_payroll_action_id     in number     -- 5005788
47                     ,p_balance_name          in varchar2 ) return number;
48 
49 PROCEDURE generate_xml(
50            errbuf                   out nocopy varchar2
51           ,retcode                  out nocopy varchar2
52           ,p_p45_archive_process    in  number
53           ,p_assignment_id    in  number);
54 
55 
56 
57 END;