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_QUOTE_PUB_W dependencies on ASO_QUOTE_PUB

Line 1: PACKAGE BODY ASO_Quote_Pub_W as

1: PACKAGE BODY ASO_Quote_Pub_W as
2: /* $Header: asovqw1b.pls 120.9.12020000.2 2012/11/19 11:11:34 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PUB_W
5: -- Purpose : Rosetta wrappers for ASO Quote Public API

Line 4: -- Package name : ASO_QUOTE_PUB_W

1: PACKAGE BODY ASO_Quote_Pub_W as
2: /* $Header: asovqw1b.pls 120.9.12020000.2 2012/11/19 11:11:34 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PUB_W
5: -- Purpose : Rosetta wrappers for ASO Quote Public API
6: -- History : Created on 12/02/01
7: -- NOTE :
8: -- END of Comments

Line 5: -- Purpose : Rosetta wrappers for ASO Quote Public API

1: PACKAGE BODY ASO_Quote_Pub_W as
2: /* $Header: asovqw1b.pls 120.9.12020000.2 2012/11/19 11:11:34 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PUB_W
5: -- Purpose : Rosetta wrappers for ASO Quote Public API
6: -- History : Created on 12/02/01
7: -- NOTE :
8: -- END of Comments
9: ROSETTA_G_MISTAKE_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_PUB_W';

8: -- END of Comments
9: ROSETTA_G_MISTAKE_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');
10: ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_PUB_W';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVQW1B.PLS';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;

Line 1271: l_control_rec ASO_Quote_Pub.Control_Rec_Type

1267: x_msg_count OUT NOCOPY NUMBER ,
1268: x_msg_data OUT NOCOPY VARCHAR2
1269: )
1270: AS
1271: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1272: := ASO_Quote_Pub.G_Miss_Control_Rec;
1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type

Line 1272: := ASO_Quote_Pub.G_Miss_Control_Rec;

1268: x_msg_data OUT NOCOPY VARCHAR2
1269: )
1270: AS
1271: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1272: := ASO_Quote_Pub.G_Miss_Control_Rec;
1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

Line 1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

1269: )
1270: AS
1271: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1272: := ASO_Quote_Pub.G_Miss_Control_Rec;
1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type

Line 1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

1270: AS
1271: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1272: := ASO_Quote_Pub.G_Miss_Control_Rec;
1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

Line 1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type

1271: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1272: := ASO_Quote_Pub.G_Miss_Control_Rec;
1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type

Line 1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

1272: := ASO_Quote_Pub.G_Miss_Control_Rec;
1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;

Line 1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type

1273: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

Line 1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

1274: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

Line 1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type

1275: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

Line 1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;

1276: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

Line 1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

1277: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

Line 1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

1278: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

1279: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

Line 1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

1280: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

1281: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type

Line 1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

1282: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;

Line 1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

1283: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

Line 1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

1284: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

Line 1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type

1285: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;

1286: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

Line 1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

1287: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

1288: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

Line 1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

1289: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

1290: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

Line 1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

1291: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

Line 1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

1292: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

Line 1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type

1293: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

Line 1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

1294: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

Line 1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

1295: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type

Line 1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

1296: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;

Line 1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

1297: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type

Line 1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

1298: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;

Line 1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type

1299: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;
1307:

Line 1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;

1300: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;
1307:
1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type

Line 1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type

1301: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;
1307:
1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;

Line 1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;

1302: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1303: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;
1307:
1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
1310:

Line 1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type

1304: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;
1307:
1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
1310:
1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;

1305: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
1306: := ASO_Quote_Pub.G_Miss_Template_Tbl;
1307:
1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
1310:
1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

Line 1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;

1307:
1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
1310:
1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;

Line 1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

1308: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
1310:
1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

Line 1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

1309: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
1310:
1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

Line 1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;

1310:
1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

Line 1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;

1311: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

1312: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

Line 1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

1313: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;

Line 1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

1314: lx_Hd_Shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;

Line 1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

1315: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

1316: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

Line 1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;

1317: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

Line 1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;

1318: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:

Line 1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

1319: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

Line 1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

1320: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;

Line 1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

1321: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1322: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE;
1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

Line 1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

1323: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

Line 1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;

1324: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

Line 1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

1325: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

Line 1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

1326:
1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

Line 1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

1327: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;

Line 1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

1328: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;

Line 1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

1329: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;

Line 1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

1330: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
1338: l_debug VARCHAR2(1);

Line 1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;

1331: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
1338: l_debug VARCHAR2(1);
1339: BEGIN

Line 1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;

1332: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
1338: l_debug VARCHAR2(1);
1339: BEGIN
1340:

Line 1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;

1333: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1334: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
1335: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
1336: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
1337: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
1338: l_debug VARCHAR2(1);
1339: BEGIN
1340:
1341: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 2635: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Create_Quote');

2631:
2632:
2633: -- Call ASO API
2634: IF l_debug = 'Y' THEN
2635: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Create_Quote');
2636: END IF;
2637: ASO_QUOTE_PUB.Create_Quote(
2638: P_Api_Version_Number => p_api_version_number ,
2639: P_Init_Msg_List => p_init_msg_list ,

Line 2637: ASO_QUOTE_PUB.Create_Quote(

2633: -- Call ASO API
2634: IF l_debug = 'Y' THEN
2635: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Create_Quote');
2636: END IF;
2637: ASO_QUOTE_PUB.Create_Quote(
2638: P_Api_Version_Number => p_api_version_number ,
2639: P_Init_Msg_List => p_init_msg_list ,
2640: P_Commit => p_commit ,
2641: P_Validation_Level => p_validation_level ,

Line 2692: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Create_Quote');

2688: X_Msg_Count => x_msg_count ,
2689: X_Msg_Data => x_msg_data);
2690:
2691: IF l_debug = 'Y' THEN
2692: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Create_Quote');
2693: END IF;
2694:
2695: x_q_quote_header_id := rosetta_g_miss_num_map(lx_qte_header_rec.quote_header_id);
2696: x_q_last_update_date := lx_qte_header_rec.last_update_date;

Line 3980: lp_submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type

3976: x_msg_count OUT NOCOPY NUMBER ,
3977: x_msg_data OUT NOCOPY VARCHAR2
3978: )
3979: IS
3980: lp_submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type
3981: := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
3982: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
3983: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;

Line 3981: := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;

3977: x_msg_data OUT NOCOPY VARCHAR2
3978: )
3979: IS
3980: lp_submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type
3981: := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
3982: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
3983: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
3985: l_debug VARCHAR2(1);

Line 3982: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

3978: )
3979: IS
3980: lp_submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type
3981: := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
3982: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
3983: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
3985: l_debug VARCHAR2(1);
3986: BEGIN

Line 3983: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

3979: IS
3980: lp_submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type
3981: := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
3982: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
3983: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
3985: l_debug VARCHAR2(1);
3986: BEGIN
3987:

Line 3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;

3980: lp_submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type
3981: := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
3982: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
3983: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
3984: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
3985: l_debug VARCHAR2(1);
3986: BEGIN
3987:
3988: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 4142: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Quote_Pub.Submit_Quote');

4138:
4139:
4140: -- Call ASO API
4141: IF l_debug = 'Y'
4142: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Quote_Pub.Submit_Quote');
4143: END IF;
4144: ASO_Quote_Pub.Submit_Quote(
4145: p_api_version_number => p_api_version_number,
4146: p_init_msg_list => p_init_msg_list,

Line 4144: ASO_Quote_Pub.Submit_Quote(

4140: -- Call ASO API
4141: IF l_debug = 'Y'
4142: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Quote_Pub.Submit_Quote');
4143: END IF;
4144: ASO_Quote_Pub.Submit_Quote(
4145: p_api_version_number => p_api_version_number,
4146: p_init_msg_list => p_init_msg_list,
4147: p_control_rec => lp_submit_control_rec,
4148: p_qte_header_rec => l_qte_header_rec,

Line 4154: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Quote_Pub.Submit_Quote');

4150: x_return_status => x_return_status,
4151: x_msg_count => x_msg_count,
4152: x_msg_data => x_msg_data);
4153: IF l_debug = 'Y'
4154: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Quote_Pub.Submit_Quote');
4155: END IF;
4156:
4157: ASO_QUOTE_UTIL_PVT.Set_Order_Header_Rec_Out(
4158: p_order_header_rec => lx_order_header_rec,

Line 5417: l_control_rec ASO_Quote_Pub.Control_Rec_Type

5413: x_msg_count OUT NOCOPY NUMBER ,
5414: x_msg_data OUT NOCOPY VARCHAR2
5415: )
5416: AS
5417: l_control_rec ASO_Quote_Pub.Control_Rec_Type
5418: := ASO_Quote_Pub.G_Miss_Control_Rec;
5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type

Line 5418: := ASO_Quote_Pub.G_Miss_Control_Rec;

5414: x_msg_data OUT NOCOPY VARCHAR2
5415: )
5416: AS
5417: l_control_rec ASO_Quote_Pub.Control_Rec_Type
5418: := ASO_Quote_Pub.G_Miss_Control_Rec;
5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

Line 5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

5415: )
5416: AS
5417: l_control_rec ASO_Quote_Pub.Control_Rec_Type
5418: := ASO_Quote_Pub.G_Miss_Control_Rec;
5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type

Line 5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

5416: AS
5417: l_control_rec ASO_Quote_Pub.Control_Rec_Type
5418: := ASO_Quote_Pub.G_Miss_Control_Rec;
5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

Line 5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type

5417: l_control_rec ASO_Quote_Pub.Control_Rec_Type
5418: := ASO_Quote_Pub.G_Miss_Control_Rec;
5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type

Line 5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

5418: := ASO_Quote_Pub.G_Miss_Control_Rec;
5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;

Line 5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type

5419: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

Line 5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

5420: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

Line 5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type

5421: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

Line 5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;

5422: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

Line 5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

5423: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type
5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

Line 5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

5424: := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

5425: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type
5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

Line 5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

5426: := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

5427: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

Line 5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

5428: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;

Line 5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

5429: l_ln_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

Line 5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

5430: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

Line 5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

5431: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;

5432: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

Line 5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

5433: l_ln_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

5434: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

Line 5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

5435: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

5436: := ASO_Quote_Pub.G_MISS_SHIPMENT_Tbl;
5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

Line 5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

5437: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

Line 5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

5438: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

Line 5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type

5439: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

Line 5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

5440: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

Line 5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

5441: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type

Line 5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

5442: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;

Line 5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

5443: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type

Line 5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

5444: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;

Line 5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type

5445: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;
5453:

Line 5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;

5446: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;
5453:
5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type

Line 5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type

5447: l_ln_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;
5453:
5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;

Line 5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;

5448: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5449: l_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type
5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;
5453:
5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
5456:

Line 5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type

5450: := ASO_Quote_Pub.G_Miss_Qte_Access_Tbl;
5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;
5453:
5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
5456:
5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;

5451: l_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type
5452: := ASO_Quote_Pub.G_Miss_Template_Tbl;
5453:
5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
5456:
5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

Line 5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;

5453:
5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
5456:
5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

Line 5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

5454: l_Related_Obj_Tbl ASO_Quote_Pub.Related_Obj_Tbl_Type
5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
5456:
5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

Line 5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

5455: := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
5456:
5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

Line 5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;

5456:
5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

Line 5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

5457: lx_Qte_Header_Rec ASO_Quote_Pub.Qte_Header_Rec_Type;
5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

Line 5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

5458: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

5459: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

Line 5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

5460: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;

Line 5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

5461: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

Line 5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

5462: lx_Hd_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

Line 5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;

5463: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;

5464: lx_Qte_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:

Line 5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

5465: lx_Line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

Line 5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

5466: lx_Ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;

Line 5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

5467: lx_Ln_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type;
5468: lx_Ln_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type;
5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

Line 5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

5469: lx_Ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

Line 5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;

5470: lx_Ln_Sales_Credit_Tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

Line 5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

5471: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

Line 5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;

5472:
5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

Line 5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

5473: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;

Line 5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

5474: lx_Hd_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type ;
5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;

Line 5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

5475: lx_Hd_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;

Line 5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;

5476: lx_Ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type ;
5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
5484: l_debug VARCHAR2(1);

Line 5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;

5477: lx_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
5484: l_debug VARCHAR2(1);
5485: BEGIN

Line 5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;

5478: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
5484: l_debug VARCHAR2(1);
5485: BEGIN
5486:

Line 5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;

5479: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
5480: lx_Ln_Quote_Party_Tbl ASO_Quote_Pub.Quote_Party_Tbl_Type;
5481: lx_Qte_Access_Tbl ASO_Quote_Pub.Qte_Access_Tbl_Type;
5482: lx_Template_Tbl ASO_Quote_Pub.Template_Tbl_Type;
5483: lx_Related_Obj_Tbl ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
5484: l_debug VARCHAR2(1);
5485: BEGIN
5486:
5487: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 6778: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Update_Quote');

6774: );
6775:
6776: -- Call ASO API
6777: IF l_debug = 'Y' THEN
6778: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Update_Quote');
6779: END IF;
6780: ASO_QUOTE_PUB.Update_Quote(
6781: P_Api_Version_Number => p_api_version_number ,
6782: P_Init_Msg_List => p_init_msg_list ,

Line 6780: ASO_QUOTE_PUB.Update_Quote(

6776: -- Call ASO API
6777: IF l_debug = 'Y' THEN
6778: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Update_Quote');
6779: END IF;
6780: ASO_QUOTE_PUB.Update_Quote(
6781: P_Api_Version_Number => p_api_version_number ,
6782: P_Init_Msg_List => p_init_msg_list ,
6783: P_Commit => p_commit ,
6784: P_Validation_Level => p_validation_level ,

Line 6834: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Update_Quote');

6830: X_Return_Status => x_return_status ,
6831: X_Msg_Count => x_msg_count ,
6832: X_Msg_Data => x_msg_data);
6833: IF l_debug = 'Y' THEN
6834: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Update_Quote');
6835: END IF;
6836:
6837: x_q_quote_header_id := rosetta_g_miss_num_map(lx_qte_header_rec.quote_header_id);
6838: x_q_last_update_date := lx_qte_header_rec.last_update_date;

Line 8315: l_control_rec ASO_Quote_Pub.Control_Rec_Type

8311: x_msg_count OUT NOCOPY NUMBER ,
8312: x_msg_data OUT NOCOPY VARCHAR2
8313: )
8314: AS
8315: l_control_rec ASO_Quote_Pub.Control_Rec_Type
8316: := ASO_Quote_Pub.G_Miss_Control_Rec;
8317: l_opp_qte_in_rec ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type
8318: := ASO_Opp_Qte_Pub.G_Miss_Opp_Qte_In_Rec;
8319: lx_opp_qte_out_rec ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type;

Line 8316: := ASO_Quote_Pub.G_Miss_Control_Rec;

8312: x_msg_data OUT NOCOPY VARCHAR2
8313: )
8314: AS
8315: l_control_rec ASO_Quote_Pub.Control_Rec_Type
8316: := ASO_Quote_Pub.G_Miss_Control_Rec;
8317: l_opp_qte_in_rec ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type
8318: := ASO_Opp_Qte_Pub.G_Miss_Opp_Qte_In_Rec;
8319: lx_opp_qte_out_rec ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type;
8320:

Line 8321: l_quote_header_rec ASO_Quote_Pub.qte_header_rec_type

8317: l_opp_qte_in_rec ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type
8318: := ASO_Opp_Qte_Pub.G_Miss_Opp_Qte_In_Rec;
8319: lx_opp_qte_out_rec ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type;
8320:
8321: l_quote_header_rec ASO_Quote_Pub.qte_header_rec_type
8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type

Line 8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

8318: := ASO_Opp_Qte_Pub.G_Miss_Opp_Qte_In_Rec;
8319: lx_opp_qte_out_rec ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type;
8320:
8321: l_quote_header_rec ASO_Quote_Pub.qte_header_rec_type
8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;

Line 8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type

8319: lx_opp_qte_out_rec ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type;
8320:
8321: l_quote_header_rec ASO_Quote_Pub.qte_header_rec_type
8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type

Line 8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;

8320:
8321: l_quote_header_rec ASO_Quote_Pub.qte_header_rec_type
8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;

Line 8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type

8321: l_quote_header_rec ASO_Quote_Pub.qte_header_rec_type
8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;
8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type

Line 8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;

8322: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;
8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type
8330: := ASO_Quote_Pub.G_Miss_Template_Tbl;

Line 8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type

8323: l_hd_payment_rec ASO_Quote_Pub.Payment_rec_Type
8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;
8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type
8330: := ASO_Quote_Pub.G_Miss_Template_Tbl;
8331: l_debug VARCHAR2(1);

Line 8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;

8324: := ASO_Quote_Pub.G_MISS_PAYMENT_rec;
8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;
8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type
8330: := ASO_Quote_Pub.G_Miss_Template_Tbl;
8331: l_debug VARCHAR2(1);
8332:

Line 8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type

8325: l_hd_shipment_rec ASO_Quote_Pub.Shipment_rec_Type
8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;
8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type
8330: := ASO_Quote_Pub.G_Miss_Template_Tbl;
8331: l_debug VARCHAR2(1);
8332:
8333: BEGIN

Line 8330: := ASO_Quote_Pub.G_Miss_Template_Tbl;

8326: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
8327: l_hd_tax_rec ASO_Quote_Pub.Tax_Detail_rec_Type
8328: := ASO_Quote_Pub.G_Miss_Tax_Detail_rec;
8329: l_template_tbl ASO_Quote_Pub.Template_TBL_Type
8330: := ASO_Quote_Pub.G_Miss_Template_Tbl;
8331: l_debug VARCHAR2(1);
8332:
8333: BEGIN
8334:

Line 9072: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');

9068: -- initialize API return status to success
9069: x_return_status := FND_API.G_RET_STS_SUCCESS;
9070:
9071: IF l_debug = 'Y' THEN
9072: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
9073: END IF;
9074:
9075: -- begin API body
9076:

Line 9127: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');

9123: COMMIT WORK;
9124: END IF;
9125:
9126: IF l_debug = 'Y' THEN
9127: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
9128: END IF;
9129: -- standard call to get message count and if count is 1, get message info.
9130: FND_MSG_PUB.Count_And_Get
9131: ( p_encoded => FND_API.G_FALSE,

Line 9370: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;

9366: IS
9367: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Line';
9368: l_api_version CONSTANT NUMBER := 1.0;
9369:
9370: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
9371: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9372: l_copy_quote_control_rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type := ASO_COPY_QUOTE_PUB.G_Miss_Copy_Quote_Control_Rec;
9373: l_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
9374: x_q_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

Line 9371: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

9367: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Line';
9368: l_api_version CONSTANT NUMBER := 1.0;
9369:
9370: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
9371: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9372: l_copy_quote_control_rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type := ASO_COPY_QUOTE_PUB.G_Miss_Copy_Quote_Control_Rec;
9373: l_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
9374: x_q_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9375: l_debug VARCHAR2(1);

Line 9373: l_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;

9369:
9370: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
9371: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9372: l_copy_quote_control_rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type := ASO_COPY_QUOTE_PUB.G_Miss_Copy_Quote_Control_Rec;
9373: l_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
9374: x_q_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9375: l_debug VARCHAR2(1);
9376: BEGIN
9377:

Line 9374: x_q_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

9370: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
9371: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9372: l_copy_quote_control_rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type := ASO_COPY_QUOTE_PUB.G_Miss_Copy_Quote_Control_Rec;
9373: l_quote_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
9374: x_q_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
9375: l_debug VARCHAR2(1);
9376: BEGIN
9377:
9378: SAVEPOINT Copy_Quote_Line_Pvt;

Line 9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');

9397: END IF;
9398:
9399: -- begin API body
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;

Line 9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));

9398:
9399: -- begin API body
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec

Line 9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));

9399: -- begin API body
9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec
9407: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(

Line 9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);

9400: IF l_debug = 'Y' THEN
9401: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Begins');
9402: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_header_id = '||TO_CHAR(p_quote_header_id));
9403: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_quote_line_id = '||TO_CHAR(p_quote_line_id));
9404: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line PARAM: p_cc_copy_attachment = '||p_cc_copy_attachment);
9405: END IF;
9406: -- set l_control_rec
9407: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(
9408: p_last_update_date => p_c_last_update_date,

Line 9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));

9606: p_count => x_msg_count,
9607: p_data => x_msg_data);
9608:
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');

Line 9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);

9607: p_data => x_msg_data);
9608:
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));

9608:
9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;

Line 9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);

9609: IF l_debug = 'Y' THEN
9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;
9617:

Line 9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');

9610: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_copy_quote_line_id = '||TO_CHAR(x_ql_quote_line_id));
9611: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_return_status = '||x_return_status);
9612: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_count = '||TO_CHAR(x_msg_count));
9613: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line OUTPUT: x_msg_data = '||x_msg_data);
9614: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Copy_Quote_Line Ends');
9615: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
9616: END IF;
9617:
9618: EXCEPTION

Line 9981: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

9977: x_msg_data OUT NOCOPY VARCHAR2
9978:
9979: ) IS
9980:
9981: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type

Line 9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

9978:
9979: ) IS
9980:
9981: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;

Line 9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type

9979: ) IS
9980:
9981: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;
9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type

Line 9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;

9980:
9981: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;
9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type
9988: := ASO_Quote_Pub.G_MISS_Control_Rec;

Line 9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type

9981: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;
9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type
9988: := ASO_Quote_Pub.G_MISS_Control_Rec;
9989:

Line 9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;

9982: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;
9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type
9988: := ASO_Quote_Pub.G_MISS_Control_Rec;
9989:
9990: l_debug VARCHAR2(1);

Line 9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type

9983: l_config_rec ASO_Quote_Pub.qte_line_dtl_rec_type
9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;
9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type
9988: := ASO_Quote_Pub.G_MISS_Control_Rec;
9989:
9990: l_debug VARCHAR2(1);
9991: CURSOR l_old_cfg_csr(p_c_quote_line_id NUMBER) IS

Line 9988: := ASO_Quote_Pub.G_MISS_Control_Rec;

9984: := ASO_Quote_Pub.G_MISS_Qte_Line_Dtl_Rec;
9985: l_model_line_rec ASO_Quote_Pub.qte_line_rec_type
9986: := ASO_Quote_Pub.G_MISS_Qte_Line_Rec;
9987: l_control_rec ASO_Quote_Pub.Control_Rec_Type
9988: := ASO_Quote_Pub.G_MISS_Control_Rec;
9989:
9990: l_debug VARCHAR2(1);
9991: CURSOR l_old_cfg_csr(p_c_quote_line_id NUMBER) IS
9992: select config_header_id, config_revision_num

Line 10363: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Delete_Quote');

10359: FOR i in 1..p_quote_header_ids.COUNT LOOP
10360: l_quote_header_id := p_quote_header_ids(i);
10361: -- Call ASO API
10362: IF l_debug = 'Y'
10363: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Delete_Quote');
10364: END IF;
10365: ASO_QUOTE_PUB.Delete_Quote (
10366: p_api_version,
10367: p_init_msg_list,

Line 10365: ASO_QUOTE_PUB.Delete_Quote (

10361: -- Call ASO API
10362: IF l_debug = 'Y'
10363: THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Delete_Quote');
10364: END IF;
10365: ASO_QUOTE_PUB.Delete_Quote (
10366: p_api_version,
10367: p_init_msg_list,
10368: p_commit,
10369: l_quote_header_id,

Line 10374: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Delete_Quote');

10370: x_return_status,
10371: x_msg_count,
10372: x_msg_data);
10373: IF l_debug = 'Y'
10374: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Delete_Quote');
10375: END IF;
10376: END LOOP;
10377:
10378: IF l_debug = 'Y' THEN

Line 10540: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type

10536: x_msg_count OUT NOCOPY NUMBER ,
10537: x_msg_data OUT NOCOPY VARCHAR2
10538: )
10539: IS
10540: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type
10541: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
10542: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
10543: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
10544:

Line 10541: := ASO_QUOTE_PUB.G_Miss_Control_Rec;

10537: x_msg_data OUT NOCOPY VARCHAR2
10538: )
10539: IS
10540: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type
10541: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
10542: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
10543: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
10544:
10545: l_template_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type

Line 10542: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

10538: )
10539: IS
10540: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type
10541: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
10542: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
10543: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
10544:
10545: l_template_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type
10546: := ASO_QUOTE_TMPL_INT.G_MISS_List_Template_Tbl;

Line 10543: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

10539: IS
10540: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type
10541: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
10542: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
10543: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
10544:
10545: l_template_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type
10546: := ASO_QUOTE_TMPL_INT.G_MISS_List_Template_Tbl;
10547: l_debug VARCHAR2(1);

Line 10996: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(+)');

10992: -- initialize API return status to success
10993: x_return_status := FND_API.G_RET_STS_SUCCESS;
10994:
10995: IF l_debug = 'Y' THEN
10996: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(+)');
10997: END IF;
10998:
10999: -- begin API body
11000:

Line 11017: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(-)');

11013: end loop;
11014:
11015: -- end API body
11016: IF l_debug = 'Y' THEN
11017: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(-)');
11018: END IF;
11019:
11020: -- standard call to get message count and if count is 1, get message info.
11021: FND_MSG_PUB.Count_And_Get

Line 11221: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type

11217: x_msg_data OUT NOCOPY VARCHAR2
11218: )
11219:
11220: AS
11221: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
11222: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC;
11223: l_debug VARCHAR2(1);
11224: BEGIN
11225: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 11222: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC;

11218: )
11219:
11220: AS
11221: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
11222: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC;
11223: l_debug VARCHAR2(1);
11224: BEGIN
11225: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11226: IF l_debug = 'Y' THEN

Line 11418: l_related_obj_rec ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE

11414: WHERE related_object_id = c_related_object_id;
11415:
11416: l_api_name VARCHAR2(30) := 'Update_Object_Relationship';
11417: l_api_version NUMBER := 1.0;
11418: l_related_obj_rec ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
11419: := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;
11420:
11421: l_debug VARCHAR2(1);
11422: BEGIN

Line 11419: := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;

11415:
11416: l_api_name VARCHAR2(30) := 'Update_Object_Relationship';
11417: l_api_version NUMBER := 1.0;
11418: l_related_obj_rec ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
11419: := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_REC;
11420:
11421: l_debug VARCHAR2(1);
11422: BEGIN
11423:

Line 11757: l_control_rec Aso_Quote_Pub.Control_Rec_Type

11753: x_msg_data OUT NOCOPY VARCHAR2
11754: )
11755: AS
11756: l_api_name VARCHAR2(30) := 'Tradein_Lines_from_InstallBase';
11757: l_control_rec Aso_Quote_Pub.Control_Rec_Type
11758: := Aso_Quote_Pub.G_Miss_Control_Rec;
11759: l_qte_header_rec Aso_Quote_Pub.qte_header_rec_type
11760: := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;
11761: l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type

Line 11758: := Aso_Quote_Pub.G_Miss_Control_Rec;

11754: )
11755: AS
11756: l_api_name VARCHAR2(30) := 'Tradein_Lines_from_InstallBase';
11757: l_control_rec Aso_Quote_Pub.Control_Rec_Type
11758: := Aso_Quote_Pub.G_Miss_Control_Rec;
11759: l_qte_header_rec Aso_Quote_Pub.qte_header_rec_type
11760: := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;
11761: l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type
11762: := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;

Line 11759: l_qte_header_rec Aso_Quote_Pub.qte_header_rec_type

11755: AS
11756: l_api_name VARCHAR2(30) := 'Tradein_Lines_from_InstallBase';
11757: l_control_rec Aso_Quote_Pub.Control_Rec_Type
11758: := Aso_Quote_Pub.G_Miss_Control_Rec;
11759: l_qte_header_rec Aso_Quote_Pub.qte_header_rec_type
11760: := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;
11761: l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type
11762: := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;
11763:

Line 11760: := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;

11756: l_api_name VARCHAR2(30) := 'Tradein_Lines_from_InstallBase';
11757: l_control_rec Aso_Quote_Pub.Control_Rec_Type
11758: := Aso_Quote_Pub.G_Miss_Control_Rec;
11759: l_qte_header_rec Aso_Quote_Pub.qte_header_rec_type
11760: := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;
11761: l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type
11762: := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;
11763:
11764: lx_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;

Line 11764: lx_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;

11760: := Aso_Quote_Pub.G_MISS_Qte_Header_Rec;
11761: l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type
11762: := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;
11763:
11764: lx_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;
11765: lx_Qte_Line_Tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
11766: lx_Qte_Line_Dtl_Tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
11767: lx_Ln_Shipment_Tbl Aso_Quote_Pub.Shipment_Tbl_Type;
11768: l_debug VARCHAR2(1);

Line 11765: lx_Qte_Line_Tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;

11761: l_instance_tbl Aso_Quote_Headers_Pvt.Instance_Tbl_Type
11762: := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;
11763:
11764: lx_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;
11765: lx_Qte_Line_Tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
11766: lx_Qte_Line_Dtl_Tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
11767: lx_Ln_Shipment_Tbl Aso_Quote_Pub.Shipment_Tbl_Type;
11768: l_debug VARCHAR2(1);
11769: BEGIN

Line 11766: lx_Qte_Line_Dtl_Tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

11762: := Aso_Quote_Headers_Pvt.G_MISS_Instance_Tbl;
11763:
11764: lx_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;
11765: lx_Qte_Line_Tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
11766: lx_Qte_Line_Dtl_Tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
11767: lx_Ln_Shipment_Tbl Aso_Quote_Pub.Shipment_Tbl_Type;
11768: l_debug VARCHAR2(1);
11769: BEGIN
11770:

Line 11767: lx_Ln_Shipment_Tbl Aso_Quote_Pub.Shipment_Tbl_Type;

11763:
11764: lx_Qte_Header_Rec Aso_Quote_Pub.Qte_Header_Rec_Type;
11765: lx_Qte_Line_Tbl Aso_Quote_Pub.Qte_Line_Tbl_Type;
11766: lx_Qte_Line_Dtl_Tbl Aso_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
11767: lx_Ln_Shipment_Tbl Aso_Quote_Pub.Shipment_Tbl_Type;
11768: l_debug VARCHAR2(1);
11769: BEGIN
11770:
11771: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');

11770:
11771: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
11772: IF l_debug = 'Y' THEN
11773: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
11774: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase BEGIN');
11775: ASO_QUOTE_UTIL_PVT.debug('To Set_Control_Rec_W');
11776: END IF;
11777:
11778: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(

Line 12311: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase END');

12307: --*/
12308: );
12309: IF l_debug = 'Y' THEN
12310: ASO_QUOTE_UTIL_PVT.debug('X_Return_Status '||X_Return_Status);
12311: ASO_QUOTE_UTIL_PVT.debug('Aso_Quote_Pub_W.Tradein_Lines_from_InstallBase END');
12312: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12313: END IF;
12314:
12315: EXCEPTION

Line 12690: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;

12686: )
12687: IS
12688: l_api_name VARCHAR2(255) := 'Submit_Price_Tax_Req';
12689:
12690: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
12691: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
12692:
12693: l_debug VARCHAR2(1);
12694:

Line 12691: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

12687: IS
12688: l_api_name VARCHAR2(255) := 'Submit_Price_Tax_Req';
12689:
12690: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
12691: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
12692:
12693: l_debug VARCHAR2(1);
12694:
12695: BEGIN

Line 12703: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Begins');

12699: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
12700: IF l_debug = 'Y'
12701: THEN
12702: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
12703: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Begins');
12704: END IF;
12705:
12706: -- set l_control_rec
12707: ASO_QUOTE_UTIL_PVT.Set_Control_Rec_W(

Line 12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));

12879: p_count => x_msg_count,
12880: p_data => x_msg_data);
12881:
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');

Line 12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);

12880: p_data => x_msg_data);
12881:
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));

12881:
12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;

Line 12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);

12882: IF l_debug = 'Y' THEN
12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;
12890:

Line 12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');

12883: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_request_id = '||TO_CHAR(x_request_id));
12884: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_return_status = '||x_return_status);
12885: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
12886: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req: x_msg_data = '||x_msg_data);
12887: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Submit_Price_Tax_Req Ends');
12888: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
12889: END IF;
12890:
12891: EXCEPTION

Line 13072: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

13068: x_msg_data OUT NOCOPY VARCHAR2
13069: )
13070: IS
13071: l_api_name VARCHAR2(30) := 'Cancel_Price_Tax_Req';
13072: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13073: l_debug VARCHAR2(1);
13074:
13075: BEGIN
13076:

Line 13082: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Begins');

13078:
13079: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
13080: IF l_debug = 'Y' THEN
13081: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
13082: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Begins');
13083: END IF;
13084:
13085: -- set l_quote_header_rec
13086: l_quote_header_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Header_Rec(

Line 13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);

13236: p_count => x_msg_count,
13237: p_data => x_msg_data);
13238:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));

13237: p_data => x_msg_data);
13238:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;

Line 13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);

13238:
13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;
13246:

Line 13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');

13239: IF l_debug = 'Y' THEN
13240: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_return_status = '||x_return_status);
13241: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_count = '||TO_CHAR(x_msg_count));
13242: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req: x_msg_data = '||x_msg_data);
13243: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Cancel_Price_Tax_Req Ends');
13244: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
13245: END IF;
13246:
13247: EXCEPTION

Line 13681: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type

13677: x_msg_count OUT NOCOPY NUMBER ,
13678: x_msg_data OUT NOCOPY VARCHAR2
13679: )
13680: AS
13681: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

Line 13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

13678: x_msg_data OUT NOCOPY VARCHAR2
13679: )
13680: AS
13681: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type

Line 13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type

13679: )
13680: AS
13681: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;

Line 13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

13680: AS
13681: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type

Line 13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

13681: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

Line 13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type

13682: := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type

Line 13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;

13683: l_ln_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type
13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type
13691: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;

Line 13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type

13684: := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type
13691: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
13692: l_debug VARCHAR2(1);

Line 13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

13685: lx_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type
13691: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
13692: l_debug VARCHAR2(1);
13693:

Line 13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type

13686: l_control_Rec ASO_QUOTE_PUB.Control_Rec_Type
13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type
13691: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
13692: l_debug VARCHAR2(1);
13693:
13694: BEGIN

Line 13691: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;

13687: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
13688: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
13689: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
13690: l_original_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type
13691: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
13692: l_debug VARCHAR2(1);
13693:
13694: BEGIN
13695:

Line 14483: ASO_QUOTE_UTIL_PVT.Debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Begins');

14479:
14480: l_debug := ASO_QUOTE_UTIL_PVT.Is_Debug_Enabled;
14481: IF l_debug = 'Y' THEN
14482: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
14483: ASO_QUOTE_UTIL_PVT.Debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Begins');
14484: END IF;
14485:
14486: SAVEPOINT Load_Lines_For_Display_Pvt;
14487:

Line 14859: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Ends');

14855: p_count => x_msg_count,
14856: p_data => x_msg_data);
14857:
14858: IF l_debug = 'Y' THEN
14859: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.Load_Lines_For_Display Ends');
14860: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
14861: END IF;
14862:
14863: EXCEPTION

Line 14868: ,P_PKG_NAME => 'ASO_QUOTE_PUB_W'

14864:
14865: WHEN OTHERS THEN
14866: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
14867: P_API_NAME => l_api_name
14868: ,P_PKG_NAME => 'ASO_QUOTE_PUB_W'
14869: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
14870: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
14871: ,X_MSG_COUNT => X_MSG_COUNT
14872: ,X_MSG_DATA => X_MSG_DATA

Line 15024: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

15020: )
15021: AS
15022: l_api_name CONSTANT VARCHAR2(30) := 'Assign_sales_Team';
15023: l_debug VARCHAR2(1);
15024: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

15021: AS
15022: l_api_name CONSTANT VARCHAR2(30) := 'Assign_sales_Team';
15023: l_debug VARCHAR2(1);
15024: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec

Line 15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

15022: l_api_name CONSTANT VARCHAR2(30) := 'Assign_sales_Team';
15023: l_debug VARCHAR2(1);
15024: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15030:

Line 15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec

15025: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15026: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15027: BEGIN
15028: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15029: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15030:
15031: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15032: p_quote_header_id => p_q_quote_header_id ,
15033: p_creation_date => p_q_creation_date ,

Line 15388: l_control_rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE

15384: )
15385: AS
15386: l_api_name CONSTANT VARCHAR2(30) := 'Allocate_Sales_Credits';
15387: l_debug VARCHAR2(1);
15388: l_control_rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
15389: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
15390:
15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

Line 15389: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;

15385: AS
15386: l_api_name CONSTANT VARCHAR2(30) := 'Allocate_Sales_Credits';
15387: l_debug VARCHAR2(1);
15388: l_control_rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
15389: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
15390:
15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

Line 15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

15387: l_debug VARCHAR2(1);
15388: l_control_rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
15389: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
15390:
15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

15388: l_control_rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
15389: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
15390:
15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec

Line 15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

15389: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
15390:
15391: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15397:

Line 15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec

15392: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15393: lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
15394: BEGIN
15395: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15396: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15397:
15398: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15399: p_quote_header_id => p_q_quote_header_id ,
15400: p_creation_date => p_q_creation_date ,

Line 15531: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Allocate_Sales_Credits');

15527: p_credit_update_date => p_q_credit_update_date);
15528:
15529: -- Call ASO API
15530: IF l_debug = 'Y' THEN
15531: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Allocate_Sales_Credits');
15532: END IF;
15533:
15534: ASO_QUOTE_PUB.Allocate_Sales_Credits (
15535: P_Api_Version_Number => p_api_version_number ,

Line 15534: ASO_QUOTE_PUB.Allocate_Sales_Credits (

15530: IF l_debug = 'Y' THEN
15531: ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_QUOTE_PUB.Allocate_Sales_Credits');
15532: END IF;
15533:
15534: ASO_QUOTE_PUB.Allocate_Sales_Credits (
15535: P_Api_Version_Number => p_api_version_number ,
15536: P_Init_Msg_List => P_Init_Msg_List,
15537: P_Commit => p_commit,
15538: p_Control_Rec => l_control_rec,

Line 15559: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Allocate_Sales_Credits');

15555: x_q_object_version_number := lx_qte_header_rec.object_version_number;
15556:
15557:
15558: IF l_debug = 'Y' THEN
15559: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_QUOTE_PUB.Allocate_Sales_Credits');
15560: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
15561: END IF;
15562:
15563: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 15758: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

15754: )
15755: AS
15756: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Proj_Commission';
15757: l_debug VARCHAR2(1);
15758: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15759: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15760: BEGIN
15761: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec

Line 15759: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

15755: AS
15756: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Proj_Commission';
15757: l_debug VARCHAR2(1);
15758: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15759: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15760: BEGIN
15761: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15763:

Line 15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec

15758: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
15759: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
15760: BEGIN
15761: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
15762: --build ASO_QUOTE_PUB.Qte_Header_Rec_Type by calling ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec
15763:
15764: l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
15765: p_quote_header_id => p_q_quote_header_id ,
15766: p_creation_date => p_q_creation_date ,

Line 16249: END ASO_Quote_Pub_W;

16245:
16246: END get_ou_attribute_value;
16247:
16248:
16249: END ASO_Quote_Pub_W;