[Home] [Help]
69: l_debug_info := 'Check if Notif Rules Setup';
70: ------------------------------------------------------------
71: select 'Y'
72: into l_is_notif_rule_setup
73: from AP_AUD_RULE_SETS rs,
74: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
75: where rsa.org_id = p_org_id
76: and rsa.rule_set_id = rs.rule_set_id
77: and rs.rule_set_type = C_NOTIFY_RULE
462: l_total varchar2(80);
463: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
464: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
465:
466: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;
467: l_is_notif_rule_setup varchar2(1) := 'N';
468:
469: BEGIN
470:
2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2197:
2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2199: l_business_group_id hr_organization_units.business_group_id%TYPE;
2200: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;
2201: l_emp_rec AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type;
2202: l_audit_rec AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type;
2203: l_auto_audit_id NUMBER;
2204: l_x_return_status VARCHAR2(1);
2221: CURSOR c_overdue_receipts IS
2222: select aerh.report_header_id,
2223: aerh.receipts_status
2224: from AP_EXPENSE_REPORT_HEADERS aerh,
2225: AP_AUD_RULE_SETS rs,
2226: AP_AUD_RULE_ASSIGNMENTS rsa
2227: where aerh.receipts_status in (C_REQUIRED, C_MISSING)
2228: and aerh.bothpay_parent_id is null
2229: and rsa.org_id = nvl(p_org_id, rsa.org_id)
2256: hr.business_group_id,
2257: max(rs.audit_term_duration_days)
2258: from AP_EXPENSE_REPORT_HEADERS aerh,
2259: hr_organization_units hr,
2260: AP_AUD_RULE_SETS rs,
2261: AP_AUD_RULE_ASSIGNMENTS rsa
2262: where aerh.org_id = nvl(p_org_id, aerh.org_id)
2263: and aerh.bothpay_parent_id is null
2264: and aerh.report_submitted_date is not null