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_CN_CFS_REPORT_PKG dependencies on GL_PERIODS

Line 465: L_PERIOD_NUM_FROM GL_PERIODS.PERIOD_NUM%TYPE;

461: L_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
462: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
463: L_PROC_NAME VARCHAR2(100) := 'Cfs_Detail_Report';
464: L_LE_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
465: L_PERIOD_NUM_FROM GL_PERIODS.PERIOD_NUM%TYPE;
466: L_PERIOD_NUM_TO GL_PERIODS.PERIOD_NUM%TYPE;
467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;
468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;

Line 466: L_PERIOD_NUM_TO GL_PERIODS.PERIOD_NUM%TYPE;

462: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
463: L_PROC_NAME VARCHAR2(100) := 'Cfs_Detail_Report';
464: L_LE_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
465: L_PERIOD_NUM_FROM GL_PERIODS.PERIOD_NUM%TYPE;
466: L_PERIOD_NUM_TO GL_PERIODS.PERIOD_NUM%TYPE;
467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;
468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;
470: L_PERIOD_TYPE GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE%TYPE;

Line 467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;

463: L_PROC_NAME VARCHAR2(100) := 'Cfs_Detail_Report';
464: L_LE_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
465: L_PERIOD_NUM_FROM GL_PERIODS.PERIOD_NUM%TYPE;
466: L_PERIOD_NUM_TO GL_PERIODS.PERIOD_NUM%TYPE;
467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;
468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;
470: L_PERIOD_TYPE GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE%TYPE;
471: L_YEAR_FROM GL_PERIODS.PERIOD_YEAR%TYPE;

Line 468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;

464: L_LE_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
465: L_PERIOD_NUM_FROM GL_PERIODS.PERIOD_NUM%TYPE;
466: L_PERIOD_NUM_TO GL_PERIODS.PERIOD_NUM%TYPE;
467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;
468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;
470: L_PERIOD_TYPE GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE%TYPE;
471: L_YEAR_FROM GL_PERIODS.PERIOD_YEAR%TYPE;
472: L_YEAR_TO GL_PERIODS.PERIOD_YEAR%TYPE;

Line 469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;

465: L_PERIOD_NUM_FROM GL_PERIODS.PERIOD_NUM%TYPE;
466: L_PERIOD_NUM_TO GL_PERIODS.PERIOD_NUM%TYPE;
467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;
468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;
470: L_PERIOD_TYPE GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE%TYPE;
471: L_YEAR_FROM GL_PERIODS.PERIOD_YEAR%TYPE;
472: L_YEAR_TO GL_PERIODS.PERIOD_YEAR%TYPE;
473: L_TRX_ID NUMBER;

Line 471: L_YEAR_FROM GL_PERIODS.PERIOD_YEAR%TYPE;

467: L_DATE_FROM GL_PERIODS.START_DATE%TYPE;
468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;
470: L_PERIOD_TYPE GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE%TYPE;
471: L_YEAR_FROM GL_PERIODS.PERIOD_YEAR%TYPE;
472: L_YEAR_TO GL_PERIODS.PERIOD_YEAR%TYPE;
473: L_TRX_ID NUMBER;
474: L_TRX_LINE_ID NUMBER;
475:

Line 472: L_YEAR_TO GL_PERIODS.PERIOD_YEAR%TYPE;

468: L_DATE_TO GL_PERIODS.END_DATE%TYPE;
469: L_PERIOD_SET_NAME GL_PERIODS.PERIOD_SET_NAME%TYPE;
470: L_PERIOD_TYPE GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE%TYPE;
471: L_YEAR_FROM GL_PERIODS.PERIOD_YEAR%TYPE;
472: L_YEAR_TO GL_PERIODS.PERIOD_YEAR%TYPE;
473: L_TRX_ID NUMBER;
474: L_TRX_LINE_ID NUMBER;
475:
476: -- Fix bug#6697073 begin ------------------------

Line 485: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;

481: L_INVOICE_NUM1 INVOICE_NUM_TBL := INVOICE_NUM_TBL();-- Fix bug#6920953 add
482: L_TRX_NUMBER varchar2(240):=null;
483: -- Fix bug#6697073 end --------------------------
484:
485: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
486: L_PERIOD_NAME JA_CN_CFS_ACTIVITIES_ALL.PERIOD_NAME%TYPE;
487: L_FUNC_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.FUNC_AMOUNT%TYPE;
488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;
489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;

Line 553: ,GL_PERIODS GP

549: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
550: ,RG_REPORT_AXES RRA
551: ,RG_REPORTS RG
552: ,GL_LEDGERS LED
553: ,GL_PERIODS GP
554: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID
555: AND JCA.LEDGER_ID = P_LEDGER_ID
556: AND JCA.GL_DATE >= L_DATE_FROM
557: AND JCA.GL_DATE <= L_DATE_TO

Line 851: ,GL_PERIODS GP1

847: INTO L_PERIOD_SET_NAME
848: ,L_YEAR_FROM
849: ,L_YEAR_TO
850: FROM GL_LEDGERS LED
851: ,GL_PERIODS GP1
852: ,GL_PERIODS GP2
853: WHERE LED.LEDGER_ID = P_LEDGER_ID
854: AND GP1.PERIOD_SET_NAME = LED.PERIOD_SET_NAME
855: AND GP1.PERIOD_NAME = P_GL_PERIOD_FROM

Line 852: ,GL_PERIODS GP2

848: ,L_YEAR_FROM
849: ,L_YEAR_TO
850: FROM GL_LEDGERS LED
851: ,GL_PERIODS GP1
852: ,GL_PERIODS GP2
853: WHERE LED.LEDGER_ID = P_LEDGER_ID
854: AND GP1.PERIOD_SET_NAME = LED.PERIOD_SET_NAME
855: AND GP1.PERIOD_NAME = P_GL_PERIOD_FROM
856: AND GP2.PERIOD_SET_NAME = LED.PERIOD_SET_NAME

Line 877: FROM GL_PERIODS

873: SELECT PERIOD_YEAR * 1000 + PERIOD_NUM
874: ,START_DATE
875: INTO L_PERIOD_NUM_FROM
876: ,L_DATE_FROM
877: FROM GL_PERIODS
878: WHERE PERIOD_SET_NAME = L_PERIOD_SET_NAME
879: AND PERIOD_NAME = P_GL_PERIOD_FROM
880: AND PERIOD_TYPE = L_PERIOD_TYPE;
881:

Line 887: FROM GL_PERIODS

883: SELECT PERIOD_YEAR * 1000 + PERIOD_NUM
884: ,END_DATE
885: INTO L_PERIOD_NUM_TO
886: ,L_DATE_TO
887: FROM GL_PERIODS
888: WHERE PERIOD_SET_NAME = L_PERIOD_SET_NAME
889: AND PERIOD_NAME = P_GL_PERIOD_TO
890: AND PERIOD_TYPE = L_PERIOD_TYPE;
891: --for each periods