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 529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

525: PROCEDURE Process_Acknowledgment
526: (p_api_version_number IN NUMBER
527: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
528:
529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 530: OE_Order_Pub.G_MISS_HEADER_REC

526: (p_api_version_number IN NUMBER
527: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
528:
529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

527: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
528:
529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 532: OE_Order_Pub.G_MISS_HEADER_VAL_REC

528:
529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

532: OE_Order_Pub.G_MISS_HEADER_VAL_REC
533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

533: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

534: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL

Line 539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

535: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

536: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

537: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 542: OE_Order_Pub.G_MISS_LINE_TBL

538: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

539: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 544: OE_Order_Pub.G_MISS_LINE_VAL_TBL

540: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

541: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

542: OE_Order_Pub.G_MISS_LINE_TBL
543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

543: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

544: OE_Order_Pub.G_MISS_LINE_VAL_TBL
545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

545: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

546: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

547: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

548: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

549: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

Line 554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

550: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL

Line 555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

551: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:

Line 556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

552: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

553: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC

Line 558: OE_Order_Pub.G_MISS_REQUEST_TBL

554: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
555: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

Line 560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

556: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 561: OE_Order_Pub.G_MISS_HEADER_REC

557: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

558: OE_Order_Pub.G_MISS_REQUEST_TBL
559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 563: OE_Order_Pub.G_MISS_HEADER_VAL_REC

559:
560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

560: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

561: OE_Order_Pub.G_MISS_HEADER_REC
562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

562: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

563: OE_Order_Pub.G_MISS_HEADER_VAL_REC
564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

564: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

565: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL

Line 570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

566: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

567: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

568: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 573: OE_Order_Pub.G_MISS_LINE_TBL

569: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

570: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 575: OE_Order_Pub.G_MISS_LINE_VAL_TBL

571: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

572: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

573: OE_Order_Pub.G_MISS_LINE_TBL
574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

574: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

575: OE_Order_Pub.G_MISS_LINE_VAL_TBL
576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

576: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

577: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

578: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

579: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
587: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

580: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
587: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
588:

Line 585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

581: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
587: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
588:
589: ,p_buyer_seller_flag IN VARCHAR2

Line 586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

582: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
587: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
588:
589: ,p_buyer_seller_flag IN VARCHAR2
590: ,p_reject_order IN VARCHAR2

Line 587: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

583: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
584: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
585: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
586: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
587: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
588:
589: ,p_buyer_seller_flag IN VARCHAR2
590: ,p_reject_order IN VARCHAR2
591:

Line 706: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

702: -- aksingh 3A4 Start
703:
704: -- {Start of function to get the index for the tbl for give line_id
705: FUNCTION Get_Line_Index
706: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
707: p_line_id IN Number
708: )
709: RETURN NUMBER
710: IS

Line 746: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type,

742: END Get_Line_Index;
743:
744: -- {Start of procedure Insert_Header
745: PROCEDURE Insert_Header
746: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type,
747: p_header_status IN Varchar2,
748: p_ack_type IN Varchar2,
749: p_itemkey IN Number,
750: x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2

Line 804: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type,

800: -- End of procedure Insert_Header }
801:
802: -- {Start of procedure Insert_Line
803: PROCEDURE Insert_Line
804: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type,
805: p_line_status IN Varchar2,
806: p_ack_type IN Varchar2,
807: p_itemkey IN Number,
808: x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2

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

857: p_change_sequence IN Varchar2,
858: p_msg_id IN Number := NULL,
859: p_request_id IN Number := NuLL,
860: p_xml_transaction_type_code IN Varchar2,
861: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
862: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
863: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS

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

858: p_msg_id IN Number := NULL,
859: p_request_id IN Number := NuLL,
860: p_xml_transaction_type_code IN Varchar2,
861: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
862: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
863: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;

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

859: p_request_id IN Number := NuLL,
860: p_xml_transaction_type_code IN Varchar2,
861: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
862: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
863: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;
867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

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

860: p_xml_transaction_type_code IN Varchar2,
861: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
862: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
863: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;
867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
868: l_line_rec OE_Order_Pub.Line_Rec_Type;

Line 866: l_header_rec OE_Order_Pub.Header_Rec_Type;

862: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
863: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;
867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
868: l_line_rec OE_Order_Pub.Line_Rec_Type;
869: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
870: l_line_count Number := 0;

Line 867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

863: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;
867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
868: l_line_rec OE_Order_Pub.Line_Rec_Type;
869: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
870: l_line_count Number := 0;
871: l_order_source_id Number;

Line 868: l_line_rec OE_Order_Pub.Line_Rec_Type;

864: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type)
865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;
867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
868: l_line_rec OE_Order_Pub.Line_Rec_Type;
869: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
870: l_line_count Number := 0;
871: l_order_source_id Number;
872: l_orig_sys_document_ref Varchar2(50);

Line 869: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

865: IS
866: l_header_rec OE_Order_Pub.Header_Rec_Type;
867: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
868: l_line_rec OE_Order_Pub.Line_Rec_Type;
869: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
870: l_line_count Number := 0;
871: l_order_source_id Number;
872: l_orig_sys_document_ref Varchar2(50);
873: l_change_sequence Varchar2(50);

Line 1096: l_header_rec OE_Order_Pub.Header_Rec_Type;

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

Line 1097: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

1093:
1094: -- (v) Code to check if the acknowledgment is setup for the TP
1095:
1096: l_header_rec OE_Order_Pub.Header_Rec_Type;
1097: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1098: l_line_rec OE_Order_Pub.Line_Rec_Type;
1099: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1100: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;

Line 1098: l_line_rec OE_Order_Pub.Line_Rec_Type;

1094: -- (v) Code to check if the acknowledgment is setup for the TP
1095:
1096: l_header_rec OE_Order_Pub.Header_Rec_Type;
1097: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1098: l_line_rec OE_Order_Pub.Line_Rec_Type;
1099: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1100: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1102: l_header_id Number;

Line 1099: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

1095:
1096: l_header_rec OE_Order_Pub.Header_Rec_Type;
1097: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1098: l_line_rec OE_Order_Pub.Line_Rec_Type;
1099: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1100: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1102: l_header_id Number;
1103: l_header_last_ack_code Varchar2(30);

Line 1100: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;

1096: l_header_rec OE_Order_Pub.Header_Rec_Type;
1097: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1098: l_line_rec OE_Order_Pub.Line_Rec_Type;
1099: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1100: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1102: l_header_id Number;
1103: l_header_last_ack_code Varchar2(30);
1104: l_reject_order Varchar2(1) := 'Y';

Line 1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;

1097: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
1098: l_line_rec OE_Order_Pub.Line_Rec_Type;
1099: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1100: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1102: l_header_id Number;
1103: l_header_last_ack_code Varchar2(30);
1104: l_reject_order Varchar2(1) := 'Y';
1105: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;

Line 1726: p_header_rec IN OE_Order_Pub.Header_Rec_Type,

1722: -- 4. ....
1723: PROCEDURE Process_SSO
1724: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1726: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1727: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1728: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1729: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1730: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1727: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

1723: PROCEDURE Process_SSO
1724: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1726: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1727: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1728: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1729: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1730: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1731: )

Line 1728: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,

1724: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1726: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1727: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1728: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1729: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1730: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1731: )
1732: IS

Line 1729: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

1725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1726: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1727: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1728: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1729: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1730: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1731: )
1732: IS
1733: l_is_delivery_required varchar2(1);

Line 1761: l_line_rec OE_Order_Pub.Line_Rec_Type;

1757:
1758: l_header_status varchar2(30);
1759: l_header_status_cso varchar2(30);
1760: l_line_status varchar2(30);
1761: l_line_rec OE_Order_Pub.Line_Rec_Type;
1762: i pls_integer;
1763: j pls_integer;
1764: l_return_status varchar2(1);
1765: l_itemkey_sso number;

Line 1767: l_header_rec OE_Order_Pub.Header_Rec_Type;

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

Line 1768: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

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

Line 3721: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3717: /*----------------------------------------------------------------------
3718: Processes 3A8 transaction received. This will be called during process order call
3719: ----------------------------------------------------------------------*/
3720: Procedure Process_3A8
3721: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3722: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
3723: , x_return_status OUT NOCOPY VARCHAR2
3724: )
3725: IS

Line 3722: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

3718: Processes 3A8 transaction received. This will be called during process order call
3719: ----------------------------------------------------------------------*/
3720: Procedure Process_3A8
3721: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3722: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
3723: , x_return_status OUT NOCOPY VARCHAR2
3724: )
3725: IS
3726: l_msg_count NUMBER := 0;