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_EST_UPD dependencies on PER_EST_SHD

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

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

Line 65: per_est_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_est_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_establishments Row
68: --
69: update per_establishments

Line 119: per_est_shd.g_api_dml := false; -- Unset the api dml status

115: est_information20 = p_rec.est_information20,
116: object_version_number = p_rec.object_version_number
117: where establishment_id = p_rec.establishment_id;
118: --
119: per_est_shd.g_api_dml := false; -- Unset the api dml status
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: Exception

Line 126: per_est_shd.g_api_dml := false; -- Unset the api dml status

122: --
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: per_est_shd.g_api_dml := false; -- Unset the api dml status
127: per_est_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated

Line 127: per_est_shd.constraint_error

123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: per_est_shd.g_api_dml := false; -- Unset the api dml status
127: per_est_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status

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

127: per_est_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status
132: per_est_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated

Line 132: per_est_shd.constraint_error

128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status
132: per_est_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_est_shd.g_api_dml := false; -- Unset the api dml status

Line 136: per_est_shd.g_api_dml := false; -- Unset the api dml status

132: per_est_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_est_shd.g_api_dml := false; -- Unset the api dml status
137: per_est_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_est_shd.g_api_dml := false; -- Unset the api dml status

Line 137: per_est_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_est_shd.g_api_dml := false; -- Unset the api dml status
137: per_est_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_est_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;

Line 140: per_est_shd.g_api_dml := false; -- Unset the api dml status

136: per_est_shd.g_api_dml := false; -- Unset the api dml status
137: per_est_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_est_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
142: End update_dml;
143: --
144: -- ----------------------------------------------------------------------------

Line 176: Procedure pre_update(p_rec in per_est_shd.g_rec_type) is

172: -- Internal Table Handler Use Only.
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update(p_rec in per_est_shd.g_rec_type) is
177: --
178: l_proc varchar2(72) := g_package||'pre_update';
179: --
180: Begin

Line 218: Procedure post_update(p_rec in per_est_shd.g_rec_type) is

214: -- Internal Table Handler Use Only.
215: --
216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure post_update(p_rec in per_est_shd.g_rec_type) is
219: --
220: l_proc varchar2(72) := g_package||'post_update';
221: --
222: Begin

Line 274: ,p_name_o =>per_est_shd.g_old_rec.name

270: p_est_information18 => p_rec.est_information18,
271: p_est_information19 => p_rec.est_information19,
272: p_est_information20 => p_rec.est_information20
273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_name_o =>per_est_shd.g_old_rec.name
275: ,p_location_o =>per_est_shd.g_old_rec.location
276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2

Line 275: ,p_location_o =>per_est_shd.g_old_rec.location

271: p_est_information19 => p_rec.est_information19,
272: p_est_information20 => p_rec.est_information20
273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_name_o =>per_est_shd.g_old_rec.name
275: ,p_location_o =>per_est_shd.g_old_rec.location
276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3

Line 276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category

272: p_est_information20 => p_rec.est_information20
273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_name_o =>per_est_shd.g_old_rec.name
275: ,p_location_o =>per_est_shd.g_old_rec.location
276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4

Line 277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1

273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_name_o =>per_est_shd.g_old_rec.name
275: ,p_location_o =>per_est_shd.g_old_rec.location
276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5

Line 278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2

274: ,p_name_o =>per_est_shd.g_old_rec.name
275: ,p_location_o =>per_est_shd.g_old_rec.location
276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6

Line 279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3

275: ,p_location_o =>per_est_shd.g_old_rec.location
276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7

Line 280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4

276: ,p_attribute_category_o =>per_est_shd.g_old_rec.attribute_category
277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8

Line 281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5

277: ,p_attribute1_o =>per_est_shd.g_old_rec.attribute1
278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9

Line 282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6

278: ,p_attribute2_o =>per_est_shd.g_old_rec.attribute2
279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10

Line 283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7

279: ,p_attribute3_o =>per_est_shd.g_old_rec.attribute3
280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11

Line 284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8

280: ,p_attribute4_o =>per_est_shd.g_old_rec.attribute4
281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12

Line 285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9

281: ,p_attribute5_o =>per_est_shd.g_old_rec.attribute5
282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13

Line 286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10

282: ,p_attribute6_o =>per_est_shd.g_old_rec.attribute6
283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14

Line 287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11

283: ,p_attribute7_o =>per_est_shd.g_old_rec.attribute7
284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15

Line 288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12

284: ,p_attribute8_o =>per_est_shd.g_old_rec.attribute8
285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16

Line 289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13

285: ,p_attribute9_o =>per_est_shd.g_old_rec.attribute9
286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17

Line 290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14

286: ,p_attribute10_o =>per_est_shd.g_old_rec.attribute10
287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18

Line 291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15

287: ,p_attribute11_o =>per_est_shd.g_old_rec.attribute11
288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19

Line 292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16

288: ,p_attribute12_o =>per_est_shd.g_old_rec.attribute12
289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,

Line 293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17

289: ,p_attribute13_o =>per_est_shd.g_old_rec.attribute13
290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,

Line 294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18

290: ,p_attribute14_o =>per_est_shd.g_old_rec.attribute14
291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,

Line 295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19

291: ,p_attribute15_o =>per_est_shd.g_old_rec.attribute15
292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,

Line 296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,

292: ,p_attribute16_o =>per_est_shd.g_old_rec.attribute16
293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,

Line 297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,

293: ,p_attribute17_o =>per_est_shd.g_old_rec.attribute17
294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,

Line 298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,

294: ,p_attribute18_o =>per_est_shd.g_old_rec.attribute18
295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,

Line 299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,

295: ,p_attribute19_o =>per_est_shd.g_old_rec.attribute19
296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,

Line 300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,

296: ,p_attribute20_o =>per_est_shd.g_old_rec.attribute20,
297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,

Line 301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,

297: p_est_information_category_o => per_est_shd.g_old_rec.est_information_category,
298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,

Line 302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,

298: p_est_information1_o => per_est_shd.g_old_rec.est_information1,
299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,

Line 303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,

299: p_est_information2_o => per_est_shd.g_old_rec.est_information2,
300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,

Line 304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,

300: p_est_information3_o => per_est_shd.g_old_rec.est_information3,
301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,

Line 305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,

301: p_est_information4_o => per_est_shd.g_old_rec.est_information4,
302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,

Line 306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,

302: p_est_information5_o => per_est_shd.g_old_rec.est_information5,
303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,

Line 307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,

303: p_est_information6_o => per_est_shd.g_old_rec.est_information6,
304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,

Line 308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,

304: p_est_information7_o => per_est_shd.g_old_rec.est_information7,
305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,

Line 309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,

305: p_est_information8_o => per_est_shd.g_old_rec.est_information8,
306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,

Line 310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,

306: p_est_information9_o => per_est_shd.g_old_rec.est_information9,
307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,

Line 311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,

307: p_est_information10_o => per_est_shd.g_old_rec.est_information10,
308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,

Line 312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,

308: p_est_information11_o => per_est_shd.g_old_rec.est_information11,
309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,

Line 313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,

309: p_est_information12_o => per_est_shd.g_old_rec.est_information12,
310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,
317: p_est_information20_o => per_est_shd.g_old_rec.est_information20

Line 314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,

310: p_est_information13_o => per_est_shd.g_old_rec.est_information13,
311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,
317: p_est_information20_o => per_est_shd.g_old_rec.est_information20
318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number

Line 315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,

311: p_est_information14_o => per_est_shd.g_old_rec.est_information14,
312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,
317: p_est_information20_o => per_est_shd.g_old_rec.est_information20
318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number
319: );

Line 316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,

312: p_est_information15_o => per_est_shd.g_old_rec.est_information15,
313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,
317: p_est_information20_o => per_est_shd.g_old_rec.est_information20
318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number
319: );
320: exception

Line 317: p_est_information20_o => per_est_shd.g_old_rec.est_information20

313: p_est_information16_o => per_est_shd.g_old_rec.est_information16,
314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,
317: p_est_information20_o => per_est_shd.g_old_rec.est_information20
318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then

Line 318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number

314: p_est_information17_o => per_est_shd.g_old_rec.est_information17,
315: p_est_information18_o => per_est_shd.g_old_rec.est_information18,
316: p_est_information19_o => per_est_shd.g_old_rec.est_information19,
317: p_est_information20_o => per_est_shd.g_old_rec.est_information20
318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error

Line 375: Procedure convert_defs(p_rec in out nocopy per_est_shd.g_rec_type) is

371: -- Internal Table Handler Use Only.
372: --
373: -- {End Of Comments}
374: -- ----------------------------------------------------------------------------
375: Procedure convert_defs(p_rec in out nocopy per_est_shd.g_rec_type) is
376: --
377: l_proc varchar2(72) := g_package||'convert_defs';
378: --
379: Begin

Line 390: per_est_shd.g_old_rec.name;

386: -- is being used then we must set to the 'current' argument value.
387: --
388: If (p_rec.name = hr_api.g_varchar2) then
389: p_rec.name :=
390: per_est_shd.g_old_rec.name;
391: End If;
392: If (p_rec.location = hr_api.g_varchar2) then
393: p_rec.location :=
394: per_est_shd.g_old_rec.location;

Line 394: per_est_shd.g_old_rec.location;

390: per_est_shd.g_old_rec.name;
391: End If;
392: If (p_rec.location = hr_api.g_varchar2) then
393: p_rec.location :=
394: per_est_shd.g_old_rec.location;
395: End If;
396: If (p_rec.attribute_category = hr_api.g_varchar2) then
397: p_rec.attribute_category :=
398: per_est_shd.g_old_rec.attribute_category;

Line 398: per_est_shd.g_old_rec.attribute_category;

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

Line 402: per_est_shd.g_old_rec.attribute1;

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

Line 406: per_est_shd.g_old_rec.attribute2;

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

Line 410: per_est_shd.g_old_rec.attribute3;

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

Line 414: per_est_shd.g_old_rec.attribute4;

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

Line 418: per_est_shd.g_old_rec.attribute5;

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

Line 422: per_est_shd.g_old_rec.attribute6;

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

Line 426: per_est_shd.g_old_rec.attribute7;

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

Line 430: per_est_shd.g_old_rec.attribute8;

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

Line 434: per_est_shd.g_old_rec.attribute9;

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

Line 438: per_est_shd.g_old_rec.attribute10;

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

Line 442: per_est_shd.g_old_rec.attribute11;

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

Line 446: per_est_shd.g_old_rec.attribute12;

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

Line 450: per_est_shd.g_old_rec.attribute13;

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

Line 454: per_est_shd.g_old_rec.attribute14;

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

Line 458: per_est_shd.g_old_rec.attribute15;

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

Line 462: per_est_shd.g_old_rec.attribute16;

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

Line 466: per_est_shd.g_old_rec.attribute17;

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

Line 470: per_est_shd.g_old_rec.attribute18;

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

Line 474: per_est_shd.g_old_rec.attribute19;

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

Line 478: per_est_shd.g_old_rec.attribute20;

474: per_est_shd.g_old_rec.attribute19;
475: End If;
476: If (p_rec.attribute20 = hr_api.g_varchar2) then
477: p_rec.attribute20 :=
478: per_est_shd.g_old_rec.attribute20;
479: End If;
480: If (p_rec.est_information_category = hr_api.g_varchar2) then
481: p_rec.est_information_category :=
482: per_est_shd.g_old_rec.est_information_category;

Line 482: per_est_shd.g_old_rec.est_information_category;

478: per_est_shd.g_old_rec.attribute20;
479: End If;
480: If (p_rec.est_information_category = hr_api.g_varchar2) then
481: p_rec.est_information_category :=
482: per_est_shd.g_old_rec.est_information_category;
483: End If;
484: If (p_rec.est_information1 = hr_api.g_varchar2) then
485: p_rec.est_information1 :=
486: per_est_shd.g_old_rec.est_information1;

Line 486: per_est_shd.g_old_rec.est_information1;

482: per_est_shd.g_old_rec.est_information_category;
483: End If;
484: If (p_rec.est_information1 = hr_api.g_varchar2) then
485: p_rec.est_information1 :=
486: per_est_shd.g_old_rec.est_information1;
487: End If;
488: If (p_rec.est_information2 = hr_api.g_varchar2) then
489: p_rec.est_information2 :=
490: per_est_shd.g_old_rec.est_information2;

Line 490: per_est_shd.g_old_rec.est_information2;

486: per_est_shd.g_old_rec.est_information1;
487: End If;
488: If (p_rec.est_information2 = hr_api.g_varchar2) then
489: p_rec.est_information2 :=
490: per_est_shd.g_old_rec.est_information2;
491: End If;
492: If (p_rec.est_information3 = hr_api.g_varchar2) then
493: p_rec.est_information3 :=
494: per_est_shd.g_old_rec.est_information3;

Line 494: per_est_shd.g_old_rec.est_information3;

490: per_est_shd.g_old_rec.est_information2;
491: End If;
492: If (p_rec.est_information3 = hr_api.g_varchar2) then
493: p_rec.est_information3 :=
494: per_est_shd.g_old_rec.est_information3;
495: End If;
496: If (p_rec.est_information4 = hr_api.g_varchar2) then
497: p_rec.est_information4 :=
498: per_est_shd.g_old_rec.est_information4;

Line 498: per_est_shd.g_old_rec.est_information4;

494: per_est_shd.g_old_rec.est_information3;
495: End If;
496: If (p_rec.est_information4 = hr_api.g_varchar2) then
497: p_rec.est_information4 :=
498: per_est_shd.g_old_rec.est_information4;
499: End If;
500: If (p_rec.est_information5 = hr_api.g_varchar2) then
501: p_rec.est_information5 :=
502: per_est_shd.g_old_rec.est_information5;

Line 502: per_est_shd.g_old_rec.est_information5;

498: per_est_shd.g_old_rec.est_information4;
499: End If;
500: If (p_rec.est_information5 = hr_api.g_varchar2) then
501: p_rec.est_information5 :=
502: per_est_shd.g_old_rec.est_information5;
503: End If;
504: If (p_rec.est_information6 = hr_api.g_varchar2) then
505: p_rec.est_information6 :=
506: per_est_shd.g_old_rec.est_information6;

Line 506: per_est_shd.g_old_rec.est_information6;

502: per_est_shd.g_old_rec.est_information5;
503: End If;
504: If (p_rec.est_information6 = hr_api.g_varchar2) then
505: p_rec.est_information6 :=
506: per_est_shd.g_old_rec.est_information6;
507: End If;
508: If (p_rec.est_information7 = hr_api.g_varchar2) then
509: p_rec.est_information7 :=
510: per_est_shd.g_old_rec.est_information7;

Line 510: per_est_shd.g_old_rec.est_information7;

506: per_est_shd.g_old_rec.est_information6;
507: End If;
508: If (p_rec.est_information7 = hr_api.g_varchar2) then
509: p_rec.est_information7 :=
510: per_est_shd.g_old_rec.est_information7;
511: End If;
512: If (p_rec.est_information8 = hr_api.g_varchar2) then
513: p_rec.est_information8 :=
514: per_est_shd.g_old_rec.est_information8;

Line 514: per_est_shd.g_old_rec.est_information8;

510: per_est_shd.g_old_rec.est_information7;
511: End If;
512: If (p_rec.est_information8 = hr_api.g_varchar2) then
513: p_rec.est_information8 :=
514: per_est_shd.g_old_rec.est_information8;
515: End If;
516: If (p_rec.est_information9 = hr_api.g_varchar2) then
517: p_rec.est_information9 :=
518: per_est_shd.g_old_rec.est_information9;

Line 518: per_est_shd.g_old_rec.est_information9;

514: per_est_shd.g_old_rec.est_information8;
515: End If;
516: If (p_rec.est_information9 = hr_api.g_varchar2) then
517: p_rec.est_information9 :=
518: per_est_shd.g_old_rec.est_information9;
519: End If;
520: If (p_rec.est_information10 = hr_api.g_varchar2) then
521: p_rec.est_information10 :=
522: per_est_shd.g_old_rec.est_information10;

Line 522: per_est_shd.g_old_rec.est_information10;

518: per_est_shd.g_old_rec.est_information9;
519: End If;
520: If (p_rec.est_information10 = hr_api.g_varchar2) then
521: p_rec.est_information10 :=
522: per_est_shd.g_old_rec.est_information10;
523: End If;
524: If (p_rec.est_information11 = hr_api.g_varchar2) then
525: p_rec.est_information11 :=
526: per_est_shd.g_old_rec.est_information11;

Line 526: per_est_shd.g_old_rec.est_information11;

522: per_est_shd.g_old_rec.est_information10;
523: End If;
524: If (p_rec.est_information11 = hr_api.g_varchar2) then
525: p_rec.est_information11 :=
526: per_est_shd.g_old_rec.est_information11;
527: End If;
528: If (p_rec.est_information12 = hr_api.g_varchar2) then
529: p_rec.est_information12 :=
530: per_est_shd.g_old_rec.est_information12;

Line 530: per_est_shd.g_old_rec.est_information12;

526: per_est_shd.g_old_rec.est_information11;
527: End If;
528: If (p_rec.est_information12 = hr_api.g_varchar2) then
529: p_rec.est_information12 :=
530: per_est_shd.g_old_rec.est_information12;
531: End If;
532: If (p_rec.est_information13 = hr_api.g_varchar2) then
533: p_rec.est_information13 :=
534: per_est_shd.g_old_rec.est_information13;

Line 534: per_est_shd.g_old_rec.est_information13;

530: per_est_shd.g_old_rec.est_information12;
531: End If;
532: If (p_rec.est_information13 = hr_api.g_varchar2) then
533: p_rec.est_information13 :=
534: per_est_shd.g_old_rec.est_information13;
535: End If;
536: If (p_rec.est_information14 = hr_api.g_varchar2) then
537: p_rec.est_information14 :=
538: per_est_shd.g_old_rec.est_information14;

Line 538: per_est_shd.g_old_rec.est_information14;

534: per_est_shd.g_old_rec.est_information13;
535: End If;
536: If (p_rec.est_information14 = hr_api.g_varchar2) then
537: p_rec.est_information14 :=
538: per_est_shd.g_old_rec.est_information14;
539: End If;
540: If (p_rec.est_information15 = hr_api.g_varchar2) then
541: p_rec.est_information15 :=
542: per_est_shd.g_old_rec.est_information15;

Line 542: per_est_shd.g_old_rec.est_information15;

538: per_est_shd.g_old_rec.est_information14;
539: End If;
540: If (p_rec.est_information15 = hr_api.g_varchar2) then
541: p_rec.est_information15 :=
542: per_est_shd.g_old_rec.est_information15;
543: End If;
544: If (p_rec.est_information16 = hr_api.g_varchar2) then
545: p_rec.est_information16 :=
546: per_est_shd.g_old_rec.est_information16;

Line 546: per_est_shd.g_old_rec.est_information16;

542: per_est_shd.g_old_rec.est_information15;
543: End If;
544: If (p_rec.est_information16 = hr_api.g_varchar2) then
545: p_rec.est_information16 :=
546: per_est_shd.g_old_rec.est_information16;
547: End If;
548: If (p_rec.est_information17 = hr_api.g_varchar2) then
549: p_rec.est_information17 :=
550: per_est_shd.g_old_rec.est_information17;

Line 550: per_est_shd.g_old_rec.est_information17;

546: per_est_shd.g_old_rec.est_information16;
547: End If;
548: If (p_rec.est_information17 = hr_api.g_varchar2) then
549: p_rec.est_information17 :=
550: per_est_shd.g_old_rec.est_information17;
551: End If;
552: If (p_rec.est_information18 = hr_api.g_varchar2) then
553: p_rec.est_information18 :=
554: per_est_shd.g_old_rec.est_information18;

Line 554: per_est_shd.g_old_rec.est_information18;

550: per_est_shd.g_old_rec.est_information17;
551: End If;
552: If (p_rec.est_information18 = hr_api.g_varchar2) then
553: p_rec.est_information18 :=
554: per_est_shd.g_old_rec.est_information18;
555: End If;
556: If (p_rec.est_information19 = hr_api.g_varchar2) then
557: p_rec.est_information19 :=
558: per_est_shd.g_old_rec.est_information19;

Line 558: per_est_shd.g_old_rec.est_information19;

554: per_est_shd.g_old_rec.est_information18;
555: End If;
556: If (p_rec.est_information19 = hr_api.g_varchar2) then
557: p_rec.est_information19 :=
558: per_est_shd.g_old_rec.est_information19;
559: End If;
560: If (p_rec.est_information20 = hr_api.g_varchar2) then
561: p_rec.est_information20 :=
562: per_est_shd.g_old_rec.est_information20;

Line 562: per_est_shd.g_old_rec.est_information20;

558: per_est_shd.g_old_rec.est_information19;
559: End If;
560: If (p_rec.est_information20 = hr_api.g_varchar2) then
561: p_rec.est_information20 :=
562: per_est_shd.g_old_rec.est_information20;
563: End If;
564:
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 575: p_rec in out nocopy per_est_shd.g_rec_type,

571: -- |---------------------------------< upd >----------------------------------|
572: -- ----------------------------------------------------------------------------
573: Procedure upd
574: (
575: p_rec in out nocopy per_est_shd.g_rec_type,
576: p_validate in boolean default false
577: ) is
578: --
579: l_proc varchar2(72) := g_package||'upd';

Line 595: per_est_shd.lck

591: End If;
592: --
593: -- We must lock the row which we need to update.
594: --
595: per_est_shd.lck
596: (
597: p_rec.establishment_id,
598: p_rec.object_version_number
599: );

Line 692: l_rec per_est_shd.g_rec_type;

688: p_object_version_number in out nocopy number,
689: p_validate in boolean default false
690: ) is
691: --
692: l_rec per_est_shd.g_rec_type;
693: l_proc varchar2(72) := g_package||'upd';
694: --
695: Begin
696: hr_utility.set_location('Entering:'||l_proc, 5);

Line 702: per_est_shd.convert_args

698: -- Call conversion function to turn arguments into the
699: -- l_rec structure.
700: --
701: l_rec :=
702: per_est_shd.convert_args
703: (
704: p_establishment_id,
705: p_name,
706: p_location,