1 PACKAGE per_data_upgrader_util AUTHID CURRENT_USER AS
2 /* $Header: pedatupgutl.pkh 115.3 2003/04/23 14:34:04 adhunter noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< upgrade_chunk >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 --
9 -- Description:
10 -- This procedure migrates data using the AD large table update utilities
11 -- it process data for a single thread in a multi-threaded upgrade job.
12 --
13 -- It is a generic routine which accepts a named procedure to call. This
14 -- procedure accepts a standard set of parameters and actually performs the
15 -- data upgrade. It passes out the number of rows processed.
16 --
17 -- Prerequisites
18 --
19 -- Parameters:
20 -- Name Reqd Type Description
21 -- p_this_worker_num Y Number The number of this worker
22 -- thread.
23 -- p_total_num_workers Y Number The total number of workers
24 -- performing this upgrade.
25 -- p_process_ctrl Y Varchar2 String encoding special control
26 -- actions on a per process basis.
27 -- p_table_owner Y Varchar2 The name of the schema owning
28 -- the table to be upgraded.
29 -- p_table_name Y Varchar2 The name of the table to be
30 -- upgraded.
31 -- p_pkid_column Y Varchar2 The name of the PK id column
32 -- p_update_name Y Varchar2 The name of the update process.
33 -- p_batch_size Y Number The batch commit size.
34 -- p_upg_proc Y Varchar2 The procedure to call which
35 -- actually performs the data
36 -- upgrade.
37 procedure upgradeChunk
38 (p_this_worker_num number
39 ,p_total_num_workers number
40 ,p_process_ctrl varchar2
41 ,p_table_owner varchar2
42 ,p_table_name varchar2
43 ,p_pkid_column varchar2
44 ,p_update_name varchar2
45 ,p_batch_size number
46 ,p_upg_proc varchar2);
47
48 procedure submitUpgradeProcessControl(
49 errbuf out nocopy varchar2,
50 retcode out nocopy number,
51 p_process_to_call in varchar2,
52 p_upgrade_type in varchar2,
53 p_action_parameter_group_id in varchar2,
54 p_process_ctrl in varchar2,
55 p_param1 in varchar2,
56 p_param2 in varchar2,
57 p_param3 in varchar2,
58 p_param4 in varchar2,
59 p_param5 in varchar2,
60 p_param6 in varchar2,
61 p_param7 in varchar2,
62 p_param8 in varchar2,
63 p_param9 in varchar2,
64 p_param10 in varchar2
65 );
66
67 procedure submitUpgradeProcessSingle(
68 errbuf out nocopy varchar2,
69 retcode out nocopy number,
70 p_process_number in varchar2,
71 p_max_number_proc in varchar2,
72 p_process_to_call in varchar2,
73 p_upgrade_type in varchar2,
74 p_process_ctrl in varchar2,
75 p_param1 in varchar2,
76 p_param2 in varchar2,
77 p_param3 in varchar2,
78 p_param4 in varchar2,
79 p_param5 in varchar2,
80 p_param6 in varchar2,
81 p_param7 in varchar2,
82 p_param8 in varchar2,
83 p_param9 in varchar2,
84 p_param10 in varchar2
85 );
86
87 Function getLoggingState return varchar2;
88
89 Procedure writeLog(p_text in VARCHAR2
90 ,p_logging_type in VARCHAR2 default null
91 ,p_error in BOOLEAN default FALSE
92 ,p_location in NUMBER default 0) ;
93
94 end per_data_upgrader_util;