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_SHT_UPD dependencies on PER_SHT_SHD

Line 48: Procedure update_dml(p_rec in out nocopy per_sht_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_sht_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 108: per_sht_shd.constraint_error

104: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: per_sht_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_sht_shd.constraint_error

Line 112: per_sht_shd.constraint_error

108: per_sht_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_sht_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_sht_shd.constraint_error

Line 116: per_sht_shd.constraint_error

112: per_sht_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_sht_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: Raise;
120: End update_dml;

Line 154: Procedure pre_update(p_rec in per_sht_shd.g_rec_type) is

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

Line 197: p_effective_date in date,p_rec in per_sht_shd.g_rec_type) is

193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure post_update(
197: p_effective_date in date,p_rec in per_sht_shd.g_rec_type) is
198: --
199: l_proc varchar2(72) := g_package||'post_update';
200: --
201: Begin

Line 250: ,p_business_group_id_o =>per_sht_shd.g_old_rec.business_group_id

246: ,p_information_category =>p_rec.information_category
247: ,p_object_version_number =>p_rec.object_version_number
248: ,p_lookup_type =>p_rec.lookup_type
249: ,p_effective_date =>p_effective_date
250: ,p_business_group_id_o =>per_sht_shd.g_old_rec.business_group_id
251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name
252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1

Line 251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name

247: ,p_object_version_number =>p_rec.object_version_number
248: ,p_lookup_type =>p_rec.lookup_type
249: ,p_effective_date =>p_effective_date
250: ,p_business_group_id_o =>per_sht_shd.g_old_rec.business_group_id
251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name
252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2

Line 252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code

248: ,p_lookup_type =>p_rec.lookup_type
249: ,p_effective_date =>p_effective_date
250: ,p_business_group_id_o =>per_sht_shd.g_old_rec.business_group_id
251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name
252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3

Line 253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd

249: ,p_effective_date =>p_effective_date
250: ,p_business_group_id_o =>per_sht_shd.g_old_rec.business_group_id
251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name
252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4

Line 254: ,p_information1_o =>per_sht_shd.g_old_rec.information1

250: ,p_business_group_id_o =>per_sht_shd.g_old_rec.business_group_id
251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name
252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5

Line 255: ,p_information2_o =>per_sht_shd.g_old_rec.information2

251: ,p_shared_type_name_o =>per_sht_shd.g_old_rec.shared_type_name
252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6

Line 256: ,p_information3_o =>per_sht_shd.g_old_rec.information3

252: ,p_shared_type_code_o =>per_sht_shd.g_old_rec.shared_type_code
253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7

Line 257: ,p_information4_o =>per_sht_shd.g_old_rec.information4

253: ,p_system_type_cd_o =>per_sht_shd.g_old_rec.system_type_cd
254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8

Line 258: ,p_information5_o =>per_sht_shd.g_old_rec.information5

254: ,p_information1_o =>per_sht_shd.g_old_rec.information1
255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9

Line 259: ,p_information6_o =>per_sht_shd.g_old_rec.information6

255: ,p_information2_o =>per_sht_shd.g_old_rec.information2
256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10

Line 260: ,p_information7_o =>per_sht_shd.g_old_rec.information7

256: ,p_information3_o =>per_sht_shd.g_old_rec.information3
257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11

Line 261: ,p_information8_o =>per_sht_shd.g_old_rec.information8

257: ,p_information4_o =>per_sht_shd.g_old_rec.information4
258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12

Line 262: ,p_information9_o =>per_sht_shd.g_old_rec.information9

258: ,p_information5_o =>per_sht_shd.g_old_rec.information5
259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13

Line 263: ,p_information10_o =>per_sht_shd.g_old_rec.information10

259: ,p_information6_o =>per_sht_shd.g_old_rec.information6
260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14

Line 264: ,p_information11_o =>per_sht_shd.g_old_rec.information11

260: ,p_information7_o =>per_sht_shd.g_old_rec.information7
261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15

Line 265: ,p_information12_o =>per_sht_shd.g_old_rec.information12

261: ,p_information8_o =>per_sht_shd.g_old_rec.information8
262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16

Line 266: ,p_information13_o =>per_sht_shd.g_old_rec.information13

262: ,p_information9_o =>per_sht_shd.g_old_rec.information9
263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17

Line 267: ,p_information14_o =>per_sht_shd.g_old_rec.information14

263: ,p_information10_o =>per_sht_shd.g_old_rec.information10
264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18

Line 268: ,p_information15_o =>per_sht_shd.g_old_rec.information15

264: ,p_information11_o =>per_sht_shd.g_old_rec.information11
265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19

Line 269: ,p_information16_o =>per_sht_shd.g_old_rec.information16

265: ,p_information12_o =>per_sht_shd.g_old_rec.information12
266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20

Line 270: ,p_information17_o =>per_sht_shd.g_old_rec.information17

266: ,p_information13_o =>per_sht_shd.g_old_rec.information13
267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21

Line 271: ,p_information18_o =>per_sht_shd.g_old_rec.information18

267: ,p_information14_o =>per_sht_shd.g_old_rec.information14
268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22

Line 272: ,p_information19_o =>per_sht_shd.g_old_rec.information19

268: ,p_information15_o =>per_sht_shd.g_old_rec.information15
269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23

Line 273: ,p_information20_o =>per_sht_shd.g_old_rec.information20

269: ,p_information16_o =>per_sht_shd.g_old_rec.information16
270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24

Line 274: ,p_information21_o =>per_sht_shd.g_old_rec.information21

270: ,p_information17_o =>per_sht_shd.g_old_rec.information17
271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25

Line 275: ,p_information22_o =>per_sht_shd.g_old_rec.information22

271: ,p_information18_o =>per_sht_shd.g_old_rec.information18
272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26

Line 276: ,p_information23_o =>per_sht_shd.g_old_rec.information23

272: ,p_information19_o =>per_sht_shd.g_old_rec.information19
273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27

Line 277: ,p_information24_o =>per_sht_shd.g_old_rec.information24

273: ,p_information20_o =>per_sht_shd.g_old_rec.information20
274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28

Line 278: ,p_information25_o =>per_sht_shd.g_old_rec.information25

274: ,p_information21_o =>per_sht_shd.g_old_rec.information21
275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29

Line 279: ,p_information26_o =>per_sht_shd.g_old_rec.information26

275: ,p_information22_o =>per_sht_shd.g_old_rec.information22
276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30

Line 280: ,p_information27_o =>per_sht_shd.g_old_rec.information27

276: ,p_information23_o =>per_sht_shd.g_old_rec.information23
277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category

Line 281: ,p_information28_o =>per_sht_shd.g_old_rec.information28

277: ,p_information24_o =>per_sht_shd.g_old_rec.information24
278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category
285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number

Line 282: ,p_information29_o =>per_sht_shd.g_old_rec.information29

278: ,p_information25_o =>per_sht_shd.g_old_rec.information25
279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category
285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number
286: ,p_lookup_type_o =>per_sht_shd.g_old_rec.lookup_type

Line 283: ,p_information30_o =>per_sht_shd.g_old_rec.information30

279: ,p_information26_o =>per_sht_shd.g_old_rec.information26
280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category
285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number
286: ,p_lookup_type_o =>per_sht_shd.g_old_rec.lookup_type
287: );

Line 284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category

280: ,p_information27_o =>per_sht_shd.g_old_rec.information27
281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category
285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number
286: ,p_lookup_type_o =>per_sht_shd.g_old_rec.lookup_type
287: );
288: --

Line 285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number

281: ,p_information28_o =>per_sht_shd.g_old_rec.information28
282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category
285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number
286: ,p_lookup_type_o =>per_sht_shd.g_old_rec.lookup_type
287: );
288: --
289: exception

Line 286: ,p_lookup_type_o =>per_sht_shd.g_old_rec.lookup_type

282: ,p_information29_o =>per_sht_shd.g_old_rec.information29
283: ,p_information30_o =>per_sht_shd.g_old_rec.information30
284: ,p_information_category_o =>per_sht_shd.g_old_rec.information_category
285: ,p_object_version_number_o =>per_sht_shd.g_old_rec.object_version_number
286: ,p_lookup_type_o =>per_sht_shd.g_old_rec.lookup_type
287: );
288: --
289: exception
290: --

Line 348: Procedure convert_defs(p_rec in out nocopy per_sht_shd.g_rec_type) is

344: -- Internal Row Handler Use Only.
345: --
346: -- {End Of Comments}
347: -- ----------------------------------------------------------------------------
348: Procedure convert_defs(p_rec in out nocopy per_sht_shd.g_rec_type) is
349: --
350: l_proc varchar2(72) := g_package||'convert_defs';
351: --
352: Begin

Line 363: per_sht_shd.g_old_rec.business_group_id;

359: -- is being used then we must set to the 'current' argument value.
360: --
361: If (p_rec.business_group_id = hr_api.g_number) then
362: p_rec.business_group_id :=
363: per_sht_shd.g_old_rec.business_group_id;
364: End If;
365: If (p_rec.shared_type_name = hr_api.g_varchar2) then
366: p_rec.shared_type_name :=
367: per_sht_shd.g_old_rec.shared_type_name;

Line 367: per_sht_shd.g_old_rec.shared_type_name;

363: per_sht_shd.g_old_rec.business_group_id;
364: End If;
365: If (p_rec.shared_type_name = hr_api.g_varchar2) then
366: p_rec.shared_type_name :=
367: per_sht_shd.g_old_rec.shared_type_name;
368: End If;
369: If (p_rec.shared_type_code = hr_api.g_varchar2) then
370: p_rec.shared_type_code :=
371: per_sht_shd.g_old_rec.shared_type_code;

Line 371: per_sht_shd.g_old_rec.shared_type_code;

367: per_sht_shd.g_old_rec.shared_type_name;
368: End If;
369: If (p_rec.shared_type_code = hr_api.g_varchar2) then
370: p_rec.shared_type_code :=
371: per_sht_shd.g_old_rec.shared_type_code;
372: End If;
373: If (p_rec.system_type_cd = hr_api.g_varchar2) then
374: p_rec.system_type_cd :=
375: per_sht_shd.g_old_rec.system_type_cd;

Line 375: per_sht_shd.g_old_rec.system_type_cd;

371: per_sht_shd.g_old_rec.shared_type_code;
372: End If;
373: If (p_rec.system_type_cd = hr_api.g_varchar2) then
374: p_rec.system_type_cd :=
375: per_sht_shd.g_old_rec.system_type_cd;
376: End If;
377: If (p_rec.information1 = hr_api.g_varchar2) then
378: p_rec.information1 :=
379: per_sht_shd.g_old_rec.information1;

Line 379: per_sht_shd.g_old_rec.information1;

375: per_sht_shd.g_old_rec.system_type_cd;
376: End If;
377: If (p_rec.information1 = hr_api.g_varchar2) then
378: p_rec.information1 :=
379: per_sht_shd.g_old_rec.information1;
380: End If;
381: If (p_rec.information2 = hr_api.g_varchar2) then
382: p_rec.information2 :=
383: per_sht_shd.g_old_rec.information2;

Line 383: per_sht_shd.g_old_rec.information2;

379: per_sht_shd.g_old_rec.information1;
380: End If;
381: If (p_rec.information2 = hr_api.g_varchar2) then
382: p_rec.information2 :=
383: per_sht_shd.g_old_rec.information2;
384: End If;
385: If (p_rec.information3 = hr_api.g_varchar2) then
386: p_rec.information3 :=
387: per_sht_shd.g_old_rec.information3;

Line 387: per_sht_shd.g_old_rec.information3;

383: per_sht_shd.g_old_rec.information2;
384: End If;
385: If (p_rec.information3 = hr_api.g_varchar2) then
386: p_rec.information3 :=
387: per_sht_shd.g_old_rec.information3;
388: End If;
389: If (p_rec.information4 = hr_api.g_varchar2) then
390: p_rec.information4 :=
391: per_sht_shd.g_old_rec.information4;

Line 391: per_sht_shd.g_old_rec.information4;

387: per_sht_shd.g_old_rec.information3;
388: End If;
389: If (p_rec.information4 = hr_api.g_varchar2) then
390: p_rec.information4 :=
391: per_sht_shd.g_old_rec.information4;
392: End If;
393: If (p_rec.information5 = hr_api.g_varchar2) then
394: p_rec.information5 :=
395: per_sht_shd.g_old_rec.information5;

Line 395: per_sht_shd.g_old_rec.information5;

391: per_sht_shd.g_old_rec.information4;
392: End If;
393: If (p_rec.information5 = hr_api.g_varchar2) then
394: p_rec.information5 :=
395: per_sht_shd.g_old_rec.information5;
396: End If;
397: If (p_rec.information6 = hr_api.g_varchar2) then
398: p_rec.information6 :=
399: per_sht_shd.g_old_rec.information6;

Line 399: per_sht_shd.g_old_rec.information6;

395: per_sht_shd.g_old_rec.information5;
396: End If;
397: If (p_rec.information6 = hr_api.g_varchar2) then
398: p_rec.information6 :=
399: per_sht_shd.g_old_rec.information6;
400: End If;
401: If (p_rec.information7 = hr_api.g_varchar2) then
402: p_rec.information7 :=
403: per_sht_shd.g_old_rec.information7;

Line 403: per_sht_shd.g_old_rec.information7;

399: per_sht_shd.g_old_rec.information6;
400: End If;
401: If (p_rec.information7 = hr_api.g_varchar2) then
402: p_rec.information7 :=
403: per_sht_shd.g_old_rec.information7;
404: End If;
405: If (p_rec.information8 = hr_api.g_varchar2) then
406: p_rec.information8 :=
407: per_sht_shd.g_old_rec.information8;

Line 407: per_sht_shd.g_old_rec.information8;

403: per_sht_shd.g_old_rec.information7;
404: End If;
405: If (p_rec.information8 = hr_api.g_varchar2) then
406: p_rec.information8 :=
407: per_sht_shd.g_old_rec.information8;
408: End If;
409: If (p_rec.information9 = hr_api.g_varchar2) then
410: p_rec.information9 :=
411: per_sht_shd.g_old_rec.information9;

Line 411: per_sht_shd.g_old_rec.information9;

407: per_sht_shd.g_old_rec.information8;
408: End If;
409: If (p_rec.information9 = hr_api.g_varchar2) then
410: p_rec.information9 :=
411: per_sht_shd.g_old_rec.information9;
412: End If;
413: If (p_rec.information10 = hr_api.g_varchar2) then
414: p_rec.information10 :=
415: per_sht_shd.g_old_rec.information10;

Line 415: per_sht_shd.g_old_rec.information10;

411: per_sht_shd.g_old_rec.information9;
412: End If;
413: If (p_rec.information10 = hr_api.g_varchar2) then
414: p_rec.information10 :=
415: per_sht_shd.g_old_rec.information10;
416: End If;
417: If (p_rec.information11 = hr_api.g_varchar2) then
418: p_rec.information11 :=
419: per_sht_shd.g_old_rec.information11;

Line 419: per_sht_shd.g_old_rec.information11;

415: per_sht_shd.g_old_rec.information10;
416: End If;
417: If (p_rec.information11 = hr_api.g_varchar2) then
418: p_rec.information11 :=
419: per_sht_shd.g_old_rec.information11;
420: End If;
421: If (p_rec.information12 = hr_api.g_varchar2) then
422: p_rec.information12 :=
423: per_sht_shd.g_old_rec.information12;

Line 423: per_sht_shd.g_old_rec.information12;

419: per_sht_shd.g_old_rec.information11;
420: End If;
421: If (p_rec.information12 = hr_api.g_varchar2) then
422: p_rec.information12 :=
423: per_sht_shd.g_old_rec.information12;
424: End If;
425: If (p_rec.information13 = hr_api.g_varchar2) then
426: p_rec.information13 :=
427: per_sht_shd.g_old_rec.information13;

Line 427: per_sht_shd.g_old_rec.information13;

423: per_sht_shd.g_old_rec.information12;
424: End If;
425: If (p_rec.information13 = hr_api.g_varchar2) then
426: p_rec.information13 :=
427: per_sht_shd.g_old_rec.information13;
428: End If;
429: If (p_rec.information14 = hr_api.g_varchar2) then
430: p_rec.information14 :=
431: per_sht_shd.g_old_rec.information14;

Line 431: per_sht_shd.g_old_rec.information14;

427: per_sht_shd.g_old_rec.information13;
428: End If;
429: If (p_rec.information14 = hr_api.g_varchar2) then
430: p_rec.information14 :=
431: per_sht_shd.g_old_rec.information14;
432: End If;
433: If (p_rec.information15 = hr_api.g_varchar2) then
434: p_rec.information15 :=
435: per_sht_shd.g_old_rec.information15;

Line 435: per_sht_shd.g_old_rec.information15;

431: per_sht_shd.g_old_rec.information14;
432: End If;
433: If (p_rec.information15 = hr_api.g_varchar2) then
434: p_rec.information15 :=
435: per_sht_shd.g_old_rec.information15;
436: End If;
437: If (p_rec.information16 = hr_api.g_varchar2) then
438: p_rec.information16 :=
439: per_sht_shd.g_old_rec.information16;

Line 439: per_sht_shd.g_old_rec.information16;

435: per_sht_shd.g_old_rec.information15;
436: End If;
437: If (p_rec.information16 = hr_api.g_varchar2) then
438: p_rec.information16 :=
439: per_sht_shd.g_old_rec.information16;
440: End If;
441: If (p_rec.information17 = hr_api.g_varchar2) then
442: p_rec.information17 :=
443: per_sht_shd.g_old_rec.information17;

Line 443: per_sht_shd.g_old_rec.information17;

439: per_sht_shd.g_old_rec.information16;
440: End If;
441: If (p_rec.information17 = hr_api.g_varchar2) then
442: p_rec.information17 :=
443: per_sht_shd.g_old_rec.information17;
444: End If;
445: If (p_rec.information18 = hr_api.g_varchar2) then
446: p_rec.information18 :=
447: per_sht_shd.g_old_rec.information18;

Line 447: per_sht_shd.g_old_rec.information18;

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

Line 451: per_sht_shd.g_old_rec.information19;

447: per_sht_shd.g_old_rec.information18;
448: End If;
449: If (p_rec.information19 = hr_api.g_varchar2) then
450: p_rec.information19 :=
451: per_sht_shd.g_old_rec.information19;
452: End If;
453: If (p_rec.information20 = hr_api.g_varchar2) then
454: p_rec.information20 :=
455: per_sht_shd.g_old_rec.information20;

Line 455: per_sht_shd.g_old_rec.information20;

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

Line 459: per_sht_shd.g_old_rec.information21;

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

Line 463: per_sht_shd.g_old_rec.information22;

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

Line 467: per_sht_shd.g_old_rec.information23;

463: per_sht_shd.g_old_rec.information22;
464: End If;
465: If (p_rec.information23 = hr_api.g_varchar2) then
466: p_rec.information23 :=
467: per_sht_shd.g_old_rec.information23;
468: End If;
469: If (p_rec.information24 = hr_api.g_varchar2) then
470: p_rec.information24 :=
471: per_sht_shd.g_old_rec.information24;

Line 471: per_sht_shd.g_old_rec.information24;

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

Line 475: per_sht_shd.g_old_rec.information25;

471: per_sht_shd.g_old_rec.information24;
472: End If;
473: If (p_rec.information25 = hr_api.g_varchar2) then
474: p_rec.information25 :=
475: per_sht_shd.g_old_rec.information25;
476: End If;
477: If (p_rec.information26 = hr_api.g_varchar2) then
478: p_rec.information26 :=
479: per_sht_shd.g_old_rec.information26;

Line 479: per_sht_shd.g_old_rec.information26;

475: per_sht_shd.g_old_rec.information25;
476: End If;
477: If (p_rec.information26 = hr_api.g_varchar2) then
478: p_rec.information26 :=
479: per_sht_shd.g_old_rec.information26;
480: End If;
481: If (p_rec.information27 = hr_api.g_varchar2) then
482: p_rec.information27 :=
483: per_sht_shd.g_old_rec.information27;

Line 483: per_sht_shd.g_old_rec.information27;

479: per_sht_shd.g_old_rec.information26;
480: End If;
481: If (p_rec.information27 = hr_api.g_varchar2) then
482: p_rec.information27 :=
483: per_sht_shd.g_old_rec.information27;
484: End If;
485: If (p_rec.information28 = hr_api.g_varchar2) then
486: p_rec.information28 :=
487: per_sht_shd.g_old_rec.information28;

Line 487: per_sht_shd.g_old_rec.information28;

483: per_sht_shd.g_old_rec.information27;
484: End If;
485: If (p_rec.information28 = hr_api.g_varchar2) then
486: p_rec.information28 :=
487: per_sht_shd.g_old_rec.information28;
488: End If;
489: If (p_rec.information29 = hr_api.g_varchar2) then
490: p_rec.information29 :=
491: per_sht_shd.g_old_rec.information29;

Line 491: per_sht_shd.g_old_rec.information29;

487: per_sht_shd.g_old_rec.information28;
488: End If;
489: If (p_rec.information29 = hr_api.g_varchar2) then
490: p_rec.information29 :=
491: per_sht_shd.g_old_rec.information29;
492: End If;
493: If (p_rec.information30 = hr_api.g_varchar2) then
494: p_rec.information30 :=
495: per_sht_shd.g_old_rec.information30;

Line 495: per_sht_shd.g_old_rec.information30;

491: per_sht_shd.g_old_rec.information29;
492: End If;
493: If (p_rec.information30 = hr_api.g_varchar2) then
494: p_rec.information30 :=
495: per_sht_shd.g_old_rec.information30;
496: End If;
497: If (p_rec.information_category = hr_api.g_varchar2) then
498: p_rec.information_category :=
499: per_sht_shd.g_old_rec.information_category;

Line 499: per_sht_shd.g_old_rec.information_category;

495: per_sht_shd.g_old_rec.information30;
496: End If;
497: If (p_rec.information_category = hr_api.g_varchar2) then
498: p_rec.information_category :=
499: per_sht_shd.g_old_rec.information_category;
500: End If;
501: If (p_rec.lookup_type = hr_api.g_varchar2) then
502: p_rec.lookup_type :=
503: per_sht_shd.g_old_rec.lookup_type;

Line 503: per_sht_shd.g_old_rec.lookup_type;

499: per_sht_shd.g_old_rec.information_category;
500: End If;
501: If (p_rec.lookup_type = hr_api.g_varchar2) then
502: p_rec.lookup_type :=
503: per_sht_shd.g_old_rec.lookup_type;
504: End If;
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: --

Line 516: p_rec in out nocopy per_sht_shd.g_rec_type

512: -- ----------------------------------------------------------------------------
513: Procedure upd
514: (
515: p_effective_date in date,
516: p_rec in out nocopy per_sht_shd.g_rec_type
517: ) is
518: --
519: l_proc varchar2(72) := g_package||'upd';
520: --

Line 526: per_sht_shd.lck

522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- We must lock the row which we need to update.
525: --
526: per_sht_shd.lck
527: (
528: p_rec.shared_type_id,
529: p_rec.object_version_number
530: );

Line 602: l_rec per_sht_shd.g_rec_type;

598: p_object_version_number in out nocopy number,
599: p_lookup_type in varchar2 default hr_api.g_varchar2
600: ) is
601: --
602: l_rec per_sht_shd.g_rec_type;
603: l_proc varchar2(72) := g_package||'upd';
604: --
605: Begin
606: hr_utility.set_location('Entering:'||l_proc, 5);

Line 612: per_sht_shd.convert_args

608: -- Call conversion function to turn arguments into the
609: -- l_rec structure.
610: --
611: l_rec :=
612: per_sht_shd.convert_args
613: (
614: p_shared_type_id,
615: p_business_group_id,
616: p_shared_type_name,