69:
70: FUNCTION Service_Index (
71: quote_line_id NUMBER := FND_API.G_MISS_NUM,
72: quote_line_index NUMBER := FND_API.G_MISS_NUM,
73: P_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type ,
74: p_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
75: ) RETURN NUMBER
76: IS
77: l_parent_id NUMBER := FND_API.G_MISS_NUM;
70: FUNCTION Service_Index (
71: quote_line_id NUMBER := FND_API.G_MISS_NUM,
72: quote_line_index NUMBER := FND_API.G_MISS_NUM,
73: P_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type ,
74: p_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
75: ) RETURN NUMBER
76: IS
77: l_parent_id NUMBER := FND_API.G_MISS_NUM;
78: l_parent_index NUMBER := FND_API.G_MISS_NUM;
266: END Retrieve_OE_Messages;
267:
268:
269: PROCEDURE Map_quote_to_fulfillment(
270: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
271: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
272: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
273: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
274: -- P_fulfillment_tbl IN ASO_ORDER_INT.FULFILLMENT_TBL_TYPE,
267:
268:
269: PROCEDURE Map_quote_to_fulfillment(
270: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
271: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
272: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
273: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
274: -- P_fulfillment_tbl IN ASO_ORDER_INT.FULFILLMENT_TBL_TYPE,
275: X_ffm_content_tbl OUT NOCOPY /* file.sql.39 change */ ASO_FFM_INT.ffm_content_tbl_type,
268:
269: PROCEDURE Map_quote_to_fulfillment(
270: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
271: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
272: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
273: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
274: -- P_fulfillment_tbl IN ASO_ORDER_INT.FULFILLMENT_TBL_TYPE,
275: X_ffm_content_tbl OUT NOCOPY /* file.sql.39 change */ ASO_FFM_INT.ffm_content_tbl_type,
276: X_ffm_bind_tbl OUT NOCOPY /* file.sql.39 change */ ASO_FFM_INT.ffm_bind_tbl_type
269: PROCEDURE Map_quote_to_fulfillment(
270: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
271: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
272: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
273: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
274: -- P_fulfillment_tbl IN ASO_ORDER_INT.FULFILLMENT_TBL_TYPE,
275: X_ffm_content_tbl OUT NOCOPY /* file.sql.39 change */ ASO_FFM_INT.ffm_content_tbl_type,
276: X_ffm_bind_tbl OUT NOCOPY /* file.sql.39 change */ ASO_FFM_INT.ffm_bind_tbl_type
277: )
346:
347:
348: /*
349: ** convert from ASO_ORDER_INT.Sales_Credit and ASO_ORDER_INT.Lot_Serial
350: ** to ASO_QUOTE_PUB.Sales_Credit and ASO_QUOTE_PUB.Lot_Serial
351: ** respectively.
352: */
353: Procedure Map_Scredit_to_Qcredit(
354: P_header_sales_credit_TBL IN Sales_credit_tbl_type
356: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
357: := G_MISS_sales_credit_TBL,
358: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
359: := G_MISS_Lot_Serial_Tbl,
360: x_header_sales_credit_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_credit_tbl_type,
361: x_Line_sales_credit_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_credit_tbl_type,
362: x_Lot_Serial_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
363: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
357: := G_MISS_sales_credit_TBL,
358: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
359: := G_MISS_Lot_Serial_Tbl,
360: x_header_sales_credit_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_credit_tbl_type,
361: x_Line_sales_credit_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_credit_tbl_type,
362: x_Lot_Serial_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
363: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
365: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
358: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
359: := G_MISS_Lot_Serial_Tbl,
360: x_header_sales_credit_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_credit_tbl_type,
361: x_Line_sales_credit_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_credit_tbl_type,
362: x_Lot_Serial_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
363: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
365: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
366: )
547: PROCEDURE Create_order(
548: P_Api_Version_Number IN NUMBER,
549: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
550: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
551: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
552: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
548: P_Api_Version_Number IN NUMBER,
549: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
550: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
551: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
552: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
549: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
550: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
551: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
552: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
550: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
551: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
552: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
551: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
552: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
552: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
553: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
554: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
555: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
556: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
557: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
558: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
559: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
560: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
561: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
562: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
570: := G_MISS_sales_credit_TBL,
563: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
570: := G_MISS_sales_credit_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
564: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
565: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
566: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
570: := G_MISS_sales_credit_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
567: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
570: := G_MISS_sales_credit_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
568: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
570: := G_MISS_sales_credit_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
569: P_header_sales_credit_TBL IN Sales_credit_tbl_type
570: := G_MISS_sales_credit_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
570: := G_MISS_sales_credit_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
571: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
572: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
573: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
574: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
575: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
576: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
577: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
578: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
579: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
580: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
581: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
582: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
583: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
584: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
585: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
593: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
586: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
593: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
594: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
587: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
593: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
594: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
595: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
588: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
593: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
594: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
595: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
596: := G_MISS_sales_credit_TBL,
589: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
593: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
594: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
595: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
596: := G_MISS_sales_credit_TBL,
597: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
590: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
591: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
592: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
593: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
594: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
595: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
596: := G_MISS_sales_credit_TBL,
597: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
598: := G_MISS_Lot_Serial_Tbl,
606: IS
607:
608: l_api_version_number CONSTANT NUMBER := 1.0;
609: l_api_name CONSTANT VARCHAR2(30):= 'Create_Order';
610: l_header_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
611: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
612: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
613:
614: BEGIN
607:
608: l_api_version_number CONSTANT NUMBER := 1.0;
609: l_api_name CONSTANT VARCHAR2(30):= 'Create_Order';
610: l_header_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
611: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
612: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
613:
614: BEGIN
615:
608: l_api_version_number CONSTANT NUMBER := 1.0;
609: l_api_name CONSTANT VARCHAR2(30):= 'Create_Order';
610: l_header_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
611: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
612: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
613:
614: BEGIN
615:
616:
672: P_Header_Price_Adj_Attr_Tbl => P_Header_Price_Adj_Attr_Tbl,
673: P_Header_Shipment_Tbl => P_Header_Shipment_Tbl,
674: P_Header_TAX_DETAIL_Tbl =>P_Header_TAX_DETAIL_Tbl,
675: P_Header_FREIGHT_CHARGE_Tbl => P_Header_FREIGHT_CHARGE_Tbl,
676: P_Header_ATTRIBS_EXT_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
677: P_Header_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
678: P_header_sales_credit_TBL => l_header_sales_credit_TBL,
679: P_Qte_Line_Tbl => P_Qte_Line_Tbl,
680: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,
673: P_Header_Shipment_Tbl => P_Header_Shipment_Tbl,
674: P_Header_TAX_DETAIL_Tbl =>P_Header_TAX_DETAIL_Tbl,
675: P_Header_FREIGHT_CHARGE_Tbl => P_Header_FREIGHT_CHARGE_Tbl,
676: P_Header_ATTRIBS_EXT_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
677: P_Header_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
678: P_header_sales_credit_TBL => l_header_sales_credit_TBL,
679: P_Qte_Line_Tbl => P_Qte_Line_Tbl,
680: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,
681: P_Line_Payment_Tbl => P_Line_Payment_Tbl,
688: P_Line_FREIGHT_CHARGE_Tbl => P_Line_FREIGHT_CHARGE_Tbl,
689: P_Line_ATTRIBS_EXT_Tbl =>P_Line_ATTRIBS_EXT_Tbl,
690: P_Line_Rltship_Tbl => P_Line_Rltship_Tbl,
691: P_Line_sales_credit_TBL => l_line_sales_credit_TBL,
692: P_Line_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
693: P_Lot_Serial_Tbl => l_Lot_Serial_Tbl,
694: P_Control_Rec => P_Control_Rec,
695: X_Order_Header_Rec => X_Order_Header_Rec,
696: X_Order_Line_Tbl => X_Order_Line_Tbl,
760: PROCEDURE Update_order(
761: P_Api_Version_Number IN NUMBER,
762: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
763: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
764: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
765: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
761: P_Api_Version_Number IN NUMBER,
762: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
763: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
764: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
765: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
762: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
763: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
764: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
765: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
763: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
764: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
765: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
764: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
765: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
765: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
766: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
767: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
768: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
769: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
770: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
771: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
772: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
773: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
774: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
775: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
783: := G_MISS_sales_credit_TBL,
776: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
783: := G_MISS_sales_credit_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
777: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
778: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
779: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
783: := G_MISS_sales_credit_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
780: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
783: := G_MISS_sales_credit_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
781: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
783: := G_MISS_sales_credit_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
782: P_header_sales_credit_TBL IN Sales_credit_tbl_type
783: := G_MISS_sales_credit_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
783: := G_MISS_sales_credit_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
784: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
785: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
786: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
787: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
788: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
789: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
790: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
791: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
792: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
793: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
794: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
795: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
796: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
804: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
797: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
804: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
805: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
798: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
804: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
805: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
806: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
799: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
804: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
805: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
806: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
807: := G_MISS_sales_credit_TBL,
800: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
804: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
805: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
806: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
807: := G_MISS_sales_credit_TBL,
808: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
801: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
802: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
803: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
804: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
805: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
806: P_Line_sales_credit_TBL IN Sales_credit_tbl_type
807: := G_MISS_sales_credit_TBL,
808: P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
809: := G_MISS_Lot_Serial_Tbl,
817: IS
818:
819: l_api_version_number CONSTANT NUMBER := 1.0;
820: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
821: l_header_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
822: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
823: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
824:
825: BEGIN
818:
819: l_api_version_number CONSTANT NUMBER := 1.0;
820: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
821: l_header_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
822: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
823: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
824:
825: BEGIN
826: -- Standard Start of API savepoint
819: l_api_version_number CONSTANT NUMBER := 1.0;
820: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
821: l_header_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
822: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
823: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
824:
825: BEGIN
826: -- Standard Start of API savepoint
827: SAVEPOINT UPDATE_order_PVT;
883: P_Header_Price_Adj_Attr_Tbl => P_Header_Price_Adj_Attr_Tbl,
884: P_Header_Shipment_Tbl => P_Header_Shipment_Tbl,
885: P_Header_TAX_DETAIL_Tbl =>P_Header_TAX_DETAIL_Tbl,
886: P_Header_FREIGHT_CHARGE_Tbl => P_Header_FREIGHT_CHARGE_Tbl,
887: P_Header_ATTRIBS_EXT_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
888: P_Header_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
889: P_header_sales_credit_TBL => l_header_sales_credit_TBL,
890: P_Qte_Line_Tbl => P_Qte_Line_Tbl,
891: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,
884: P_Header_Shipment_Tbl => P_Header_Shipment_Tbl,
885: P_Header_TAX_DETAIL_Tbl =>P_Header_TAX_DETAIL_Tbl,
886: P_Header_FREIGHT_CHARGE_Tbl => P_Header_FREIGHT_CHARGE_Tbl,
887: P_Header_ATTRIBS_EXT_Tbl => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
888: P_Header_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
889: P_header_sales_credit_TBL => l_header_sales_credit_TBL,
890: P_Qte_Line_Tbl => P_Qte_Line_Tbl,
891: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,
892: P_Line_Payment_Tbl => P_Line_Payment_Tbl,
896: P_Line_Price_Adj_Attr_Tbl => P_Line_Price_Adj_Attr_Tbl,
897: P_Line_Shipment_Tbl => P_Line_Shipment_Tbl,
898: P_Line_TAX_DETAIL_Tbl => P_Line_TAX_DETAIL_Tbl,
899: P_Line_FREIGHT_CHARGE_Tbl => P_Line_FREIGHT_CHARGE_Tbl,
900: P_Line_ATTRIBS_EXT_Tbl =>ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
901: P_Line_Rltship_Tbl => P_Line_Rltship_Tbl,
902: P_Line_sales_credit_TBL => l_Line_sales_credit_TBL ,
903: P_Line_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
904: P_Lot_Serial_Tbl => l_Lot_Serial_Tbl,
899: P_Line_FREIGHT_CHARGE_Tbl => P_Line_FREIGHT_CHARGE_Tbl,
900: P_Line_ATTRIBS_EXT_Tbl =>ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
901: P_Line_Rltship_Tbl => P_Line_Rltship_Tbl,
902: P_Line_sales_credit_TBL => l_Line_sales_credit_TBL ,
903: P_Line_Quote_Party_Tbl => ASO_QUOTE_PUB.G_MISS_QUOTE_PARTY_TBL,
904: P_Lot_Serial_Tbl => l_Lot_Serial_Tbl,
905: P_Control_Rec => P_Control_Rec,
906: X_Order_Header_Rec => X_Order_Header_Rec,
907: X_Order_Line_Tbl => X_Order_Line_Tbl,
1115:
1116:
1117: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1118: OE_Order_PUB.G_MISS_REQUEST_TBL;
1119: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1120:
1121: l_control_rec OE_GLOBALS.Control_Rec_Type;
1122: l_return_status VARCHAR2(1);
1123: l_header_rec OE_Order_PUB.Header_Rec_Type;
1362:
1363:
1364: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1365: OE_Order_PUB.G_MISS_REQUEST_TBL;
1366: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1367:
1368: l_control_rec OE_GLOBALS.Control_Rec_Type;
1369: l_return_status VARCHAR2(1);
1370: l_header_rec OE_Order_PUB.Header_Rec_Type;
1587:
1588: --- create order overloaded
1589: -- the following procedure is an overloaded procedure which takes the same
1590: -- parameters as the create order but all record types are defined in
1591: -- ASO_QUOTE_PUB.
1592:
1593: PROCEDURE Create_order(
1594: P_Api_Version IN NUMBER,
1595: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1593: PROCEDURE Create_order(
1594: P_Api_Version IN NUMBER,
1595: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1596: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1597: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1598: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1594: P_Api_Version IN NUMBER,
1595: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1596: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1597: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1598: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1595: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1596: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1597: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1598: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1596: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1597: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1598: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1597: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1598: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1598: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1599: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1600: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1601: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1602: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1603: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1604: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1605: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1606: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1607: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1608: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1609: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1610: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1611: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1612: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1613: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1614: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1615: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1616: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1617: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1618: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1619: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1620: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1621: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1622: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1623: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1624: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1625: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1626: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1627: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1628: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1629: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1630: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1631: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1632: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1633: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1634: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1635: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1636: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1637: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1638: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1639: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1640: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1641: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1649: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
1642: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1649: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
1650: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
1643: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1649: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
1650: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
1651: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
1644: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1649: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
1650: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
1651: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
1652: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
1645: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1649: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
1650: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
1651: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
1652: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
1653: X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
1646: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
1647: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
1648: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
1649: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
1650: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
1651: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
1652: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
1653: X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
1654: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1660: l_api_name CONSTANT VARCHAR2(30):= 'Create_Order';
1661: l_control_rec OE_GLOBALS.Control_Rec_Type;
1662: l_return_status VARCHAR2(1);
1663:
1664: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1665:
1666: -- header record types
1667: l_header_rec OE_Order_PUB.Header_Rec_Type;
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2239: PROCEDURE Update_order(
2240: P_Api_Version IN NUMBER,
2241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2243: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2244: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2240: P_Api_Version IN NUMBER,
2241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2243: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2244: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2243: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2244: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2243: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2244: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2243: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2244: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2244: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2245: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2246: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2247: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2248: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2249: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2250: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2251: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2252: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2253: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2254: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2255: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2256: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2257: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2258: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2259: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2260: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2261: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2262: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2263: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2264: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2265: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2266: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2267: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2268: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2269: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2270: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2271: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2272: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2273: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2274: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2275: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2276: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2277: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2278: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2279: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2280: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2281: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2282: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2283: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2284: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2285: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2286: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2294: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2287: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2294: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2295: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2288: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2294: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2295: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2296: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2289: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2294: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2295: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2296: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2297: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2290: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2294: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2295: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2296: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2297: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2298: X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
2291: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2292: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2293: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2294: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2295: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2296: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2297: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2298: X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
2299: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2308: WHERE lookup_type = 'CANCEL_CODE'
2309: AND lookup_code = 'Not provided';
2310:
2311:
2312: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2313: l_api_version_number CONSTANT NUMBER := 1.0;
2314: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
2315: l_control_rec OE_GLOBALS.Control_Rec_Type;
2316: l_return_status VARCHAR2(1);
3221: x_cust_account_role_id := l_cust_account_role_id;
3222: END get_cust_acct_roles;
3223:
3224: PROCEDURE Get_Cust_Accnt_Id(
3225: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
3226: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
3227: p_Party_Id IN NUMBER,
3228: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3229: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3222: END get_cust_acct_roles;
3223:
3224: PROCEDURE Get_Cust_Accnt_Id(
3225: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
3226: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
3227: p_Party_Id IN NUMBER,
3228: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3229: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3230: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,