DBA Data[Home] [Help]

APPS.OE_DEALS_UTIL dependencies on OE_ORDER_PUB

Line 59: p_deleted_options_tbl OE_Order_PUB.request_tbl_type;

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);

Line 60: p_updated_options_tbl OE_Order_PUB.request_tbl_type;

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;

Line 868: l_line_tbl Oe_Order_Pub.Line_Tbl_Type;

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) ;

Line 869: l_line_adj_tbl Oe_Order_Pub.Line_Adj_Tbl_Type;

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) ;

Line 870: x_action_request_tbl Oe_Order_Pub.Request_Tbl_Type;

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:

Line 875: l_header_rec Oe_Order_Pub.Header_Rec_Type;

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;

Line 876: x_header_rec Oe_Order_Pub.Header_Rec_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;

Line 877: x_header_val_rec Oe_Order_Pub.Header_Val_Rec_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;

Line 878: x_Header_Adj_tbl Oe_Order_Pub.Header_Adj_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;

Line 879: x_Header_Adj_val_tbl Oe_Order_Pub.Header_Adj_Val_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;

Line 880: x_Header_price_Att_tbl Oe_Order_Pub.Header_Price_Att_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;

Line 881: x_Header_Adj_Att_tbl Oe_Order_Pub.Header_Adj_Att_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;

Line 882: x_Header_Adj_Assoc_tbl Oe_Order_Pub.Header_Adj_Assoc_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;

Line 883: x_Header_Scredit_tbl Oe_Order_Pub.Header_Scredit_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;

Line 884: x_Header_Scredit_val_tbl Oe_Order_Pub.Header_Scredit_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;
888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_Tbl_Type;

Line 885: x_line_tbl Oe_Order_Pub.Line_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;

Line 886: x_line_val_tbl Oe_Order_Pub.Line_Val_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;

Line 887: x_Line_Adj_tbl Oe_Order_Pub.Line_Adj_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;

Line 888: x_Line_Adj_val_tbl Oe_Order_Pub.Line_Adj_Val_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;

Line 889: x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_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;

Line 890: x_Line_Adj_Att_tbl Oe_Order_Pub.Line_Adj_Att_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;

Line 891: x_Line_Adj_Assoc_tbl Oe_Order_Pub.Line_Adj_Assoc_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;

Line 892: x_Line_Scredit_tbl Oe_Order_Pub.Line_Scredit_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:

Line 893: x_Line_Scredit_val_tbl Oe_Order_Pub.Line_Scredit_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:
897: l_uom_code varchar2(30);

Line 894: x_Lot_Serial_tbl Oe_Order_Pub.Lot_Serial_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);
898: l_currency_code varchar2(30);

Line 895: x_Lot_Serial_val_tbl Oe_Order_Pub.Lot_Serial_Val_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);
899: l_ordered_qty NUMBER;

Line 953: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

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

Line 992: l_line_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_REC;

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;

Line 1018: l_line_adj_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;

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';

Line 1040: l_line_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_REC;

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';