1 package ITA_SETUP_PARAMETER_MIG_PKG as
2 /* $Header: itatmigs.pls 120.0 2005/09/06 16:12 cpetriuc noship $ */
3
4
5 procedure INSERT_ROW (
6 X_MIGRATION_ID in NUMBER,
7 X_OLD_PARAMETER_CODE in VARCHAR2,
8 X_NEW_PARAMETER_CODE in VARCHAR2,
9 X_START_DATE in DATE,
10 X_END_DATE in DATE,
11 X_SECURITY_GROUP_ID in NUMBER,
12 X_OBJECT_VERSION_NUMBER in NUMBER,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER
18 );
19
20
21 procedure LOCK_ROW (
22 X_MIGRATION_ID in NUMBER,
23 X_OLD_PARAMETER_CODE in VARCHAR2,
24 X_NEW_PARAMETER_CODE in VARCHAR2,
25 X_START_DATE in DATE,
26 X_END_DATE in DATE,
27 X_SECURITY_GROUP_ID in NUMBER,
28 X_OBJECT_VERSION_NUMBER in NUMBER
29 );
30
31
32 procedure UPDATE_ROW (
33 X_MIGRATION_ID in NUMBER,
34 X_OLD_PARAMETER_CODE in VARCHAR2,
35 X_NEW_PARAMETER_CODE in VARCHAR2,
36 X_START_DATE in DATE,
37 X_END_DATE in DATE,
38 X_SECURITY_GROUP_ID in NUMBER,
39 X_OBJECT_VERSION_NUMBER in NUMBER,
40 X_LAST_UPDATE_DATE in DATE,
41 X_LAST_UPDATED_BY in NUMBER,
42 X_LAST_UPDATE_LOGIN in NUMBER
43 );
44
45
46 procedure DELETE_ROW (
47 X_MIGRATION_ID in NUMBER
48 );
49
50
51 procedure LOAD_ROW (
52 X_MIGRATION_ID in NUMBER,
53 X_OLD_PARAMETER_CODE in VARCHAR2,
54 X_NEW_PARAMETER_CODE in VARCHAR2,
55 X_START_DATE in DATE,
56 X_END_DATE in DATE,
57 X_LAST_UPDATE_DATE in VARCHAR2,
58 X_OWNER in VARCHAR2,
59 X_CUSTOM_MODE in VARCHAR2
60 );
61
62
63 end ITA_SETUP_PARAMETER_MIG_PKG;