[Home] [Help]
PACKAGE: APPS.IGS_PE_PERSID_GROUP_PKG
Source
1 package IGS_PE_PERSID_GROUP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSNI24S.pls 115.8 2003/06/09 20:04:24 jzyli ship $ */
3
4 -------------------------------------------------------------------------------------------
5 --Change History:
6 -- Bug ID : 2203134
7 -- who when what
8 -- kpadiyar Mar 14,2002 Added check_uniqueness for the group_cd column.
9
10 -------------------------------------------------------------------------------------------
11 -------------------------------------------------------------------------------------------
12 --Change History:
13 -- Bug ID : 2000408
14 -- who when what
15 -- CDCRUZ Sep 24,2002 New Flex Fld Col's added for
16 -- Person DLD
17
18 -------------------------------------------------------------------------------------------
19
20 procedure INSERT_ROW (
21 X_ROWID in out NOCOPY VARCHAR2,
22 X_GROUP_ID in NUMBER,
23 X_GROUP_CD in VARCHAR2,
24 X_CREATOR_PERSON_ID in NUMBER,
25 X_DESCRIPTION in VARCHAR2,
26 X_CREATE_DT in DATE,
27 X_CLOSED_IND in VARCHAR2,
28 X_COMMENTS in VARCHAR2,
29 X_FILE_NAME in VARCHAR2 DEFAULT NULL,
30 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
31 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
32 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
33 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
34 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
35 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
36 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
37 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
38 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
39 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
40 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
41 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
42 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
43 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
44 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
45 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
46 X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
47 X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
48 X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
49 X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
50 X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
51 X_ORG_ID in NUMBER,
52 X_MODE in VARCHAR2 default 'R'
53 );
54 procedure LOCK_ROW (
55 X_ROWID in VARCHAR2,
56 X_GROUP_ID in NUMBER,
57 X_GROUP_CD in VARCHAR2,
58 X_CREATOR_PERSON_ID in NUMBER,
59 X_DESCRIPTION in VARCHAR2,
60 X_CREATE_DT in DATE,
61 X_CLOSED_IND in VARCHAR2,
62 X_COMMENTS in VARCHAR2,
63 X_FILE_NAME in VARCHAR2 DEFAULT NULL,
64 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
65 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
66 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
67 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
68 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
69 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
70 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
71 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
72 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
73 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
74 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
75 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
76 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
77 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
78 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
79 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
80 X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
81 X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
82 X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
83 X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
84 X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL
85 );
86 procedure UPDATE_ROW (
87 X_ROWID in VARCHAR2,
88 X_GROUP_ID in NUMBER,
89 X_GROUP_CD in VARCHAR2,
90 X_CREATOR_PERSON_ID in NUMBER,
91 X_DESCRIPTION in VARCHAR2,
92 X_CREATE_DT in DATE,
93 X_CLOSED_IND in VARCHAR2,
94 X_COMMENTS in VARCHAR2,
95 X_FILE_NAME in VARCHAR2 DEFAULT NULL,
96 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
97 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
98 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
99 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
100 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
101 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
102 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
103 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
104 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
105 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
106 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
107 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
108 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
109 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
110 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
111 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
112 X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
113 X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
114 X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
115 X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
116 X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
117 X_MODE in VARCHAR2 default 'R'
118 );
119 procedure ADD_ROW (
120 X_ROWID in out NOCOPY VARCHAR2,
121 X_GROUP_ID in NUMBER,
122 X_GROUP_CD in VARCHAR2,
123 X_CREATOR_PERSON_ID in NUMBER,
124 X_DESCRIPTION in VARCHAR2,
125 X_CREATE_DT in DATE,
126 X_CLOSED_IND in VARCHAR2,
127 X_COMMENTS in VARCHAR2,
128 X_ORG_ID in NUMBER,
129 X_FILE_NAME in VARCHAR2 DEFAULT NULL,
130 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
131 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
132 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
133 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
134 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
135 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
136 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
137 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
138 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
139 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
140 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
141 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
142 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
143 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
144 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
145 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
146 X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
147 X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
148 X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
149 X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
150 X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
151 X_MODE in VARCHAR2 default 'R'
152 );
153
154 FUNCTION Get_PK_For_Validation (
155 x_group_id IN NUMBER
156 ) RETURN BOOLEAN;
157
158 FUNCTION get_uk_for_validation(
159 X_GROUP_CD IN VARCHAR2
160 ) RETURN BOOLEAN;
161
162 FUNCTION val_persid_group(p_group_id IN NUMBER ,
163 p_message_name OUT NOCOPY VARCHAR2
164 )RETURN BOOLEAN ;
165
166 PROCEDURE GET_FK_IGS_PE_PERSON (
167 x_person_id IN NUMBER
168 );
169 PROCEDURE Check_Constraints (
170 Column_Name IN VARCHAR2 DEFAULT NULL,
171 Column_Value IN VARCHAR2 DEFAULT NULL
172 );
173 PROCEDURE Before_DML (
174
175 p_action IN VARCHAR2,
176
177 x_rowid IN VARCHAR2 DEFAULT NULL,
178
179 x_group_id IN NUMBER DEFAULT NULL,
180
181 x_group_cd IN VARCHAR2 DEFAULT NULL,
182
183 x_creator_person_id IN NUMBER DEFAULT NULL,
184
185 x_description IN VARCHAR2 DEFAULT NULL,
186
187 x_create_dt IN DATE DEFAULT NULL,
188
189 x_closed_ind IN VARCHAR2 DEFAULT NULL,
190
191 x_comments IN VARCHAR2 DEFAULT NULL,
192
193 x_file_name IN VARCHAR2 DEFAULT NULL,
194 x_attribute_category IN VARCHAR2 DEFAULT NULL,
195 x_attribute1 IN VARCHAR2 DEFAULT NULL,
196 x_attribute2 IN VARCHAR2 DEFAULT NULL,
197 x_attribute3 IN VARCHAR2 DEFAULT NULL,
198 x_attribute4 IN VARCHAR2 DEFAULT NULL,
199 x_attribute5 IN VARCHAR2 DEFAULT NULL,
200 x_attribute6 IN VARCHAR2 DEFAULT NULL,
201 x_attribute7 IN VARCHAR2 DEFAULT NULL,
202 x_attribute8 IN VARCHAR2 DEFAULT NULL,
203 x_attribute9 IN VARCHAR2 DEFAULT NULL,
204 x_attribute10 IN VARCHAR2 DEFAULT NULL,
205 x_attribute11 IN VARCHAR2 DEFAULT NULL,
206 x_attribute12 IN VARCHAR2 DEFAULT NULL,
207 x_attribute13 IN VARCHAR2 DEFAULT NULL,
208 x_attribute14 IN VARCHAR2 DEFAULT NULL,
209 x_attribute15 IN VARCHAR2 DEFAULT NULL,
210 x_attribute16 IN VARCHAR2 DEFAULT NULL,
211 x_attribute17 IN VARCHAR2 DEFAULT NULL,
212 x_attribute18 IN VARCHAR2 DEFAULT NULL,
213 x_attribute19 IN VARCHAR2 DEFAULT NULL,
214 x_attribute20 IN VARCHAR2 DEFAULT NULL,
215
216
217 X_ORG_ID in NUMBER DEFAULT NULL,
218
219 x_creation_date IN DATE DEFAULT NULL,
220
221 x_created_by IN NUMBER DEFAULT NULL,
222
223 x_last_update_date IN DATE DEFAULT NULL,
224
225 x_last_updated_by IN NUMBER DEFAULT NULL,
226
227 x_last_update_login IN NUMBER DEFAULT NULL
228
229 );
230
231
232 end IGS_PE_PERSID_GROUP_PKG;