144: --------------------------------------------------------------------------
145:
146: PROCEDURE Update_Record(
147: x_pay_group_id NUMBER
148: ,x_name VARCHAR2 := fnd_api.g_miss_char
149: ,x_period_set_name VARCHAR2 := fnd_api.g_miss_char
150: ,x_period_type VARCHAR2 := fnd_api.g_miss_char
151: ,x_start_date DATE := fnd_api.g_miss_date
152: ,x_end_date DATE := fnd_api.g_miss_date
145:
146: PROCEDURE Update_Record(
147: x_pay_group_id NUMBER
148: ,x_name VARCHAR2 := fnd_api.g_miss_char
149: ,x_period_set_name VARCHAR2 := fnd_api.g_miss_char
150: ,x_period_type VARCHAR2 := fnd_api.g_miss_char
151: ,x_start_date DATE := fnd_api.g_miss_date
152: ,x_end_date DATE := fnd_api.g_miss_date
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
146: PROCEDURE Update_Record(
147: x_pay_group_id NUMBER
148: ,x_name VARCHAR2 := fnd_api.g_miss_char
149: ,x_period_set_name VARCHAR2 := fnd_api.g_miss_char
150: ,x_period_type VARCHAR2 := fnd_api.g_miss_char
151: ,x_start_date DATE := fnd_api.g_miss_date
152: ,x_end_date DATE := fnd_api.g_miss_date
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
147: x_pay_group_id NUMBER
148: ,x_name VARCHAR2 := fnd_api.g_miss_char
149: ,x_period_set_name VARCHAR2 := fnd_api.g_miss_char
150: ,x_period_type VARCHAR2 := fnd_api.g_miss_char
151: ,x_start_date DATE := fnd_api.g_miss_date
152: ,x_end_date DATE := fnd_api.g_miss_date
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
148: ,x_name VARCHAR2 := fnd_api.g_miss_char
149: ,x_period_set_name VARCHAR2 := fnd_api.g_miss_char
150: ,x_period_type VARCHAR2 := fnd_api.g_miss_char
151: ,x_start_date DATE := fnd_api.g_miss_date
152: ,x_end_date DATE := fnd_api.g_miss_date
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
149: ,x_period_set_name VARCHAR2 := fnd_api.g_miss_char
150: ,x_period_type VARCHAR2 := fnd_api.g_miss_char
151: ,x_start_date DATE := fnd_api.g_miss_date
152: ,x_end_date DATE := fnd_api.g_miss_date
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
152: ,x_end_date DATE := fnd_api.g_miss_date
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
153: ,x_pay_group_description VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
154: ,x_period_set_id NUMBER := cn_api.g_miss_id
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
155: ,x_period_type_id NUMBER := cn_api.g_miss_id
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
156: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
157: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
158: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
159: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
160: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
161: ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
162: ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
170: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
163: ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
170: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
171: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
164: ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
170: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
171: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
172: ,x_Last_Updated_By NUMBER
165: ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
170: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
171: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
172: ,x_Last_Updated_By NUMBER
173: ,x_Last_Update_Date DATE
166: ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
170: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
171: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
172: ,x_Last_Updated_By NUMBER
173: ,x_Last_Update_Date DATE
174: ,x_Last_Update_Login NUMBER
167: ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
168: ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
169: ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
170: ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
171: ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
172: ,x_Last_Updated_By NUMBER
173: ,x_Last_Update_Date DATE
174: ,x_Last_Update_Login NUMBER
175: ,x_object_version_number OUT NOCOPY NUMBER
214: FETCH pay_group_cur INTO l_pay_group_rec;
215: CLOSE pay_group_cur;
216:
217: SELECT decode(x_name,
218: fnd_api.g_miss_char, l_pay_group_rec.name,
219: x_name),
220: decode(x_period_set_name,
221: fnd_api.g_miss_char, l_pay_group_rec.period_set_name,
222: x_period_set_name),
217: SELECT decode(x_name,
218: fnd_api.g_miss_char, l_pay_group_rec.name,
219: x_name),
220: decode(x_period_set_name,
221: fnd_api.g_miss_char, l_pay_group_rec.period_set_name,
222: x_period_set_name),
223: decode(x_period_type,
224: fnd_api.g_miss_char, l_pay_group_rec.period_type,
225: x_period_type),
220: decode(x_period_set_name,
221: fnd_api.g_miss_char, l_pay_group_rec.period_set_name,
222: x_period_set_name),
223: decode(x_period_type,
224: fnd_api.g_miss_char, l_pay_group_rec.period_type,
225: x_period_type),
226: decode(x_start_date,
227: fnd_api.g_miss_date, l_pay_group_rec.start_date,
228: x_start_date),
223: decode(x_period_type,
224: fnd_api.g_miss_char, l_pay_group_rec.period_type,
225: x_period_type),
226: decode(x_start_date,
227: fnd_api.g_miss_date, l_pay_group_rec.start_date,
228: x_start_date),
229: decode(x_end_date,
230: fnd_api.g_miss_date, l_pay_group_rec.end_date,
231: x_end_date),
226: decode(x_start_date,
227: fnd_api.g_miss_date, l_pay_group_rec.start_date,
228: x_start_date),
229: decode(x_end_date,
230: fnd_api.g_miss_date, l_pay_group_rec.end_date,
231: x_end_date),
232: decode(x_pay_group_description,
233: fnd_api.g_miss_char, l_pay_group_rec.pay_group_description,
234: x_pay_group_description),
229: decode(x_end_date,
230: fnd_api.g_miss_date, l_pay_group_rec.end_date,
231: x_end_date),
232: decode(x_pay_group_description,
233: fnd_api.g_miss_char, l_pay_group_rec.pay_group_description,
234: x_pay_group_description),
235: decode(x_period_set_id,
236: cn_api.g_miss_id, l_pay_group_rec.period_set_id,
237: x_period_set_id),
238: decode(x_period_type_id,
239: cn_api.g_miss_id, l_pay_group_rec.period_type_id,
240: x_period_type_id),
241: decode(x_attribute_category,
242: fnd_api.g_miss_char, l_pay_group_rec.attribute_category,
243: x_attribute_category),
244: decode(x_attribute1,
245: fnd_api.g_miss_char, l_pay_group_rec.attribute1,
246: x_attribute1),
241: decode(x_attribute_category,
242: fnd_api.g_miss_char, l_pay_group_rec.attribute_category,
243: x_attribute_category),
244: decode(x_attribute1,
245: fnd_api.g_miss_char, l_pay_group_rec.attribute1,
246: x_attribute1),
247: decode(x_attribute2,
248: fnd_api.g_miss_char, l_pay_group_rec.attribute2,
249: x_attribute2),
244: decode(x_attribute1,
245: fnd_api.g_miss_char, l_pay_group_rec.attribute1,
246: x_attribute1),
247: decode(x_attribute2,
248: fnd_api.g_miss_char, l_pay_group_rec.attribute2,
249: x_attribute2),
250: decode(x_attribute3,
251: fnd_api.g_miss_char, l_pay_group_rec.attribute3,
252: x_attribute3),
247: decode(x_attribute2,
248: fnd_api.g_miss_char, l_pay_group_rec.attribute2,
249: x_attribute2),
250: decode(x_attribute3,
251: fnd_api.g_miss_char, l_pay_group_rec.attribute3,
252: x_attribute3),
253: decode(x_attribute4,
254: fnd_api.g_miss_char, l_pay_group_rec.attribute4,
255: x_attribute4),
250: decode(x_attribute3,
251: fnd_api.g_miss_char, l_pay_group_rec.attribute3,
252: x_attribute3),
253: decode(x_attribute4,
254: fnd_api.g_miss_char, l_pay_group_rec.attribute4,
255: x_attribute4),
256: decode(x_attribute5,
257: fnd_api.g_miss_char, l_pay_group_rec.attribute5,
258: x_attribute5),
253: decode(x_attribute4,
254: fnd_api.g_miss_char, l_pay_group_rec.attribute4,
255: x_attribute4),
256: decode(x_attribute5,
257: fnd_api.g_miss_char, l_pay_group_rec.attribute5,
258: x_attribute5),
259: decode(x_attribute6,
260: fnd_api.g_miss_char, l_pay_group_rec.attribute6,
261: x_attribute6),
256: decode(x_attribute5,
257: fnd_api.g_miss_char, l_pay_group_rec.attribute5,
258: x_attribute5),
259: decode(x_attribute6,
260: fnd_api.g_miss_char, l_pay_group_rec.attribute6,
261: x_attribute6),
262: decode(x_attribute7,
263: fnd_api.g_miss_char, l_pay_group_rec.attribute7,
264: x_attribute7),
259: decode(x_attribute6,
260: fnd_api.g_miss_char, l_pay_group_rec.attribute6,
261: x_attribute6),
262: decode(x_attribute7,
263: fnd_api.g_miss_char, l_pay_group_rec.attribute7,
264: x_attribute7),
265: decode(x_attribute8,
266: fnd_api.g_miss_char, l_pay_group_rec.attribute8,
267: x_attribute8),
262: decode(x_attribute7,
263: fnd_api.g_miss_char, l_pay_group_rec.attribute7,
264: x_attribute7),
265: decode(x_attribute8,
266: fnd_api.g_miss_char, l_pay_group_rec.attribute8,
267: x_attribute8),
268: decode(x_attribute9,
269: fnd_api.g_miss_char, l_pay_group_rec.attribute9,
270: x_attribute9),
265: decode(x_attribute8,
266: fnd_api.g_miss_char, l_pay_group_rec.attribute8,
267: x_attribute8),
268: decode(x_attribute9,
269: fnd_api.g_miss_char, l_pay_group_rec.attribute9,
270: x_attribute9),
271: decode(x_attribute10,
272: fnd_api.g_miss_char, l_pay_group_rec.attribute10,
273: x_attribute10),
268: decode(x_attribute9,
269: fnd_api.g_miss_char, l_pay_group_rec.attribute9,
270: x_attribute9),
271: decode(x_attribute10,
272: fnd_api.g_miss_char, l_pay_group_rec.attribute10,
273: x_attribute10),
274: decode(x_attribute11,
275: fnd_api.g_miss_char, l_pay_group_rec.attribute11,
276: x_attribute11),
271: decode(x_attribute10,
272: fnd_api.g_miss_char, l_pay_group_rec.attribute10,
273: x_attribute10),
274: decode(x_attribute11,
275: fnd_api.g_miss_char, l_pay_group_rec.attribute11,
276: x_attribute11),
277: decode(x_attribute12,
278: fnd_api.g_miss_char, l_pay_group_rec.attribute12,
279: x_attribute12),
274: decode(x_attribute11,
275: fnd_api.g_miss_char, l_pay_group_rec.attribute11,
276: x_attribute11),
277: decode(x_attribute12,
278: fnd_api.g_miss_char, l_pay_group_rec.attribute12,
279: x_attribute12),
280: decode(x_attribute13,
281: fnd_api.g_miss_char, l_pay_group_rec.attribute13,
282: x_attribute13),
277: decode(x_attribute12,
278: fnd_api.g_miss_char, l_pay_group_rec.attribute12,
279: x_attribute12),
280: decode(x_attribute13,
281: fnd_api.g_miss_char, l_pay_group_rec.attribute13,
282: x_attribute13),
283: decode(x_attribute14,
284: fnd_api.g_miss_char, l_pay_group_rec.attribute14,
285: x_attribute14),
280: decode(x_attribute13,
281: fnd_api.g_miss_char, l_pay_group_rec.attribute13,
282: x_attribute13),
283: decode(x_attribute14,
284: fnd_api.g_miss_char, l_pay_group_rec.attribute14,
285: x_attribute14),
286: decode(x_attribute15,
287: fnd_api.g_miss_char, l_pay_group_rec.attribute15,
288: x_attribute15),
283: decode(x_attribute14,
284: fnd_api.g_miss_char, l_pay_group_rec.attribute14,
285: x_attribute14),
286: decode(x_attribute15,
287: fnd_api.g_miss_char, l_pay_group_rec.attribute15,
288: x_attribute15),
289: decode(x_org_id,
290: cn_api.g_miss_id, l_pay_group_rec.org_id,
291: x_org_id)