APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 121: FROM aso_quote_headers_all

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

Line 411: UPDATE ASO_QUOTE_HEADERS_ALL

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

Line 488: UPDATE ASO_QUOTE_HEADERS_ALL

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