DBA Data[Home] [Help]

APPS.HR_CNP_DEL dependencies on HR_CNP_SHD

Line 52: (p_rec in hr_cnp_shd.g_rec_type

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: --

Line 75: hr_cnp_shd.constraint_error

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;

Line 114: Procedure pre_delete(p_rec in hr_cnp_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in hr_cnp_shd.g_rec_type) is

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

Line 167: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id

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

Line 168: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id

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

Line 169: ,p_height_o => hr_cnp_shd.g_old_rec.height

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

Line 170: ,p_visible_o => hr_cnp_shd.g_old_rec.visible

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

Line 171: ,p_width_o => hr_cnp_shd.g_old_rec.width

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

Line 172: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position

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

Line 173: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position

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

Line 174: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category

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

Line 175: ,p_information1_o => hr_cnp_shd.g_old_rec.information1

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

Line 176: ,p_information2_o => hr_cnp_shd.g_old_rec.information2

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

Line 177: ,p_information3_o => hr_cnp_shd.g_old_rec.information3

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

Line 178: ,p_information4_o => hr_cnp_shd.g_old_rec.information4

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

Line 179: ,p_information5_o => hr_cnp_shd.g_old_rec.information5

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

Line 180: ,p_information6_o => hr_cnp_shd.g_old_rec.information6

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

Line 181: ,p_information7_o => hr_cnp_shd.g_old_rec.information7

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

Line 182: ,p_information8_o => hr_cnp_shd.g_old_rec.information8

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

Line 183: ,p_information9_o => hr_cnp_shd.g_old_rec.information9

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

Line 184: ,p_information10_o => hr_cnp_shd.g_old_rec.information10

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

Line 185: ,p_information11_o => hr_cnp_shd.g_old_rec.information11

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

Line 186: ,p_information12_o => hr_cnp_shd.g_old_rec.information12

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

Line 187: ,p_information13_o => hr_cnp_shd.g_old_rec.information13

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

Line 188: ,p_information14_o => hr_cnp_shd.g_old_rec.information14

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

Line 189: ,p_information15_o => hr_cnp_shd.g_old_rec.information15

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

Line 190: ,p_information16_o => hr_cnp_shd.g_old_rec.information16

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

Line 191: ,p_information17_o => hr_cnp_shd.g_old_rec.information17

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

Line 192: ,p_information18_o => hr_cnp_shd.g_old_rec.information18

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

Line 193: ,p_information19_o => hr_cnp_shd.g_old_rec.information19

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

Line 194: ,p_information20_o => hr_cnp_shd.g_old_rec.information20

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

Line 195: ,p_information21_o => hr_cnp_shd.g_old_rec.information21

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

Line 196: ,p_information22_o => hr_cnp_shd.g_old_rec.information22

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

Line 197: ,p_information23_o => hr_cnp_shd.g_old_rec.information23

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

Line 198: ,p_information24_o => hr_cnp_shd.g_old_rec.information24

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

Line 199: ,p_information25_o => hr_cnp_shd.g_old_rec.information25

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

Line 200: ,p_information26_o => hr_cnp_shd.g_old_rec.information26

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

Line 201: ,p_information27_o => hr_cnp_shd.g_old_rec.information27

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: );

Line 202: ,p_information28_o => hr_cnp_shd.g_old_rec.information28

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: --

Line 203: ,p_information29_o => hr_cnp_shd.g_old_rec.information29

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

Line 204: ,p_information30_o => hr_cnp_shd.g_old_rec.information30

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: --

Line 224: (p_rec in hr_cnp_shd.g_rec_type

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: --

Line 234: hr_cnp_shd.lck

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: --

Line 265: l_rec hr_cnp_shd.g_rec_type;

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);