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_EXPORT_PKG dependencies on JA_CN_JOURNAL_LINES

Line 89: l_account_segment ja_cn_journal_lines.account_segment%TYPE;

85: NO_DATA EXCEPTION;
86:
87: lv_message VARCHAR2(300);
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;

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

199: segment11,segment12,segment13,segment14,segment15,
200: segment16,segment17,segment18,segment19,segment20,
201: segment21,segment22,segment23,segment24,segment25,
202: segment26,segment27,segment28,segment29,segment30
203: FROM ja_cn_journal_lines
204: WHERE period_name = :3
205: AND account_segment = :4
206: @AND_CONDITION
207: AND ledger_id = :5

Line 257: FROM ja_cn_voucher_number jcvn, ja_cn_journal_lines jc

253: segment16,segment17,segment18,segment19,segment20,
254: segment21,segment22,segment23,segment24,segment25,
255: segment26,segment27,segment28,segment29,segment30
256: FROM (SELECT DISTINCT jc.*, jcvn.voucher_number
257: FROM ja_cn_voucher_number jcvn, ja_cn_journal_lines jc
258: WHERE jcvn.je_header_id = jc.je_header_id
259: AND jcvn.je_line_number = jc.je_line_num) jcjl
260: WHERE jcjl.period_name = :3
261: AND jcjl.account_segment = :4

Line 299: CURSOR c_in_ja_cn_journal_lines

295: prefix_a ||
296: '.je_header_id=jh.je_header_id ';
297:
298: --cursors start here
299: CURSOR c_in_ja_cn_journal_lines
300: IS
301: SELECT DISTINCT account_segment
302: FROM ja_cn_journal_lines
303: WHERE company_segment IN

Line 302: FROM ja_cn_journal_lines

298: --cursors start here
299: CURSOR c_in_ja_cn_journal_lines
300: IS
301: SELECT DISTINCT account_segment
302: FROM ja_cn_journal_lines
303: WHERE company_segment IN
304: (SELECT bal_seg_value
305: FROM ja_cn_ledger_le_bsv_gt
306: WHERE legal_entity_id = pn_legal_entity_id

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

441: DELETE FROM JA_CN_SUBSIDIARY_GT;
442: COMMIT;
443:
444: --fetch the account and save it temp table
445: OPEN c_in_ja_cn_journal_lines;
446: --log
447: IF (ln_statement_level >= ln_dbg_level) THEN
448: FND_LOG.STRING(ln_statement_level,
449: lv_procedure_name,

Line 457: FETCH c_in_ja_cn_journal_lines

453: --the context code is not necessary to be a condition to query out the signs for subsidiary
454: lv_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT (ACCOUNT_SEGMENT_VALUE) select flex_value' ||
455: ' from FND_FLEX_VALUES where flex_value_set_id=:1 and flex_value=:2';
456: LOOP
457: FETCH c_in_ja_cn_journal_lines
458: INTO l_account_segment;
459: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;
460:
461: EXECUTE IMMEDIATE lv_sql_stmt

Line 459: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;

455: ' from FND_FLEX_VALUES where flex_value_set_id=:1 and flex_value=:2';
456: LOOP
457: FETCH c_in_ja_cn_journal_lines
458: INTO l_account_segment;
459: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;
460:
461: EXECUTE IMMEDIATE lv_sql_stmt
462: USING ln_flex_value_set_id, l_account_segment;
463:

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

463:
464: END LOOP;
465:
466: --no data found with the requested parameters
467: IF (c_in_ja_cn_journal_lines%ROWCOUNT = 0) THEN
468: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
469: lv_message := FND_MESSAGE.get();
470: FND_FILE.put_line(FND_FILE.LOG, lv_message);
471: IF (ln_exception_level >= ln_dbg_level) THEN

Line 476: CLOSE c_in_ja_cn_journal_lines;

472: FND_LOG.STRING(ln_exception_level, lv_procedure_name, lv_message);
473: END IF;
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

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;