DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on IBE_QUOTE_HEADERS_V

Line 3869: l_cart_name ibe_quote_headers_v.quote_name%TYPE;

3865: l_quote_num VARCHAR2(1000) := null;
3866: l_first_name VARCHAR2(1000);
3867: l_last_name VARCHAR2(1000);
3868: l_contact_phone hz_contact_points.phone_number%TYPE;
3869: l_cart_name ibe_quote_headers_v.quote_name%TYPE;
3870: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;
3871: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;
3872: l_address VARCHAR2(4000);
3873: l_address1 VARCHAR2(240);

Line 3870: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;

3866: l_first_name VARCHAR2(1000);
3867: l_last_name VARCHAR2(1000);
3868: l_contact_phone hz_contact_points.phone_number%TYPE;
3869: l_cart_name ibe_quote_headers_v.quote_name%TYPE;
3870: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;
3871: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;
3872: l_address VARCHAR2(4000);
3873: l_address1 VARCHAR2(240);
3874: l_address2 VARCHAR2(240);

Line 3885: l_contact_name ibe_quote_headers_v.party_name%TYPE;

3881: l_ship_to_province VARCHAR2(60);
3882: l_ship_to_county VARCHAR2(60);
3883: l_minisite_name ibe_msites_vl.msite_name%TYPE;
3884: l_shipping_method wsh_carrier_ship_methods_v.ship_method_code_meaning%TYPE;
3885: l_contact_name ibe_quote_headers_v.party_name%TYPE;
3886:
3887: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;
3888: l_tax ibe_quote_headers_v.TOTAL_TAX%TYPE;
3889: l_total ibe_quote_headers_v.TOTAL_QUOTE_PRICE%TYPE;

Line 3887: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;

3883: l_minisite_name ibe_msites_vl.msite_name%TYPE;
3884: l_shipping_method wsh_carrier_ship_methods_v.ship_method_code_meaning%TYPE;
3885: l_contact_name ibe_quote_headers_v.party_name%TYPE;
3886:
3887: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;
3888: l_tax ibe_quote_headers_v.TOTAL_TAX%TYPE;
3889: l_total ibe_quote_headers_v.TOTAL_QUOTE_PRICE%TYPE;
3890:
3891: l_return_status VARCHAR2(20);

Line 3888: l_tax ibe_quote_headers_v.TOTAL_TAX%TYPE;

3884: l_shipping_method wsh_carrier_ship_methods_v.ship_method_code_meaning%TYPE;
3885: l_contact_name ibe_quote_headers_v.party_name%TYPE;
3886:
3887: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;
3888: l_tax ibe_quote_headers_v.TOTAL_TAX%TYPE;
3889: l_total ibe_quote_headers_v.TOTAL_QUOTE_PRICE%TYPE;
3890:
3891: l_return_status VARCHAR2(20);
3892: l_msg_count NUMBER;

Line 3889: l_total ibe_quote_headers_v.TOTAL_QUOTE_PRICE%TYPE;

3885: l_contact_name ibe_quote_headers_v.party_name%TYPE;
3886:
3887: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;
3888: l_tax ibe_quote_headers_v.TOTAL_TAX%TYPE;
3889: l_total ibe_quote_headers_v.TOTAL_QUOTE_PRICE%TYPE;
3890:
3891: l_return_status VARCHAR2(20);
3892: l_msg_count NUMBER;
3893: l_msg_data VARCHAR2(4000);