APPS.ASO_COPY_TMPL_PUB dependencies on ASO_QUOTE_PUB

Line 58: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

54:
55: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Quote_To_Tmpl';
56: l_api_version_number CONSTANT NUMBER := 1.0;
57: l_return_status VARCHAR2 ( 1 );
58: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
59: l_qte_num NUMBER;
60: l_quote_name varchar2(2000);
61: l_currency_code varchar2(15);
62: l_price_list_id number;

Line 67: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;

63: l_order_type_id number;
64: l_quote_category_code varchar2(240);
65:
66: -- ER 3177722
67: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
68: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
69:
70:
71: begin

Line 242: , P_Control_Rec => ASO_QUOTE_PUB.G_MISS_Control_Rec

238: , P_Commit => FND_API.G_FALSE
239: , P_qte_Header_Id => P_old_quote_header_Id
240: , P_new_qte_header_id => x_qte_header_id
241: --, P_Qte_Header_Rec => l_copy_line_qte_header_rec
242: , P_Control_Rec => ASO_QUOTE_PUB.G_MISS_Control_Rec
243: , X_Return_Status => l_return_status
244: , X_Msg_Count => x_msg_count
245: , X_Msg_Data => x_msg_data
246: );

Line 256: aso_debug_pub.add('Copy_template -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');

252:
253:
254: if l_copy_config_profile='N' then
255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
256: aso_debug_pub.add('Copy_template -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');
257: end if;
258:
259: ASO_QUOTE_PUB.validate_model_configuration
260: (

Line 259: ASO_QUOTE_PUB.validate_model_configuration

255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
256: aso_debug_pub.add('Copy_template -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');
257: end if;
258:
259: ASO_QUOTE_PUB.validate_model_configuration
260: (
261: P_Api_Version_Number => 1.0,
262: P_Init_Msg_List => FND_API.G_FALSE,
263: P_Commit => FND_API.G_FALSE,

Line 279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');

275: commit work;
276: end if;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
281: END IF;
282:
283: end if; -- profile

Line 280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');

276: end if;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
281: END IF;
282:
283: end if; -- profile
284: end if; -- success

Line 309: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type

305: PROCEDURE Copy_Tmpl_Header (
306: P_Api_Version_Number IN NUMBER
307: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
308: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
309: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
310: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
311: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
312: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
313: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 323: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;

319: l_api_version_number CONSTANT NUMBER := 1.0;
320:
321:
322: -- out tables parameters
323: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

320:
321:
322: -- out tables parameters
323: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

321:
322: -- out tables parameters
323: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

322: -- out tables parameters
323: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

323: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

324: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

325: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;

326: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
334: l_qte_access_tbl_out aso_quote_pub.qte_access_tbl_type ;

Line 331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

327: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
334: l_qte_access_tbl_out aso_quote_pub.qte_access_tbl_type ;
335:

Line 332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

328: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
334: l_qte_access_tbl_out aso_quote_pub.qte_access_tbl_type ;
335:
336:

Line 333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

329: l_hd_Price_Adj_Tbl_out ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
334: l_qte_access_tbl_out aso_quote_pub.qte_access_tbl_type ;
335:
336:
337:

Line 334: l_qte_access_tbl_out aso_quote_pub.qte_access_tbl_type ;

330: l_shipment_rec_out ASO_QUOTE_PUB.Shipment_Rec_Type;
331: l_hd_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
332: l_Sales_Credit_Tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
333: l_Quote_Party_Tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
334: l_qte_access_tbl_out aso_quote_pub.qte_access_tbl_type ;
335:
336:
337:
338: begin

Line 373: , p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl

369: --
370:
371: ASO_QUOTE_HEADERS_PVT.Insert_Rows (
372: p_qte_header_rec => P_Qte_Header_Rec
373: , p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl
374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL

Line 374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL

370:
371: ASO_QUOTE_HEADERS_PVT.Insert_Rows (
372: p_qte_header_rec => P_Qte_Header_Rec
373: , p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl
374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl

Line 375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL

371: ASO_QUOTE_HEADERS_PVT.Insert_Rows (
372: p_qte_header_rec => P_Qte_Header_Rec
373: , p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl
374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl

Line 376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL

372: p_qte_header_rec => P_Qte_Header_Rec
373: , p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl
374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL

Line 377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL

373: , p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl
374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl

Line 378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl

374: , P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl

Line 379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl

375: , P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl
383: , P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL

Line 380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL

376: , P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl
383: , P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL
384: , x_qte_header_rec => l_qte_header_rec_out

Line 381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl

377: , P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl
383: , P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL
384: , x_qte_header_rec => l_qte_header_rec_out
385: , x_Price_Attributes_Tbl => l_price_attr_tbl_out

Line 382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl

378: , P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl
383: , P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL
384: , x_qte_header_rec => l_qte_header_rec_out
385: , x_Price_Attributes_Tbl => l_price_attr_tbl_out
386: , x_Price_Adjustment_Tbl => l_hd_Price_Adj_Tbl_out

Line 383: , P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL

379: , P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
380: , P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
381: , P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
382: , P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl
383: , P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL
384: , x_qte_header_rec => l_qte_header_rec_out
385: , x_Price_Attributes_Tbl => l_price_attr_tbl_out
386: , x_Price_Adjustment_Tbl => l_hd_Price_Adj_Tbl_out
387: , x_Price_Adj_Attr_Tbl => l_price_adj_attr_tbl_out

Line 435: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

431: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
432: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
433: P_Qte_Header_Id IN NUMBER,
434: P_New_Qte_Header_Id IN NUMBER,
435: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
436: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
437: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
438: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
439: as

Line 471: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

467: SELECT shipment_id
468: FROM ASO_SHIPMENTS
469: WHERE quote_line_id = lc_line_id;
470:
471: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

468: FROM ASO_SHIPMENTS
469: WHERE quote_line_id = lc_line_id;
470:
471: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

469: WHERE quote_line_id = lc_line_id;
470:
471: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

470:
471: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

471: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

472: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

473: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

474: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

475: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

476: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

477: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
485: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

478: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
485: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
486:

Line 483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

479: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
485: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
486:
487: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

Line 484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

480: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
485: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
486:
487: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
488: l_qte_line_id NUMBER;

Line 485: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

481: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
482: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
483: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
484: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
485: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
486:
487: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
488: l_qte_line_id NUMBER;
489: l_index NUMBER;

Line 500: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

496: l_config_hdr_id NUMBER;
497: l_config_rev_nbr NUMBER;
498: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
499: LX_LINE_RELATIONSHIP_ID NUMBER;
500: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

497: l_config_rev_nbr NUMBER;
498: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
499: LX_LINE_RELATIONSHIP_ID NUMBER;
500: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

498: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
499: LX_LINE_RELATIONSHIP_ID NUMBER;
500: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

499: LX_LINE_RELATIONSHIP_ID NUMBER;
500: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
507: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

500: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
507: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
508: l_api_version CONSTANT NUMBER := 1.0;

Line 505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

501: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
507: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
508: l_api_version CONSTANT NUMBER := 1.0;
509: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';

Line 506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

502: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
507: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
508: l_api_version CONSTANT NUMBER := 1.0;
509: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
510: l_service_item_flag VARCHAR2 ( 1 );

Line 507: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

503: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
504: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
505: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
506: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
507: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
508: l_api_version CONSTANT NUMBER := 1.0;
509: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
510: l_service_item_flag VARCHAR2 ( 1 );
511: l_serviceable_product_flag VARCHAR2 ( 1 );

Line 522: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

518: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
519: -- hyang: for bug 2692785
520: lx_status VARCHAR2(1);
521:
522: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
523:
524: --- New Code added for Copy Quote Line Functionality
525:
526: CURSOR C_Validate_Quote_Line (

Line 555: x_qte_header_rec aso_quote_pub.qte_header_rec_type;

551: l_line_number NUMBER;
552:
553:
554:
555: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

Line 556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

552:
553:
554:
555: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

553:
554:
555: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

554:
555: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

555: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

Line 560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

556: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

Line 561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

557: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

Line 562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

558: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

Line 563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

559: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

Line 564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

560: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

Line 565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

561: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

Line 566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

562: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

563: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

564: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

565: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

Line 570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

566: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:

Line 571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

567: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

568: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

569: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
570: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

571: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

572: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

573: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

574:
575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

575: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

576: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

577: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
585: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;

Line 582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

578: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
585: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
586:

Line 583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

579: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
585: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
586:
587: l_copy_flag varchar2(1):='T';

Line 584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

580: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
585: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
586:
587: l_copy_flag varchar2(1):='T';
588:

Line 907: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

903: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
904: , P_price_attributes_tbl => l_price_attr_tbl
905: , P_Price_Adj_Tbl => l_price_adj_tbl
906: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
907: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
908: , P_Shipment_Tbl => l_shipment_tbl
909: , P_Freight_Charge_Tbl => l_freight_charge_tbl
910: , P_Tax_Detail_Tbl => l_tax_detail_tbl
911: , P_Sales_Credit_Tbl => l_sales_credit_tbl

Line 1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1221: FROM aso_line_relationships
1222: WHERE quote_line_id = qte_ln_id
1223: AND relationship_type_code = 'SERVICE';
1224:
1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1222: WHERE quote_line_id = qte_ln_id
1223: AND relationship_type_code = 'SERVICE';
1224:
1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1223: AND relationship_type_code = 'SERVICE';
1224:
1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

1224:
1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1226: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1227: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1228: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1229: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1230: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1231: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;

Line 1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1232: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1240: LX_LINE_RELATIONSHIP_ID NUMBER;

Line 1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1233: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1240: LX_LINE_RELATIONSHIP_ID NUMBER;
1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

1234: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1235: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1236: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1240: LX_LINE_RELATIONSHIP_ID NUMBER;
1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1237: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1240: LX_LINE_RELATIONSHIP_ID NUMBER;
1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1238: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1240: LX_LINE_RELATIONSHIP_ID NUMBER;
1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1239: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1240: LX_LINE_RELATIONSHIP_ID NUMBER;
1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1240: LX_LINE_RELATIONSHIP_ID NUMBER;
1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1248: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1241: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1248: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1249: l_service_ref_line_id NUMBER;

Line 1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

1242: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1248: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1249: l_service_ref_line_id NUMBER;
1250: l_return_status VARCHAR2 ( 1 );

Line 1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1243: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1248: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1249: l_service_ref_line_id NUMBER;
1250: l_return_status VARCHAR2 ( 1 );
1251: qte_line_id NUMBER;

Line 1248: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

1244: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1245: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1246: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1247: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1248: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1249: l_service_ref_line_id NUMBER;
1250: l_return_status VARCHAR2 ( 1 );
1251: qte_line_id NUMBER;
1252: i NUMBER;

Line 1264: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1260: WHERE quote_line_id = x_qte_line_id ;
1261:
1262: l_line_number NUMBER;
1263:
1264: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1261:
1262: l_line_number NUMBER;
1263:
1264: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1262: l_line_number NUMBER;
1263:
1264: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

1263:
1264: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

1264: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

1265: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1266: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1274:

Line 1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1267: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1274:
1275: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1268: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1274:
1275: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1276:

Line 1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1269: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1274:
1275: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1276:
1277:

Line 1275: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1271: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1272: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1273: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1274:
1275: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1276:
1277:
1278: BEGIN
1279:

Line 1492: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

1488: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
1489: , P_price_attributes_tbl => l_price_attr_tbl
1490: , P_Price_Adj_Tbl => l_price_adj_tbl
1491: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
1492: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
1493: , P_Shipment_Tbl => l_shipment_tbl
1494: , P_Freight_Charge_Tbl => l_freight_charge_tbl
1495: , P_Tax_Detail_Tbl => l_tax_detail_tbl
1496: , P_Sales_Credit_Tbl => l_sales_credit_tbl

Line 1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1584: FROM MTL_SYSTEM_ITEMS_VL
1585: WHERE inventory_item_id = l_inv_item_id
1586: AND organization_id = l_organization_id;
1587:
1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1585: WHERE inventory_item_id = l_inv_item_id
1586: AND organization_id = l_organization_id;
1587:
1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1586: AND organization_id = l_organization_id;
1587:
1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

1587:
1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1589: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1590: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1591: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1592: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1593: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1594: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;

Line 1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1595: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1603: LX_LINE_RELATIONSHIP_ID NUMBER;

Line 1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1596: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1603: LX_LINE_RELATIONSHIP_ID NUMBER;
1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

1597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1598: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1599: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1603: LX_LINE_RELATIONSHIP_ID NUMBER;
1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1600: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1603: LX_LINE_RELATIONSHIP_ID NUMBER;
1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1601: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1603: LX_LINE_RELATIONSHIP_ID NUMBER;
1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1602: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1603: LX_LINE_RELATIONSHIP_ID NUMBER;
1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1603: LX_LINE_RELATIONSHIP_ID NUMBER;
1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1611: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1604: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1611: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1612: l_return_status VARCHAR2 ( 1 );

Line 1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

1605: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1611: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1612: l_return_status VARCHAR2 ( 1 );
1613: qte_line_id NUMBER;

Line 1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1606: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1611: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1612: l_return_status VARCHAR2 ( 1 );
1613: qte_line_id NUMBER;
1614: i NUMBER;

Line 1611: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

1607: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1608: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1609: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1610: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1611: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1612: l_return_status VARCHAR2 ( 1 );
1613: qte_line_id NUMBER;
1614: i NUMBER;
1615: j NUMBER;

Line 1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1643: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1644: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
1646:
1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1644: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
1646:
1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
1646:
1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

1646:
1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

1648: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1649: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1657:

Line 1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1650: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1657:
1658: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1651: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1657:
1658: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1659:

Line 1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1652: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1657:
1658: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1659:
1660:

Line 1658: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1654: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1655: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1656: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1657:
1658: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1659:
1660:
1661: BEGIN
1662:

Line 1903: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

1899: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
1900: , P_price_attributes_tbl => l_price_attr_tbl
1901: , P_Price_Adj_Tbl => l_price_adj_tbl
1902: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
1903: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
1904: , P_Shipment_Tbl => l_shipment_tbl
1905: , P_Freight_Charge_Tbl => l_freight_charge_tbl
1906: , P_Tax_Detail_Tbl => l_tax_detail_tbl
1907: , P_Sales_Credit_Tbl => l_sales_credit_tbl