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

Line 671: l_period_name gl_periods.period_name%TYPE; --period name of th

667: l_coa_id NUMBER :=P_COA_ID;
668: l_source_application_id NUMBER :=P_SOURCE_APP_ID;
669: l_source_name fnd_application.application_short_name%TYPE;
670: -- PERIODS e current item
671: l_period_name gl_periods.period_name%TYPE; --period name of th
672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;

Line 672: l_period_year gl_periods.period_year%TYPE;

668: l_source_application_id NUMBER :=P_SOURCE_APP_ID;
669: l_source_name fnd_application.application_short_name%TYPE;
670: -- PERIODS e current item
671: l_period_name gl_periods.period_name%TYPE; --period name of th
672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;
676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th

Line 673: l_period_num gl_periods.period_num%TYPE;

669: l_source_name fnd_application.application_short_name%TYPE;
670: -- PERIODS e current item
671: l_period_name gl_periods.period_name%TYPE; --period name of th
672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;
676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th

Line 674: l_period_start_date gl_periods.start_date%TYPE;

670: -- PERIODS e current item
671: l_period_name gl_periods.period_name%TYPE; --period name of th
672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;
676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
678:

Line 675: l_period_end_date gl_periods.end_date%TYPE;

671: l_period_name gl_periods.period_name%TYPE; --period name of th
672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;
676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
678:
679: -- GL: GL_JE_HEADER

Line 676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th

672: l_period_year gl_periods.period_year%TYPE;
673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;
676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
678:
679: -- GL: GL_JE_HEADER
680: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;

Line 677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th

673: l_period_num gl_periods.period_num%TYPE;
674: l_period_start_date gl_periods.start_date%TYPE;
675: l_period_end_date gl_periods.end_date%TYPE;
676: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
678:
679: -- GL: GL_JE_HEADER
680: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

Line 758: FROM gl_periods gp, GL_LEDGERS ledger

754: , gp.period_year
755: , gp.period_num
756: , gp.start_date
757: , gp.end_date
758: FROM gl_periods gp, GL_LEDGERS ledger
759: WHERE ledger.ledger_id = l_ledger_id --using variable P_LEDGER_ID
760: AND ledger.period_set_name = gp.PERIOD_SET_NAME
761: AND ledger.accounted_period_type = gp.period_type
762: AND gp.start_date between

Line 764: FROM GL_PERIODS GP

760: AND ledger.period_set_name = gp.PERIOD_SET_NAME
761: AND ledger.accounted_period_type = gp.period_type
762: AND gp.start_date between
763: (SELECT start_date
764: FROM GL_PERIODS GP
765: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
766: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
767: AND GP.period_name = l_period_name_from) --using parameter P_START_PERIOD
768: and (SELECT start_date

Line 769: FROM GL_PERIODS GP

765: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
766: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
767: AND GP.period_name = l_period_name_from) --using parameter P_START_PERIOD
768: and (SELECT start_date
769: FROM GL_PERIODS GP
770: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
771: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
772: AND GP.period_name = l_period_name_to) --using parameter P_END_PERIOD
773: ORDER BY gp.start_date

Line 1651: FROM gl_periods

1647: l_period_name VARCHAR2(30);
1648: BEGIN
1649: SELECT period_name
1650: INTO l_period_name
1651: FROM gl_periods
1652: WHERE period_set_name = p_period_set_name
1653: AND start_date <=p_gl_date
1654: AND End_Date >=p_gl_date
1655: AND period_type = p_period_type