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_GL_INTER_VALID_PKG dependencies on GL_JE_HEADERS

Line 640: l_status GL_JE_HEADERS.STATUS%TYPE := P_STATUS;

636: l_period_to GL_PERIODS.period_name%TYPE := P_END_PERIOD;
637: l_source gl_je_sources_tl.je_source_name%TYPE :=P_SOURCE;
638: l_journal_ctg gl_je_categories_tl.user_je_category_name%TYPE :=P_JOURNAL_CTG;
639: l_le_name VARCHAR2(240);
640: l_status GL_JE_HEADERS.STATUS%TYPE := P_STATUS;
641: l_sts_settle VARCHAR2(200) := ''; -- the 'where' limitation sqls for certain status
642: l_check_flg VARCHAR2(10) :='FALSE'; -- Flag to determine whether the check of JOURNAL will be continued
643:
644: -- leger parameters

Line 680: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

676: l_all_jnl_catg t_bulk_jnl_catg;
677: l_jnl_catg gl_je_categories_tl.je_category_name%TYPE;
678: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;
679:
680: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
681: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
682: l_je_batch_name GL_JE_BATCHES.name%TYPE;
683: l_je_name GL_JE_HEADERS.name%TYPE;
684: l_je_source GL_JE_HEADERS.je_source%TYPE;

Line 681: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status

677: l_jnl_catg gl_je_categories_tl.je_category_name%TYPE;
678: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;
679:
680: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
681: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
682: l_je_batch_name GL_JE_BATCHES.name%TYPE;
683: l_je_name GL_JE_HEADERS.name%TYPE;
684: l_je_source GL_JE_HEADERS.je_source%TYPE;
685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;

Line 683: l_je_name GL_JE_HEADERS.name%TYPE;

679:
680: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
681: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
682: l_je_batch_name GL_JE_BATCHES.name%TYPE;
683: l_je_name GL_JE_HEADERS.name%TYPE;
684: l_je_source GL_JE_HEADERS.je_source%TYPE;
685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
686: l_je_catg GL_JE_HEADERS.je_category%TYPE;
687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;

Line 684: l_je_source GL_JE_HEADERS.je_source%TYPE;

680: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
681: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
682: l_je_batch_name GL_JE_BATCHES.name%TYPE;
683: l_je_name GL_JE_HEADERS.name%TYPE;
684: l_je_source GL_JE_HEADERS.je_source%TYPE;
685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
686: l_je_catg GL_JE_HEADERS.je_category%TYPE;
687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;

Line 686: l_je_catg GL_JE_HEADERS.je_category%TYPE;

682: l_je_batch_name GL_JE_BATCHES.name%TYPE;
683: l_je_name GL_JE_HEADERS.name%TYPE;
684: l_je_source GL_JE_HEADERS.je_source%TYPE;
685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
686: l_je_catg GL_JE_HEADERS.je_category%TYPE;
687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
689: l_je_desc GL_JE_HEADERS.description%TYPE;
690: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

Line 688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;

684: l_je_source GL_JE_HEADERS.je_source%TYPE;
685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
686: l_je_catg GL_JE_HEADERS.je_category%TYPE;
687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
689: l_je_desc GL_JE_HEADERS.description%TYPE;
690: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
691: l_je_line_desc GL_JE_LINES.description%TYPE;
692: l_language VARCHAR(100):=userenv('LANG');

Line 689: l_je_desc GL_JE_HEADERS.description%TYPE;

685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
686: l_je_catg GL_JE_HEADERS.je_category%TYPE;
687: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
688: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
689: l_je_desc GL_JE_HEADERS.description%TYPE;
690: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
691: l_je_line_desc GL_JE_LINES.description%TYPE;
692: l_language VARCHAR(100):=userenv('LANG');
693: l_characterset varchar(245);

Line 756: ,GL_JE_HEADERS jeh

752: ,src_t.user_je_source_name jnl_usr_source
753: ,catg_t.user_je_category_name jnl_usr_catg
754: ,jeh.status jeh_status
755: FROM GL_JE_BATCHES jeb
756: ,GL_JE_HEADERS jeh
757: ,gl_je_sources_tl src_t
758: ,gl_je_categories_tl catg_t
759: WHERE jeh.ledger_id = l_ledger_id --using variable l_sob_id
760: AND jeb.je_batch_id + 0 = jeh.je_batch_id + 0