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_EQT_UPD dependencies on PER_EQT_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_eqt_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_eqt_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_eqt_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_eqt_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_qualification_types Row
68:
69: -- mvankada

Line 143: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

139: ,provider = p_rec.provider
140: ,qa_organization = p_rec.qa_organization
141: where qualification_type_id = p_rec.qualification_type_id;
142: --
143: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: --
147: Exception

Line 150: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

146: --
147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
151: per_eqt_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated

Line 151: per_eqt_shd.constraint_error

147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
151: per_eqt_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

Line 155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

151: per_eqt_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
156: per_eqt_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated

Line 156: per_eqt_shd.constraint_error

152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
156: per_eqt_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

Line 160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

156: per_eqt_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
161: per_eqt_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

Line 161: per_eqt_shd.constraint_error

157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
161: per_eqt_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
165: Raise;

Line 164: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
161: per_eqt_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
165: Raise;
166: End update_dml;
167: --
168: -- ----------------------------------------------------------------------------

Line 200: Procedure pre_update(p_rec in per_eqt_shd.g_rec_type) is

196: -- Internal Table Handler Use Only.
197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure pre_update(p_rec in per_eqt_shd.g_rec_type) is
201: --
202: l_proc varchar2(72) := g_package||'pre_update';
203: --
204: Begin

Line 242: Procedure post_update(p_rec in per_eqt_shd.g_rec_type

238: -- Internal Table Handler Use Only.
239: --
240: -- {End Of Comments}
241: -- ----------------------------------------------------------------------------
242: Procedure post_update(p_rec in per_eqt_shd.g_rec_type
243: ,p_effective_date in date
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'post_update';

Line 327: ,p_name_o => per_eqt_shd.g_old_rec.name

323: ,p_field => p_rec.field
324: ,p_sub_field => p_rec.sub_field
325: ,p_provider => p_rec.provider
326: ,p_qa_organization => p_rec.qa_organization
327: ,p_name_o => per_eqt_shd.g_old_rec.name
328: ,p_category_o => per_eqt_shd.g_old_rec.category
329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1

Line 328: ,p_category_o => per_eqt_shd.g_old_rec.category

324: ,p_sub_field => p_rec.sub_field
325: ,p_provider => p_rec.provider
326: ,p_qa_organization => p_rec.qa_organization
327: ,p_name_o => per_eqt_shd.g_old_rec.name
328: ,p_category_o => per_eqt_shd.g_old_rec.category
329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2

Line 329: ,p_rank_o => per_eqt_shd.g_old_rec.rank

325: ,p_provider => p_rec.provider
326: ,p_qa_organization => p_rec.qa_organization
327: ,p_name_o => per_eqt_shd.g_old_rec.name
328: ,p_category_o => per_eqt_shd.g_old_rec.category
329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3

Line 330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category

326: ,p_qa_organization => p_rec.qa_organization
327: ,p_name_o => per_eqt_shd.g_old_rec.name
328: ,p_category_o => per_eqt_shd.g_old_rec.category
329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4

Line 331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1

327: ,p_name_o => per_eqt_shd.g_old_rec.name
328: ,p_category_o => per_eqt_shd.g_old_rec.category
329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5

Line 332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2

328: ,p_category_o => per_eqt_shd.g_old_rec.category
329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6

Line 333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3

329: ,p_rank_o => per_eqt_shd.g_old_rec.rank
330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7

Line 334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4

330: ,p_attribute_category_o => per_eqt_shd.g_old_rec.attribute_category
331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8

Line 335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5

331: ,p_attribute1_o => per_eqt_shd.g_old_rec.attribute1
332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9

Line 336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6

332: ,p_attribute2_o => per_eqt_shd.g_old_rec.attribute2
333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10

Line 337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7

333: ,p_attribute3_o => per_eqt_shd.g_old_rec.attribute3
334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11

Line 338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8

334: ,p_attribute4_o => per_eqt_shd.g_old_rec.attribute4
335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12

Line 339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9

335: ,p_attribute5_o => per_eqt_shd.g_old_rec.attribute5
336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13

Line 340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10

336: ,p_attribute6_o => per_eqt_shd.g_old_rec.attribute6
337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14

Line 341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11

337: ,p_attribute7_o => per_eqt_shd.g_old_rec.attribute7
338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15

Line 342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12

338: ,p_attribute8_o => per_eqt_shd.g_old_rec.attribute8
339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16

Line 343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13

339: ,p_attribute9_o => per_eqt_shd.g_old_rec.attribute9
340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17

Line 344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14

340: ,p_attribute10_o => per_eqt_shd.g_old_rec.attribute10
341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18

Line 345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15

341: ,p_attribute11_o => per_eqt_shd.g_old_rec.attribute11
342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19

Line 346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16

342: ,p_attribute12_o => per_eqt_shd.g_old_rec.attribute12
343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20

Line 347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17

343: ,p_attribute13_o => per_eqt_shd.g_old_rec.attribute13
344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number

Line 348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18

344: ,p_attribute14_o => per_eqt_shd.g_old_rec.attribute14
345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category

Line 349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19

345: ,p_attribute15_o => per_eqt_shd.g_old_rec.attribute15
346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1

Line 350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20

346: ,p_attribute16_o => per_eqt_shd.g_old_rec.attribute16
347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2

Line 351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number

347: ,p_attribute17_o => per_eqt_shd.g_old_rec.attribute17
348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3

Line 352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category

348: ,p_attribute18_o => per_eqt_shd.g_old_rec.attribute18
349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4

Line 353: ,p_information1_o => per_eqt_shd.g_old_rec.information1

349: ,p_attribute19_o => per_eqt_shd.g_old_rec.attribute19
350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5

Line 354: ,p_information2_o => per_eqt_shd.g_old_rec.information2

350: ,p_attribute20_o => per_eqt_shd.g_old_rec.attribute20
351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6

Line 355: ,p_information3_o => per_eqt_shd.g_old_rec.information3

351: ,p_object_version_number_o => per_eqt_shd.g_old_rec.object_version_number
352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7

Line 356: ,p_information4_o => per_eqt_shd.g_old_rec.information4

352: ,p_information_category_o => per_eqt_shd.g_old_rec.information_category
353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8

Line 357: ,p_information5_o => per_eqt_shd.g_old_rec.information5

353: ,p_information1_o => per_eqt_shd.g_old_rec.information1
354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9

Line 358: ,p_information6_o => per_eqt_shd.g_old_rec.information6

354: ,p_information2_o => per_eqt_shd.g_old_rec.information2
355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10

Line 359: ,p_information7_o => per_eqt_shd.g_old_rec.information7

355: ,p_information3_o => per_eqt_shd.g_old_rec.information3
356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11

Line 360: ,p_information8_o => per_eqt_shd.g_old_rec.information8

356: ,p_information4_o => per_eqt_shd.g_old_rec.information4
357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12

Line 361: ,p_information9_o => per_eqt_shd.g_old_rec.information9

357: ,p_information5_o => per_eqt_shd.g_old_rec.information5
358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13

Line 362: ,p_information10_o => per_eqt_shd.g_old_rec.information10

358: ,p_information6_o => per_eqt_shd.g_old_rec.information6
359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14

Line 363: ,p_information11_o => per_eqt_shd.g_old_rec.information11

359: ,p_information7_o => per_eqt_shd.g_old_rec.information7
360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15

Line 364: ,p_information12_o => per_eqt_shd.g_old_rec.information12

360: ,p_information8_o => per_eqt_shd.g_old_rec.information8
361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16

Line 365: ,p_information13_o => per_eqt_shd.g_old_rec.information13

361: ,p_information9_o => per_eqt_shd.g_old_rec.information9
362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17

Line 366: ,p_information14_o => per_eqt_shd.g_old_rec.information14

362: ,p_information10_o => per_eqt_shd.g_old_rec.information10
363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18

Line 367: ,p_information15_o => per_eqt_shd.g_old_rec.information15

363: ,p_information11_o => per_eqt_shd.g_old_rec.information11
364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19

Line 368: ,p_information16_o => per_eqt_shd.g_old_rec.information16

364: ,p_information12_o => per_eqt_shd.g_old_rec.information12
365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20

Line 369: ,p_information17_o => per_eqt_shd.g_old_rec.information17

365: ,p_information13_o => per_eqt_shd.g_old_rec.information13
366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21

Line 370: ,p_information18_o => per_eqt_shd.g_old_rec.information18

366: ,p_information14_o => per_eqt_shd.g_old_rec.information14
367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22

Line 371: ,p_information19_o => per_eqt_shd.g_old_rec.information19

367: ,p_information15_o => per_eqt_shd.g_old_rec.information15
368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23

Line 372: ,p_information20_o => per_eqt_shd.g_old_rec.information20

368: ,p_information16_o => per_eqt_shd.g_old_rec.information16
369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24

Line 373: ,p_information21_o => per_eqt_shd.g_old_rec.information21

369: ,p_information17_o => per_eqt_shd.g_old_rec.information17
370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25

Line 374: ,p_information22_o => per_eqt_shd.g_old_rec.information22

370: ,p_information18_o => per_eqt_shd.g_old_rec.information18
371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26

Line 375: ,p_information23_o => per_eqt_shd.g_old_rec.information23

371: ,p_information19_o => per_eqt_shd.g_old_rec.information19
372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27

Line 376: ,p_information24_o => per_eqt_shd.g_old_rec.information24

372: ,p_information20_o => per_eqt_shd.g_old_rec.information20
373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28

Line 377: ,p_information25_o => per_eqt_shd.g_old_rec.information25

373: ,p_information21_o => per_eqt_shd.g_old_rec.information21
374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29

Line 378: ,p_information26_o => per_eqt_shd.g_old_rec.information26

374: ,p_information22_o => per_eqt_shd.g_old_rec.information22
375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30

Line 379: ,p_information27_o => per_eqt_shd.g_old_rec.information27

375: ,p_information23_o => per_eqt_shd.g_old_rec.information23
376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id

Line 380: ,p_information28_o => per_eqt_shd.g_old_rec.information28

376: ,p_information24_o => per_eqt_shd.g_old_rec.information24
377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type

Line 381: ,p_information29_o => per_eqt_shd.g_old_rec.information29

377: ,p_information25_o => per_eqt_shd.g_old_rec.information25
378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type

Line 382: ,p_information30_o => per_eqt_shd.g_old_rec.information30

378: ,p_information26_o => per_eqt_shd.g_old_rec.information26
379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits

Line 383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id

379: ,p_information27_o => per_eqt_shd.g_old_rec.information27
380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type

Line 384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type

380: ,p_information28_o => per_eqt_shd.g_old_rec.information28
381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number

Line 385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type

381: ,p_information29_o => per_eqt_shd.g_old_rec.information29
382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field

Line 386: ,p_credits_o => per_eqt_shd.g_old_rec.credits

382: ,p_information30_o => per_eqt_shd.g_old_rec.information30
383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field

Line 387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type

383: ,p_qual_framework_id_o => per_eqt_shd.g_old_rec.qual_framework_id
384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field
391: ,p_provider_o => per_eqt_shd.g_old_rec.provider

Line 388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number

384: ,p_qualification_type_o => per_eqt_shd.g_old_rec.qualification_type
385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field
391: ,p_provider_o => per_eqt_shd.g_old_rec.provider
392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization

Line 389: ,p_field_o => per_eqt_shd.g_old_rec.field

385: ,p_credit_type_o => per_eqt_shd.g_old_rec.credit_type
386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field
391: ,p_provider_o => per_eqt_shd.g_old_rec.provider
392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization
393: );

Line 390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field

386: ,p_credits_o => per_eqt_shd.g_old_rec.credits
387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field
391: ,p_provider_o => per_eqt_shd.g_old_rec.provider
392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization
393: );
394: exception

Line 391: ,p_provider_o => per_eqt_shd.g_old_rec.provider

387: ,p_level_type_o => per_eqt_shd.g_old_rec.level_type
388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field
391: ,p_provider_o => per_eqt_shd.g_old_rec.provider
392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then

Line 392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization

388: ,p_level_number_o => per_eqt_shd.g_old_rec.level_number
389: ,p_field_o => per_eqt_shd.g_old_rec.field
390: ,p_sub_field_o => per_eqt_shd.g_old_rec.sub_field
391: ,p_provider_o => per_eqt_shd.g_old_rec.provider
392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error

Line 449: Procedure convert_defs(p_rec in out nocopy per_eqt_shd.g_rec_type) is

445: -- Internal Table Handler Use Only.
446: --
447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure convert_defs(p_rec in out nocopy per_eqt_shd.g_rec_type) is
450: --
451: l_proc varchar2(72) := g_package||'convert_defs';
452: --
453: Begin

Line 464: per_eqt_shd.g_old_rec.name;

460: -- is being used then we must set to the 'current' argument value.
461: --
462: If (p_rec.name = hr_api.g_varchar2) then
463: p_rec.name :=
464: per_eqt_shd.g_old_rec.name;
465: End If;
466: If (p_rec.category = hr_api.g_varchar2) then
467: p_rec.category :=
468: per_eqt_shd.g_old_rec.category;

Line 468: per_eqt_shd.g_old_rec.category;

464: per_eqt_shd.g_old_rec.name;
465: End If;
466: If (p_rec.category = hr_api.g_varchar2) then
467: p_rec.category :=
468: per_eqt_shd.g_old_rec.category;
469: End If;
470: If (p_rec.rank = hr_api.g_number) then
471: p_rec.rank :=
472: per_eqt_shd.g_old_rec.rank;

Line 472: per_eqt_shd.g_old_rec.rank;

468: per_eqt_shd.g_old_rec.category;
469: End If;
470: If (p_rec.rank = hr_api.g_number) then
471: p_rec.rank :=
472: per_eqt_shd.g_old_rec.rank;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: per_eqt_shd.g_old_rec.attribute_category;

Line 476: per_eqt_shd.g_old_rec.attribute_category;

472: per_eqt_shd.g_old_rec.rank;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: per_eqt_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: per_eqt_shd.g_old_rec.attribute1;

Line 480: per_eqt_shd.g_old_rec.attribute1;

476: per_eqt_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: per_eqt_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: per_eqt_shd.g_old_rec.attribute2;

Line 484: per_eqt_shd.g_old_rec.attribute2;

480: per_eqt_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: per_eqt_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: per_eqt_shd.g_old_rec.attribute3;

Line 488: per_eqt_shd.g_old_rec.attribute3;

484: per_eqt_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: per_eqt_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: per_eqt_shd.g_old_rec.attribute4;

Line 492: per_eqt_shd.g_old_rec.attribute4;

488: per_eqt_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: per_eqt_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: per_eqt_shd.g_old_rec.attribute5;

Line 496: per_eqt_shd.g_old_rec.attribute5;

492: per_eqt_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: per_eqt_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: per_eqt_shd.g_old_rec.attribute6;

Line 500: per_eqt_shd.g_old_rec.attribute6;

496: per_eqt_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: per_eqt_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: per_eqt_shd.g_old_rec.attribute7;

Line 504: per_eqt_shd.g_old_rec.attribute7;

500: per_eqt_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: per_eqt_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: per_eqt_shd.g_old_rec.attribute8;

Line 508: per_eqt_shd.g_old_rec.attribute8;

504: per_eqt_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: per_eqt_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: per_eqt_shd.g_old_rec.attribute9;

Line 512: per_eqt_shd.g_old_rec.attribute9;

508: per_eqt_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: per_eqt_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: per_eqt_shd.g_old_rec.attribute10;

Line 516: per_eqt_shd.g_old_rec.attribute10;

512: per_eqt_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: per_eqt_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: per_eqt_shd.g_old_rec.attribute11;

Line 520: per_eqt_shd.g_old_rec.attribute11;

516: per_eqt_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: per_eqt_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: per_eqt_shd.g_old_rec.attribute12;

Line 524: per_eqt_shd.g_old_rec.attribute12;

520: per_eqt_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: per_eqt_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: per_eqt_shd.g_old_rec.attribute13;

Line 528: per_eqt_shd.g_old_rec.attribute13;

524: per_eqt_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: per_eqt_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: per_eqt_shd.g_old_rec.attribute14;

Line 532: per_eqt_shd.g_old_rec.attribute14;

528: per_eqt_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: per_eqt_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: per_eqt_shd.g_old_rec.attribute15;

Line 536: per_eqt_shd.g_old_rec.attribute15;

532: per_eqt_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: per_eqt_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: per_eqt_shd.g_old_rec.attribute16;

Line 540: per_eqt_shd.g_old_rec.attribute16;

536: per_eqt_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: per_eqt_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: per_eqt_shd.g_old_rec.attribute17;

Line 544: per_eqt_shd.g_old_rec.attribute17;

540: per_eqt_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: per_eqt_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: per_eqt_shd.g_old_rec.attribute18;

Line 548: per_eqt_shd.g_old_rec.attribute18;

544: per_eqt_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: per_eqt_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: per_eqt_shd.g_old_rec.attribute19;

Line 552: per_eqt_shd.g_old_rec.attribute19;

548: per_eqt_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: per_eqt_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: per_eqt_shd.g_old_rec.attribute20;

Line 556: per_eqt_shd.g_old_rec.attribute20;

552: per_eqt_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: per_eqt_shd.g_old_rec.attribute20;
557: End If;
558:
559: -- mvankada
560: -- For Developer DF columns

Line 564: per_eqt_shd.g_old_rec.information_category;

560: -- For Developer DF columns
561:
562: If (p_rec.information_category = hr_api.g_varchar2) then
563: p_rec.information_category :=
564: per_eqt_shd.g_old_rec.information_category;
565: End If;
566: If (p_rec.information1 = hr_api.g_varchar2) then
567: p_rec.information1 :=
568: per_eqt_shd.g_old_rec.information1;

Line 568: per_eqt_shd.g_old_rec.information1;

564: per_eqt_shd.g_old_rec.information_category;
565: End If;
566: If (p_rec.information1 = hr_api.g_varchar2) then
567: p_rec.information1 :=
568: per_eqt_shd.g_old_rec.information1;
569: End If;
570: If (p_rec.information2 = hr_api.g_varchar2) then
571: p_rec.information2 :=
572: per_eqt_shd.g_old_rec.information2;

Line 572: per_eqt_shd.g_old_rec.information2;

568: per_eqt_shd.g_old_rec.information1;
569: End If;
570: If (p_rec.information2 = hr_api.g_varchar2) then
571: p_rec.information2 :=
572: per_eqt_shd.g_old_rec.information2;
573: End If;
574: If (p_rec.information3 = hr_api.g_varchar2) then
575: p_rec.information3 :=
576: per_eqt_shd.g_old_rec.information3;

Line 576: per_eqt_shd.g_old_rec.information3;

572: per_eqt_shd.g_old_rec.information2;
573: End If;
574: If (p_rec.information3 = hr_api.g_varchar2) then
575: p_rec.information3 :=
576: per_eqt_shd.g_old_rec.information3;
577: End If;
578: If (p_rec.information4 = hr_api.g_varchar2) then
579: p_rec.information4 :=
580: per_eqt_shd.g_old_rec.information4;

Line 580: per_eqt_shd.g_old_rec.information4;

576: per_eqt_shd.g_old_rec.information3;
577: End If;
578: If (p_rec.information4 = hr_api.g_varchar2) then
579: p_rec.information4 :=
580: per_eqt_shd.g_old_rec.information4;
581: End If;
582: If (p_rec.information5 = hr_api.g_varchar2) then
583: p_rec.information5 :=
584: per_eqt_shd.g_old_rec.information5;

Line 584: per_eqt_shd.g_old_rec.information5;

580: per_eqt_shd.g_old_rec.information4;
581: End If;
582: If (p_rec.information5 = hr_api.g_varchar2) then
583: p_rec.information5 :=
584: per_eqt_shd.g_old_rec.information5;
585: End If;
586: If (p_rec.information6 = hr_api.g_varchar2) then
587: p_rec.information6 :=
588: per_eqt_shd.g_old_rec.information6;

Line 588: per_eqt_shd.g_old_rec.information6;

584: per_eqt_shd.g_old_rec.information5;
585: End If;
586: If (p_rec.information6 = hr_api.g_varchar2) then
587: p_rec.information6 :=
588: per_eqt_shd.g_old_rec.information6;
589: End If;
590: If (p_rec.information7 = hr_api.g_varchar2) then
591: p_rec.information7 :=
592: per_eqt_shd.g_old_rec.information7;

Line 592: per_eqt_shd.g_old_rec.information7;

588: per_eqt_shd.g_old_rec.information6;
589: End If;
590: If (p_rec.information7 = hr_api.g_varchar2) then
591: p_rec.information7 :=
592: per_eqt_shd.g_old_rec.information7;
593: End If;
594: If (p_rec.information8 = hr_api.g_varchar2) then
595: p_rec.information8 :=
596: per_eqt_shd.g_old_rec.information8;

Line 596: per_eqt_shd.g_old_rec.information8;

592: per_eqt_shd.g_old_rec.information7;
593: End If;
594: If (p_rec.information8 = hr_api.g_varchar2) then
595: p_rec.information8 :=
596: per_eqt_shd.g_old_rec.information8;
597: End If;
598: If (p_rec.information9 = hr_api.g_varchar2) then
599: p_rec.information9 :=
600: per_eqt_shd.g_old_rec.information9;

Line 600: per_eqt_shd.g_old_rec.information9;

596: per_eqt_shd.g_old_rec.information8;
597: End If;
598: If (p_rec.information9 = hr_api.g_varchar2) then
599: p_rec.information9 :=
600: per_eqt_shd.g_old_rec.information9;
601: End If;
602: If (p_rec.information10 = hr_api.g_varchar2) then
603: p_rec.information10 :=
604: per_eqt_shd.g_old_rec.information10;

Line 604: per_eqt_shd.g_old_rec.information10;

600: per_eqt_shd.g_old_rec.information9;
601: End If;
602: If (p_rec.information10 = hr_api.g_varchar2) then
603: p_rec.information10 :=
604: per_eqt_shd.g_old_rec.information10;
605: End If;
606: If (p_rec.information11 = hr_api.g_varchar2) then
607: p_rec.information11 :=
608: per_eqt_shd.g_old_rec.information11;

Line 608: per_eqt_shd.g_old_rec.information11;

604: per_eqt_shd.g_old_rec.information10;
605: End If;
606: If (p_rec.information11 = hr_api.g_varchar2) then
607: p_rec.information11 :=
608: per_eqt_shd.g_old_rec.information11;
609: End If;
610: If (p_rec.information12 = hr_api.g_varchar2) then
611: p_rec.information12 :=
612: per_eqt_shd.g_old_rec.information12;

Line 612: per_eqt_shd.g_old_rec.information12;

608: per_eqt_shd.g_old_rec.information11;
609: End If;
610: If (p_rec.information12 = hr_api.g_varchar2) then
611: p_rec.information12 :=
612: per_eqt_shd.g_old_rec.information12;
613: End If;
614: If (p_rec.information13 = hr_api.g_varchar2) then
615: p_rec.information13 :=
616: per_eqt_shd.g_old_rec.information13;

Line 616: per_eqt_shd.g_old_rec.information13;

612: per_eqt_shd.g_old_rec.information12;
613: End If;
614: If (p_rec.information13 = hr_api.g_varchar2) then
615: p_rec.information13 :=
616: per_eqt_shd.g_old_rec.information13;
617: End If;
618: If (p_rec.information14 = hr_api.g_varchar2) then
619: p_rec.information14 :=
620: per_eqt_shd.g_old_rec.information14;

Line 620: per_eqt_shd.g_old_rec.information14;

616: per_eqt_shd.g_old_rec.information13;
617: End If;
618: If (p_rec.information14 = hr_api.g_varchar2) then
619: p_rec.information14 :=
620: per_eqt_shd.g_old_rec.information14;
621: End If;
622: If (p_rec.information15 = hr_api.g_varchar2) then
623: p_rec.information15 :=
624: per_eqt_shd.g_old_rec.information15;

Line 624: per_eqt_shd.g_old_rec.information15;

620: per_eqt_shd.g_old_rec.information14;
621: End If;
622: If (p_rec.information15 = hr_api.g_varchar2) then
623: p_rec.information15 :=
624: per_eqt_shd.g_old_rec.information15;
625: End If;
626: If (p_rec.information16 = hr_api.g_varchar2) then
627: p_rec.information16 :=
628: per_eqt_shd.g_old_rec.information16;

Line 628: per_eqt_shd.g_old_rec.information16;

624: per_eqt_shd.g_old_rec.information15;
625: End If;
626: If (p_rec.information16 = hr_api.g_varchar2) then
627: p_rec.information16 :=
628: per_eqt_shd.g_old_rec.information16;
629: End If;
630: If (p_rec.information17 = hr_api.g_varchar2) then
631: p_rec.information17 :=
632: per_eqt_shd.g_old_rec.information17;

Line 632: per_eqt_shd.g_old_rec.information17;

628: per_eqt_shd.g_old_rec.information16;
629: End If;
630: If (p_rec.information17 = hr_api.g_varchar2) then
631: p_rec.information17 :=
632: per_eqt_shd.g_old_rec.information17;
633: End If;
634: If (p_rec.information18 = hr_api.g_varchar2) then
635: p_rec.information18 :=
636: per_eqt_shd.g_old_rec.information18;

Line 636: per_eqt_shd.g_old_rec.information18;

632: per_eqt_shd.g_old_rec.information17;
633: End If;
634: If (p_rec.information18 = hr_api.g_varchar2) then
635: p_rec.information18 :=
636: per_eqt_shd.g_old_rec.information18;
637: End If;
638: If (p_rec.information19 = hr_api.g_varchar2) then
639: p_rec.information19 :=
640: per_eqt_shd.g_old_rec.information19;

Line 640: per_eqt_shd.g_old_rec.information19;

636: per_eqt_shd.g_old_rec.information18;
637: End If;
638: If (p_rec.information19 = hr_api.g_varchar2) then
639: p_rec.information19 :=
640: per_eqt_shd.g_old_rec.information19;
641: End If;
642: If (p_rec.information20 = hr_api.g_varchar2) then
643: p_rec.information20 :=
644: per_eqt_shd.g_old_rec.information20;

Line 644: per_eqt_shd.g_old_rec.information20;

640: per_eqt_shd.g_old_rec.information19;
641: End If;
642: If (p_rec.information20 = hr_api.g_varchar2) then
643: p_rec.information20 :=
644: per_eqt_shd.g_old_rec.information20;
645: End If;
646: If (p_rec.information21 = hr_api.g_varchar2) then
647: p_rec.information21 :=
648: per_eqt_shd.g_old_rec.information21;

Line 648: per_eqt_shd.g_old_rec.information21;

644: per_eqt_shd.g_old_rec.information20;
645: End If;
646: If (p_rec.information21 = hr_api.g_varchar2) then
647: p_rec.information21 :=
648: per_eqt_shd.g_old_rec.information21;
649: End If;
650: If (p_rec.information22 = hr_api.g_varchar2) then
651: p_rec.information22 :=
652: per_eqt_shd.g_old_rec.information22;

Line 652: per_eqt_shd.g_old_rec.information22;

648: per_eqt_shd.g_old_rec.information21;
649: End If;
650: If (p_rec.information22 = hr_api.g_varchar2) then
651: p_rec.information22 :=
652: per_eqt_shd.g_old_rec.information22;
653: End If;
654: If (p_rec.information23 = hr_api.g_varchar2) then
655: p_rec.information23 :=
656: per_eqt_shd.g_old_rec.information23;

Line 656: per_eqt_shd.g_old_rec.information23;

652: per_eqt_shd.g_old_rec.information22;
653: End If;
654: If (p_rec.information23 = hr_api.g_varchar2) then
655: p_rec.information23 :=
656: per_eqt_shd.g_old_rec.information23;
657: End If;
658: If (p_rec.information24 = hr_api.g_varchar2) then
659: p_rec.information24 :=
660: per_eqt_shd.g_old_rec.information24;

Line 660: per_eqt_shd.g_old_rec.information24;

656: per_eqt_shd.g_old_rec.information23;
657: End If;
658: If (p_rec.information24 = hr_api.g_varchar2) then
659: p_rec.information24 :=
660: per_eqt_shd.g_old_rec.information24;
661: End If;
662: If (p_rec.information25 = hr_api.g_varchar2) then
663: p_rec.information25 :=
664: per_eqt_shd.g_old_rec.information25;

Line 664: per_eqt_shd.g_old_rec.information25;

660: per_eqt_shd.g_old_rec.information24;
661: End If;
662: If (p_rec.information25 = hr_api.g_varchar2) then
663: p_rec.information25 :=
664: per_eqt_shd.g_old_rec.information25;
665: End If;
666: If (p_rec.information26 = hr_api.g_varchar2) then
667: p_rec.information26 :=
668: per_eqt_shd.g_old_rec.information26;

Line 668: per_eqt_shd.g_old_rec.information26;

664: per_eqt_shd.g_old_rec.information25;
665: End If;
666: If (p_rec.information26 = hr_api.g_varchar2) then
667: p_rec.information26 :=
668: per_eqt_shd.g_old_rec.information26;
669: End If;
670: If (p_rec.information27 = hr_api.g_varchar2) then
671: p_rec.information27 :=
672: per_eqt_shd.g_old_rec.information27;

Line 672: per_eqt_shd.g_old_rec.information27;

668: per_eqt_shd.g_old_rec.information26;
669: End If;
670: If (p_rec.information27 = hr_api.g_varchar2) then
671: p_rec.information27 :=
672: per_eqt_shd.g_old_rec.information27;
673: End If;
674: If (p_rec.information28 = hr_api.g_varchar2) then
675: p_rec.information28 :=
676: per_eqt_shd.g_old_rec.information28;

Line 676: per_eqt_shd.g_old_rec.information28;

672: per_eqt_shd.g_old_rec.information27;
673: End If;
674: If (p_rec.information28 = hr_api.g_varchar2) then
675: p_rec.information28 :=
676: per_eqt_shd.g_old_rec.information28;
677: End If;
678: If (p_rec.information29 = hr_api.g_varchar2) then
679: p_rec.information29 :=
680: per_eqt_shd.g_old_rec.information29;

Line 680: per_eqt_shd.g_old_rec.information29;

676: per_eqt_shd.g_old_rec.information28;
677: End If;
678: If (p_rec.information29 = hr_api.g_varchar2) then
679: p_rec.information29 :=
680: per_eqt_shd.g_old_rec.information29;
681: End If;
682: If (p_rec.information30 = hr_api.g_varchar2) then
683: p_rec.information30 :=
684: per_eqt_shd.g_old_rec.information30;

Line 684: per_eqt_shd.g_old_rec.information30;

680: per_eqt_shd.g_old_rec.information29;
681: End If;
682: If (p_rec.information30 = hr_api.g_varchar2) then
683: p_rec.information30 :=
684: per_eqt_shd.g_old_rec.information30;
685: End If;
686: --
687: -- BUG3356369
688: --

Line 691: per_eqt_shd.g_old_rec.qual_framework_id;

687: -- BUG3356369
688: --
689: If (p_rec.qual_framework_id = hr_api.g_number) then
690: p_rec.qual_framework_id :=
691: per_eqt_shd.g_old_rec.qual_framework_id;
692: End If;
693: If (p_rec.qualification_type = hr_api.g_varchar2) then
694: p_rec.qualification_type :=
695: per_eqt_shd.g_old_rec.qualification_type;

Line 695: per_eqt_shd.g_old_rec.qualification_type;

691: per_eqt_shd.g_old_rec.qual_framework_id;
692: End If;
693: If (p_rec.qualification_type = hr_api.g_varchar2) then
694: p_rec.qualification_type :=
695: per_eqt_shd.g_old_rec.qualification_type;
696: End If;
697: If (p_rec.credit_type = hr_api.g_varchar2) then
698: p_rec.credit_type :=
699: per_eqt_shd.g_old_rec.credit_type;

Line 699: per_eqt_shd.g_old_rec.credit_type;

695: per_eqt_shd.g_old_rec.qualification_type;
696: End If;
697: If (p_rec.credit_type = hr_api.g_varchar2) then
698: p_rec.credit_type :=
699: per_eqt_shd.g_old_rec.credit_type;
700: End If;
701: If (p_rec.credits = hr_api.g_number) then
702: p_rec.credits :=
703: per_eqt_shd.g_old_rec.credits;

Line 703: per_eqt_shd.g_old_rec.credits;

699: per_eqt_shd.g_old_rec.credit_type;
700: End If;
701: If (p_rec.credits = hr_api.g_number) then
702: p_rec.credits :=
703: per_eqt_shd.g_old_rec.credits;
704: End If;
705: If (p_rec.level_type = hr_api.g_varchar2) then
706: p_rec.level_type :=
707: per_eqt_shd.g_old_rec.level_type;

Line 707: per_eqt_shd.g_old_rec.level_type;

703: per_eqt_shd.g_old_rec.credits;
704: End If;
705: If (p_rec.level_type = hr_api.g_varchar2) then
706: p_rec.level_type :=
707: per_eqt_shd.g_old_rec.level_type;
708: End If;
709: If (p_rec.level_number = hr_api.g_number) then
710: p_rec.level_number :=
711: per_eqt_shd.g_old_rec.level_number;

Line 711: per_eqt_shd.g_old_rec.level_number;

707: per_eqt_shd.g_old_rec.level_type;
708: End If;
709: If (p_rec.level_number = hr_api.g_number) then
710: p_rec.level_number :=
711: per_eqt_shd.g_old_rec.level_number;
712: End If;
713: If (p_rec.field = hr_api.g_varchar2) then
714: p_rec.field :=
715: per_eqt_shd.g_old_rec.field ;

Line 715: per_eqt_shd.g_old_rec.field ;

711: per_eqt_shd.g_old_rec.level_number;
712: End If;
713: If (p_rec.field = hr_api.g_varchar2) then
714: p_rec.field :=
715: per_eqt_shd.g_old_rec.field ;
716: End If;
717: If (p_rec.sub_field = hr_api.g_varchar2) then
718: p_rec.sub_field :=
719: per_eqt_shd.g_old_rec.sub_field;

Line 719: per_eqt_shd.g_old_rec.sub_field;

715: per_eqt_shd.g_old_rec.field ;
716: End If;
717: If (p_rec.sub_field = hr_api.g_varchar2) then
718: p_rec.sub_field :=
719: per_eqt_shd.g_old_rec.sub_field;
720: End If;
721: If (p_rec.provider = hr_api.g_varchar2) then
722: p_rec.provider :=
723: per_eqt_shd.g_old_rec.provider;

Line 723: per_eqt_shd.g_old_rec.provider;

719: per_eqt_shd.g_old_rec.sub_field;
720: End If;
721: If (p_rec.provider = hr_api.g_varchar2) then
722: p_rec.provider :=
723: per_eqt_shd.g_old_rec.provider;
724: End If;
725: If (p_rec.qa_organization = hr_api.g_varchar2) then
726: p_rec.qa_organization :=
727: per_eqt_shd.g_old_rec.qa_organization;

Line 727: per_eqt_shd.g_old_rec.qa_organization;

723: per_eqt_shd.g_old_rec.provider;
724: End If;
725: If (p_rec.qa_organization = hr_api.g_varchar2) then
726: p_rec.qa_organization :=
727: per_eqt_shd.g_old_rec.qa_organization;
728: End If;
729:
730: --
731: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 740: p_rec in out nocopy per_eqt_shd.g_rec_type,

736: -- |---------------------------------< upd >----------------------------------|
737: -- ----------------------------------------------------------------------------
738: Procedure upd
739: (
740: p_rec in out nocopy per_eqt_shd.g_rec_type,
741: p_effective_date in date,
742: p_validate in boolean default false
743: ) is
744: --

Line 761: per_eqt_shd.lck

757: End If;
758: --
759: -- We must lock the row which we need to update.
760: --
761: per_eqt_shd.lck
762: (
763: p_rec.qualification_type_id,
764: p_rec.object_version_number
765: );

Line 887: l_rec per_eqt_shd.g_rec_type;

883: ,p_provider in varchar2 default hr_api.g_varchar2
884: ,p_qa_organization in varchar2 default hr_api.g_varchar2
885: ) is
886: --
887: l_rec per_eqt_shd.g_rec_type;
888: l_proc varchar2(72) := g_package||'upd';
889: --
890: Begin
891: hr_utility.set_location('Entering:'||l_proc, 5);

Line 897: per_eqt_shd.convert_args

893: -- Call conversion function to turn arguments into the
894: -- l_rec structure.
895: --
896: l_rec :=
897: per_eqt_shd.convert_args
898: (
899: p_qualification_type_id,
900: p_name,
901: p_category,