1 PACKAGE CN_Payrun_PVT AUTHID CURRENT_USER as
2 -- $Header: cnvpruns.pls 120.3 2005/09/29 19:04:27 rnagired ship $
3
4 TYPE Payrun_rec_type IS RECORD
5 ( payrun_id cn_payruns.payrun_id%TYPE,
6 name cn_payruns.name%TYPE,
7 pay_date cn_payruns.pay_date%TYPE,
8 accounting_period_id cn_payruns.accounting_period_id%TYPE,
9 batch_id cn_payruns.batch_id%TYPE,
10 status cn_payruns.status%TYPE,
11 pay_period_id cn_payruns.pay_period_id%TYPE,
12 pay_period_start_date cn_period_statuses.start_date%TYPE,
13 pay_period_end_date cn_period_statuses.end_date%TYPE,
14 incentive_type_code cn_posting_details.incentive_type_code%TYPE,
15 pay_group_id cn_payruns.pay_group_id%TYPE,
16 --R12
17 org_id cn_payruns.org_id%TYPE,
18 object_version_number cn_payruns.object_version_number%TYPE
19 );
20 --============================================================================
21 -- Start of comments
22 -- API name : Create_Payrun
23 -- Type : Private.
24 -- Pre-reqs : None.
25 -- Usage : Used to create a new payrun
26 --
27 -- Desc : This procedure will validate the input for a payrun
28 -- and create one if all validations are passed.
29 --
30 -- Parameters :
31 -- IN : p_api_version IN NUMBER Required
32 -- p_init_msg_list IN VARCHAR2 Optional
33 -- Default = FND_API.G_FALSE
34 -- p_commit IN VARCHAR2 Optional
35 -- Default = FND_API.G_FALSE
36 -- p_validation_level IN NUMBER Optional
37 -- Default = FND_API.G_VALID_LEVEL_FULL
38 -- OUT : x_return_status OUT VARCHAR2(1)
39 -- x_msg_count OUT NUMBER
40 -- x_msg_data OUT VARCHAR2(2000)
41 -- IN : p_payrun_rec IN Required
42 -- Default = G_MISS_PAYRUNS_REC
43 -- OUT : x_loading_status OUT VARCHAR2(50)
44 -- Detailed error code returned from procedure.
45 --
46 -- OUT : x_status OUT VARCHAR2(50)
47 -- Return Sql Statement Status ( VALID/INVALID)
48 --
49 -- Version : Current version 1.0
50 -- Initial version 1.0
51 --
52 -- Notes : Note text
53 --
54 -- End of comments
55 --============================================================================
56
57 PROCEDURE Create_Payrun
58 ( p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := cn_api.g_false,
60 p_commit IN VARCHAR2 := cn_api.g_false,
61 p_validation_level IN NUMBER := cn_api.g_valid_level_full,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_Payrun_rec IN OUT NOCOPY Payrun_rec_type,
66 x_loading_status OUT NOCOPY VARCHAR2,
67 x_status OUT NOCOPY VARCHAR2
68 );
69 --============================================================================
70 --Start of comments
71 -- API name : Update_Payrun
72 -- Type : Public.
73 -- Usage : Used to refresh/freeze/unfreeze a payrun
74 -- Desc : Procedure to update a payrun
75 -- Parameters :
76 -- IN : p_api_version IN NUMBER Require
77 -- p_init_msg_list IN VARCHAR2 Optional
78 -- p_commit IN VARCHAR2 Optional
79 -- p_validation_level IN NUMBER Optional
80 -- OUT : x_return_status OUT VARCHAR2
81 -- x_msg_count OUT NUMBER
82 -- x_msg_data OUT VARCHAR2
83 -- IN : p_payrun_id IN cn_payruns.payrun_id%TYPE
84 -- p_action IN VARCHAR2
85 -- OUT : x_status OUT VARCHAR2
86 -- : x_loading_status OUT VARCHAR2
87 -- End of comments
88 --============================================================================
89
90 PROCEDURE Update_Payrun
91 ( p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2,
93 p_commit IN VARCHAR2,
94 p_validation_level IN NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_payrun_id IN cn_payruns.payrun_id%TYPE,
99 p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
100 p_action IN VARCHAR2,
101 x_status OUT NOCOPY VARCHAR2,
102 x_loading_status OUT NOCOPY VARCHAR2
103 );
104 --============================================================================
105 -- Start of Comments
106 --
107 -- API name : Delete_Payrun
108 -- Type : Private
109 -- Pre-reqs : None.
110 -- Usage : Delete
111 -- Desc : Procedure to Delete Payrun
112 -- Parameters :
113 -- IN : p_api_version IN NUMBER Require
114 -- p_init_msg_list IN VARCHAR2 Optional
115 -- Default = FND_API.G_FALSE
116 -- p_commit IN VARCHAR2 Optional
117 -- Default = FND_API.G_FALSE
118 -- p_validation_level IN NUMBER Optional
119 -- Default = FND_API.G_VALID_LEVEL_FULL
120 -- OUT : x_return_status OUT VARCHAR2(1)
121 -- x_msg_count OUT NUMBER
122 -- x_msg_data OUT VARCHAR2(2000)
123 -- IN : x_Payrun_rec IN Payrun_rec_type
124 --
125 -- OUT : x_loading_status OUT
126 -- Detailed Error Message
127 -- Version : Current version 1.0
128 -- Initial version 1.0
129 --
130 -- End of comments
131 --============================================================================
132 PROCEDURE Delete_Payrun
133 (
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := cn_api.g_false,
136 p_commit IN VARCHAR2 := cn_api.g_false,
137 p_validation_level IN NUMBER := cn_api.g_valid_level_full,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_payrun_id IN cn_payruns.payrun_id%TYPE,
142 p_validation_only IN VARCHAR2,
143 x_status OUT NOCOPY VARCHAR2,
144 x_loading_status OUT NOCOPY VARCHAR2
145 ) ;
146
147 --============================================================================
148 -- Start of Comments
149 --
150 -- API name : Pay_Payrun
151 -- Type : Public.
152 -- Pre-reqs : None.
153 -- Usage : To Pay a payrun
154 -- Desc : Procedure to Pay Payrun
155 -- Parameters :
156 -- IN : p_api_version IN NUMBER Require
157 -- p_init_msg_list IN VARCHAR2 Optional
158 -- Default = FND_API.G_FALSE
159 -- p_commit IN VARCHAR2 Optional
160 -- Default = FND_API.G_FALSE
161 -- p_validation_level IN NUMBER Optional
162 -- Default = FND_API.G_VALID_LEVEL_FULL
163 -- OUT : x_return_status OUT VARCHAR2(1)
164 -- x_msg_count OUT NUMBER
165 -- x_msg_data OUT VARCHAR2(2000)
166 -- IN : p_Payrun_name IN cn_payruns.name%TYPE
167 --
168 -- OUT : x_loading_status OUT
169 -- Detailed Error Message
170 -- Version : Current version 1.0
171 -- Initial version 1.0
172 --
173 -- End of comments
174 --============================================================================
175 PROCEDURE Pay_Payrun
176 ( p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 := cn_api.g_false,
178 p_commit IN VARCHAR2 := cn_api.g_false,
179 p_validation_level IN NUMBER := cn_api.g_valid_level_full,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_payrun_id IN cn_payruns.payrun_id%TYPE,
184 p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
185 x_status OUT NOCOPY VARCHAR2,
186 x_loading_status OUT NOCOPY VARCHAR2
187 ) ;
188
189 --============================================================================
190 --Name : delete_payrun_conc
191 --Description : Procedure which will be used as the executable for the
192 -- : concurrent program. delete payrun
193 --============================================================================
194 PROCEDURE delete_payrun_conc
195 ( errbuf OUT NOCOPY VARCHAR2,
196 retcode OUT NOCOPY NUMBER ,
197 p_name cn_payruns.name%TYPE,
198 --R12
199 p_org_name hr_operating_units.name%TYPE );
200 --============================================================================
201 --Name : Build Bee API
202 --Description : Payroll Integration
203 -- : concurrent program. delete payrun
204 --============================================================================
205 PROCEDURE BUILD_BEE_API
206 (x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_payrun_id IN NUMBER,
210 p_loading_status IN VARCHAR2,
211 x_loading_status OUT NOCOPY VARCHAR2);
212 --============================================================================
213 --Name : Populate CCIDS
214 --Description : Procedure to Populate CCIDs
215 --============================================================================
216 FUNCTION populate_ccids
217 (
218 p_payrun_id IN cn_payruns.payrun_id%TYPE,
219 p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
220 --p_start_date IN DATE,
221 --p_end_date IN DATE,
222 -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
223 p_pmt_tran_id IN cn_payment_transactions.payment_transaction_id%TYPE DEFAULT NULL,
224 p_loading_status OUT NOCOPY VARCHAR2,
225 x_loading_status OUT NOCOPY VARCHAR2
226 ) RETURN VARCHAR2;
227 END CN_Payrun_PVT ;