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

Line 444: l_source ap_expense_report_headers.source%TYPE;

440: FUNCTION GetIncludeNotification(p_category IN VARCHAR2,
441: p_trx_id IN NUMBER)
442: RETURN VARCHAR2 IS
443: l_status ap_lookup_codes.lookup_code%TYPE ;
444: l_source ap_expense_report_headers.source%TYPE;
445: l_workflow_approved_flag ap_expense_report_headers.workflow_approved_flag%TYPE;
446: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
447:
448: BEGIN

Line 445: l_workflow_approved_flag ap_expense_report_headers.workflow_approved_flag%TYPE;

441: p_trx_id IN NUMBER)
442: RETURN VARCHAR2 IS
443: l_status ap_lookup_codes.lookup_code%TYPE ;
444: l_source ap_expense_report_headers.source%TYPE;
445: l_workflow_approved_flag ap_expense_report_headers.workflow_approved_flag%TYPE;
446: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
447:
448: BEGIN
449:

Line 446: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

442: RETURN VARCHAR2 IS
443: l_status ap_lookup_codes.lookup_code%TYPE ;
444: l_source ap_expense_report_headers.source%TYPE;
445: l_workflow_approved_flag ap_expense_report_headers.workflow_approved_flag%TYPE;
446: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
447:
448: BEGIN
449:
450: IF p_category = 'PERSONAL' then

Line 454: FROM ap_credit_card_trxns cct, ap_expense_report_headers erh

450: IF p_category = 'PERSONAL' then
451:
452: SELECT erh.report_header_id, source, workflow_approved_flag
453: INTO l_report_header_id , l_source , l_workflow_approved_flaG
454: FROM ap_credit_card_trxns cct, ap_expense_report_headers erh
455: WHERE trx_id = p_trx_id
456: AND cct.report_header_id = erh.report_header_id;
457:
458: l_status := AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(l_source,

Line 521: FROM AP_EXPENSE_REPORT_HEADERS_ALL AERH

517:
518: --Check if report is split or not, if it is not split it will throw the exception
519: SELECT AERH.VOUCHNO, AERH.EXPENSE_STATUS_CODE
520: INTO l_cc_vouch_no, l_org_cc_report_status_code
521: FROM AP_EXPENSE_REPORT_HEADERS_ALL AERH
522: WHERE AERH.BOTHPAY_PARENT_ID=p_report_header_id;
523:
524:
525: --Report is split

Line 549: AP_EXPENSE_REPORT_HEADERS_ALL AERH,

545: 'CANCELLED')
546: INTO l_final_status_code
547: FROM
548: AP_INVOICES_ALL AI,
549: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
550: AP_PAYMENT_SCHEDULES_ALL APS
551: WHERE AERH.VOUCHNO = AI.INVOICE_ID
552: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
553: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'

Line 576: AP_EXPENSE_REPORT_HEADERS_ALL AERH,

572: 'CANCELLED')
573: INTO l_cc_report_status_code
574: FROM
575: AP_INVOICES_ALL AI,
576: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
577: AP_PAYMENT_SCHEDULES_ALL APS
578: WHERE AERH.VOUCHNO = AI.INVOICE_ID
579: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
580: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'