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_DFF_ASSIGNMENTS

Line 75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;

71: l_message VARCHAR2(300);
72: --l_set_of_books_id ja_cn_system_parameters_all.legal_entity_id%TYPE;
73: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
74: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
76: l_context_code ja_cn_dff_assignments.context_code%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;

Line 76: l_context_code ja_cn_dff_assignments.context_code%TYPE;

72: --l_set_of_books_id ja_cn_system_parameters_all.legal_entity_id%TYPE;
73: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
74: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
76: l_context_code ja_cn_dff_assignments.context_code%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;

Line 77: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;

73: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
74: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
76: l_context_code ja_cn_dff_assignments.context_code%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;

Line 78: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;

74: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
76: l_context_code ja_cn_dff_assignments.context_code%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;

Line 79: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;

75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
76: l_context_code ja_cn_dff_assignments.context_code%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;

Line 80: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;

76: l_context_code ja_cn_dff_assignments.context_code%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) := '';

Line 221: CURSOR c_in_ja_cn_dff_assignments IS

217: --exceptions start here
218: --sob_unfetchable EXCEPTION;
219:
220: --cursors start here
221: CURSOR c_in_ja_cn_dff_assignments IS
222: SELECT *
223: FROM ja_cn_dff_assignments
224: WHERE chart_of_accounts_id = p_coa_id
225: AND (dff_title_code = 'SACC'

Line 223: FROM ja_cn_dff_assignments

219:
220: --cursors start here
221: CURSOR c_in_ja_cn_dff_assignments IS
222: SELECT *
223: FROM ja_cn_dff_assignments
224: WHERE chart_of_accounts_id = p_coa_id
225: AND (dff_title_code = 'SACC'
226: OR dff_title_code = 'SATP'
227: OR dff_title_code = 'SAEE'

Line 396: OPEN c_in_ja_cn_dff_assignments;

392: nvl(to_char(l_flex_value_set_id), 'null'));
393: END IF;
394:
395: --fetch context code, attribute column for cost center, third party, personnel and project
396: OPEN c_in_ja_cn_dff_assignments;
397: LOOP
398: FETCH c_in_ja_cn_dff_assignments
399: INTO l_ja_cn_dff_assignments_row;
400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;

Line 398: FETCH c_in_ja_cn_dff_assignments

394:
395: --fetch context code, attribute column for cost center, third party, personnel and project
396: OPEN c_in_ja_cn_dff_assignments;
397: LOOP
398: FETCH c_in_ja_cn_dff_assignments
399: INTO l_ja_cn_dff_assignments_row;
400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;
401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN
402: l_context_code := l_ja_cn_dff_assignments_row.context_code;

Line 399: INTO l_ja_cn_dff_assignments_row;

395: --fetch context code, attribute column for cost center, third party, personnel and project
396: OPEN c_in_ja_cn_dff_assignments;
397: LOOP
398: FETCH c_in_ja_cn_dff_assignments
399: INTO l_ja_cn_dff_assignments_row;
400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;
401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN
402: l_context_code := l_ja_cn_dff_assignments_row.context_code;
403: END IF;

Line 400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;

396: OPEN c_in_ja_cn_dff_assignments;
397: LOOP
398: FETCH c_in_ja_cn_dff_assignments
399: INTO l_ja_cn_dff_assignments_row;
400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;
401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN
402: l_context_code := l_ja_cn_dff_assignments_row.context_code;
403: END IF;
404: CASE l_ja_cn_dff_assignments_row.dff_title_code

Line 401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN

397: LOOP
398: FETCH c_in_ja_cn_dff_assignments
399: INTO l_ja_cn_dff_assignments_row;
400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;
401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN
402: l_context_code := l_ja_cn_dff_assignments_row.context_code;
403: END IF;
404: CASE l_ja_cn_dff_assignments_row.dff_title_code
405: WHEN 'SACC' THEN

Line 402: l_context_code := l_ja_cn_dff_assignments_row.context_code;

398: FETCH c_in_ja_cn_dff_assignments
399: INTO l_ja_cn_dff_assignments_row;
400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;
401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN
402: l_context_code := l_ja_cn_dff_assignments_row.context_code;
403: END IF;
404: CASE l_ja_cn_dff_assignments_row.dff_title_code
405: WHEN 'SACC' THEN
406: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;

Line 404: CASE l_ja_cn_dff_assignments_row.dff_title_code

400: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;
401: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN
402: l_context_code := l_ja_cn_dff_assignments_row.context_code;
403: END IF;
404: CASE l_ja_cn_dff_assignments_row.dff_title_code
405: WHEN 'SACC' THEN
406: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;
407: WHEN 'SATP' THEN
408: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;

Line 406: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;

402: l_context_code := l_ja_cn_dff_assignments_row.context_code;
403: END IF;
404: CASE l_ja_cn_dff_assignments_row.dff_title_code
405: WHEN 'SACC' THEN
406: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;
407: WHEN 'SATP' THEN
408: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
409: WHEN 'SAEE' THEN
410: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;

Line 408: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;

404: CASE l_ja_cn_dff_assignments_row.dff_title_code
405: WHEN 'SACC' THEN
406: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;
407: WHEN 'SATP' THEN
408: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
409: WHEN 'SAEE' THEN
410: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
411: WHEN 'SAPA' THEN
412: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;

Line 410: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;

406: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;
407: WHEN 'SATP' THEN
408: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
409: WHEN 'SAEE' THEN
410: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
411: WHEN 'SAPA' THEN
412: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
413: END CASE; END LOOP;
414: CLOSE c_in_ja_cn_dff_assignments;

Line 412: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;

408: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
409: WHEN 'SAEE' THEN
410: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
411: WHEN 'SAPA' THEN
412: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
413: END CASE; END LOOP;
414: CLOSE c_in_ja_cn_dff_assignments;
415: --log
416: IF (l_statement_level >= l_runtime_level) THEN

Line 414: CLOSE c_in_ja_cn_dff_assignments;

410: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
411: WHEN 'SAPA' THEN
412: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
413: END CASE; END LOOP;
414: CLOSE c_in_ja_cn_dff_assignments;
415: --log
416: IF (l_statement_level >= l_runtime_level) THEN
417: FND_LOG.STRING(l_statement_level,
418: l_module_name,