DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_UTIL dependencies on OE_ORDER_PUB

Line 141: ( p_HEADER_ADJ_rec IN OE_Order_PUB.HEADER_ADJ_Rec_Type

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

Line 147: , x_api_rec OUT nocopy OE_Order_PUB.HEADER_ADJ_Rec_Type

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

Line 164: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type

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: );

Line 165: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

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:

Line 166: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

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

Line 167: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

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);

Line 177: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type

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: );

Line 178: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

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:

Line 179: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

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

Line 180: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 186: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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

Line 187: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 193: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 199: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 205: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 228: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 238: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

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:

Line 246: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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: );

Line 247: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC

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:

Line 258: , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

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:

Line 266: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 267: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

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

Line 268: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

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:

Line 269: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type;

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

Line 274: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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:

Line 275: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type

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

Line 282: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type

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:

Line 283: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type

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:

Line 296: ( p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,

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 */

Line 297: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) ;

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: