DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_AUD_AUDIT_REASONS

Line 1226: from AP_AUD_AUDIT_REASONS

1222:
1223: CURSOR audit_cur IS
1224: select audit_reason_code,
1225: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_REASONS',audit_reason_code) audit_reason
1226: from AP_AUD_AUDIT_REASONS
1227: where report_header_id = p_report_header_id
1228: order by audit_reason_id;
1229:
1230: audit_rec audit_cur%ROWTYPE;

Line 3303: | This procedures clears the data from AP_AUD_AUDIT_REASONS table

3299: /*========================================================================
3300: | PUBLIC PROCEDURE clear_audit_reason_codes
3301: |
3302: | DESCRIPTION
3303: | This procedures clears the data from AP_AUD_AUDIT_REASONS table
3304: | for specified expense report.
3305: |
3306: | RETURNS
3307: |

Line 3318: from ap_aud_audit_reasons

3314: PROCEDURE clear_audit_reason_codes(p_report_header_id IN NUMBER) IS
3315: BEGIN
3316:
3317: delete
3318: from ap_aud_audit_reasons
3319: where report_header_id = p_report_header_id
3320: and audit_reason_code <> 'RANDOM';
3321:
3322: EXCEPTION