[Home] [Help]
PACKAGE: APPS.IGS_AS_ITEM_ASSESSOR_PKG
Source
1 package IGS_AS_ITEM_ASSESSOR_PKG AS
2 /* $Header: IGSDI02S.pls 120.0 2005/07/05 13:06:48 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_ASS_ID in NUMBER,
6 X_PERSON_ID in NUMBER,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_ASS_ASSESSOR_TYPE in VARCHAR2,
9 X_PRIMARY_ASSESSOR_IND in VARCHAR2,
10 X_ITEM_LIMIT in NUMBER,
11 X_LOCATION_CD in VARCHAR2,
12 X_UNIT_MODE in VARCHAR2,
13 X_UNIT_CLASS in VARCHAR2,
14 X_COMMENTS in VARCHAR2,
15 X_MODE in VARCHAR2 default 'R'
16 );
17 procedure LOCK_ROW (
18 X_ROWID in VARCHAR2,
19 X_ASS_ID in NUMBER,
20 X_PERSON_ID in NUMBER,
21 X_SEQUENCE_NUMBER in NUMBER,
22 X_ASS_ASSESSOR_TYPE in VARCHAR2,
23 X_PRIMARY_ASSESSOR_IND in VARCHAR2,
24 X_ITEM_LIMIT in NUMBER,
25 X_LOCATION_CD in VARCHAR2,
26 X_UNIT_MODE in VARCHAR2,
27 X_UNIT_CLASS in VARCHAR2,
28 X_COMMENTS in VARCHAR2
29 );
30 procedure UPDATE_ROW (
31 X_ROWID in VARCHAR2,
32 X_ASS_ID in NUMBER,
33 X_PERSON_ID in NUMBER,
34 X_SEQUENCE_NUMBER in NUMBER,
35 X_ASS_ASSESSOR_TYPE in VARCHAR2,
36 X_PRIMARY_ASSESSOR_IND in VARCHAR2,
37 X_ITEM_LIMIT in NUMBER,
38 X_LOCATION_CD in VARCHAR2,
39 X_UNIT_MODE in VARCHAR2,
40 X_UNIT_CLASS in VARCHAR2,
41 X_COMMENTS in VARCHAR2,
42 X_MODE in VARCHAR2 default 'R'
43 );
44 procedure ADD_ROW (
45 X_ROWID in out NOCOPY VARCHAR2,
46 X_ASS_ID in NUMBER,
47 X_PERSON_ID in NUMBER,
48 X_SEQUENCE_NUMBER in NUMBER,
49 X_ASS_ASSESSOR_TYPE in VARCHAR2,
50 X_PRIMARY_ASSESSOR_IND in VARCHAR2,
51 X_ITEM_LIMIT in NUMBER,
52 X_LOCATION_CD in VARCHAR2,
53 X_UNIT_MODE in VARCHAR2,
54 X_UNIT_CLASS in VARCHAR2,
55 X_COMMENTS in VARCHAR2,
56 X_MODE in VARCHAR2 default 'R'
57 );
58 procedure DELETE_ROW (
59 X_ROWID in VARCHAR2
60 );
61 FUNCTION Get_PK_For_Validation (
62 x_ass_id IN NUMBER,
63 x_person_id IN NUMBER,
64 x_sequence_number IN NUMBER
65 )RETURN BOOLEAN;
66
67 PROCEDURE GET_FK_IGS_AS_ASSESSMNT_ITM (
68 x_ass_id IN NUMBER
69 );
70
71 PROCEDURE GET_FK_IGS_AS_ASSESSOR_TYPE (
72 x_ass_assessor_type IN VARCHAR2
73 );
74
75 PROCEDURE GET_FK_IGS_AD_LOCATION (
76 x_location_cd IN VARCHAR2
77 );
78
79 PROCEDURE GET_FK_IGS_PE_PERSON (
80 x_person_id IN NUMBER
81 );
82
83 PROCEDURE GET_FK_IGS_AS_UNIT_MODE (
84 x_unit_mode IN VARCHAR2
85 );
86
87
88
89
90
91 PROCEDURE Check_Constraints (
92
93
94
95
96
97 Column_Name IN VARCHAR2 DEFAULT NULL,
98
99
100
101
102
103 Column_Value IN VARCHAR2 DEFAULT NULL
104
105
106
107
108
109 );
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127 PROCEDURE Before_DML (
128
129
130
131
132
133 p_action IN VARCHAR2,
134
135
136
137
138
139 x_rowid IN VARCHAR2 DEFAULT NULL,
140
141
142
143
144
145 x_person_id IN NUMBER DEFAULT NULL,
146
147
148
149
150
151 x_sequence_number IN NUMBER DEFAULT NULL,
152
153
154
155
156
157 x_ass_assessor_type IN VARCHAR2 DEFAULT NULL,
158
159
160
161
162
163 x_primary_assessor_ind IN VARCHAR2 DEFAULT NULL,
164
165
166
167
168
169 x_item_limit IN NUMBER DEFAULT NULL,
170
171
172
173
174
175 x_location_cd IN VARCHAR2 DEFAULT NULL,
176
177
178
179
180
181 x_unit_mode IN VARCHAR2 DEFAULT NULL,
182
183
184
185
186
187 x_unit_class IN VARCHAR2 DEFAULT NULL,
188
189
190
191
192
193 x_comments IN VARCHAR2 DEFAULT NULL,
194
195
196
197
198
199 x_ass_id IN NUMBER DEFAULT NULL,
200
201
202
203
204
205 x_creation_date IN DATE DEFAULT NULL,
206
207
208
209
210
211 x_created_by IN NUMBER DEFAULT NULL,
212
213
214
215
216
217 x_last_update_date IN DATE DEFAULT NULL,
218
219
220
221
222
223 x_last_updated_by IN NUMBER DEFAULT NULL,
224
225
226
227
228
229 x_last_update_login IN NUMBER DEFAULT NULL
230
231
232
233
234
235 ) ;
236
237
238
239
240
241
242
243
244
245
246
247
248
249 end IGS_AS_ITEM_ASSESSOR_PKG;