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 653: l_period_name gl_periods.period_name%TYPE; --period name of th

649: l_coa_id NUMBER :=P_COA_ID;
650: l_source_application_id NUMBER :=P_SOURCE_APP_ID;
651: l_source_name fnd_application.application_short_name%TYPE;
652: -- PERIODS e current item
653: l_period_name gl_periods.period_name%TYPE; --period name of th
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;

Line 654: l_period_year gl_periods.period_year%TYPE;

650: l_source_application_id NUMBER :=P_SOURCE_APP_ID;
651: l_source_name fnd_application.application_short_name%TYPE;
652: -- PERIODS e current item
653: l_period_name gl_periods.period_name%TYPE; --period name of th
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;
658: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th

Line 655: l_period_num gl_periods.period_num%TYPE;

651: l_source_name fnd_application.application_short_name%TYPE;
652: -- PERIODS e current item
653: l_period_name gl_periods.period_name%TYPE; --period name of th
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;
658: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
659: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th

Line 656: l_period_start_date gl_periods.start_date%TYPE;

652: -- PERIODS e current item
653: l_period_name gl_periods.period_name%TYPE; --period name of th
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;
658: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
659: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
660:

Line 657: l_period_end_date gl_periods.end_date%TYPE;

653: l_period_name gl_periods.period_name%TYPE; --period name of th
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;
658: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
659: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
660:
661: -- GL: GL_JE_HEADER

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

654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;
658: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
659: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
660:
661: -- GL: GL_JE_HEADER
662: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;

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

655: l_period_num gl_periods.period_num%TYPE;
656: l_period_start_date gl_periods.start_date%TYPE;
657: l_period_end_date gl_periods.end_date%TYPE;
658: l_period_name_from gl_periods.period_name%TYPE:=P_GL_PERIOD_FROM; --period name of th
659: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
660:
661: -- GL: GL_JE_HEADER
662: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

Line 740: FROM gl_periods gp, GL_LEDGERS ledger

736: , gp.period_year
737: , gp.period_num
738: , gp.start_date
739: , gp.end_date
740: FROM gl_periods gp, GL_LEDGERS ledger
741: WHERE ledger.ledger_id = l_ledger_id --using variable P_LEDGER_ID
742: AND ledger.period_set_name = gp.PERIOD_SET_NAME
743: AND ledger.accounted_period_type = gp.period_type
744: AND gp.start_date between

Line 746: FROM GL_PERIODS GP

742: AND ledger.period_set_name = gp.PERIOD_SET_NAME
743: AND ledger.accounted_period_type = gp.period_type
744: AND gp.start_date between
745: (SELECT start_date
746: FROM GL_PERIODS GP
747: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
748: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
749: AND GP.period_name = l_period_name_from) --using parameter P_START_PERIOD
750: and (SELECT start_date

Line 751: FROM GL_PERIODS GP

747: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
748: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
749: AND GP.period_name = l_period_name_from) --using parameter P_START_PERIOD
750: and (SELECT start_date
751: FROM GL_PERIODS GP
752: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
753: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
754: AND GP.period_name = l_period_name_to) --using parameter P_END_PERIOD
755: ORDER BY gp.start_date

Line 1600: FROM gl_periods

1596: l_period_name VARCHAR2(30);
1597: BEGIN
1598: SELECT period_name
1599: INTO l_period_name
1600: FROM gl_periods
1601: WHERE period_set_name = p_period_set_name
1602: AND start_date <=p_gl_date
1603: AND End_Date >=p_gl_date
1604: AND period_type = p_period_type