eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 74: FROM ap_expense_report_headers_all

70: l_parent_report_id NUMBER;
71: BEGIN
72:
73: SELECT shortpay_parent_id INTO l_parent_report_id
74: FROM ap_expense_report_headers_all
75: WHERE report_header_id = p_report_header_id;
76:
77: IF l_parent_report_id is NOT NULL THEN
78: SELECT audit_code into l_audit_code

Line 79: FROM ap_expense_report_headers_all

75: WHERE report_header_id = p_report_header_id;
76:
77: IF l_parent_report_id is NOT NULL THEN
78: SELECT audit_code into l_audit_code
79: FROM ap_expense_report_headers_all
80: WHERE report_header_id = l_parent_report_id;
81:
82: RETURN l_audit_code;
83: ELSE

Line 160: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

156: rs.AUD_PAPER_RECEIPT_REQUIRED,
157: rs.RECPT_ASSIGN_STAGE_CODE,
158: rs.IMAGE_AUDIT_TAG,
159: rs.audit_all
160: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
161: AP_AUD_RULE_SETS rs,
162: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
163: where aerh.report_header_id = p_report_header_id
164: and aerh.org_id = rsa.org_id

Line 179: l_old_audit_code ap_expense_report_headers_all.audit_code%type := null;

175: l_bpay_personal_cc_only boolean := false;
176: l_shortpaid_report boolean := false;
177: audit_code VARCHAR2(30);
178: l_audit_code VARCHAR2(30);
179: l_old_audit_code ap_expense_report_headers_all.audit_code%type := null;
180: l_old_audit_reason_code ap_aud_audit_reasons.audit_reason_code%type := null;
181: BEGIN
182:
183: IF p_report_header_id is null THEN

Line 296: from ap_expense_report_headers_all aerh,

292: into l_old_audit_reason_code, l_old_audit_code
293: from
294: (
295: select audit_code, audit_reason_code
296: from ap_expense_report_headers_all aerh,
297: ap_aud_audit_reasons aud
298: where aerh.report_header_id = p_report_header_id
299: and aerh.report_header_id = aud.report_header_id
300: and aud.audit_reason_code = 'RANDOM'

Line 675: OR (EXISTS(select 1 from ap_expense_report_headers_all aerh

671: and pv.distribution_line_number = aerl.distribution_line_number
672: )
673: )
674: )
675: OR (EXISTS(select 1 from ap_expense_report_headers_all aerh
676: where aerh.report_header_id = aerl.report_header_id
677: and aerh.missing_img_just IS NOT NULL)));
678:
679: line_rec line_cur%ROWTYPE;

Line 723: from AP_EXPENSE_REPORT_HEADERS_ALL

719: p_audit_report OUT NOCOPY BOOLEAN) IS
720:
721: CURSOR report_cur IS
722: select AP_WEB_AUDIT_UTILS.is_employee_active(employee_id, org_id) active
723: from AP_EXPENSE_REPORT_HEADERS_ALL
724: where report_header_id = p_report_header_id;
725:
726: report_rec report_cur%ROWTYPE;
727:

Line 776: FROM ap_expense_report_headers_all XH,

772: INTO adv_not_applied_flag
773: FROM dual
774: WHERE EXISTS(
775: SELECT 'Y'
776: FROM ap_expense_report_headers_all XH,
777: ap_invoices_all AI,
778: po_vendors PV
779: WHERE XH.report_header_id = p_report_header_id
780: AND XH.prepay_num IS NULL

Line 836: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

832: CURSOR report_cur IS
833: select aerh.default_currency_code,
834: aerh.total,
835: sp.default_exchange_rate_type
836: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
837: ap_system_parameters_all sp
838: where aerh.report_header_id = p_report_header_id
839: and sp.org_id = aerh.org_id;
840:

Line 1063: UPDATE ap_expense_report_headers_all erh

1059:
1060: IF ( p_report_header_id IS NOT NULL
1061: AND p_audit_code IS NOT NULL) THEN
1062:
1063: UPDATE ap_expense_report_headers_all erh
1064: SET audit_code = p_audit_code
1065: WHERE report_header_id = p_report_header_id;
1066: END IF;
1067:

Line 1247: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

1243: rs.rule_set_id,
1244: aerh.default_currency_code,
1245: aerh.default_exchange_rate_type,
1246: aerh.week_end_date
1247: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
1248: AP_AUD_RULE_SETS rs,
1249: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1250: where aerh.report_header_id = p_report_header_id
1251: and aerh.org_id = rsa.org_id

Line 1263: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

1259: --card Report from report count.
1260: CURSOR reports_cur(p_employee_id IN NUMBER, p_org_id IN NUMBER, p_ex_rate IN NUMBER) IS
1261: select sum(NVL(aerh.total,0)*NVL(aerh.default_exchange_rate,p_ex_rate)) expense_report_total,
1262: count(aerh.expense_report_id) expense_report_count
1263: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
1264: where employee_id = p_employee_id
1265: and aerh.org_id = p_org_id
1266: and aerh.report_submitted_date > add_months(sysdate,-1)
1267: and ( aerh.source in ('WebExpense', 'SelfService')

Line 1725: AP_EXPENSE_REPORT_HEADERS_ALL aerh

1721:
1722: CURSOR violation_cur IS
1723: select count(1) violation_count
1724: from AP_POL_VIOLATIONS_ALL viol,
1725: AP_EXPENSE_REPORT_HEADERS_ALL aerh
1726: where aerh.employee_id = p_employee_id
1727: and viol.report_header_id = aerh.report_header_id
1728: and aerh.week_end_date > add_months(sysdate,-p_months);
1729: