1 package BIS_CREATE_REQUESTSET AUTHID CURRENT_USER AS
2 /*$Header: BISCRSTS.pls 120.2 2006/09/07 14:33:27 aguwalan noship $*/
3
4
5 Type varcharTableType is Table of varchar2(30) index by binary_integer;
6 ---this procedure is for creating a request set and add it to a report group for given responsibility
7 procedure create_set_all(p_setname in varchar2,p_setlongname in varchar2,p_setapp in varchar2);
8 procedure delete_set_all(p_setname in varchar2,p_setlongname in varchar2,p_setapp in varchar2);
9 procedure get_stage_sequence(p_set_name in varchar2,
10 p_set_app in varchar2,
11 p_process_name in varchar2,
12 p_process_app in varchar2,
13 x_stage out NOCOPY varchar2,
14 x_sequence out NOCOPY number);
15
16 function get_max_prog_sequence(p_set_name in varchar2,
17 p_set_app in varchar2,
18 p_stage_name varchar2) return number ;
19
20
21
22
23
24
25
26 /**
27 *this api is a wrapper of add_portlet_to_set and add_table_to_set and add_page_to_set
28 *parameter description:
29 *(1)p_object_type:from bis_obj_dependency table object_type, like 'PAGE', 'TABLE','PORTLET','MV', etc
30 (2)p_object_name:table name, portlet internal name etc
31 (3)p_object_owner: from bis_obj_dependency table, 'FII','POA', etc
32 (4)p_setname : request set short name
33 (5)p_setapp: request set application short name
34 (6)p_option: create the request set per portlet,per page or for all. Currently only support 'ALL'
35 (7)p_analyze_table: 'Y'--add fnd_stats call for MVs
36 (8)p_refresh_mode:'INCR'--incremental refresh,'INIT'--initial refresh,'INIT_INCR'--Initial and Incremental refresh
37 (9)p_portal_exist: 'Y' if portal installed in the same instance, null---not installed
38 **/
39 procedure add_object_to_set(p_object_type in varchar2,
40 p_object_name in varchar2,
41 p_object_owner in varchar2,
42 p_setname in varchar2,
43 p_setapp in varchar2,
44 p_option in varchar2,
45 p_analyze_table in varchar2,
46 p_refresh_mode in varchar2,
47 p_portal_exist in varchar2,
48 p_force_full_refresh in varchar2);
49
50
51
52 function set_in_group(p_set_name varchar2,
53 p_setapp varchar2,
54 p_group_name varchar2,
55 p_group_app varchar2) return varchar2;
56
57 procedure remove_empty_stages(p_set_name varchar2,
58 p_setapp varchar2);
59
60 procedure wrapup( p_setname in varchar2,
61 p_setapp in varchar2,
62 p_option in varchar2,
63 p_analyze_table in varchar2,
64 p_refresh_mode in varchar2,
65 p_force_full_refresh in varchar2,
66 p_alert_flag in varchar2);
67
68 function is_stage_empty(p_setapp_id number,
69 p_set_id number,
70 p_set_stage_id number) return varchar2;
71
72 procedure get_stats_stage_sequence(p_set_name in varchar2,
73 p_set_app in varchar2,
74 p_process_name in varchar2,
75 p_parameter_value in varchar2,
76 p_parameter_type in varchar2,
77 x_stage out NOCOPY varchar2,
78 x_sequence out NOCOPY number);
79
80 function get_object_owner(p_obj_name in varchar2,p_obj_type in varchar2) return varchar2;
81
82 ---this function will return 'N' if the object has no direct dependency except dimensions
83 function dependency_exist(p_object_name in varchar2, p_object_type in varchar2) return varchar2;
84
85 function object_has_data(p_object_name in varchar2, p_object_type in varchar2,p_object_owner in varchar2) return varchar2;
86
87 procedure add_first_last_stages(p_set_name in varchar2,p_set_app in varchar2,p_max_stage in number,p_min_stage in number,
88 p_rsg_history_flag in varchar2);
89
90 procedure create_rs_option(p_set_name in varchar2, p_set_app in varchar2,
91 p_refresh_mode in varchar2, p_analyze_table in varchar2,p_force_full in varchar2,
92 p_alert_flag in varchar2, p_rsg_history_flag in VARCHAR2);
93
94 procedure create_rs_objects(p_set_name in varchar2, p_set_app in varchar2,
95 p_object_type in varchar2, p_object_name in varchar2, p_object_owner in
96 varchar2);
97
98 procedure delete_rs_objects(p_set_name in varchar2, p_set_app in varchar2 );
99
100 procedure delete_rs_option(p_set_name in varchar2, p_set_app in varchar2);
101
102 procedure preparation_conc(
103 errbuf OUT NOCOPY VARCHAR2,
104 retcode OUT NOCOPY VARCHAR,
105 p_request_set_code IN VARCHAR
106 );
107
108 procedure finalization_conc(
109 errbuf OUT NOCOPY VARCHAR2,
110 retcode OUT NOCOPY VARCHAR,
111 p_request_set_code IN VARCHAR
112 );
113
114 FUNCTION get_apps_schema_name RETURN VARCHAR2;
115
116 procedure bsc_loader_wrapper(
117 p_request_set_code IN VARCHAR
118 );
119
120 function get_indicator(p_object_name varchar2) return varchar2;
121
122 procedure analyze_objects_in_set(
123 p_request_set_code IN VARCHAR2,
124 p_set_app IN varchar2
125 );
126
127 procedure seed_data_validation(
128 errbuf OUT NOCOPY VARCHAR2,
129 retcode OUT NOCOPY VARCHAR,
130 p_request_set_code IN VARCHAR2,
131 p_set_app IN varchar2
132 ) ;
133
134 procedure add_any_object_to_set(p_object_name in varchar2,
135 p_object_type in varchar2,
136 p_setname in varchar2,
137 p_set_application in varchar2,
138 p_option in varchar2,
139 p_analyze_table in varchar2,
140 p_refresh_mode in varchar2,
141 p_force_full_refresh in varchar2) ;
142
143 PROCEDURE add_link_history_stage ( p_set_name IN varchar2,
144 p_set_app IN varchar2,
145 p_max_stage IN number,
146 p_rsg_history_flag IN VARCHAR2);
147
148 function get_bsc_schema_name return varchar;
149 function get_mv_log (p_object_name in varchar2,p_schema_name in varchar2 ) return varchar2 ;
150 function get_report_type(p_object_name in varchar2) return varchar2 ;
151 function get_indicator_auto_gen(p_object_name in varchar2) return number;
152
153 /*
154 * Added for Bug#4881518 :: API to check the status of all the request inside the request
155 */
156 PROCEDURE set_rs_status(errbuf OUT NOCOPY VARCHAR2,
157 retcode OUT NOCOPY VARCHAR) ;
158
159 /*
160 * API to return the value of the request set option='HISTORY_COLLECT' :: Enh#4418520-aguwalan
161 */
162 FUNCTION is_history_collect_on(p_request_set_name IN VARCHAR2,
163 p_request_app_id IN NUMBER) RETURN BOOLEAN;
164
165 /*
166 * Overloading is_history_collect_on API to take the root_Request_id and return the request set
167 * option='HISTORY_COLLECT' :: Enh#4418520-aguwalan
168 */
169 FUNCTION is_history_collect_on(p_root_request_id IN NUMBER) RETURN BOOLEAN;
170
171 /*
172 * Overloading wrapup api to support Enh#4418520-aguwalan
173 */
174 PROCEDURE wrapup( p_setname in varchar2,
175 p_setapp in varchar2,
176 p_option in varchar2,
177 p_analyze_table in varchar2,
178 p_refresh_mode in varchar2,
179 p_force_full_refresh in varchar2,
180 p_alert_flag in varchar2,
181 p_rsg_history_flag in varchar2);
182
183 END BIS_CREATE_REQUESTSET;
184