1 PACKAGE pay_nz_sscwt_rate_archive AS
2 /* $Header: paynzssc.pkh 120.0.12000000.1 2007/01/17 14:29:16 appldev noship $ */
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 --------------------------------------------------------------------------
36 -- --
37 -- Name : INITIALIZATION_CODE --
38 -- Type : PROCEDURE --
39 -- Access : Public --
40 -- Description : This procedure is used to set global contexts --
41 -- Here it fetches and stores defined balnce ids, --
42 -- element type ids and element input value ids. --
43 -- --
44 -- Parameters : --
45 -- IN : p_payroll_action_id NUMBER --
46 -- OUT : N/A --
47 --------------------------------------------------------------------------
48 --
49 PROCEDURE initialization_code
50 (
51 p_payroll_action_id IN NUMBER
52 );
53 --
54
55 --------------------------------------------------------------------------
56 -- --
57 -- Name : ASSIGNMENT_ACTION_CODE --
58 -- Type : PROCEDURE --
59 -- Access : Public --
60 -- Description : This procedure further restricts the assignment_id's--
61 -- returned by range_code --
62 -- --
63 -- Parameters : --
64 -- IN : p_payroll_action_id NUMBER --
65 -- p_start_person NUMBER --
66 -- p_end_person NUMBER --
67 -- p_chunk NUMBER --
68 -- OUT : N/A --
69 --------------------------------------------------------------------------
70 --
71
72 PROCEDURE assignment_action_code
73 (
74 p_payroll_action_id IN NUMBER
75 ,p_start_person IN NUMBER
76 ,p_end_person IN NUMBER
77 ,p_chunk IN NUMBER
78 );
79 --
80
81 --------------------------------------------------------------------------
82 -- --
83 -- Name : ARCHIVE_CODE --
84 -- Type : PROCEDURE --
85 -- Access : Public --
86 -- Description : This procedure is actually used to archive data . --
87 -- This procedure archives details of an employee's --
88 -- SSCWT Rates. It archives details of all employees --
89 -- selected by assignment_action_code --
90 -- --
91 -- Parameters : --
92 -- IN : p_assignment_action_id NUMBER --
93 -- p_effective_date DATE --
94 -- OUT : N/A --
95 --------------------------------------------------------------------------
96 --
97
98 PROCEDURE archive_code
99 (
100 p_assignment_action_id IN NUMBER
101 ,p_effective_date IN DATE
102 );
103 --
104
105
106 --------------------------------------------------------------------------
107 -- --
108 -- Name : DEINITIALIZE_CODE --
109 -- Type : PROCEDURE --
110 -- Access : Public --
111 -- Description : This procedure is used to submit request for --
112 -- SSCWT Report to run. --
113 -- --
114 -- Parameters : --
115 -- IN : p_payroll_action_id NUMBER --
116 -- OUT : N/A --
117 --------------------------------------------------------------------------
118 --
119 PROCEDURE deinitialize_code
120 (
121 p_payroll_action_id IN NUMBER
122 );
123 --
124
125
126 --------------------------------------------------------------------------
127 -- --
128 -- Name : PERIODS_IN_SPAN --
129 -- Type : FUNCTION --
130 -- Access : Public --
131 -- Description : Function returns the number of periods for which --
132 -- the payroll is run for a given assignment and given --
133 -- period. --
134 -- --
135 -- Parameters : --
136 -- IN : p_start_date DATE --
137 -- p_start_date DATE --
138 -- p_assignment_id per_assignments_f.assignment_id%TYPE --
139 -- --
140 -- OUT : N/A --
141 -- --
142 -- Change History : --
143 --------------------------------------------------------------------------
144 -- Rev# Date Userid Description --
145 --------------------------------------------------------------------------
146 -- 115.0 22-JAN-2004 sshankar Initial Version --
147 -- --
148 --------------------------------------------------------------------------
149 --
150 FUNCTION periods_in_span
151 ( p_start_date IN DATE
152 , p_end_date IN DATE
153 , p_assignment_id IN per_assignments_f.assignment_id%TYPE)
154 RETURN NUMBER;
155 --
156
157
158 END pay_nz_sscwt_rate_archive;