DBA Data[Home] [Help]

APPS.ASO_PA_APR_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 1673: from aso_quote_headers_all

1669: l_apr_object_version number;
1670:
1671: cursor c_get_qte_info ( l_qte_hdr_id number) is
1672: select last_update_date,object_version_number
1673: from aso_quote_headers_all
1674: where quote_header_id = l_qte_hdr_id;
1675:
1676: CURSOR C_Get_Status IS
1677: SELECT Quote_Status_Id

Line 1752: update aso_quote_headers_all

1748: x_last_update_date := sysdate;
1749: x_obj_ver_num := l_object_version_number + 1;
1750:
1751: -- update the quote status to approval pending
1752: update aso_quote_headers_all
1753: set quote_status_id = l_status_id,
1754: object_version_number = x_obj_ver_num,
1755: last_update_date = x_last_update_date
1756: where quote_header_id = p_qte_hdr_id;