1 package WF_CLONE AUTHID CURRENT_USER as
2 /*$Header: wfclones.pls 120.2 2005/10/04 05:36:45 rtodi noship $*/
3 --This API updates attribute values which refernce the source
4 --system to target references.
5
6 procedure UpdateAttrValues(WEB_HOST in varchar2,
7 DOMAIN in varchar2,
8 WEB_PORT in varchar2,
9 SID in varchar2,
10 URL_PROTO in varchar2 default NULL);
11
12
13 --This API updates the system_guid and related tables
14
15 procedure UpdateSysGuid;
16
17 --This API updates the mailer parameters
18
19 procedure UpdateMailer(WEB_HOST in varchar2,
20 DOMAIN in varchar2,
21 WEB_PORT in varchar2,
22 SID in varchar2,
23 URL_PROTO in varchar2 default NULL);
24
25
26 --This API updates WF_SYSTEM_GUID token in wf_resources with
27 --the new system guid.
28 procedure UpdateResource(WEB_HOST in varchar2,
29 DOMAIN in varchar2,
30 WEB_PORT in varchar2,
31 SID in varchar2,
32 URL_PROTO in varchar2 default NULL);
33
34
35 --This API detemines whether its a clone run or install/
36 --upgrade/rerun.
37 --Incase of install/upgrade/rerun we return false so that
38 --clone APIs are not called.
39
40 Function DetermineClone(WEB_HOST in varchar2,
41 DOMAIN in varchar2,
42 WEB_PORT in varchar2,
43 SID in varchar2 ,
44 URL_PROTO in varchar2 default NULL)
45
46 return boolean;
47
48 --Procedure Clone
49 --This API calls all the cloning related APIs
50 --This will be invoked by the concurrent program
51 Procedure WFClone(P_WEB_HOST in varchar2,
52 P_DOMAIN in varchar2,
53 P_WEB_PORT in varchar2,
54 P_SID in varchar2,
55 P_URL_PROTO in varchar2 default NULL);
56
57
58 procedure purgedata;
59
60 --Keep the default of raise_error as FALSE as
61 --autoconfig cannot throw errors but still we can
62 --potentially record it in standalone
63
64 PROCEDURE TruncateTable (TableName IN VARCHAR2,
65 Owner IN VARCHAR2,
66 raise_error IN BOOLEAN default FALSE );
67
68 --Truncate Queue Table
69 PROCEDURE QTableTruncate(QName IN VARCHAR2,
70 raise_error IN BOOLEAN default FALSE );
71
72 PROCEDURE QDequeue(QName IN VARCHAR2,
73 owner in VARCHAR2,
74 AgtName IN VARCHAR2 default null,
75 raise_error IN BOOLEAN default FALSE );
76 --Concurrent Programs
77 --#1. CLONE - Where u do a complete source_data migration
78 -- over to target system updating all transactional
79 -- data also to be compatiable.
80 PROCEDURE CLONE(errbuf out NOCOPY varchar2,
81 retcode out NOCOPY varchar2,
82 P_WEB_HOST in varchar2,
83 P_DOMAIN in varchar2,
84 P_WEB_PORT in varchar2,
85 P_SID in varchar2 ,
86 P_URL_PROTO in varchar2 default NULL);
87
88
89 --#2. PURGE - Where u do a complete purge of transaction/
90 -- runtime data.
91 PROCEDURE PURGE(errbuf out NOCOPY varchar2,
92 retcode out NOCOPY varchar2);
93
94
95 end wf_clone;
96