137: FUNCTION G_MISS_OE_AK_HEADER_ADJ_REC
138: RETURN OE_AK_HEADER_PRCADJS_V%ROWTYPE;
139:
140: PROCEDURE API_Rec_To_Rowtype_Rec
141: ( p_HEADER_ADJ_rec IN OE_Order_PUB.HEADER_ADJ_Rec_Type
142: , x_rowtype_rec OUT nocopy OE_AK_HEADER_PRCADJS_V%ROWTYPE
143: );
144:
145: PROCEDURE Rowtype_Rec_To_API_Rec
143: );
144:
145: PROCEDURE Rowtype_Rec_To_API_Rec
146: ( p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
147: , x_api_rec OUT nocopy OE_Order_PUB.HEADER_ADJ_Rec_Type
148: );
149:
150:
151: -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
160: -- Procedure Clear_Dependent_Attr
161:
162: PROCEDURE Clear_Dependent_Attr
163: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
164: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
165: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
166: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
167: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
168: );
161:
162: PROCEDURE Clear_Dependent_Attr
163: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
164: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
165: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
166: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
167: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
168: );
169:
162: PROCEDURE Clear_Dependent_Attr
163: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
164: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
165: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
166: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
167: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
168: );
169:
170: --Bug 4060297
163: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
164: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
165: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
166: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
167: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
168: );
169:
170: --Bug 4060297
171: Procedure log_request_for_margin(p_header_id in number);
173:
174: -- Procedure Apply_Attribute_Changes
175:
176: PROCEDURE Apply_Attribute_Changes
177: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
178: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
179: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
180: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
181: );
174: -- Procedure Apply_Attribute_Changes
175:
176: PROCEDURE Apply_Attribute_Changes
177: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
178: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
179: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
180: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
181: );
182:
175:
176: PROCEDURE Apply_Attribute_Changes
177: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
178: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
179: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
180: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
181: );
182:
183: -- Procedure Complete_Record
176: PROCEDURE Apply_Attribute_Changes
177: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
178: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
179: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
180: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
181: );
182:
183: -- Procedure Complete_Record
184:
182:
183: -- Procedure Complete_Record
184:
185: PROCEDURE Complete_Record
186: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
187: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
188: );
189:
190: -- Procedure Convert_Miss_To_Null
183: -- Procedure Complete_Record
184:
185: PROCEDURE Complete_Record
186: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
187: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
188: );
189:
190: -- Procedure Convert_Miss_To_Null
191:
189:
190: -- Procedure Convert_Miss_To_Null
191:
192: PROCEDURE Convert_Miss_To_Null
193: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
194: );
195:
196: -- Procedure Update_Row
197:
195:
196: -- Procedure Update_Row
197:
198: PROCEDURE Update_Row
199: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
200: );
201:
202: -- Procedure Insert_Row
203:
201:
202: -- Procedure Insert_Row
203:
204: PROCEDURE Insert_Row
205: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
206: );
207:
208: -- Procedure Delete_Row
209:
224: -- Procedure Query_Row
225:
226: PROCEDURE Query_Row
227: ( p_price_adjustment_id IN NUMBER
228: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
229: );
230:
231: -- Procedure Query_Rows
232:
234: ( p_price_adjustment_id IN NUMBER :=
235: FND_API.G_MISS_NUM
236: , p_header_id IN NUMBER :=
237: FND_API.G_MISS_NUM
238: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
239: );
240:
241: -- Procedure lock_Row
242:
242:
243: PROCEDURE Lock_Row
244: ( x_return_status OUT NOCOPY VARCHAR2
245:
246: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
247: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
248: , p_price_adjustment_id IN NUMBER
249: := FND_API.G_MISS_NUM
250: );
243: PROCEDURE Lock_Row
244: ( x_return_status OUT NOCOPY VARCHAR2
245:
246: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
247: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
248: , p_price_adjustment_id IN NUMBER
249: := FND_API.G_MISS_NUM
250: );
251:
254: ( p_price_adjustment_id IN NUMBER
255: := FND_API.G_MISS_NUM
256: , p_header_id IN NUMBER
257: := FND_API.G_MISS_NUM
258: , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
259: , x_return_status OUT NOCOPY VARCHAR2
260:
261: );
262:
262:
263: -- Function Get_Values
264:
265: FUNCTION Get_Values
266: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
267: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
268: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
269: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type;
270:
263: -- Function Get_Values
264:
265: FUNCTION Get_Values
266: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
267: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
268: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
269: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type;
270:
271: -- Procedure Get_Ids
264:
265: FUNCTION Get_Values
266: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
267: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
268: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
269: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type;
270:
271: -- Procedure Get_Ids
272:
265: FUNCTION Get_Values
266: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
267: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
268: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
269: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type;
270:
271: -- Procedure Get_Ids
272:
273: PROCEDURE Get_Ids
270:
271: -- Procedure Get_Ids
272:
273: PROCEDURE Get_Ids
274: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
275: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
276: );
277:
278:
271: -- Procedure Get_Ids
272:
273: PROCEDURE Get_Ids
274: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
275: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
276: );
277:
278:
279: PROCEDURE Log_Adj_Requests
278:
279: PROCEDURE Log_Adj_Requests
280: ( x_return_status OUT NOCOPY VARCHAR2
281:
282: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
283: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
284: , p_delete_flag IN BOOLEAN DEFAULT FALSE
285: );
286:
279: PROCEDURE Log_Adj_Requests
280: ( x_return_status OUT NOCOPY VARCHAR2
281:
282: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
283: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
284: , p_delete_flag IN BOOLEAN DEFAULT FALSE
285: );
286:
287:
292: RETURN NUMBER;
293:
294: /* Start AuditTrail */
295: PROCEDURE Pre_Write_Process
296: ( p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
297: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) ;
298: /* End Audit Trail */
299:
300: /* Fix for 1559906: New Procedure to Copy Freight Charges */
293:
294: /* Start AuditTrail */
295: PROCEDURE Pre_Write_Process
296: ( p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
297: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) ;
298: /* End Audit Trail */
299:
300: /* Fix for 1559906: New Procedure to Copy Freight Charges */
301: