[Home] [Help]
PACKAGE: APPS.GMD_QC_MIG12
Source
1 PACKAGE GMD_QC_MIG12 AUTHID CURRENT_USER AS
2 /* $Header: gmdmg12s.pls 120.1.12020000.2 2013/01/11 07:25:20 maychen ship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | gmdmg12s.pls |
10 | |
11 | PACKAGE NAME |
12 | GMD_QC_MIG12 |
13 | |
14 | DESCRIPTION |
15 | This package migration procedures for Quality for 12 migration. |
16 | |
17 | |
18 | 01/04/2013, Bug 14198664 - performance issues |
19 | changed GMD_QC_MIGRATE_SAMPLES, add p_start_rowid and p_end_rowid |
20 | Add new procedure GMD_QC_MIGRATE_RESULTS |
21 | HISTORY |
22 +==========================================================================+
23 */
24
25 /*=================================
26 Database Log Counters
27 =================================*/
28
29 g_progress_ind NUMBER;
30
31 g_test_method_upd_count NUMBER;
32 g_test_method_err_count NUMBER;
33 g_test_method_pro_count NUMBER;
34 g_quality_config_ins_count NUMBER;
35 g_quality_config_upd_count NUMBER;
36 g_quality_config_err_count NUMBER;
37 g_quality_config_pro_count NUMBER;
38 g_sampling_plan_pro_count NUMBER;
39 g_sampling_plan_upd_count NUMBER;
40 g_sampling_plan_err_count NUMBER;
41 g_sample_upd_count NUMBER;
42 g_sample_err_count NUMBER;
43 g_sample_pro_count NUMBER;
44 g_result_upd_count NUMBER;
45 g_result_err_count NUMBER;
46 g_result_pro_count NUMBER;
47 g_sample_event_upd_count NUMBER;
48 g_sample_event_err_count NUMBER;
49 g_sample_event_pro_count NUMBER;
50 g_store_plan_upd_count NUMBER;
51 g_store_plan_err_count NUMBER;
52 g_store_plan_pro_count NUMBER;
53 g_store_pack_pro_count NUMBER;
54 g_store_pack_upd_count NUMBER;
55 g_store_pack_err_count NUMBER;
56 g_store_pack_ins_count NUMBER;
57 g_stab_pro_count NUMBER;
58 g_stab_upd_count NUMBER;
59 g_stab_err_count NUMBER;
60 g_matl_source_pro_count NUMBER;
61 g_matl_source_upd_count NUMBER;
62 g_matl_source_err_count NUMBER;
63 g_ss_variant_pro_count NUMBER;
64 g_ss_variant_upd_count NUMBER;
65 g_ss_variant_err_count NUMBER;
66 g_ss_storehist_pro_count NUMBER;
67 g_ss_storehist_upd_count NUMBER;
68 g_ss_storehist_err_count NUMBER;
69 g_inv_spec_pro_count NUMBER;
70 g_inv_spec_ins_count NUMBER;
71 g_inv_spec_del_count NUMBER;
72 g_inv_spec_upd_count NUMBER;
73 g_inv_spec_err_count NUMBER;
74 g_specs_pro_count NUMBER;
75 g_specs_upd_count NUMBER;
76 g_specs_err_count NUMBER;
77 g_wip_spec_pro_count NUMBER;
78 g_wip_spec_ins_count NUMBER;
79 g_wip_spec_del_count NUMBER;
80 g_wip_spec_upd_count NUMBER;
81 g_wip_spec_err_count NUMBER;
82 g_cust_spec_pro_count NUMBER;
83 g_cust_spec_ins_count NUMBER;
84 g_cust_spec_del_count NUMBER;
85 g_cust_spec_upd_count NUMBER;
86 g_cust_spec_err_count NUMBER;
87 g_supl_spec_pro_count NUMBER;
88 g_supl_spec_ins_count NUMBER;
89 g_supl_spec_upd_count NUMBER;
90 g_supl_spec_del_count NUMBER;
91 g_supl_spec_err_count NUMBER;
92 g_mon_spec_pro_count NUMBER;
93 g_mon_spec_ins_count NUMBER;
94 g_mon_spec_del_count NUMBER;
95 g_mon_spec_upd_count NUMBER;
96 g_mon_spec_err_count NUMBER;
97
98 PROCEDURE GMD_QC_MIGRATE_SETUP
99 ( p_migration_run_id IN NUMBER
100 , p_commit IN VARCHAR2
101 , x_exception_count OUT NOCOPY NUMBER
102 );
103
104 PROCEDURE GMD_QC_MIGRATE_SAMPLES
105 ( p_migration_run_id IN NUMBER
106 , p_commit IN VARCHAR2
107 , p_start_rowid IN ROWID
108 , p_end_rowid IN ROWID
109 , x_exception_count OUT NOCOPY NUMBER
110 );
111
112 PROCEDURE GMD_QC_MIGRATE_RESULTS
113 ( p_migration_run_id IN NUMBER
114 , p_commit IN VARCHAR2
115 , p_start_rowid IN ROWID
116 , p_end_rowid IN ROWID
117 , x_exception_count OUT NOCOPY NUMBER
118 );
119
120 PROCEDURE GMD_QC_MIGRATE_SPECS
121 ( p_migration_run_id IN NUMBER
122 , p_commit IN VARCHAR2
123 , x_exception_count OUT NOCOPY NUMBER
124 );
125
126 PROCEDURE GMD_QC_MIGRATE_STABS
127 ( p_migration_run_id IN NUMBER
128 , p_commit IN VARCHAR2
129 , x_exception_count OUT NOCOPY NUMBER
130 );
131
132
133 END GMD_QC_MIG12;