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;
2403: PROCEDURE Update_order(
2404: P_Api_Version IN NUMBER,
2405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2407: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2408: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2404: P_Api_Version IN NUMBER,
2405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2407: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2408: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2407: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2408: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2407: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2408: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2407: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2408: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2408: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2409: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2410: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2411: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2412: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2413: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2414: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2415: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2416: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2417: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2418: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2419: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2420: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2421: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2422: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2423: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2424: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2425: P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2426: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2427: P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2428: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2429: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2430: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2431: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2432: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2433: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2434: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2435: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2436: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2437: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2438: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2439: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2440: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2441: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2442: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2443: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2444: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2445: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2446: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2447: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2448: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2449: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2450: P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2458: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2451: := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2458: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2459: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2452: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2458: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2459: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2460: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2453: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2458: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2459: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2460: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2461: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2454: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2458: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2459: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2460: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2461: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2462: X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
2455: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
2456: P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
2457: := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
2458: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
2459: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
2460: P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
2461: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
2462: X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
2463: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2472: WHERE lookup_type = 'CANCEL_CODE'
2473: AND lookup_code = 'Not provided';
2474:
2475:
2476: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2477: l_api_version_number CONSTANT NUMBER := 1.0;
2478: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
2479: l_control_rec OE_GLOBALS.Control_Rec_Type;
2480: l_return_status VARCHAR2(1);
3387: x_cust_account_role_id := l_cust_account_role_id;
3388: END get_cust_acct_roles;
3389:
3390: PROCEDURE Get_Cust_Accnt_Id(
3391: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
3392: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
3393: p_Party_Id IN NUMBER,
3394: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3395: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3388: END get_cust_acct_roles;
3389:
3390: PROCEDURE Get_Cust_Accnt_Id(
3391: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
3392: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
3393: p_Party_Id IN NUMBER,
3394: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3395: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3396: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,