APPS.AP_WEB_AUDIT_UTILS dependencies on AP_AUD_RULE_SETS

Line 1355: from AP_AUD_RULE_SETS rs,

1351: and nvl(aerl.receipt_required_flag, 'N') = 'Y';
1352:
1353: CURSOR rule_cur (p_org_id IN NUMBER) IS
1354: select rs.audit_term_duration_days
1355: from AP_AUD_RULE_SETS rs,
1356: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1357: where rsa.org_id = p_org_id
1358: and rsa.rule_set_id = rs.rule_set_id
1359: and rs.rule_set_type = 'AUDIT_LIST'

Line 1525: from AP_AUD_RULE_SETS rs,

1521: p_data_type IN VARCHAR2) RETURN VARCHAR2 IS
1522:
1523: CURSOR rule_cur IS
1524: select rs.rule_set_id
1525: from AP_AUD_RULE_SETS rs,
1526: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1527: where rsa.org_id = p_org_id
1528: and rsa.rule_set_id = rs.rule_set_id
1529: and rs.rule_set_type = p_rule_type

Line 1554: 'AP_AUD_RULE_SETS',

1550:
1551: return get_object_info(to_char(rule_rec.rule_set_id),
1552: p_column,
1553: p_data_type,
1554: 'AP_AUD_RULE_SETS',
1555: 'rule_set_id');
1556:
1557: END get_audit_rule_info;
1558:

Line 2861: AP_AUD_RULE_SETS rs,

2857: rs.requires_audit_tag,
2858: rs.paperless_audit_tag,
2859: aerh.audit_code
2860: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
2861: AP_AUD_RULE_SETS rs,
2862: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2863: where aerh.report_header_id = p_report_header_id
2864: and aerh.org_id = rsa.org_id
2865: and rsa.rule_set_id = rs.rule_set_id

Line 3138: PROCEDURE get_rule(p_org_id IN NUMBER, p_date IN DATE, p_rule_type IN VARCHAR2, p_rule OUT NOCOPY AP_AUD_RULE_SETS%ROWTYPE) IS

3134: | Date Author Description of Changes
3135: | 11-Oct-2004 J Rautiainen Created
3136: |
3137: *=======================================================================*/
3138: PROCEDURE get_rule(p_org_id IN NUMBER, p_date IN DATE, p_rule_type IN VARCHAR2, p_rule OUT NOCOPY AP_AUD_RULE_SETS%ROWTYPE) IS
3139:
3140: CURSOR rule_cur IS
3141: select rs.*
3142: from AP_AUD_RULE_SETS rs,

Line 3142: from AP_AUD_RULE_SETS rs,

3138: PROCEDURE get_rule(p_org_id IN NUMBER, p_date IN DATE, p_rule_type IN VARCHAR2, p_rule OUT NOCOPY AP_AUD_RULE_SETS%ROWTYPE) IS
3139:
3140: CURSOR rule_cur IS
3141: select rs.*
3142: from AP_AUD_RULE_SETS rs,
3143: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
3144: where rsa.org_id = p_org_id
3145: and rsa.rule_set_id = rs.rule_set_id
3146: and rs.rule_set_type = p_rule_type

Line 3151: rule_rec AP_AUD_RULE_SETS%ROWTYPE;

3147: and TRUNC(p_date)
3148: BETWEEN TRUNC(NVL(rsa.START_DATE,p_date))
3149: AND TRUNC(NVL(rsa.END_DATE,p_date));
3150:
3151: rule_rec AP_AUD_RULE_SETS%ROWTYPE;
3152: BEGIN
3153: IF (p_org_id is null OR p_date IS NULL OR p_rule_type IS NULL ) THEN
3154: return;
3155: END IF;