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