APPS.JA_CN_JE_EXPORT_PKG dependencies on JA_CN_SUBSIDIARY_GT

Line 59: -- JA_CN_SUBSIDIARY_GT temporary table before

55: --
56: -- CHANGE HISTORY:
57: -- 18-Mar-2010 Wei Huang Created
58: -- 13-APr-2010 Wei Huang Updated Procedure Add_Journal, Clear the
59: -- JA_CN_SUBSIDIARY_GT temporary table before
60: -- insert data to it.
61: -- 19-May-2010 Wei Huang Updated procedure Add_journal, change the
62: -- exporting of Bill Date from eight spaces to
63: -- the default of fixed date '00000000'.

Line 90: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;

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;
94: l_functional_currency fnd_currencies_vl.NAME%TYPE;

Line 291: ' left join JA_CN_SUBSIDIARY_GT s on ' ||

287: segment21,segment22,segment23,segment24,segment25,
288: segment26,segment27,segment28,segment29,segment30
289: ) ' ||
290: prefix_a ||
291: ' left join JA_CN_SUBSIDIARY_GT s on ' ||
292: prefix_a ||
293: '.account_segment=s.ACCOUNT_SEGMENT_VALUE' ||
294: ' LEFT JOIN GL_JE_HEADERS jh ON ' ||
295: prefix_a ||

Line 319: SELECT * FROM ja_cn_subsidiary_gt;

315: AND ledger_id = pn_ledger_id;
316:
317: CURSOR c_in_ja_cn_subsidiary_gbl_tmp
318: IS
319: SELECT * FROM ja_cn_subsidiary_gt;
320:
321: CURSOR c_in_closed_periods
322: IS
323: SELECT period_name

Line 439: --Clear the JA_CN_SUBSIDIARY_GT temporary table as the Accounting

435: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
436: '.variable:' ||
437: 'ln_flex_value_set_id=' || ln_flex_value_set_id);
438:
439: --Clear the JA_CN_SUBSIDIARY_GT temporary table as the Accounting
440: --Balance already inserted data
441: DELETE FROM JA_CN_SUBSIDIARY_GT;
442: COMMIT;
443:

Line 441: DELETE FROM JA_CN_SUBSIDIARY_GT;

437: 'ln_flex_value_set_id=' || ln_flex_value_set_id);
438:
439: --Clear the JA_CN_SUBSIDIARY_GT temporary table as the Accounting
440: --Balance already inserted data
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;

Line 454: lv_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT (ACCOUNT_SEGMENT_VALUE) select flex_value' ||

450: 'Fetched account segments start below:');
451:
452: END IF; --ln_statement_level >= ln_dbg_level
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;