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_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_PUB

Line 534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

530: PROCEDURE Process_Acknowledgment
531: (p_api_version_number IN NUMBER
532: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
533:
534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 535: OE_Order_Pub.G_MISS_HEADER_REC

531: (p_api_version_number IN NUMBER
532: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
533:
534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

532: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
533:
534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 537: OE_Order_Pub.G_MISS_HEADER_VAL_REC

533:
534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

537: OE_Order_Pub.G_MISS_HEADER_VAL_REC
538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

538: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

539: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL

Line 544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

540: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

541: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

542: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 547: OE_Order_Pub.G_MISS_LINE_TBL

543: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

544: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 549: OE_Order_Pub.G_MISS_LINE_VAL_TBL

545: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

546: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

547: OE_Order_Pub.G_MISS_LINE_TBL
548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

548: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

549: OE_Order_Pub.G_MISS_LINE_VAL_TBL
550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

550: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

551: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

552: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

553: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

554: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

Line 559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

555: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL

Line 560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

556: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:

Line 561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

557: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

558: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC

Line 563: OE_Order_Pub.G_MISS_REQUEST_TBL

559: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
560: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

Line 565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

561: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 566: OE_Order_Pub.G_MISS_HEADER_REC

562: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

563: OE_Order_Pub.G_MISS_REQUEST_TBL
564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 568: OE_Order_Pub.G_MISS_HEADER_VAL_REC

564:
565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

565: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

566: OE_Order_Pub.G_MISS_HEADER_REC
567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

567: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

568: OE_Order_Pub.G_MISS_HEADER_VAL_REC
569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

569: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

570: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL

Line 575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

571: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

572: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

573: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 578: OE_Order_Pub.G_MISS_LINE_TBL

574: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

575: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 580: OE_Order_Pub.G_MISS_LINE_VAL_TBL

576: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

577: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

578: OE_Order_Pub.G_MISS_LINE_TBL
579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

579: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

580: OE_Order_Pub.G_MISS_LINE_VAL_TBL
581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

581: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

582: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

583: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

584: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
592: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

585: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
592: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
593:

Line 590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

586: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
592: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
593:
594: ,p_buyer_seller_flag IN VARCHAR2

Line 591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

587: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
592: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
593:
594: ,p_buyer_seller_flag IN VARCHAR2
595: ,p_reject_order IN VARCHAR2

Line 592: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

588: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
589: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
590: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
591: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
592: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
593:
594: ,p_buyer_seller_flag IN VARCHAR2
595: ,p_reject_order IN VARCHAR2
596:

Line 711: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

707: -- aksingh 3A4 Start
708:
709: -- {Start of function to get the index for the tbl for give line_id
710: FUNCTION Get_Line_Index
711: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
712: p_line_id IN Number
713: )
714: RETURN NUMBER
715: IS

Line 751: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type,

747: END Get_Line_Index;
748:
749: -- {Start of procedure Insert_Header
750: PROCEDURE Insert_Header
751: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type,
752: p_header_status IN Varchar2,
753: p_ack_type IN Varchar2,
754: p_itemkey IN Number,
755: x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2

Line 809: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type,

805: -- End of procedure Insert_Header }
806:
807: -- {Start of procedure Insert_Line
808: PROCEDURE Insert_Line
809: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type,
810: p_line_status IN Varchar2,
811: p_ack_type IN Varchar2,
812: p_itemkey IN Number,
813: x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2

Line 866: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,

862: p_change_sequence IN Varchar2,
863: p_msg_id IN Number := NULL,
864: p_request_id IN Number := NuLL,
865: p_xml_transaction_type_code IN Varchar2,
866: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
867: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS

Line 867: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,

863: p_msg_id IN Number := NULL,
864: p_request_id IN Number := NuLL,
865: p_xml_transaction_type_code IN Varchar2,
866: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
867: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;

Line 868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,

864: p_request_id IN Number := NuLL,
865: p_xml_transaction_type_code IN Varchar2,
866: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
867: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;
872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

Line 869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)

865: p_xml_transaction_type_code IN Varchar2,
866: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
867: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;
872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
873: l_line_rec OE_Order_Pub.Line_Rec_Type;

Line 871: l_header_rec OE_Order_Pub.Header_Rec_Type;

867: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;
872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
873: l_line_rec OE_Order_Pub.Line_Rec_Type;
874: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
875: l_line_count Number := 0;

Line 872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

868: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;
872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
873: l_line_rec OE_Order_Pub.Line_Rec_Type;
874: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
875: l_line_count Number := 0;
876: l_order_source_id Number;

Line 873: l_line_rec OE_Order_Pub.Line_Rec_Type;

869: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;
872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
873: l_line_rec OE_Order_Pub.Line_Rec_Type;
874: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
875: l_line_count Number := 0;
876: l_order_source_id Number;
877: l_orig_sys_document_ref Varchar2(50);

Line 874: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

870: IS
871: l_header_rec OE_Order_Pub.Header_Rec_Type;
872: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
873: l_line_rec OE_Order_Pub.Line_Rec_Type;
874: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
875: l_line_count Number := 0;
876: l_order_source_id Number;
877: l_orig_sys_document_ref Varchar2(50);
878: l_change_sequence Varchar2(50);

Line 1101: l_header_rec OE_Order_Pub.Header_Rec_Type;

1097: -- (iv) Make sure raise event is raised only for the Xml order source
1098:
1099: -- (v) Code to check if the acknowledgment is setup for the TP
1100:
1101: l_header_rec OE_Order_Pub.Header_Rec_Type;
1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1103: l_line_rec OE_Order_Pub.Line_Rec_Type;
1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;

Line 1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

1098:
1099: -- (v) Code to check if the acknowledgment is setup for the TP
1100:
1101: l_header_rec OE_Order_Pub.Header_Rec_Type;
1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1103: l_line_rec OE_Order_Pub.Line_Rec_Type;
1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;

Line 1103: l_line_rec OE_Order_Pub.Line_Rec_Type;

1099: -- (v) Code to check if the acknowledgment is setup for the TP
1100:
1101: l_header_rec OE_Order_Pub.Header_Rec_Type;
1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1103: l_line_rec OE_Order_Pub.Line_Rec_Type;
1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1107: l_header_id Number;

Line 1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

1100:
1101: l_header_rec OE_Order_Pub.Header_Rec_Type;
1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1103: l_line_rec OE_Order_Pub.Line_Rec_Type;
1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1107: l_header_id Number;
1108: l_header_last_ack_code Varchar2(30);

Line 1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;

1101: l_header_rec OE_Order_Pub.Header_Rec_Type;
1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1103: l_line_rec OE_Order_Pub.Line_Rec_Type;
1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1107: l_header_id Number;
1108: l_header_last_ack_code Varchar2(30);
1109: l_reject_order Varchar2(1) := 'Y';

Line 1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;

1102: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1103: l_line_rec OE_Order_Pub.Line_Rec_Type;
1104: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1105: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1107: l_header_id Number;
1108: l_header_last_ack_code Varchar2(30);
1109: l_reject_order Varchar2(1) := 'Y';
1110: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;

Line 1731: p_header_rec IN OE_Order_Pub.Header_Rec_Type,

1727: -- 4. ....
1728: PROCEDURE Process_SSO
1729: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1731: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1732: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1733: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1734: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1735: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1732: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

1728: PROCEDURE Process_SSO
1729: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1731: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1732: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1733: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1734: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1735: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1736: )

Line 1733: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,

1729: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1731: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1732: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1733: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1734: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1735: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1736: )
1737: IS

Line 1734: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1731: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1732: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1733: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1734: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1735: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1736: )
1737: IS
1738: l_is_delivery_required varchar2(1);

Line 1766: l_line_rec OE_Order_Pub.Line_Rec_Type;

1762:
1763: l_header_status varchar2(30);
1764: l_header_status_cso varchar2(30);
1765: l_line_status varchar2(30);
1766: l_line_rec OE_Order_Pub.Line_Rec_Type;
1767: i pls_integer;
1768: j pls_integer;
1769: l_return_status varchar2(1);
1770: l_itemkey_sso number;

Line 1772: l_header_rec OE_Order_Pub.Header_Rec_Type;

1768: j pls_integer;
1769: l_return_status varchar2(1);
1770: l_itemkey_sso number;
1771: l_itemkey_cso number;
1772: l_header_rec OE_Order_Pub.Header_Rec_Type;
1773: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1774: l_is_delivery_required_cso varchar2(1) := 'N'; -- initialized so that if the code release level
1775: -- is below 110510, then the code behaves
1776: -- exactly the same as when 3A7 transaction is not set up at all

Line 1773: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

1769: l_return_status varchar2(1);
1770: l_itemkey_sso number;
1771: l_itemkey_cso number;
1772: l_header_rec OE_Order_Pub.Header_Rec_Type;
1773: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1774: l_is_delivery_required_cso varchar2(1) := 'N'; -- initialized so that if the code release level
1775: -- is below 110510, then the code behaves
1776: -- exactly the same as when 3A7 transaction is not set up at all
1777: l_change_usp_cso varchar2(1); -- variables to detect when 3a7 is to be generated

Line 3837: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3833: /*----------------------------------------------------------------------
3834: Processes 3A8 transaction received. This will be called during process order call
3835: ----------------------------------------------------------------------*/
3836: Procedure Process_3A8
3837: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3838: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
3839: , x_return_status OUT NOCOPY VARCHAR2
3840: )
3841: IS

Line 3838: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

3834: Processes 3A8 transaction received. This will be called during process order call
3835: ----------------------------------------------------------------------*/
3836: Procedure Process_3A8
3837: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3838: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
3839: , x_return_status OUT NOCOPY VARCHAR2
3840: )
3841: IS
3842: l_msg_count NUMBER := 0;