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 78: L_START_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;

74: L_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
75: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
76: L_PROC_NAME VARCHAR2(100) := 'Prepare_CFS_Detail_Report';
77:
78: L_START_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;
79: L_END_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;
80:
81: /*L_ERROR_STATUS BOOLEAN;*/
82: JA_CN_INVALID_GLPERIOD EXCEPTION;

Line 79: L_END_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;

75: L_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
76: L_PROC_NAME VARCHAR2(100) := 'Prepare_CFS_Detail_Report';
77:
78: L_START_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;
79: L_END_YEAR GL_PERIODS.PERIOD_YEAR%TYPE;
80:
81: /*L_ERROR_STATUS BOOLEAN;*/
82: JA_CN_INVALID_GLPERIOD EXCEPTION;
83: L_MSG_INVALID_GLPERIOD VARCHAR2(2000);

Line 85: /* L_PERIOD_NAME GL_PERIODS.PERIOD_NAME%TYPE;

81: /*L_ERROR_STATUS BOOLEAN;*/
82: JA_CN_INVALID_GLPERIOD EXCEPTION;
83: L_MSG_INVALID_GLPERIOD VARCHAR2(2000);
84:
85: /* L_PERIOD_NAME GL_PERIODS.PERIOD_NAME%TYPE;
86: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
87: L_ROW_ID RG_REPORT_AXES.AXIS_SEQ%TYPE;
88:
89: L_ROW_NAME RG_REPORT_AXES.DESCRIPTION%TYPE;

Line 86: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;

82: JA_CN_INVALID_GLPERIOD EXCEPTION;
83: L_MSG_INVALID_GLPERIOD VARCHAR2(2000);
84:
85: /* L_PERIOD_NAME GL_PERIODS.PERIOD_NAME%TYPE;
86: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
87: L_ROW_ID RG_REPORT_AXES.AXIS_SEQ%TYPE;
88:
89: L_ROW_NAME RG_REPORT_AXES.DESCRIPTION%TYPE;
90: L_TRX_ID NUMBER;

Line 103: ,GL_PERIODS GP

99: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
100: ,RG_REPORT_AXES RRA
101: ,RG_REPORTS RG
102: ,GL_LEDGERS LED
103: ,GL_PERIODS GP
104: ,GL_PERIODS GP1
105: ,GL_PERIODS GP2
106: WHERE JCA.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
107: AND JCA.LEDGER_ID = P_LEDGER_ID

Line 104: ,GL_PERIODS GP1

100: ,RG_REPORT_AXES RRA
101: ,RG_REPORTS RG
102: ,GL_LEDGERS LED
103: ,GL_PERIODS GP
104: ,GL_PERIODS GP1
105: ,GL_PERIODS GP2
106: WHERE JCA.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
107: AND JCA.LEDGER_ID = P_LEDGER_ID
108: AND JCA.SOURCE = NVL(P_SOURCE, JCA.SOURCE)

Line 105: ,GL_PERIODS GP2

101: ,RG_REPORTS RG
102: ,GL_LEDGERS LED
103: ,GL_PERIODS GP
104: ,GL_PERIODS GP1
105: ,GL_PERIODS GP2
106: WHERE JCA.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
107: AND JCA.LEDGER_ID = P_LEDGER_ID
108: AND JCA.SOURCE = NVL(P_SOURCE, JCA.SOURCE)
109: AND JCA.GL_DATE >= GP1.START_DATE

Line 327: ,GL_PERIODS GP1

323: ,GP2.PERIOD_YEAR
324: INTO L_START_YEAR
325: ,L_END_YEAR
326: FROM GL_LEDGERS LED
327: ,GL_PERIODS GP1
328: ,GL_PERIODS GP2
329: WHERE LED.LEDGER_ID = P_LEDGER_ID
330: AND GP1.PERIOD_SET_NAME = LED.PERIOD_SET_NAME
331: AND GP1.PERIOD_NAME = P_START_PERIOD

Line 328: ,GL_PERIODS GP2

324: INTO L_START_YEAR
325: ,L_END_YEAR
326: FROM GL_LEDGERS LED
327: ,GL_PERIODS GP1
328: ,GL_PERIODS GP2
329: WHERE LED.LEDGER_ID = P_LEDGER_ID
330: AND GP1.PERIOD_SET_NAME = LED.PERIOD_SET_NAME
331: AND GP1.PERIOD_NAME = P_START_PERIOD
332: AND GP2.PERIOD_SET_NAME = LED.PERIOD_SET_NAME