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

Line 473: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

469: AND ( NVL(CCT.EXPENSED_AMOUNT
470: ,0) = 0
471: OR ( CCT.EXPENSED_AMOUNT <> 0
472: AND CCT.CATEGORY = 'PERSONAL'
473: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY
474: ,CCT.TRX_ID) = 'TRUE' ) )
475: AND NVL(CCT.CATEGORY
476: ,'BUSINESS') not in ( 'DISPUTED' , 'MATCHED' , 'CREDIT' )
477: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID

Line 516: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

512: AND ( NVL(CCT.EXPENSED_AMOUNT
513: ,0) = 0
514: OR ( CCT.EXPENSED_AMOUNT <> 0
515: AND CCT.CATEGORY = 'PERSONAL'
516: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY
517: ,CCT.TRX_ID) = 'TRUE' ) )
518: AND NVL(CCT.CATEGORY
519: ,'BUSINESS') not in ( 'DISPUTED' , 'MATCHED' , 'CREDIT' )
520: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID

Line 553: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

549: AND ( NVL(CCT.EXPENSED_AMOUNT
550: ,0) = 0
551: OR ( CCT.EXPENSED_AMOUNT <> 0
552: AND CCT.CATEGORY = 'PERSONAL'
553: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY
554: ,CCT.TRX_ID) = 'TRUE' ) )
555: AND NVL(CCT.CATEGORY
556: ,'BUSINESS') not in ( 'DISPUTED' , 'MATCHED' , 'CREDIT' )
557: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID

Line 592: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

588: AND ERH.REPORT_HEADER_ID = CCT.REPORT_HEADER_ID
589: AND ERH.EMPLOYEE_ID = AC.EMPLOYEE_ID
590: AND NVL(ERH.VOUCHNO
591: ,0) = 0
592: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
593: ,ERH.WORKFLOW_APPROVED_FLAG
594: ,ERH.REPORT_HEADER_ID) in ( 'EMPAPPR' , 'RESOLUTN' , 'RETURNED' , 'REJECTED' , 'WITHDRAWN' , 'SAVED' , 'INPROGRESS' )
595: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
596: AND AC.CARD_ID = CCT.CARD_ID

Line 635: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

631: AND NVL(CCT.CATEGORY
632: ,'BUSINESS') not in ( 'DISPUTED' , 'MATCHED' , 'CREDIT' , 'PERSONAL' , 'DEACTIVATED' )
633: AND ERH.REPORT_HEADER_ID = CCT.REPORT_HEADER_ID
634: AND ERH.EMPLOYEE_ID = AC.EMPLOYEE_ID
635: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
636: ,ERH.WORKFLOW_APPROVED_FLAG
637: ,ERH.REPORT_HEADER_ID) in ( 'EMPAPPR' , 'RESOLUTN' , 'RETURNED' , 'REJECTED' , 'WITHDRAWN' , 'SAVED' , 'INPROGRESS' )
638: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
639: AND AC.CARD_ID = CCT.CARD_ID

Line 675: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

671: AND ERL.CREDIT_CARD_TRX_ID = CCT.TRX_ID
672: AND ERH.REPORT_HEADER_ID = ERL.REPORT_HEADER_ID
673: AND NVL(ERH.VOUCHNO
674: ,0) = 0
675: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
676: ,ERH.WORKFLOW_APPROVED_FLAG
677: ,ERH.REPORT_HEADER_ID) in ( 'EMPAPPR' , 'RESOLUTN' , 'RETURNED' , 'REJECTED' , 'WITHDRAWN' , 'SAVED' , 'INPROGRESS' )
678: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
679: AND AC.CARD_ID = CCT.CARD_ID

Line 1149: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

1145: AND erl.credit_card_trx_id (+) = CCT.TRX_ID
1146: AND erh.report_header_id (+) = ERL.REPORT_HEADER_ID
1147: AND NVL(ERH.VOUCHNO
1148: ,0) = 0
1149: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1150: ,ERH.WORKFLOW_APPROVED_FLAG
1151: ,ERH.REPORT_HEADER_ID)
1152: ,'UNUSED') in ( 'UNUSED' , 'SAVED' , 'INPROGRESS' , 'EMPAPPR' , 'REJECTED' , 'RESOLUTN' , 'WITHDRAWN' , 'RETURNED' )
1153: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

Line 1153: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

1149: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1150: ,ERH.WORKFLOW_APPROVED_FLAG
1151: ,ERH.REPORT_HEADER_ID)
1152: ,'UNUSED') in ( 'UNUSED' , 'SAVED' , 'INPROGRESS' , 'EMPAPPR' , 'REJECTED' , 'RESOLUTN' , 'WITHDRAWN' , 'RETURNED' )
1153: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY
1154: ,CCT.TRX_ID) = 'TRUE'
1155: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
1156: AND AC.CARD_ID = CCT.CARD_ID
1157: AND CP.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID

Line 1206: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

1202: AND CCT.PAYMENT_FLAG <> 'Y'
1203: AND NVL(CCT.CATEGORY
1204: ,'BUSINESS') NOT IN ( 'DEACTIVATED' , 'MATCHED' , 'CREDIT' )
1205: AND erl.credit_card_trx_id (+) = CCT.TRX_ID
1206: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1207: ,ERH.WORKFLOW_APPROVED_FLAG
1208: ,ERH.REPORT_HEADER_ID)
1209: ,'UNUSED') in ( 'UNUSED' , 'SAVED' , 'INPROGRESS' , 'EMPAPPR' , 'REJECTED' , 'RESOLUTN' , 'WITHDRAWN' , 'RETURNED' )
1210: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

Line 1210: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

1206: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1207: ,ERH.WORKFLOW_APPROVED_FLAG
1208: ,ERH.REPORT_HEADER_ID)
1209: ,'UNUSED') in ( 'UNUSED' , 'SAVED' , 'INPROGRESS' , 'EMPAPPR' , 'REJECTED' , 'RESOLUTN' , 'WITHDRAWN' , 'RETURNED' )
1210: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY
1211: ,CCT.TRX_ID) = 'TRUE'
1212: AND erh.report_header_id (+) = ERL.REPORT_HEADER_ID
1213: AND NVL(ERH.VOUCHNO
1214: ,0) = 0

Line 1262: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

1258: AND erl.credit_card_trx_id (+) = CCT.TRX_ID
1259: AND erh.report_header_id (+) = ERL.REPORT_HEADER_ID
1260: AND NVL(ERH.VOUCHNO
1261: ,0) = 0
1262: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1263: ,ERH.WORKFLOW_APPROVED_FLAG
1264: ,ERH.REPORT_HEADER_ID)
1265: ,'UNUSED') in ( 'UNUSED' , 'SAVED' , 'INPROGRESS' , 'EMPAPPR' , 'REJECTED' , 'RESOLUTN' , 'WITHDRAWN' , 'RETURNED' )
1266: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

Line 1266: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY

1262: AND NVL(AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1263: ,ERH.WORKFLOW_APPROVED_FLAG
1264: ,ERH.REPORT_HEADER_ID)
1265: ,'UNUSED') in ( 'UNUSED' , 'SAVED' , 'INPROGRESS' , 'EMPAPPR' , 'REJECTED' , 'RESOLUTN' , 'WITHDRAWN' , 'RETURNED' )
1266: AND AP_WEB_OA_ACTIVE_PKG.GETINCLUDENOTIFICATION(CCT.CATEGORY
1267: ,CCT.TRX_ID) = 'TRUE'
1268: AND AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
1269: AND AC.CARD_ID = CCT.CARD_ID
1270: AND CP.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID

Line 1483: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

1479: AND PERF.EFFECTIVE_END_DATE
1480: AND TRUNC(SYSDATE) between PERA.EFFECTIVE_START_DATE
1481: AND PERA.EFFECTIVE_END_DATE
1482: AND CCT.REPORT_HEADER_ID = erh.report_header_id (+)
1483: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1484: ,ERH.WORKFLOW_APPROVED_FLAG
1485: ,ERH.REPORT_HEADER_ID) in ( 'EMPAPPR' , 'RESOLUTN' , 'RETURNED' , 'REJECTED' , 'WITHDRAWN' , 'SAVED' , 'INPROGRESS' )
1486: AND TRUNC(NVL(CCT.BILLED_DATE
1487: ,CCT.POSTED_DATE)) between NVL(P_CC_BILLED_START_DATE

Line 1574: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE

1570: AND PERA.EFFECTIVE_END_DATE
1571: AND CCT.REPORT_HEADER_ID = erh.report_header_id (+)
1572: AND NVL(CCT.CATEGORY
1573: ,'BUSINESS') <> 'DEACTIVATED'
1574: AND AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(ERH.SOURCE
1575: ,ERH.WORKFLOW_APPROVED_FLAG
1576: ,ERH.REPORT_HEADER_ID) in ( 'EMPAPPR' , 'RESOLUTN' , 'RETURNED' , 'REJECTED' , 'WITHDRAWN' , 'SAVED' , 'INPROGRESS' )
1577: AND NVL(CCT.BILLED_DATE
1578: ,CCT.POSTED_DATE) between NVL(P_CC_BILLED_START_DATE