APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_CATEGORIES_TL

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

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

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

671: l_invalid_jnl_count number; --count of all invalid journals
672: l_invalid_lines number; --count of all invalid lines
673: l_invalid_line_4_jnl number; --count of invalid lines of a journal
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:

Line 677: l_jnl_catg gl_je_categories_tl.je_category_name%TYPE;

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

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

Line 721: FROM gl_je_categories_tl jec

717: -- ?? not sure
718: CURSOR c_all_jnl_catg IS
719: SELECT jec.je_category_name catg_name
720: --,jec.user_je_category_name catg_user_name
721: FROM gl_je_categories_tl jec
722: ,JA_CN_DFF_ASSIGNMENTS DFF
723: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
724: AND jec.context = DFF.CONTEXT_CODE
725: AND jec.language = userenv('LANG')

Line 758: ,gl_je_categories_tl catg_t

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

Line 1005: FROM gl_je_categories_tl jec

1001: IF l_journal_ctg is not null
1002: THEN
1003: SELECT distinct jec.je_category_name catg_name
1004: INTO l_jnl_catg
1005: FROM gl_je_categories_tl jec
1006: ,JA_CN_DFF_ASSIGNMENTS DFF
1007: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
1008: AND jec.context = DFF.CONTEXT_CODE
1009: AND jec.language = l_language