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 635: l_status GL_JE_HEADERS.STATUS%TYPE := P_STATUS;

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

Line 675: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

671: l_all_jnl_catg t_bulk_jnl_catg;
672: l_jnl_catg gl_je_categories_tl.je_category_name%TYPE;
673: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;
674:
675: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
676: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
677: l_je_batch_name GL_JE_BATCHES.name%TYPE;
678: l_je_name GL_JE_HEADERS.name%TYPE;
679: l_je_source GL_JE_HEADERS.je_source%TYPE;

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

672: l_jnl_catg gl_je_categories_tl.je_category_name%TYPE;
673: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;
674:
675: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
676: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
677: l_je_batch_name GL_JE_BATCHES.name%TYPE;
678: l_je_name GL_JE_HEADERS.name%TYPE;
679: l_je_source GL_JE_HEADERS.je_source%TYPE;
680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;

Line 678: l_je_name GL_JE_HEADERS.name%TYPE;

674:
675: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
676: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
677: l_je_batch_name GL_JE_BATCHES.name%TYPE;
678: l_je_name GL_JE_HEADERS.name%TYPE;
679: l_je_source GL_JE_HEADERS.je_source%TYPE;
680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
681: l_je_catg GL_JE_HEADERS.je_category%TYPE;
682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;

Line 679: l_je_source GL_JE_HEADERS.je_source%TYPE;

675: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
676: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
677: l_je_batch_name GL_JE_BATCHES.name%TYPE;
678: l_je_name GL_JE_HEADERS.name%TYPE;
679: l_je_source GL_JE_HEADERS.je_source%TYPE;
680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
681: l_je_catg GL_JE_HEADERS.je_category%TYPE;
682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;

Line 681: l_je_catg GL_JE_HEADERS.je_category%TYPE;

677: l_je_batch_name GL_JE_BATCHES.name%TYPE;
678: l_je_name GL_JE_HEADERS.name%TYPE;
679: l_je_source GL_JE_HEADERS.je_source%TYPE;
680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
681: l_je_catg GL_JE_HEADERS.je_category%TYPE;
682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
684: l_je_desc GL_JE_HEADERS.description%TYPE;
685: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

Line 683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;

679: l_je_source GL_JE_HEADERS.je_source%TYPE;
680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
681: l_je_catg GL_JE_HEADERS.je_category%TYPE;
682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
684: l_je_desc GL_JE_HEADERS.description%TYPE;
685: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
686: l_je_line_desc GL_JE_LINES.description%TYPE;
687: l_language VARCHAR(100):=userenv('LANG');

Line 684: l_je_desc GL_JE_HEADERS.description%TYPE;

680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
681: l_je_catg GL_JE_HEADERS.je_category%TYPE;
682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
684: l_je_desc GL_JE_HEADERS.description%TYPE;
685: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
686: l_je_line_desc GL_JE_LINES.description%TYPE;
687: l_language VARCHAR(100):=userenv('LANG');
688: l_characterset varchar(245);

Line 751: ,GL_JE_HEADERS jeh

747: ,src_t.user_je_source_name jnl_usr_source
748: ,catg_t.user_je_category_name jnl_usr_catg
749: ,jeh.status jeh_status
750: FROM GL_JE_BATCHES jeb
751: ,GL_JE_HEADERS jeh
752: ,gl_je_sources_tl src_t
753: ,gl_je_categories_tl catg_t
754: WHERE jeh.ledger_id = l_ledger_id --using variable l_sob_id
755: AND jeb.je_batch_id + 0 = jeh.je_batch_id + 0