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_PRV_UPD dependencies on PER_PRV_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_prv_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_prv_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_prv_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_prv_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_performance_reviews Row
68: --
69: update per_performance_reviews

Line 110: per_prv_shd.g_api_dml := false; -- Unset the api dml status

106: attribute30 = p_rec.attribute30,
107: object_version_number = p_rec.object_version_number
108: where performance_review_id = p_rec.performance_review_id;
109: --
110: per_prv_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: --
114: Exception

Line 117: per_prv_shd.g_api_dml := false; -- Unset the api dml status

113: --
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: per_prv_shd.g_api_dml := false; -- Unset the api dml status
118: per_prv_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated

Line 118: per_prv_shd.constraint_error

114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: per_prv_shd.g_api_dml := false; -- Unset the api dml status
118: per_prv_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status

Line 122: per_prv_shd.g_api_dml := false; -- Unset the api dml status

118: per_prv_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status
123: per_prv_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated

Line 123: per_prv_shd.constraint_error

119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status
123: per_prv_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_prv_shd.g_api_dml := false; -- Unset the api dml status

Line 127: per_prv_shd.g_api_dml := false; -- Unset the api dml status

123: per_prv_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_prv_shd.g_api_dml := false; -- Unset the api dml status
128: per_prv_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_prv_shd.g_api_dml := false; -- Unset the api dml status

Line 128: per_prv_shd.constraint_error

124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_prv_shd.g_api_dml := false; -- Unset the api dml status
128: per_prv_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_prv_shd.g_api_dml := false; -- Unset the api dml status
132: Raise;

Line 131: per_prv_shd.g_api_dml := false; -- Unset the api dml status

127: per_prv_shd.g_api_dml := false; -- Unset the api dml status
128: per_prv_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_prv_shd.g_api_dml := false; -- Unset the api dml status
132: Raise;
133: End update_dml;
134: --
135: -- ----------------------------------------------------------------------------

Line 167: Procedure pre_update(p_rec in per_prv_shd.g_rec_type) is

163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_update(p_rec in per_prv_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --
171: Begin

Line 209: Procedure post_update(p_rec in per_prv_shd.g_rec_type) is

205: -- Internal Row Handler Use Only.
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update(p_rec in per_prv_shd.g_rec_type) is
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --
213: Begin

Line 261: ,p_person_id_o =>per_prv_shd.g_old_rec.person_id

257: ,p_attribute28 =>p_rec.attribute28
258: ,p_attribute29 =>p_rec.attribute29
259: ,p_attribute30 =>p_rec.attribute30
260: ,p_object_version_number =>p_rec.object_version_number
261: ,p_person_id_o =>per_prv_shd.g_old_rec.person_id
262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id
263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date

Line 262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id

258: ,p_attribute29 =>p_rec.attribute29
259: ,p_attribute30 =>p_rec.attribute30
260: ,p_object_version_number =>p_rec.object_version_number
261: ,p_person_id_o =>per_prv_shd.g_old_rec.person_id
262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id
263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category

Line 263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date

259: ,p_attribute30 =>p_rec.attribute30
260: ,p_object_version_number =>p_rec.object_version_number
261: ,p_person_id_o =>per_prv_shd.g_old_rec.person_id
262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id
263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1

Line 264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating

260: ,p_object_version_number =>p_rec.object_version_number
261: ,p_person_id_o =>per_prv_shd.g_old_rec.person_id
262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id
263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2

Line 265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date

261: ,p_person_id_o =>per_prv_shd.g_old_rec.person_id
262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id
263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3

Line 266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category

262: ,p_event_id_o =>per_prv_shd.g_old_rec.event_id
263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4

Line 267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1

263: ,p_review_date_o =>per_prv_shd.g_old_rec.review_date
264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5

Line 268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2

264: ,p_performance_rating_o =>per_prv_shd.g_old_rec.performance_rating
265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6

Line 269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3

265: ,p_next_perf_review_date_o =>per_prv_shd.g_old_rec.next_perf_review_date
266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7

Line 270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4

266: ,p_attribute_category_o =>per_prv_shd.g_old_rec.attribute_category
267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8

Line 271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5

267: ,p_attribute1_o =>per_prv_shd.g_old_rec.attribute1
268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9

Line 272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6

268: ,p_attribute2_o =>per_prv_shd.g_old_rec.attribute2
269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10

Line 273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7

269: ,p_attribute3_o =>per_prv_shd.g_old_rec.attribute3
270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11

Line 274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8

270: ,p_attribute4_o =>per_prv_shd.g_old_rec.attribute4
271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12

Line 275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9

271: ,p_attribute5_o =>per_prv_shd.g_old_rec.attribute5
272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13

Line 276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10

272: ,p_attribute6_o =>per_prv_shd.g_old_rec.attribute6
273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14

Line 277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11

273: ,p_attribute7_o =>per_prv_shd.g_old_rec.attribute7
274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15

Line 278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12

274: ,p_attribute8_o =>per_prv_shd.g_old_rec.attribute8
275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16

Line 279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13

275: ,p_attribute9_o =>per_prv_shd.g_old_rec.attribute9
276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17

Line 280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14

276: ,p_attribute10_o =>per_prv_shd.g_old_rec.attribute10
277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18

Line 281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15

277: ,p_attribute11_o =>per_prv_shd.g_old_rec.attribute11
278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19

Line 282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16

278: ,p_attribute12_o =>per_prv_shd.g_old_rec.attribute12
279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20

Line 283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17

279: ,p_attribute13_o =>per_prv_shd.g_old_rec.attribute13
280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21

Line 284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18

280: ,p_attribute14_o =>per_prv_shd.g_old_rec.attribute14
281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22

Line 285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19

281: ,p_attribute15_o =>per_prv_shd.g_old_rec.attribute15
282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23

Line 286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20

282: ,p_attribute16_o =>per_prv_shd.g_old_rec.attribute16
283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24

Line 287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21

283: ,p_attribute17_o =>per_prv_shd.g_old_rec.attribute17
284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25

Line 288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22

284: ,p_attribute18_o =>per_prv_shd.g_old_rec.attribute18
285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26

Line 289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23

285: ,p_attribute19_o =>per_prv_shd.g_old_rec.attribute19
286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27

Line 290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24

286: ,p_attribute20_o =>per_prv_shd.g_old_rec.attribute20
287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28

Line 291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25

287: ,p_attribute21_o =>per_prv_shd.g_old_rec.attribute21
288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29

Line 292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26

288: ,p_attribute22_o =>per_prv_shd.g_old_rec.attribute22
289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29
296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30

Line 293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27

289: ,p_attribute23_o =>per_prv_shd.g_old_rec.attribute23
290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29
296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30
297: ,p_object_version_number_o =>per_prv_shd.g_old_rec.object_version_number

Line 294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28

290: ,p_attribute24_o =>per_prv_shd.g_old_rec.attribute24
291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29
296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30
297: ,p_object_version_number_o =>per_prv_shd.g_old_rec.object_version_number
298: );

Line 295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29

291: ,p_attribute25_o =>per_prv_shd.g_old_rec.attribute25
292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29
296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30
297: ,p_object_version_number_o =>per_prv_shd.g_old_rec.object_version_number
298: );
299: --

Line 296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30

292: ,p_attribute26_o =>per_prv_shd.g_old_rec.attribute26
293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29
296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30
297: ,p_object_version_number_o =>per_prv_shd.g_old_rec.object_version_number
298: );
299: --
300: exception

Line 297: ,p_object_version_number_o =>per_prv_shd.g_old_rec.object_version_number

293: ,p_attribute27_o =>per_prv_shd.g_old_rec.attribute27
294: ,p_attribute28_o =>per_prv_shd.g_old_rec.attribute28
295: ,p_attribute29_o =>per_prv_shd.g_old_rec.attribute29
296: ,p_attribute30_o =>per_prv_shd.g_old_rec.attribute30
297: ,p_object_version_number_o =>per_prv_shd.g_old_rec.object_version_number
298: );
299: --
300: exception
301: --

Line 359: Procedure convert_defs(p_rec in out nocopy per_prv_shd.g_rec_type) is

355: -- Internal Row Handler Use Only.
356: --
357: -- {End Of Comments}
358: -- ----------------------------------------------------------------------------
359: Procedure convert_defs(p_rec in out nocopy per_prv_shd.g_rec_type) is
360: --
361: l_proc varchar2(72) := g_package||'convert_defs';
362: --
363: Begin

Line 374: per_prv_shd.g_old_rec.person_id;

370: -- is being used then we must set to the 'current' argument value.
371: --
372: If (p_rec.person_id = hr_api.g_number) then
373: p_rec.person_id :=
374: per_prv_shd.g_old_rec.person_id;
375: End If;
376: If (p_rec.event_id = hr_api.g_number) then
377: p_rec.event_id :=
378: per_prv_shd.g_old_rec.event_id;

Line 378: per_prv_shd.g_old_rec.event_id;

374: per_prv_shd.g_old_rec.person_id;
375: End If;
376: If (p_rec.event_id = hr_api.g_number) then
377: p_rec.event_id :=
378: per_prv_shd.g_old_rec.event_id;
379: End If;
380: If (p_rec.review_date = hr_api.g_date) then
381: p_rec.review_date :=
382: per_prv_shd.g_old_rec.review_date;

Line 382: per_prv_shd.g_old_rec.review_date;

378: per_prv_shd.g_old_rec.event_id;
379: End If;
380: If (p_rec.review_date = hr_api.g_date) then
381: p_rec.review_date :=
382: per_prv_shd.g_old_rec.review_date;
383: End If;
384: If (p_rec.performance_rating = hr_api.g_varchar2) then
385: p_rec.performance_rating :=
386: per_prv_shd.g_old_rec.performance_rating;

Line 386: per_prv_shd.g_old_rec.performance_rating;

382: per_prv_shd.g_old_rec.review_date;
383: End If;
384: If (p_rec.performance_rating = hr_api.g_varchar2) then
385: p_rec.performance_rating :=
386: per_prv_shd.g_old_rec.performance_rating;
387: End If;
388: If (p_rec.next_perf_review_date = hr_api.g_date) then
389: p_rec.next_perf_review_date :=
390: per_prv_shd.g_old_rec.next_perf_review_date;

Line 390: per_prv_shd.g_old_rec.next_perf_review_date;

386: per_prv_shd.g_old_rec.performance_rating;
387: End If;
388: If (p_rec.next_perf_review_date = hr_api.g_date) then
389: p_rec.next_perf_review_date :=
390: per_prv_shd.g_old_rec.next_perf_review_date;
391: End If;
392: If (p_rec.attribute_category = hr_api.g_varchar2) then
393: p_rec.attribute_category :=
394: per_prv_shd.g_old_rec.attribute_category;

Line 394: per_prv_shd.g_old_rec.attribute_category;

390: per_prv_shd.g_old_rec.next_perf_review_date;
391: End If;
392: If (p_rec.attribute_category = hr_api.g_varchar2) then
393: p_rec.attribute_category :=
394: per_prv_shd.g_old_rec.attribute_category;
395: End If;
396: If (p_rec.attribute1 = hr_api.g_varchar2) then
397: p_rec.attribute1 :=
398: per_prv_shd.g_old_rec.attribute1;

Line 398: per_prv_shd.g_old_rec.attribute1;

394: per_prv_shd.g_old_rec.attribute_category;
395: End If;
396: If (p_rec.attribute1 = hr_api.g_varchar2) then
397: p_rec.attribute1 :=
398: per_prv_shd.g_old_rec.attribute1;
399: End If;
400: If (p_rec.attribute2 = hr_api.g_varchar2) then
401: p_rec.attribute2 :=
402: per_prv_shd.g_old_rec.attribute2;

Line 402: per_prv_shd.g_old_rec.attribute2;

398: per_prv_shd.g_old_rec.attribute1;
399: End If;
400: If (p_rec.attribute2 = hr_api.g_varchar2) then
401: p_rec.attribute2 :=
402: per_prv_shd.g_old_rec.attribute2;
403: End If;
404: If (p_rec.attribute3 = hr_api.g_varchar2) then
405: p_rec.attribute3 :=
406: per_prv_shd.g_old_rec.attribute3;

Line 406: per_prv_shd.g_old_rec.attribute3;

402: per_prv_shd.g_old_rec.attribute2;
403: End If;
404: If (p_rec.attribute3 = hr_api.g_varchar2) then
405: p_rec.attribute3 :=
406: per_prv_shd.g_old_rec.attribute3;
407: End If;
408: If (p_rec.attribute4 = hr_api.g_varchar2) then
409: p_rec.attribute4 :=
410: per_prv_shd.g_old_rec.attribute4;

Line 410: per_prv_shd.g_old_rec.attribute4;

406: per_prv_shd.g_old_rec.attribute3;
407: End If;
408: If (p_rec.attribute4 = hr_api.g_varchar2) then
409: p_rec.attribute4 :=
410: per_prv_shd.g_old_rec.attribute4;
411: End If;
412: If (p_rec.attribute5 = hr_api.g_varchar2) then
413: p_rec.attribute5 :=
414: per_prv_shd.g_old_rec.attribute5;

Line 414: per_prv_shd.g_old_rec.attribute5;

410: per_prv_shd.g_old_rec.attribute4;
411: End If;
412: If (p_rec.attribute5 = hr_api.g_varchar2) then
413: p_rec.attribute5 :=
414: per_prv_shd.g_old_rec.attribute5;
415: End If;
416: If (p_rec.attribute6 = hr_api.g_varchar2) then
417: p_rec.attribute6 :=
418: per_prv_shd.g_old_rec.attribute6;

Line 418: per_prv_shd.g_old_rec.attribute6;

414: per_prv_shd.g_old_rec.attribute5;
415: End If;
416: If (p_rec.attribute6 = hr_api.g_varchar2) then
417: p_rec.attribute6 :=
418: per_prv_shd.g_old_rec.attribute6;
419: End If;
420: If (p_rec.attribute7 = hr_api.g_varchar2) then
421: p_rec.attribute7 :=
422: per_prv_shd.g_old_rec.attribute7;

Line 422: per_prv_shd.g_old_rec.attribute7;

418: per_prv_shd.g_old_rec.attribute6;
419: End If;
420: If (p_rec.attribute7 = hr_api.g_varchar2) then
421: p_rec.attribute7 :=
422: per_prv_shd.g_old_rec.attribute7;
423: End If;
424: If (p_rec.attribute8 = hr_api.g_varchar2) then
425: p_rec.attribute8 :=
426: per_prv_shd.g_old_rec.attribute8;

Line 426: per_prv_shd.g_old_rec.attribute8;

422: per_prv_shd.g_old_rec.attribute7;
423: End If;
424: If (p_rec.attribute8 = hr_api.g_varchar2) then
425: p_rec.attribute8 :=
426: per_prv_shd.g_old_rec.attribute8;
427: End If;
428: If (p_rec.attribute9 = hr_api.g_varchar2) then
429: p_rec.attribute9 :=
430: per_prv_shd.g_old_rec.attribute9;

Line 430: per_prv_shd.g_old_rec.attribute9;

426: per_prv_shd.g_old_rec.attribute8;
427: End If;
428: If (p_rec.attribute9 = hr_api.g_varchar2) then
429: p_rec.attribute9 :=
430: per_prv_shd.g_old_rec.attribute9;
431: End If;
432: If (p_rec.attribute10 = hr_api.g_varchar2) then
433: p_rec.attribute10 :=
434: per_prv_shd.g_old_rec.attribute10;

Line 434: per_prv_shd.g_old_rec.attribute10;

430: per_prv_shd.g_old_rec.attribute9;
431: End If;
432: If (p_rec.attribute10 = hr_api.g_varchar2) then
433: p_rec.attribute10 :=
434: per_prv_shd.g_old_rec.attribute10;
435: End If;
436: If (p_rec.attribute11 = hr_api.g_varchar2) then
437: p_rec.attribute11 :=
438: per_prv_shd.g_old_rec.attribute11;

Line 438: per_prv_shd.g_old_rec.attribute11;

434: per_prv_shd.g_old_rec.attribute10;
435: End If;
436: If (p_rec.attribute11 = hr_api.g_varchar2) then
437: p_rec.attribute11 :=
438: per_prv_shd.g_old_rec.attribute11;
439: End If;
440: If (p_rec.attribute12 = hr_api.g_varchar2) then
441: p_rec.attribute12 :=
442: per_prv_shd.g_old_rec.attribute12;

Line 442: per_prv_shd.g_old_rec.attribute12;

438: per_prv_shd.g_old_rec.attribute11;
439: End If;
440: If (p_rec.attribute12 = hr_api.g_varchar2) then
441: p_rec.attribute12 :=
442: per_prv_shd.g_old_rec.attribute12;
443: End If;
444: If (p_rec.attribute13 = hr_api.g_varchar2) then
445: p_rec.attribute13 :=
446: per_prv_shd.g_old_rec.attribute13;

Line 446: per_prv_shd.g_old_rec.attribute13;

442: per_prv_shd.g_old_rec.attribute12;
443: End If;
444: If (p_rec.attribute13 = hr_api.g_varchar2) then
445: p_rec.attribute13 :=
446: per_prv_shd.g_old_rec.attribute13;
447: End If;
448: If (p_rec.attribute14 = hr_api.g_varchar2) then
449: p_rec.attribute14 :=
450: per_prv_shd.g_old_rec.attribute14;

Line 450: per_prv_shd.g_old_rec.attribute14;

446: per_prv_shd.g_old_rec.attribute13;
447: End If;
448: If (p_rec.attribute14 = hr_api.g_varchar2) then
449: p_rec.attribute14 :=
450: per_prv_shd.g_old_rec.attribute14;
451: End If;
452: If (p_rec.attribute15 = hr_api.g_varchar2) then
453: p_rec.attribute15 :=
454: per_prv_shd.g_old_rec.attribute15;

Line 454: per_prv_shd.g_old_rec.attribute15;

450: per_prv_shd.g_old_rec.attribute14;
451: End If;
452: If (p_rec.attribute15 = hr_api.g_varchar2) then
453: p_rec.attribute15 :=
454: per_prv_shd.g_old_rec.attribute15;
455: End If;
456: If (p_rec.attribute16 = hr_api.g_varchar2) then
457: p_rec.attribute16 :=
458: per_prv_shd.g_old_rec.attribute16;

Line 458: per_prv_shd.g_old_rec.attribute16;

454: per_prv_shd.g_old_rec.attribute15;
455: End If;
456: If (p_rec.attribute16 = hr_api.g_varchar2) then
457: p_rec.attribute16 :=
458: per_prv_shd.g_old_rec.attribute16;
459: End If;
460: If (p_rec.attribute17 = hr_api.g_varchar2) then
461: p_rec.attribute17 :=
462: per_prv_shd.g_old_rec.attribute17;

Line 462: per_prv_shd.g_old_rec.attribute17;

458: per_prv_shd.g_old_rec.attribute16;
459: End If;
460: If (p_rec.attribute17 = hr_api.g_varchar2) then
461: p_rec.attribute17 :=
462: per_prv_shd.g_old_rec.attribute17;
463: End If;
464: If (p_rec.attribute18 = hr_api.g_varchar2) then
465: p_rec.attribute18 :=
466: per_prv_shd.g_old_rec.attribute18;

Line 466: per_prv_shd.g_old_rec.attribute18;

462: per_prv_shd.g_old_rec.attribute17;
463: End If;
464: If (p_rec.attribute18 = hr_api.g_varchar2) then
465: p_rec.attribute18 :=
466: per_prv_shd.g_old_rec.attribute18;
467: End If;
468: If (p_rec.attribute19 = hr_api.g_varchar2) then
469: p_rec.attribute19 :=
470: per_prv_shd.g_old_rec.attribute19;

Line 470: per_prv_shd.g_old_rec.attribute19;

466: per_prv_shd.g_old_rec.attribute18;
467: End If;
468: If (p_rec.attribute19 = hr_api.g_varchar2) then
469: p_rec.attribute19 :=
470: per_prv_shd.g_old_rec.attribute19;
471: End If;
472: If (p_rec.attribute20 = hr_api.g_varchar2) then
473: p_rec.attribute20 :=
474: per_prv_shd.g_old_rec.attribute20;

Line 474: per_prv_shd.g_old_rec.attribute20;

470: per_prv_shd.g_old_rec.attribute19;
471: End If;
472: If (p_rec.attribute20 = hr_api.g_varchar2) then
473: p_rec.attribute20 :=
474: per_prv_shd.g_old_rec.attribute20;
475: End If;
476: If (p_rec.attribute21 = hr_api.g_varchar2) then
477: p_rec.attribute21 :=
478: per_prv_shd.g_old_rec.attribute21;

Line 478: per_prv_shd.g_old_rec.attribute21;

474: per_prv_shd.g_old_rec.attribute20;
475: End If;
476: If (p_rec.attribute21 = hr_api.g_varchar2) then
477: p_rec.attribute21 :=
478: per_prv_shd.g_old_rec.attribute21;
479: End If;
480: If (p_rec.attribute22 = hr_api.g_varchar2) then
481: p_rec.attribute22 :=
482: per_prv_shd.g_old_rec.attribute22;

Line 482: per_prv_shd.g_old_rec.attribute22;

478: per_prv_shd.g_old_rec.attribute21;
479: End If;
480: If (p_rec.attribute22 = hr_api.g_varchar2) then
481: p_rec.attribute22 :=
482: per_prv_shd.g_old_rec.attribute22;
483: End If;
484: If (p_rec.attribute23 = hr_api.g_varchar2) then
485: p_rec.attribute23 :=
486: per_prv_shd.g_old_rec.attribute23;

Line 486: per_prv_shd.g_old_rec.attribute23;

482: per_prv_shd.g_old_rec.attribute22;
483: End If;
484: If (p_rec.attribute23 = hr_api.g_varchar2) then
485: p_rec.attribute23 :=
486: per_prv_shd.g_old_rec.attribute23;
487: End If;
488: If (p_rec.attribute24 = hr_api.g_varchar2) then
489: p_rec.attribute24 :=
490: per_prv_shd.g_old_rec.attribute24;

Line 490: per_prv_shd.g_old_rec.attribute24;

486: per_prv_shd.g_old_rec.attribute23;
487: End If;
488: If (p_rec.attribute24 = hr_api.g_varchar2) then
489: p_rec.attribute24 :=
490: per_prv_shd.g_old_rec.attribute24;
491: End If;
492: If (p_rec.attribute25 = hr_api.g_varchar2) then
493: p_rec.attribute25 :=
494: per_prv_shd.g_old_rec.attribute25;

Line 494: per_prv_shd.g_old_rec.attribute25;

490: per_prv_shd.g_old_rec.attribute24;
491: End If;
492: If (p_rec.attribute25 = hr_api.g_varchar2) then
493: p_rec.attribute25 :=
494: per_prv_shd.g_old_rec.attribute25;
495: End If;
496: If (p_rec.attribute26 = hr_api.g_varchar2) then
497: p_rec.attribute26 :=
498: per_prv_shd.g_old_rec.attribute26;

Line 498: per_prv_shd.g_old_rec.attribute26;

494: per_prv_shd.g_old_rec.attribute25;
495: End If;
496: If (p_rec.attribute26 = hr_api.g_varchar2) then
497: p_rec.attribute26 :=
498: per_prv_shd.g_old_rec.attribute26;
499: End If;
500: If (p_rec.attribute27 = hr_api.g_varchar2) then
501: p_rec.attribute27 :=
502: per_prv_shd.g_old_rec.attribute27;

Line 502: per_prv_shd.g_old_rec.attribute27;

498: per_prv_shd.g_old_rec.attribute26;
499: End If;
500: If (p_rec.attribute27 = hr_api.g_varchar2) then
501: p_rec.attribute27 :=
502: per_prv_shd.g_old_rec.attribute27;
503: End If;
504: If (p_rec.attribute28 = hr_api.g_varchar2) then
505: p_rec.attribute28 :=
506: per_prv_shd.g_old_rec.attribute28;

Line 506: per_prv_shd.g_old_rec.attribute28;

502: per_prv_shd.g_old_rec.attribute27;
503: End If;
504: If (p_rec.attribute28 = hr_api.g_varchar2) then
505: p_rec.attribute28 :=
506: per_prv_shd.g_old_rec.attribute28;
507: End If;
508: If (p_rec.attribute29 = hr_api.g_varchar2) then
509: p_rec.attribute29 :=
510: per_prv_shd.g_old_rec.attribute29;

Line 510: per_prv_shd.g_old_rec.attribute29;

506: per_prv_shd.g_old_rec.attribute28;
507: End If;
508: If (p_rec.attribute29 = hr_api.g_varchar2) then
509: p_rec.attribute29 :=
510: per_prv_shd.g_old_rec.attribute29;
511: End If;
512: If (p_rec.attribute30 = hr_api.g_varchar2) then
513: p_rec.attribute30 :=
514: per_prv_shd.g_old_rec.attribute30;

Line 514: per_prv_shd.g_old_rec.attribute30;

510: per_prv_shd.g_old_rec.attribute29;
511: End If;
512: If (p_rec.attribute30 = hr_api.g_varchar2) then
513: p_rec.attribute30 :=
514: per_prv_shd.g_old_rec.attribute30;
515: End If;
516:
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 527: p_rec in out nocopy per_prv_shd.g_rec_type,

523: -- |---------------------------------< upd >----------------------------------|
524: -- ----------------------------------------------------------------------------
525: Procedure upd
526: (
527: p_rec in out nocopy per_prv_shd.g_rec_type,
528: p_next_review_date_warning out nocopy boolean,
529: p_validate boolean
530: ) is
531: --

Line 549: per_prv_shd.lck

545: --
546: --
547: -- We must lock the row which we need to update.
548: --
549: per_prv_shd.lck
550: (
551: p_rec.performance_review_id,
552: p_rec.object_version_number
553: );

Line 639: l_rec per_prv_shd.g_rec_type;

635: p_validate in boolean default false,
636: p_next_review_date_warning out nocopy boolean
637: ) is
638: --
639: l_rec per_prv_shd.g_rec_type;
640: l_proc varchar2(72) := g_package||'upd';
641: --
642: Begin
643: hr_utility.set_location('Entering:'||l_proc, 5);

Line 649: per_prv_shd.convert_args

645: -- Call conversion function to turn arguments into the
646: -- l_rec structure.
647: --
648: l_rec :=
649: per_prv_shd.convert_args
650: (
651: p_performance_review_id,
652: hr_api.g_number,
653: p_event_id,