APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_CATEGORIES_TL

Line 633: l_journal_ctg gl_je_categories_tl.user_je_category_name%TYPE :=P_JOURNAL_CTG;

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
637: l_check_flg VARCHAR2(10) :='FALSE'; -- Flag to determine whether the check of JOURNAL will be continued

Line 670: type t_bulk_jnl_catg is table of gl_je_categories_tl.je_category_name%type;

666: l_invalid_jnl_count number; --count of all invalid journals
667: l_invalid_lines number; --count of all invalid lines
668: l_invalid_line_4_jnl number; --count of invalid lines of a journal
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:

Line 672: l_jnl_catg gl_je_categories_tl.je_category_name%TYPE;

668: l_invalid_line_4_jnl number; --count of invalid lines of a journal
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

Line 682: l_je_usr_catg gl_je_categories_tl.user_je_category_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;
686: l_je_line_desc GL_JE_LINES.description%TYPE;

Line 716: FROM gl_je_categories_tl jec

712: -- ?? not sure
713: CURSOR c_all_jnl_catg IS
714: SELECT jec.je_category_name catg_name
715: --,jec.user_je_category_name catg_user_name
716: FROM gl_je_categories_tl jec
717: ,JA_CN_DFF_ASSIGNMENTS DFF
718: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
719: AND jec.context = DFF.CONTEXT_CODE
720: AND jec.language = userenv('LANG')

Line 753: ,gl_je_categories_tl catg_t

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
757: AND jeh.period_name = l_period_name --using variable l_period_name

Line 968: FROM gl_je_categories_tl jec

964: IF l_journal_ctg is not null
965: THEN
966: SELECT distinct jec.je_category_name catg_name
967: INTO l_jnl_catg
968: FROM gl_je_categories_tl jec
969: ,JA_CN_DFF_ASSIGNMENTS DFF
970: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
971: AND jec.context = DFF.CONTEXT_CODE
972: AND jec.language = l_language