eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_JE_EXP_PKG dependencies on JA_CN_JOURNAL_LINES

Line 81: l_account_segment ja_cn_journal_lines.account_segment%TYPE;

77: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
78: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
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 := '';

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 172: FROM ja_cn_journal_lines

168: JOURNAL_APPROVER,
169: JOURNAL_POSTER,
170: PERIOD_NAME
171: @COLUMN_CLAUSE
172: FROM ja_cn_journal_lines
173: WHERE period_name = :2
174: AND account_segment = :3
175: @AND_CONDITION
176: AND ledger_id = :4

Line 230: CURSOR c_in_ja_cn_journal_lines IS

226: OR dff_title_code = 'SATP'
227: OR dff_title_code = 'SAEE'
228: OR dff_title_code = 'SAPA');
229:
230: CURSOR c_in_ja_cn_journal_lines IS
231: SELECT DISTINCT account_segment
232: FROM ja_cn_journal_lines
233: WHERE company_segment IN
234: (SELECT bal_seg_value--segment_value

Line 232: FROM ja_cn_journal_lines

228: OR dff_title_code = 'SAPA');
229:
230: CURSOR c_in_ja_cn_journal_lines IS
231: SELECT DISTINCT account_segment
232: FROM ja_cn_journal_lines
233: WHERE company_segment IN
234: (SELECT bal_seg_value--segment_value
235: FROM ja_cn_ledger_le_bsv_gt--ja_cn_legal_companies_all
236: WHERE legal_entity_id = p_legal_entity_id

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 443: OPEN c_in_ja_cn_journal_lines;

439:
440: END IF;
441:
442: --fetch the account subsidiary info and save to temp table
443: OPEN c_in_ja_cn_journal_lines;
444: --log
445: IF (l_statement_level >= l_runtime_level) THEN
446: FND_LOG.STRING(l_statement_level,
447: l_module_name,

Line 460: FETCH c_in_ja_cn_journal_lines

456: nvl(to_char(l_attribute_column4project), 'null') ||
457: ' from FND_FLEX_VALUES where flex_value_set_id=:1 and flex_value=:2';
458:
459: LOOP
460: FETCH c_in_ja_cn_journal_lines
461: INTO l_account_segment;
462: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;
463: --log
464: IF (l_statement_level >= l_runtime_level) THEN

Line 462: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;

458:
459: LOOP
460: FETCH c_in_ja_cn_journal_lines
461: INTO l_account_segment;
462: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;
463: --log
464: IF (l_statement_level >= l_runtime_level) THEN
465: FND_LOG.STRING(l_statement_level,
466: l_module_name,

Line 478: IF (c_in_ja_cn_journal_lines%ROWCOUNT = 0) THEN

474:
475: END LOOP;
476:
477: --no data found with the requested parameters
478: IF (c_in_ja_cn_journal_lines%ROWCOUNT = 0) THEN
479: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
480: l_message := FND_MESSAGE.get();
481: FND_FILE.put_line(FND_FILE.LOG, l_message);
482: IF (l_exception_level >= l_runtime_level) THEN

Line 490: CLOSE c_in_ja_cn_journal_lines;

486: errbuf := l_message;
487: RETURN;
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

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;