APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_SOURCES_TL

Line 637: l_source gl_je_sources_tl.je_source_name%TYPE :=P_SOURCE;

633: l_coa_id NUMBER := P_COA_ID;
634: l_ledger_id NUMBER := P_LEDGER_ID;
635: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;
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

Line 678: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;

674:
675: type t_bulk_jnl_catg is table of gl_je_categories_tl.je_category_name%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;

Line 685: l_je_usr_source gl_je_sources_tl.user_je_source_name%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;
689: l_je_desc GL_JE_HEADERS.description%TYPE;

Line 736: FROM gl_je_sources_tl jes

732: /*--Cursor to get all Journal Sources
733: CURSOR c_all_jnl_src IS
734: SELECT jes.je_source_name src_name
735: --,jes.user_je_source_name src_user_name
736: FROM gl_je_sources_tl jes
737: WHERE jes.language = userenv('LANG')
738: ;
739: */
740:

Line 757: ,gl_je_sources_tl src_t

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
761: AND jeb.je_batch_id > 0

Line 994: FROM gl_je_sources_tl jes

990:
991: --Get Journal Source; P_SOURCE is a required parameter.
992: SELECT jes.je_source_name
993: INTO l_jnl_src
994: FROM gl_je_sources_tl jes
995: WHERE jes.user_je_source_name = l_source -- ?? not sure
996: AND jes.language = l_language; -- ?? userenv('LANG');
997:
998: --Get cash related Journal Categories: specified in P_JOURNAL_CTG or all.