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.
PACKAGE: APPS.BSC_BSC_XTD_PKG

Source


1 package BSC_BSC_XTD_PKG AS
2 /*$Header: BSCRPTCS.pls 120.3 2006/02/14 11:55:28 vsurendr noship $*/
3 --program runtime parameters
4 Type varchar_tabletype is Table of varchar2(800) index by binary_integer;
5 Type number_tabletype is Table of number index by binary_integer;
6 Type boolean_tabletype is Table of boolean index by binary_integer;
7 Type date_tabletype is Table of date index by binary_integer;
8 --------
9 --support for rolling periods
10 g_roll_year_range number:=365;
11 g_roll_qtr_range number:=90;
12 g_roll_period_range number:=30;
13 g_roll_week_range number:=7;
14 g_exception exception;
15 --------
16 
17 type xtd_record is record(
18 session_id number,
19 kpi number,
20 report_date date,
21 xtd_periodicity number);
22 type xtd_record_table is table of xtd_record;
23 --------
24 g_kpi_xtd xtd_record_table;--keeps track of what is already in bsc_rpt_cal_keys
25 g_num_kpi_xtd number:=0;
26 g_session_id number;
27 g_debug boolean;
28 g_status number;
29 g_status_message varchar2(4000);
30 g_file boolean;
31 g_options BSC_IM_UTILS.varchar_tabletype;
32 g_number_options number;
33 g_bsc_owner varchar2(40);--schema
34 g_fnd_owner varchar2(40);--schema
35 g_option_string varchar2(20000);
36 -------------------------------------------------
37 procedure open_file;
38 procedure populate_rpt_keys(
39 p_table_name varchar2,
40 p_session_id number,
41 p_kpi number,
42 p_report_date varchar2,
43 p_xtd_period varchar2,
44 p_xtd_year varchar2,
45 p_xtd_periodicity number,
46 p_option_string varchar2,
47 p_error_message out nocopy varchar2
48 );
49 procedure populate_rpt_keys(
50 p_table_name varchar2,
51 p_session_id number,
52 p_kpi number,
53 p_report_date varchar2,
54 p_xtd_period varchar2,
55 p_xtd_year varchar2,
56 p_xtd_periodicity number,
57 p_xtd_type varchar2,--ROLLING vs XTD
58 p_option_string varchar2,
59 p_error_message out nocopy varchar2
60 );
61 function populate_rpt_keys(
62 p_table_name varchar2,--name of the rpt_cal_keys table
63 p_session_id number,
64 p_kpi number,
65 p_report_date date_tabletype,
66 p_num_report_date number,
67 p_xtd_period number_tabletype,--use p_num_report_date for count
68 p_xtd_year number_tabletype,--use p_num_report_date for count
69 p_xtd_periodicity number,
70 p_xtd_type varchar2
71 )return boolean;
72 function parse_values(
73 p_list varchar2,
74 p_separator varchar2,
75 p_names out nocopy number_tabletype,
76 p_number_names out nocopy number) return boolean;
77 function parse_values(
78 p_list varchar2,
79 p_separator varchar2,
80 p_names out nocopy varchar_tabletype,
81 p_number_names out nocopy number) return boolean;
82 function insert_rpt_cal_keys(
83 p_table_name varchar2,
84 p_report_date date,
85 p_report_date_insert date,--used to insert into bsc_rpt_keys table
86 p_xtd_periodicity number,
87 p_xtd_period number,
88 p_xtd_year number,
89 p_hier varchar2,
90 p_xtd_pattern number,
91 p_calendar_id number,
92 p_roll_flag varchar2,
93 p_periodicity_missing boolean,
94 p_period_periodicity number_tabletype,
95 p_period_missing boolean_tabletype,
96 p_num_pattern_period number
97 )return boolean;
98 function correct_rpt_cal_keys(
99 p_table_name varchar2,
100 p_report_date date,
101 p_xtd_periodicity number,
102 p_periodicity_missing number,
103 p_periodicity_present number,
104 p_calendar_id number,
105 p_roll_flag varchar2
106 )return boolean;
107 procedure delete_rpt_keys(
108 p_table_name varchar2,
109 p_session_id number,
110 p_error_message out nocopy varchar2
111 );
112 procedure create_rpt_key_table(
113 p_user_id number,
114 p_table_name out nocopy varchar2,
115 p_error_message out nocopy varchar2
116 );
117 procedure drop_rpt_key_table(
118 p_user_id number,
119 p_error_message out nocopy varchar2
120 );
121 procedure get_bsc_fnd_owner;
122 procedure init;
123 function get_day_count(
124 p_table_name varchar2,
125 p_session_id number,
126 p_report_date date,
127 p_roll_flag varchar2) return number;
128 procedure delete_table(
129 p_table_name varchar2,
130 p_session_id number,
131 p_report_date date,
132 p_roll_flag varchar2);
133 function populate_rolling_rpt_keys(
134 p_table_name varchar2,--name of the rpt_cal_keys table
135 p_session_id number,
136 p_hier varchar2,
137 p_xtd_pattern varchar2,
138 p_calendar_id number,
139 p_report_date date_tabletype,
140 p_num_report_date number,
141 p_xtd_period number_tabletype,--use p_num_report_date for count
142 p_xtd_year number_tabletype,--use p_num_report_date for count
143 p_xtd_periodicity number,
144 p_periodicity number_tabletype,
145 p_period_num_of_periods number_tabletype,
146 p_num_periodicity number,
147 --
148 p_periodicity_missing boolean,
149 p_period_periodicity number_tabletype,
150 p_period_missing boolean_tabletype,
151 p_num_pattern_period number
152 )return boolean ;
153 procedure correct_rolling_data_92_91(
154 p_table_name varchar2);
155 procedure correct_rolling_data(
156 p_table_name varchar2,
157 p_session_id number,
158 p_xtd_report_date date,
159 p_rtd_report_date date,
160 p_xtd_periodicity number,
161 p_xtd_period number,
162 p_xtd_year number,
163 p_hier varchar2,
164 p_xtd_pattern number,
165 p_calendar_id number,
166 p_periodicity_missing boolean,
167 p_period_periodicity number_tabletype,
168 p_period_missing boolean_tabletype,
169 p_num_pattern_period number
170 );
171 procedure populate_rpt_keys_daily(
172 p_table_name varchar2,--name of the rpt_cal_keys table
173 p_session_id number,
174 p_calendar_id number,
175 p_report_date date_tabletype,
176 p_num_report_date number,
177 p_xtd_period number_tabletype,--use p_num_report_date for count
178 p_xtd_year number_tabletype,--use p_num_report_date for count
179 p_xtd_periodicity number,
180 p_xtd_type varchar2
181 );
182 function is_daily_periodicity(p_periodicity number) return boolean ;
183 -------------------------------------------
184 function get_time return varchar2;
185 -------------------------------------------------
186 
187 --TYPE clskeys IS RECORD (  keysRow BSC_RPT_KEYS%ROWTYPE);
188 TYPE tab_clsKeys IS TABLE of BSC_RPT_KEYS%ROWTYPE INDEX BY BINARY_INTEGER;
189 
190 gKeysTable tab_clsKeys;
191 
192 END BSC_BSC_XTD_PKG;