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

Line 19: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

15:
16:
17: PROCEDURE Validate_Line_Tradein(
18: p_init_msg_list IN VARCHAR2,
19: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
20: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
21: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
23: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 20: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

16:
17: PROCEDURE Validate_Line_Tradein(
18: p_init_msg_list IN VARCHAR2,
19: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
20: P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
21: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
23: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
24: IS

Line 232: p_qte_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,

228:
229:
230: PROCEDURE OrderType(
231: p_init_msg_list IN VARCHAR2,
232: p_qte_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
233: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
234: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
235: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
236: IS

Line 320: p_qte_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,

316:
317:
318: PROCEDURE LineType(
319: p_init_msg_list IN VARCHAR2,
320: p_qte_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
321: p_qte_line_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
322: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
323: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
324: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 321: p_qte_line_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,

317:
318: PROCEDURE LineType(
319: p_init_msg_list IN VARCHAR2,
320: p_qte_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
321: p_qte_line_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
322: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
323: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
324: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
325: IS

Line 418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type

414: P_Api_Version_Number IN NUMBER,
415: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
416: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type

Line 419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,

415: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
416: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,

Line 420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

416: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,
424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,
424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
425: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,
424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
425: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
426: X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
427: X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
428: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 425: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,
424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
425: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
426: X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
427: X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
428: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
429: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 426: X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

422: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,
424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
425: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
426: X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
427: X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
428: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
429: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
430: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 427: X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,

423: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl,
424: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
425: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
426: X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
427: X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
428: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
429: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
430: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
431: )

Line 476: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

472: l_Cur_Child C_Get_Item_Details%ROWTYPE;
473: l_used_inst_tbl ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
474: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl;
475:
476: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

473: l_used_inst_tbl ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type
474: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl;
475:
476: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

474: := ASO_QUOTE_HEADERS_PVT.G_MISS_Instance_Tbl;
475:
476: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

475:
476: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

476: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

477: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

478: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

479: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

480: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

481: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

482: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

483: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

484: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

485: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

486: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

487: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

488: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

489: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

490: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
498: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

491: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
498: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
499:

Line 496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

492: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
498: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
499:
500: l_used VARCHAR2(1);

Line 497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

493: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
498: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
499:
500: l_used VARCHAR2(1);
501: j NUMBER := 0;

Line 498: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

494: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
495: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
496: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
497: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
498: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
499:
500: l_used VARCHAR2(1);
501: j NUMBER := 0;
502: l_org_id NUMBER;

Line 511: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec;

507: l_api_name CONSTANT VARCHAR2(45) := 'Add_Lines_from_InstallBase';
508: -- 2929469
509: l_organization_id NUMBER;
510:
511: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec;
512: l_prof_val varchar2(240);
513:
514: BEGIN
515:

Line 818: aso_debug_pub.add('Add_Lines_from_InstallBase - calling ASO_QUOTE_PUB.Update_Quote: ', 1, 'N');

814: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;
815: end if;
816:
817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
818: aso_debug_pub.add('Add_Lines_from_InstallBase - calling ASO_QUOTE_PUB.Update_Quote: ', 1, 'N');
819: END IF;
820:
821: ASO_QUOTE_PUB.Update_Quote(
822: p_api_version_number => 1.0,

Line 821: ASO_QUOTE_PUB.Update_Quote(

817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
818: aso_debug_pub.add('Add_Lines_from_InstallBase - calling ASO_QUOTE_PUB.Update_Quote: ', 1, 'N');
819: END IF;
820:
821: ASO_QUOTE_PUB.Update_Quote(
822: p_api_version_number => 1.0,
823: p_init_msg_list => p_init_msg_list,
824: p_commit => p_commit,
825: p_control_rec => l_control_rec,

Line 925: p_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

921:
922:
923: PROCEDURE Validate_IB_Return_Qty(
924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
925: p_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
926: p_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type,
927: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
928: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
929: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 926: p_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type,

922:
923: PROCEDURE Validate_IB_Return_Qty(
924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
925: p_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
926: p_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type,
927: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
928: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
929: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
930: