APPS.JA_CN_JE_EXP_PKG dependencies on JA_CN_JOURNAL_LINES_GT

Line 83: l_journal_lines_gbl_tmp_row ja_cn_journal_lines_gt%ROWTYPE;

79: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
80: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
81: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
82: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
83: l_journal_lines_gbl_tmp_row ja_cn_journal_lines_gt%ROWTYPE;
84: l_sql_stmt VARCHAR2(30000) := '';
85: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';
86: l_journal_line_number NUMBER := 0;
87: l_functional_currency fnd_currencies_vl.NAME%TYPE;

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

81: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
82: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
83: l_journal_lines_gbl_tmp_row ja_cn_journal_lines_gt%ROWTYPE;
84: l_sql_stmt VARCHAR2(30000) := '';
85: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';
86: l_journal_line_number NUMBER := 0;
87: l_functional_currency fnd_currencies_vl.NAME%TYPE;
88:
89: l_start_date DATE;

Line 94: l_sql_stmt4insert_j_line CONSTANT VARCHAR2(30000) := 'INSERT INTO ja_cn_journal_lines_gt

90: l_end_date DATE;
91: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;
92: l_current_start_date DATE;
93:
94: l_sql_stmt4insert_j_line CONSTANT VARCHAR2(30000) := 'INSERT INTO ja_cn_journal_lines_gt
95: (journal_number,
96: je_category,
97: description,
98: default_effective_date,

Line 252: FROM ja_cn_journal_lines_gt

248: SELECT * FROM ja_cn_subsidiary_gt;
249:
250: CURSOR c_in_journal_lines_gbl_tmp IS
251: SELECT *
252: FROM ja_cn_journal_lines_gt
253: ORDER BY start_date, to_number(journal_number), to_number(je_line_num);
254:
255: CURSOR c_in_closed_periods IS
256: SELECT period_name

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

488:
489: END IF;
490: CLOSE c_in_ja_cn_journal_lines;
491:
492: --combine the journal lines and save them to the JA_CN_JOURNAL_LINES_GT
493: OPEN c_in_closed_periods;
494: LOOP
495: FETCH c_in_closed_periods
496: INTO l_current_period;