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

Line 50: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;

46: ,P_COA_ID IN NUMBER) IS
47: l_ledger_id NUMBER := P_LEDGER_ID;
48: l_coa_id NUMBER := P_COA_ID;
49: l_sql_str varchar2(30000):='';
50: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;

47: l_ledger_id NUMBER := P_LEDGER_ID;
48: l_coa_id NUMBER := P_COA_ID;
49: l_sql_str varchar2(30000):='';
50: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;

48: l_coa_id NUMBER := P_COA_ID;
49: l_sql_str varchar2(30000):='';
50: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

49: l_sql_str varchar2(30000):='';
50: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

50: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
58: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

51: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
58: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
59:

Line 56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

52: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
58: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
59:
60: BEGIN

Line 57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

53: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
58: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
59:
60: BEGIN
61: --Get positions of

Line 58: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

54: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
55: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
56: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
57: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
58: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
59:
60: BEGIN
61: --Get positions of
62: -- account level, project, third party, cost center and personnel,and Balance Side

Line 82: FROM JA_CN_DFF_ASSIGNMENTS DFF1

78: ,l_sub_tp_position
79: ,l_sub_cc_position
80: ,l_sub_person_position
81: ,l_acc_bal_position
82: FROM JA_CN_DFF_ASSIGNMENTS DFF1
83: ,JA_CN_DFF_ASSIGNMENTS DFF6
84: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
85: AND DFF6.DFF_TITLE_CODE = 'ACBS' -- Balance Side
86: -- Check whether the flexfields had been set for current COA_ID

Line 83: ,JA_CN_DFF_ASSIGNMENTS DFF6

79: ,l_sub_cc_position
80: ,l_sub_person_position
81: ,l_acc_bal_position
82: FROM JA_CN_DFF_ASSIGNMENTS DFF1
83: ,JA_CN_DFF_ASSIGNMENTS DFF6
84: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
85: AND DFF6.DFF_TITLE_CODE = 'ACBS' -- Balance Side
86: -- Check whether the flexfields had been set for current COA_ID
87: AND DFF1.CHART_OF_ACCOUNTS_ID=l_coa_id

Line 279: FROM JA_CN_DFF_ASSIGNMENTS DFF1

275: DECODE(nvl(DFF1.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
276: || DECODE(nvl(DFF6.CONTEXT_CODE, ''), '', 'N',
277: DECODE(nvl(DFF6.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
278: dff_assign
279: FROM JA_CN_DFF_ASSIGNMENTS DFF1
280: ,JA_CN_DFF_ASSIGNMENTS DFF6
281: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
282: AND DFF6.DFF_TITLE_CODE = 'ACBS' -- Balance Side
283: -- Check whether the flexfields had been set for current COA_ID

Line 280: ,JA_CN_DFF_ASSIGNMENTS DFF6

276: || DECODE(nvl(DFF6.CONTEXT_CODE, ''), '', 'N',
277: DECODE(nvl(DFF6.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
278: dff_assign
279: FROM JA_CN_DFF_ASSIGNMENTS DFF1
280: ,JA_CN_DFF_ASSIGNMENTS DFF6
281: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
282: AND DFF6.DFF_TITLE_CODE = 'ACBS' -- Balance Side
283: -- Check whether the flexfields had been set for current COA_ID
284: AND DFF1.CHART_OF_ACCOUNTS_ID=l_coa_id