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.FII_EA_JE_TRAN_PKG dependencies on FII_EA_JE_TRAN_PKG

Line 1: PACKAGE BODY FII_EA_JE_TRAN_PKG AS

1: PACKAGE BODY FII_EA_JE_TRAN_PKG AS
2: /* $Header: FIIEAJ1B.pls 120.4 2006/08/08 17:00:32 vkazhipu noship $ */
3:
4:
5: /* Getting category type for a category */

Line 13: INTO FII_EA_JE_TRAN_PKG.g_fin_type

9: l_type VARCHAR2(100);
10: BEGIN
11:
12: SELECT fin_cat_type_code
13: INTO FII_EA_JE_TRAN_PKG.g_fin_type
14: FROM fii_fin_cat_type_assgns
15: WHERE fin_category_id= fii_ea_util_pkg.g_fin_category_id
16: AND fin_cat_type_code IN ('EXP','R');
17:

Line 20: FII_EA_JE_TRAN_PKG.g_fin_type := NULL;

16: AND fin_cat_type_code IN ('EXP','R');
17:
18: EXCEPTION
19: WHEN no_data_found THEN
20: FII_EA_JE_TRAN_PKG.g_fin_type := NULL;
21: END get_cat_type;
22:
23:
24: PROCEDURE get_je_tran (

Line 52: FII_EA_JE_TRAN_PKG.get_cat_type;

48: FII_EA_UTIL_PKG.reset_globals;
49: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
50:
51: /* Getting category type for a category */
52: FII_EA_JE_TRAN_PKG.get_cat_type;
53:
54: /* Preparing Dynamic where clauses for PMV sql */
55:
56: l_ledger_where := ' AND f.ledger_id = &FII_LEDGER+FII_LEDGER ';

Line 80: IF FII_EA_JE_TRAN_PKG.g_fin_type = 'EXP' THEN /* Expense*/

76: END;
77:
78: /* Select columns based on call for Expense or Revenue */
79:
80: IF FII_EA_JE_TRAN_PKG.g_fin_type = 'EXP' THEN /* Expense*/
81:
82: l_entered_amount := ' SUM(NVL(jln.entered_cr, 0) - NVL(jln.entered_dr, 0))*-1 FII_EA_ENTERED_AMOUNT, ';
83: l_functional_amount := ' SUM(NVL(jln.accounted_cr, 0) - NVL(jln.accounted_dr, 0))*-1 FII_EA_FUNCTIONAL_AMOUNT, ';
84: l_gt_functional_amount := ' SUM(SUM(NVL(jln.accounted_cr, 0) -NVL(jln.accounted_dr,0))*-1) OVER() FII_GT_EA_FUNCTIONAL_AMOUNT ';

Line 86: ELSIF FII_EA_JE_TRAN_PKG.g_fin_type = 'R' THEN /* Revenue */

82: l_entered_amount := ' SUM(NVL(jln.entered_cr, 0) - NVL(jln.entered_dr, 0))*-1 FII_EA_ENTERED_AMOUNT, ';
83: l_functional_amount := ' SUM(NVL(jln.accounted_cr, 0) - NVL(jln.accounted_dr, 0))*-1 FII_EA_FUNCTIONAL_AMOUNT, ';
84: l_gt_functional_amount := ' SUM(SUM(NVL(jln.accounted_cr, 0) -NVL(jln.accounted_dr,0))*-1) OVER() FII_GT_EA_FUNCTIONAL_AMOUNT ';
85:
86: ELSIF FII_EA_JE_TRAN_PKG.g_fin_type = 'R' THEN /* Revenue */
87:
88: l_entered_amount := ' SUM(NVL(jln.entered_cr, 0) - NVL(jln.entered_dr, 0)) FII_EA_ENTERED_AMOUNT, ';
89: l_functional_amount := ' SUM(NVL(jln.accounted_cr, 0) - NVL(jln.accounted_dr, 0)) FII_EA_FUNCTIONAL_AMOUNT, ';
90: l_gt_functional_amount := ' SUM(SUM(NVL(jln.accounted_cr, 0) -NVL(jln.accounted_dr,0))) OVER() FII_GT_EA_FUNCTIONAL_AMOUNT ';

Line 186: FII_EA_JE_TRAN_PKG.get_cat_type;

182:
183: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
184:
185: /* Getting category type for a category */
186: FII_EA_JE_TRAN_PKG.get_cat_type;
187:
188: /* Preparing Dynamic where clauses for PMV sql */
189:
190: l_ledger_where := ' AND f.ledger_id = &FII_LEDGER+FII_LEDGER ';

Line 213: IF FII_EA_JE_TRAN_PKG.g_fin_type = 'EXP' THEN /* Expense*/

209: END;
210:
211: /* Select columns based on call for Expense or Revenue */
212:
213: IF FII_EA_JE_TRAN_PKG.g_fin_type = 'EXP' THEN /* Expense*/
214:
215: l_entered_amount := ' (NVL(jln.entered_cr, 0) - NVL(jln.entered_dr, 0))*-1 FII_EA_ENTERED_AMOUNT, ';
216: l_functional_amount := ' (NVL(jln.accounted_cr, 0) - NVL(jln.accounted_dr, 0)) *-1 FII_EA_FUNCTIONAL_AMOUNT, ';
217: l_gt_functional_amount := ' SUM((NVL(jln.accounted_cr, 0) -NVL(jln.accounted_dr,0)) *-1) OVER() FII_GT_EA_FUNCTIONAL_AMOUNT ';

Line 219: ELSIF FII_EA_JE_TRAN_PKG.g_fin_type = 'R' THEN /* Revenue */

215: l_entered_amount := ' (NVL(jln.entered_cr, 0) - NVL(jln.entered_dr, 0))*-1 FII_EA_ENTERED_AMOUNT, ';
216: l_functional_amount := ' (NVL(jln.accounted_cr, 0) - NVL(jln.accounted_dr, 0)) *-1 FII_EA_FUNCTIONAL_AMOUNT, ';
217: l_gt_functional_amount := ' SUM((NVL(jln.accounted_cr, 0) -NVL(jln.accounted_dr,0)) *-1) OVER() FII_GT_EA_FUNCTIONAL_AMOUNT ';
218:
219: ELSIF FII_EA_JE_TRAN_PKG.g_fin_type = 'R' THEN /* Revenue */
220:
221:
222: l_entered_amount := ' (NVL(jln.entered_cr, 0) - NVL(jln.entered_dr, 0)) FII_EA_ENTERED_AMOUNT, ';
223: l_functional_amount := ' (NVL(jln.accounted_cr, 0) - NVL(jln.accounted_dr, 0)) FII_EA_FUNCTIONAL_AMOUNT, ';

Line 319: END FII_EA_JE_TRAN_PKG;

315: END get_je_line_tran;
316:
317:
318:
319: END FII_EA_JE_TRAN_PKG;
320: