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_PSI_BUD_SUM_PKG dependencies on FII_EA_UTIL_PKG

Line 47: FII_EA_UTIL_PKG.reset_globals;

43: l_fud2_from VARCHAR2(100);
44:
45: BEGIN
46:
47: FII_EA_UTIL_PKG.reset_globals;
48: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
49: FII_EA_UTIL_PKG.get_rolling_period;
50:
51: FII_EA_UTIL_PKG.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);

Line 48: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);

44:
45: BEGIN
46:
47: FII_EA_UTIL_PKG.reset_globals;
48: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
49: FII_EA_UTIL_PKG.get_rolling_period;
50:
51: FII_EA_UTIL_PKG.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
52: FII_EA_UTIL_PKG.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

Line 49: FII_EA_UTIL_PKG.get_rolling_period;

45: BEGIN
46:
47: FII_EA_UTIL_PKG.reset_globals;
48: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
49: FII_EA_UTIL_PKG.get_rolling_period;
50:
51: FII_EA_UTIL_PKG.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
52: FII_EA_UTIL_PKG.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
53:

Line 51: FII_EA_UTIL_PKG.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);

47: FII_EA_UTIL_PKG.reset_globals;
48: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
49: FII_EA_UTIL_PKG.get_rolling_period;
50:
51: FII_EA_UTIL_PKG.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
52: FII_EA_UTIL_PKG.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
53:
54: /* Setting 'period type' dependent variables in this CASE structure which need to be used in
55: dynamic pmv sql to retrieve data FROM the correct columns */

Line 52: FII_EA_UTIL_PKG.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

48: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
49: FII_EA_UTIL_PKG.get_rolling_period;
50:
51: FII_EA_UTIL_PKG.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
52: FII_EA_UTIL_PKG.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
53:
54: /* Setting 'period type' dependent variables in this CASE structure which need to be used in
55: dynamic pmv sql to retrieve data FROM the correct columns */
56:

Line 57: CASE fii_ea_util_pkg.g_page_period_type

53:
54: /* Setting 'period type' dependent variables in this CASE structure which need to be used in
55: dynamic pmv sql to retrieve data FROM the correct columns */
56:
57: CASE fii_ea_util_pkg.g_page_period_type
58: WHEN 'FII_TIME_ENT_YEAR' THEN
59: l_roll_column := 'qtd';
60: l_xtd_column := 'ytd' ;
61:

Line 64: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

60: l_xtd_column := 'ytd' ;
61:
62: SELECT ent_year_id into l_time_id
63: FROM fii_time_ent_period per
64: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;
65:
66: WHEN 'FII_TIME_ENT_QTR' THEN
67: l_roll_column := 'mtd';
68: l_xtd_column := 'qtd' ;

Line 72: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

68: l_xtd_column := 'qtd' ;
69:
70: SELECT ent_qtr_id into l_time_id
71: FROM fii_time_ent_period per
72: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;
73: WHEN 'FII_TIME_ENT_PERIOD' THEN
74: l_roll_column := 'mtd';
75: l_xtd_column := 'mtd' ;
76:

Line 79: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

75: l_xtd_column := 'mtd' ;
76:
77: SELECT ent_period_id into l_time_id
78: FROM fii_time_ent_period per
79: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;
80:
81: END CASE;
82:
83: -- logic for fix to display DIRECT.. if we choose node A which has 2 children B & C, then, we want to

Line 89: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN

85: -- For this, while keeping parent_id as A, we want to look only for A in fii_gl_base_map_mv
86: -- so that we do not get duplication of actuals..hence we append conditional decode
87: -- statements l_cat_decode AND l_fud1_decode in l_sqlstmt2 AND l_snap_sqlstmt2..
88:
89: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN
90: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN
91: l_cat_decode := 'AND fin_hier.parent_fin_cat_id = decode(fin_hier.parent_fin_cat_id,:CATEGORY_ID,
92: fin_hier.child_fin_cat_id,fin_hier.parent_fin_cat_id)';
93: END IF;

Line 90: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN

86: -- so that we do not get duplication of actuals..hence we append conditional decode
87: -- statements l_cat_decode AND l_fud1_decode in l_sqlstmt2 AND l_snap_sqlstmt2..
88:
89: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN
90: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN
91: l_cat_decode := 'AND fin_hier.parent_fin_cat_id = decode(fin_hier.parent_fin_cat_id,:CATEGORY_ID,
92: fin_hier.child_fin_cat_id,fin_hier.parent_fin_cat_id)';
93: END IF;
94: ELSE

Line 99: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN

95: l_cat_decode := 'AND fin_hier.parent_fin_cat_id = DECODE(fin_hier.parent_fin_cat_id, :CATEGORY_ID,
96: fin_hier.child_fin_cat_id, fin_hier.parent_fin_cat_id)';
97: END IF;
98:
99: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
100:
101: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
102:
103: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN

Line 101: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);

97: END IF;
98:
99: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
100:
101: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
102:
103: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
104:
105: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);

Line 103: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN

99: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
100:
101: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
102:
103: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
104:
105: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
106: l_fud1_decode := 'AND fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,
107: fud1_hier.child_value_id, fud1_hier.parent_value_id)';

Line 105: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);

101: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
102:
103: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
104:
105: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
106: l_fud1_decode := 'AND fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,
107: fud1_hier.child_value_id, fud1_hier.parent_value_id)';
108: END IF;
109:

Line 120: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN

116: END;
117:
118: IF l_fud2_enabled_flag = 'Y' THEN
119:
120: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
121:
122: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
123:
124: l_fud2_snap_where := ' AND fud2_hier.parent_value_id = gt.fud2_id

Line 130: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN

126:
127: l_fud2_where := ' AND fud2_hier.parent_value_id = inner_inline_view.fud2_id
128: AND fud2_hier.child_value_id = f.fud2_id ';
129:
130: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN
131:
132: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
133:
134: l_fud2_snap_where := ' AND fud2_hier.parent_value_id = gt.fud2_id

Line 316: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN

312: GROUP BY '||p_aggrt_viewby_id||',
313: inner_inline_view.viewby,
314: inner_inline_view.sort_order ';
315:
316: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
317:
318: l_aggrt_sql := l_trend_sum_mv_sql;
319:
320: ELSIF p_aggrt_gt_is_empty = 'N' then -- aggrt GT table is populated

Line 409: FII_EA_UTIL_PKG.bind_variable(

405:
406:
407: -- Attach bind parameters
408:
409: FII_EA_UTIL_PKG.bind_variable(
410: p_sqlstmt=>sqlstmt,
411: p_page_parameter_tbl=>p_page_parameter_tbl,
412: p_sql_output=>bud_sum_sql,
413: p_bind_output_table=>bud_sum_output);

Line 455: FII_EA_UTIL_PKG.reset_globals;

451: l_fud2_snap_where VARCHAR2(300);
452: l_fud2_from VARCHAR2(100);
453: BEGIN
454:
455: FII_EA_UTIL_PKG.reset_globals;
456: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
457: FII_EA_UTIL_PKG.get_rolling_period;
458:
459: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);

Line 456: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);

452: l_fud2_from VARCHAR2(100);
453: BEGIN
454:
455: FII_EA_UTIL_PKG.reset_globals;
456: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
457: FII_EA_UTIL_PKG.get_rolling_period;
458:
459: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
460: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

Line 457: FII_EA_UTIL_PKG.get_rolling_period;

453: BEGIN
454:
455: FII_EA_UTIL_PKG.reset_globals;
456: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
457: FII_EA_UTIL_PKG.get_rolling_period;
458:
459: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
460: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
461:

Line 459: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);

455: FII_EA_UTIL_PKG.reset_globals;
456: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
457: FII_EA_UTIL_PKG.get_rolling_period;
458:
459: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
460: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
461:
462:
463: /* Setting 'period type' dependent variables in this CASE structure which need to be used in

Line 460: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);

456: FII_EA_UTIL_PKG.get_parameters(p_page_parameter_tbl=>p_page_parameter_tbl);
457: FII_EA_UTIL_PKG.get_rolling_period;
458:
459: fii_ea_util_pkg.get_viewby_id(p_aggrt_viewby_id, p_snap_aggrt_viewby_id, p_nonaggrt_viewby_id);
460: fii_ea_util_pkg.populate_security_gt_tables(p_aggrt_gt_is_empty, p_non_aggrt_gt_is_empty);
461:
462:
463: /* Setting 'period type' dependent variables in this CASE structure which need to be used in
464: dynamic pmv sql to retrieve data FROM the correct columns */

Line 466: CASE fii_ea_util_pkg.g_page_period_type

462:
463: /* Setting 'period type' dependent variables in this CASE structure which need to be used in
464: dynamic pmv sql to retrieve data FROM the correct columns */
465:
466: CASE fii_ea_util_pkg.g_page_period_type
467: WHEN 'FII_TIME_ENT_YEAR' THEN
468: l_roll_column := 'qtd';
469: l_xtd_column := 'ytd' ;
470:

Line 473: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

469: l_xtd_column := 'ytd' ;
470:
471: SELECT ent_year_id into l_time_id
472: FROM fii_time_ent_period per
473: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;
474:
475: WHEN 'FII_TIME_ENT_QTR' THEN
476: l_roll_column := 'mtd';
477: l_xtd_column := 'qtd' ;

Line 481: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

477: l_xtd_column := 'qtd' ;
478:
479: SELECT ent_qtr_id into l_time_id
480: FROM fii_time_ent_period per
481: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;
482:
483: WHEN 'FII_TIME_ENT_PERIOD' THEN
484: l_roll_column := 'mtd';
485: l_xtd_column := 'mtd' ;

Line 489: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;

485: l_xtd_column := 'mtd' ;
486:
487: SELECT ent_period_id into l_time_id
488: FROM fii_time_ent_period per
489: WHERE fii_ea_util_pkg.g_as_of_date between start_date AND end_date;
490:
491: END CASE;
492:
493: -- logic for fix to display DIRECT.. if we choose node A which has 2 children B & C, then, we want to

Line 499: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN

495: -- For this, while keeping parent_id as A, we want to look only for A in fii_gl_base_map_mv
496: -- so that we do not get duplication of actuals..hence we append conditional decode
497: -- statements l_cat_decode AND l_fud1_decode in l_sqlstmt2 AND l_snap_sqlstmt2..
498:
499: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN
500: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN
501: l_cat_decode := 'AND fin_hier.parent_fin_cat_id = decode(fin_hier.parent_fin_cat_id,:CATEGORY_ID,
502: fin_hier.child_fin_cat_id,fin_hier.parent_fin_cat_id)';
503: END IF;

Line 500: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN

496: -- so that we do not get duplication of actuals..hence we append conditional decode
497: -- statements l_cat_decode AND l_fud1_decode in l_sqlstmt2 AND l_snap_sqlstmt2..
498:
499: IF fii_ea_util_pkg.g_fin_category_id = 'All' THEN
500: IF fii_ea_util_pkg.g_fin_cat_top_node_count = 1 THEN
501: l_cat_decode := 'AND fin_hier.parent_fin_cat_id = decode(fin_hier.parent_fin_cat_id,:CATEGORY_ID,
502: fin_hier.child_fin_cat_id,fin_hier.parent_fin_cat_id)';
503: END IF;
504: ELSE

Line 509: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN

505: l_cat_decode := 'AND fin_hier.parent_fin_cat_id = DECODE(fin_hier.parent_fin_cat_id, :CATEGORY_ID,
506: fin_hier.child_fin_cat_id, fin_hier.parent_fin_cat_id)';
507: END IF;
508:
509: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
510:
511: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
512:
513: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN

Line 511: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);

507: END IF;
508:
509: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
510:
511: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
512:
513: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
514:
515: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);

Line 513: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN

509: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
510:
511: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
512:
513: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
514:
515: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
516: l_fud1_decode := 'AND fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,
517: fud1_hier.child_value_id, fud1_hier.parent_value_id)';

Line 515: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);

511: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
512:
513: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
514:
515: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
516: l_fud1_decode := 'AND fud1_hier.parent_value_id = DECODE(fud1_hier.parent_value_id, :UDD1_ID,
517: fud1_hier.child_value_id, fud1_hier.parent_value_id)';
518: END IF;
519:

Line 530: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN

526: END;
527:
528: IF l_fud2_enabled_flag = 'Y' THEN
529:
530: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
531:
532: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
533:
534: l_fud2_snap_where := ' AND fud2_hier.parent_value_id = gt.fud2_id

Line 540: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN

536:
537: l_fud2_where := ' AND fud2_hier.parent_value_id = inner_inline_view.fud2_id
538: AND fud2_hier.child_value_id = f.fud2_id ';
539:
540: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN
541:
542: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
543:
544: l_fud2_snap_where := ' AND fud2_hier.parent_value_id = gt.fud2_id

Line 664: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN

660: AND f.fin_category_id = inner_inline_view.fin_category_id
661:
662: GROUP BY '||p_aggrt_viewby_id||', inner_inline_view.viewby, inner_inline_view.sort_order';
663:
664: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
665:
666: l_aggrt_sql := l_trend_sum_mv_sql;
667:
668: ELSIF p_aggrt_gt_is_empty = 'N' then -- aggrt GT table is populated

Line 724: FII_EA_UTIL_PKG.bind_variable(

720: NVL(FII_PSI_XTD, -999999999) desc ';
721:
722: -- Attach bind parameters
723:
724: FII_EA_UTIL_PKG.bind_variable(
725: p_sqlstmt=>sqlstmt,
726: p_page_parameter_tbl=>p_page_parameter_tbl,
727: p_sql_output=>bud_sum_sql,
728: p_bind_output_table=>bud_sum_output);