1 PACKAGE PAY_UPGRADE_DEFINITIONS_PKG AS
2 /* $Header: pypud01t.pkh 120.1 2005/06/16 03:21 nmanchan noship $ */
3
4 PROCEDURE Insert_Row (
5 P_SHORT_NAME in VARCHAR2
6 ,P_NAME in VARCHAR2
7 ,P_DESCRIPTION in VARCHAR2
8 ,P_LEGISLATION_CODE in VARCHAR2 default null
9 ,P_UPGRADE_LEVEL in VARCHAR2
10 ,P_CRITICALITY in VARCHAR2
11 ,P_FAILURE_POINT in VARCHAR2
12 ,P_LEGISLATIVELY_ENABLED in VARCHAR2
13 ,P_UPGRADE_PROCEDURE in VARCHAR2
14 ,P_THREADING_LEVEL in VARCHAR2
15 ,P_UPGRADE_METHOD in VARCHAR2
16 ,P_QUALIFYING_PROCEDURE in VARCHAR2 default null
17 ,P_OWNER_APPL_ID in NUMBER default null
18 ,P_FIRST_PATCHSET in VARCHAR2 default null
19 ,P_VALIDATE_CODE in VARCHAR2 default null
20 ,P_ADDITIONAL_INFO in VARCHAR2 default null
21 ,P_LAST_UPDATE_DATE in DATE
22 ,P_LAST_UPDATED_BY in NUMBER
23 ,P_LAST_UPDATE_LOGIN in NUMBER
24 ,P_CREATED_BY in NUMBER
25 ,P_CREATION_DATE in DATE
26 ,P_UPGRADE_DEFINITION_ID out nocopy NUMBER
27 );
28
29 PROCEDURE UPDATE_ROW (
30 P_UPGRADE_DEFINITION_ID in NUMBER
31 , P_CRITICALITY in VARCHAR2
32 , P_FAILURE_POINT in VARCHAR2
33 , P_UPGRADE_PROCEDURE in VARCHAR2
34 , P_DESCRIPTION in VARCHAR2
35 , P_QUALIFYING_PROCEDURE in VARCHAR2
36 , P_OWNER_APPL_ID in NUMBER
37 , P_FIRST_PATCHSET in VARCHAR2
38 , P_VALIDATE_CODE in VARCHAR2
39 , P_ADDITIONAL_INFO in VARCHAR2
40 , P_LAST_UPDATE_DATE in DATE
41 , P_LAST_UPDATED_BY in NUMBER
42 , P_LAST_UPDATE_LOGIN in NUMBER
43 );
44
45 PROCEDURE LOCK_ROW (
46 P_UPGRADE_DEFINITION_ID in NUMBER
47 , P_SHORT_NAME in VARCHAR2
48 , P_NAME in VARCHAR2
49 , P_LEGISLATION_CODE in VARCHAR2
50 , P_UPGRADE_LEVEL in VARCHAR2
51 , P_CRITICALITY in VARCHAR2
52 , P_FAILURE_POINT in VARCHAR2
53 , P_LEGISLATIVELY_ENABLED in VARCHAR2
54 , P_UPGRADE_PROCEDURE in VARCHAR2
55 , P_THREADING_LEVEL in VARCHAR2
56 , P_DESCRIPTION in VARCHAR2
57 , P_UPGRADE_METHOD in VARCHAR2
58 , P_QUALIFYING_PROCEDURE in VARCHAR2
59 );
60
61 PROCEDURE DELETE_ROW (
62 P_UPGRADE_DEFINITION_ID in NUMBER
63 );
64
65 PROCEDURE ADD_LANGUAGE;
66
67 PROCEDURE LOAD_ROW (
68 P_SHORT_NAME in VARCHAR2
69 , P_NAME in VARCHAR2
70 , P_DESCRIPTION in VARCHAR2
71 , P_LEGISLATION_CODE in VARCHAR2
72 , P_UPGRADE_LEVEL in VARCHAR2
73 , P_CRITICALITY in VARCHAR2
74 , P_THREADING_LEVEL in VARCHAR2
75 , P_FAILURE_POINT in VARCHAR2
76 , P_LEGISLATIVELY_ENABLED in VARCHAR2
77 , P_UPGRADE_PROCEDURE in VARCHAR2
78 , P_UPGRADE_METHOD in VARCHAR2
79 , P_QUALIFYING_PROCEDURE in VARCHAR2
80 , P_OWNER_APPL_SHORT_NAME in VARCHAR2
81 , P_FIRST_PATCHSET in VARCHAR2
82 , P_VALIDATE_CODE in VARCHAR2
83 , P_ADDITIONAL_INFO in VARCHAR2
84 , P_OWNER in VARCHAR2
85 );
86
87 PROCEDURE TRANSLATE_ROW (
88 P_SHORT_NAME in VARCHAR2
89 , P_NAME in VARCHAR2
90 , P_DESCRIPTION in VARCHAR2
91 , P_ADDITIONAL_INFO in varchar2
92 , P_OWNER in VARCHAR2
93 );
94
95
96 END PAY_UPGRADE_DEFINITIONS_PKG;
97