[Home] [Help]
PACKAGE BODY: APPS.ARP_MUL_EXEMPT_COV
Source
1 PACKAGE BODY ARP_MUL_EXEMPT_COV as
2 /* $Header: ARXEMECB.pls 120.5 2006/05/10 00:08:49 sachandr ship $ */
3 /* Purpose: This package contains the cover routines used to create Multiple */
4 /* tax rate exemptions. The routines are called from the 10SC forms */
5 /* RAXSTDTE(Item Tax Rate Exceptions) and RAXSUDTE(Tax Exemptions). */
6
7 /*----------------------------------------------------------------------------*
8 | PRIVATE GLOBAL VARIABLES |
9 *----------------------------------------------------------------------------*/
10 pg_Date_Format CONSTANT VARCHAR2(20) := 'DD-MM-RR HH24:MI:SS';
11 --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
12 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
13
14 /*----------------------------------------------------------------------------*
15 | PUBLIC FUNCTIONS/PROCEDURES |
16 *----------------------------------------------------------------------------*/
17
18 /*----------------------------------------------------------------------------*
19 | PROCEDURE |
20 | exceptions |
21 | |
22 | DESCRIPTION |
23 | This procedure will update exceptions given an Item Range. Item Range |
24 | could be specified using Item Flex Range, Item Category Set, Category |
25 | and Item type.An existing exception must have the same effectivity date |
26 | to be updated. |
27 | |
28 | Since the PL/SQL concurrent pgm parameters have to be of type VARCHAR2, |
29 | this procedure will also convert the parameters to the appropriate |
30 | datatype before invoking the entity handler in ARP_MULTI_EXEMPTIONS. |
31 | |
32 | PARAMETERS |
33 | INPUT |
34 | p_Conc_Req_Flag VARCHAR2 -- 'Y' if called thru a conc pgm. |
35 | p_Insert_Flag VARCHAR2 -- 'Y' if INSERT, 'N' if UPDATE. |
36 | Item Flex Range, Item Category Set, Item Category, Item Type and |
37 | Old/New Exception details. |
38 | OUTPUT |
39 | Errbuf VARCHAR2 -- Conc Pgm Error mesgs. |
40 | RetCode VARCHAR2 -- Conc Pgm Error Code. |
41 | 0 - Success, 2 - Failure. |
42 | |
43 | Note: The Date parameters format must be as in pg_Date_Format. |
44 | |
45 | HISTORY |
46 | 28-Feb-96 Mahesh Sabapathy Created. |
47 *----------------------------------------------------------------------------*/
48 PROCEDURE exceptions (
49 Errbuf OUT NOCOPY VARCHAR2,
50 Retcode OUT NOCOPY VARCHAR2,
51 p_Conc_Req_Flag VARCHAR2 default 'Y',
52 p_Insert_Flag VARCHAR2 default 'Y',
53 p_Org_ID VARCHAR2,
54 p_Item_Segment1_Low VARCHAR2,
55 p_Item_Segment1_High VARCHAR2,
56 p_Item_Segment2_Low VARCHAR2,
57 p_Item_Segment2_High VARCHAR2,
58 p_Item_Segment3_Low VARCHAR2,
59 p_Item_Segment3_High VARCHAR2,
60 p_Item_Segment4_Low VARCHAR2,
61 p_Item_Segment4_High VARCHAR2,
62 p_Item_Segment5_Low VARCHAR2,
63 p_Item_Segment5_High VARCHAR2,
64 p_Item_Segment6_Low VARCHAR2,
65 p_Item_Segment6_High VARCHAR2,
66 p_Item_Segment7_Low VARCHAR2,
67 p_Item_Segment7_High VARCHAR2,
68 p_Item_Segment8_Low VARCHAR2,
69 p_Item_Segment8_High VARCHAR2,
70 p_Item_Segment9_Low VARCHAR2,
71 p_Item_Segment9_High VARCHAR2,
72 p_Item_Segment10_Low VARCHAR2,
73 p_Item_Segment10_High VARCHAR2,
74 p_Category_Set_Id VARCHAR2,
75 p_Category_Id VARCHAR2,
76 p_Item_Type VARCHAR2,
77 p_Old_Location_Id_Segment_1 VARCHAR2,
78 p_Old_Location_Id_Segment_2 VARCHAR2,
79 p_Old_Location_Id_Segment_3 VARCHAR2,
80 p_Old_Location_Id_Segment_4 VARCHAR2,
81 p_Old_Location_Id_Segment_5 VARCHAR2,
82 p_Old_Location_Id_Segment_6 VARCHAR2,
83 p_Old_Location_Id_Segment_7 VARCHAR2,
84 p_Old_Location_Id_Segment_8 VARCHAR2,
85 p_Old_Location_Id_Segment_9 VARCHAR2,
86 p_Old_Location_Id_Segment_10 VARCHAR2,
87 p_Old_Start_Date VARCHAR2,
88 p_Old_End_Date VARCHAR2,
89 p_Creation_Date VARCHAR2,
90 p_Created_By VARCHAR2,
91 p_Last_Update_Login VARCHAR2,
92 p_Last_Updated_By VARCHAR2,
93 p_Last_Update_Date VARCHAR2,
94 p_Location_Context VARCHAR2,
95 p_Location_Id_Segment_1 VARCHAR2,
96 p_Location_Id_Segment_2 VARCHAR2,
97 p_Location_Id_Segment_3 VARCHAR2,
98 p_Location_Id_Segment_4 VARCHAR2,
99 p_Location_Id_Segment_5 VARCHAR2,
100 p_Location_Id_Segment_6 VARCHAR2,
101 p_Location_Id_Segment_7 VARCHAR2,
102 p_Location_Id_Segment_8 VARCHAR2,
103 p_Location_Id_Segment_9 VARCHAR2,
104 p_Location_Id_Segment_10 VARCHAR2,
105 p_Rate_Context VARCHAR2,
106 p_Location1_Rate VARCHAR2,
107 p_Location2_Rate VARCHAR2,
108 p_Location3_Rate VARCHAR2,
109 p_Location4_Rate VARCHAR2,
110 p_Location5_Rate VARCHAR2,
111 p_Location6_Rate VARCHAR2,
112 p_Location7_Rate VARCHAR2,
113 p_Location8_Rate VARCHAR2,
114 p_Location9_Rate VARCHAR2,
115 p_Location10_Rate VARCHAR2,
116 p_Start_Date VARCHAR2,
117 p_End_Date VARCHAR2,
118 p_Reason_Code VARCHAR2,
119 p_Attribute_Category VARCHAR2,
120 p_Attribute1 VARCHAR2,
121 p_Attribute2 VARCHAR2,
122 p_Attribute3 VARCHAR2,
123 p_Attribute4 VARCHAR2,
124 p_Attribute5 VARCHAR2,
125 p_Attribute6 VARCHAR2,
126 p_Attribute7 VARCHAR2,
127 p_Attribute8 VARCHAR2,
128 p_Attribute9 VARCHAR2,
129 p_Attribute10 VARCHAR2,
130 p_Attribute11 VARCHAR2,
131 p_Attribute12 VARCHAR2,
132 p_Attribute13 VARCHAR2,
133 p_Attribute14 VARCHAR2,
134 p_Attribute15 VARCHAR2
135 ) IS
136 BEGIN
137 null;
138 EXCEPTION
139 WHEN OTHERS THEN
140 NULL;
141 END exceptions;
142
143 /*----------------------------------------------------------------------------*
144 | PROCEDURE |
145 | exemptions |
146 | |
147 | DESCRIPTION |
148 | This procedure will update exemptions given an Item Range. Item Range |
149 | could be specified using Item Flex Range, Item Category Set, Category |
150 | and Item type.An existing exemption must have the same effectivity date |
151 | to be updated. |
152 | |
153 | Since the PL/SQL concurrent pgm parameters have to be of type VARCHAR2, |
154 | this procedure will also convert the parameters to the appropriate |
155 | datatype before invoking the entity handler in ARP_MULTI_EXEMPTIONS. |
156 | |
157 | PARAMETERS |
158 | INPUT |
159 | p_Conc_Req_Flag VARCHAR2 -- 'Y' if called thru a conc pgm. |
160 | p_Insert_Flag VARCHAR2 -- 'Y' if INSERT, 'N' if UPDATE. |
161 | Item Flex Range, Item Category Set, Item Category, Item Type and |
162 | Old/New Exemption details. |
163 | OUTPUT |
164 | Errbuf VARCHAR2 -- Conc Pgm Error mesgs. |
165 | RetCode VARCHAR2 -- Conc Pgm Error Code. |
166 | 0 - Success, 2 - Failure. |
167 | |
168 | HISTORY |
169 | 20-Mar-96 Mahesh Sabapathy Created. |
170 | 09-Mar-99 Nilesh Patel - added parameters exempt_context and |
171 | exempt percent1-10 in procedure exemptions |
172 *----------------------------------------------------------------------------*/
173 PROCEDURE exemptions (
174 Errbuf OUT NOCOPY VARCHAR2,
175 Retcode OUT NOCOPY VARCHAR2,
176 p_Conc_Req_Flag VARCHAR2 default 'Y',
177 p_Insert_Flag VARCHAR2 default 'Y',
178 p_Org_ID VARCHAR2,
179 p_Item_Segment1_Low VARCHAR2,
180 p_Item_Segment1_High VARCHAR2,
181 p_Item_Segment2_Low VARCHAR2,
182 p_Item_Segment2_High VARCHAR2,
183 p_Item_Segment3_Low VARCHAR2,
184 p_Item_Segment3_High VARCHAR2,
185 p_Item_Segment4_Low VARCHAR2,
186 p_Item_Segment4_High VARCHAR2,
187 p_Item_Segment5_Low VARCHAR2,
188 p_Item_Segment5_High VARCHAR2,
189 p_Item_Segment6_Low VARCHAR2,
190 p_Item_Segment6_High VARCHAR2,
191 p_Item_Segment7_Low VARCHAR2,
192 p_Item_Segment7_High VARCHAR2,
193 p_Item_Segment8_Low VARCHAR2,
194 p_Item_Segment8_High VARCHAR2,
195 p_Item_Segment9_Low VARCHAR2,
196 p_Item_Segment9_High VARCHAR2,
197 p_Item_Segment10_Low VARCHAR2,
198 p_Item_Segment10_High VARCHAR2,
199 p_Category_Set_Id VARCHAR2,
200 p_Category_Id VARCHAR2,
201 p_Item_Type VARCHAR2,
202 p_Old_Tax_Code VARCHAR2,
203 p_Old_Start_Date VARCHAR2,
204 p_Old_End_Date VARCHAR2,
205 p_Last_updated_by VARCHAR2,
206 p_Last_update_date VARCHAR2,
207 p_Created_by VARCHAR2,
208 p_Creation_date VARCHAR2,
209 p_Status VARCHAR2,
210 p_Customer_id VARCHAR2,
211 p_Site_use_id VARCHAR2,
212 p_Exemption_type VARCHAR2,
213 p_Tax_code VARCHAR2,
214 p_Percent_exempt VARCHAR2,
215 p_Customer_exemption_number VARCHAR2,
216 p_Start_date VARCHAR2,
217 p_End_date VARCHAR2,
218 p_Location_context VARCHAR2,
219 p_Location_id_segment_1 VARCHAR2,
220 p_Location_id_segment_2 VARCHAR2,
221 p_Location_id_segment_3 VARCHAR2,
222 p_Location_id_segment_4 VARCHAR2,
223 p_Location_id_segment_5 VARCHAR2,
224 p_Location_id_segment_6 VARCHAR2,
225 p_Location_id_segment_7 VARCHAR2,
226 p_Location_id_segment_8 VARCHAR2,
227 p_Location_id_segment_9 VARCHAR2,
228 p_Location_id_segment_10 VARCHAR2,
229 p_Attribute_category VARCHAR2,
230 p_Attribute1 VARCHAR2,
231 p_Attribute2 VARCHAR2,
232 p_Attribute3 VARCHAR2,
233 p_Attribute4 VARCHAR2,
234 p_Attribute5 VARCHAR2,
235 p_Attribute6 VARCHAR2,
236 p_Attribute7 VARCHAR2,
237 p_Attribute8 VARCHAR2,
238 p_Attribute9 VARCHAR2,
239 p_Attribute10 VARCHAR2,
240 p_Attribute11 VARCHAR2,
241 p_Attribute12 VARCHAR2,
242 p_Attribute13 VARCHAR2,
243 p_Attribute14 VARCHAR2,
244 p_Attribute15 VARCHAR2,
245 p_In_use_flag VARCHAR2,
246 p_Program_id VARCHAR2,
247 p_Program_update_date VARCHAR2,
248 p_Request_id VARCHAR2,
249 p_Program_application_id VARCHAR2,
250 p_Reason_code VARCHAR2,
251 p_Exempt_Context VARCHAR2,
252 p_Exempt_Percent1 VARCHAR2,
253 p_Exempt_Percent2 VARCHAR2,
254 p_Exempt_Percent3 VARCHAR2,
255 p_Exempt_Percent4 VARCHAR2,
256 p_Exempt_Percent5 VARCHAR2,
257 p_Exempt_Percent6 VARCHAR2,
258 p_Exempt_Percent7 VARCHAR2,
259 p_Exempt_Percent8 VARCHAR2,
260 p_Exempt_Percent9 VARCHAR2,
261 p_Exempt_Percent10 VARCHAR2
262
263
264 ) IS
265
266
267 BEGIN
268
269 null;
270 EXCEPTION
271 WHEN OTHERS THEN
272 null;
273 END exemptions;
274
275
276 END ARP_MUL_EXEMPT_COV;