APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 123: FROM aso_quote_headers_all

119: where site_use_id = l_site_use_id;
120:
121: CURSOR C_get_quote_number(l_qte_hdr_id NUMBER) IS
122: SELECT quote_number, quote_version
123: FROM aso_quote_headers_all
124: WHERE quote_header_id = l_qte_hdr_id ;
125:
126: CURSOR scheduling_level_cur(p_type_id number) IS
127: SELECT nvl(scheduling_level_code,' ')

Line 413: UPDATE ASO_QUOTE_HEADERS_ALL

409: l_header_rec.conversion_type_code := l_conversion_type;
410:
411: -- update in quote tables if needed
412: IF upper(p_qte_rec.quote_source_code) = 'ORDER CAPTURE QUOTES' THEN
413: UPDATE ASO_QUOTE_HEADERS_ALL
414: SET Exchange_Type_Code = l_conversion_type,
415: Exchange_Rate_Date = l_sysdate,
416: Exchange_rate = p_qte_rec.exchange_rate
417: ,last_update_date = l_sysdate

Line 490: UPDATE ASO_QUOTE_HEADERS_ALL

486: aso_debug_pub.add('Cust_Accnt_Id in'||l_cust_account_id, 1, 'N');
487: END IF;
488: -- update quote header if account is created
489: IF upper(p_qte_rec.quote_source_code) = 'ORDER CAPTURE QUOTES' THEN
490: UPDATE ASO_QUOTE_HEADERS_ALL
491: SET cust_account_id = l_cust_account_id
492: ,last_update_date = l_sysdate
493: ,last_updated_by = l_g_user_id
494: ,last_update_login = l_g_login_id