APPS.JA_CN_JE_EXPORT_PKG dependencies on JA_CN_JOURNAL_LINES_GT

Line 92: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';

88: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
89: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
90: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
91: lv_sql_stmt VARCHAR2(30000) := '';
92: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';
93: ln_journal_line_number NUMBER := 0;
94: l_functional_currency fnd_currencies_vl.NAME%TYPE;
95:
96: ld_start_date DATE;

Line 103: lv_sql_stmt4insert_j_line CONSTANT VARCHAR2(30000) := 'INSERT INTO ja_cn_journal_lines_gt

99: ld_current_start_date DATE;
100: ln_current_period_num NUMBER;
101: ln_row_count NUMBER := 0;
102: lv_je_category VARCHAR2(200);
103: lv_sql_stmt4insert_j_line CONSTANT VARCHAR2(30000) := 'INSERT INTO ja_cn_journal_lines_gt
104: (journal_number,
105: je_category,
106: description,
107: default_effective_date,

Line 334: FROM ja_cn_journal_lines_gt

330:
331: CURSOR c_in_journal_lines_gbl_tmp
332: IS
333: SELECT *
334: FROM ja_cn_journal_lines_gt
335: ORDER BY start_date, to_number(journal_number), to_number(je_line_num);
336:
337: BEGIN
338: --log the parameters

Line 478: --combine the journal lines and save them to the JA_CN_JOURNAL_LINES_GT

474: ln_row_count := 0;
475: END IF;
476: CLOSE c_in_ja_cn_journal_lines;
477:
478: --combine the journal lines and save them to the JA_CN_JOURNAL_LINES_GT
479: OPEN c_in_closed_periods;
480: LOOP
481: FETCH c_in_closed_periods
482: INTO l_current_period;