[Home] [Help]
PACKAGE: APPS.ASO_PRICE_ADJUSTMENTS_PKG
Source
1 PACKAGE ASO_PRICE_ADJUSTMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: asotpads.pls 120.1 2005/06/29 12:39:41 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PRICE_ADJUSTMENTS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 PROCEDURE Insert_Row(
12 px_PRICE_ADJUSTMENT_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
13 p_CREATION_DATE DATE,
14 p_CREATED_BY NUMBER,
15 p_LAST_UPDATE_DATE DATE,
16 p_LAST_UPDATED_BY NUMBER,
17 p_LAST_UPDATE_LOGIN NUMBER,
18 p_PROGRAM_APPLICATION_ID NUMBER,
19 p_PROGRAM_ID NUMBER,
20 p_PROGRAM_UPDATE_DATE DATE,
21 p_REQUEST_ID NUMBER,
22 p_QUOTE_HEADER_ID NUMBER,
23 p_QUOTE_LINE_ID NUMBER,
24 p_MODIFIER_HEADER_ID NUMBER,
25 p_MODIFIER_LINE_ID NUMBER,
26 p_MODIFIER_LINE_TYPE_CODE VARCHAR2,
27 p_MODIFIER_MECHANISM_TYPE_CODE VARCHAR2,
28 p_MODIFIED_FROM NUMBER,
29 p_MODIFIED_TO NUMBER,
30 p_OPERAND NUMBER,
31 p_ARITHMETIC_OPERATOR VARCHAR2,
32 p_AUTOMATIC_FLAG VARCHAR2,
33 p_UPDATE_ALLOWABLE_FLAG VARCHAR2,
34 p_UPDATED_FLAG VARCHAR2,
35 p_APPLIED_FLAG VARCHAR2,
36 p_ON_INVOICE_FLAG VARCHAR2,
37 p_PRICING_PHASE_ID NUMBER,
38 p_ATTRIBUTE_CATEGORY VARCHAR2,
39 p_ATTRIBUTE1 VARCHAR2,
40 p_ATTRIBUTE2 VARCHAR2,
41 p_ATTRIBUTE3 VARCHAR2,
42 p_ATTRIBUTE4 VARCHAR2,
43 p_ATTRIBUTE5 VARCHAR2,
44 p_ATTRIBUTE6 VARCHAR2,
45 p_ATTRIBUTE7 VARCHAR2,
46 p_ATTRIBUTE8 VARCHAR2,
47 p_ATTRIBUTE9 VARCHAR2,
48 p_ATTRIBUTE10 VARCHAR2,
49 p_ATTRIBUTE11 VARCHAR2,
50 p_ATTRIBUTE12 VARCHAR2,
51 p_ATTRIBUTE13 VARCHAR2,
52 p_ATTRIBUTE14 VARCHAR2,
53 p_ATTRIBUTE15 VARCHAR2,
54 p_ATTRIBUTE16 VARCHAR2,
55 p_ATTRIBUTE17 VARCHAR2,
56 p_ATTRIBUTE18 VARCHAR2,
57 p_ATTRIBUTE19 VARCHAR2,
58 p_ATTRIBUTE20 VARCHAR2,
59 p_ORIG_SYS_DISCOUNT_REF VARCHAR2 := NULL ,
60 p_CHANGE_SEQUENCE VARCHAR2 := NULL ,
61 -- p_LIST_HEADER_ID NUMBER := NULL ,
62 -- p_LIST_LINE_ID NUMBER := NULL ,
63 -- p_LIST_LINE_TYPE_CODE VARCHAR2 := NULL,
64 p_UPDATE_ALLOWED VARCHAR2 := NULL,
65 p_CHANGE_REASON_CODE VARCHAR2 := NULL,
66 p_CHANGE_REASON_TEXT VARCHAR2 := NULL,
67 p_COST_ID NUMBER := NULL,
68 p_TAX_CODE VARCHAR2 := NULL,
69 p_TAX_EXEMPT_FLAG VARCHAR2 := NULL,
70 p_TAX_EXEMPT_NUMBER VARCHAR2 := NULL,
71 p_TAX_EXEMPT_REASON_CODE VARCHAR2 := NULL,
72 p_PARENT_ADJUSTMENT_ID NUMBER := NULL,
73 p_INVOICED_FLAG VARCHAR2 := NULL,
74 p_ESTIMATED_FLAG VARCHAR2 := NULL,
75 p_INC_IN_SALES_PERFORMANCE VARCHAR2 := NULL,
76 p_SPLIT_ACTION_CODE VARCHAR2 := NULL,
77 p_ADJUSTED_AMOUNT NUMBER := NULL,
78 p_CHARGE_TYPE_CODE VARCHAR2 := NULL,
79 p_CHARGE_SUBTYPE_CODE VARCHAR2 := NULL,
80 p_RANGE_BREAK_QUANTITY NUMBER := NULL,
81 p_ACCRUAL_CONVERSION_RATE NUMBER := NULL ,
82 p_PRICING_GROUP_SEQUENCE NUMBER := NULL,
83 p_ACCRUAL_FLAG VARCHAR2 := NULL,
84 p_LIST_LINE_NO VARCHAR2 := NULL,
85 p_SOURCE_SYSTEM_CODE VARCHAR2 := NULL ,
86 p_BENEFIT_QTY NUMBER := NULL,
87 p_BENEFIT_UOM_CODE VARCHAR2 := NULL,
88 p_PRINT_ON_INVOICE_FLAG VARCHAR2 := NULL,
89 p_EXPIRATION_DATE DATE := NULL,
90 p_REBATE_TRANSACTION_TYPE_CODE VARCHAR2 := NULL,
91 p_REBATE_TRANSACTION_REFERENCE VARCHAR2 := NULL,
92 p_REBATE_PAYMENT_SYSTEM_CODE VARCHAR2 := NULL,
93 p_REDEEMED_DATE DATE := NULL,
94 p_REDEEMED_FLAG VARCHAR2 := NULL,
95 p_MODIFIER_LEVEL_CODE VARCHAR2 := NULL,
96 p_PRICE_BREAK_TYPE_CODE VARCHAR2 := NULL,
97 p_SUBSTITUTION_ATTRIBUTE VARCHAR2 := NULL,
98 p_PRORATION_TYPE_CODE VARCHAR2 := NULL,
99 p_INCLUDE_ON_RETURNS_FLAG VARCHAR2 := NULL,
100 p_CREDIT_OR_CHARGE_FLAG VARCHAR2 := NULL,
101 p_quote_shipment_id NUMBER := NULL,
102 p_OPERAND_PER_PQTY NUMBER := NULL,
103 p_ADJUSTED_AMOUNT_PER_PQTY NUMBER := NULL,
104 p_OBJECT_VERSION_NUMBER NUMBER
105 );
106
107 PROCEDURE Update_Row(
108 p_PRICE_ADJUSTMENT_ID NUMBER,
109 p_CREATION_DATE DATE,
110 p_CREATED_BY NUMBER,
111 p_LAST_UPDATE_DATE DATE,
112 p_LAST_UPDATED_BY NUMBER,
113 p_LAST_UPDATE_LOGIN NUMBER,
114 p_PROGRAM_APPLICATION_ID NUMBER,
115 p_PROGRAM_ID NUMBER,
116 p_PROGRAM_UPDATE_DATE DATE,
117 p_REQUEST_ID NUMBER,
118 p_QUOTE_HEADER_ID NUMBER,
119 p_QUOTE_LINE_ID NUMBER,
120 p_MODIFIER_HEADER_ID NUMBER,
121 p_MODIFIER_LINE_ID NUMBER,
122 p_MODIFIER_LINE_TYPE_CODE VARCHAR2,
123 p_MODIFIER_MECHANISM_TYPE_CODE VARCHAR2,
124 p_MODIFIED_FROM NUMBER,
125 p_MODIFIED_TO NUMBER,
126 p_OPERAND NUMBER,
127 p_ARITHMETIC_OPERATOR VARCHAR2,
128 p_AUTOMATIC_FLAG VARCHAR2,
129 p_UPDATE_ALLOWABLE_FLAG VARCHAR2,
130 p_UPDATED_FLAG VARCHAR2,
131 p_APPLIED_FLAG VARCHAR2,
132 p_ON_INVOICE_FLAG VARCHAR2,
133 p_PRICING_PHASE_ID NUMBER,
134 p_ATTRIBUTE_CATEGORY VARCHAR2,
135 p_ATTRIBUTE1 VARCHAR2,
136 p_ATTRIBUTE2 VARCHAR2,
137 p_ATTRIBUTE3 VARCHAR2,
138 p_ATTRIBUTE4 VARCHAR2,
139 p_ATTRIBUTE5 VARCHAR2,
140 p_ATTRIBUTE6 VARCHAR2,
141 p_ATTRIBUTE7 VARCHAR2,
142 p_ATTRIBUTE8 VARCHAR2,
143 p_ATTRIBUTE9 VARCHAR2,
144 p_ATTRIBUTE10 VARCHAR2,
145 p_ATTRIBUTE11 VARCHAR2,
146 p_ATTRIBUTE12 VARCHAR2,
147 p_ATTRIBUTE13 VARCHAR2,
148 p_ATTRIBUTE14 VARCHAR2,
149 p_ATTRIBUTE15 VARCHAR2,
150 p_ATTRIBUTE16 VARCHAR2,
151 p_ATTRIBUTE17 VARCHAR2,
152 p_ATTRIBUTE18 VARCHAR2,
153 p_ATTRIBUTE19 VARCHAR2,
154 p_ATTRIBUTE20 VARCHAR2,
155 p_ORIG_SYS_DISCOUNT_REF VARCHAR2,
156 p_CHANGE_SEQUENCE VARCHAR2,
157 --p_LIST_HEADER_ID NUMBER,
158 --p_LIST_LINE_ID NUMBER,
159 --p_LIST_LINE_TYPE_CODE VARCHAR2,
160 p_UPDATE_ALLOWED VARCHAR2,
161 p_CHANGE_REASON_CODE VARCHAR2,
162 p_CHANGE_REASON_TEXT VARCHAR2,
163 p_COST_ID NUMBER,
164 p_TAX_CODE VARCHAR2,
165 p_TAX_EXEMPT_FLAG VARCHAR2,
166 p_TAX_EXEMPT_NUMBER VARCHAR2,
167 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
168 p_PARENT_ADJUSTMENT_ID NUMBER,
169 p_INVOICED_FLAG VARCHAR2,
170 p_ESTIMATED_FLAG VARCHAR2,
171 p_INC_IN_SALES_PERFORMANCE VARCHAR2,
172 p_SPLIT_ACTION_CODE VARCHAR2,
173 p_ADJUSTED_AMOUNT NUMBER,
174 p_CHARGE_TYPE_CODE VARCHAR2,
175 p_CHARGE_SUBTYPE_CODE VARCHAR2,
176 p_RANGE_BREAK_QUANTITY NUMBER,
177 p_ACCRUAL_CONVERSION_RATE NUMBER,
178 p_PRICING_GROUP_SEQUENCE NUMBER,
179 p_ACCRUAL_FLAG VARCHAR2,
180 p_LIST_LINE_NO VARCHAR2,
181 p_SOURCE_SYSTEM_CODE VARCHAR2,
182 p_BENEFIT_QTY NUMBER,
183 p_BENEFIT_UOM_CODE VARCHAR2,
184 p_PRINT_ON_INVOICE_FLAG VARCHAR2,
185 p_EXPIRATION_DATE DATE,
186 p_REBATE_TRANSACTION_TYPE_CODE VARCHAR2,
187 p_REBATE_TRANSACTION_REFERENCE VARCHAR2,
188 p_REBATE_PAYMENT_SYSTEM_CODE VARCHAR2,
189 p_REDEEMED_DATE DATE,
190 p_REDEEMED_FLAG VARCHAR2,
191 p_MODIFIER_LEVEL_CODE VARCHAR2,
192 p_PRICE_BREAK_TYPE_CODE VARCHAR2,
193 p_SUBSTITUTION_ATTRIBUTE VARCHAR2,
194 p_PRORATION_TYPE_CODE VARCHAR2,
195 p_INCLUDE_ON_RETURNS_FLAG VARCHAR2,
196 p_CREDIT_OR_CHARGE_FLAG VARCHAR2,
197 p_quote_shipment_id NUMBER,
198 p_OPERAND_PER_PQTY NUMBER,
199 p_ADJUSTED_AMOUNT_PER_PQTY NUMBER,
200 p_OBJECT_VERSION_NUMBER NUMBER
201 );
202
203 PROCEDURE Lock_Row(
204 --p_OBJECT_VERSION_NUMBER NUMBER,
205 p_PRICE_ADJUSTMENT_ID NUMBER,
206 p_CREATION_DATE DATE,
207 p_CREATED_BY NUMBER,
208 p_LAST_UPDATE_DATE DATE,
209 p_LAST_UPDATED_BY NUMBER,
210 p_LAST_UPDATE_LOGIN NUMBER,
211 p_PROGRAM_APPLICATION_ID NUMBER,
212 p_PROGRAM_ID NUMBER,
213 p_PROGRAM_UPDATE_DATE DATE,
214 p_REQUEST_ID NUMBER,
215 p_QUOTE_HEADER_ID NUMBER,
216 p_QUOTE_LINE_ID NUMBER,
217 p_MODIFIER_HEADER_ID NUMBER,
218 p_MODIFIER_LINE_ID NUMBER,
219 p_MODIFIER_LINE_TYPE_CODE VARCHAR2,
220 p_MODIFIER_MECHANISM_TYPE_CODE VARCHAR2,
221 p_MODIFIED_FROM NUMBER,
222 p_MODIFIED_TO NUMBER,
223 p_OPERAND NUMBER,
224 p_ARITHMETIC_OPERATOR VARCHAR2,
225 p_AUTOMATIC_FLAG VARCHAR2,
226 p_UPDATE_ALLOWABLE_FLAG VARCHAR2,
227 p_UPDATED_FLAG VARCHAR2,
228 p_APPLIED_FLAG VARCHAR2,
229 p_ON_INVOICE_FLAG VARCHAR2,
230 p_PRICING_PHASE_ID NUMBER,
231 p_ATTRIBUTE_CATEGORY VARCHAR2,
232 p_ATTRIBUTE1 VARCHAR2,
233 p_ATTRIBUTE2 VARCHAR2,
234 p_ATTRIBUTE3 VARCHAR2,
235 p_ATTRIBUTE4 VARCHAR2,
236 p_ATTRIBUTE5 VARCHAR2,
237 p_ATTRIBUTE6 VARCHAR2,
238 p_ATTRIBUTE7 VARCHAR2,
239 p_ATTRIBUTE8 VARCHAR2,
240 p_ATTRIBUTE9 VARCHAR2,
241 p_ATTRIBUTE10 VARCHAR2,
242 p_ATTRIBUTE11 VARCHAR2,
243 p_ATTRIBUTE12 VARCHAR2,
244 p_ATTRIBUTE13 VARCHAR2,
245 p_ATTRIBUTE14 VARCHAR2,
246 p_ATTRIBUTE15 VARCHAR2,
247 p_ORIG_SYS_DISCOUNT_REF VARCHAR2 ,
248 p_CHANGE_SEQUENCE VARCHAR2 ,
249 --p_LIST_HEADER_ID NUMBER,
250 --p_LIST_LINE_ID NUMBER,
251 --p_LIST_LINE_TYPE_CODE VARCHAR2,
252 p_UPDATE_ALLOWED VARCHAR2,
253 p_CHANGE_REASON_CODE VARCHAR2,
254 p_CHANGE_REASON_TEXT VARCHAR2,
255 p_COST_ID NUMBER,
256 p_TAX_CODE VARCHAR2 ,
257 p_TAX_EXEMPT_FLAG VARCHAR2,
258 p_TAX_EXEMPT_NUMBER VARCHAR2,
259 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
260 p_PARENT_ADJUSTMENT_ID NUMBER,
261 p_INVOICED_FLAG VARCHAR2,
262 p_ESTIMATED_FLAG VARCHAR2,
263 p_INC_IN_SALES_PERFORMANCE VARCHAR2,
264 p_SPLIT_ACTION_CODE VARCHAR2,
265 p_ADJUSTED_AMOUNT NUMBER,
266 p_CHARGE_TYPE_CODE VARCHAR2,
267 p_CHARGE_SUBTYPE_CODE VARCHAR2,
268 p_RANGE_BREAK_QUANTITY NUMBER,
272 p_LIST_LINE_NO VARCHAR2,
269 p_ACCRUAL_CONVERSION_RATE NUMBER,
270 p_PRICING_GROUP_SEQUENCE NUMBER,
271 p_ACCRUAL_FLAG VARCHAR2,
273 p_SOURCE_SYSTEM_CODE VARCHAR2,
274 p_BENEFIT_QTY NUMBER,
275 p_BENEFIT_UOM_CODE VARCHAR2,
276 p_PRINT_ON_INVOICE_FLAG VARCHAR2,
277 p_EXPIRATION_DATE DATE,
278 p_REBATE_TRANSACTION_TYPE_CODE VARCHAR2,
279 p_REBATE_TRANSACTION_REFERENCE VARCHAR2,
280 p_REBATE_PAYMENT_SYSTEM_CODE VARCHAR2,
281 p_REDEEMED_DATE DATE,
282 p_REDEEMED_FLAG VARCHAR2,
283 p_MODIFIER_LEVEL_CODE VARCHAR2,
284 p_PRICE_BREAK_TYPE_CODE VARCHAR2,
285 p_SUBSTITUTION_ATTRIBUTE VARCHAR2,
286 p_PRORATION_TYPE_CODE VARCHAR2,
287 p_INCLUDE_ON_RETURNS_FLAG VARCHAR2,
288 p_CREDIT_OR_CHARGE_FLAG VARCHAR2,
289 p_quote_shipment_id NUMBER := NULL
290 );
291
292 PROCEDURE Delete_Row(
293 p_PRICE_ADJUSTMENT_ID NUMBER);
294
295 PROCEDURE Delete_Row(
296 p_PRICE_ADJ_ID NUMBER);
297
298 PROCEDURE Delete_Row(
299 p_LINE_ID NUMBER,
300 p_TYPE_CODE VARCHAR2);
301
302
303 End ASO_PRICE_ADJUSTMENTS_PKG;