[Home] [Help]
PACKAGE: APPS.FII_GL_UTIL_PKG
Source
1 PACKAGE fii_gl_util_pkg AS
2 /* $Header: FIIGLC5S.pls 120.6 2006/03/15 15:09:18 hpoddar noship $ */
3 g_viewby_type VARCHAR2(50);
4 g_period_type NUMBER;
5 g_where_period_type NUMBER;
6 g_act_where_period_type NUMBER;
7 g_ent_period_type NUMBER;
8 g_actual_period_type NUMBER;
9 g_budget_period_type NUMBER;
10 g_forecast_period_type NUMBER;
11 g_global_curr_view VARCHAR2(1);
12 g_view VARCHAR2(100);
13 g_view_by VARCHAR2(30);
14 g_lob_id VARCHAR2(30);
15 g_previous_asof_date DATE;
16 g_as_of_date DATE;
17 g_curr_start DATE;
18 g_curr_end DATE;
19 g_temp DATE;
20 g_prior_start DATE;
21 g_prior_end DATE;
22 g_mgr_id NUMBER;
23 g_mgr_mgr_id NUMBER;
24 g_fin_id NUMBER;
25 g_py_sper_end DATE;
26 g_curr_per_sequence NUMBER;
27 g_p_period_end DATE;
28 g_p_p_period_end DATE;
29 g_ccc_id NUMBER;
30 g_time_comp VARCHAR2(30);
31 g_currency VARCHAR2(50);
32 g_gid VARCHAR2(30);
33 g_lob_from_clause VARCHAR2(500);
34 g_mgr_from_clause VARCHAR2(500);
35 g_cat_from_clause VARCHAR2(500);
36 g_ccc_from_clause VARCHAR2(500);
37 g_non_ag_cat_from_clause VARCHAR2(500);
38 g_lob_join VARCHAR2(200);
39 g_cat_join VARCHAR2(32000);
40 g_mgr_join VARCHAR2(200);
41 g_ccc_join VARCHAR2(500);
42 g_non_ag_cat_join VARCHAR2(32000);
43 g_lob_viewby_from_clause VARCHAR2(500);
44 g_mgr_viewby_from_clause VARCHAR2(500);
45 g_cat_viewby_from_clause VARCHAR2(500);
46 g_ccc_viewby_from_clause VARCHAR2(500);
47 g_viewby_from_clause VARCHAR2(500);
48 g_lob_viewby_join VARCHAR2(200);
49 g_cat_viewby_join VARCHAR2(200);
50 g_mgr_viewby_join VARCHAR2(200);
51 g_ccc_viewby_join VARCHAR2(500);
52 g_viewby_join VARCHAR2(500);
53 g_lob_viewby_value VARCHAR2(30);
54 g_cat_viewby_value VARCHAR2(30);
55 g_ccc_viewby_value VARCHAR2(30);
56 g_mgr_viewby_value VARCHAR2(30);
57 g_viewby_value VARCHAR2(200);
58 g_lob_viewby_id VARCHAR2(30);
59 g_cat_viewby_id VARCHAR2(30);
60 g_mgr_viewby_id VARCHAR2(30);
61 g_ccc_viewby_id VARCHAR2(30);
62 g_viewby_id VARCHAR2(30);
63 g_parent_fin_id NUMBER;
64 g_fin_type VARCHAR2(200);
65 g_month_id VARCHAR2(100);
66 g_page_period_type VARCHAR2(100);
67 g_cy_period_end DATE;
68 g_ent_pyr_start DATE;
69 g_ent_pyr_end DATE;
70 g_ent_cyr_start DATE;
71 g_ent_cyr_end DATE;
72 g_total_hc NUMBER;
73 g_py_sday DATE;
74 g_five_yr_back DATE;
75 g_begin_date DATE;
76 g_rpt_begin_date DATE;
77 g_rev_msg VARCHAR2(240);
78 g_exp_msg VARCHAR2(240);
79 g_cog_msg VARCHAR2(240);
80 g_dir_msg VARCHAR2(240);
81 g_prod_id NUMBER;
82 g_cat_join2 VARCHAR2(32000);
83 g_lob_is_top_node VARCHAR2(1);
84 g_cc_owner NUMBER;
85 g_ccc_mgr_join VARCHAR2(200);
86 g_ppy_sday DATE;
87 g_new_date DATE;
88 g_new_date2 DATE;
89 g_detail_start DATE;
90 g_detail_end DATE;
91 g_top_spend_start DATE;
92 g_top_spend_end DATE;
93 g_exp_asof_date DATE;
94 g_exp_begin_date DATE;
95 g_exp_start DATE;
96 g_mgr_is_leaf VARCHAR2(1);
97 g_lob_is_leaf VARCHAR2(1);
98 g_fincat_is_leaf VARCHAR2(1);
99 g_sd_lyr DATE;
100 --added for bug fix 5002238
101 --by vkazhipu
102 --changing l_id and l_dim_flag to bind variables
103 g_l_id NUMBER;
104 g_dim_flag VARCHAR2(1);
105 g_bitmask NUMBER;
106 --added for bug fix 4969910
107 --added by hpoddar
108 --changing l_start,l_end,l_slice_type_flag,l_prev_mgr_id and l_emp_id to bind variables
109
110 g_start_id NUMBER;
111 g_end_id NUMBER;
112 g_slice_type_flag VARCHAR2(1);
113 g_prev_mgr_id NUMBER;
114 g_emp_id NUMBER;
115
116 --added for bug fix 5002564
117 --added by hpoddar
118 -- g_curr_start_id and g_curr_end_id store the month-id of the start date and end date of the period chosen
119 -- g_curr%day_id are used to store day-ids for start date and end date of current and prior periods
120
121 g_curr_start_period_id NUMBER;
122 g_curr_end_period_id NUMBER;
123 g_curr_start_day_id NUMBER;
124 g_curr_end_day_id NUMBER;
125 g_prior_start_day_id NUMBER;
126 g_prior_end_day_id NUMBER;
127
128
129 -- This package will provide central utilities for all GL DBI PMV content
130
131 PROCEDURE reset_globals;
132
133 PROCEDURE get_viewby_sql;
134
135 PROCEDURE get_non_ag_cat_pmv_sql;
136
137 PROCEDURE get_lob_pmv_sql;
138
139 PROCEDURE get_ccc_pmv_sql;
140
141 PROCEDURE get_cat_pmv_sql;
142
143 PROCEDURE get_parameters (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL);
144
145 PROCEDURE Bind_Variable (p_sqlstmt IN Varchar2,
146 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
147 p_sql_output OUT NOCOPY Varchar2,
148 p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
149
150 PROCEDURE get_bitmasks;
151 PROCEDURE get_mgr_pmv_sql;
152 PROCEDURE get_supervisor (l_mgr_mgr_id OUT NOCOPY NUMBER);
153
154 PROCEDURE get_lob;
155
156 FUNCTION ccc_within_mgr_lob( g_ccc_id IN NUMBER,
157 g_lob_id IN VARCHAR2,
158 g_mgr_id IN NUMBER) return varchar2;
159
160 PROCEDURE get_fin_item ( l_fin_id IN NUMBER,
161 l_p_fin_id OUT NOCOPY NUMBER);
162
163 FUNCTION get_first_string(l_id IN VARCHAR2) return VARCHAR2;
164
165 END fii_gl_util_pkg;
166