1 PACKAGE ota_data_upgrader_util AUTHID CURRENT_USER AS
2 /* $Header: otdatupg.pkh 120.1 2005/08/01 00:56:56 jbharath 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 ,p_upgrade_id varchar2
48 ,p_use_rowid varchar2);
49
50 procedure submitUpgradeProcessControl(
51 errbuf out nocopy varchar2,
52 retcode out nocopy number,
53 p_process_to_call in varchar2,
54 p_upgrade_type in varchar2,
55 p_action_parameter_group_id in varchar2,
56 p_process_ctrl in varchar2,
57 p_param1 in varchar2,
58 p_param2 in varchar2,
59 p_param3 in varchar2,
60 p_param4 in varchar2,
61 p_param5 in varchar2,
62 p_param6 in varchar2,
63 p_param7 in varchar2,
64 p_param8 in varchar2,
65 p_param9 in varchar2,
66 p_param10 in varchar2
67 );
68
69 procedure submitUpgradeProcessSingle(
70 errbuf out nocopy varchar2,
71 retcode out nocopy number,
72 p_process_number in varchar2,
73 p_max_number_proc in varchar2,
74 p_process_to_call in varchar2,
75 p_upgrade_type in varchar2,
76 p_process_ctrl in varchar2,
77 p_param1 in varchar2,
78 p_param2 in varchar2,
79 p_param3 in varchar2,
80 p_param4 in varchar2,
81 p_param5 in varchar2,
82 p_param6 in varchar2,
83 p_param7 in varchar2,
84 p_param8 in varchar2,
85 p_param9 in varchar2,
86 p_param10 in varchar2
87 );
88
89 Function getLoggingState return varchar2;
90
91 Procedure writeLog(p_text in VARCHAR2
92 ,p_logging_type in VARCHAR2 default null
93 ,p_error in BOOLEAN default FALSE
94 ,p_location in NUMBER default 0) ;
95
96 end ota_data_upgrader_util;