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_GL_PROFIT_AND_LOSS dependencies on FII_GL_UTIL_PKG

Line 15: fii_gl_util_pkg.reset_globals;

11: sqlstmt VARCHAR2(32000);
12: comp_amt VARCHAR2(500);
13:
14: BEGIN
15: fii_gl_util_pkg.reset_globals;
16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';

Line 16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

12: comp_amt VARCHAR2(500);
13:
14: BEGIN
15: fii_gl_util_pkg.reset_globals;
16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;

Line 17: fii_gl_util_pkg.get_bitmasks;

13:
14: BEGIN
15: fii_gl_util_pkg.reset_globals;
16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;
21: fii_gl_util_pkg.get_mgr_pmv_sql;

Line 18: fii_gl_util_pkg.g_fin_type := 'OM';

14: BEGIN
15: fii_gl_util_pkg.reset_globals;
16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;
21: fii_gl_util_pkg.get_mgr_pmv_sql;
22: fii_gl_util_pkg.get_cat_pmv_sql;

Line 19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';

15: fii_gl_util_pkg.reset_globals;
16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;
21: fii_gl_util_pkg.get_mgr_pmv_sql;
22: fii_gl_util_pkg.get_cat_pmv_sql;
23:

Line 20: fii_gl_util_pkg.get_viewby_sql;

16: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;
21: fii_gl_util_pkg.get_mgr_pmv_sql;
22: fii_gl_util_pkg.get_cat_pmv_sql;
23:
24:

Line 21: fii_gl_util_pkg.get_mgr_pmv_sql;

17: fii_gl_util_pkg.get_bitmasks;
18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;
21: fii_gl_util_pkg.get_mgr_pmv_sql;
22: fii_gl_util_pkg.get_cat_pmv_sql;
23:
24:
25: IF ('||fii_gl_util_pkg.g_time_comp||' = 'BUDGET') THEN

Line 22: fii_gl_util_pkg.get_cat_pmv_sql;

18: fii_gl_util_pkg.g_fin_type := 'OM';
19: fii_gl_util_pkg.g_view_by := 'FINANCIAL ITEM+GL_FII_FIN_ITEM';
20: fii_gl_util_pkg.get_viewby_sql;
21: fii_gl_util_pkg.get_mgr_pmv_sql;
22: fii_gl_util_pkg.get_cat_pmv_sql;
23:
24:
25: IF ('||fii_gl_util_pkg.g_time_comp||' = 'BUDGET') THEN
26:

Line 25: IF ('||fii_gl_util_pkg.g_time_comp||' = 'BUDGET') THEN

21: fii_gl_util_pkg.get_mgr_pmv_sql;
22: fii_gl_util_pkg.get_cat_pmv_sql;
23:
24:
25: IF ('||fii_gl_util_pkg.g_time_comp||' = 'BUDGET') THEN
26:
27: comp_amt := 'SUM(case when cal.report_date = &BIS_CURRENT_ASOF_DATE
28: and bitand(cal.record_type_id, :BUDGET_PERIOD_TYPE) = cal.record_type_id
29: then f.budget_g else 0 end) prior_amt';

Line 46: (SELECT /+ ordered (cal, f) / '||fii_gl_util_pkg.g_viewby_value||' viewby,

42: (select oper.viewby, cat.fin_category_id viewby_id, cat.fin_cat_type_code viewbytype, oper.curr_amt, oper.prior_amt,
43: sum(case when cat.fin_cat_type_code =''R'' then oper.curr_amt else oper.curr_amt*(-1) end) over () grand_total,
44: sum(case when cat.fin_cat_type_code=''R'' then oper.prior_amt else oper.prior_amt*(-1) end) over () prior_grand_total
45: from
46: (SELECT /*+ ordered (cal, f) */ '||fii_gl_util_pkg.g_viewby_value||' viewby,
47: tl.flex_value_id viewby_id,
48: SUM(case when cal.report_date = &BIS_CURRENT_ASOF_DATE
49: and bitand(cal.record_type_id, :ACTUAL_PERIOD_TYPE) = cal.record_type_id
50: then f.actual_g else 0 end) curr_amt,

Line 55: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||',' ||fii_gl_util_pkg.g_viewby_from_clause||'

51:
52: '||comp_amt||'
53:
54: FROM FII_TIME_RPT_STRUCT cal
55: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||',' ||fii_gl_util_pkg.g_viewby_from_clause||'
56: WHERE f.time_id = cal.time_id
57: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'
58: AND f.period_type_id = cal.period_type_id
59: AND (tl.flex_value_id = '||fii_gl_util_pkg.g_viewby_id||' OR

Line 57: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'

53:
54: FROM FII_TIME_RPT_STRUCT cal
55: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||',' ||fii_gl_util_pkg.g_viewby_from_clause||'
56: WHERE f.time_id = cal.time_id
57: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'
58: AND f.period_type_id = cal.period_type_id
59: AND (tl.flex_value_id = '||fii_gl_util_pkg.g_viewby_id||' OR
60: tl.flex_value_id = f.parent_fin_category_id)
61: AND tl.language = '''||userenv('LANG')||'''

Line 59: AND (tl.flex_value_id = '||fii_gl_util_pkg.g_viewby_id||' OR

55: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||',' ||fii_gl_util_pkg.g_viewby_from_clause||'
56: WHERE f.time_id = cal.time_id
57: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||fii_gl_util_pkg.g_gid||'
58: AND f.period_type_id = cal.period_type_id
59: AND (tl.flex_value_id = '||fii_gl_util_pkg.g_viewby_id||' OR
60: tl.flex_value_id = f.parent_fin_category_id)
61: AND tl.language = '''||userenv('LANG')||'''
62: AND BITAND(cal.record_type_id, :WHERE_PERIOD_TYPE)= cal.record_type_id
63: AND cal.report_date in (&BIS_CURRENT_ASOF_DATE, &BIS_PREVIOUS_ASOF_DATE)

Line 64: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', tl.flex_value_id

60: tl.flex_value_id = f.parent_fin_category_id)
61: AND tl.language = '''||userenv('LANG')||'''
62: AND BITAND(cal.record_type_id, :WHERE_PERIOD_TYPE)= cal.record_type_id
63: AND cal.report_date in (&BIS_CURRENT_ASOF_DATE, &BIS_PREVIOUS_ASOF_DATE)
64: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', tl.flex_value_id
65: order by '||fii_gl_util_pkg.g_viewby_value||' desc) oper,
66: (select fin_category_id, fin_cat_type_code from fii_fin_cat_type_assgns
67: where top_node_flag = ''Y'' and fin_cat_type_code in (''R'', ''OE'', ''CGS'')) cat
68: where oper.viewby_id (+)= cat.fin_category_id)

Line 65: order by '||fii_gl_util_pkg.g_viewby_value||' desc) oper,

61: AND tl.language = '''||userenv('LANG')||'''
62: AND BITAND(cal.record_type_id, :WHERE_PERIOD_TYPE)= cal.record_type_id
63: AND cal.report_date in (&BIS_CURRENT_ASOF_DATE, &BIS_PREVIOUS_ASOF_DATE)
64: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', tl.flex_value_id
65: order by '||fii_gl_util_pkg.g_viewby_value||' desc) oper,
66: (select fin_category_id, fin_cat_type_code from fii_fin_cat_type_assgns
67: where top_node_flag = ''Y'' and fin_cat_type_code in (''R'', ''OE'', ''CGS'')) cat
68: where oper.viewby_id (+)= cat.fin_category_id)
69: group by decode(viewbytype, ''CGS'', :COG_MSG, ''OE'', :EXP_MSG, ''R'', :REV_MSG,viewby)';

Line 71: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);

67: where top_node_flag = ''Y'' and fin_cat_type_code in (''R'', ''OE'', ''CGS'')) cat
68: where oper.viewby_id (+)= cat.fin_category_id)
69: group by decode(viewbytype, ''CGS'', :COG_MSG, ''OE'', :EXP_MSG, ''R'', :REV_MSG,viewby)';
70:
71: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);
72:
73: END get_oper_profit1;
74:
75: PROCEDURE GET_OPER_PROFIT (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

Line 86: fii_gl_util_pkg.reset_globals;

82: l_prior_or_budget2 VARCHAR2(1000);
83: l_prior_or_budget3 VARCHAR2(4000);
84:
85: BEGIN
86: fii_gl_util_pkg.reset_globals;
87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';

Line 87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

83: l_prior_or_budget3 VARCHAR2(4000);
84:
85: BEGIN
86: fii_gl_util_pkg.reset_globals;
87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;

Line 88: fii_gl_util_pkg.get_bitmasks;

84:
85: BEGIN
86: fii_gl_util_pkg.reset_globals;
87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;
92: fii_gl_util_pkg.get_mgr_pmv_sql;

Line 89: fii_gl_util_pkg.g_fin_type := 'OM';

85: BEGIN
86: fii_gl_util_pkg.reset_globals;
87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;
92: fii_gl_util_pkg.get_mgr_pmv_sql;
93: fii_gl_util_pkg.get_cat_pmv_sql;

Line 90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';

86: fii_gl_util_pkg.reset_globals;
87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;
92: fii_gl_util_pkg.get_mgr_pmv_sql;
93: fii_gl_util_pkg.get_cat_pmv_sql;
94:

Line 91: fii_gl_util_pkg.get_viewby_sql;

87: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;
92: fii_gl_util_pkg.get_mgr_pmv_sql;
93: fii_gl_util_pkg.get_cat_pmv_sql;
94:
95: -- when budget comparison type is selected, budget amount is used to calculate the change column

Line 92: fii_gl_util_pkg.get_mgr_pmv_sql;

88: fii_gl_util_pkg.get_bitmasks;
89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;
92: fii_gl_util_pkg.get_mgr_pmv_sql;
93: fii_gl_util_pkg.get_cat_pmv_sql;
94:
95: -- when budget comparison type is selected, budget amount is used to calculate the change column
96: -- in the KPI portlet; when year/year or sequential comparison type is selected, prior actual

Line 93: fii_gl_util_pkg.get_cat_pmv_sql;

89: fii_gl_util_pkg.g_fin_type := 'OM';
90: fii_gl_util_pkg.g_view_by := 'HRI_PERSON+HRI_PER_USRDR_H';
91: fii_gl_util_pkg.get_viewby_sql;
92: fii_gl_util_pkg.get_mgr_pmv_sql;
93: fii_gl_util_pkg.get_cat_pmv_sql;
94:
95: -- when budget comparison type is selected, budget amount is used to calculate the change column
96: -- in the KPI portlet; when year/year or sequential comparison type is selected, prior actual
97: -- amount is used to calculate the change column in the KPI portlet

Line 98: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') THEN

94:
95: -- when budget comparison type is selected, budget amount is used to calculate the change column
96: -- in the KPI portlet; when year/year or sequential comparison type is selected, prior actual
97: -- amount is used to calculate the change column in the KPI portlet
98: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') THEN
99: l_prior_or_budget1 :='NVL(sum(CY_BUDGET_REV), 0) FII_MEASURE2,
100: SUM(NVL(sum(CY_BUDGET_REV), 0)) OVER () FII_GRAND_TOTAL2,';
101:
102: l_prior_or_budget2 :='NVL(sum(CY_BUDGET_EXP), 0) FII_MEASURE4,

Line 137: SELECT '||fii_gl_util_pkg.g_viewby_value||' VIEWBY,

133: * operating_income_previous FII_MEASURE6
134: */
135:
136: sqlstmt := '
137: SELECT '||fii_gl_util_pkg.g_viewby_value||' VIEWBY,
138: f.viewby_id VIEWBYID,
139: NVL(sum(CY_ACTUAL_REV),0) FII_MEASURE1,
140: SUM(NVL(sum(CY_ACTUAL_REV),0)) OVER () FII_GRAND_TOTAL1,
141: NVL(sum(CY_ACTUAL_EXP),0) FII_MEASURE3,

Line 154: '||fii_gl_util_pkg.g_viewby_from_clause||',

150: '||l_prior_or_budget1||'
151: '||l_prior_or_budget2||'
152: '||l_prior_or_budget3||'
153: FROM
154: '||fii_gl_util_pkg.g_viewby_from_clause||',
155: (select '||fii_gl_util_pkg.g_viewby_id||' viewby_id,
156: sum(case when bitand(cal.record_type_id, :ACTUAL_PERIOD_TYPE) = cal.record_type_id
157: and asgn.fin_cat_type_code = ''R''
158: then f.actual_g

Line 155: (select '||fii_gl_util_pkg.g_viewby_id||' viewby_id,

151: '||l_prior_or_budget2||'
152: '||l_prior_or_budget3||'
153: FROM
154: '||fii_gl_util_pkg.g_viewby_from_clause||',
155: (select '||fii_gl_util_pkg.g_viewby_id||' viewby_id,
156: sum(case when bitand(cal.record_type_id, :ACTUAL_PERIOD_TYPE) = cal.record_type_id
157: and asgn.fin_cat_type_code = ''R''
158: then f.actual_g
159: else to_number(NULL) end) CY_ACTUAL_REV,

Line 185: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'

181: to_number(NULL) PY_ACTUAL_EXP,
182: to_number(NULL) PY_ACTUAL_CGS
183: FROM FII_TIME_RPT_STRUCT cal,
184: FII_FIN_CAT_TYPE_ASSGNS asgn
185: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'
186: WHERE f.time_id = cal.time_id
187: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'
188: '||fii_gl_util_pkg.g_gid||'
189: AND f.period_type_id = cal.period_type_id

Line 187: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'

183: FROM FII_TIME_RPT_STRUCT cal,
184: FII_FIN_CAT_TYPE_ASSGNS asgn
185: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'
186: WHERE f.time_id = cal.time_id
187: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'
188: '||fii_gl_util_pkg.g_gid||'
189: AND f.period_type_id = cal.period_type_id
190: AND BITAND(cal.record_type_id, :WHERE_PERIOD_TYPE)= cal.record_type_id
191: AND cal.report_date = &BIS_CURRENT_ASOF_DATE

Line 188: '||fii_gl_util_pkg.g_gid||'

184: FII_FIN_CAT_TYPE_ASSGNS asgn
185: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'
186: WHERE f.time_id = cal.time_id
187: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'
188: '||fii_gl_util_pkg.g_gid||'
189: AND f.period_type_id = cal.period_type_id
190: AND BITAND(cal.record_type_id, :WHERE_PERIOD_TYPE)= cal.record_type_id
191: AND cal.report_date = &BIS_CURRENT_ASOF_DATE
192: AND asgn.fin_category_id = f.fin_category_id

Line 193: GROUP BY '||fii_gl_util_pkg.g_viewby_id||'

189: AND f.period_type_id = cal.period_type_id
190: AND BITAND(cal.record_type_id, :WHERE_PERIOD_TYPE)= cal.record_type_id
191: AND cal.report_date = &BIS_CURRENT_ASOF_DATE
192: AND asgn.fin_category_id = f.fin_category_id
193: GROUP BY '||fii_gl_util_pkg.g_viewby_id||'
194: union all
195:
196: select '||fii_gl_util_pkg.g_viewby_id||' viewby_id,
197: to_number(NULL) CY_ACTUAL_REV,

Line 196: select '||fii_gl_util_pkg.g_viewby_id||' viewby_id,

192: AND asgn.fin_category_id = f.fin_category_id
193: GROUP BY '||fii_gl_util_pkg.g_viewby_id||'
194: union all
195:
196: select '||fii_gl_util_pkg.g_viewby_id||' viewby_id,
197: to_number(NULL) CY_ACTUAL_REV,
198: to_number(NULL) CY_ACTUAL_EXP,
199: to_number(NULL) CY_ACTUAL_CGS,
200: to_number(NULL) CY_BUDGET_REV,

Line 217: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'

213: then f.actual_g
214: else to_number(NULL) end) PY_ACTUAL_CGS
215: FROM FII_TIME_RPT_STRUCT cal,
216: FII_FIN_CAT_TYPE_ASSGNS asgn
217: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'
218: WHERE f.time_id = cal.time_id
219: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'
220: '||fii_gl_util_pkg.g_gid||'
221: AND f.period_type_id = cal.period_type_id

Line 219: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'

215: FROM FII_TIME_RPT_STRUCT cal,
216: FII_FIN_CAT_TYPE_ASSGNS asgn
217: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'
218: WHERE f.time_id = cal.time_id
219: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'
220: '||fii_gl_util_pkg.g_gid||'
221: AND f.period_type_id = cal.period_type_id
222: AND BITAND(cal.record_type_id, :ACT_WHERE_PERIOD_TYPE)= cal.record_type_id
223: AND cal.report_date = &BIS_PREVIOUS_ASOF_DATE

Line 220: '||fii_gl_util_pkg.g_gid||'

216: FII_FIN_CAT_TYPE_ASSGNS asgn
217: '||fii_gl_util_pkg.g_view||fii_gl_util_pkg.g_mgr_from_clause||'
218: WHERE f.time_id = cal.time_id
219: '||fii_gl_util_pkg.g_mgr_join||fii_gl_util_pkg.g_cat_join||'
220: '||fii_gl_util_pkg.g_gid||'
221: AND f.period_type_id = cal.period_type_id
222: AND BITAND(cal.record_type_id, :ACT_WHERE_PERIOD_TYPE)= cal.record_type_id
223: AND cal.report_date = &BIS_PREVIOUS_ASOF_DATE
224: AND asgn.fin_category_id = f.fin_category_id

Line 225: GROUP BY '||fii_gl_util_pkg.g_viewby_id||') f

221: AND f.period_type_id = cal.period_type_id
222: AND BITAND(cal.record_type_id, :ACT_WHERE_PERIOD_TYPE)= cal.record_type_id
223: AND cal.report_date = &BIS_PREVIOUS_ASOF_DATE
224: AND asgn.fin_category_id = f.fin_category_id
225: GROUP BY '||fii_gl_util_pkg.g_viewby_id||') f
226:
227: WHERE '||fii_gl_util_pkg.g_viewby_join||'
228: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', f.viewby_id';
229:

Line 227: WHERE '||fii_gl_util_pkg.g_viewby_join||'

223: AND cal.report_date = &BIS_PREVIOUS_ASOF_DATE
224: AND asgn.fin_category_id = f.fin_category_id
225: GROUP BY '||fii_gl_util_pkg.g_viewby_id||') f
226:
227: WHERE '||fii_gl_util_pkg.g_viewby_join||'
228: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', f.viewby_id';
229:
230: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);
231: END get_oper_profit;

Line 228: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', f.viewby_id';

224: AND asgn.fin_category_id = f.fin_category_id
225: GROUP BY '||fii_gl_util_pkg.g_viewby_id||') f
226:
227: WHERE '||fii_gl_util_pkg.g_viewby_join||'
228: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', f.viewby_id';
229:
230: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);
231: END get_oper_profit;
232:

Line 230: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);

226:
227: WHERE '||fii_gl_util_pkg.g_viewby_join||'
228: GROUP BY '||fii_gl_util_pkg.g_viewby_value||', f.viewby_id';
229:
230: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);
231: END get_oper_profit;
232:
233: PROCEDURE GET_REV_BY_CHANNEL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
234: rev_by_channel_sql out NOCOPY VARCHAR2, rev_by_channel_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

Line 240: fii_gl_util_pkg.reset_globals;

236: rev_by_channel_rec BIS_QUERY_ATTRIBUTES;
237: sqlstmt VARCHAR2(32000);
238:
239: BEGIN
240: fii_gl_util_pkg.reset_globals;
241: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
242: fii_gl_util_pkg.get_bitmasks;
243:
244:

Line 241: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

237: sqlstmt VARCHAR2(32000);
238:
239: BEGIN
240: fii_gl_util_pkg.reset_globals;
241: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
242: fii_gl_util_pkg.get_bitmasks;
243:
244:
245:

Line 242: fii_gl_util_pkg.get_bitmasks;

238:
239: BEGIN
240: fii_gl_util_pkg.reset_globals;
241: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
242: fii_gl_util_pkg.get_bitmasks;
243:
244:
245:
246: /* --- Mapping -------

Line 254: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN /* Done for bug 3875336 */

250: * revenue_amount FII_MEASURE4,
251: * revenue_amount_previous FII_MEASURE5,
252: */
253:
254: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN /* Done for bug 3875336 */
255:
256: sqlstmt := '
257:
258: SELECT NULL FII_ATTRIBUTE1,

Line 287: fii_ar_rev_sum_v'|| fii_gl_util_pkg.g_global_curr_view ||' f,

283: then f.actual_g else 0 end)) over() FII_MEASURE7,
284: sum(sum(case when cal.report_date = &BIS_PREVIOUS_ASOF_DATE
285: then f.actual_g else 0 end)) over() FII_MEASURE8
286: FROM bis_sales_channels_v bsc,
287: fii_ar_rev_sum_v'|| fii_gl_util_pkg.g_global_curr_view ||' f,
288: fii_cc_mgr_hierarchies h,
289: FII_TIME_RPT_STRUCT cal
290: where f.sales_channel_code = bsc.id
291: and h.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H

Line 301: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_by_channel_sql, rev_by_channel_output);

297: group by bsc.value, bsc.id';
298:
299: END IF;
300:
301: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, rev_by_channel_sql, rev_by_channel_output);
302:
303: END GET_REV_BY_CHANNEL;
304:
305: END fii_gl_profit_and_loss;