DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on OE_ORDER_PUB

Line 402: , p_line_rec IN OE_Order_PUB.Line_Rec_Type

398: -- Procedure Clear_Dependent_Attr
399:
400: PROCEDURE Clear_Dependent_Attr
401: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
402: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
403: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
404: OE_Order_PUB.G_MISS_LINE_REC
405: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
406: );

Line 403: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

399:
400: PROCEDURE Clear_Dependent_Attr
401: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
402: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
403: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
404: OE_Order_PUB.G_MISS_LINE_REC
405: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
406: );
407: */

Line 404: OE_Order_PUB.G_MISS_LINE_REC

400: PROCEDURE Clear_Dependent_Attr
401: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
402: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
403: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
404: OE_Order_PUB.G_MISS_LINE_REC
405: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
406: );
407: */
408:

Line 405: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type

401: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
402: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
403: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
404: OE_Order_PUB.G_MISS_LINE_REC
405: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
406: );
407: */
408:
409: -- Procedure Apply_Attribute_Changes

Line 412: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

408:
409: -- Procedure Apply_Attribute_Changes
410:
411: PROCEDURE Apply_Attribute_Changes
412: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
413: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
414: OE_Order_PUB.G_MISS_LINE_REC
415: );
416:

Line 413: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

409: -- Procedure Apply_Attribute_Changes
410:
411: PROCEDURE Apply_Attribute_Changes
412: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
413: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
414: OE_Order_PUB.G_MISS_LINE_REC
415: );
416:
417: -- Procedure Complete_Record

Line 414: OE_Order_PUB.G_MISS_LINE_REC

410:
411: PROCEDURE Apply_Attribute_Changes
412: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
413: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
414: OE_Order_PUB.G_MISS_LINE_REC
415: );
416:
417: -- Procedure Complete_Record
418:

Line 420: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

416:
417: -- Procedure Complete_Record
418:
419: PROCEDURE Complete_Record
420: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
421: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
422: ) ;
423:
424: -- Procedure Convert_Miss_To_Null

Line 421: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

417: -- Procedure Complete_Record
418:
419: PROCEDURE Complete_Record
420: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
421: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
422: ) ;
423:
424: -- Procedure Convert_Miss_To_Null
425:

Line 427: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

423:
424: -- Procedure Convert_Miss_To_Null
425:
426: PROCEDURE Convert_Miss_To_Null
427: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
428: ) ;
429:
430: -- Procedure Update_Row
431:

Line 433: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

429:
430: -- Procedure Update_Row
431:
432: PROCEDURE Update_Row
433: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
434: );
435:
436: -- Procedure Insert_Row
437:

Line 439: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

435:
436: -- Procedure Insert_Row
437:
438: PROCEDURE Insert_Row
439: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
440: );
441:
442: -- Procedure Delete_Row
443:

Line 459: ) RETURN OE_Order_PUB.Line_Rec_Type;

455: -- as it has the nocopy option which would improve the performance
456:
457: FUNCTION Query_Row
458: ( p_line_id IN NUMBER
459: ) RETURN OE_Order_PUB.Line_Rec_Type;
460:
461: -- Procedure Query_Row
462:
463: PROCEDURE Query_Row

Line 465: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

461: -- Procedure Query_Row
462:
463: PROCEDURE Query_Row
464: ( p_line_id IN NUMBER
465: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
466: );
467:
468: -- Procedure Query_Rows
469:

Line 479: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

475: , p_header_id IN NUMBER :=
476: FND_API.G_MISS_NUM
477: , p_line_set_id IN NUMBER :=
478: FND_API.G_MISS_NUM
479: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
480: );
481:
482: -- Procedure lock_Row
483: PROCEDURE Lock_Row

Line 485: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

481:
482: -- Procedure lock_Row
483: PROCEDURE Lock_Row
484: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
485: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
486: , p_line_id IN NUMBER
487: := FND_API.G_MISS_NUM
488: );
489:

Line 495: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

491: ( p_line_id IN NUMBER :=
492: FND_API.G_MISS_NUM
493: , p_header_id IN NUMBER :=
494: FND_API.G_MISS_NUM
495: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
496: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
497: );
498:
499: -- Function Get_Values

Line 502: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

498:
499: -- Function Get_Values
500:
501: FUNCTION Get_Values
502: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
503: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
504: OE_Order_PUB.G_MISS_LINE_REC
505: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
506:

Line 503: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

499: -- Function Get_Values
500:
501: FUNCTION Get_Values
502: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
503: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
504: OE_Order_PUB.G_MISS_LINE_REC
505: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
506:
507:

Line 504: OE_Order_PUB.G_MISS_LINE_REC

500:
501: FUNCTION Get_Values
502: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
503: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
504: OE_Order_PUB.G_MISS_LINE_REC
505: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
506:
507:
508: -- Procedure Get_Ids

Line 505: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;

501: FUNCTION Get_Values
502: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
503: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
504: OE_Order_PUB.G_MISS_LINE_REC
505: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
506:
507:
508: -- Procedure Get_Ids
509:

Line 511: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

507:
508: -- Procedure Get_Ids
509:
510: PROCEDURE Get_Ids
511: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
512: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
513: ) ;
514:
515: Procedure Query_Header

Line 512: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type

508: -- Procedure Get_Ids
509:
510: PROCEDURE Get_Ids
511: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
512: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
513: ) ;
514:
515: Procedure Query_Header
516: ( p_line_id IN NUMBER :=

Line 561: FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)

557: p_order_quantity_uom IN VARCHAR2)
558: RETURN NUMBER;
559:
560:
561: FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)
562: RETURN BOOLEAN;
563:
564: PROCEDURE Pre_Write_Process
565: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 565: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

561: FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)
562: RETURN BOOLEAN;
563:
564: PROCEDURE Pre_Write_Process
565: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
566: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
567: OE_Order_PUB.G_MISS_LINE_REC
568: );
569:

Line 566: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

562: RETURN BOOLEAN;
563:
564: PROCEDURE Pre_Write_Process
565: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
566: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
567: OE_Order_PUB.G_MISS_LINE_REC
568: );
569:
570: PROCEDURE Version_Audit_Process

Line 567: OE_Order_PUB.G_MISS_LINE_REC

563:
564: PROCEDURE Pre_Write_Process
565: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
566: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
567: OE_Order_PUB.G_MISS_LINE_REC
568: );
569:
570: PROCEDURE Version_Audit_Process
571: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 571: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

567: OE_Order_PUB.G_MISS_LINE_REC
568: );
569:
570: PROCEDURE Version_Audit_Process
571: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
572: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
573: OE_Order_PUB.G_MISS_LINE_REC
574: , p_process_step IN NUMBER := 3
575: );

Line 572: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

568: );
569:
570: PROCEDURE Version_Audit_Process
571: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
572: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
573: OE_Order_PUB.G_MISS_LINE_REC
574: , p_process_step IN NUMBER := 3
575: );
576:

Line 573: OE_Order_PUB.G_MISS_LINE_REC

569:
570: PROCEDURE Version_Audit_Process
571: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
572: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
573: OE_Order_PUB.G_MISS_LINE_REC
574: , p_process_step IN NUMBER := 3
575: );
576:
577: PROCEDURE Post_Write_Process

Line 578: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

574: , p_process_step IN NUMBER := 3
575: );
576:
577: PROCEDURE Post_Write_Process
578: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
579: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
580: OE_Order_PUB.G_MISS_LINE_REC
581: );
582:

Line 579: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

575: );
576:
577: PROCEDURE Post_Write_Process
578: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
579: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
580: OE_Order_PUB.G_MISS_LINE_REC
581: );
582:
583: PROCEDURE Post_Line_Process

Line 580: OE_Order_PUB.G_MISS_LINE_REC

576:
577: PROCEDURE Post_Write_Process
578: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
579: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
580: OE_Order_PUB.G_MISS_LINE_REC
581: );
582:
583: PROCEDURE Post_Line_Process
584: ( p_control_rec IN OE_Globals.Control_Rec_Type

Line 585: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

581: );
582:
583: PROCEDURE Post_Line_Process
584: ( p_control_rec IN OE_Globals.Control_Rec_Type
585: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
586: );
587:
588: Function Get_Return_Item_Type_Code
589: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 589: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

585: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
586: );
587:
588: Function Get_Return_Item_Type_Code
589: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
590: ) RETURN varchar2;
591:
592: -- OPM 02/JUN/00
593: -- =============

Line 613: p_line_rec OE_ORDER_PUB.Line_Rec_Type

609:
610:
611: /* FUNCTION Get_Dual_Uom -- INVCONV
612: (
613: p_line_rec OE_ORDER_PUB.Line_Rec_Type
614: )
615: RETURN VARCHAR2; */
616:
617: /* FUNCTION Get_Preferred_Grade -- INVCONV

Line 619: p_line_rec OE_ORDER_PUB.Line_Rec_Type,

615: RETURN VARCHAR2; */
616:
617: /* FUNCTION Get_Preferred_Grade -- INVCONV
618: (
619: p_line_rec OE_ORDER_PUB.Line_Rec_Type,
620: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type
621: )
622: RETURN VARCHAR2; */
623:

Line 620: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type

616:
617: /* FUNCTION Get_Preferred_Grade -- INVCONV
618: (
619: p_line_rec OE_ORDER_PUB.Line_Rec_Type,
620: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type
621: )
622: RETURN VARCHAR2; */
623:
624: PROCEDURE Sync_Dual_Qty

Line 626: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

622: RETURN VARCHAR2; */
623:
624: PROCEDURE Sync_Dual_Qty
625: (
626: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
627: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
628: );
629:
630: /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed

Line 627: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type

623:
624: PROCEDURE Sync_Dual_Qty
625: (
626: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
627: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
628: );
629:
630: /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed
631: (

Line 632: P_LINE_REC OE_ORDER_PUB.Line_Rec_Type

628: );
629:
630: /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed
631: (
632: P_LINE_REC OE_ORDER_PUB.Line_Rec_Type
633: )
634: RETURN NUMBER; */
635: -- OPM 02/JUN/00 END
636: -- =================

Line 656: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

652: ,p_lot_number IN VARCHAR2 DEFAULT NULL -- INVCONV orig for 2380194 added for RMA quantity2 OM pack J project
653: ) ;
654:
655: Procedure Pre_Attribute_Security
656: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
657: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
658: , p_index IN NUMBER);
659:
660: PROCEDURE Log_Scheduling_Requests

Line 657: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

653: ) ;
654:
655: Procedure Pre_Attribute_Security
656: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
657: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
658: , p_index IN NUMBER);
659:
660: PROCEDURE Log_Scheduling_Requests
661: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 661: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

657: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
658: , p_index IN NUMBER);
659:
660: PROCEDURE Log_Scheduling_Requests
661: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
662: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
663: ,p_caller IN VARCHAR2
664: ,p_order_type_id IN NUMBER
665: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 662: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

658: , p_index IN NUMBER);
659:
660: PROCEDURE Log_Scheduling_Requests
661: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
662: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
663: ,p_caller IN VARCHAR2
664: ,p_order_type_id IN NUMBER
665: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
666:

Line 672: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,

668:
669:
670:
671: PROCEDURE update_adjustment_flags
672: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
673: p_x_line_rec IN OE_Order_PUB.line_rec_type);
674:
675:
676: PROCEDURE GET_ITEM_INFO

Line 673: p_x_line_rec IN OE_Order_PUB.line_rec_type);

669:
670:
671: PROCEDURE update_adjustment_flags
672: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
673: p_x_line_rec IN OE_Order_PUB.line_rec_type);
674:
675:
676: PROCEDURE GET_ITEM_INFO
677: ( x_return_status OUT NOCOPY VARCHAR2