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