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_AB_EXP_PKG dependencies on JA_CN_DFF_ASSIGNMENTS

Line 81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;

77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;

Line 82: l_context_code ja_cn_dff_assignments.context_code%TYPE;

78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;

Line 83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;

79: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;

Line 84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;

80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;

Line 85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;

81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;

Line 86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;

82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
90: l_account_segment ja_cn_journal_lines.account_segment%TYPE;

Line 87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;

83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
90: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
91: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;

Line 88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;

84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
90: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
91: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
92: l_account_balances_gbl_tmp_row ja_cn_account_balances_gt%ROWTYPE;

Line 89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;

85: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
86: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
90: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
91: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
92: l_account_balances_gbl_tmp_row ja_cn_account_balances_gt%ROWTYPE;
93: l_sql_stmt VARCHAR2(30000) := '';

Line 212: CURSOR c_in_ja_cn_dff_assignments IS

208: --exceptions start here
209: --sob_unfetchable EXCEPTION;
210:
211: --cursors start here
212: CURSOR c_in_ja_cn_dff_assignments IS
213: SELECT *
214: FROM ja_cn_dff_assignments
215: WHERE chart_of_accounts_id = p_coa_id
216: AND (dff_title_code = 'SACC'

Line 214: FROM ja_cn_dff_assignments

210:
211: --cursors start here
212: CURSOR c_in_ja_cn_dff_assignments IS
213: SELECT *
214: FROM ja_cn_dff_assignments
215: WHERE chart_of_accounts_id = p_coa_id
216: AND (dff_title_code = 'SACC'
217: OR dff_title_code = 'SATP'
218: OR dff_title_code = 'SAEE'

Line 393: OPEN c_in_ja_cn_dff_assignments;

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

Line 395: FETCH c_in_ja_cn_dff_assignments

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

Line 396: INTO l_ja_cn_dff_assignments_row;

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

Line 397: EXIT WHEN c_in_ja_cn_dff_assignments%NOTFOUND;

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

Line 398: IF l_ja_cn_dff_assignments_row.context_code IS NOT NULL THEN

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

Line 399: l_context_code := l_ja_cn_dff_assignments_row.context_code;

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

Line 400: END IF; --l_ja_cn_dff_assignments_row.context_code IS NOT NULL

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

Line 401: CASE l_ja_cn_dff_assignments_row.dff_title_code

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

Line 403: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;

399: l_context_code := l_ja_cn_dff_assignments_row.context_code;
400: END IF; --l_ja_cn_dff_assignments_row.context_code IS NOT NULL
401: CASE l_ja_cn_dff_assignments_row.dff_title_code
402: WHEN 'SACC' THEN
403: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;
404: WHEN 'SATP' THEN
405: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
406: WHEN 'SAEE' THEN
407: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;

Line 405: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;

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

Line 407: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;

403: l_attribute_column4cost_center := l_ja_cn_dff_assignments_row.attribute_column;
404: WHEN 'SATP' THEN
405: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
406: WHEN 'SAEE' THEN
407: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
408: WHEN 'SAPA' THEN
409: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
410: WHEN 'FCRA' THEN
411: l_attribute_column4is_foreign := l_ja_cn_dff_assignments_row.attribute_column;

Line 409: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;

405: l_attribute_column4third_party := l_ja_cn_dff_assignments_row.attribute_column;
406: WHEN 'SAEE' THEN
407: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
408: WHEN 'SAPA' THEN
409: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
410: WHEN 'FCRA' THEN
411: l_attribute_column4is_foreign := l_ja_cn_dff_assignments_row.attribute_column;
412: WHEN 'ACBS' THEN
413: l_attribute_column4balanceside := l_ja_cn_dff_assignments_row.attribute_column;

Line 411: l_attribute_column4is_foreign := l_ja_cn_dff_assignments_row.attribute_column;

407: l_attribute_column4personnel := l_ja_cn_dff_assignments_row.attribute_column;
408: WHEN 'SAPA' THEN
409: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
410: WHEN 'FCRA' THEN
411: l_attribute_column4is_foreign := l_ja_cn_dff_assignments_row.attribute_column;
412: WHEN 'ACBS' THEN
413: l_attribute_column4balanceside := l_ja_cn_dff_assignments_row.attribute_column;
414: WHEN 'ACLE' THEN
415: l_attribute_column4account_lev := l_ja_cn_dff_assignments_row.attribute_column;

Line 413: l_attribute_column4balanceside := l_ja_cn_dff_assignments_row.attribute_column;

409: l_attribute_column4project := l_ja_cn_dff_assignments_row.attribute_column;
410: WHEN 'FCRA' THEN
411: l_attribute_column4is_foreign := l_ja_cn_dff_assignments_row.attribute_column;
412: WHEN 'ACBS' THEN
413: l_attribute_column4balanceside := l_ja_cn_dff_assignments_row.attribute_column;
414: WHEN 'ACLE' THEN
415: l_attribute_column4account_lev := l_ja_cn_dff_assignments_row.attribute_column;
416: END CASE; END LOOP;
417: CLOSE c_in_ja_cn_dff_assignments;

Line 415: l_attribute_column4account_lev := l_ja_cn_dff_assignments_row.attribute_column;

411: l_attribute_column4is_foreign := l_ja_cn_dff_assignments_row.attribute_column;
412: WHEN 'ACBS' THEN
413: l_attribute_column4balanceside := l_ja_cn_dff_assignments_row.attribute_column;
414: WHEN 'ACLE' THEN
415: l_attribute_column4account_lev := l_ja_cn_dff_assignments_row.attribute_column;
416: END CASE; END LOOP;
417: CLOSE c_in_ja_cn_dff_assignments;
418:
419: --log

Line 417: CLOSE c_in_ja_cn_dff_assignments;

413: l_attribute_column4balanceside := l_ja_cn_dff_assignments_row.attribute_column;
414: WHEN 'ACLE' THEN
415: l_attribute_column4account_lev := l_ja_cn_dff_assignments_row.attribute_column;
416: END CASE; END LOOP;
417: CLOSE c_in_ja_cn_dff_assignments;
418:
419: --log
420: IF (l_statement_level >= l_runtime_level) THEN
421: FND_LOG.STRING(l_statement_level,