[Home] [Help]
PACKAGE: APPS.OE_OE_FORM_HEADER_ADJ
Source
1 PACKAGE OE_OE_Form_Header_Adj AUTHID CURRENT_USER AS
2 /* $Header: OEXFHADS.pls 120.0 2005/06/01 01:20:00 appldev noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
10 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , p_header_id IN NUMBER
12 , p_line_id IN NUMBER
13 , x_price_adjustment_id OUT NOCOPY /* file.sql.39 change */ NUMBER
14 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
15 , x_discount_id OUT NOCOPY /* file.sql.39 change */ NUMBER
16 , x_discount_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
17 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_percent OUT NOCOPY /* file.sql.39 change */ NUMBER
19 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
20 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_discount OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
39 , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 , x_modifier_mechanism_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 , x_updated_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_update_allowed OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_applied_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_change_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_change_reason_text OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_modified_from OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_modified_to OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_operand OUT NOCOPY /* file.sql.39 change */ NUMBER
49 , x_arithmetic_operator OUT NOCOPY /* file.sql.39 change */ varchar2
50 , x_adjusted_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
51 , x_pricing_phase_id OUT NOCOPY /* file.sql.39 change */ NUMBER
52 , x_list_line_no OUT NOCOPY /* file.sql.39 change */ varchar2
53 , x_source_system_code OUT NOCOPY /* file.sql.39 change */ varchar2
54 , x_benefit_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
55 , x_benefit_uom_code OUT NOCOPY /* file.sql.39 change */ varchar2
56 , x_print_on_invoice_flag OUT NOCOPY /* file.sql.39 change */ varchar2
57 , x_expiration_date OUT NOCOPY /* file.sql.39 change */ DATE
58 , x_rebate_transaction_type_code OUT NOCOPY /* file.sql.39 change */ varchar2
59 , x_rebate_transaction_reference OUT NOCOPY /* file.sql.39 change */ varchar2
60 , x_rebate_payment_system_code OUT NOCOPY /* file.sql.39 change */ varchar2
61 , x_redeemed_date OUT NOCOPY /* file.sql.39 change */ DATE
62 , x_redeemed_flag OUT NOCOPY /* file.sql.39 change */ varchar2
63 , x_accrual_flag OUT NOCOPY /* file.sql.39 change */ varchar2
64 , x_invoiced_flag OUT NOCOPY /* file.sql.39 change */ varchar2
65 , x_estimated_flag OUT NOCOPY /* file.sql.39 change */ varchar2
66 , x_credit_or_charge_flag OUT NOCOPY /* file.sql.39 change */ varchar2
67 , x_include_on_returns_flag OUT NOCOPY /* file.sql.39 change */ varchar2
68 , x_charge_type_code OUT NOCOPY /* file.sql.39 change */ varchar2
69 , x_charge_subtype_code OUT NOCOPY /* file.sql.39 change */ varchar2
70 , x_ac_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 , x_ac_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 , x_ac_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 , x_ac_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 , x_ac_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 , x_ac_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_ac_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_ac_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_ac_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_ac_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_ac_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_ac_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_ac_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_ac_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_ac_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_ac_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 --uom begin
87 , x_operand_per_pqty OUT NOCOPY /* file.sql.39 change */ NUMBER
88 , x_adjusted_amount_per_pqty OUT NOCOPY /* file.sql.39 change */ NUMBER
89 --uom end
90 );
91
92 -- Procedure : Change_Attributes
93 --
94
95 PROCEDURE Change_Attributes
96 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
98 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , p_price_adjustment_id IN NUMBER
100 , p_attr_id IN NUMBER
101 , p_attr_value1 IN VARCHAR2
102 , p_attr_value2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
103 , p_context IN VARCHAR2
104 , p_attribute1 IN VARCHAR2
105 , p_attribute2 IN VARCHAR2
106 , p_attribute3 IN VARCHAR2
107 , p_attribute4 IN VARCHAR2
108 , p_attribute5 IN VARCHAR2
109 , p_attribute6 IN VARCHAR2
110 , p_attribute7 IN VARCHAR2
111 , p_attribute8 IN VARCHAR2
112 , p_attribute9 IN VARCHAR2
113 , p_attribute10 IN VARCHAR2
114 , p_attribute11 IN VARCHAR2
115 , p_attribute12 IN VARCHAR2
116 , p_attribute13 IN VARCHAR2
117 , p_attribute14 IN VARCHAR2
118 , p_attribute15 IN VARCHAR2
119 , p_ac_context IN VARCHAR2
120 , p_ac_attribute1 IN VARCHAR2
121 , p_ac_attribute2 IN VARCHAR2
122 , p_ac_attribute3 IN VARCHAR2
123 , p_ac_attribute4 IN VARCHAR2
124 , p_ac_attribute5 IN VARCHAR2
125 , p_ac_attribute6 IN VARCHAR2
126 , p_ac_attribute7 IN VARCHAR2
127 , p_ac_attribute8 IN VARCHAR2
128 , p_ac_attribute9 IN VARCHAR2
129 , p_ac_attribute10 IN VARCHAR2
130 , p_ac_attribute11 IN VARCHAR2
131 , p_ac_attribute12 IN VARCHAR2
132 , p_ac_attribute13 IN VARCHAR2
133 , p_ac_attribute14 IN VARCHAR2
134 , p_ac_attribute15 IN VARCHAR2
135 , x_price_adjustment_id OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
137 , x_discount_id OUT NOCOPY /* file.sql.39 change */ NUMBER
138 , x_discount_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
139 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 , x_percent OUT NOCOPY /* file.sql.39 change */ NUMBER
141 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
142 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 , x_ac_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 , x_ac_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 , x_ac_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
161 , x_ac_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 , x_ac_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
163 , x_ac_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164 , x_ac_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
165 , x_ac_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
166 , x_ac_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , x_ac_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168 , x_ac_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169 , x_ac_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170 , x_ac_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
171 , x_ac_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 , x_ac_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
173 , x_ac_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174 , x_discount OUT NOCOPY /* file.sql.39 change */ VARCHAR2
175 , p_enforce_fixed_price IN VARCHAR2
176
177 -- New code added
178 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
179 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
180 , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181 , x_modifier_mechanism_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
182 , x_updated_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
183 , x_update_allowed OUT NOCOPY /* file.sql.39 change */ VARCHAR2
184 , x_applied_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
185 , x_change_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
186 , x_change_reason_text OUT NOCOPY /* file.sql.39 change */ VARCHAR2
187 , x_modified_from OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188 , x_modified_to OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 , x_operand OUT NOCOPY /* file.sql.39 change */ NUMBER
190 , x_arithmetic_operator OUT NOCOPY /* file.sql.39 change */ varchar2
191 , x_adjusted_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
192 , x_pricing_phase_id OUT NOCOPY /* file.sql.39 change */ NUMBER
193 , x_list_line_no OUT NOCOPY /* file.sql.39 change */ varchar2
194 , x_source_system_code OUT NOCOPY /* file.sql.39 change */ varchar2
195 , x_benefit_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
196 , x_benefit_uom_code OUT NOCOPY /* file.sql.39 change */ varchar2
197 , x_print_on_invoice_flag OUT NOCOPY /* file.sql.39 change */ varchar2
198 , x_expiration_date OUT NOCOPY /* file.sql.39 change */ DATE
199 , x_rebate_transaction_type_code OUT NOCOPY /* file.sql.39 change */ varchar2
203 , x_redeemed_flag OUT NOCOPY /* file.sql.39 change */ varchar2
200 , x_rebate_transaction_reference OUT NOCOPY /* file.sql.39 change */ varchar2
201 , x_rebate_payment_system_code OUT NOCOPY /* file.sql.39 change */ varchar2
202 , x_redeemed_date OUT NOCOPY /* file.sql.39 change */ DATE
204 , x_accrual_flag OUT NOCOPY /* file.sql.39 change */ varchar2
205 , x_invoiced_flag OUT NOCOPY /* file.sql.39 change */ varchar2
206 , x_estimated_flag OUT NOCOPY /* file.sql.39 change */ varchar2
207 , x_credit_or_charge_flag OUT NOCOPY /* file.sql.39 change */ varchar2
208 , x_include_on_returns_flag OUT NOCOPY /* file.sql.39 change */ varchar2
209 , x_charge_type_code OUT NOCOPY /* file.sql.39 change */ varchar2
210 , x_charge_subtype_code OUT NOCOPY /* file.sql.39 change */ varchar2
211 --uom begin
212 , x_operand_per_pqty OUT NOCOPY /* file.sql.39 change */ NUMBER
213 , x_adjusted_amount_per_pqty OUT NOCOPY /* file.sql.39 change */ NUMBER
214 --uom end
215 );
216
217 -- Procedure Validate_And_Write
218 --
219
220 PROCEDURE Validate_And_Write
221 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
222 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
223 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
224 , p_price_adjustment_id IN NUMBER
225 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
226 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
227 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
228 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
229 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
230 , p_ok_flag IN VARCHAR2
231 , x_program_id OUT NOCOPY /* file.sql.39 change */ NUMBER
232 , x_program_application_id OUT NOCOPY /* file.sql.39 change */ NUMBER
233 , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
234 , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
235 , x_lock_control OUT NOCOPY /* file.sql.39 change */ NUMBER
236 );
237
238 -- Procedure Delete_Row
239 --
240
241 PROCEDURE Delete_Row
242 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
243 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
244 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
245 , p_price_adjustment_id IN NUMBER
246 , p_change_reason_code IN VARCHAR2 Default Null
247 , p_change_comments IN VARCHAR2 Default Null
248 );
249
250 -- Procedure Process_Entity
251 --
252
253 PROCEDURE Process_Delayed_Requests
254 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
255 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
256 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
257 , p_header_id IN NUMBER
258 );
259
260
261 -- Procedure lock_Row
262 --
263
264 PROCEDURE Lock_Row
265 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
266 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
267 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
268 , p_price_adjustment_id IN NUMBER
269 , p_lock_control IN NUMBER
270 );
271
272 END OE_OE_Form_Header_Adj;