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

Line 1: PACKAGE BODY ASO_Quote_Pub_W1 as

1: PACKAGE BODY ASO_Quote_Pub_W1 as
2: /* $Header: asovqw2b.pls 120.1.12010000.6 2010/04/19 04:10:11 cazhou 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_W1 as
2: /* $Header: asovqw2b.pls 120.1.12010000.6 2010/04/19 04:10:11 cazhou 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_W1 as
2: /* $Header: asovqw2b.pls 120.1.12010000.6 2010/04/19 04:10:11 cazhou 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_W2';

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_W2';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVQW2B.PLS';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;

Line 216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */

212: p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215:
216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
217: p_ql_creation_date IN jtf_date_table := NULL,
218: p_ql_created_by IN jtf_number_table := NULL,
219: p_ql_last_updated_by IN jtf_number_table := NULL,
220: p_ql_last_update_date IN jtf_date_table := NULL,

Line 295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */

291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297: p_qls_qte_line_index IN jtf_number_table := NULL,
298: p_qls_shipment_id IN jtf_number_table := NULL,
299: p_qls_creation_date IN jtf_date_table := NULL,

Line 385: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

381: )
382:
383: IS
384:
385: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
386: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
387:
388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;

Line 386: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

382:
383: IS
384:
385: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
386: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
387:
388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
390:

Line 388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type

384:
385: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
386: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
387:
388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
390:
391: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
392: := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;

Line 389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;

385: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
386: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
387:
388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
390:
391: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
392: := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
393:

Line 391: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type

387:
388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
390:
391: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
392: := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
393:
394: lx_ln_atp_tbl ASO_ATP_INT.Atp_Tbl_Typ;
395:

Line 392: := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;

388: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
390:
391: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
392: := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
393:
394: lx_ln_atp_tbl ASO_ATP_INT.Atp_Tbl_Typ;
395:
396: l_ship_site_use_id JTF_NUMBER_TABLE := NULL;

Line 901: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;

897: p_config_model_lookup_date IN DATE :=FND_API.G_MISS_DATE
898: )
899: IS
900: l_debug VARCHAR2(1);
901: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
902:
903: BEGIN
904:
905: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 912: ASO_QUOTE_PUB.validate_model_configuration

908: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
909: END IF;
910:
911:
912: ASO_QUOTE_PUB.validate_model_configuration
913: (
914: P_Api_Version_Number => 1.0,
915: P_Init_Msg_List => FND_API.G_TRUE,
916: P_Commit => FND_API.G_FALSE,

Line 939: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_quote_pub.validate_model_configuration');

935: );
936:
937: IF l_debug = 'Y'
938: THEN
939: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_quote_pub.validate_model_configuration');
940: ASO_QUOTE_UTIL_PVT.Debug('x_return_status:'|| x_return_status);
941: ASO_QUOTE_UTIL_PVT.Debug('x_return_status:'|| x_msg_data);
942: END IF;
943: END Validate_Model_Configuration;

Line 1601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

1597:
1598: l_copy_qte_hdr_rec ASO_Copy_Quote_Pub.Copy_Quote_Header_Rec_Type
1599: := ASO_Copy_Quote_Pub.G_Miss_Copy_Quote_Header_Rec;
1600:
1601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

Line 1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

1598: l_copy_qte_hdr_rec ASO_Copy_Quote_Pub.Copy_Quote_Header_Rec_Type
1599: := ASO_Copy_Quote_Pub.G_Miss_Copy_Quote_Header_Rec;
1600:
1601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type

1599: := ASO_Copy_Quote_Pub.G_Miss_Copy_Quote_Header_Rec;
1600:
1601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type

Line 1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

1600:
1601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;

Line 1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type

1601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

1602: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

Line 1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type

1603: l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;

1604: := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

Line 1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type

1605: l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

Line 1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

1606: := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1614: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

Line 1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type

1607: l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1614: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1615:

Line 1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

1608: := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1614: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1615:
1616: l_debug VARCHAR2(1);

Line 1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type

1609: l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1614: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1615:
1616: l_debug VARCHAR2(1);
1617:

Line 1614: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

1610: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611: l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612: := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613: l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1614: := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1615:
1616: l_debug VARCHAR2(1);
1617:
1618: BEGIN

Line 1642: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_from_quote(+)');

1638: -- initialize API return status to success
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641: IF l_debug = 'Y' THEN
1642: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_from_quote(+)');
1643: END IF;
1644:
1645: -- begin API body
1646:

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

2329: COMMIT WORK;
2330: END IF;
2331:
2332: IF l_debug = 'Y' THEN
2333: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
2334: END IF;
2335: -- standard call to get message count and if count is 1, get message info.
2336: FND_MSG_PUB.Count_And_Get
2337: ( p_encoded => FND_API.G_FALSE,

Line 2395: END ASO_Quote_Pub_W1;

2391: END IF;
2392:
2393: END Copy_From_Quote;
2394:
2395: END ASO_Quote_Pub_W1;