55:
56: Function Validate_config (p_header_id IN NUMBER)
57: RETURN boolean IS
58:
59: p_deleted_options_tbl OE_Order_PUB.request_tbl_type;
60: p_updated_options_tbl OE_Order_PUB.request_tbl_type;
61: l_return_status VARCHAR2(1);
62: l_valid_config VARCHAR2(10);
63: l_complete_config VARCHAR2(10);
56: Function Validate_config (p_header_id IN NUMBER)
57: RETURN boolean IS
58:
59: p_deleted_options_tbl OE_Order_PUB.request_tbl_type;
60: p_updated_options_tbl OE_Order_PUB.request_tbl_type;
61: l_return_status VARCHAR2(1);
62: l_valid_config VARCHAR2(10);
63: l_complete_config VARCHAR2(10);
64: l_top_model_line_id NUMBER;
864: x_msg_count NUMBER;
865: x_msg_data VARCHAR2(2000);
866:
867: l_init_msg_list VARCHAR2(30) ;
868: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
869: l_line_adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
870: x_action_request_tbl Oe_Order_Pub.Request_Tbl_Type;
871: l_api_version_number NUMBER := 1.0 ;
872: x_msg_details VARCHAR2(3000) ;
865: x_msg_data VARCHAR2(2000);
866:
867: l_init_msg_list VARCHAR2(30) ;
868: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
869: l_line_adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
870: x_action_request_tbl Oe_Order_Pub.Request_Tbl_Type;
871: l_api_version_number NUMBER := 1.0 ;
872: x_msg_details VARCHAR2(3000) ;
873: x_msg_summary VARCHAR2(3000) ;
866:
867: l_init_msg_list VARCHAR2(30) ;
868: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;
869: l_line_adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
870: x_action_request_tbl Oe_Order_Pub.Request_Tbl_Type;
871: l_api_version_number NUMBER := 1.0 ;
872: x_msg_details VARCHAR2(3000) ;
873: x_msg_summary VARCHAR2(3000) ;
874:
871: l_api_version_number NUMBER := 1.0 ;
872: x_msg_details VARCHAR2(3000) ;
873: x_msg_summary VARCHAR2(3000) ;
874:
875: l_header_rec Oe_Order_Pub.Header_Rec_Type;
876: x_header_rec Oe_Order_Pub.Header_Rec_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
872: x_msg_details VARCHAR2(3000) ;
873: x_msg_summary VARCHAR2(3000) ;
874:
875: l_header_rec Oe_Order_Pub.Header_Rec_Type;
876: x_header_rec Oe_Order_Pub.Header_Rec_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
873: x_msg_summary VARCHAR2(3000) ;
874:
875: l_header_rec Oe_Order_Pub.Header_Rec_Type;
876: x_header_rec Oe_Order_Pub.Header_Rec_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
874:
875: l_header_rec Oe_Order_Pub.Header_Rec_Type;
876: x_header_rec Oe_Order_Pub.Header_Rec_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
875: l_header_rec Oe_Order_Pub.Header_Rec_Type;
876: x_header_rec Oe_Order_Pub.Header_Rec_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
876: x_header_rec Oe_Order_Pub.Header_Rec_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_Val_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
885: x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
886: x_line_val_tbl Oe_Order_Pub.Line_Val_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_Tbl_Type;
887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_Tbl_Type;
895: x_Lot_Serial_val_tbl Oe_Order_Pub.Lot_Serial_Val_Tbl_Type;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_Tbl_Type;
895: x_Lot_Serial_val_tbl Oe_Order_Pub.Lot_Serial_Val_Tbl_Type;
896:
889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type;
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_Tbl_Type;
895: x_Lot_Serial_val_tbl Oe_Order_Pub.Lot_Serial_Val_Tbl_Type;
896:
897: l_uom_code varchar2(30);
890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_Tbl_Type;
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_Tbl_Type;
895: x_Lot_Serial_val_tbl Oe_Order_Pub.Lot_Serial_Val_Tbl_Type;
896:
897: l_uom_code varchar2(30);
898: l_currency_code varchar2(30);
891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_Tbl_Type;
892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_Tbl_Type;
893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_Val_Tbl_Type;
894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_Tbl_Type;
895: x_Lot_Serial_val_tbl Oe_Order_Pub.Lot_Serial_Val_Tbl_Type;
896:
897: l_uom_code varchar2(30);
898: l_currency_code varchar2(30);
899: l_ordered_qty NUMBER;
949: END IF;
950:
951: select list_header_id INTO l_list_header_id from qp_list_lines where list_line_id=l_list_line_id;
952: --Update the Header,
953: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
954: l_header_rec.header_id := p_header_id;
955: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
956: l_header_rec.flow_status_code := 'PRICING_APPROVED';
957: IF l_debug_level > 0 THEN
988:
989: IF (l_continue='Y') then
990: i := i+1;
991: --Order Line Information
992: l_line_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_REC;
993: l_line_tbl(i).header_id := p_header_id;
994: l_line_tbl(i).line_id := l_lines.line_id;
995: l_line_tbl(i).unit_selling_price := l_price;
996: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1014: oe_debug_pub.add( 'In call Process Order API Adjustment' , 1 ) ;
1015: END IF;
1016:
1017: --Order Line Adjustment Information
1018: l_line_adj_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
1019: l_line_adj_tbl(i).line_index := i; --adjustment for the line above
1020: l_line_adj_tbl(i).list_header_id := l_list_header_id; --oe_price_adjustments
1021: l_line_adj_tbl(i).list_line_id := l_list_line_id;
1022: l_line_adj_tbl(i).arithmetic_operator := 'AMT';
1036: ELSE
1037: --Bug 7322917
1038: i := i+1;
1039: --Order Line Information
1040: l_line_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_REC;
1041: l_line_tbl(i).header_id := p_header_id;
1042: l_line_tbl(i).line_id := l_lines.line_id;
1043: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1044: l_line_tbl(i).calculate_price_flag := 'P';