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.

[Home] [Help]

APPS.PER_PHN_UPD dependencies on PER_PHN_SHD

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

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

Line 111: per_phn_shd.constraint_error

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

Line 115: per_phn_shd.constraint_error

111: per_phn_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: per_phn_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_phn_shd.constraint_error

Line 119: per_phn_shd.constraint_error

115: per_phn_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_phn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: Raise;
123: End update_dml;

Line 157: Procedure pre_update(p_rec in per_phn_shd.g_rec_type) is

153: -- Internal Table Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure pre_update(p_rec in per_phn_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin

Line 199: Procedure post_update(p_rec in per_phn_shd.g_rec_type,

195: -- Internal Table Handler Use Only.
196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_update(p_rec in per_phn_shd.g_rec_type,
200: p_effective_date in date ) is
201: --
202: l_proc varchar2(72) := g_package||'post_update';
203: --

Line 253: ,p_date_from_o => per_phn_shd.g_old_rec.date_from

249: ,p_attribute30 => p_rec.attribute30
250: ,p_party_id => p_rec.party_id -- HR/TCA merge
251: ,p_validity => p_rec.validity
252: ,p_object_version_number => p_rec.object_version_number
253: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id

Line 254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to

250: ,p_party_id => p_rec.party_id -- HR/TCA merge
251: ,p_validity => p_rec.validity
252: ,p_object_version_number => p_rec.object_version_number
253: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table

Line 255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type

251: ,p_validity => p_rec.validity
252: ,p_object_version_number => p_rec.object_version_number
253: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category

Line 256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number

252: ,p_object_version_number => p_rec.object_version_number
253: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1

Line 257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id

253: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2

Line 258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table

254: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3

Line 259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category

255: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4

Line 260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1

256: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5

Line 261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2

257: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6

Line 262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3

258: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7

Line 263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4

259: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8

Line 264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5

260: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9

Line 265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6

261: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10

Line 266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7

262: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11

Line 267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8

263: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12

Line 268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9

264: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13

Line 269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10

265: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14

Line 270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11

266: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15

Line 271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12

267: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16

Line 272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13

268: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17

Line 273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14

269: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18

Line 274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15

270: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19

Line 275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16

271: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20

Line 276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17

272: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21

Line 277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18

273: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22

Line 278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19

274: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23

Line 279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20

275: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24

Line 280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21

276: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25

Line 281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22

277: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26

Line 282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23

278: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27

Line 283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24

279: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28

Line 284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25

280: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29

Line 285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26

281: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30

Line 286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27

282: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge

Line 287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28

283: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
291: ,p_validity_o => per_phn_shd.g_old_rec.validity

Line 288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29

284: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
291: ,p_validity_o => per_phn_shd.g_old_rec.validity
292: ,p_object_version_number_o

Line 289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30

285: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
291: ,p_validity_o => per_phn_shd.g_old_rec.validity
292: ,p_object_version_number_o
293: => per_phn_shd.g_old_rec.object_version_number

Line 290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge

286: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
291: ,p_validity_o => per_phn_shd.g_old_rec.validity
292: ,p_object_version_number_o
293: => per_phn_shd.g_old_rec.object_version_number
294: ,p_effective_date => p_effective_date

Line 291: ,p_validity_o => per_phn_shd.g_old_rec.validity

287: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
288: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
291: ,p_validity_o => per_phn_shd.g_old_rec.validity
292: ,p_object_version_number_o
293: => per_phn_shd.g_old_rec.object_version_number
294: ,p_effective_date => p_effective_date
295: );

Line 293: => per_phn_shd.g_old_rec.object_version_number

289: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
290: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
291: ,p_validity_o => per_phn_shd.g_old_rec.validity
292: ,p_object_version_number_o
293: => per_phn_shd.g_old_rec.object_version_number
294: ,p_effective_date => p_effective_date
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then

Line 352: Procedure convert_defs(p_rec in out nocopy per_phn_shd.g_rec_type) is

348: -- Internal Table Handler Use Only.
349: --
350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure convert_defs(p_rec in out nocopy per_phn_shd.g_rec_type) is
353: --
354: l_proc varchar2(72) := g_package||'convert_defs';
355: --
356: Begin

Line 367: per_phn_shd.g_old_rec.date_from;

363: -- is being used then we must set to the 'current' argument value.
364: --
365: If (p_rec.date_from = hr_api.g_date) then
366: p_rec.date_from :=
367: per_phn_shd.g_old_rec.date_from;
368: End If;
369: If (p_rec.date_to = hr_api.g_date) then
370: p_rec.date_to :=
371: per_phn_shd.g_old_rec.date_to;

Line 371: per_phn_shd.g_old_rec.date_to;

367: per_phn_shd.g_old_rec.date_from;
368: End If;
369: If (p_rec.date_to = hr_api.g_date) then
370: p_rec.date_to :=
371: per_phn_shd.g_old_rec.date_to;
372: End If;
373: If (p_rec.phone_type = hr_api.g_varchar2) then
374: p_rec.phone_type :=
375: per_phn_shd.g_old_rec.phone_type;

Line 375: per_phn_shd.g_old_rec.phone_type;

371: per_phn_shd.g_old_rec.date_to;
372: End If;
373: If (p_rec.phone_type = hr_api.g_varchar2) then
374: p_rec.phone_type :=
375: per_phn_shd.g_old_rec.phone_type;
376: End If;
377: If (p_rec.phone_number = hr_api.g_varchar2) then
378: p_rec.phone_number :=
379: per_phn_shd.g_old_rec.phone_number;

Line 379: per_phn_shd.g_old_rec.phone_number;

375: per_phn_shd.g_old_rec.phone_type;
376: End If;
377: If (p_rec.phone_number = hr_api.g_varchar2) then
378: p_rec.phone_number :=
379: per_phn_shd.g_old_rec.phone_number;
380: End If;
381: If (p_rec.parent_id = hr_api.g_number) then
382: p_rec.parent_id :=
383: per_phn_shd.g_old_rec.parent_id;

Line 383: per_phn_shd.g_old_rec.parent_id;

379: per_phn_shd.g_old_rec.phone_number;
380: End If;
381: If (p_rec.parent_id = hr_api.g_number) then
382: p_rec.parent_id :=
383: per_phn_shd.g_old_rec.parent_id;
384: End If;
385: If (p_rec.parent_table = hr_api.g_varchar2) then
386: p_rec.parent_table :=
387: per_phn_shd.g_old_rec.parent_table;

Line 387: per_phn_shd.g_old_rec.parent_table;

383: per_phn_shd.g_old_rec.parent_id;
384: End If;
385: If (p_rec.parent_table = hr_api.g_varchar2) then
386: p_rec.parent_table :=
387: per_phn_shd.g_old_rec.parent_table;
388: End If;
389: If (p_rec.attribute_category = hr_api.g_varchar2) then
390: p_rec.attribute_category :=
391: per_phn_shd.g_old_rec.attribute_category;

Line 391: per_phn_shd.g_old_rec.attribute_category;

387: per_phn_shd.g_old_rec.parent_table;
388: End If;
389: If (p_rec.attribute_category = hr_api.g_varchar2) then
390: p_rec.attribute_category :=
391: per_phn_shd.g_old_rec.attribute_category;
392: End If;
393: If (p_rec.attribute1 = hr_api.g_varchar2) then
394: p_rec.attribute1 :=
395: per_phn_shd.g_old_rec.attribute1;

Line 395: per_phn_shd.g_old_rec.attribute1;

391: per_phn_shd.g_old_rec.attribute_category;
392: End If;
393: If (p_rec.attribute1 = hr_api.g_varchar2) then
394: p_rec.attribute1 :=
395: per_phn_shd.g_old_rec.attribute1;
396: End If;
397: If (p_rec.attribute2 = hr_api.g_varchar2) then
398: p_rec.attribute2 :=
399: per_phn_shd.g_old_rec.attribute2;

Line 399: per_phn_shd.g_old_rec.attribute2;

395: per_phn_shd.g_old_rec.attribute1;
396: End If;
397: If (p_rec.attribute2 = hr_api.g_varchar2) then
398: p_rec.attribute2 :=
399: per_phn_shd.g_old_rec.attribute2;
400: End If;
401: If (p_rec.attribute3 = hr_api.g_varchar2) then
402: p_rec.attribute3 :=
403: per_phn_shd.g_old_rec.attribute3;

Line 403: per_phn_shd.g_old_rec.attribute3;

399: per_phn_shd.g_old_rec.attribute2;
400: End If;
401: If (p_rec.attribute3 = hr_api.g_varchar2) then
402: p_rec.attribute3 :=
403: per_phn_shd.g_old_rec.attribute3;
404: End If;
405: If (p_rec.attribute4 = hr_api.g_varchar2) then
406: p_rec.attribute4 :=
407: per_phn_shd.g_old_rec.attribute4;

Line 407: per_phn_shd.g_old_rec.attribute4;

403: per_phn_shd.g_old_rec.attribute3;
404: End If;
405: If (p_rec.attribute4 = hr_api.g_varchar2) then
406: p_rec.attribute4 :=
407: per_phn_shd.g_old_rec.attribute4;
408: End If;
409: If (p_rec.attribute5 = hr_api.g_varchar2) then
410: p_rec.attribute5 :=
411: per_phn_shd.g_old_rec.attribute5;

Line 411: per_phn_shd.g_old_rec.attribute5;

407: per_phn_shd.g_old_rec.attribute4;
408: End If;
409: If (p_rec.attribute5 = hr_api.g_varchar2) then
410: p_rec.attribute5 :=
411: per_phn_shd.g_old_rec.attribute5;
412: End If;
413: If (p_rec.attribute6 = hr_api.g_varchar2) then
414: p_rec.attribute6 :=
415: per_phn_shd.g_old_rec.attribute6;

Line 415: per_phn_shd.g_old_rec.attribute6;

411: per_phn_shd.g_old_rec.attribute5;
412: End If;
413: If (p_rec.attribute6 = hr_api.g_varchar2) then
414: p_rec.attribute6 :=
415: per_phn_shd.g_old_rec.attribute6;
416: End If;
417: If (p_rec.attribute7 = hr_api.g_varchar2) then
418: p_rec.attribute7 :=
419: per_phn_shd.g_old_rec.attribute7;

Line 419: per_phn_shd.g_old_rec.attribute7;

415: per_phn_shd.g_old_rec.attribute6;
416: End If;
417: If (p_rec.attribute7 = hr_api.g_varchar2) then
418: p_rec.attribute7 :=
419: per_phn_shd.g_old_rec.attribute7;
420: End If;
421: If (p_rec.attribute8 = hr_api.g_varchar2) then
422: p_rec.attribute8 :=
423: per_phn_shd.g_old_rec.attribute8;

Line 423: per_phn_shd.g_old_rec.attribute8;

419: per_phn_shd.g_old_rec.attribute7;
420: End If;
421: If (p_rec.attribute8 = hr_api.g_varchar2) then
422: p_rec.attribute8 :=
423: per_phn_shd.g_old_rec.attribute8;
424: End If;
425: If (p_rec.attribute9 = hr_api.g_varchar2) then
426: p_rec.attribute9 :=
427: per_phn_shd.g_old_rec.attribute9;

Line 427: per_phn_shd.g_old_rec.attribute9;

423: per_phn_shd.g_old_rec.attribute8;
424: End If;
425: If (p_rec.attribute9 = hr_api.g_varchar2) then
426: p_rec.attribute9 :=
427: per_phn_shd.g_old_rec.attribute9;
428: End If;
429: If (p_rec.attribute10 = hr_api.g_varchar2) then
430: p_rec.attribute10 :=
431: per_phn_shd.g_old_rec.attribute10;

Line 431: per_phn_shd.g_old_rec.attribute10;

427: per_phn_shd.g_old_rec.attribute9;
428: End If;
429: If (p_rec.attribute10 = hr_api.g_varchar2) then
430: p_rec.attribute10 :=
431: per_phn_shd.g_old_rec.attribute10;
432: End If;
433: If (p_rec.attribute11 = hr_api.g_varchar2) then
434: p_rec.attribute11 :=
435: per_phn_shd.g_old_rec.attribute11;

Line 435: per_phn_shd.g_old_rec.attribute11;

431: per_phn_shd.g_old_rec.attribute10;
432: End If;
433: If (p_rec.attribute11 = hr_api.g_varchar2) then
434: p_rec.attribute11 :=
435: per_phn_shd.g_old_rec.attribute11;
436: End If;
437: If (p_rec.attribute12 = hr_api.g_varchar2) then
438: p_rec.attribute12 :=
439: per_phn_shd.g_old_rec.attribute12;

Line 439: per_phn_shd.g_old_rec.attribute12;

435: per_phn_shd.g_old_rec.attribute11;
436: End If;
437: If (p_rec.attribute12 = hr_api.g_varchar2) then
438: p_rec.attribute12 :=
439: per_phn_shd.g_old_rec.attribute12;
440: End If;
441: If (p_rec.attribute13 = hr_api.g_varchar2) then
442: p_rec.attribute13 :=
443: per_phn_shd.g_old_rec.attribute13;

Line 443: per_phn_shd.g_old_rec.attribute13;

439: per_phn_shd.g_old_rec.attribute12;
440: End If;
441: If (p_rec.attribute13 = hr_api.g_varchar2) then
442: p_rec.attribute13 :=
443: per_phn_shd.g_old_rec.attribute13;
444: End If;
445: If (p_rec.attribute14 = hr_api.g_varchar2) then
446: p_rec.attribute14 :=
447: per_phn_shd.g_old_rec.attribute14;

Line 447: per_phn_shd.g_old_rec.attribute14;

443: per_phn_shd.g_old_rec.attribute13;
444: End If;
445: If (p_rec.attribute14 = hr_api.g_varchar2) then
446: p_rec.attribute14 :=
447: per_phn_shd.g_old_rec.attribute14;
448: End If;
449: If (p_rec.attribute15 = hr_api.g_varchar2) then
450: p_rec.attribute15 :=
451: per_phn_shd.g_old_rec.attribute15;

Line 451: per_phn_shd.g_old_rec.attribute15;

447: per_phn_shd.g_old_rec.attribute14;
448: End If;
449: If (p_rec.attribute15 = hr_api.g_varchar2) then
450: p_rec.attribute15 :=
451: per_phn_shd.g_old_rec.attribute15;
452: End If;
453: If (p_rec.attribute16 = hr_api.g_varchar2) then
454: p_rec.attribute16 :=
455: per_phn_shd.g_old_rec.attribute16;

Line 455: per_phn_shd.g_old_rec.attribute16;

451: per_phn_shd.g_old_rec.attribute15;
452: End If;
453: If (p_rec.attribute16 = hr_api.g_varchar2) then
454: p_rec.attribute16 :=
455: per_phn_shd.g_old_rec.attribute16;
456: End If;
457: If (p_rec.attribute17 = hr_api.g_varchar2) then
458: p_rec.attribute17 :=
459: per_phn_shd.g_old_rec.attribute17;

Line 459: per_phn_shd.g_old_rec.attribute17;

455: per_phn_shd.g_old_rec.attribute16;
456: End If;
457: If (p_rec.attribute17 = hr_api.g_varchar2) then
458: p_rec.attribute17 :=
459: per_phn_shd.g_old_rec.attribute17;
460: End If;
461: If (p_rec.attribute18 = hr_api.g_varchar2) then
462: p_rec.attribute18 :=
463: per_phn_shd.g_old_rec.attribute18;

Line 463: per_phn_shd.g_old_rec.attribute18;

459: per_phn_shd.g_old_rec.attribute17;
460: End If;
461: If (p_rec.attribute18 = hr_api.g_varchar2) then
462: p_rec.attribute18 :=
463: per_phn_shd.g_old_rec.attribute18;
464: End If;
465: If (p_rec.attribute19 = hr_api.g_varchar2) then
466: p_rec.attribute19 :=
467: per_phn_shd.g_old_rec.attribute19;

Line 467: per_phn_shd.g_old_rec.attribute19;

463: per_phn_shd.g_old_rec.attribute18;
464: End If;
465: If (p_rec.attribute19 = hr_api.g_varchar2) then
466: p_rec.attribute19 :=
467: per_phn_shd.g_old_rec.attribute19;
468: End If;
469: If (p_rec.attribute20 = hr_api.g_varchar2) then
470: p_rec.attribute20 :=
471: per_phn_shd.g_old_rec.attribute20;

Line 471: per_phn_shd.g_old_rec.attribute20;

467: per_phn_shd.g_old_rec.attribute19;
468: End If;
469: If (p_rec.attribute20 = hr_api.g_varchar2) then
470: p_rec.attribute20 :=
471: per_phn_shd.g_old_rec.attribute20;
472: End If;
473: If (p_rec.attribute21 = hr_api.g_varchar2) then
474: p_rec.attribute21 :=
475: per_phn_shd.g_old_rec.attribute21;

Line 475: per_phn_shd.g_old_rec.attribute21;

471: per_phn_shd.g_old_rec.attribute20;
472: End If;
473: If (p_rec.attribute21 = hr_api.g_varchar2) then
474: p_rec.attribute21 :=
475: per_phn_shd.g_old_rec.attribute21;
476: End If;
477: If (p_rec.attribute22 = hr_api.g_varchar2) then
478: p_rec.attribute22 :=
479: per_phn_shd.g_old_rec.attribute22;

Line 479: per_phn_shd.g_old_rec.attribute22;

475: per_phn_shd.g_old_rec.attribute21;
476: End If;
477: If (p_rec.attribute22 = hr_api.g_varchar2) then
478: p_rec.attribute22 :=
479: per_phn_shd.g_old_rec.attribute22;
480: End If;
481: If (p_rec.attribute23 = hr_api.g_varchar2) then
482: p_rec.attribute23 :=
483: per_phn_shd.g_old_rec.attribute23;

Line 483: per_phn_shd.g_old_rec.attribute23;

479: per_phn_shd.g_old_rec.attribute22;
480: End If;
481: If (p_rec.attribute23 = hr_api.g_varchar2) then
482: p_rec.attribute23 :=
483: per_phn_shd.g_old_rec.attribute23;
484: End If;
485: If (p_rec.attribute24 = hr_api.g_varchar2) then
486: p_rec.attribute24 :=
487: per_phn_shd.g_old_rec.attribute24;

Line 487: per_phn_shd.g_old_rec.attribute24;

483: per_phn_shd.g_old_rec.attribute23;
484: End If;
485: If (p_rec.attribute24 = hr_api.g_varchar2) then
486: p_rec.attribute24 :=
487: per_phn_shd.g_old_rec.attribute24;
488: End If;
489: If (p_rec.attribute25 = hr_api.g_varchar2) then
490: p_rec.attribute25 :=
491: per_phn_shd.g_old_rec.attribute25;

Line 491: per_phn_shd.g_old_rec.attribute25;

487: per_phn_shd.g_old_rec.attribute24;
488: End If;
489: If (p_rec.attribute25 = hr_api.g_varchar2) then
490: p_rec.attribute25 :=
491: per_phn_shd.g_old_rec.attribute25;
492: End If;
493: If (p_rec.attribute26 = hr_api.g_varchar2) then
494: p_rec.attribute26 :=
495: per_phn_shd.g_old_rec.attribute26;

Line 495: per_phn_shd.g_old_rec.attribute26;

491: per_phn_shd.g_old_rec.attribute25;
492: End If;
493: If (p_rec.attribute26 = hr_api.g_varchar2) then
494: p_rec.attribute26 :=
495: per_phn_shd.g_old_rec.attribute26;
496: End If;
497: If (p_rec.attribute27 = hr_api.g_varchar2) then
498: p_rec.attribute27 :=
499: per_phn_shd.g_old_rec.attribute27;

Line 499: per_phn_shd.g_old_rec.attribute27;

495: per_phn_shd.g_old_rec.attribute26;
496: End If;
497: If (p_rec.attribute27 = hr_api.g_varchar2) then
498: p_rec.attribute27 :=
499: per_phn_shd.g_old_rec.attribute27;
500: End If;
501: If (p_rec.attribute28 = hr_api.g_varchar2) then
502: p_rec.attribute28 :=
503: per_phn_shd.g_old_rec.attribute28;

Line 503: per_phn_shd.g_old_rec.attribute28;

499: per_phn_shd.g_old_rec.attribute27;
500: End If;
501: If (p_rec.attribute28 = hr_api.g_varchar2) then
502: p_rec.attribute28 :=
503: per_phn_shd.g_old_rec.attribute28;
504: End If;
505: If (p_rec.attribute29 = hr_api.g_varchar2) then
506: p_rec.attribute29 :=
507: per_phn_shd.g_old_rec.attribute29;

Line 507: per_phn_shd.g_old_rec.attribute29;

503: per_phn_shd.g_old_rec.attribute28;
504: End If;
505: If (p_rec.attribute29 = hr_api.g_varchar2) then
506: p_rec.attribute29 :=
507: per_phn_shd.g_old_rec.attribute29;
508: End If;
509: If (p_rec.attribute30 = hr_api.g_varchar2) then
510: p_rec.attribute30 :=
511: per_phn_shd.g_old_rec.attribute30;

Line 511: per_phn_shd.g_old_rec.attribute30;

507: per_phn_shd.g_old_rec.attribute29;
508: End If;
509: If (p_rec.attribute30 = hr_api.g_varchar2) then
510: p_rec.attribute30 :=
511: per_phn_shd.g_old_rec.attribute30;
512: End If;
513: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
514: p_rec.party_id := --
515: per_phn_shd.g_old_rec.party_id; --

Line 515: per_phn_shd.g_old_rec.party_id; --

511: per_phn_shd.g_old_rec.attribute30;
512: End If;
513: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
514: p_rec.party_id := --
515: per_phn_shd.g_old_rec.party_id; --
516: End If;
517: If (p_rec.validity = hr_api.g_varchar2) then
518: p_rec.validity :=
519: per_phn_shd.g_old_rec.validity;

Line 519: per_phn_shd.g_old_rec.validity;

515: per_phn_shd.g_old_rec.party_id; --
516: End If;
517: If (p_rec.validity = hr_api.g_varchar2) then
518: p_rec.validity :=
519: per_phn_shd.g_old_rec.validity;
520: End If;
521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: --

Line 531: p_rec in out nocopy per_phn_shd.g_rec_type,

527: -- |---------------------------------< upd >----------------------------------|
528: -- ----------------------------------------------------------------------------
529: Procedure upd
530: (
531: p_rec in out nocopy per_phn_shd.g_rec_type,
532: p_validate in boolean default false,
533: p_effective_date in date
534: ) is
535: --

Line 552: per_phn_shd.lck

548: End If;
549: --
550: -- We must lock the row which we need to update.
551: --
552: per_phn_shd.lck
553: (
554: p_rec.phone_id,
555: p_rec.object_version_number
556: );

Line 655: l_rec per_phn_shd.g_rec_type;

651: p_party_id in number default hr_api.g_number,
652: p_validity in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_phn_shd.g_rec_type;
656: l_proc varchar2(72) := g_package||'upd';
657: --
658: Begin
659: hr_utility.set_location('Entering:'||l_proc, 5);

Line 665: per_phn_shd.convert_args

661: -- Call conversion function to turn arguments into the
662: -- l_rec structure.
663: --
664: l_rec :=
665: per_phn_shd.convert_args
666: (
667: p_phone_id,
668: p_date_from,
669: p_date_to,