[Home] [Help]
PACKAGE: APPS.BIL_BI_UTIL_PKG
Source
1 PACKAGE BIL_BI_UTIL_PKG AS
2 /* $Header: bilbuts.pls 120.4 2005/10/10 03:08:35 hrpandey noship $ */
3
4
5 FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN;
6
7 PROCEDURE GET_CONV_RATE(p_as_of_date IN DATE
8 ,p_currency IN VARCHAR2
9 ,x_conv_rate_selected OUT NOCOPY VARCHAR2
10 ,x_err_desc OUT NOCOPY VARCHAR2
11 ,x_err_msg OUT NOCOPY VARCHAR2
12 ,x_parameter_valid OUT NOCOPY BOOLEAN );
13
14 PROCEDURE GET_CURR_DATE(x_curr_date OUT NOCOPY DATE);
15
16 PROCEDURE GET_CURR_START_DATE (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
17 p_as_of_date IN DATE,
18 p_period_type IN VARCHAR2,
19 x_curr_start_date OUT NOCOPY DATE);
20
21 FUNCTION GET_DBI_PARAMS(p_region_id IN VARCHAR2) RETURN VARCHAR2;
22
23 FUNCTION get_dbi_sales_group_id RETURN VARCHAR2;
24
25 PROCEDURE GET_DEFAULT_QUERY(p_RegionName IN VARCHAR2,
26 x_SqlStr OUT NOCOPY VARCHAR2);
27
28 PROCEDURE GET_FORECAST_PROFILES(x_FstCrdtType OUT NOCOPY VARCHAR2 );
29
30 PROCEDURE GET_GLOBAL_CONTS(x_bitand_id OUT NOCOPY VARCHAR2,
31 x_calendar_id OUT NOCOPY VARCHAR2,
32 x_curr_date OUT NOCOPY DATE,
33 x_fii_struct OUT NOCOPY VARCHAR2);
34
35 PROCEDURE GET_LATEST_SNAP_DATE(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
36 p_as_of_date IN DATE,
37 p_period_type IN VARCHAR2,
38 x_snapshot_date OUT NOCOPY DATE);
39
40
41 PROCEDURE GET_OTHER_PROFILES(x_DebugMode OUT NOCOPY VARCHAR2);
42
43
44
45 PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
46 p_region_id IN VARCHAR2,
47 x_as_of_date OUT NOCOPY DATE,
48 x_comp_type OUT NOCOPY VARCHAR2,
49 x_conv_rate_selected OUT NOCOPY VARCHAR2,
50 x_curr_page_time_id OUT NOCOPY NUMBER,
51 x_page_period_type OUT NOCOPY VARCHAR2,
52 x_parameter_valid OUT NOCOPY BOOLEAN,
53 x_period_type OUT NOCOPY VARCHAR2,
54 x_prev_page_time_id OUT NOCOPY NUMBER,
55 x_prior_as_of_date OUT NOCOPY DATE,
56 x_prodcat_id OUT NOCOPY VARCHAR2,
57 x_record_type_id OUT NOCOPY NUMBER,
58 x_resource_id OUT NOCOPY VARCHAR2,
59 x_sg_id OUT NOCOPY VARCHAR2,
60 x_parent_sg_id OUT NOCOPY NUMBER,
61 x_viewby OUT NOCOPY VARCHAR2);
62
63
64 PROCEDURE GET_PRODUCT_WHERE_CLAUSE(p_prodcat IN VARCHAR2,
65 p_viewby IN VARCHAR2,
66 x_denorm OUT NOCOPY VARCHAR2,
67 x_where_clause OUT NOCOPY VARCHAR2);
68
69 PROCEDURE GET_PC_NOROLLUP_WHERE_CLAUSE(p_prodcat IN VARCHAR2,
70 p_viewby IN VARCHAR2,
71 x_denorm OUT NOCOPY VARCHAR2,
72 x_where_clause OUT NOCOPY VARCHAR2);
73
74 PROCEDURE GET_TREND_PARAMS (p_comp_type IN VARCHAR2,
75 p_curr_as_of_date IN DATE,
76 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
77 p_page_period_type IN VARCHAR2,
78 x_column_name OUT NOCOPY VARCHAR2,
79 x_curr_eff_end_date OUT NOCOPY DATE,
80 x_curr_start_date OUT NOCOPY DATE,
81 x_prev_eff_end_date OUT NOCOPY DATE,
82 x_prev_start_date OUT NOCOPY DATE,
83 x_table_name OUT NOCOPY VARCHAR2);
84
85 FUNCTION isUserCurrency (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN BOOLEAN;
86
87 FUNCTION GET_UNASSIGNED_PC RETURN VARCHAR2;
88
89 FUNCTION isLeafNode (p_prodcat_id IN NUMBER) RETURN BOOLEAN;
90
91 PROCEDURE PARSE_SALES_GROUP_ID(p_salesgroup_id IN OUT NOCOPY VARCHAR2,
92 x_resource_id OUT NOCOPY VARCHAR2 );
93
94 FUNCTION getLookupMeaning (p_lookuptype IN VARCHAR2,p_lookupcode IN VARCHAR2) RETURN VARCHAR2;
95
96
97
98 PROCEDURE GET_PARENT_SLS_GRP_ID(p_sales_grp_id IN NUMBER,
99 x_parent_sls_grp_id OUT NOCOPY NUMBER,
100 x_parameter_valid OUT NOCOPY BOOLEAN);
101
102
103
104
105 PROCEDURE GET_PRIOR_PRIOR_TIME (p_comp_type IN VARCHAR2,
106 p_period_type IN VARCHAR2,
107 p_prev_date IN DATE,
108 p_prev_page_time_id IN NUMBER,
109 x_prior_prior_date OUT NOCOPY DATE,
110 x_prior_prior_time_id OUT NOCOPY NUMBER);
111
112 FUNCTION GET_DRILL_LINKS ( p_view_by IN VARCHAR2,
113 p_salesgroup_id IN VARCHAR2,
114 p_resource_id IN VARCHAR2
115 ) RETURN VARCHAR2;
116
117
118 FUNCTION GET_LBL_SGFST (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN VARCHAR2;
119
120
121 PROCEDURE GET_PIPE_SNAP_DATE( p_as_of_date IN DATE,
122 p_prev_date IN DATE,
123 p_period_type IN VARCHAR2,
124 p_coll_st_date IN DATE,
125 p_coll_end_date IN DATE,
126 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
127 x_snap_date OUT NOCOPY DATE,
128 x_prev_snap_date OUT NOCOPY DATE
129 );
130
131 PROCEDURE GET_PIPE_MV(
132 p_asof_date IN DATE,
133 p_period_type IN VARCHAR2,
134 p_compare_to IN VARCHAR2,
135 p_prev_date IN DATE,
136 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
137 x_pipe_mv OUT NOCOPY VARCHAR2,
138 x_snapshot_date OUT NOCOPY DATE,
139 x_prev_snap_date OUT NOCOPY DATE
140 ) ;
141
142 FUNCTION GET_HIST_SNAPSHOT_DATE (p_asof_date IN DATE,
143 x_period_type IN VARCHAR2
144 ) RETURN DATE;
145
146 FUNCTION GET_PIPE_COL_NAMES(p_period_type IN VARCHAR2,
147 p_compare_to IN VARCHAR2,
148 p_column_type IN VARCHAR2,
149 p_curr_suffix IN VARCHAR2
150 ) RETURN VARCHAR2;
151
152
153 PROCEDURE GET_PIPE_TREND_SOURCE (p_as_of_date IN DATE,
154 p_prev_date IN DATE,
155 p_trend_type IN VARCHAR2,
156 p_period_type IN VARCHAR2,
157 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
158 x_pipe_mv OUT NOCOPY VARCHAR2,
159 x_snap_date OUT NOCOPY DATE,
160 x_prev_snap_date OUT NOCOPY DATE);
161
162 END BIL_BI_UTIL_PKG;