DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

* 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);