[Home] [Help]
PACKAGE: APPS.JTF_DIAGNOSTIC_MIGRATE
Source
1 PACKAGE JTF_DIAGNOSTIC_MIGRATE AUTHID CURRENT_USER AS
2 /* $Header: jtfdiagmigrate_s.pls 115.0 2002/07/12 23:50:02 skhemani noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Insert a place holder migration date if none exists in the
6 -- jtf_diagnostic_prereq table
7 ---------------------------------------------------------------------------
8
9 procedure INSERT_PLACEHOLDER_DATE;
10
11 ---------------------------------------------------------------------------
12 -- Update the migration date in the
13 -- jtf_diagnostic_prereq table
14 ---------------------------------------------------------------------------
15
16 procedure UPDATE_MIGRATION_DATE;
17
18 ---------------------------------------------------------------------------
19 -- lock the migration date so that no other thread
20 -- can update the date or waits or throws an exception at
21 -- the time data is being migrated
22 ---------------------------------------------------------------------------
23
24 procedure LOCK_MIGRATION_DATE;
25
26 ---------------------------------------------------------------------------
27 --
28 ---------------------------------------------------------------------------
29
30 procedure MIGRATE_DB_DIAGNOSTIC_DATA;
31
32 ---------------------------------------------------------------------------
33 --
34 ---------------------------------------------------------------------------
35
36 procedure MIGRATE_APPS;
37
38 ---------------------------------------------------------------------------
39 --
40 ---------------------------------------------------------------------------
41
42 PROCEDURE MIGRATE_APP_PREREQS(P_ASN IN VARCHAR2, P_APP_ID IN NUMBER);
43
44 ---------------------------------------------------------------------------
45 --
46 ---------------------------------------------------------------------------
47
48 PROCEDURE MIGRATE_APP_GROUPS(P_ASN IN VARCHAR2, P_APP_ID IN NUMBER);
49
50
51 ---------------------------------------------------------------------------
52 --
53 ---------------------------------------------------------------------------
54
55 PROCEDURE MIGRATE_APP_GROUPS(
56 P_ASN IN VARCHAR2,
57 P_APP_ID IN NUMBER,
58 P_GRPCOUNT IN NUMBER);
59
60
61 ---------------------------------------------------------------------------
62 --
63 ---------------------------------------------------------------------------
64
65 PROCEDURE MIGRATE_GROUP_PREREQS(
66 P_ASN IN VARCHAR2,
67 P_GRPNAME IN VARCHAR2,
68 P_APP_ID IN NUMBER);
69
70
71 ---------------------------------------------------------------------------
72 --
73 ---------------------------------------------------------------------------
74
75 PROCEDURE MIGRATE_GROUP_TESTS(
76 P_ASN IN VARCHAR2,
77 P_GRPNAME IN VARCHAR2,
78 P_APP_ID IN NUMBER,
79 p_testnum in number);
80
81
82 ---------------------------------------------------------------------------
83 --
84 ---------------------------------------------------------------------------
85
86 procedure migrate_test_arguments(
87 p_asn in varchar2,
88 p_grpname in varchar2,
89 p_app_id in number,
90 p_classname in varchar2);
91
92 ---------------------------------------------------------------------------
93 --
94 ---------------------------------------------------------------------------
95
96 procedure migrate_test_arg_row(
97 v_argument_names IN JTF_VARCHAR2_TABLE_4000,
98 p_asn in varchar2,
99 p_grpname in varchar2,
100 p_classname in varchar2,
101 p_app_id in number,
102 p_rownum in varchar2);
103
104
105
106
107 END JTF_DIAGNOSTIC_MIGRATE;
108