48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_cnp_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: hr_cnp_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;
110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in hr_cnp_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin
152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in hr_cnp_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin
163: --
164: hr_cnp_rkd.after_delete
165: (p_canvas_property_id => p_rec.canvas_property_id
166: ,p_object_version_number_o => hr_tdg_shd.g_old_rec.object_version_number
167: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
164: hr_cnp_rkd.after_delete
165: (p_canvas_property_id => p_rec.canvas_property_id
166: ,p_object_version_number_o => hr_tdg_shd.g_old_rec.object_version_number
167: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
165: (p_canvas_property_id => p_rec.canvas_property_id
166: ,p_object_version_number_o => hr_tdg_shd.g_old_rec.object_version_number
167: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
166: ,p_object_version_number_o => hr_tdg_shd.g_old_rec.object_version_number
167: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
167: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
169: ,p_height_o => hr_cnp_shd.g_old_rec.height
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
171: ,p_width_o => hr_cnp_shd.g_old_rec.width
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
204: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
204: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
205: );
198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
204: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
205: );
206: --
199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
204: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
205: );
206: --
207: exception
200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
204: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
205: );
206: --
207: exception
208: --
220: -- ----------------------------------------------------------------------------
221: -- |---------------------------------< del >----------------------------------|
222: -- ----------------------------------------------------------------------------
223: Procedure del
224: (p_rec in hr_cnp_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'del';
228: --
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: -- We must lock the row which we need to delete.
233: --
234: hr_cnp_shd.lck
235: (p_rec.canvas_property_id
236: ,p_rec.object_version_number
237: );
238: --
261: (p_canvas_property_id in number
262: ,p_object_version_number in number
263: ) is
264: --
265: l_rec hr_cnp_shd.g_rec_type;
266: l_proc varchar2(72) := g_package||'del';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);