eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CHK_UPD dependencies on PER_CHK_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_chk_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_chk_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_chk_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_chk_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_checklist_items Row
68: --
69: update per_checklist_items

Line 112: per_chk_shd.g_api_dml := false; -- Unset the api dml status

108: attribute29 = p_rec.attribute29,
109: attribute30 = p_rec.attribute30
110: where checklist_item_id = p_rec.checklist_item_id;
111: --
112: per_chk_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception

Line 119: per_chk_shd.g_api_dml := false; -- Unset the api dml status

115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated

Line 120: per_chk_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status

Line 124: per_chk_shd.g_api_dml := false; -- Unset the api dml status

120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated

Line 125: per_chk_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status

Line 129: per_chk_shd.g_api_dml := false; -- Unset the api dml status

125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_chk_shd.g_api_dml := false; -- Unset the api dml status

Line 130: per_chk_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_chk_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;

Line 133: per_chk_shd.g_api_dml := false; -- Unset the api dml status

129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_chk_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;
135: End update_dml;
136: --
137: -- ----------------------------------------------------------------------------

Line 169: Procedure pre_update(p_rec in per_chk_shd.g_rec_type) is

165: -- Internal Row Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update(p_rec in per_chk_shd.g_rec_type) is
170: --
171: l_proc varchar2(72) := g_package||'pre_update';
172: --
173: Begin

Line 212: p_rec in per_chk_shd.g_rec_type) is

208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure post_update(p_effective_date in date,
212: p_rec in per_chk_shd.g_rec_type) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --
216: Begin

Line 266: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id

262: ,p_attribute27 =>p_rec.attribute27
263: ,p_attribute28 =>p_rec.attribute28
264: ,p_attribute29 =>p_rec.attribute29
265: ,p_attribute30 =>p_rec.attribute30
266: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status

Line 267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code

263: ,p_attribute28 =>p_rec.attribute28
264: ,p_attribute29 =>p_rec.attribute29
265: ,p_attribute30 =>p_rec.attribute30
266: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes

Line 268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due

264: ,p_attribute29 =>p_rec.attribute29
265: ,p_attribute30 =>p_rec.attribute30
266: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number

Line 269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done

265: ,p_attribute30 =>p_rec.attribute30
266: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category

Line 270: ,p_status_o =>per_chk_shd.g_old_rec.status

266: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1

Line 271: ,p_notes_o =>per_chk_shd.g_old_rec.notes

267: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2

Line 272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number

268: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3

Line 273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category

269: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4

Line 274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1

270: ,p_status_o =>per_chk_shd.g_old_rec.status
271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5

Line 275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2

271: ,p_notes_o =>per_chk_shd.g_old_rec.notes
272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6

Line 276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3

272: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7

Line 277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4

273: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8

Line 278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5

274: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9

Line 279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6

275: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10

Line 280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7

276: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11

Line 281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8

277: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12

Line 282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9

278: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13

Line 283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10

279: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14

Line 284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11

280: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15

Line 285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12

281: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16

Line 286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13

282: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17

Line 287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14

283: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18

Line 288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15

284: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19

Line 289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16

285: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20

Line 290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17

286: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21

Line 291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18

287: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22

Line 292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19

288: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23

Line 293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20

289: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24

Line 294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21

290: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25

Line 295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22

291: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26

Line 296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23

292: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27

Line 297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24

293: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28

Line 298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25

294: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29

Line 299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26

295: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
303: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30

Line 300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27

296: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
303: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
304: );

Line 301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28

297: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
303: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
304: );
305: --

Line 302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29

298: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
303: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
304: );
305: --
306: exception

Line 303: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30

299: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
300: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
301: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
302: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
303: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
304: );
305: --
306: exception
307: --

Line 365: Procedure convert_defs(p_rec in out nocopy per_chk_shd.g_rec_type) is

361: -- Internal Row Handler Use Only.
362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure convert_defs(p_rec in out nocopy per_chk_shd.g_rec_type) is
366: --
367: l_proc varchar2(72) := g_package||'convert_defs';
368: --
369: Begin

Line 380: per_chk_shd.g_old_rec.person_id;

376: -- is being used then we must set to the 'current' argument value.
377: --
378: If (p_rec.person_id = hr_api.g_number) then
379: p_rec.person_id :=
380: per_chk_shd.g_old_rec.person_id;
381: End If;
382: If (p_rec.item_code = hr_api.g_varchar2) then
383: p_rec.item_code :=
384: per_chk_shd.g_old_rec.item_code;

Line 384: per_chk_shd.g_old_rec.item_code;

380: per_chk_shd.g_old_rec.person_id;
381: End If;
382: If (p_rec.item_code = hr_api.g_varchar2) then
383: p_rec.item_code :=
384: per_chk_shd.g_old_rec.item_code;
385: End If;
386: If (p_rec.date_due = hr_api.g_date) then
387: p_rec.date_due :=
388: per_chk_shd.g_old_rec.date_due;

Line 388: per_chk_shd.g_old_rec.date_due;

384: per_chk_shd.g_old_rec.item_code;
385: End If;
386: If (p_rec.date_due = hr_api.g_date) then
387: p_rec.date_due :=
388: per_chk_shd.g_old_rec.date_due;
389: End If;
390: If (p_rec.date_done = hr_api.g_date) then
391: p_rec.date_done :=
392: per_chk_shd.g_old_rec.date_done;

Line 392: per_chk_shd.g_old_rec.date_done;

388: per_chk_shd.g_old_rec.date_due;
389: End If;
390: If (p_rec.date_done = hr_api.g_date) then
391: p_rec.date_done :=
392: per_chk_shd.g_old_rec.date_done;
393: End If;
394: If (p_rec.status = hr_api.g_varchar2) then
395: p_rec.status :=
396: per_chk_shd.g_old_rec.status;

Line 396: per_chk_shd.g_old_rec.status;

392: per_chk_shd.g_old_rec.date_done;
393: End If;
394: If (p_rec.status = hr_api.g_varchar2) then
395: p_rec.status :=
396: per_chk_shd.g_old_rec.status;
397: End If;
398: If (p_rec.notes = hr_api.g_varchar2) then
399: p_rec.notes :=
400: per_chk_shd.g_old_rec.notes;

Line 400: per_chk_shd.g_old_rec.notes;

396: per_chk_shd.g_old_rec.status;
397: End If;
398: If (p_rec.notes = hr_api.g_varchar2) then
399: p_rec.notes :=
400: per_chk_shd.g_old_rec.notes;
401: End If;
402: If (p_rec.attribute_category = hr_api.g_varchar2) then
403: p_rec.attribute_category :=
404: per_chk_shd.g_old_rec.attribute_category;

Line 404: per_chk_shd.g_old_rec.attribute_category;

400: per_chk_shd.g_old_rec.notes;
401: End If;
402: If (p_rec.attribute_category = hr_api.g_varchar2) then
403: p_rec.attribute_category :=
404: per_chk_shd.g_old_rec.attribute_category;
405: End If;
406: If (p_rec.attribute1 = hr_api.g_varchar2) then
407: p_rec.attribute1 :=
408: per_chk_shd.g_old_rec.attribute1;

Line 408: per_chk_shd.g_old_rec.attribute1;

404: per_chk_shd.g_old_rec.attribute_category;
405: End If;
406: If (p_rec.attribute1 = hr_api.g_varchar2) then
407: p_rec.attribute1 :=
408: per_chk_shd.g_old_rec.attribute1;
409: End If;
410: If (p_rec.attribute2 = hr_api.g_varchar2) then
411: p_rec.attribute2 :=
412: per_chk_shd.g_old_rec.attribute2;

Line 412: per_chk_shd.g_old_rec.attribute2;

408: per_chk_shd.g_old_rec.attribute1;
409: End If;
410: If (p_rec.attribute2 = hr_api.g_varchar2) then
411: p_rec.attribute2 :=
412: per_chk_shd.g_old_rec.attribute2;
413: End If;
414: If (p_rec.attribute3 = hr_api.g_varchar2) then
415: p_rec.attribute3 :=
416: per_chk_shd.g_old_rec.attribute3;

Line 416: per_chk_shd.g_old_rec.attribute3;

412: per_chk_shd.g_old_rec.attribute2;
413: End If;
414: If (p_rec.attribute3 = hr_api.g_varchar2) then
415: p_rec.attribute3 :=
416: per_chk_shd.g_old_rec.attribute3;
417: End If;
418: If (p_rec.attribute4 = hr_api.g_varchar2) then
419: p_rec.attribute4 :=
420: per_chk_shd.g_old_rec.attribute4;

Line 420: per_chk_shd.g_old_rec.attribute4;

416: per_chk_shd.g_old_rec.attribute3;
417: End If;
418: If (p_rec.attribute4 = hr_api.g_varchar2) then
419: p_rec.attribute4 :=
420: per_chk_shd.g_old_rec.attribute4;
421: End If;
422: If (p_rec.attribute5 = hr_api.g_varchar2) then
423: p_rec.attribute5 :=
424: per_chk_shd.g_old_rec.attribute5;

Line 424: per_chk_shd.g_old_rec.attribute5;

420: per_chk_shd.g_old_rec.attribute4;
421: End If;
422: If (p_rec.attribute5 = hr_api.g_varchar2) then
423: p_rec.attribute5 :=
424: per_chk_shd.g_old_rec.attribute5;
425: End If;
426: If (p_rec.attribute6 = hr_api.g_varchar2) then
427: p_rec.attribute6 :=
428: per_chk_shd.g_old_rec.attribute6;

Line 428: per_chk_shd.g_old_rec.attribute6;

424: per_chk_shd.g_old_rec.attribute5;
425: End If;
426: If (p_rec.attribute6 = hr_api.g_varchar2) then
427: p_rec.attribute6 :=
428: per_chk_shd.g_old_rec.attribute6;
429: End If;
430: If (p_rec.attribute7 = hr_api.g_varchar2) then
431: p_rec.attribute7 :=
432: per_chk_shd.g_old_rec.attribute7;

Line 432: per_chk_shd.g_old_rec.attribute7;

428: per_chk_shd.g_old_rec.attribute6;
429: End If;
430: If (p_rec.attribute7 = hr_api.g_varchar2) then
431: p_rec.attribute7 :=
432: per_chk_shd.g_old_rec.attribute7;
433: End If;
434: If (p_rec.attribute8 = hr_api.g_varchar2) then
435: p_rec.attribute8 :=
436: per_chk_shd.g_old_rec.attribute8;

Line 436: per_chk_shd.g_old_rec.attribute8;

432: per_chk_shd.g_old_rec.attribute7;
433: End If;
434: If (p_rec.attribute8 = hr_api.g_varchar2) then
435: p_rec.attribute8 :=
436: per_chk_shd.g_old_rec.attribute8;
437: End If;
438: If (p_rec.attribute9 = hr_api.g_varchar2) then
439: p_rec.attribute9 :=
440: per_chk_shd.g_old_rec.attribute9;

Line 440: per_chk_shd.g_old_rec.attribute9;

436: per_chk_shd.g_old_rec.attribute8;
437: End If;
438: If (p_rec.attribute9 = hr_api.g_varchar2) then
439: p_rec.attribute9 :=
440: per_chk_shd.g_old_rec.attribute9;
441: End If;
442: If (p_rec.attribute10 = hr_api.g_varchar2) then
443: p_rec.attribute10 :=
444: per_chk_shd.g_old_rec.attribute10;

Line 444: per_chk_shd.g_old_rec.attribute10;

440: per_chk_shd.g_old_rec.attribute9;
441: End If;
442: If (p_rec.attribute10 = hr_api.g_varchar2) then
443: p_rec.attribute10 :=
444: per_chk_shd.g_old_rec.attribute10;
445: End If;
446: If (p_rec.attribute11 = hr_api.g_varchar2) then
447: p_rec.attribute11 :=
448: per_chk_shd.g_old_rec.attribute11;

Line 448: per_chk_shd.g_old_rec.attribute11;

444: per_chk_shd.g_old_rec.attribute10;
445: End If;
446: If (p_rec.attribute11 = hr_api.g_varchar2) then
447: p_rec.attribute11 :=
448: per_chk_shd.g_old_rec.attribute11;
449: End If;
450: If (p_rec.attribute12 = hr_api.g_varchar2) then
451: p_rec.attribute12 :=
452: per_chk_shd.g_old_rec.attribute12;

Line 452: per_chk_shd.g_old_rec.attribute12;

448: per_chk_shd.g_old_rec.attribute11;
449: End If;
450: If (p_rec.attribute12 = hr_api.g_varchar2) then
451: p_rec.attribute12 :=
452: per_chk_shd.g_old_rec.attribute12;
453: End If;
454: If (p_rec.attribute13 = hr_api.g_varchar2) then
455: p_rec.attribute13 :=
456: per_chk_shd.g_old_rec.attribute13;

Line 456: per_chk_shd.g_old_rec.attribute13;

452: per_chk_shd.g_old_rec.attribute12;
453: End If;
454: If (p_rec.attribute13 = hr_api.g_varchar2) then
455: p_rec.attribute13 :=
456: per_chk_shd.g_old_rec.attribute13;
457: End If;
458: If (p_rec.attribute14 = hr_api.g_varchar2) then
459: p_rec.attribute14 :=
460: per_chk_shd.g_old_rec.attribute14;

Line 460: per_chk_shd.g_old_rec.attribute14;

456: per_chk_shd.g_old_rec.attribute13;
457: End If;
458: If (p_rec.attribute14 = hr_api.g_varchar2) then
459: p_rec.attribute14 :=
460: per_chk_shd.g_old_rec.attribute14;
461: End If;
462: If (p_rec.attribute15 = hr_api.g_varchar2) then
463: p_rec.attribute15 :=
464: per_chk_shd.g_old_rec.attribute15;

Line 464: per_chk_shd.g_old_rec.attribute15;

460: per_chk_shd.g_old_rec.attribute14;
461: End If;
462: If (p_rec.attribute15 = hr_api.g_varchar2) then
463: p_rec.attribute15 :=
464: per_chk_shd.g_old_rec.attribute15;
465: End If;
466: If (p_rec.attribute16 = hr_api.g_varchar2) then
467: p_rec.attribute16 :=
468: per_chk_shd.g_old_rec.attribute16;

Line 468: per_chk_shd.g_old_rec.attribute16;

464: per_chk_shd.g_old_rec.attribute15;
465: End If;
466: If (p_rec.attribute16 = hr_api.g_varchar2) then
467: p_rec.attribute16 :=
468: per_chk_shd.g_old_rec.attribute16;
469: End If;
470: If (p_rec.attribute17 = hr_api.g_varchar2) then
471: p_rec.attribute17 :=
472: per_chk_shd.g_old_rec.attribute17;

Line 472: per_chk_shd.g_old_rec.attribute17;

468: per_chk_shd.g_old_rec.attribute16;
469: End If;
470: If (p_rec.attribute17 = hr_api.g_varchar2) then
471: p_rec.attribute17 :=
472: per_chk_shd.g_old_rec.attribute17;
473: End If;
474: If (p_rec.attribute18 = hr_api.g_varchar2) then
475: p_rec.attribute18 :=
476: per_chk_shd.g_old_rec.attribute18;

Line 476: per_chk_shd.g_old_rec.attribute18;

472: per_chk_shd.g_old_rec.attribute17;
473: End If;
474: If (p_rec.attribute18 = hr_api.g_varchar2) then
475: p_rec.attribute18 :=
476: per_chk_shd.g_old_rec.attribute18;
477: End If;
478: If (p_rec.attribute19 = hr_api.g_varchar2) then
479: p_rec.attribute19 :=
480: per_chk_shd.g_old_rec.attribute19;

Line 480: per_chk_shd.g_old_rec.attribute19;

476: per_chk_shd.g_old_rec.attribute18;
477: End If;
478: If (p_rec.attribute19 = hr_api.g_varchar2) then
479: p_rec.attribute19 :=
480: per_chk_shd.g_old_rec.attribute19;
481: End If;
482: If (p_rec.attribute20 = hr_api.g_varchar2) then
483: p_rec.attribute20 :=
484: per_chk_shd.g_old_rec.attribute20;

Line 484: per_chk_shd.g_old_rec.attribute20;

480: per_chk_shd.g_old_rec.attribute19;
481: End If;
482: If (p_rec.attribute20 = hr_api.g_varchar2) then
483: p_rec.attribute20 :=
484: per_chk_shd.g_old_rec.attribute20;
485: End If;
486: If (p_rec.attribute21 = hr_api.g_varchar2) then
487: p_rec.attribute21 :=
488: per_chk_shd.g_old_rec.attribute21;

Line 488: per_chk_shd.g_old_rec.attribute21;

484: per_chk_shd.g_old_rec.attribute20;
485: End If;
486: If (p_rec.attribute21 = hr_api.g_varchar2) then
487: p_rec.attribute21 :=
488: per_chk_shd.g_old_rec.attribute21;
489: End If;
490: If (p_rec.attribute22 = hr_api.g_varchar2) then
491: p_rec.attribute22 :=
492: per_chk_shd.g_old_rec.attribute22;

Line 492: per_chk_shd.g_old_rec.attribute22;

488: per_chk_shd.g_old_rec.attribute21;
489: End If;
490: If (p_rec.attribute22 = hr_api.g_varchar2) then
491: p_rec.attribute22 :=
492: per_chk_shd.g_old_rec.attribute22;
493: End If;
494: If (p_rec.attribute23 = hr_api.g_varchar2) then
495: p_rec.attribute23 :=
496: per_chk_shd.g_old_rec.attribute23;

Line 496: per_chk_shd.g_old_rec.attribute23;

492: per_chk_shd.g_old_rec.attribute22;
493: End If;
494: If (p_rec.attribute23 = hr_api.g_varchar2) then
495: p_rec.attribute23 :=
496: per_chk_shd.g_old_rec.attribute23;
497: End If;
498: If (p_rec.attribute24 = hr_api.g_varchar2) then
499: p_rec.attribute24 :=
500: per_chk_shd.g_old_rec.attribute24;

Line 500: per_chk_shd.g_old_rec.attribute24;

496: per_chk_shd.g_old_rec.attribute23;
497: End If;
498: If (p_rec.attribute24 = hr_api.g_varchar2) then
499: p_rec.attribute24 :=
500: per_chk_shd.g_old_rec.attribute24;
501: End If;
502: If (p_rec.attribute25 = hr_api.g_varchar2) then
503: p_rec.attribute25 :=
504: per_chk_shd.g_old_rec.attribute25;

Line 504: per_chk_shd.g_old_rec.attribute25;

500: per_chk_shd.g_old_rec.attribute24;
501: End If;
502: If (p_rec.attribute25 = hr_api.g_varchar2) then
503: p_rec.attribute25 :=
504: per_chk_shd.g_old_rec.attribute25;
505: End If;
506: If (p_rec.attribute26 = hr_api.g_varchar2) then
507: p_rec.attribute26 :=
508: per_chk_shd.g_old_rec.attribute26;

Line 508: per_chk_shd.g_old_rec.attribute26;

504: per_chk_shd.g_old_rec.attribute25;
505: End If;
506: If (p_rec.attribute26 = hr_api.g_varchar2) then
507: p_rec.attribute26 :=
508: per_chk_shd.g_old_rec.attribute26;
509: End If;
510: If (p_rec.attribute27 = hr_api.g_varchar2) then
511: p_rec.attribute27 :=
512: per_chk_shd.g_old_rec.attribute27;

Line 512: per_chk_shd.g_old_rec.attribute27;

508: per_chk_shd.g_old_rec.attribute26;
509: End If;
510: If (p_rec.attribute27 = hr_api.g_varchar2) then
511: p_rec.attribute27 :=
512: per_chk_shd.g_old_rec.attribute27;
513: End If;
514: If (p_rec.attribute28 = hr_api.g_varchar2) then
515: p_rec.attribute28 :=
516: per_chk_shd.g_old_rec.attribute28;

Line 516: per_chk_shd.g_old_rec.attribute28;

512: per_chk_shd.g_old_rec.attribute27;
513: End If;
514: If (p_rec.attribute28 = hr_api.g_varchar2) then
515: p_rec.attribute28 :=
516: per_chk_shd.g_old_rec.attribute28;
517: End If;
518: If (p_rec.attribute29 = hr_api.g_varchar2) then
519: p_rec.attribute29 :=
520: per_chk_shd.g_old_rec.attribute29;

Line 520: per_chk_shd.g_old_rec.attribute29;

516: per_chk_shd.g_old_rec.attribute28;
517: End If;
518: If (p_rec.attribute29 = hr_api.g_varchar2) then
519: p_rec.attribute29 :=
520: per_chk_shd.g_old_rec.attribute29;
521: End If;
522: If (p_rec.attribute30 = hr_api.g_varchar2) then
523: p_rec.attribute30 :=
524: per_chk_shd.g_old_rec.attribute30;

Line 524: per_chk_shd.g_old_rec.attribute30;

520: per_chk_shd.g_old_rec.attribute29;
521: End If;
522: If (p_rec.attribute30 = hr_api.g_varchar2) then
523: p_rec.attribute30 :=
524: per_chk_shd.g_old_rec.attribute30;
525: End If;
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 10);
528: --

Line 537: ,p_rec in out nocopy per_chk_shd.g_rec_type

533: -- ----------------------------------------------------------------------------
534: Procedure upd
535: (
536: p_effective_date in date
537: ,p_rec in out nocopy per_chk_shd.g_rec_type
538: ) is
539: --
540: l_proc varchar2(72) := g_package||'upd';
541: --

Line 547: per_chk_shd.lck

543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- We must lock the row which we need to update.
546: --
547: per_chk_shd.lck
548: (
549: p_rec.checklist_item_id,
550: p_rec.object_version_number
551: );

Line 624: l_rec per_chk_shd.g_rec_type;

620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --
624: l_rec per_chk_shd.g_rec_type;
625: l_proc varchar2(72) := g_package||'upd';
626: --
627: Begin
628: hr_utility.set_location('Entering:'||l_proc, 5);

Line 634: per_chk_shd.convert_args

630: -- Call conversion function to turn arguments into the
631: -- l_rec structure.
632: --
633: l_rec :=
634: per_chk_shd.convert_args
635: (
636: p_checklist_item_id,
637: p_person_id,
638: p_item_code,