The following lines contain the word 'select', 'insert', 'update' or 'delete':
* Modifies: Updates po_change_requests with the result of the tolerance check.
* Returns:
* approval_required_flag: Y if user cannot auto approve
* : N if he/she can auto approve
*/
PROCEDURE set_approval_required_flag(
p_chreqgrp_id IN NUMBER
, x_appr_status OUT NOCOPY VARCHAR2
, p_source_type_code IN VARCHAR2 DEFAULT NULL
)
IS
BEGIN
po_rcotolerance_pvt.set_approval_required_flag(p_chreqgrp_id,
x_appr_status,
p_source_type_code);