DBA Data[Home] [Help]

APPS.ASO_APR_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 2005: from aso_quote_headers_all

2001: l_status_id NUMBER;
2002:
2003: cursor c_get_qte_info ( l_qte_hdr_id number) is
2004: select last_update_date,object_version_number
2005: from aso_quote_headers_all
2006: where quote_header_id = l_qte_hdr_id;
2007:
2008: CURSOR C_Get_Status IS
2009: SELECT Quote_Status_Id

Line 2078: update aso_quote_headers_all

2074: x_last_update_date := sysdate;
2075: x_obj_ver_num := l_object_version_number + 1;
2076:
2077: -- update the quote status to approval pending
2078: update aso_quote_headers_all
2079: set quote_status_id = l_status_id,
2080: object_version_number = x_obj_ver_num,
2081: last_update_date = x_last_update_date
2082: where quote_header_id = p_qte_hdr_id;