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_DEL dependencies on PER_CHK_SHD

Line 51: Procedure delete_dml(p_rec in per_chk_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_chk_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

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

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_chk_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_checklist_items row.
61: --
62: delete from per_checklist_items

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

61: --
62: delete from per_checklist_items
63: where checklist_item_id = p_rec.checklist_item_id;
64: --
65: per_chk_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_chk_shd.g_api_dml := false; -- Unset the api dml status
73: per_chk_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_chk_shd.g_api_dml := false; -- Unset the api dml status

Line 73: per_chk_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_chk_shd.g_api_dml := false; -- Unset the api dml status
73: per_chk_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_chk_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: per_chk_shd.g_api_dml := false; -- Unset the api dml status
73: per_chk_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_chk_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in per_chk_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_chk_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in per_chk_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in per_chk_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

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

165: --
166: per_chk_rkd.after_delete
167: (
168: p_checklist_item_id =>p_rec.checklist_item_id
169: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
170: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status

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

166: per_chk_rkd.after_delete
167: (
168: p_checklist_item_id =>p_rec.checklist_item_id
169: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
170: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes

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

167: (
168: p_checklist_item_id =>p_rec.checklist_item_id
169: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
170: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number

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

168: p_checklist_item_id =>p_rec.checklist_item_id
169: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
170: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category

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

169: ,p_person_id_o =>per_chk_shd.g_old_rec.person_id
170: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1

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

170: ,p_item_code_o =>per_chk_shd.g_old_rec.item_code
171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2

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

171: ,p_date_due_o =>per_chk_shd.g_old_rec.date_due
172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3

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

172: ,p_date_done_o =>per_chk_shd.g_old_rec.date_done
173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4

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

173: ,p_status_o =>per_chk_shd.g_old_rec.status
174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5

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

174: ,p_notes_o =>per_chk_shd.g_old_rec.notes
175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6

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

175: ,p_object_version_number_o =>per_chk_shd.g_old_rec.object_version_number
176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7

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

176: ,p_attribute_category_o =>per_chk_shd.g_old_rec.attribute_category
177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8

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

177: ,p_attribute1_o =>per_chk_shd.g_old_rec.attribute1
178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9

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

178: ,p_attribute2_o =>per_chk_shd.g_old_rec.attribute2
179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10

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

179: ,p_attribute3_o =>per_chk_shd.g_old_rec.attribute3
180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11

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

180: ,p_attribute4_o =>per_chk_shd.g_old_rec.attribute4
181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12

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

181: ,p_attribute5_o =>per_chk_shd.g_old_rec.attribute5
182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13

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

182: ,p_attribute6_o =>per_chk_shd.g_old_rec.attribute6
183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14

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

183: ,p_attribute7_o =>per_chk_shd.g_old_rec.attribute7
184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15

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

184: ,p_attribute8_o =>per_chk_shd.g_old_rec.attribute8
185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16

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

185: ,p_attribute9_o =>per_chk_shd.g_old_rec.attribute9
186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17

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

186: ,p_attribute10_o =>per_chk_shd.g_old_rec.attribute10
187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18

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

187: ,p_attribute11_o =>per_chk_shd.g_old_rec.attribute11
188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19

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

188: ,p_attribute12_o =>per_chk_shd.g_old_rec.attribute12
189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20

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

189: ,p_attribute13_o =>per_chk_shd.g_old_rec.attribute13
190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21

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

190: ,p_attribute14_o =>per_chk_shd.g_old_rec.attribute14
191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22

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

191: ,p_attribute15_o =>per_chk_shd.g_old_rec.attribute15
192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23

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

192: ,p_attribute16_o =>per_chk_shd.g_old_rec.attribute16
193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24

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

193: ,p_attribute17_o =>per_chk_shd.g_old_rec.attribute17
194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25

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

194: ,p_attribute18_o =>per_chk_shd.g_old_rec.attribute18
195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26

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

195: ,p_attribute19_o =>per_chk_shd.g_old_rec.attribute19
196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27

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

196: ,p_attribute20_o =>per_chk_shd.g_old_rec.attribute20
197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28

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

197: ,p_attribute21_o =>per_chk_shd.g_old_rec.attribute21
198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
205: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29

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

198: ,p_attribute22_o =>per_chk_shd.g_old_rec.attribute22
199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
205: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
206: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30

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

199: ,p_attribute23_o =>per_chk_shd.g_old_rec.attribute23
200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
205: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
206: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
207: );

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

200: ,p_attribute24_o =>per_chk_shd.g_old_rec.attribute24
201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
205: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
206: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
207: );
208: --

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

201: ,p_attribute25_o =>per_chk_shd.g_old_rec.attribute25
202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
205: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
206: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
207: );
208: --
209: exception

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

202: ,p_attribute26_o =>per_chk_shd.g_old_rec.attribute26
203: ,p_attribute27_o =>per_chk_shd.g_old_rec.attribute27
204: ,p_attribute28_o =>per_chk_shd.g_old_rec.attribute28
205: ,p_attribute29_o =>per_chk_shd.g_old_rec.attribute29
206: ,p_attribute30_o =>per_chk_shd.g_old_rec.attribute30
207: );
208: --
209: exception
210: --

Line 230: p_rec in per_chk_shd.g_rec_type

226: -- |---------------------------------< del >----------------------------------|
227: -- ----------------------------------------------------------------------------
228: Procedure del
229: (
230: p_rec in per_chk_shd.g_rec_type
231: ) is
232: --
233: l_proc varchar2(72) := g_package||'del';
234: --

Line 240: per_chk_shd.lck

236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: -- We must lock the row which we need to delete.
239: --
240: per_chk_shd.lck
241: (
242: p_rec.checklist_item_id,
243: p_rec.object_version_number
244: );

Line 272: l_rec per_chk_shd.g_rec_type;

268: p_checklist_item_id in number,
269: p_object_version_number in number
270: ) is
271: --
272: l_rec per_chk_shd.g_rec_type;
273: l_proc varchar2(72) := g_package||'del';
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);