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_DB_CCARD_PKG dependencies on AP_WEB_OA_ACTIVE_PKG

Line 247: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

243: merchant_name1,
244: billed_amount,
245: billed_currency_code,
246: erh.invoice_num,
247: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
248: (erh.source,erh.workflow_approved_flag,
249: erh.report_header_id), --2615448
250: cct.trx_id -- Bug 3241358
251: FROM

Line 270: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

266: nvl(p_billedEndDate, nvl(cct.billed_date, cct.posted_date)+1)
267: and abs(cct.billed_amount) > nvl(p_minimumAmount,0)
268: and erh.report_header_id = cct.report_header_id --3130923
269: and ac.employee_id = erh.employee_id --3130923
270: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
271: (erh.source,erh.workflow_approved_flag,
272: erh.report_header_id) in
273: ('EMPAPPR', 'RESOLUTN','RETURNED','REJECTED','WITHDRAWN', 'SAVED') --2615448
274: and ac.employee_id = p_employeeId

Line 309: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

305: merchant_name1,
306: billed_amount,
307: billed_currency_code,
308: erh.invoice_num,
309: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
310: (erh.source,erh.workflow_approved_flag,
311: erh.report_header_id), --2615448
312: cct.trx_id -- Bug 3241358
313: FROM

Line 331: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

327: nvl(p_billedEndDate, nvl(cct.billed_date, cct.posted_date)+1)
328: and abs(cct.billed_amount) > nvl(p_minimumAmount,0)
329: and erh.report_header_id = cct.report_header_id
330: and ac.employee_id = erh.employee_id --3130923
331: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
332: (erh.source,erh.workflow_approved_flag,
333: erh.report_header_id) in
334: ('EMPAPPR', 'RESOLUTN','RETURNED','REJECTED','WITHDRAWN', 'SAVED') --2615448
335: and ac.employee_id = p_employeeId

Line 372: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

368: merchant_name1,
369: billed_amount,
370: billed_currency_code,
371: erh.invoice_num,
372: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
373: (erh.source,erh.workflow_approved_flag,
374: erh.report_header_id), --2615448
375: cct.trx_id -- Bug 3241358
376: FROM

Line 395: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,

391: nvl(p_billedEndDate, nvl(cct.billed_date, cct.posted_date)+1)
392: and abs(cct.billed_amount) > nvl(p_minimumAmount,0)
393: and erh.report_header_id = cct.report_header_id --3130923
394: and ac.employee_id = erh.employee_id --3130923
395: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,
396: erh.report_header_id) in
397: ('EMPAPPR', 'RESOLUTN','RETURNED','REJECTED','WITHDRAWN', 'SAVED') --2615448
398: and ac.employee_id = p_employeeId
399: UNION ALL

Line 431: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

427: merchant_name1,
428: billed_amount,
429: billed_currency_code,
430: erh.invoice_num,
431: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
432: (erh.source,erh.workflow_approved_flag,
433: erh.report_header_id), --2615448
434: cct.trx_id -- Bug 3241358
435: FROM

Line 453: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,

449: nvl(p_billedEndDate, nvl(cct.billed_date, cct.posted_date)+1)
450: and abs(cct.billed_amount) > nvl(p_minimumAmount,0)
451: and erh.report_header_id = cct.report_header_id
452: and ac.employee_id = erh.employee_id --3130923
453: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,
454: erh.report_header_id) in
455: ('EMPAPPR', 'RESOLUTN','RETURNED','REJECTED','WITHDRAWN', 'SAVED') --2615448
456: and ac.employee_id = p_employeeId;
457: --order by cct.transaction_date;

Line 494: NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

490: billed_amount,
491: billed_currency_code,
492: cct.posted_currency_code, --3339380
493: erh.invoice_num,
494: NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
495: (erh.source,erh.workflow_approved_flag,
496: erh.report_header_id),'UNUSED'), --2615505
497: nvl(cct.billed_date, cct.posted_date) billed_date,
498: cct.posted_date, --Notification Esc

Line 516: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,

512: and ac.card_program_id = cct.card_program_id
513: and ac.card_id = cct.card_id
514: and trunc(sysdate) - cct.posted_date between p_min_bucket and p_max_bucket
515: and erh.report_header_id = cct.report_header_id
516: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,
517: erh.report_header_id)
518: in ('SAVED','REJECTED', 'RESOLUTN','EMPAPPR','RETURNED','WITHDRAWN')
519: and ac.employee_id = p_employeeId
520: and rownum < 41

Line 529: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

525: billed_amount,
526: billed_currency_code,
527: cct.posted_currency_code, --3339380
528: erh.invoice_num,
529: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
530: (erh.source,erh.workflow_approved_flag,
531: erh.report_header_id),
532: nvl(cct.billed_date, cct.posted_date) billed_date,
533: cct.posted_date, --Notification Esc

Line 551: and NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,

547: and ac.card_program_id = cct.card_program_id
548: and ac.card_id = cct.card_id
549: and trunc(sysdate) - cct.posted_date between p_min_bucket and p_max_bucket
550: and erh.report_header_id = cct.report_header_id
551: and NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,
552: erh.report_header_id),'UNUSED')
553: in ('SAVED','REJECTED', 'RESOLUTN','EMPAPPR','RETURNED','WITHDRAWN')
554: and ac.employee_id = p_employeeId
555: and rownum < 41

Line 617: NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

613: merchant_name1,
614: billed_amount,
615: billed_currency_code,
616: erh.invoice_num,
617: NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
618: (erh.source,erh.workflow_approved_flag,
619: erh.report_header_id),'UNUSED'), --2615505
620: nvl(cct.billed_date, cct.posted_date) billed_date,
621: cct.trx_id -- Bug 3241358

Line 638: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,

634: and trunc(sysdate) - nvl(cct.billed_date, cct.posted_date) between p_min_bucket and p_max_bucket
635: and erh.report_header_id = cct.report_header_id
636: and cct.expensed_amount <> 0
637: and erh.report_header_id = cct.report_header_id
638: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,
639: erh.report_header_id)
640: in ('SAVED','REJECTED', 'RESOLUTN','EMPAPPR','RETURNED','WITHDRAWN')
641: and ac.employee_id = p_employeeId
642: UNION ALL

Line 648: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode

644: merchant_name1,
645: billed_amount,
646: billed_currency_code,
647: erh.invoice_num,
648: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode
649: (erh.source,erh.workflow_approved_flag,
650: erh.report_header_id),
651: nvl(cct.billed_date, cct.posted_date) billed_date,
652: cct.trx_id

Line 667: and NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,

663: and ac.card_program_id = cct.card_program_id
664: and ac.card_id = cct.card_id
665: and trunc(sysdate) - nvl(cct.billed_date, cct.posted_date) between p_min_bucket and p_max_bucket
666: and erh.report_header_id = cct.report_header_id
667: and NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,
668: erh.report_header_id),'UNUSED')
669: in ('SAVED','REJECTED', 'RESOLUTN','EMPAPPR','RETURNED','WITHDRAWN')
670: and ac.employee_id = p_employeeId
671: UNION ALL

Line 1934: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(

1930: WHERE
1931: cct.card_program_id = p_cardProgramId
1932: and cct.validate_code = 'Y'
1933: and cct.payment_flag <> 'Y'
1934: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(
1935: erh.source,erh.workflow_approved_flag,
1936: erh.report_header_id)
1937: in
1938: ('EMPAPPR', 'RESOLUTN','RETURNED',

Line 2011: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,

2007: and ac.card_program_id = cct.card_program_id
2008: and ac.card_id = cct.card_id
2009: and trunc(sysdate) - cct.posted_date between p_min_bucket and p_max_bucket
2010: and erh.report_header_id = cct.report_header_id
2011: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,
2012: erh.workflow_approved_flag,
2013: erh.report_header_id) --2615505
2014: in ('SAVED','UNUSED','REJECTED',
2015: 'RESOLUTN','EMPAPPR','RETURNED','WITHDRAWN')

Line 2087: and NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,

2083: and ac.card_id = cct.card_id
2084: and trunc(sysdate) - (cct.posted_date+nvl(p_grace_days,0))
2085: between p_min_bucket and p_max_bucket
2086: and erh.report_header_id(+) = cct.report_header_id
2087: and NVL(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,
2088: erh.workflow_approved_flag,
2089: erh.report_header_id),
2090: 'UNUSED') --2615505
2091: in ('SAVED','UNUSED','REJECTED',