APPS.AP_WEB_AUDIT_UTILS dependencies on AP_AUD_RULE_SETS

Line 1394: from AP_AUD_RULE_SETS rs,

1390: and nvl(aerl.receipt_required_flag, 'N') = 'Y';
1391:
1392: CURSOR rule_cur (p_org_id IN NUMBER) IS
1393: select rs.audit_term_duration_days
1394: from AP_AUD_RULE_SETS rs,
1395: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1396: where rsa.org_id = p_org_id
1397: and rsa.rule_set_id = rs.rule_set_id
1398: and rs.rule_set_type = 'AUDIT_LIST'

Line 1564: from AP_AUD_RULE_SETS rs,

1560: p_data_type IN VARCHAR2) RETURN VARCHAR2 IS
1561:
1562: CURSOR rule_cur IS
1563: select rs.rule_set_id
1564: from AP_AUD_RULE_SETS rs,
1565: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1566: where rsa.org_id = p_org_id
1567: and rsa.rule_set_id = rs.rule_set_id
1568: and rs.rule_set_type = p_rule_type

Line 1593: 'AP_AUD_RULE_SETS',

1589:
1590: return get_object_info(to_char(rule_rec.rule_set_id),
1591: p_column,
1592: p_data_type,
1593: 'AP_AUD_RULE_SETS',
1594: 'rule_set_id');
1595:
1596: END get_audit_rule_info;
1597:

Line 2908: AP_AUD_RULE_SETS rs,

2904: nvl(rs.aud_paper_receipt_required, 'X') aud_paper_receipt_required,
2905: nvl(aerh.image_receipts_status,'NOT_REQUIRED') hdr_img_receipt_required,
2906: nvl(aerh.receipts_status,'NOT_REQUIRED') hdr_paper_receipt_required
2907: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
2908: AP_AUD_RULE_SETS rs,
2909: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2910: where aerh.report_header_id = p_report_header_id
2911: and aerh.org_id = rsa.org_id
2912: and rsa.rule_set_id = rs.rule_set_id

Line 3187: 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

3183: | Date Author Description of Changes
3184: | 11-Oct-2004 J Rautiainen Created
3185: |
3186: *=======================================================================*/
3187: 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
3188:
3189: CURSOR rule_cur IS
3190: select rs.*
3191: from AP_AUD_RULE_SETS rs,

Line 3191: from AP_AUD_RULE_SETS rs,

3187: 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
3188:
3189: CURSOR rule_cur IS
3190: select rs.*
3191: from AP_AUD_RULE_SETS rs,
3192: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
3193: where rsa.org_id = p_org_id
3194: and rsa.rule_set_id = rs.rule_set_id
3195: and rs.rule_set_type = p_rule_type

Line 3200: rule_rec AP_AUD_RULE_SETS%ROWTYPE;

3196: and TRUNC(p_date)
3197: BETWEEN TRUNC(NVL(rsa.START_DATE,p_date))
3198: AND TRUNC(NVL(rsa.END_DATE,p_date));
3199:
3200: rule_rec AP_AUD_RULE_SETS%ROWTYPE;
3201: BEGIN
3202: IF (p_org_id is null OR p_date IS NULL OR p_rule_type IS NULL ) THEN
3203: return;
3204: END IF;