APPS.FII_GL_UTIL_PKG dependencies on FII_GL_UTIL_PKG

Line 1: PACKAGE BODY fii_gl_util_pkg AS

1: PACKAGE BODY fii_gl_util_pkg AS
2: /* $Header: FIIGLC5B.pls 120.9 2006/05/18 19:49:35 vkazhipu noship $ */
3:
4: g_min_start_date date;
5: g_min_week_start_date date;

Line 342: g_l_id := fii_gl_util_pkg.g_mgr_id;

338: --by vkazhipu
339: --changing l_id AND l_dim_flag to bind variables
340:
341: IF g_view_by = 'HRI_PERSON+HRI_PER_USRDR_H' THEN
342: g_l_id := fii_gl_util_pkg.g_mgr_id;
343: g_dim_flag := NVL(fii_gl_util_pkg.g_mgr_is_leaf,'N');
344:
345:
346: ELSIF g_view_by = 'LOB+FII_LOB' THEN

Line 343: g_dim_flag := NVL(fii_gl_util_pkg.g_mgr_is_leaf,'N');

339: --changing l_id AND l_dim_flag to bind variables
340:
341: IF g_view_by = 'HRI_PERSON+HRI_PER_USRDR_H' THEN
342: g_l_id := fii_gl_util_pkg.g_mgr_id;
343: g_dim_flag := NVL(fii_gl_util_pkg.g_mgr_is_leaf,'N');
344:
345:
346: ELSIF g_view_by = 'LOB+FII_LOB' THEN
347: g_l_id := fii_gl_util_pkg.g_lob_id;

Line 347: g_l_id := fii_gl_util_pkg.g_lob_id;

343: g_dim_flag := NVL(fii_gl_util_pkg.g_mgr_is_leaf,'N');
344:
345:
346: ELSIF g_view_by = 'LOB+FII_LOB' THEN
347: g_l_id := fii_gl_util_pkg.g_lob_id;
348: g_dim_flag := fii_gl_util_pkg.g_lob_is_leaf;
349:
350: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
351: g_l_id := fii_gl_util_pkg.g_fin_id;

Line 348: g_dim_flag := fii_gl_util_pkg.g_lob_is_leaf;

344:
345:
346: ELSIF g_view_by = 'LOB+FII_LOB' THEN
347: g_l_id := fii_gl_util_pkg.g_lob_id;
348: g_dim_flag := fii_gl_util_pkg.g_lob_is_leaf;
349:
350: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
351: g_l_id := fii_gl_util_pkg.g_fin_id;
352: g_dim_flag := fii_gl_util_pkg.g_fincat_is_leaf;

Line 351: g_l_id := fii_gl_util_pkg.g_fin_id;

347: g_l_id := fii_gl_util_pkg.g_lob_id;
348: g_dim_flag := fii_gl_util_pkg.g_lob_is_leaf;
349:
350: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
351: g_l_id := fii_gl_util_pkg.g_fin_id;
352: g_dim_flag := fii_gl_util_pkg.g_fincat_is_leaf;
353: ELSE
354: g_l_id := -9999;
355: g_dim_flag := 'Y';

Line 352: g_dim_flag := fii_gl_util_pkg.g_fincat_is_leaf;

348: g_dim_flag := fii_gl_util_pkg.g_lob_is_leaf;
349:
350: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
351: g_l_id := fii_gl_util_pkg.g_fin_id;
352: g_dim_flag := fii_gl_util_pkg.g_fincat_is_leaf;
353: ELSE
354: g_l_id := -9999;
355: g_dim_flag := 'Y';
356: END IF;

Line 1266: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

1262: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
1263: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1264: p_sql_output := p_sqlstmt;
1265:
1266: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
1267:
1268: IF (g_viewby_type IS NOT NULL) THEN
1269:
1270: p_bind_output_table.EXTEND;

Line 1870: END fii_gl_util_pkg;

1866: END IF;
1867:
1868: END get_fin_item;
1869:
1870: END fii_gl_util_pkg;
1871: