[Home] [Help]
PACKAGE: APPS.CN_PAY_ELEMENT_INPUTS_PVT
Source
1 PACKAGE CN_PAY_ELEMENT_INPUTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvqpis.pls 115.4 2002/02/05 00:27:12 pkm ship $ */
3
4 --
5 -- Record type for Pay Element Inputs
6 --
7 TYPE pay_element_input_rec_type IS RECORD
8 ( pay_element_name pay_element_types.element_name%TYPE
9 := CN_API.G_MISS_CHAR,
10 start_date pay_element_types.effective_start_date%TYPE,
11 end_date pay_element_types.effective_end_date%TYPE,
12 table_name cn_objects.name%TYPE
13 := CN_API.G_MISS_CHAR,
14 column_name cn_objects.name%TYPE
15 := CN_API.G_MISS_CHAR,
16 pay_input_name pay_input_values.name%TYPE
17 := CN_API.G_MISS_CHAR,
18 line_number pay_input_values.display_sequence%TYPE,
19 pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
20 quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
21 element_input_id cn_pay_element_inputs.element_input_id%TYPE,
22 element_type_id cn_pay_element_inputs.element_type_id%TYPE,
23 tab_object_id cn_objects.object_id%TYPE,
24 col_object_id cn_objects.object_id%TYPE,
25 ATTRIBUTE_CATEGORY cn_pay_element_inputs.attribute_category%TYPE
26 := CN_API.G_MISS_CHAR,
27 ATTRIBUTE1 cn_pay_element_inputs.attribute1%TYPE
28 := CN_API.G_MISS_CHAR,
29 ATTRIBUTE2 cn_pay_element_inputs.attribute2%TYPE
30 := CN_API.G_MISS_CHAR,
31 ATTRIBUTE3 cn_pay_element_inputs.attribute3%TYPE
32 := CN_API.G_MISS_CHAR,
33 ATTRIBUTE4 cn_pay_element_inputs.attribute4%TYPE
34 := CN_API.G_MISS_CHAR,
35 ATTRIBUTE5 cn_pay_element_inputs.attribute5%TYPE
36 := CN_API.G_MISS_CHAR,
37 ATTRIBUTE6 cn_pay_element_inputs.attribute6%TYPE
38 := CN_API.G_MISS_CHAR,
39 ATTRIBUTE7 cn_pay_element_inputs.attribute7%TYPE
40 := CN_API.G_MISS_CHAR,
41 ATTRIBUTE8 cn_pay_element_inputs.attribute8%TYPE
42 := CN_API.G_MISS_CHAR,
43 ATTRIBUTE9 cn_pay_element_inputs.attribute9%TYPE
44 := CN_API.G_MISS_CHAR,
45 ATTRIBUTE10 cn_pay_element_inputs.attribute10%TYPE
46 := CN_API.G_MISS_CHAR,
47 ATTRIBUTE11 cn_pay_element_inputs.attribute11%TYPE
48 := CN_API.G_MISS_CHAR,
49 ATTRIBUTE12 cn_pay_element_inputs.attribute12%TYPE
50 := CN_API.G_MISS_CHAR,
51 ATTRIBUTE13 cn_pay_element_inputs.attribute13%TYPE
52 := CN_API.G_MISS_CHAR,
53 ATTRIBUTE14 cn_pay_element_inputs.attribute14%TYPE
54 := CN_API.G_MISS_CHAR,
55 ATTRIBUTE15 cn_pay_element_inputs.attribute15%TYPE
56 := CN_API.G_MISS_CHAR
57 );
58
59 -- Global variable that represent missing values.
60 G_MISS_PAY_ELEMENT_INPUT_REC pay_element_input_rec_type;
61
62 --
63 -- Table Record Type for pay_element_input_rec_type
64 --
65 TYPE pay_element_input_tbl_type IS TABLE OF pay_element_input_rec_type
66 INDEX BY BINARY_INTEGER;
67
68 -- global variables that represent missing values
69 G_MISS_QPI_TBL_LIST pay_element_input_tbl_type;
70
71 -- user for getting and displaying in the jsp page.
72 TYPE pay_element_input_out_rec_type IS RECORD
73 ( pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE,
74 quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE,
75 element_input_id cn_pay_element_inputs.element_input_id%TYPE,
76 element_type_id cn_pay_element_inputs.element_type_id%TYPE,
77 table_name cn_objects.name%TYPE,
78 column_name cn_objects.name%TYPE,
79 start_date cn_pay_element_inputs.start_date%TYPE,
80 end_date cn_pay_element_inputs.end_date%TYPE,
81 pay_element_name pay_element_types.element_name%TYPE,
82 pay_input_name pay_input_values.name%TYPE,
83 line_number cn_pay_element_inputs.line_number%TYPE,
84 tab_object_id cn_objects.object_id%TYPE,
85 col_object_id cn_objects.object_id%TYPE
86 );
87
88 TYPE pay_element_input_out_tbl_type IS TABLE OF
89 pay_element_input_out_rec_type INDEX BY BINARY_INTEGER;
90
91 --============================================================================
92 -- Start of comments
93 -- API name : Create_pay_Element_input
94 -- Type : Private.
95 -- Pre-reqs : None.
96 -- Usage : Used to create a new Pay element inputs
97 -- Desc : Procedure to create a new pay element input
98 -- Parameters :
99 -- IN : p_api_version IN NUMBER Require
100 -- p_init_msg_list IN VARCHAR2 Optional
101 -- Default = CN_API.G_FALSE
102 -- p_commit IN VARCHAR2 Optional
103 -- Default = CN_API.G_FALSE
104 -- p_validation_level IN NUMBER Optional
105 -- Default = CN_API.G_VALID_LEVEL_FULL
106 -- p_pay_element_input_rec IN pay_element_input_rec_type
107 -- Required input :
108 -- OUT : x_return_status OUT VARCHAR2(1)
109 -- x_msg_count OUT NUMBER
110 -- x_msg_data OUT VARCHAR2(2000)
111 -- x_loading_status OUT VARCHAR2(30)
112 -- Version : Current version 1.0
113 -- Initial version 1.0
114 -- Notes :
115 -- Default Action for this procedure :
116 -- if nothing is passed for the status default is not active, which is same as
117 -- cn_salesreps default value
118 --
119 -- End of comments
120 --============================================================================
121 PROCEDURE Create_pay_element_input
122 (
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
125 p_commit IN VARCHAR2 := CN_API.G_FALSE,
126 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
127 x_return_status OUT VARCHAR2,
128 x_msg_count OUT NUMBER,
129 x_msg_data OUT VARCHAR2,
130 p_pay_element_input_rec IN pay_element_input_rec_type
131 := G_MISS_PAY_ELEMENT_INPUT_REC,
132 x_pay_element_input_id OUT NUMBER,
133 x_loading_status OUT VARCHAR2
134 );
135 --============================================================================
136 -- Start of comments
137 -- API name : Update_pay_element_input
138 -- Type : Private.
139 -- Pre-reqs : None.
140 -- Usage : Used to update pay element input
141 -- Desc : Procedure to update pay element input
142 -- Parameters :
143 -- IN : p_api_version IN NUMBER Require
144 -- p_init_msg_list IN VARCHAR2 Optional
145 -- Default = CN_API.G_FALSE
146 -- p_commit IN VARCHAR2 Optional
147 -- Default = CN_API.G_FALSE
148 -- p_validation_level IN NUMBER Optional
149 -- Default = CN_API.G_VALID_LEVEL_FULL
150 -- p_pay_element_input_rec IN pay_element_input_rec_type
151 -- Required input :
152 -- OUT : x_return_status OUT VARCHAR2(1)
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2(2000)
155 -- x_loading_status OUT VARCHAR2(30)
156 -- Version : Current version 1.0
157 -- Initial version 1.0
158 -- Notes :
159 --
160 -- End of comments
161 --============================================================================
162 PROCEDURE Update_pay_element_input
163 (
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
166 p_commit IN VARCHAR2 := CN_API.G_FALSE,
167 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
168 x_return_status OUT VARCHAR2,
169 x_msg_count OUT NUMBER,
170 x_msg_data OUT VARCHAR2,
171 po_pay_element_input_rec IN pay_element_input_rec_type
172 := g_miss_pay_element_input_rec,
173 p_pay_element_input_rec IN pay_element_input_rec_type
174 := G_MISS_pay_element_input_rec,
175 x_loading_status OUT VARCHAR2
176 );
177 --============================================================================
178 -- Start of comments
179 -- API name : Delete_pay_element_input
180 -- Type : Private
181 -- Pre-reqs : None.
182 -- Parameters :
183 -- IN : p_api_version IN NUMBER Require
184 -- p_init_msg_list IN VARCHAR2 Optional
185 -- Default = CN_API.G_FALSE
186 -- p_commit IN VARCHAR2 Optional
187 -- Default = CN_API.G_FALSE
188 -- p_validation_level IN NUMBER Optional
189 -- Default = CN_API.G_VALID_LEVEL_FULL
190 -- Required input :
191 -- pay_element_input_id
192 -- OUT : x_return_status OUT VARCHAR2(1)
193 -- x_msg_count OUT NUMBER
194 -- x_msg_data OUT VARCHAR2(2000)
195 -- x_loading_status OUT VARCHAR2(30)
196 -- Version : Current version 1.0
197 -- Initial version 1.0
198 -- Notes :
199 -- Delete pay element mapping
200 --
201 -- End of comments
202 --============================================================================
203 PROCEDURE Delete_pay_element_input
204 (
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
207 p_commit IN VARCHAR2 := CN_API.G_FALSE,
208 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
209 x_return_status OUT VARCHAR2,
210 x_msg_count OUT NUMBER,
211 x_msg_data OUT VARCHAR2,
212 p_pay_element_input_id IN NUMBER,
213 x_loading_status OUT VARCHAR2
214 );
215
216 --============================================================================
217 -- Start of Comments
218 --
219 -- API name : Get_pay_element_input
220 -- Type : Private.
221 -- Pre-reqs : None.
222 -- Usage : To get a pay element input
223 -- Desc : Procedure to get pay element
224 -- Parameters :
225 -- IN : p_api_version IN NUMBER Require
226 -- p_init_msg_list IN VARCHAR2 Optional
227 -- Default = FND_API.G_FALSE
228 -- p_commit IN VARCHAR2 Optional
229 -- Default = FND_API.G_FALSE
230 -- p_validation_level IN NUMBER Optional
231 -- Default = FND_API.G_VALID_LEVEL_FULL
232 -- OUT : x_return_status OUT VARCHAR2(1)
233 -- x_msg_count OUT NUMBER
234 -- x_msg_data OUT VARCHAR2(2000)
235 -- IN : p_pay_element, p_start_date, p_end_date
236 -- OUT : x_loading_status OUT
237 -- Detailed Error Message
238 -- Version : Current version 1.0
239 -- Initial version 1.0
240 --
241 -- End of comments
242 --============================================================================
243 PROCEDURE Get_pay_element_input
244 ( p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2,
246 p_commit IN VARCHAR2,
247 p_validation_level IN NUMBER,
248 x_return_status OUT VARCHAR2,
249 x_msg_count OUT NUMBER,
250 x_msg_data OUT VARCHAR2,
251 p_element_type_id IN cn_pay_element_inputs.element_type_id%TYPE,
252 p_start_record IN NUMBER,
253 p_increment_count IN NUMBER,
254 p_order_by IN VARCHAR2,
255 x_pay_element_input_tbl OUT pay_element_input_out_tbl_type,
259 );
256 x_total_records OUT NUMBER,
257 x_status OUT VARCHAR2,
258 x_loading_status OUT VARCHAR2
260
261 END CN_PAY_ELEMENT_INPUTS_PVT;