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.IBE_QUOTE_W1_PVT dependencies on ASO_QUOTE_PUB

Line 61: RETURN ASO_Quote_Pub.Payment_Tbl_Type

57: p_attribute15 IN jtf_varchar2_table_200 ,
58: p_assignment_id IN jtf_number_table ,
59: p_cvv2 IN jtf_varchar2_table_200
60: )
61: RETURN ASO_Quote_Pub.Payment_Tbl_Type
62: IS
63: l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;
64: l_table_size PLS_INTEGER := 0;
65: i PLS_INTEGER;

Line 63: l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;

59: p_cvv2 IN jtf_varchar2_table_200
60: )
61: RETURN ASO_Quote_Pub.Payment_Tbl_Type
62: IS
63: l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;
64: l_table_size PLS_INTEGER := 0;
65: i PLS_INTEGER;
66: BEGIN
67: --To determine the table size

Line 261: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,

257: END IF;
258: END Construct_Payment_Tbl;
259:
260: PROCEDURE Set_Order_Header_Out_W(
261: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,
262: x_order_number OUT NOCOPY NUMBER ,
263: x_order_header_id OUT NOCOPY NUMBER ,
264: x_order_request_id OUT NOCOPY NUMBER ,
265: x_contract_id OUT NOCOPY NUMBER ,

Line 312: x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type

308: p_sc_reserve_flag IN VARCHAR2 := FND_API.G_FALSE,
309: p_sc_calculate_price IN VARCHAR2 := FND_API.G_FALSE,
310: p_sc_server_id IN NUMBER := -1 ,
311: p_sc_cc_by_fax IN VARCHAR2 := FND_API.G_FALSE,
312: x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type
313: )
314: IS
315: BEGIN
316: x_submit_control_rec.book_flag := p_sc_book_flag;

Line 338: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type

334: p_c_line_pricing_event VARCHAR2,
335: p_c_cal_tax_flag VARCHAR2,
336: p_c_cal_freight_charge_flag VARCHAR2,
337: p_c_price_mode VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
338: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
339: )
340: IS
341: BEGIN
342: IF p_c_last_update_date = ROSETTA_G_MISTAKE_DATE THEN

Line 376: RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type

372: p_price_adj_index IN jtf_number_table ,
373: p_rltd_price_adj_id IN jtf_number_table ,
374: p_rltd_price_adj_index IN jtf_number_table
375: )
376: RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
377: IS
378: l_price_adj_rltship_tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
379: l_table_size PLS_INTEGER := 0;
380: i PLS_INTEGER;

Line 378: l_price_adj_rltship_tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

374: p_rltd_price_adj_index IN jtf_number_table
375: )
376: RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
377: IS
378: l_price_adj_rltship_tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
379: l_table_size PLS_INTEGER := 0;
380: i PLS_INTEGER;
381: BEGIN
382: IF p_operation_code IS NOT NULL THEN

Line 562: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

558: p_proration_type_code IN jtf_varchar2_table_100 ,
559: p_include_on_ret_flag IN jtf_varchar2_table_100 ,
560: p_credit_or_charge_flag IN jtf_varchar2_table_100
561: )
562: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
563: IS
564: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
565: l_table_size PLS_INTEGER := 0;
566: i PLS_INTEGER;

Line 564: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

560: p_credit_or_charge_flag IN jtf_varchar2_table_100
561: )
562: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
563: IS
564: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
565: l_table_size PLS_INTEGER := 0;
566: i PLS_INTEGER;
567: BEGIN
568: IF p_operation_code IS NOT NULL THEN

Line 798: RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type

794: p_pricing_attr_value_to IN jtf_varchar2_table_300 ,
795: p_comparison_operator IN jtf_varchar2_table_100 ,
796: p_flex_title IN jtf_varchar2_table_100
797: )
798: RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
799: IS
800: l_price_adj_attr_tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
801: l_table_size PLS_INTEGER := 0;
802: i PLS_INTEGER;

Line 800: l_price_adj_attr_tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

796: p_flex_title IN jtf_varchar2_table_100
797: )
798: RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
799: IS
800: l_price_adj_attr_tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
801: l_table_size PLS_INTEGER := 0;
802: i PLS_INTEGER;
803: BEGIN
804: IF p_operation_code IS NOT NULL THEN

Line 915: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type

911: p_start_date_active IN jtf_date_table ,
912: p_end_date_active IN jtf_date_table ,
913: p_operation_code IN jtf_varchar2_table_100
914: )
915: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
916: IS
917: l_line_attribs_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
918: l_table_size PLS_INTEGER := 0;
919: i PLS_INTEGER;

Line 917: l_line_attribs_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

913: p_operation_code IN jtf_varchar2_table_100
914: )
915: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
916: IS
917: l_line_attribs_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
918: l_table_size PLS_INTEGER := 0;
919: i PLS_INTEGER;
920: BEGIN
921: IF p_operation_code IS NOT NULL THEN

Line 1065: RETURN ASO_Quote_Pub.Freight_Charge_Tbl_Type

1061: p_attribute13 IN jtf_varchar2_table_200 ,
1062: p_attribute14 IN jtf_varchar2_table_200 ,
1063: p_attribute15 IN jtf_varchar2_table_200
1064: )
1065: RETURN ASO_Quote_Pub.Freight_Charge_Tbl_Type
1066: IS
1067: l_freight_charge_tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
1068: l_table_size PLS_INTEGER := 0;
1069: i PLS_INTEGER;

Line 1067: l_freight_charge_tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

1063: p_attribute15 IN jtf_varchar2_table_200
1064: )
1065: RETURN ASO_Quote_Pub.Freight_Charge_Tbl_Type
1066: IS
1067: l_freight_charge_tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
1068: l_table_size PLS_INTEGER := 0;
1069: i PLS_INTEGER;
1070: BEGIN
1071: IF p_operation_code IS NOT NULL THEN

Line 1315: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type

1311: p_attribute13 IN jtf_varchar2_table_300 ,
1312: p_attribute14 IN jtf_varchar2_table_300 ,
1313: p_attribute15 IN jtf_varchar2_table_300
1314: )
1315: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type
1316: IS
1317: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1318: l_table_size PLS_INTEGER := 0;
1319: i PLS_INTEGER;

Line 1317: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

1313: p_attribute15 IN jtf_varchar2_table_300
1314: )
1315: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type
1316: IS
1317: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1318: l_table_size PLS_INTEGER := 0;
1319: i PLS_INTEGER;
1320: BEGIN
1321: IF p_operation_code IS NOT NULL THEN

Line 1585: RETURN ASO_Quote_Pub.Shipment_Rec_Type

1581: p_attribute13 IN VARCHAR2 ,
1582: p_attribute14 IN VARCHAR2 ,
1583: p_attribute15 IN VARCHAR2
1584: )
1585: RETURN ASO_Quote_Pub.Shipment_Rec_Type
1586: IS
1587: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1588: BEGIN
1589:

Line 1587: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;

1583: p_attribute15 IN VARCHAR2
1584: )
1585: RETURN ASO_Quote_Pub.Shipment_Rec_Type
1586: IS
1587: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
1588: BEGIN
1589:
1590: l_shipment_rec.operation_code := p_operation_code;
1591: IF p_qte_line_index = ROSETTA_G_MISS_NUM THEN

Line 1822: RETURN ASO_Quote_Pub.Shipment_Tbl_Type

1818: p_attribute13 IN jtf_varchar2_table_200 ,
1819: p_attribute14 IN jtf_varchar2_table_200 ,
1820: p_attribute15 IN jtf_varchar2_table_200
1821: )
1822: RETURN ASO_Quote_Pub.Shipment_Tbl_Type
1823: IS
1824: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1825: l_table_size PLS_INTEGER := 0;
1826: i PLS_INTEGER;

Line 1824: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;

1820: p_attribute15 IN jtf_varchar2_table_200
1821: )
1822: RETURN ASO_Quote_Pub.Shipment_Tbl_Type
1823: IS
1824: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;
1825: l_table_size PLS_INTEGER := 0;
1826: i PLS_INTEGER;
1827: BEGIN
1828: IF p_quote_header_id IS NOT NULL THEN

Line 2147: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type

2143: p_attribute13 IN jtf_varchar2_table_200 ,
2144: p_attribute14 IN jtf_varchar2_table_200 ,
2145: p_attribute15 IN jtf_varchar2_table_200
2146: )
2147: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type
2148: IS
2149: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
2150: l_table_size PLS_INTEGER := 0;
2151: i PLS_INTEGER;

Line 2149: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

2145: p_attribute15 IN jtf_varchar2_table_200
2146: )
2147: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type
2148: IS
2149: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
2150: l_table_size PLS_INTEGER := 0;
2151: i PLS_INTEGER;
2152: BEGIN
2153: IF p_quote_header_id IS NOT NULL THEN

Line 2442: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type

2438: p_end_customer_cust_account_id IN NUMBER ,
2439: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
2440: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
2441: )
2442: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
2443: IS
2444: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
2445: BEGIN
2446: IF p_quote_header_id= ROSETTA_G_MISS_NUM THEN

Line 2444: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;

2440: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
2441: )
2442: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
2443: IS
2444: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
2445: BEGIN
2446: IF p_quote_header_id= ROSETTA_G_MISS_NUM THEN
2447: l_qte_header.quote_header_id := FND_API.G_MISS_NUM;
2448: ELSE

Line 2838: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type

2834: p_end_customer_cust_party_id IN jtf_number_table ,
2835: p_end_customer_party_site_id IN jtf_number_table ,
2836: p_end_customer_cust_account_id IN jtf_number_table
2837: )
2838: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
2839: IS
2840: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2841: l_table_size PLS_INTEGER := 0;
2842: i PLS_INTEGER;

Line 2840: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

2836: p_end_customer_cust_account_id IN jtf_number_table
2837: )
2838: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
2839: IS
2840: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2841: l_table_size PLS_INTEGER := 0;
2842: i PLS_INTEGER;
2843: BEGIN
2844: --To determine the table size

Line 3146: RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_TBL; --empty qte_line arrays passed in

3142: END LOOP; --end of loop around the column arrays
3143:
3144: RETURN l_qte_line_tbl;
3145: ELSE
3146: RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_TBL; --empty qte_line arrays passed in
3147: END IF; --end if for l_table_size>0
3148: END Construct_Qte_Line_Tbl;
3149:
3150:

Line 3223: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type

3219: p_qte_line_index IN jtf_number_table ,
3220: p_return_attr_category IN jtf_varchar2_table_100 ,
3221: p_return_reason_code IN jtf_varchar2_table_100
3222: )
3223: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
3224: IS
3225: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
3226: l_table_size PLS_INTEGER := 0;
3227: i PLS_INTEGER;

Line 3225: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

3221: p_return_reason_code IN jtf_varchar2_table_100
3222: )
3223: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
3224: IS
3225: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
3226: l_table_size PLS_INTEGER := 0;
3227: i PLS_INTEGER;
3228: BEGIN
3229: IF p_quote_line_detail_id IS NOT NULL THEN

Line 3447: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type

3443: p_qte_line_index IN jtf_number_table ,
3444: p_related_qte_line_index IN jtf_number_table ,
3445: p_operation_code IN jtf_varchar2_table_100
3446: )
3447: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
3448: IS
3449: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
3450: l_table_size PLS_INTEGER := 0;
3451: i PLS_INTEGER;

Line 3449: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

3445: p_operation_code IN jtf_varchar2_table_100
3446: )
3447: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
3448: IS
3449: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
3450: l_table_size PLS_INTEGER := 0;
3451: i PLS_INTEGER;
3452:
3453: BEGIN

Line 4601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

4597: p_qlfc_attribute14 IN jtf_varchar2_table_200 := NULL,
4598: p_qlfc_attribute15 IN jtf_varchar2_table_200 := NULL
4599: )
4600: IS
4601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;

Line 4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

4598: p_qlfc_attribute15 IN jtf_varchar2_table_200 := NULL
4599: )
4600: IS
4601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;

Line 4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;

4599: )
4600: IS
4601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;

Line 4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;

4600: IS
4601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;

Line 4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;

4601: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;

Line 4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;

4602: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;

Line 4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;

4603: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;
4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;

Line 4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;

4604: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;
4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;

4605: l_control_rec ASO_Quote_Pub.Control_Rec_Type;
4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;

4606: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

Line 4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;

4607: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;
4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

Line 4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

4608: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

Line 4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

4609: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;
4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

Line 4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

4610: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

4611: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;
4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

Line 4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

4612: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
4620:

Line 4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

4613: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
4620:
4621: -- 4/23/02: changed

Line 4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

4614: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
4620:
4621: -- 4/23/02: changed
4622: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

Line 4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

4615: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;
4616: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;
4617: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
4620:
4621: -- 4/23/02: changed
4622: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4623: l_save_type VARCHAR2(100) := 'SAVE_ADDTOCART';

Line 4622: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

4618: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
4619: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
4620:
4621: -- 4/23/02: changed
4622: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
4623: l_save_type VARCHAR2(100) := 'SAVE_ADDTOCART';
4624:
4625: BEGIN
4626:

Line 4828: l_qte_line_tbl := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

4824: p_end_customer_cust_party_id => p_ql_end_cust_cust_party_id ,
4825: p_end_customer_party_site_id => p_ql_end_cust_party_site_id ,
4826: p_end_customer_cust_account_id => p_ql_end_cust_cust_account_id);
4827: ELSE
4828: l_qte_line_tbl := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
4829: END IF;
4830:
4831: IF p_qdl_quote_line_detail_id IS NOT NULL AND p_qdl_quote_line_detail_id.COUNT > 0 THEN
4832: l_qte_line_dtl_tbl := Construct_Qte_Line_Dtl_Tbl(

Line 4904: l_qte_line_dtl_tbl := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

4900: p_qte_line_index => p_qdl_qte_line_index ,
4901: p_return_attr_category => p_qdl_return_attr_category ,
4902: p_return_reason_code => p_qdl_return_reason_code);
4903: ELSE
4904: l_qte_line_dtl_tbl := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
4905: END IF;
4906:
4907:
4908: IF p_qrl_line_relationship_id IS NOT NULL AND p_qrl_line_relationship_id.COUNT > 0 THEN

Line 4928: l_line_rltship_tbl := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;

4924: p_qte_line_index => p_qrl_qte_line_index ,
4925: p_related_qte_line_index => p_qrl_related_qte_line_index,
4926: p_operation_code => p_qrl_operation_code);
4927: ELSE
4928: l_line_rltship_tbl := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;
4929: END IF;
4930:
4931: IF p_qp_quote_header_id IS NOT NULL AND p_qp_quote_header_id.COUNT > 0 THEN
4932: -- set header payment tbl

Line 4978: l_Hd_Payment_Tbl := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

4974: p_attribute15 => p_qp_attribute15 ,
4975: p_assignment_id => p_qp_assignment_id ,
4976: p_cvv2 => p_qp_cvv2 );
4977: ELSE
4978: l_Hd_Payment_Tbl := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
4979: END IF;
4980:
4981: IF p_qlp_quote_header_id IS NOT NULL AND p_qlp_quote_header_id.COUNT > 0 THEN
4982: -- set line payment tbl

Line 5028: l_ln_Payment_Tbl := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

5024: p_attribute15 => p_qlp_attribute15 ,
5025: p_assignment_id => null ,
5026: p_cvv2 => null);
5027: ELSE
5028: l_ln_Payment_Tbl := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
5029: END IF;
5030:
5031: IF p_qt_quote_header_id IS NOT NULL AND p_qt_quote_header_id.COUNT > 0 THEN
5032: -- set header tax detail

Line 5075: l_Hd_Tax_Detail_Tbl := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

5071: p_attribute13 => p_qt_attribute13 ,
5072: p_attribute14 => p_qt_attribute14 ,
5073: p_attribute15 => p_qt_attribute15);
5074: ELSE
5075: l_Hd_Tax_Detail_Tbl := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5076: END IF;
5077:
5078: IF p_qlt_quote_header_id IS NOT NULL AND p_qlt_quote_header_id.COUNT > 0 THEN
5079: -- set line tax detail

Line 5122: l_ln_tax_detail_tbl := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

5118: p_attribute13 => p_qlt_attribute13 ,
5119: p_attribute14 => p_qlt_attribute14 ,
5120: p_attribute15 => p_qlt_attribute15);
5121: ELSE
5122: l_ln_tax_detail_tbl := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
5123: END IF;
5124:
5125: IF p_qs_quote_header_id IS NOT NULL AND p_qs_quote_header_id.COUNT > 0 THEN
5126: -- set header shipment

Line 5193: l_hd_shipment_tbl := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

5189: p_attribute13 => p_qs_attribute13 ,
5190: p_attribute14 => p_qs_attribute14 ,
5191: p_attribute15 => p_qs_attribute15);
5192: ELSE
5193: l_hd_shipment_tbl := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5194: END IF;
5195:
5196: IF p_qls_quote_header_id IS NOT NULL AND p_qls_quote_header_id.COUNT > 0 THEN
5197: -- set line shipment

Line 5264: l_ln_shipment_tbl := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

5260: p_attribute13 => p_qls_attribute13 ,
5261: p_attribute14 => p_qls_attribute14 ,
5262: p_attribute15 => p_qls_attribute15);
5263: ELSE
5264: l_ln_shipment_tbl := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
5265: END IF;
5266:
5267: IF p_qpa_operation_code IS NOT NULL AND p_qpa_operation_code.COUNT >0 THEN
5268: -- set header price attribute

Line 5403: l_hd_price_attributes_tbl := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

5399: p_attribute13 => p_qpa_attribute13 ,
5400: p_attribute14 => p_qpa_attribute14 ,
5401: p_attribute15 => p_qpa_attribute15);
5402: ELSE
5403: l_hd_price_attributes_tbl := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5404: END IF;
5405:
5406: IF p_qlpa_operation_code IS NOT NULL AND p_qlpa_operation_code.COUNT > 0 THEN
5407: -- set line price attribute

Line 5542: l_ln_price_attributes_tbl := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

5538: p_attribute13 => p_qlpa_attribute13 ,
5539: p_attribute14 => p_qlpa_attribute14 ,
5540: p_attribute15 => p_qlpa_attribute15);
5541: ELSE
5542: l_ln_price_attributes_tbl := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
5543: END IF;
5544:
5545: IF p_qfc_operation_code IS NOT NULL AND p_qfc_operation_code.COUNT > 0 THEN
5546: -- set header freight charge

Line 5582: l_hd_freight_charge_tbl := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;

5578: p_attribute13 => p_qfc_attribute13 ,
5579: p_attribute14 => p_qfc_attribute14 ,
5580: p_attribute15 => p_qfc_attribute15);
5581: ELSE
5582: l_hd_freight_charge_tbl := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
5583: END IF;
5584:
5585: IF p_qlfc_operation_code IS NOT NULL AND p_qlfc_operation_code.COUNT > 0 THEN
5586: -- set line freight charge

Line 5622: l_ln_freight_charge_tbl := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;

5618: p_attribute13 => p_qlfc_attribute13 ,
5619: p_attribute14 => p_qlfc_attribute14 ,
5620: p_attribute15 => p_qlfc_attribute15);
5621: ELSE
5622: l_ln_freight_charge_tbl := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
5623: END IF;
5624:
5625:
5626: IF p_qlae_operation_code IS NOT NULL AND p_qlae_operation_code.COUNT>0 THEN

Line 5654: l_line_attr_ext_tbl := ASO_Quote_Pub.G_MISS_Line_Attribs_Ext_TBL;

5650: p_start_date_active => p_qlae_start_date_active ,
5651: p_end_date_active => p_qlae_end_date_active ,
5652: p_operation_code => p_qlae_operation_code);
5653: ELSE
5654: l_line_attr_ext_tbl := ASO_Quote_Pub.G_MISS_Line_Attribs_Ext_TBL;
5655: END IF;
5656:
5657: IF p_qlpaa_operation_code IS NOT NULL AND p_qlpaa_operation_code.COUNT > 0 THEN
5658: -- set price adjustment attribute

Line 5681: l_price_adj_attr_tbl := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;

5677: p_pricing_attr_value_to => p_qlpaa_pricing_attr_value_to ,
5678: p_comparison_operator => p_qlpaa_comparison_operator ,
5679: p_flex_title => p_qlpaa_flex_title);
5680: ELSE
5681: l_price_adj_attr_tbl := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
5682: END IF;
5683:
5684: IF p_qlpaj_operation_code IS NOT NULL AND p_qlpaj_operation_code.COUNT > 0 THEN
5685: -- set price adjustment tbl

Line 5771: l_price_adjustment_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

5767: p_proration_type_code => p_qlpaj_proration_type_code ,
5768: p_include_on_ret_flag => p_qlpaj_include_on_ret_flag ,
5769: p_credit_or_charge_flag => p_qlpaj_credit_or_charge_flag);
5770: ELSE
5771: l_price_adjustment_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
5772: END IF;
5773:
5774: IF p_qlpar_operation_code IS NOT NULL AND p_qlpar_operation_code.COUNT > 0 THEN
5775: -- set price adjustment relationship tbl

Line 5795: l_price_adj_rltship_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;

5791: p_price_adj_index => p_qlpar_price_adj_index ,
5792: p_rltd_price_adj_id => p_qlpar_rltd_price_adj_id ,
5793: p_rltd_price_adj_index => p_qlpar_rltd_price_adj_index);
5794: ELSE
5795: l_price_adj_rltship_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
5796: END IF;
5797: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5798: IBE_UTIL.DEBUG('p_q_save_type in Save_wrapper: '||p_q_save_type);
5799: END IF;

Line 5921: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;

5917: x_retrieval_number OUT NOCOPY NUMBER
5918: )
5919:
5920: IS
5921: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
5922: BEGIN
5923: Set_Control_Rec_W(
5924: p_c_last_update_date => p_c_last_update_date ,
5925: p_c_auto_version_flag => p_c_auto_version_flag ,

Line 5988: lp_Submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;

5984: --Mannamra: Added for bug 4716044
5985: x_hold_flag OUT NOCOPY VARCHAR2
5986: )
5987: IS
5988: lp_Submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
5989: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
5990: BEGIN
5991: Set_Submit_Control_Rec_w(
5992: p_sc_book_flag => p_sc_book_flag ,

Line 5989: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;

5985: x_hold_flag OUT NOCOPY VARCHAR2
5986: )
5987: IS
5988: lp_Submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
5989: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
5990: BEGIN
5991: Set_Submit_Control_Rec_w(
5992: p_sc_book_flag => p_sc_book_flag ,
5993: p_sc_reserve_flag => p_sc_reserve_flag ,

Line 6232: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

6228: p_ql_section_id IN jtf_number_table := NULL,
6229: p_ql_line_codes IN jtf_number_table := NULL
6230: )
6231: IS
6232: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6233: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6234: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6235: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6236: l_count NUMBER;

Line 6233: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

6229: p_ql_line_codes IN jtf_number_table := NULL
6230: )
6231: IS
6232: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6233: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6234: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6235: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6236: l_count NUMBER;
6237: BEGIN

Line 6234: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

6230: )
6231: IS
6232: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6233: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6234: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6235: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6236: l_count NUMBER;
6237: BEGIN
6238:

Line 6235: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;

6231: IS
6232: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6233: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6234: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6235: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6236: l_count NUMBER;
6237: BEGIN
6238:
6239: Set_Control_rec_w(

Line 6606: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

6602: x_msg_count OUT NOCOPY NUMBER,
6603: x_msg_data OUT NOCOPY VARCHAR2
6604: )
6605: IS
6606: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6607: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6608:
6609: BEGIN
6610:

Line 6607: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;

6603: x_msg_data OUT NOCOPY VARCHAR2
6604: )
6605: IS
6606: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6607: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6608:
6609: BEGIN
6610:
6611: Set_Control_rec_w(