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: );
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: */
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:
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
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:
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
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:
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
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:
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:
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:
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:
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
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:
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
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:
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
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:
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:
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
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:
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
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 :=
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
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:
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
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
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: );
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:
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
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:
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
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
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
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: -- =============
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
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:
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
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
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: (
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: -- =================
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
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
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);
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:
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
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