eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_UTIL dependencies on OE_ORDER_PUB

Line 409: , p_line_rec IN OE_Order_PUB.Line_Rec_Type

405: -- Procedure Clear_Dependent_Attr
406:
407: PROCEDURE Clear_Dependent_Attr
408: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
409: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
410: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
411: OE_Order_PUB.G_MISS_LINE_REC
412: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
413: );

Line 410: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

406:
407: PROCEDURE Clear_Dependent_Attr
408: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
409: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
410: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
411: OE_Order_PUB.G_MISS_LINE_REC
412: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
413: );
414: */

Line 411: OE_Order_PUB.G_MISS_LINE_REC

407: PROCEDURE Clear_Dependent_Attr
408: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
409: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
410: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
411: OE_Order_PUB.G_MISS_LINE_REC
412: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
413: );
414: */
415:

Line 412: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type

408: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
409: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
410: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
411: OE_Order_PUB.G_MISS_LINE_REC
412: , x_line_rec OUT OE_Order_PUB.Line_Rec_Type
413: );
414: */
415:
416: -- Procedure Apply_Attribute_Changes

Line 419: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

415:
416: -- Procedure Apply_Attribute_Changes
417:
418: PROCEDURE Apply_Attribute_Changes
419: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
420: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
421: OE_Order_PUB.G_MISS_LINE_REC
422: );
423:

Line 420: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 421: OE_Order_PUB.G_MISS_LINE_REC

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

Line 427: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

Line 428: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

424: -- Procedure Complete_Record
425:
426: PROCEDURE Complete_Record
427: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
428: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
429: ) ;
430:
431: -- Procedure Convert_Miss_To_Null
432:

Line 434: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

430:
431: -- Procedure Convert_Miss_To_Null
432:
433: PROCEDURE Convert_Miss_To_Null
434: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
435: ) ;
436:
437: -- Procedure Update_Row
438:

Line 440: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

Line 446: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

442:
443: -- Procedure Insert_Row
444:
445: PROCEDURE Insert_Row
446: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
447: );
448:
449: -- Procedure Delete_Row
450:

Line 466: ) RETURN OE_Order_PUB.Line_Rec_Type;

462: -- as it has the nocopy option which would improve the performance
463:
464: FUNCTION Query_Row
465: ( p_line_id IN NUMBER
466: ) RETURN OE_Order_PUB.Line_Rec_Type;
467:
468: -- Procedure Query_Row
469:
470: PROCEDURE Query_Row

Line 472: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

468: -- Procedure Query_Row
469:
470: PROCEDURE Query_Row
471: ( p_line_id IN NUMBER
472: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
473: );
474:
475: -- Procedure Query_Rows
476:

Line 486: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

482: , p_header_id IN NUMBER :=
483: FND_API.G_MISS_NUM
484: , p_line_set_id IN NUMBER :=
485: FND_API.G_MISS_NUM
486: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
487: );
488:
489: -- Procedure lock_Row
490: PROCEDURE Lock_Row

Line 492: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

488:
489: -- Procedure lock_Row
490: PROCEDURE Lock_Row
491: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
492: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
493: , p_line_id IN NUMBER
494: := FND_API.G_MISS_NUM
495: );
496:

Line 502: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

498: ( p_line_id IN NUMBER :=
499: FND_API.G_MISS_NUM
500: , p_header_id IN NUMBER :=
501: FND_API.G_MISS_NUM
502: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
503: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
504: );
505:
506: -- Function Get_Values

Line 509: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

505:
506: -- Function Get_Values
507:
508: FUNCTION Get_Values
509: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
511: OE_Order_PUB.G_MISS_LINE_REC
512: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
513:

Line 510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

506: -- Function Get_Values
507:
508: FUNCTION Get_Values
509: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
511: OE_Order_PUB.G_MISS_LINE_REC
512: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
513:
514:

Line 511: OE_Order_PUB.G_MISS_LINE_REC

507:
508: FUNCTION Get_Values
509: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
511: OE_Order_PUB.G_MISS_LINE_REC
512: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
513:
514:
515: -- Procedure Get_Ids

Line 512: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;

508: FUNCTION Get_Values
509: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
511: OE_Order_PUB.G_MISS_LINE_REC
512: ) RETURN OE_Order_PUB.Line_Val_Rec_Type;
513:
514:
515: -- Procedure Get_Ids
516:

Line 518: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

514:
515: -- Procedure Get_Ids
516:
517: PROCEDURE Get_Ids
518: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
519: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
520: ) ;
521:
522: Procedure Query_Header

Line 519: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type

515: -- Procedure Get_Ids
516:
517: PROCEDURE Get_Ids
518: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
519: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
520: ) ;
521:
522: Procedure Query_Header
523: ( p_line_id IN NUMBER :=

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

564: p_order_quantity_uom IN VARCHAR2)
565: RETURN NUMBER;
566:
567:
568: FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)
569: RETURN BOOLEAN;
570:
571: PROCEDURE Pre_Write_Process
572: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 572: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

568: FUNCTION Is_Over_Return(p_line_rec IN OE_ORDER_PUB.line_rec_type)
569: RETURN BOOLEAN;
570:
571: PROCEDURE Pre_Write_Process
572: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
573: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
574: OE_Order_PUB.G_MISS_LINE_REC
575: );
576:

Line 573: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

569: RETURN BOOLEAN;
570:
571: PROCEDURE Pre_Write_Process
572: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
573: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
574: OE_Order_PUB.G_MISS_LINE_REC
575: );
576:
577: PROCEDURE Version_Audit_Process

Line 574: OE_Order_PUB.G_MISS_LINE_REC

570:
571: PROCEDURE Pre_Write_Process
572: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
573: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
574: OE_Order_PUB.G_MISS_LINE_REC
575: );
576:
577: PROCEDURE Version_Audit_Process
578: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 578: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

574: OE_Order_PUB.G_MISS_LINE_REC
575: );
576:
577: PROCEDURE Version_Audit_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: , p_process_step IN NUMBER := 3
582: );

Line 579: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

575: );
576:
577: PROCEDURE Version_Audit_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: , p_process_step IN NUMBER := 3
582: );
583:

Line 580: OE_Order_PUB.G_MISS_LINE_REC

576:
577: PROCEDURE Version_Audit_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: , p_process_step IN NUMBER := 3
582: );
583:
584: PROCEDURE Post_Write_Process

Line 585: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

581: , p_process_step IN NUMBER := 3
582: );
583:
584: PROCEDURE Post_Write_Process
585: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
586: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
587: OE_Order_PUB.G_MISS_LINE_REC
588: );
589:

Line 586: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

582: );
583:
584: PROCEDURE Post_Write_Process
585: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
586: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
587: OE_Order_PUB.G_MISS_LINE_REC
588: );
589:
590: PROCEDURE Post_Line_Process

Line 587: OE_Order_PUB.G_MISS_LINE_REC

583:
584: PROCEDURE Post_Write_Process
585: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
586: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
587: OE_Order_PUB.G_MISS_LINE_REC
588: );
589:
590: PROCEDURE Post_Line_Process
591: ( p_control_rec IN OE_Globals.Control_Rec_Type

Line 592: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

588: );
589:
590: PROCEDURE Post_Line_Process
591: ( p_control_rec IN OE_Globals.Control_Rec_Type
592: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
593: );
594:
595: Function Get_Return_Item_Type_Code
596: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 596: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

592: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
593: );
594:
595: Function Get_Return_Item_Type_Code
596: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
597: ) RETURN varchar2;
598:
599: -- OPM 02/JUN/00
600: -- =============

Line 620: p_line_rec OE_ORDER_PUB.Line_Rec_Type

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

Line 626: p_line_rec OE_ORDER_PUB.Line_Rec_Type,

622: RETURN VARCHAR2; */
623:
624: /* FUNCTION Get_Preferred_Grade -- INVCONV
625: (
626: p_line_rec OE_ORDER_PUB.Line_Rec_Type,
627: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type
628: )
629: RETURN VARCHAR2; */
630:

Line 627: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type

623:
624: /* FUNCTION Get_Preferred_Grade -- INVCONV
625: (
626: p_line_rec OE_ORDER_PUB.Line_Rec_Type,
627: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type
628: )
629: RETURN VARCHAR2; */
630:
631: PROCEDURE Sync_Dual_Qty

Line 633: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

629: RETURN VARCHAR2; */
630:
631: PROCEDURE Sync_Dual_Qty
632: (
633: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
634: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
635: );
636:
637: /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed

Line 634: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type

630:
631: PROCEDURE Sync_Dual_Qty
632: (
633: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
634: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
635: );
636:
637: /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed
638: (

Line 639: P_LINE_REC OE_ORDER_PUB.Line_Rec_Type

635: );
636:
637: /* FUNCTION Calculate_Ordered_Quantity2 INVCONV removed
638: (
639: P_LINE_REC OE_ORDER_PUB.Line_Rec_Type
640: )
641: RETURN NUMBER; */
642: -- OPM 02/JUN/00 END
643: -- =================

Line 663: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

659: ,p_lot_number IN VARCHAR2 DEFAULT NULL -- INVCONV orig for 2380194 added for RMA quantity2 OM pack J project
660: ) ;
661:
662: Procedure Pre_Attribute_Security
663: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
664: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
665: , p_index IN NUMBER);
666:
667: PROCEDURE Log_Scheduling_Requests

Line 664: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

660: ) ;
661:
662: Procedure Pre_Attribute_Security
663: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
664: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
665: , p_index IN NUMBER);
666:
667: PROCEDURE Log_Scheduling_Requests
668: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 668: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

664: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
665: , p_index IN NUMBER);
666:
667: PROCEDURE Log_Scheduling_Requests
668: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
669: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
670: ,p_caller IN VARCHAR2
671: ,p_order_type_id IN NUMBER
672: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 669: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

665: , p_index IN NUMBER);
666:
667: PROCEDURE Log_Scheduling_Requests
668: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
669: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
670: ,p_caller IN VARCHAR2
671: ,p_order_type_id IN NUMBER
672: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
673:

Line 679: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,

675:
676:
677:
678: PROCEDURE update_adjustment_flags
679: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
680: p_x_line_rec IN OE_Order_PUB.line_rec_type);
681:
682:
683: PROCEDURE GET_ITEM_INFO

Line 680: p_x_line_rec IN OE_Order_PUB.line_rec_type);

676:
677:
678: PROCEDURE update_adjustment_flags
679: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
680: p_x_line_rec IN OE_Order_PUB.line_rec_type);
681:
682:
683: PROCEDURE GET_ITEM_INFO
684: ( x_return_status OUT NOCOPY VARCHAR2

Line 700: ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,

696: );
697:
698: --ER7675548
699: Procedure Get_customer_info_ids
700: ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
701: p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
702: x_return_status OUT NOCOPY VARCHAR2,
703: x_msg_count OUT NOCOPY NUMBER,
704: x_msg_data OUT NOCOPY VARCHAR2

Line 701: p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,

697:
698: --ER7675548
699: Procedure Get_customer_info_ids
700: ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
701: p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
702: x_return_status OUT NOCOPY VARCHAR2,
703: x_msg_count OUT NOCOPY NUMBER,
704: x_msg_data OUT NOCOPY VARCHAR2
705: );

Line 727: p_Line_rec OE_Order_PUB.Line_Rec_Type

723:
724: --16206165 CW Start
725: FUNCTION IS_CATCH_WEIGHT
726: (
727: p_Line_rec OE_Order_PUB.Line_Rec_Type
728: )
729: RETURN VARCHAR2;
730: --16206165 CW End
731: