[Home] [Help]
PACKAGE: APPS.GMD_QC_MIG12
Source
1 PACKAGE GMD_QC_MIG12 AS
2 /* $Header: gmdmg12s.pls 120.1 2005/08/04 11:59:56 jdiiorio noship $
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 | HISTORY |
19 +==========================================================================+
20 */
21
22 /*=================================
23 Database Log Counters
24 =================================*/
25
26 g_progress_ind NUMBER;
27
28 g_test_method_upd_count NUMBER;
29 g_test_method_err_count NUMBER;
30 g_test_method_pro_count NUMBER;
31 g_quality_config_ins_count NUMBER;
32 g_quality_config_upd_count NUMBER;
33 g_quality_config_err_count NUMBER;
34 g_quality_config_pro_count NUMBER;
35 g_sampling_plan_pro_count NUMBER;
36 g_sampling_plan_upd_count NUMBER;
37 g_sampling_plan_err_count NUMBER;
38 g_sample_upd_count NUMBER;
39 g_sample_err_count NUMBER;
40 g_sample_pro_count NUMBER;
41 g_result_upd_count NUMBER;
42 g_result_err_count NUMBER;
43 g_result_pro_count NUMBER;
44 g_sample_event_upd_count NUMBER;
45 g_sample_event_err_count NUMBER;
46 g_sample_event_pro_count NUMBER;
47 g_store_plan_upd_count NUMBER;
48 g_store_plan_err_count NUMBER;
49 g_store_plan_pro_count NUMBER;
50 g_store_pack_pro_count NUMBER;
51 g_store_pack_upd_count NUMBER;
52 g_store_pack_err_count NUMBER;
53 g_store_pack_ins_count NUMBER;
54 g_stab_pro_count NUMBER;
55 g_stab_upd_count NUMBER;
56 g_stab_err_count NUMBER;
57 g_matl_source_pro_count NUMBER;
58 g_matl_source_upd_count NUMBER;
59 g_matl_source_err_count NUMBER;
60 g_ss_variant_pro_count NUMBER;
61 g_ss_variant_upd_count NUMBER;
62 g_ss_variant_err_count NUMBER;
63 g_ss_storehist_pro_count NUMBER;
64 g_ss_storehist_upd_count NUMBER;
65 g_ss_storehist_err_count NUMBER;
66 g_inv_spec_pro_count NUMBER;
67 g_inv_spec_ins_count NUMBER;
68 g_inv_spec_del_count NUMBER;
69 g_inv_spec_upd_count NUMBER;
70 g_inv_spec_err_count NUMBER;
71 g_specs_pro_count NUMBER;
72 g_specs_upd_count NUMBER;
73 g_specs_err_count NUMBER;
74 g_wip_spec_pro_count NUMBER;
75 g_wip_spec_ins_count NUMBER;
76 g_wip_spec_del_count NUMBER;
77 g_wip_spec_upd_count NUMBER;
78 g_wip_spec_err_count NUMBER;
79 g_cust_spec_pro_count NUMBER;
80 g_cust_spec_ins_count NUMBER;
81 g_cust_spec_del_count NUMBER;
82 g_cust_spec_upd_count NUMBER;
83 g_cust_spec_err_count NUMBER;
84 g_supl_spec_pro_count NUMBER;
85 g_supl_spec_ins_count NUMBER;
86 g_supl_spec_upd_count NUMBER;
87 g_supl_spec_del_count NUMBER;
88 g_supl_spec_err_count NUMBER;
89 g_mon_spec_pro_count NUMBER;
90 g_mon_spec_ins_count NUMBER;
91 g_mon_spec_del_count NUMBER;
92 g_mon_spec_upd_count NUMBER;
93 g_mon_spec_err_count NUMBER;
94
95 PROCEDURE GMD_QC_MIGRATE_SETUP
96 ( p_migration_run_id IN NUMBER
97 , p_commit IN VARCHAR2
98 , x_exception_count OUT NOCOPY NUMBER
99 );
100
101 PROCEDURE GMD_QC_MIGRATE_SAMPLES
102 ( p_migration_run_id IN NUMBER
103 , p_commit IN VARCHAR2
104 , x_exception_count OUT NOCOPY NUMBER
105 );
106
107 PROCEDURE GMD_QC_MIGRATE_SPECS
108 ( p_migration_run_id IN NUMBER
109 , p_commit IN VARCHAR2
110 , x_exception_count OUT NOCOPY NUMBER
111 );
112
113 PROCEDURE GMD_QC_MIGRATE_STABS
114 ( p_migration_run_id IN NUMBER
115 , p_commit IN VARCHAR2
116 , x_exception_count OUT NOCOPY NUMBER
117 );
118
119
120 END GMD_QC_MIG12;