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

Line 41: fii_ea_util_pkg.reset_globals;

37: BEGIN
38:
39: /* Clear global parameters AND read the new parameters */
40: -- Sets all g_% variables to its default values
41: fii_ea_util_pkg.reset_globals;
42:
43: -- Reads the parameters from the parameter portlet
44: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);
45:

Line 44: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);

40: -- Sets all g_% variables to its default values
41: fii_ea_util_pkg.reset_globals;
42:
43: -- Reads the parameters from the parameter portlet
44: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);
45:
46: -- Sets fin_cat_type to Operating Expenses(OE) as Encumbrances are part of OE
47: fii_ea_util_pkg.g_fin_cat_type := 'OE';
48:

Line 47: fii_ea_util_pkg.g_fin_cat_type := 'OE';

43: -- Reads the parameters from the parameter portlet
44: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);
45:
46: -- Sets fin_cat_type to Operating Expenses(OE) as Encumbrances are part of OE
47: fii_ea_util_pkg.g_fin_cat_type := 'OE';
48:
49: -- Gets the viewby_id
50: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);
51:

Line 50: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);

46: -- Sets fin_cat_type to Operating Expenses(OE) as Encumbrances are part of OE
47: fii_ea_util_pkg.g_fin_cat_type := 'OE';
48:
49: -- Gets the viewby_id
50: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);
51:
52: -- Populates the security related global temporary tables
53: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
54:

Line 53: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);

49: -- Gets the viewby_id
50: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);
51:
52: -- Populates the security related global temporary tables
53: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
54:
55: -- Initialise the global variables to set FII_PREVIOUS_ONE_DATE, etc.
56: fii_ea_util_pkg.get_rolling_period();
57:

Line 56: fii_ea_util_pkg.get_rolling_period();

52: -- Populates the security related global temporary tables
53: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
54:
55: -- Initialise the global variables to set FII_PREVIOUS_ONE_DATE, etc.
56: fii_ea_util_pkg.get_rolling_period();
57:
58: -- Decision ytd, qtd, mtd based on the period type chosen
59: CASE fii_ea_util_pkg.g_page_period_type
60:

Line 59: CASE fii_ea_util_pkg.g_page_period_type

55: -- Initialise the global variables to set FII_PREVIOUS_ONE_DATE, etc.
56: fii_ea_util_pkg.get_rolling_period();
57:
58: -- Decision ytd, qtd, mtd based on the period type chosen
59: CASE fii_ea_util_pkg.g_page_period_type
60:
61: WHEN 'FII_TIME_ENT_YEAR' THEN
62: l_roll_column := 'qtd';
63: l_xtd_column := 'ytd' ;

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

78: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
79:
80: IF l_fud2_enabled_flag = 'Y' THEN
81:
82: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
83:
84: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
85:
86: l_fud2_snap_where := ' and fud2_hier.parent_value_id = gt.fud2_id

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

88:
89: l_fud2_where := ' and fud2_hier.parent_value_id = inner_inline_view.fud2_id
90: and fud2_hier.child_value_id = f.fud2_id ';
91:
92: ELSIF fii_ea_util_pkg.g_fud2_id <> 'All' THEN
93:
94: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
95:
96: l_fud2_snap_where := ' and fud2_hier.parent_value_id = gt.fud2_id

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

102: END IF;
103: /* Bug 4192505 End */
104:
105: /* Bug 4190997 Start */
106: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
107: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
108: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
109: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
110: END IF;

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

103: /* Bug 4192505 End */
104:
105: /* Bug 4190997 Start */
106: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
107: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
108: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
109: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
110: END IF;
111: /* Bug 4190997 End */

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

104:
105: /* Bug 4190997 Start */
106: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
107: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
108: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
109: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
110: END IF;
111: /* Bug 4190997 End */
112:

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

105: /* Bug 4190997 Start */
106: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
107: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
108: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
109: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
110: END IF;
111: /* Bug 4190997 End */
112:
113: -- Constructing drilldown URL

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

417:
418: -- Adding the Final Query Header
419: sqlstmt := l_query_start;
420:
421: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
422: -- Appending the part of query that hits fii_gl_trend_sum_mv_p_v
423: sqlstmt := sqlstmt || l_trend_sum_mv_sql;
424: ELSIF l_aggrt_gt_is_empty = 'N' then
425: -- Appending the part of query that hits fii_gl_agrt_sum_mv_p_v

Line 445: fii_ea_util_pkg.bind_variable(

441: sqlstmt := sqlstmt || l_query_end;
442:
443:
444: -- Calling the bind_variable API
445: fii_ea_util_pkg.bind_variable(
446: p_sqlstmt => sqlstmt,
447: p_Page_parameter_tbl => p_page_parameter_tbl,
448: p_sql_output => p_enc_sum_sql,
449: p_bind_output_table => p_enc_sum_output

Line 490: fii_ea_util_pkg.reset_globals;

486: BEGIN
487:
488: /* Clear global parameters AND read the new parameters */
489: -- Sets all g_% variables to its default values
490: fii_ea_util_pkg.reset_globals;
491:
492: -- Reads the parameters from the parameter portlet
493: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);
494:

Line 493: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);

489: -- Sets all g_% variables to its default values
490: fii_ea_util_pkg.reset_globals;
491:
492: -- Reads the parameters from the parameter portlet
493: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);
494:
495: -- Sets fin_cat_type to Operating Expenses(OE) as Encumbrances are part of OE
496: fii_ea_util_pkg.g_fin_cat_type := 'OE';
497:

Line 496: fii_ea_util_pkg.g_fin_cat_type := 'OE';

492: -- Reads the parameters from the parameter portlet
493: fii_ea_util_pkg.get_parameters( p_page_parameter_tbl);
494:
495: -- Sets fin_cat_type to Operating Expenses(OE) as Encumbrances are part of OE
496: fii_ea_util_pkg.g_fin_cat_type := 'OE';
497:
498: -- Gets the viewby_id
499: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);
500:

Line 499: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);

495: -- Sets fin_cat_type to Operating Expenses(OE) as Encumbrances are part of OE
496: fii_ea_util_pkg.g_fin_cat_type := 'OE';
497:
498: -- Gets the viewby_id
499: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);
500:
501: -- Populates the security related global temporary tables
502: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
503:

Line 502: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);

498: -- Gets the viewby_id
499: fii_ea_util_pkg.get_viewby_id(l_aggrt_viewby_id, p_snap_aggrt_viewby_id, l_nonaggrt_viewby_id);
500:
501: -- Populates the security related global temporary tables
502: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
503:
504: -- Initialise the global variables to set FII_PREVIOUS_ONE_DATE, etc.
505: fii_ea_util_pkg.get_rolling_period();
506:

Line 505: fii_ea_util_pkg.get_rolling_period();

501: -- Populates the security related global temporary tables
502: fii_ea_util_pkg.populate_security_gt_tables(l_aggrt_gt_is_empty, l_non_aggrt_gt_is_empty);
503:
504: -- Initialise the global variables to set FII_PREVIOUS_ONE_DATE, etc.
505: fii_ea_util_pkg.get_rolling_period();
506:
507: -- Decision ytd, qtd, mtd based on the period type chosen
508: CASE fii_ea_util_pkg.g_page_period_type
509:

Line 508: CASE fii_ea_util_pkg.g_page_period_type

504: -- Initialise the global variables to set FII_PREVIOUS_ONE_DATE, etc.
505: fii_ea_util_pkg.get_rolling_period();
506:
507: -- Decision ytd, qtd, mtd based on the period type chosen
508: CASE fii_ea_util_pkg.g_page_period_type
509:
510: WHEN 'FII_TIME_ENT_YEAR' THEN
511: l_xtd_column := 'ytd' ;
512:

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

524: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
525:
526: IF l_fud2_enabled_flag = 'Y' THEN
527:
528: IF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
529:
530: l_fud2_from := ' fii_udd2_hierarchies fud2_hier, ';
531:
532: l_fud2_snap_where := ' and fud2_hier.parent_value_id = gt.fud2_id

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

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

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

548: END IF;
549: /* Bug 4192505 End */
550:
551: /* Bug 4190997 Start */
552: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
553: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
554: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
555: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
556: END IF;

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

549: /* Bug 4192505 End */
550:
551: /* Bug 4190997 Start */
552: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
553: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
554: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
555: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
556: END IF;
557: /* Bug 4190997 End */

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

550:
551: /* Bug 4190997 Start */
552: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
553: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
554: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
555: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
556: END IF;
557: /* Bug 4190997 End */
558:

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

551: /* Bug 4190997 Start */
552: IF fii_ea_util_pkg.g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
553: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_category_id);
554: ELSIF fii_ea_util_pkg.g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
555: fii_ea_util_pkg.check_if_leaf(fii_ea_util_pkg.g_udd1_id);
556: END IF;
557: /* Bug 4190997 End */
558:
559: -- Constructing drilldown URL

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

700:
701: -- Adding the Final Query Header
702: sqlstmt := l_query_start;
703:
704: IF fii_ea_util_pkg.g_if_trend_sum_mv = 'Y' THEN
705: -- Appending the part of query that hits fii_gl_trend_sum_mv_p_v
706: sqlstmt := sqlstmt || l_trend_sum_mv_sql;
707: ELSIF l_aggrt_gt_is_empty = 'N' then
708: -- Appending the part of query that hits fii_gl_agrt_sum_mv_p_v

Line 727: fii_ea_util_pkg.bind_variable(

723: -- Appending the Final Query Footer
724: sqlstmt := sqlstmt || l_query_end;
725:
726: -- Calling the bind_variable API
727: fii_ea_util_pkg.bind_variable(
728: p_sqlstmt => sqlstmt,
729: p_Page_parameter_tbl => p_page_parameter_tbl,
730: p_sql_output => p_enc_sum_sql,
731: p_bind_output_table => p_enc_sum_output