DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_ORDER_PUB

Line 204: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type

200:
201: -- Procedure API_Rec_To_Rowtype_Rec
202:
203: PROCEDURE API_Rec_To_Rowtype_Rec
204: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
205: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
206: );
207:
208: -- Procedure Rowtype_Rec_To_API_Rec

Line 212: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type

208: -- Procedure Rowtype_Rec_To_API_Rec
209:
210: PROCEDURE Rowtype_Rec_To_API_Rec
211: ( p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
212: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type
213: );
214:
215: -- Procedure Clear_Dependent_Attr: Overloaded for view%rowtype PARAMETERS
216:

Line 230: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

226: -- Procedure Clear_Dependent_Attr
227:
228: PROCEDURE Clear_Dependent_Attr
229: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
230: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
231: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
232: OE_Order_PUB.G_MISS_HEADER_REC
233: );
234:

Line 231: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

227:
228: PROCEDURE Clear_Dependent_Attr
229: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
230: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
231: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
232: OE_Order_PUB.G_MISS_HEADER_REC
233: );
234:
235: -- Procedure Apply_Attribute_Changes

Line 232: OE_Order_PUB.G_MISS_HEADER_REC

228: PROCEDURE Clear_Dependent_Attr
229: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
230: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
231: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
232: OE_Order_PUB.G_MISS_HEADER_REC
233: );
234:
235: -- Procedure Apply_Attribute_Changes
236:

Line 238: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

234:
235: -- Procedure Apply_Attribute_Changes
236:
237: PROCEDURE Apply_Attribute_Changes
238: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
239: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
240: OE_Order_PUB.G_MISS_HEADER_REC
241: );
242:

Line 239: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

235: -- Procedure Apply_Attribute_Changes
236:
237: PROCEDURE Apply_Attribute_Changes
238: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
239: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
240: OE_Order_PUB.G_MISS_HEADER_REC
241: );
242:
243: -- Function Complete_Record

Line 240: OE_Order_PUB.G_MISS_HEADER_REC

236:
237: PROCEDURE Apply_Attribute_Changes
238: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
239: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
240: OE_Order_PUB.G_MISS_HEADER_REC
241: );
242:
243: -- Function Complete_Record
244:

Line 246: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

242:
243: -- Function Complete_Record
244:
245: PROCEDURE Complete_Record
246: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
247: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
248: ) ;
249:
250: -- Function Convert_Miss_To_Null

Line 247: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type

243: -- Function Complete_Record
244:
245: PROCEDURE Complete_Record
246: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
247: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
248: ) ;
249:
250: -- Function Convert_Miss_To_Null
251:

Line 253: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

249:
250: -- Function Convert_Miss_To_Null
251:
252: PROCEDURE Convert_Miss_To_Null
253: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
254: ) ;
255:
256: -- Procedure Update_Row
257:

Line 259: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

255:
256: -- Procedure Update_Row
257:
258: PROCEDURE Update_Row
259: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
260: );
261:
262: -- Procedure Insert_Row
263:

Line 265: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

261:
262: -- Procedure Insert_Row
263:
264: PROCEDURE Insert_Row
265: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
266: );
267:
268: -- Procedure Delete_Row
269:

Line 282: ) RETURN OE_Order_PUB.Header_Rec_Type;

278: -- as it has the nocopy option which would improve the performance
279:
280: FUNCTION Query_Row
281: ( p_header_id IN NUMBER
282: ) RETURN OE_Order_PUB.Header_Rec_Type;
283:
284: -- Function Query_Row
285:
286: PROCEDURE Query_Row

Line 288: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

284: -- Function Query_Row
285:
286: PROCEDURE Query_Row
287: ( p_header_id IN NUMBER,
288: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
289: ) ;
290: --R12 CC Encryption
291: PROCEDURE Query_card_Details
292: ( p_header_id IN NUMBER,

Line 310: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

306: --
307:
308: PROCEDURE Lock_Row
309: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
310: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
311: , p_header_id IN NUMBER
312: := FND_API.G_MISS_NUM
313: );
314:

Line 324: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

320:
321: -- Function Get_Values
322:
323: FUNCTION Get_Values
324: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
325: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
326: OE_Order_PUB.G_MISS_HEADER_REC
327: ) RETURN OE_Order_PUB.Header_Val_Rec_Type;
328:

Line 325: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

321: -- Function Get_Values
322:
323: FUNCTION Get_Values
324: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
325: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
326: OE_Order_PUB.G_MISS_HEADER_REC
327: ) RETURN OE_Order_PUB.Header_Val_Rec_Type;
328:
329: -- Function Get_Ids

Line 326: OE_Order_PUB.G_MISS_HEADER_REC

322:
323: FUNCTION Get_Values
324: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
325: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
326: OE_Order_PUB.G_MISS_HEADER_REC
327: ) RETURN OE_Order_PUB.Header_Val_Rec_Type;
328:
329: -- Function Get_Ids
330:

Line 327: ) RETURN OE_Order_PUB.Header_Val_Rec_Type;

323: FUNCTION Get_Values
324: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
325: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
326: OE_Order_PUB.G_MISS_HEADER_REC
327: ) RETURN OE_Order_PUB.Header_Val_Rec_Type;
328:
329: -- Function Get_Ids
330:
331: PROCEDURE Get_Ids

Line 332: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

328:
329: -- Function Get_Ids
330:
331: PROCEDURE Get_Ids
332: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
333: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
334: ) ;
335:
336: FUNCTION Get_ord_seq_type

Line 333: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type

329: -- Function Get_Ids
330:
331: PROCEDURE Get_Ids
332: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
333: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
334: ) ;
335:
336: FUNCTION Get_ord_seq_type
337: ( p_order_type_id IN NUMBER

Line 362: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

358: ( p_order_type_id IN NUMBER)
359: RETURN VARCHAR2 ;
360:
361: PROCEDURE Get_Order_Number
362: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
363: p_old_header_rec IN oe_order_pub.header_rec_type );
364:
365: PROCEDURE Pre_Write_Process(
366: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

Line 363: p_old_header_rec IN oe_order_pub.header_rec_type );

359: RETURN VARCHAR2 ;
360:
361: PROCEDURE Get_Order_Number
362: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
363: p_old_header_rec IN oe_order_pub.header_rec_type );
364:
365: PROCEDURE Pre_Write_Process(
366: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
367: p_old_header_rec IN oe_order_pub.header_rec_type );

Line 366: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

362: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
363: p_old_header_rec IN oe_order_pub.header_rec_type );
364:
365: PROCEDURE Pre_Write_Process(
366: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
367: p_old_header_rec IN oe_order_pub.header_rec_type );
368:
369: PROCEDURE Post_Write_Process(
370: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

Line 367: p_old_header_rec IN oe_order_pub.header_rec_type );

363: p_old_header_rec IN oe_order_pub.header_rec_type );
364:
365: PROCEDURE Pre_Write_Process(
366: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
367: p_old_header_rec IN oe_order_pub.header_rec_type );
368:
369: PROCEDURE Post_Write_Process(
370: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
371: p_old_header_rec IN oe_order_pub.header_rec_type );

Line 370: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

366: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
367: p_old_header_rec IN oe_order_pub.header_rec_type );
368:
369: PROCEDURE Post_Write_Process(
370: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
371: p_old_header_rec IN oe_order_pub.header_rec_type );
372:
373: Procedure Validate_Gapless_Seq( p_application_id IN NUMBER,
374: p_entity_short_name in VARCHAR2,

Line 371: p_old_header_rec IN oe_order_pub.header_rec_type );

367: p_old_header_rec IN oe_order_pub.header_rec_type );
368:
369: PROCEDURE Post_Write_Process(
370: p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
371: p_old_header_rec IN oe_order_pub.header_rec_type );
372:
373: Procedure Validate_Gapless_Seq( p_application_id IN NUMBER,
374: p_entity_short_name in VARCHAR2,
375: p_validation_entity_short_name in VARCHAR2,

Line 406: ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,

402: );
403:
404: --ER7675548
405: Procedure Get_customer_info_ids
406: ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
407: p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2

Line 407: p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,

403:
404: --ER7675548
405: Procedure Get_customer_info_ids
406: ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
407: p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2
411: );