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 337: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type

333: p_c_header_pricing_event VARCHAR2,
334: p_c_line_pricing_event VARCHAR2,
335: p_c_cal_tax_flag VARCHAR2,
336: p_c_cal_freight_charge_flag VARCHAR2,
337: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
338: )
339: IS
340: BEGIN
341: IF p_c_last_update_date = ROSETTA_G_MISTAKE_DATE THEN

Line 374: RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type

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

Line 376: l_price_adj_rltship_tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

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

Line 560: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

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

Line 562: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

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

Line 796: RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type

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

Line 798: l_price_adj_attr_tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

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

Line 913: RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type

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

Line 915: l_line_attribs_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

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

Line 1063: RETURN ASO_Quote_Pub.Freight_Charge_Tbl_Type

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

Line 1065: l_freight_charge_tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

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

Line 1313: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type

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

Line 1315: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

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

Line 1583: RETURN ASO_Quote_Pub.Shipment_Rec_Type

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

Line 1585: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;

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

Line 1820: RETURN ASO_Quote_Pub.Shipment_Tbl_Type

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

Line 1822: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;

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

Line 2145: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type

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

Line 2147: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

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

Line 2440: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type

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

Line 2442: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;

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

Line 2836: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type

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

Line 2838: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

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

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

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

Line 3221: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type

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

Line 3223: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

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

Line 3445: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type

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

Line 3447: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

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

Line 4598: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

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

Line 4599: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

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

Line 4600: l_qte_line_dtl_tbl ASO_Quote_Pub.qte_line_Dtl_tbl_type;

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

Line 4601: l_line_rltship_tbl ASO_Quote_Pub.line_rltship_tbl_type;

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

Line 4602: l_control_rec ASO_Quote_Pub.Control_Rec_Type;

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

Line 4603: l_Hd_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;

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

Line 4604: l_ln_Payment_Tbl ASO_Quote_Pub.Payment_tbl_Type;

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

Line 4605: l_Hd_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;

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

Line 4606: l_ln_Tax_Detail_Tbl ASO_Quote_Pub.Tax_Detail_TBL_Type;

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

Line 4607: l_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;

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

Line 4608: l_ln_Shipment_Tbl ASO_Quote_Pub.Shipment_TBL_Type;

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

Line 4609: l_hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

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

Line 4610: l_ln_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

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

Line 4611: l_hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

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

Line 4612: l_ln_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

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

Line 4613: l_Line_Attr_Ext_Tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

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

Line 4614: l_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

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

Line 4615: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

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

Line 4616: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

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

Line 4619: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

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

Line 4824: l_qte_line_tbl := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

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

Line 4900: l_qte_line_dtl_tbl := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

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

Line 4924: l_line_rltship_tbl := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl;

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

Line 4974: l_Hd_Payment_Tbl := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

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

Line 5024: l_ln_Payment_Tbl := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

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

Line 5071: l_Hd_Tax_Detail_Tbl := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

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

Line 5118: l_ln_tax_detail_tbl := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

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

Line 5189: l_hd_shipment_tbl := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

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

Line 5260: l_ln_shipment_tbl := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

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

Line 5399: l_hd_price_attributes_tbl := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

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

Line 5538: l_ln_price_attributes_tbl := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

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

Line 5578: l_hd_freight_charge_tbl := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;

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

Line 5618: l_ln_freight_charge_tbl := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;

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

Line 5650: l_line_attr_ext_tbl := ASO_Quote_Pub.G_MISS_Line_Attribs_Ext_TBL;

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

Line 5677: l_price_adj_attr_tbl := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;

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

Line 5767: l_price_adjustment_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

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

Line 5791: l_price_adj_rltship_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;

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

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

5913: x_retrieval_number OUT NOCOPY NUMBER
5914: )
5915:
5916: IS
5917: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
5918: BEGIN
5919: Set_Control_Rec_W(
5920: p_c_last_update_date => p_c_last_update_date ,
5921: p_c_auto_version_flag => p_c_auto_version_flag ,

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

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

Line 5985: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;

5981: x_hold_flag OUT NOCOPY VARCHAR2
5982: )
5983: IS
5984: lp_Submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;
5985: lx_order_header_rec ASO_Quote_Pub.Order_Header_Rec_Type;
5986: BEGIN
5987: Set_Submit_Control_Rec_w(
5988: p_sc_book_flag => p_sc_book_flag ,
5989: p_sc_reserve_flag => p_sc_reserve_flag ,

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

6223: p_ql_section_id IN jtf_number_table := NULL,
6224: p_ql_line_codes IN jtf_number_table := NULL
6225: )
6226: IS
6227: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6228: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6229: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6230: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6231: l_count NUMBER;

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

6224: p_ql_line_codes IN jtf_number_table := NULL
6225: )
6226: IS
6227: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6228: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6229: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6230: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6231: l_count NUMBER;
6232: BEGIN

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

6225: )
6226: IS
6227: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6228: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6229: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6230: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6231: l_count NUMBER;
6232: BEGIN
6233:

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

6226: IS
6227: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6228: l_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6229: x_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
6230: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6231: l_count NUMBER;
6232: BEGIN
6233:
6234: Set_Control_rec_w(

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

6596: x_msg_count OUT NOCOPY NUMBER,
6597: x_msg_data OUT NOCOPY VARCHAR2
6598: )
6599: IS
6600: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6601: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6602:
6603: BEGIN
6604:

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

6597: x_msg_data OUT NOCOPY VARCHAR2
6598: )
6599: IS
6600: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
6601: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
6602:
6603: BEGIN
6604:
6605: Set_Control_rec_w(