[Home] [Help]
PACKAGE: APPS.CZ_ORAAPPS_INTEGRATE
Source
1 PACKAGE CZ_ORAAPPS_INTEGRATE AUTHID CURRENT_USER AS
2 /* $Header: czcaints.pls 120.3 2011/03/31 22:02:39 lamrute ship $ */
3
4 mERRBUF VARCHAR2(4000);
5 mRETCODE NUMBER;
6
7 LINK_WORKS CONSTANT CHAR(1):='0';
8 LINK_IS_DOWN CONSTANT CHAR(1):='1';
9
10 FUNCTION ITEM_SURROGATE_KEY(nITEM_ID IN VARCHAR2,nORG_ID IN VARCHAR2)
11 RETURN VARCHAR2;
12 PRAGMA RESTRICT_REFERENCES(ITEM_SURROGATE_KEY,WNDS);
13
14 FUNCTION isLinkAlive(sDb_Link IN VARCHAR2) RETURN VARCHAR2;
15
16 FUNCTION COMPONENT_SURROGATE_KEY(sCOMPONENT_SEQUENCE_ID IN VARCHAR2,
17 sEXPLOSION_TYPE IN VARCHAR2,
18 sORG_ID IN VARCHAR2,
19 sTOP_ITEM_ID IN VARCHAR2)
20 RETURN VARCHAR2;
21 PRAGMA RESTRICT_REFERENCES(COMPONENT_SURROGATE_KEY,WNDS);
22
23 FUNCTION PROJECT_SURROGATE_KEY(sEXPLOSION_TYPE IN VARCHAR2,
24 sORG_ID IN VARCHAR2,
25 sTOP_ITEM_ID IN VARCHAR2)
26 RETURN VARCHAR2;
27 PRAGMA RESTRICT_REFERENCES(PROJECT_SURROGATE_KEY,WNDS);
28
29 FUNCTION ENDUSER_SURROGATE_KEY(sORG_ID IN VARCHAR2,sSalesrep_ID IN VARCHAR2)
30 RETURN VARCHAR2;
31 PRAGMA RESTRICT_REFERENCES(ENDUSER_SURROGATE_KEY,WNDS);
32
33 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
34 ---------- create extraction views
35
36 FUNCTION create_exv_views(slocal_name IN VARCHAR2)
37 RETURN VARCHAR2;
38
39 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
40 ---------- recreate extraction views
41
42 PROCEDURE recreate_exv_views
43 (p_link_status OUT NOCOPY VARCHAR2,
44 p_db_link OUT NOCOPY VARCHAR2,
45 p_do_compile IN VARCHAR2);
46
47 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
48 ---------- recreate extraction views concurrent program
49
50 PROCEDURE recreate_exv_views_cp(errbuf IN OUT NOCOPY VARCHAR2,
51 retcode IN OUT NOCOPY INTEGER);
52
53 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
54 ---------- drop extraction views
55
56 FUNCTION drop_exv_views
57 RETURN VARCHAR2;
58
59 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
60 -------populate cz_servers
61
62 PROCEDURE populate_cz_server_cp( Errbuf IN OUT NOCOPY VARCHAR2,
63 Retcode IN OUT NOCOPY PLS_INTEGER,
64 LOCAL_NAME IN VARCHAR2
65 ,HOSTNAME IN VARCHAR2
66 ,DB_LISTENER_PORT IN NUMBER
67 ,INSTANCE_NAME IN VARCHAR2
68 ,FNDNAM IN VARCHAR2
69 ,GLOBAL_IDENTITY IN VARCHAR2
70 ,NOTES IN VARCHAR2
71 ,FNDNAM_LINK_NAME IN VARCHAR2
72 ,IMPORT_ENABLED IN VARCHAR2
73 );
74
75 -------alter cz_servers
76 PROCEDURE alter_cz_server_cp( Errbuf IN OUT NOCOPY VARCHAR2,
77 Retcode IN OUT NOCOPY PLS_INTEGER,
78 LOCAL_NAME IN VARCHAR2
79 ,HOSTNAME IN VARCHAR2
80 ,DB_LISTENER_PORT IN NUMBER
81 ,INSTANCE_NAME IN VARCHAR2
82 ,FNDNAM IN VARCHAR2
83 ,GLOBAL_IDENTITY IN VARCHAR2
84 ,NOTES IN VARCHAR2
85 ,FNDNAM_LINK_NAME IN VARCHAR2
86 ,IMPORT_ENABLED IN VARCHAR2
87 );
88
89 ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
90 FUNCTION create_remote_hgrid_view(p_server_id IN NUMBER, p_fndnam_link_name IN VARCHAR2)
91 RETURN VARCHAR2;
92 -------create database link
93 PROCEDURE create_link_cp( Errbuf IN OUT NOCOPY VARCHAR2,
94 Retcode IN OUT NOCOPY PLS_INTEGER,
95 LOCAL_NAME IN VARCHAR2,
96 PASSWORD IN VARCHAR2);
97
98 ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
99
100 ------- proc called by concurrent manager to show cz_servers
101 PROCEDURE show_cz_servers_cp(errbuf OUT NOCOPY VARCHAR2,
102 retcode OUT NOCOPY NUMBER);
103
104 ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
105
106 PROCEDURE ITEM_EXTERNAL_PK(nSURR_KEY IN VARCHAR2,xITEM_ID OUT NOCOPY VARCHAR2,
107 xORG_ID OUT NOCOPY VARCHAR2);
108
109 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
110 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
111
112 PROCEDURE register_spx_process
113 (p_name IN VARCHAR2,
114 p_short_name IN VARCHAR2,
115 p_application IN VARCHAR2,
116 p_description IN VARCHAR2,
117 p_procedure_name IN VARCHAR2,
118 p_request_group IN VARCHAR2,
119 cz_schema IN VARCHAR2 default NULL);
120
121 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
122 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
123 PROCEDURE delete_spx_process
124 (p_short_name IN VARCHAR2,
125 p_application IN VARCHAR2);
126
127 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
128 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
129 PROCEDURE register_export_process
130 (application_name IN VARCHAR2,
131 Request_Group IN VARCHAR2,
132 cz_schema IN VARCHAR2 default NULL);
133
134 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
135 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
136
137 PROCEDURE register_import_process
138 (application_name IN VARCHAR2,
139 Request_Group IN VARCHAR2 default NULL,
140 cz_schema IN VARCHAR2 default NULL);
141
142 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
143 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
144
145 PROCEDURE register_maint_server_process
146 (application_name IN VARCHAR2,
147 Request_Group IN VARCHAR2 default NULL,
148 cz_schema IN VARCHAR2 default NULL);
149
150 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
151 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
152
153 PROCEDURE delete_export_process(application_name IN VARCHAR2);
154
155 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
156 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
157
158 PROCEDURE delete_import_process(application_name IN VARCHAR2);
159
160 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
161 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
162
163 PROCEDURE set_request_schedule
164 (repeat_time IN VARCHAR2 default NULL,
165 repeat_interval IN NUMBER,
166 repeat_unit IN VARCHAR2,
167 repeat_type IN VARCHAR2,
168 repeat_end_time IN VARCHAR2 default NULL);
169
170 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
171 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
172
173 PROCEDURE submit_export_request
174 (v_user_id IN NUMBER,
175 v_resp_id IN NUMBER,
176 vision_org_id IN NUMBER,
177 v_appl_id IN NUMBER
178 );
179
180
181 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
182 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
183
184 PROCEDURE SettingReport
185 (section_name IN VARCHAR2,
186 setting_id IN VARCHAR2,
187 cz_schema IN VARCHAR2 default NULL);
188
189 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
190 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
191
192 PROCEDURE LOG_REPORT
193 (inStr IN VARCHAR2);
194
195 /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
196 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
197
198 ------------------------------------------------------------------------------
199 PROCEDURE GetSetting(errbuf OUT NOCOPY VARCHAR2,
200 retcode OUT NOCOPY NUMBER,
201 LIKE_SectionName IN VARCHAR2,
202 LIKE_SettingID IN VARCHAR2);
203 ------------------------------------------------------------------------------
204 PROCEDURE AssignSetting(errbuf OUT NOCOPY VARCHAR2,
205 retcode OUT NOCOPY NUMBER,
206 sSECTION_NAME IN VARCHAR2,
207 sSETTING_ID IN VARCHAR2,
208 sVALUE IN VARCHAR2,
209 sTYPE IN VARCHAR2,
210 sDESCRIPTION IN VARCHAR2 DEFAULT NULL);
211 ------------------------------------------------------------------------------
212 PROCEDURE GetTableImport(errbuf OUT NOCOPY VARCHAR2,
213 retcode OUT NOCOPY NUMBER,
214 LIKE_DstTableName IN VARCHAR2,
215 LIKE_PhaseName IN VARCHAR2);
216 ------------------------------------------------------------------------------
217 PROCEDURE SetTableImport(errbuf OUT NOCOPY VARCHAR2,
218 retcode OUT NOCOPY NUMBER,
219 DstTableName IN VARCHAR2,
220 LIKE_PhaseName IN VARCHAR2,
221 EnableImport IN VARCHAR2);
222 ------------------------------------------------------------------------------
223 PROCEDURE register_service_process(application_name IN VARCHAR2,
224 request_group IN VARCHAR2 default NULL,
225 cz_schema IN VARCHAR2 default NULL);
226 ------------------------------------------------------------------------------
227 PROCEDURE delete_service_process
228 (application_name IN VARCHAR2);
229 ------------------------------------------------------------------------------
230
231 PROCEDURE RefreshSingleModel_cp(errbuf OUT NOCOPY VARCHAR2,
232 retcode OUT NOCOPY NUMBER,
233 iFolder_ID IN NUMBER,
234 iModel_Id IN VARCHAR2,
235 COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0');
236
237 ------------------------------------------------------------------------------------------
238 PROCEDURE RemoveModel_cp(errbuf OUT NOCOPY VARCHAR2,
239 retcode OUT NOCOPY NUMBER,
240 iFolder_ID IN NUMBER,
241 iModel_Id IN VARCHAR2,
242 iImportEnabled IN VARCHAR2);
243
244 ------------------------------------------------------------------------------
245
246 PROCEDURE go_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER);
247
248 ------------------------------------------------------------------------------
249
250 PROCEDURE PopulateModels_cp
251 (errbuf OUT NOCOPY VARCHAR2,
252 retcode OUT NOCOPY NUMBER,
253 sOrg_ID IN VARCHAR2,
254 dsOrg_ID IN VARCHAR2,
255 sFrom IN VARCHAR2,
256 sTo IN VARCHAR2,
257 COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0');
258
259 ------------------------------------------------------------------------------
260 -- Bug10011026 This procedure was introduced for Sun implementation where new Concurrent Program
261 -- was introduced with same (segment1) value for sFrom and sTo parameters and cursor in original
262 -- procedure was changed to go against only cz_exv_mtl_system_items for performance improvement
263 PROCEDURE PopulateSingleModel_cp
264 (errbuf OUT NOCOPY VARCHAR2,
265 retcode OUT NOCOPY NUMBER,
266 sOrg_ID IN VARCHAR2,
267 dsOrg_ID IN VARCHAR2,
268 sFrom IN VARCHAR2,
269 sTo IN VARCHAR2,
270 COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0');
271
272 ------------------------------------------------------------------------------
273
274 -- Register Configurator BOM syncronization concurrent process --
275
276 PROCEDURE register_bom_sync_process
277 (application_name IN VARCHAR2,
278 request_group IN VARCHAR2 default NULL,
279 cz_schema IN VARCHAR2 default NULL) ;
280
281 -- remove Configurator BOM syncronization concurrent process --
282 PROCEDURE delete_bom_sync_process
283 (application_name IN VARCHAR2);
284
285 -- Check model(s)/bill(s) similarity --
286 PROCEDURE check_model_similarity_cp
287 (errbuf OUT NOCOPY VARCHAR2,
288 retcode OUT NOCOPY NUMBER,
289 p_TARGET_INSTANCE IN VARCHAR2,
290 p_FOLDER_ID IN NUMBER,
291 p_MODEL_ID IN NUMBER);
292
293 -- Check all models/bills similarity --
294 PROCEDURE check_all_models_similarity_cp
295 (errbuf OUT NOCOPY VARCHAR2,
296 retcode OUT NOCOPY NUMBER,
297 p_TARGET_INSTANCE IN VARCHAR2);
298
299 -- Synchronize all models --
300 PROCEDURE sync_all_models_cp
301 (errbuf OUT NOCOPY VARCHAR2,
302 retcode OUT NOCOPY NUMBER);
303
304 -- perform Repopulate operation
305 -- for all Populators of particular model
306 PROCEDURE Repopulate_cp
307 (errbuf OUT NOCOPY VARCHAR2,
308 retcode OUT NOCOPY NUMBER,
309 p_FOLDER_ID IN NUMBER,
310 p_MODEL_ID IN NUMBER);
311
312 -- LA 9595142 Enable/Disable Import flag
313 PROCEDURE UpdateImportFlag_cp(errbuf OUT NOCOPY VARCHAR2,
314 retcode OUT NOCOPY NUMBER,
315 iFolder_ID IN NUMBER,
316 iModel_Id IN VARCHAR2,
317 iImportEnabled IN VARCHAR2);
318
319
320 END;