APPS.AP_WEB_AUDIT_HOOK SQL Statements

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

Line: 8

 |   logic for selecting expense reports for audit.
 |
 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
 |   Called from BC4J.
 |
 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
 |
 | RETURNS
 |
 | PARAMETERS
 |   p_expense_report_id           IN  Expense report header Identifier
 |   p_audit_reason_code           OUT NOCOPY Audit reason code, when report is
 |                                     audited this code will be stored
 |                                     in table AP_AUD_AUDIT_REASONS.
 |                                     If Null is passed, no row will be created.
 |   p_audit_report                OUT NOCOPY TRUE if report needs to be audited, FALSE
 |                                     otherwise. Null is considered as FALSE.
 |   p_override_default_processing OUT NOCOPY TRUE if customization overrides default audit
 |                                     processing, FALSE otherwise.
 |                                     Null is considered as FALSE.
 |
 | MODIFICATION HISTORY
 | Date                  Author            Description of Changes
 | 25-May-2002           J Rautiainen      Created
 |
 *=======================================================================*/
PROCEDURE audit_expense_report(p_expense_report_id           IN  NUMBER,
                               p_audit_reason_code           OUT NOCOPY VARCHAR2,
                               p_audit_report                OUT NOCOPY BOOLEAN,
                               p_override_default_processing OUT NOCOPY BOOLEAN) IS

BEGIN
  p_override_default_processing := FALSE;