[Home] [Help]
PACKAGE: APPS.AMW_CONSTRAINTS_PKG
Source
1 PACKAGE AMW_CONSTRAINTS_PKG AS
2 /* $Header: amwtcsts.pls 120.3 2005/11/28 14:48:13 appldev noship $ */
3
4 -- ===============================================================
5 -- Package name
6 -- AMW_CONSTRAINTS_PKG
7 -- Purpose
8 --
9 -- History
10 -- 11/03/2003 tsho Creates
11 -- 10/01/2004 tsho Add column: Approal_Status
12 -- 09/27/2005 tsho Add column: Control_Id
13 -- ===============================================================
14
15
16 -- ===============================================================
17 -- Procedure name
18 -- INSERT_ROW
19 -- Purpose
20 -- create new constraint
21 -- in AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
22 -- ===============================================================
23 procedure INSERT_ROW (
24 X_ROWID in out nocopy VARCHAR2,
25 X_CONSTRAINT_ID in NUMBER,
26 X_CONSTRAINT_REV_ID in NUMBER,
27 X_START_DATE in DATE,
28 X_END_DATE in DATE,
29 X_ENTERED_BY_ID in NUMBER,
30 X_TYPE_CODE in VARCHAR2,
31 X_RISK_ID in NUMBER,
32 X_LAST_UPDATED_BY in NUMBER,
33 X_LAST_UPDATE_DATE in DATE,
34 X_CREATED_BY in NUMBER,
35 X_CREATION_DATE in DATE,
36 X_LAST_UPDATE_LOGIN in NUMBER,
37 X_SECURITY_GROUP_ID in NUMBER,
38 X_OBJECT_VERSION_NUMBER in NUMBER,
39 X_ATTRIBUTE_CATEGORY in VARCHAR2,
40 X_ATTRIBUTE1 in VARCHAR2,
41 X_ATTRIBUTE2 in VARCHAR2,
42 X_ATTRIBUTE3 in VARCHAR2,
43 X_ATTRIBUTE4 in VARCHAR2,
44 X_ATTRIBUTE5 in VARCHAR2,
45 X_ATTRIBUTE6 in VARCHAR2,
46 X_ATTRIBUTE7 in VARCHAR2,
47 X_ATTRIBUTE8 in VARCHAR2,
48 X_ATTRIBUTE9 in VARCHAR2,
49 X_ATTRIBUTE10 in VARCHAR2,
50 X_ATTRIBUTE11 in VARCHAR2,
51 X_ATTRIBUTE12 in VARCHAR2,
52 X_ATTRIBUTE13 in VARCHAR2,
53 X_ATTRIBUTE14 in VARCHAR2,
54 X_ATTRIBUTE15 in VARCHAR2,
55 X_CONSTRAINT_NAME in VARCHAR2,
56 X_CONSTRAINT_DESCRIPTION in VARCHAR2,
57 X_APPROVAL_STATUS in VARCHAR2 := NULL,
58 X_CLASSIFICATION in VARCHAR2 := NULL,
59 X_OBJECTIVE_CODE in VARCHAR2 := NULL,
60 X_CONTROL_ID in NUMBER := NULL);
61
62
63
64 -- ===============================================================
65 -- Procedure name
66 -- LOCK_ROW
67 -- Purpose
68 --
69 -- ===============================================================
70 procedure LOCK_ROW (
71 X_CONSTRAINT_ID in NUMBER,
72 X_CONSTRAINT_REV_ID in NUMBER,
73 X_START_DATE in DATE,
74 X_END_DATE in DATE,
75 X_ENTERED_BY_ID in NUMBER,
76 X_TYPE_CODE in VARCHAR2,
77 X_RISK_ID in NUMBER,
78 X_SECURITY_GROUP_ID in NUMBER,
79 X_OBJECT_VERSION_NUMBER in NUMBER,
80 X_ATTRIBUTE_CATEGORY in VARCHAR2,
81 X_ATTRIBUTE1 in VARCHAR2,
82 X_ATTRIBUTE2 in VARCHAR2,
83 X_ATTRIBUTE3 in VARCHAR2,
84 X_ATTRIBUTE4 in VARCHAR2,
85 X_ATTRIBUTE5 in VARCHAR2,
86 X_ATTRIBUTE6 in VARCHAR2,
87 X_ATTRIBUTE7 in VARCHAR2,
88 X_ATTRIBUTE8 in VARCHAR2,
89 X_ATTRIBUTE9 in VARCHAR2,
90 X_ATTRIBUTE10 in VARCHAR2,
91 X_ATTRIBUTE11 in VARCHAR2,
92 X_ATTRIBUTE12 in VARCHAR2,
93 X_ATTRIBUTE13 in VARCHAR2,
94 X_ATTRIBUTE14 in VARCHAR2,
95 X_ATTRIBUTE15 in VARCHAR2,
96 X_CONSTRAINT_NAME in VARCHAR2,
97 X_CONSTRAINT_DESCRIPTION in VARCHAR2,
98 X_APPROVAL_STATUS in VARCHAR2 := NULL,
99 X_CLASSIFICATION in VARCHAR2 := NULL,
100 X_OBJECTIVE_CODE in VARCHAR2 := NULL,
101 X_CONTROL_ID in NUMBER := NULL);
102
103
104
105 -- ===============================================================
106 -- Procedure name
107 -- UPDATE_ROW
108 -- Purpose
109 -- update AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
110 -- ===============================================================
111 procedure UPDATE_ROW (
112 X_CONSTRAINT_ID in NUMBER,
113 X_CONSTRAINT_REV_ID in NUMBER,
114 X_START_DATE in DATE,
115 X_END_DATE in DATE,
116 X_ENTERED_BY_ID in NUMBER,
117 X_TYPE_CODE in VARCHAR2,
118 X_RISK_ID in NUMBER,
119 X_LAST_UPDATED_BY in NUMBER,
120 X_LAST_UPDATE_DATE in DATE,
121 X_LAST_UPDATE_LOGIN in NUMBER,
122 X_SECURITY_GROUP_ID in NUMBER,
123 X_OBJECT_VERSION_NUMBER in NUMBER,
124 X_ATTRIBUTE_CATEGORY in VARCHAR2,
125 X_ATTRIBUTE1 in VARCHAR2,
126 X_ATTRIBUTE2 in VARCHAR2,
127 X_ATTRIBUTE3 in VARCHAR2,
128 X_ATTRIBUTE4 in VARCHAR2,
129 X_ATTRIBUTE5 in VARCHAR2,
130 X_ATTRIBUTE6 in VARCHAR2,
131 X_ATTRIBUTE7 in VARCHAR2,
132 X_ATTRIBUTE8 in VARCHAR2,
133 X_ATTRIBUTE9 in VARCHAR2,
134 X_ATTRIBUTE10 in VARCHAR2,
135 X_ATTRIBUTE11 in VARCHAR2,
136 X_ATTRIBUTE12 in VARCHAR2,
137 X_ATTRIBUTE13 in VARCHAR2,
138 X_ATTRIBUTE14 in VARCHAR2,
139 X_ATTRIBUTE15 in VARCHAR2,
140 X_CONSTRAINT_NAME in VARCHAR2,
141 X_CONSTRAINT_DESCRIPTION in VARCHAR2,
142 X_APPROVAL_STATUS in VARCHAR2 := NULL,
143 X_CLASSIFICATION in VARCHAR2 := NULL,
144 X_OBJECTIVE_CODE in VARCHAR2 := NULL,
145 X_CONTROL_ID in NUMBER := NULL);
146
147
148 -- ===============================================================
149 -- Procedure name
150 -- DELETE_ROW
151 -- Purpose
152 --
153 -- ===============================================================
154 procedure DELETE_ROW (
155 X_CONSTRAINT_ID in NUMBER);
156
157
158
159 -- ===============================================================
160 -- Procedure name
161 -- ADD_LANGUAGE
162 -- Purpose
163 --
164 -- ===============================================================
165 procedure ADD_LANGUAGE;
166
167 -- ----------------------------------------------------------------------
168 end AMW_CONSTRAINTS_PKG;