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_OA_ACTIVE_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 51: FROM ap_expense_report_headers_all aerh, wf_roles wfr

47:
48: --Bug 12565659: Fetch the approver name directly from wf_roles, to display it correctly
49: IF p_attribute_name = C_APPROVER_DISPLAY_NAME THEN
50: SELECT wfr.description INTO gan_old_approver_name
51: FROM ap_expense_report_headers_all aerh, wf_roles wfr
52: WHERE aerh.report_header_id = p_report_header_id
53: AND wfr.orig_system = aerh.approval_type
54: AND wfr.orig_system_id = aerh.expense_current_approver_id;
55: END IF;

Line 225: v_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE := NULL;

221: p_cache IN VARCHAR2,
222: p_query_wf_activities IN VARCHAR2) RETURN VARCHAR2
223: IS
224: v_status_code ap_lookup_codes.lookup_code%TYPE := NULL;
225: v_expense_status_code ap_expense_report_headers_all.expense_status_code%TYPE := NULL;
226:
227: --Bug 3612002:Changed datatype of the variable so that length
228: -- will become 4000.
229:

Line 240: SELECT expense_status_code INTO v_expense_status_code FROM ap_expense_report_headers_all

236: RETURN grsc_old_status_code;
237: END IF;
238:
239: -- Look at the source first
240: SELECT expense_status_code INTO v_expense_status_code FROM ap_expense_report_headers_all
241: WHERE report_header_id = p_report_header_id;
242:
243: -- Source = SelfService or CREDIT CARD
244: IF p_source IN (C_SelfService, C_CREDIT_CARD, C_BOTH_PAY) THEN

Line 542: FROM AP_EXPENSE_REPORT_HEADERS_ALL AERH

538:
539: --Check if report is split or not, if it is not split it will throw the exception
540: SELECT AERH.VOUCHNO, AERH.EXPENSE_STATUS_CODE
541: INTO l_cc_vouch_no, l_org_cc_report_status_code
542: FROM AP_EXPENSE_REPORT_HEADERS_ALL AERH
543: WHERE AERH.BOTHPAY_PARENT_ID=p_report_header_id;
544:
545:
546: --Report is split

Line 570: AP_EXPENSE_REPORT_HEADERS_ALL AERH,

566: 'CANCELLED')
567: INTO l_final_status_code
568: FROM
569: AP_INVOICES_ALL AI,
570: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
571: AP_PAYMENT_SCHEDULES_ALL APS
572: WHERE AERH.VOUCHNO = AI.INVOICE_ID
573: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
574: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'

Line 597: AP_EXPENSE_REPORT_HEADERS_ALL AERH,

593: 'CANCELLED')
594: INTO l_cc_report_status_code
595: FROM
596: AP_INVOICES_ALL AI,
597: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
598: AP_PAYMENT_SCHEDULES_ALL APS
599: WHERE AERH.VOUCHNO = AI.INVOICE_ID
600: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
601: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'