[Home] [Help]
1261:
1262: CURSOR audit_cur IS
1263: select audit_reason_code,
1264: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_REASONS',audit_reason_code) audit_reason
1265: from AP_AUD_AUDIT_REASONS
1266: where report_header_id = p_report_header_id
1267: order by audit_reason_id;
1268:
1269: audit_rec audit_cur%ROWTYPE;
3348: /*========================================================================
3349: | PUBLIC PROCEDURE clear_audit_reason_codes
3350: |
3351: | DESCRIPTION
3352: | This procedures clears the data from AP_AUD_AUDIT_REASONS table
3353: | for specified expense report.
3354: |
3355: | RETURNS
3356: |
3363: PROCEDURE clear_audit_reason_codes(p_report_header_id IN NUMBER) IS
3364: BEGIN
3365:
3366: delete
3367: from ap_aud_audit_reasons
3368: where report_header_id = p_report_header_id
3369: and audit_reason_code <> 'RANDOM';
3370:
3371: EXCEPTION