1 PACKAGE pay_cn_payslip_archive AUTHID CURRENT_USER AS
2 /* $Header: pycnparc.pkh 120.1.12020000.1 2012/06/28 17:25:33 appldev ship $ */
3
4 -------------------------------------------------------------------------
5 -- These are PUBLIC procedures that are required by the Archive process.
6 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
7 -- the archive process knows what code to execute for each step of
8 -- the archive.
9 --------------------------------------------------------------------------
10
11 --------------------------------------------------------------------------
12 -- --
13 -- Name : RANGE_CODE --
14 -- Type : PROCEDURE --
15 -- Access : Public --
16 -- Description : This procedure returns a sql string to select a --
17 -- range of assignments eligible for archival. --
18 -- --
19 -- Parameters : --
20 -- IN : p_payroll_action_id NUMBER --
21 -- OUT : p_sql VARCHAR2 --
22 -- --
23 --------------------------------------------------------------------------
24 --
25
26 PROCEDURE range_code
27 (
28 p_payroll_action_id IN NUMBER
29 ,p_sql OUT NOCOPY VARCHAR2
30 );
31 --
32
33 --------------------------------------------------------------------------
34 -- --
35 -- Name : INITIALIZATION_CODE --
36 -- Type : PROCEDURE --
37 -- Access : Public --
38 -- Description : This procedure is used to set global contexts --
39 -- Here It is used to archive the data at payroll --
40 -- action level. --
41 -- --
42 -- Parameters : --
43 -- IN : p_payroll_action_id NUMBER --
44 -- OUT : N/A --
45 --------------------------------------------------------------------------
46 --
47 PROCEDURE initialization_code
48 (
49 p_payroll_action_id IN NUMBER
50 );
51 --
52
53 --------------------------------------------------------------------------
54 -- --
55 -- Name : ASSIGNMENT_ACTION_CODE --
56 -- Type : PROCEDURE --
57 -- Access : Public --
58 -- Description : This procedure further restricts the assignment_id's--
59 -- returned by range_code --
60 -- --
61 -- Parameters : --
62 -- IN : p_payroll_action_id NUMBER --
63 -- p_start_person NUMBER --
64 -- p_end_person NUMBER --
65 -- p_chunk NUMBER --
66 -- OUT : N/A --
67 --------------------------------------------------------------------------
68 --
69
70 PROCEDURE assignment_action_code
71 (
72 p_payroll_action_id IN NUMBER
73 ,p_start_person IN NUMBER
74 ,p_end_person IN NUMBER
75 ,p_chunk IN NUMBER
76 );
77 --
78
79 --------------------------------------------------------------------------
80 -- --
81 -- Name : ARCHIVE_CODE --
82 -- Type : PROCEDURE --
83 -- Access : Public --
84 -- Description : This procedure is actually used to archive data . It--
85 -- internally calls private procedures to archive --
86 -- balances,employee details, employer details, --
87 -- elements,absences and accruals etc. --
88 -- --
89 -- Parameters : --
90 -- IN : p_assignment_action_id NUMBER --
91 -- p_effective_date DATE --
92 -- OUT : N/A --
93 --------------------------------------------------------------------------
94 --
95
96 PROCEDURE archive_code
97 (
98 p_assignment_action_id IN NUMBER
99 ,p_effective_date IN DATE
100 );
101 --
102 --------------------------------------------------------------------------
103 -- --
104 -- Name : GET_PARAMETER --
105 -- Type : FUNCTION --
106 -- Access : Public --
107 -- Description : This function returns payroll id of corresponding --
108 -- payroll action id. --
109 -- Parameters : --
110 -- IN : p_name VARCHAR2 --
111 -- p_leg_parameters VARCHAR2 --
112 -- Returns: VARCHAR2 --
113 --------------------------------------------------------------------------
114 --
115
116 FUNCTION get_parameter
117 (
118 p_name IN VARCHAR2,
119 p_leg_parameters IN VARCHAR2
120 ) RETURN VARCHAR2;
121
122
123 END pay_cn_payslip_archive;