eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_OPP_QTE_PUB dependencies on ASO_QUOTE_PUB

Line 20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,

16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,

Line 21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,

17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
25: P_OPP_QTE_IN_REC IN OPP_QTE_IN_REC_TYPE,

Line 22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,

18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
25: P_OPP_QTE_IN_REC IN OPP_QTE_IN_REC_TYPE,
26: P_CONTROL_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,

Line 23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,

19: P_SOURCE_CODE IN VARCHAR2,
20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
25: P_OPP_QTE_IN_REC IN OPP_QTE_IN_REC_TYPE,
26: P_CONTROL_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
27: X_OPP_QTE_OUT_REC OUT NOCOPY /* file.sql.39 change */ OPP_QTE_OUT_REC_TYPE,

Line 24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,

20: P_QUOTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec,
21: P_HEADER_PAYMENT_REC IN ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC,
22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
25: P_OPP_QTE_IN_REC IN OPP_QTE_IN_REC_TYPE,
26: P_CONTROL_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
27: X_OPP_QTE_OUT_REC OUT NOCOPY /* file.sql.39 change */ OPP_QTE_OUT_REC_TYPE,
28: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 26: P_CONTROL_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,

22: P_HEADER_SHIPMENT_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_REC,
23: P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Rec,
24: P_TEMPLATE_TBL IN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
25: P_OPP_QTE_IN_REC IN OPP_QTE_IN_REC_TYPE,
26: P_CONTROL_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
27: X_OPP_QTE_OUT_REC OUT NOCOPY /* file.sql.39 change */ OPP_QTE_OUT_REC_TYPE,
28: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
30: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 59: lp_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

55: l_copy_att_flag VARCHAR2(1);
56:
57: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
58: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type ;
59: lp_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;

56:
57: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
58: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type ;
59: lp_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;

57: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
58: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type ;
59: lp_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;

58: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type ;
59: lp_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

59: lp_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

60: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

61: lp_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:

Line 66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

62: lp_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()

Line 67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

63: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;

Line 68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

64: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
65: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

Line 70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()

66: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

Line 71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;

67: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

Line 72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

68: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

Line 73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;

69:
70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;

Line 74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

70: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Create_Quote()
71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

71: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;

Line 76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

72: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;

Line 77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;

73: l_hd_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;

Line 78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

74: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

Line 79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;

75: l_hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;

76: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;

77: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_dtl_Tbl;
78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

78: l_ln_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

79: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl;
80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

80: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl;
81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

81: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_type := ASO_QUOTE_PUB.G_Miss_Sales_Credit_Tbl;
82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

82: lx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

83: lx_out_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

84: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;

85: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

86: lx_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

87: lx_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

88: lx_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

89: lx_Hd_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

90: lx_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

91: lx_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

92: lx_Hd_Attr_Ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

93: lx_Hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

94: lx_Hd_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

95: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

96: lx_Line_Rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

97: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

98: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

99: lx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;

Line 104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

100: lx_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;
108: l_last_update_date Date;

Line 105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

101: lx_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;
108: l_last_update_date Date;
109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;

Line 106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

102: lx_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;
108: l_last_update_date Date;
109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
110: lx_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;

Line 107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;

103: lx_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
104: lx_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;
108: l_last_update_date Date;
109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
110: lx_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
111:

Line 109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;

105: lx_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;
108: l_last_update_date Date;
109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
110: lx_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
111:
112: -- Variables for creating object relationship between opportunity and quote
113: l_related_obj_rec ASO_QUOTE_PUB.Related_Obj_Rec_Type := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;

Line 110: lx_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;

106: lx_Ln_Quote_Party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
107: lx_Qte_Template_Tbl ASO_QUOTE_PUB.Template_Tbl_Type;
108: l_last_update_date Date;
109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
110: lx_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
111:
112: -- Variables for creating object relationship between opportunity and quote
113: l_related_obj_rec ASO_QUOTE_PUB.Related_Obj_Rec_Type := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;
114: lx_related_object_id NUMBER;

Line 113: l_related_obj_rec ASO_QUOTE_PUB.Related_Obj_Rec_Type := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;

109: l_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
110: lx_Related_Obj_Tbl ASO_QUOTE_PUB.Related_Obj_Tbl_Type;
111:
112: -- Variables for creating object relationship between opportunity and quote
113: l_related_obj_rec ASO_QUOTE_PUB.Related_Obj_Rec_Type := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;
114: lx_related_object_id NUMBER;
115: l_payment_term_id NUMBER;
116:
117: -- Variables for Sales Team (Security)

Line 118: l_qte_access_rec ASO_QUOTE_PUB.Qte_Access_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_REC;

114: lx_related_object_id NUMBER;
115: l_payment_term_id NUMBER;
116:
117: -- Variables for Sales Team (Security)
118: l_qte_access_rec ASO_QUOTE_PUB.Qte_Access_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_REC;
119: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;
120: lx_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;
121: l_primary_uom_code VARCHAR2(3);
122:

Line 119: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;

115: l_payment_term_id NUMBER;
116:
117: -- Variables for Sales Team (Security)
118: l_qte_access_rec ASO_QUOTE_PUB.Qte_Access_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_REC;
119: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;
120: lx_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;
121: l_primary_uom_code VARCHAR2(3);
122:
123: -- Dummy Variable

Line 120: lx_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;

116:
117: -- Variables for Sales Team (Security)
118: l_qte_access_rec ASO_QUOTE_PUB.Qte_Access_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_REC;
119: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;
120: lx_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL;
121: l_primary_uom_code VARCHAR2(3);
122:
123: -- Dummy Variable
124: l_dummy VARCHAR(1) := NULL;

Line 135: l_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;

131:
132:
133: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
134: l_db_object_name VARCHAR2(30);
135: l_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
136: l_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_REC;
137: l_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type
138: := ASO_DEFAULTING_INT.G_MISS_HEADER_MISC_REC;
139: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

Line 136: l_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_REC;

132:
133: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
134: l_db_object_name VARCHAR2(30);
135: l_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
136: l_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_REC;
137: l_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type
138: := ASO_DEFAULTING_INT.G_MISS_HEADER_MISC_REC;
139: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
140: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

Line 139: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

135: l_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
136: l_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_REC;
137: l_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type
138: := ASO_DEFAULTING_INT.G_MISS_HEADER_MISC_REC;
139: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
140: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
141: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
143: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;

Line 140: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

136: l_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_REC;
137: l_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type
138: := ASO_DEFAULTING_INT.G_MISS_HEADER_MISC_REC;
139: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
140: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
141: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
143: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

138: := ASO_DEFAULTING_INT.G_MISS_HEADER_MISC_REC;
139: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
140: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
141: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
143: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
145: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

Line 144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

140: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
141: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
143: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
145: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
147: lx_changed_flag VARCHAR2(1);
148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 145: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;

141: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
143: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
145: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
147: lx_changed_flag VARCHAR2(1);
148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
149:

Line 146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

142: lx_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
143: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
145: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
147: lx_changed_flag VARCHAR2(1);
148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
149:
150: l_header_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

Line 148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

144: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
145: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
147: lx_changed_flag VARCHAR2(1);
148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
149:
150: l_header_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
151: l_header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
152: l_header_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl;

Line 150: l_header_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

146: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
147: lx_changed_flag VARCHAR2(1);
148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
149:
150: l_header_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
151: l_header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
152: l_header_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl;
153:
154:

Line 151: l_header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

147: lx_changed_flag VARCHAR2(1);
148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
149:
150: l_header_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
151: l_header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
152: l_header_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl;
153:
154:
155: -- Cursors to fetch data from OSO Tables

Line 152: l_header_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl;

148: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
149:
150: l_header_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
151: l_header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
152: l_header_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl;
153:
154:
155: -- Cursors to fetch data from OSO Tables
156:

Line 884: ASO_QUOTE_PUB.Create_Quote(

880: l_ln_shipment_count := 0;
881: l_ln_sales_credit_count := 0;
882: l_ln_price_attr_count := 0;
883:
884: ASO_QUOTE_PUB.Create_Quote(
885: P_Api_Version_Number => 1.0,
886: P_Init_Msg_List => FND_API.G_FALSE,
887: P_Commit => FND_API.G_FALSE,
888: p_control_rec => l_control_rec,

Line 1100: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

1096: l_line_count := 0;
1097: l_ln_shipment_count := 0;
1098: l_ln_sales_credit_count := 0;
1099: l_ln_price_attr_count := 0;
1100: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
1101: l_profile_val := fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE');
1102:
1103: FOR i IN 1..lpx_qte_line_tbl.count LOOP
1104:

Line 1286: ASO_QUOTE_PUB.Update_Quote(

1282: RAISE FND_API.G_EXC_ERROR;
1283: END;
1284:
1285:
1286: ASO_QUOTE_PUB.Update_Quote(
1287: p_api_version_number => 1.0,
1288: p_init_msg_list => fnd_api.g_false,
1289: p_commit => fnd_api.g_false,
1290: p_control_rec => p_control_rec,

Line 1565: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1561: END Create_Qte_Opportunity;
1562:
1563:
1564: FUNCTION Validate_Item(
1565: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1566: p_inventory_item_id IN NUMBER,
1567: p_organization_id IN NUMBER,
1568: p_quantity IN NUMBER,
1569: p_uom_code IN VARCHAR2