DBA Data[Home] [Help]

APPS.HR_CNP_UPD dependencies on HR_CNP_SHD

Line 55: (p_rec in out nocopy hr_cnp_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_cnp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 120: hr_cnp_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: hr_cnp_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: --

Line 125: hr_cnp_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: --
125: hr_cnp_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: --

Line 130: hr_cnp_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: --
130: hr_cnp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;

Line 170: (p_rec in hr_cnp_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update
170: (p_rec in hr_cnp_shd.g_rec_type
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --

Line 215: ,p_rec in hr_cnp_shd.g_rec_type

211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update
214: (p_effective_date in date
215: ,p_rec in hr_cnp_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --

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

262: ,p_information27 => p_rec.information27
263: ,p_information28 => p_rec.information28
264: ,p_information29 => p_rec.information29
265: ,p_information30 => p_rec.information30
266: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number
268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible

Line 267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number

263: ,p_information28 => p_rec.information28
264: ,p_information29 => p_rec.information29
265: ,p_information30 => p_rec.information30
266: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number
268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width

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

264: ,p_information29 => p_rec.information29
265: ,p_information30 => p_rec.information30
266: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number
268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position

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

265: ,p_information30 => p_rec.information30
266: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number
268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position

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

266: ,p_form_canvas_id_o => hr_cnp_shd.g_old_rec.form_canvas_id
267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number
268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category

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

267: ,p_object_version_number_o => hr_cnp_shd.g_old_rec.object_version_number
268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1

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

268: ,p_template_canvas_id_o => hr_cnp_shd.g_old_rec.template_canvas_id
269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2

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

269: ,p_height_o => hr_cnp_shd.g_old_rec.height
270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3

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

270: ,p_visible_o => hr_cnp_shd.g_old_rec.visible
271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4

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

271: ,p_width_o => hr_cnp_shd.g_old_rec.width
272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5

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

272: ,p_x_position_o => hr_cnp_shd.g_old_rec.x_position
273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6

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

273: ,p_y_position_o => hr_cnp_shd.g_old_rec.y_position
274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7

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

274: ,p_information_category_o => hr_cnp_shd.g_old_rec.information_category
275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8

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

275: ,p_information1_o => hr_cnp_shd.g_old_rec.information1
276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9

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

276: ,p_information2_o => hr_cnp_shd.g_old_rec.information2
277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10

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

277: ,p_information3_o => hr_cnp_shd.g_old_rec.information3
278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11

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

278: ,p_information4_o => hr_cnp_shd.g_old_rec.information4
279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12

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

279: ,p_information5_o => hr_cnp_shd.g_old_rec.information5
280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13

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

280: ,p_information6_o => hr_cnp_shd.g_old_rec.information6
281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14

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

281: ,p_information7_o => hr_cnp_shd.g_old_rec.information7
282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15

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

282: ,p_information8_o => hr_cnp_shd.g_old_rec.information8
283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16

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

283: ,p_information9_o => hr_cnp_shd.g_old_rec.information9
284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17

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

284: ,p_information10_o => hr_cnp_shd.g_old_rec.information10
285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18

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

285: ,p_information11_o => hr_cnp_shd.g_old_rec.information11
286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19

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

286: ,p_information12_o => hr_cnp_shd.g_old_rec.information12
287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20

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

287: ,p_information13_o => hr_cnp_shd.g_old_rec.information13
288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21

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

288: ,p_information14_o => hr_cnp_shd.g_old_rec.information14
289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22

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

289: ,p_information15_o => hr_cnp_shd.g_old_rec.information15
290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23

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

290: ,p_information16_o => hr_cnp_shd.g_old_rec.information16
291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24

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

291: ,p_information17_o => hr_cnp_shd.g_old_rec.information17
292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25

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

292: ,p_information18_o => hr_cnp_shd.g_old_rec.information18
293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26

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

293: ,p_information19_o => hr_cnp_shd.g_old_rec.information19
294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27

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

294: ,p_information20_o => hr_cnp_shd.g_old_rec.information20
295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28

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

295: ,p_information21_o => hr_cnp_shd.g_old_rec.information21
296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
303: ,p_information29_o => hr_cnp_shd.g_old_rec.information29

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

296: ,p_information22_o => hr_cnp_shd.g_old_rec.information22
297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
303: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
304: ,p_information30_o => hr_cnp_shd.g_old_rec.information30

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

297: ,p_information23_o => hr_cnp_shd.g_old_rec.information23
298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
303: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
304: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
305: );

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

298: ,p_information24_o => hr_cnp_shd.g_old_rec.information24
299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
303: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
304: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
305: );
306: --

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

299: ,p_information25_o => hr_cnp_shd.g_old_rec.information25
300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
303: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
304: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
305: );
306: --
307: exception

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

300: ,p_information26_o => hr_cnp_shd.g_old_rec.information26
301: ,p_information27_o => hr_cnp_shd.g_old_rec.information27
302: ,p_information28_o => hr_cnp_shd.g_old_rec.information28
303: ,p_information29_o => hr_cnp_shd.g_old_rec.information29
304: ,p_information30_o => hr_cnp_shd.g_old_rec.information30
305: );
306: --
307: exception
308: --

Line 364: (p_rec in out nocopy hr_cnp_shd.g_rec_type

360: --
361: -- {End Of Comments}
362: -- ----------------------------------------------------------------------------
363: Procedure convert_defs
364: (p_rec in out nocopy hr_cnp_shd.g_rec_type
365: ) is
366: --
367: Begin
368: --

Line 375: p_rec.form_canvas_id := hr_cnp_shd.g_old_rec.form_canvas_id;

371: -- to see if a system default is being used. If a system default
372: -- is being used then we must set to the 'current' argument value.
373: --
374: If (p_rec.form_canvas_id = hr_api.g_number) then
375: p_rec.form_canvas_id := hr_cnp_shd.g_old_rec.form_canvas_id;
376: End If;
377: If (p_rec.template_canvas_id = hr_api.g_number) then
378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;
379: End If;

Line 378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;

374: If (p_rec.form_canvas_id = hr_api.g_number) then
375: p_rec.form_canvas_id := hr_cnp_shd.g_old_rec.form_canvas_id;
376: End If;
377: If (p_rec.template_canvas_id = hr_api.g_number) then
378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;
379: End If;
380: If (p_rec.height = hr_api.g_number) then
381: p_rec.height := hr_cnp_shd.g_old_rec.height;
382: End If;

Line 381: p_rec.height := hr_cnp_shd.g_old_rec.height;

377: If (p_rec.template_canvas_id = hr_api.g_number) then
378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;
379: End If;
380: If (p_rec.height = hr_api.g_number) then
381: p_rec.height := hr_cnp_shd.g_old_rec.height;
382: End If;
383: If (p_rec.visible = hr_api.g_number) then
384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;
385: End If;

Line 384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;

380: If (p_rec.height = hr_api.g_number) then
381: p_rec.height := hr_cnp_shd.g_old_rec.height;
382: End If;
383: If (p_rec.visible = hr_api.g_number) then
384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;
385: End If;
386: If (p_rec.width = hr_api.g_number) then
387: p_rec.width := hr_cnp_shd.g_old_rec.width;
388: End If;

Line 387: p_rec.width := hr_cnp_shd.g_old_rec.width;

383: If (p_rec.visible = hr_api.g_number) then
384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;
385: End If;
386: If (p_rec.width = hr_api.g_number) then
387: p_rec.width := hr_cnp_shd.g_old_rec.width;
388: End If;
389: If (p_rec.x_position = hr_api.g_number) then
390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;
391: End If;

Line 390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;

386: If (p_rec.width = hr_api.g_number) then
387: p_rec.width := hr_cnp_shd.g_old_rec.width;
388: End If;
389: If (p_rec.x_position = hr_api.g_number) then
390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;
391: End If;
392: If (p_rec.y_position = hr_api.g_number) then
393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;
394: End If;

Line 393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;

389: If (p_rec.x_position = hr_api.g_number) then
390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;
391: End If;
392: If (p_rec.y_position = hr_api.g_number) then
393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;
394: End If;
395: If (p_rec.information_category = hr_api.g_varchar2) then
396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;
397: End If;

Line 396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;

392: If (p_rec.y_position = hr_api.g_number) then
393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;
394: End If;
395: If (p_rec.information_category = hr_api.g_varchar2) then
396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;
397: End If;
398: If (p_rec.information1 = hr_api.g_varchar2) then
399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;
400: End If;

Line 399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;

395: If (p_rec.information_category = hr_api.g_varchar2) then
396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;
397: End If;
398: If (p_rec.information1 = hr_api.g_varchar2) then
399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;
400: End If;
401: If (p_rec.information2 = hr_api.g_varchar2) then
402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;
403: End If;

Line 402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;

398: If (p_rec.information1 = hr_api.g_varchar2) then
399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;
400: End If;
401: If (p_rec.information2 = hr_api.g_varchar2) then
402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;
403: End If;
404: If (p_rec.information3 = hr_api.g_varchar2) then
405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;
406: End If;

Line 405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;

401: If (p_rec.information2 = hr_api.g_varchar2) then
402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;
403: End If;
404: If (p_rec.information3 = hr_api.g_varchar2) then
405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;
406: End If;
407: If (p_rec.information4 = hr_api.g_varchar2) then
408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;
409: End If;

Line 408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;

404: If (p_rec.information3 = hr_api.g_varchar2) then
405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;
406: End If;
407: If (p_rec.information4 = hr_api.g_varchar2) then
408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;
409: End If;
410: If (p_rec.information5 = hr_api.g_varchar2) then
411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;
412: End If;

Line 411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;

407: If (p_rec.information4 = hr_api.g_varchar2) then
408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;
409: End If;
410: If (p_rec.information5 = hr_api.g_varchar2) then
411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;
412: End If;
413: If (p_rec.information6 = hr_api.g_varchar2) then
414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;
415: End If;

Line 414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;

410: If (p_rec.information5 = hr_api.g_varchar2) then
411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;
412: End If;
413: If (p_rec.information6 = hr_api.g_varchar2) then
414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;
415: End If;
416: If (p_rec.information7 = hr_api.g_varchar2) then
417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;
418: End If;

Line 417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;

413: If (p_rec.information6 = hr_api.g_varchar2) then
414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;
415: End If;
416: If (p_rec.information7 = hr_api.g_varchar2) then
417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;
418: End If;
419: If (p_rec.information8 = hr_api.g_varchar2) then
420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;
421: End If;

Line 420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;

416: If (p_rec.information7 = hr_api.g_varchar2) then
417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;
418: End If;
419: If (p_rec.information8 = hr_api.g_varchar2) then
420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;
421: End If;
422: If (p_rec.information9 = hr_api.g_varchar2) then
423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;
424: End If;

Line 423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;

419: If (p_rec.information8 = hr_api.g_varchar2) then
420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;
421: End If;
422: If (p_rec.information9 = hr_api.g_varchar2) then
423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;
424: End If;
425: If (p_rec.information10 = hr_api.g_varchar2) then
426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;
427: End If;

Line 426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;

422: If (p_rec.information9 = hr_api.g_varchar2) then
423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;
424: End If;
425: If (p_rec.information10 = hr_api.g_varchar2) then
426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;
427: End If;
428: If (p_rec.information11 = hr_api.g_varchar2) then
429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;
430: End If;

Line 429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;

425: If (p_rec.information10 = hr_api.g_varchar2) then
426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;
427: End If;
428: If (p_rec.information11 = hr_api.g_varchar2) then
429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;
430: End If;
431: If (p_rec.information12 = hr_api.g_varchar2) then
432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;
433: End If;

Line 432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;

428: If (p_rec.information11 = hr_api.g_varchar2) then
429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;
430: End If;
431: If (p_rec.information12 = hr_api.g_varchar2) then
432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;
433: End If;
434: If (p_rec.information13 = hr_api.g_varchar2) then
435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;
436: End If;

Line 435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;

431: If (p_rec.information12 = hr_api.g_varchar2) then
432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;
433: End If;
434: If (p_rec.information13 = hr_api.g_varchar2) then
435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;
436: End If;
437: If (p_rec.information14 = hr_api.g_varchar2) then
438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;
439: End If;

Line 438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;

434: If (p_rec.information13 = hr_api.g_varchar2) then
435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;
436: End If;
437: If (p_rec.information14 = hr_api.g_varchar2) then
438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;
439: End If;
440: If (p_rec.information15 = hr_api.g_varchar2) then
441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;
442: End If;

Line 441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;

437: If (p_rec.information14 = hr_api.g_varchar2) then
438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;
439: End If;
440: If (p_rec.information15 = hr_api.g_varchar2) then
441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;
442: End If;
443: If (p_rec.information16 = hr_api.g_varchar2) then
444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;
445: End If;

Line 444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;

440: If (p_rec.information15 = hr_api.g_varchar2) then
441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;
442: End If;
443: If (p_rec.information16 = hr_api.g_varchar2) then
444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;
445: End If;
446: If (p_rec.information17 = hr_api.g_varchar2) then
447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;
448: End If;

Line 447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;

443: If (p_rec.information16 = hr_api.g_varchar2) then
444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;
445: End If;
446: If (p_rec.information17 = hr_api.g_varchar2) then
447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;
448: End If;
449: If (p_rec.information18 = hr_api.g_varchar2) then
450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;
451: End If;

Line 450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;

446: If (p_rec.information17 = hr_api.g_varchar2) then
447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;
448: End If;
449: If (p_rec.information18 = hr_api.g_varchar2) then
450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;
451: End If;
452: If (p_rec.information19 = hr_api.g_varchar2) then
453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;
454: End If;

Line 453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;

449: If (p_rec.information18 = hr_api.g_varchar2) then
450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;
451: End If;
452: If (p_rec.information19 = hr_api.g_varchar2) then
453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;
454: End If;
455: If (p_rec.information20 = hr_api.g_varchar2) then
456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;
457: End If;

Line 456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;

452: If (p_rec.information19 = hr_api.g_varchar2) then
453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;
454: End If;
455: If (p_rec.information20 = hr_api.g_varchar2) then
456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;
457: End If;
458: If (p_rec.information21 = hr_api.g_varchar2) then
459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;
460: End If;

Line 459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;

455: If (p_rec.information20 = hr_api.g_varchar2) then
456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;
457: End If;
458: If (p_rec.information21 = hr_api.g_varchar2) then
459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;
460: End If;
461: If (p_rec.information22 = hr_api.g_varchar2) then
462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;
463: End If;

Line 462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;

458: If (p_rec.information21 = hr_api.g_varchar2) then
459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;
460: End If;
461: If (p_rec.information22 = hr_api.g_varchar2) then
462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;
463: End If;
464: If (p_rec.information23 = hr_api.g_varchar2) then
465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;
466: End If;

Line 465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;

461: If (p_rec.information22 = hr_api.g_varchar2) then
462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;
463: End If;
464: If (p_rec.information23 = hr_api.g_varchar2) then
465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;
466: End If;
467: If (p_rec.information24 = hr_api.g_varchar2) then
468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;
469: End If;

Line 468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;

464: If (p_rec.information23 = hr_api.g_varchar2) then
465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;
466: End If;
467: If (p_rec.information24 = hr_api.g_varchar2) then
468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;
469: End If;
470: If (p_rec.information25 = hr_api.g_varchar2) then
471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;
472: End If;

Line 471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;

467: If (p_rec.information24 = hr_api.g_varchar2) then
468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;
469: End If;
470: If (p_rec.information25 = hr_api.g_varchar2) then
471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;
475: End If;

Line 474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;

470: If (p_rec.information25 = hr_api.g_varchar2) then
471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;
475: End If;
476: If (p_rec.information27 = hr_api.g_varchar2) then
477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;
478: End If;

Line 477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;

473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;
475: End If;
476: If (p_rec.information27 = hr_api.g_varchar2) then
477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;
478: End If;
479: If (p_rec.information28 = hr_api.g_varchar2) then
480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;
481: End If;

Line 480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;

476: If (p_rec.information27 = hr_api.g_varchar2) then
477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;
478: End If;
479: If (p_rec.information28 = hr_api.g_varchar2) then
480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;
481: End If;
482: If (p_rec.information29 = hr_api.g_varchar2) then
483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;
484: End If;

Line 483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;

479: If (p_rec.information28 = hr_api.g_varchar2) then
480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;
481: End If;
482: If (p_rec.information29 = hr_api.g_varchar2) then
483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;
484: End If;
485: If (p_rec.information30 = hr_api.g_varchar2) then
486: p_rec.information30 := hr_cnp_shd.g_old_rec.information30;
487: End If;

Line 486: p_rec.information30 := hr_cnp_shd.g_old_rec.information30;

482: If (p_rec.information29 = hr_api.g_varchar2) then
483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;
484: End If;
485: If (p_rec.information30 = hr_api.g_varchar2) then
486: p_rec.information30 := hr_cnp_shd.g_old_rec.information30;
487: End If;
488: --
489: End convert_defs;
490: --

Line 496: ,p_rec in out nocopy hr_cnp_shd.g_rec_type

492: -- |---------------------------------< upd >----------------------------------|
493: -- ----------------------------------------------------------------------------
494: Procedure upd
495: (p_effective_date in date
496: ,p_rec in out nocopy hr_cnp_shd.g_rec_type
497: ) is
498: --
499: l_proc varchar2(72) := g_package||'upd';
500: --

Line 506: hr_cnp_shd.lck

502: hr_utility.set_location('Entering:'||l_proc, 5);
503: --
504: -- We must lock the row which we need to update.
505: --
506: hr_cnp_shd.lck
507: (p_rec.canvas_property_id
508: ,p_rec.object_version_number
509: );
510: --

Line 586: l_rec hr_cnp_shd.g_rec_type;

582: ,p_information29 in varchar2 default hr_api.g_varchar2
583: ,p_information30 in varchar2 default hr_api.g_varchar2
584: ) is
585: --
586: l_rec hr_cnp_shd.g_rec_type;
587: l_proc varchar2(72) := g_package||'upd';
588: --
589: Begin
590: hr_utility.set_location('Entering:'||l_proc, 5);

Line 596: hr_cnp_shd.convert_args

592: -- Call conversion function to turn arguments into the
593: -- l_rec structure.
594: --
595: l_rec :=
596: hr_cnp_shd.convert_args
597: (p_canvas_property_id
598: ,p_object_version_number
599: ,p_form_canvas_id
600: ,p_template_canvas_id