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.JA_JAINST3_XMLP_PKG dependencies on JAI_TRX_REPO_EXTRACT_PKG

Line 153: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

149: JAI_RGM_TRX_REFS
150: WHERE SOURCE = 'AP'
151: AND TAX_TYPE in ( 'Service' )
152: AND TRUNC(CREATION_DATE) < LV_DATE
153: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE
154: AND ORGANIZATION_ID in (
155: SELECT
156: DISTINCT
157: ORGANIZATION_ID

Line 204: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

200: JAI_RGM_TRX_REFS
201: WHERE SOURCE = 'AR'
202: AND TAX_TYPE in ( 'Service' )
203: AND TRUNC(CREATION_DATE) < LV_DATE
204: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE
205: AND ORGANIZATION_ID IN (
206: SELECT
207: DISTINCT
208: ORGANIZATION_ID

Line 460: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE;

456: AND ( NVL(PRM_TODT
457: ,SYSDATE) )
458: AND TO_CHAR(TRXREFS.CREATION_DATE
459: ,'MON-YYYY') = LV_DATE
460: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE;
461: CURSOR CUR_AR_SER_DIST_OUT_DEBIT IS
462: SELECT
463: NVL(SUM(DEBIT_AMOUNT)
464: ,0)

Line 673: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

669: JAI_RGM_TRX_REFS
670: WHERE SOURCE = 'AP'
671: AND TAX_TYPE in ( 'SERVICE_EDUCATION_CESS' )
672: AND TRUNC(CREATION_DATE) < LV_DATE
673: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE
674: AND ORGANIZATION_ID in (
675: SELECT
676: DISTINCT
677: ORGANIZATION_ID

Line 724: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

720: JAI_RGM_TRX_REFS
721: WHERE SOURCE = 'AR'
722: AND TAX_TYPE in ( 'SERVICE_EDUCATION_CESS' )
723: AND TRUNC(CREATION_DATE) < LV_DATE
724: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE
725: AND ORGANIZATION_ID IN (
726: SELECT
727: DISTINCT
728: ORGANIZATION_ID