APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_SOURCES_TL

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

628: l_coa_id NUMBER := P_COA_ID;
629: l_ledger_id NUMBER := P_LEDGER_ID;
630: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;
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

Line 673: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;

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

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

Line 731: FROM gl_je_sources_tl jes

727: /*--Cursor to get all Journal Sources
728: CURSOR c_all_jnl_src IS
729: SELECT jes.je_source_name src_name
730: --,jes.user_je_source_name src_user_name
731: FROM gl_je_sources_tl jes
732: WHERE jes.language = userenv('LANG')
733: ;
734: */
735:

Line 752: ,gl_je_sources_tl src_t

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

Line 957: FROM gl_je_sources_tl jes

953:
954: --Get Journal Source; P_SOURCE is a required parameter.
955: SELECT jes.je_source_name
956: INTO l_jnl_src
957: FROM gl_je_sources_tl jes
958: WHERE jes.user_je_source_name = l_source -- ?? not sure
959: AND jes.language = l_language; -- ?? userenv('LANG');
960:
961: --Get cash related Journal Categories: specified in P_JOURNAL_CTG or all.