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_SUB_UPD dependencies on PER_SUB_SHD

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

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

Line 124: per_sub_shd.g_api_dml := false; -- Unset the api dml status

120: sub_information19 = p_rec.sub_information19,
121: sub_information20 = p_rec.sub_information20
122: where subjects_taken_id = p_rec.subjects_taken_id;
123: --
124: per_sub_shd.g_api_dml := false; -- Unset the api dml status
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: --
128: Exception

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

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

Line 132: per_sub_shd.constraint_error

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

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

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

Line 137: per_sub_shd.constraint_error

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

Line 141: per_sub_shd.g_api_dml := false; -- Unset the api dml status

137: per_sub_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: per_sub_shd.g_api_dml := false; -- Unset the api dml status
142: per_sub_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: per_sub_shd.g_api_dml := false; -- Unset the api dml status

Line 142: per_sub_shd.constraint_error

138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: per_sub_shd.g_api_dml := false; -- Unset the api dml status
142: per_sub_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: per_sub_shd.g_api_dml := false; -- Unset the api dml status
146: Raise;

Line 145: per_sub_shd.g_api_dml := false; -- Unset the api dml status

141: per_sub_shd.g_api_dml := false; -- Unset the api dml status
142: per_sub_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: per_sub_shd.g_api_dml := false; -- Unset the api dml status
146: Raise;
147: End update_dml;
148: --
149: -- ----------------------------------------------------------------------------

Line 181: Procedure pre_update(p_rec in per_sub_shd.g_rec_type) is

177: -- Internal Table Handler Use Only.
178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure pre_update(p_rec in per_sub_shd.g_rec_type) is
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --
185: Begin

Line 223: Procedure post_update(p_rec in per_sub_shd.g_rec_type,

219: -- Internal Table Handler Use Only.
220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_update(p_rec in per_sub_shd.g_rec_type,
224: p_effective_date in date) is
225: --
226: l_proc varchar2(72) := g_package||'post_update';
227: --

Line 288: p_start_date_o => per_sub_shd.g_old_rec.start_date,

284: p_sub_information18 => p_rec.sub_information18,
285: p_sub_information19 => p_rec.sub_information19,
286: p_sub_information20 => p_rec.sub_information20,
287: p_effective_date => p_effective_date,
288: p_start_date_o => per_sub_shd.g_old_rec.start_date,
289: p_major_o => per_sub_shd.g_old_rec.major,
290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,

Line 289: p_major_o => per_sub_shd.g_old_rec.major,

285: p_sub_information19 => p_rec.sub_information19,
286: p_sub_information20 => p_rec.sub_information20,
287: p_effective_date => p_effective_date,
288: p_start_date_o => per_sub_shd.g_old_rec.start_date,
289: p_major_o => per_sub_shd.g_old_rec.major,
290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,

Line 290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,

286: p_sub_information20 => p_rec.sub_information20,
287: p_effective_date => p_effective_date,
288: p_start_date_o => per_sub_shd.g_old_rec.start_date,
289: p_major_o => per_sub_shd.g_old_rec.major,
290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,

Line 291: p_subject_o => per_sub_shd.g_old_rec.subject,

287: p_effective_date => p_effective_date,
288: p_start_date_o => per_sub_shd.g_old_rec.start_date,
289: p_major_o => per_sub_shd.g_old_rec.major,
290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,

Line 292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,

288: p_start_date_o => per_sub_shd.g_old_rec.start_date,
289: p_major_o => per_sub_shd.g_old_rec.major,
290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,

Line 293: p_end_date_o => per_sub_shd.g_old_rec.end_date,

289: p_major_o => per_sub_shd.g_old_rec.major,
290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,

Line 294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,

290: p_subject_status_o => per_sub_shd.g_old_rec.subject_status,
291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,

Line 295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,

291: p_subject_o => per_sub_shd.g_old_rec.subject,
292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,

Line 296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,

292: p_grade_attained_o => per_sub_shd.g_old_rec.grade_attained,
293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,

Line 297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,

293: p_end_date_o => per_sub_shd.g_old_rec.end_date,
294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,

Line 298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,

294: p_qualification_id_o => per_sub_shd.g_old_rec.qualification_id,
295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,

Line 299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,

295: p_object_version_number_o => per_sub_shd.g_old_rec.object_version_number,
296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,

Line 300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,

296: p_attribute_category_o => per_sub_shd.g_old_rec.attribute_category,
297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,

Line 301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,

297: p_attribute1_o => per_sub_shd.g_old_rec.attribute1,
298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,

Line 302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,

298: p_attribute2_o => per_sub_shd.g_old_rec.attribute2,
299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,

Line 303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,

299: p_attribute3_o => per_sub_shd.g_old_rec.attribute3,
300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,

Line 304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,

300: p_attribute4_o => per_sub_shd.g_old_rec.attribute4,
301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,

Line 305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,

301: p_attribute5_o => per_sub_shd.g_old_rec.attribute5,
302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,

Line 306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,

302: p_attribute6_o => per_sub_shd.g_old_rec.attribute6,
303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,

Line 307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,

303: p_attribute7_o => per_sub_shd.g_old_rec.attribute7,
304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,

Line 308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,

304: p_attribute8_o => per_sub_shd.g_old_rec.attribute8,
305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,

Line 309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,

305: p_attribute9_o => per_sub_shd.g_old_rec.attribute9,
306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,

Line 310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,

306: p_attribute10_o => per_sub_shd.g_old_rec.attribute10,
307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,

Line 311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,

307: p_attribute11_o => per_sub_shd.g_old_rec.attribute11,
308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,

Line 312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,

308: p_attribute12_o => per_sub_shd.g_old_rec.attribute12,
309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,

Line 313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,

309: p_attribute13_o => per_sub_shd.g_old_rec.attribute13,
310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,

Line 314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,

310: p_attribute14_o => per_sub_shd.g_old_rec.attribute14,
311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,

Line 315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,

311: p_attribute15_o => per_sub_shd.g_old_rec.attribute15,
312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,

Line 316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,

312: p_attribute16_o => per_sub_shd.g_old_rec.attribute16,
313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,

Line 317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,

313: p_attribute17_o => per_sub_shd.g_old_rec.attribute17,
314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,

Line 318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,

314: p_attribute18_o => per_sub_shd.g_old_rec.attribute18,
315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,

Line 319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,

315: p_attribute19_o => per_sub_shd.g_old_rec.attribute19,
316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,

Line 320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,

316: p_attribute20_o => per_sub_shd.g_old_rec.attribute20,
317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,

Line 321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,

317: p_sub_information_category_o => per_sub_shd.g_old_rec.sub_information_category,
318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,

Line 322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,

318: p_sub_information1_o => per_sub_shd.g_old_rec.sub_information1,
319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,

Line 323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,

319: p_sub_information2_o => per_sub_shd.g_old_rec.sub_information2,
320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,

Line 324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,

320: p_sub_information3_o => per_sub_shd.g_old_rec.sub_information3,
321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,

Line 325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,

321: p_sub_information4_o => per_sub_shd.g_old_rec.sub_information4,
322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,

Line 326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,

322: p_sub_information5_o => per_sub_shd.g_old_rec.sub_information5,
323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,

Line 327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,

323: p_sub_information6_o => per_sub_shd.g_old_rec.sub_information6,
324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,

Line 328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,

324: p_sub_information7_o => per_sub_shd.g_old_rec.sub_information7,
325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,

Line 329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,

325: p_sub_information8_o => per_sub_shd.g_old_rec.sub_information8,
326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,

Line 330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,

326: p_sub_information9_o => per_sub_shd.g_old_rec.sub_information9,
327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,

Line 331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,

327: p_sub_information10_o => per_sub_shd.g_old_rec.sub_information10,
328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,

Line 332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,

328: p_sub_information11_o => per_sub_shd.g_old_rec.sub_information11,
329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,
336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,

Line 333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,

329: p_sub_information12_o => per_sub_shd.g_old_rec.sub_information12,
330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,
336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,
337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20

Line 334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,

330: p_sub_information13_o => per_sub_shd.g_old_rec.sub_information13,
331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,
336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,
337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20
338: );

Line 335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,

331: p_sub_information14_o => per_sub_shd.g_old_rec.sub_information14,
332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,
336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,
337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20
338: );
339: exception

Line 336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,

332: p_sub_information15_o => per_sub_shd.g_old_rec.sub_information15,
333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,
336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,
337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then

Line 337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20

333: p_sub_information16_o => per_sub_shd.g_old_rec.sub_information16,
334: p_sub_information17_o => per_sub_shd.g_old_rec.sub_information17,
335: p_sub_information18_o => per_sub_shd.g_old_rec.sub_information18,
336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,
337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error

Line 396: Procedure convert_defs(p_rec in out nocopy per_sub_shd.g_rec_type) is

392: -- Internal Table Handler Use Only.
393: --
394: -- {End Of Comments}
395: -- ----------------------------------------------------------------------------
396: Procedure convert_defs(p_rec in out nocopy per_sub_shd.g_rec_type) is
397: --
398: l_proc varchar2(72) := g_package||'convert_defs';
399: --
400: Begin

Line 411: per_sub_shd.g_old_rec.start_date;

407: -- is being used then we must set to the 'current' argument value.
408: --
409: If (p_rec.start_date = hr_api.g_date) then
410: p_rec.start_date :=
411: per_sub_shd.g_old_rec.start_date;
412: End If;
413: If (p_rec.major = hr_api.g_varchar2) then
414: p_rec.major :=
415: per_sub_shd.g_old_rec.major;

Line 415: per_sub_shd.g_old_rec.major;

411: per_sub_shd.g_old_rec.start_date;
412: End If;
413: If (p_rec.major = hr_api.g_varchar2) then
414: p_rec.major :=
415: per_sub_shd.g_old_rec.major;
416: End If;
417: If (p_rec.subject_status = hr_api.g_varchar2) then
418: p_rec.subject_status :=
419: per_sub_shd.g_old_rec.subject_status;

Line 419: per_sub_shd.g_old_rec.subject_status;

415: per_sub_shd.g_old_rec.major;
416: End If;
417: If (p_rec.subject_status = hr_api.g_varchar2) then
418: p_rec.subject_status :=
419: per_sub_shd.g_old_rec.subject_status;
420: End If;
421: If (p_rec.subject = hr_api.g_varchar2) then
422: p_rec.subject :=
423: per_sub_shd.g_old_rec.subject;

Line 423: per_sub_shd.g_old_rec.subject;

419: per_sub_shd.g_old_rec.subject_status;
420: End If;
421: If (p_rec.subject = hr_api.g_varchar2) then
422: p_rec.subject :=
423: per_sub_shd.g_old_rec.subject;
424: End If;
425: If (p_rec.grade_attained = hr_api.g_varchar2) then
426: p_rec.grade_attained :=
427: per_sub_shd.g_old_rec.grade_attained;

Line 427: per_sub_shd.g_old_rec.grade_attained;

423: per_sub_shd.g_old_rec.subject;
424: End If;
425: If (p_rec.grade_attained = hr_api.g_varchar2) then
426: p_rec.grade_attained :=
427: per_sub_shd.g_old_rec.grade_attained;
428: End If;
429: If (p_rec.end_date = hr_api.g_date) then
430: p_rec.end_date :=
431: per_sub_shd.g_old_rec.end_date;

Line 431: per_sub_shd.g_old_rec.end_date;

427: per_sub_shd.g_old_rec.grade_attained;
428: End If;
429: If (p_rec.end_date = hr_api.g_date) then
430: p_rec.end_date :=
431: per_sub_shd.g_old_rec.end_date;
432: End If;
433: If (p_rec.qualification_id = hr_api.g_number) then
434: p_rec.qualification_id :=
435: per_sub_shd.g_old_rec.qualification_id;

Line 435: per_sub_shd.g_old_rec.qualification_id;

431: per_sub_shd.g_old_rec.end_date;
432: End If;
433: If (p_rec.qualification_id = hr_api.g_number) then
434: p_rec.qualification_id :=
435: per_sub_shd.g_old_rec.qualification_id;
436: End If;
437: If (p_rec.attribute_category = hr_api.g_varchar2) then
438: p_rec.attribute_category :=
439: per_sub_shd.g_old_rec.attribute_category;

Line 439: per_sub_shd.g_old_rec.attribute_category;

435: per_sub_shd.g_old_rec.qualification_id;
436: End If;
437: If (p_rec.attribute_category = hr_api.g_varchar2) then
438: p_rec.attribute_category :=
439: per_sub_shd.g_old_rec.attribute_category;
440: End If;
441: If (p_rec.attribute1 = hr_api.g_varchar2) then
442: p_rec.attribute1 :=
443: per_sub_shd.g_old_rec.attribute1;

Line 443: per_sub_shd.g_old_rec.attribute1;

439: per_sub_shd.g_old_rec.attribute_category;
440: End If;
441: If (p_rec.attribute1 = hr_api.g_varchar2) then
442: p_rec.attribute1 :=
443: per_sub_shd.g_old_rec.attribute1;
444: End If;
445: If (p_rec.attribute2 = hr_api.g_varchar2) then
446: p_rec.attribute2 :=
447: per_sub_shd.g_old_rec.attribute2;

Line 447: per_sub_shd.g_old_rec.attribute2;

443: per_sub_shd.g_old_rec.attribute1;
444: End If;
445: If (p_rec.attribute2 = hr_api.g_varchar2) then
446: p_rec.attribute2 :=
447: per_sub_shd.g_old_rec.attribute2;
448: End If;
449: If (p_rec.attribute3 = hr_api.g_varchar2) then
450: p_rec.attribute3 :=
451: per_sub_shd.g_old_rec.attribute3;

Line 451: per_sub_shd.g_old_rec.attribute3;

447: per_sub_shd.g_old_rec.attribute2;
448: End If;
449: If (p_rec.attribute3 = hr_api.g_varchar2) then
450: p_rec.attribute3 :=
451: per_sub_shd.g_old_rec.attribute3;
452: End If;
453: If (p_rec.attribute4 = hr_api.g_varchar2) then
454: p_rec.attribute4 :=
455: per_sub_shd.g_old_rec.attribute4;

Line 455: per_sub_shd.g_old_rec.attribute4;

451: per_sub_shd.g_old_rec.attribute3;
452: End If;
453: If (p_rec.attribute4 = hr_api.g_varchar2) then
454: p_rec.attribute4 :=
455: per_sub_shd.g_old_rec.attribute4;
456: End If;
457: If (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
459: per_sub_shd.g_old_rec.attribute5;

Line 459: per_sub_shd.g_old_rec.attribute5;

455: per_sub_shd.g_old_rec.attribute4;
456: End If;
457: If (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
459: per_sub_shd.g_old_rec.attribute5;
460: End If;
461: If (p_rec.attribute6 = hr_api.g_varchar2) then
462: p_rec.attribute6 :=
463: per_sub_shd.g_old_rec.attribute6;

Line 463: per_sub_shd.g_old_rec.attribute6;

459: per_sub_shd.g_old_rec.attribute5;
460: End If;
461: If (p_rec.attribute6 = hr_api.g_varchar2) then
462: p_rec.attribute6 :=
463: per_sub_shd.g_old_rec.attribute6;
464: End If;
465: If (p_rec.attribute7 = hr_api.g_varchar2) then
466: p_rec.attribute7 :=
467: per_sub_shd.g_old_rec.attribute7;

Line 467: per_sub_shd.g_old_rec.attribute7;

463: per_sub_shd.g_old_rec.attribute6;
464: End If;
465: If (p_rec.attribute7 = hr_api.g_varchar2) then
466: p_rec.attribute7 :=
467: per_sub_shd.g_old_rec.attribute7;
468: End If;
469: If (p_rec.attribute8 = hr_api.g_varchar2) then
470: p_rec.attribute8 :=
471: per_sub_shd.g_old_rec.attribute8;

Line 471: per_sub_shd.g_old_rec.attribute8;

467: per_sub_shd.g_old_rec.attribute7;
468: End If;
469: If (p_rec.attribute8 = hr_api.g_varchar2) then
470: p_rec.attribute8 :=
471: per_sub_shd.g_old_rec.attribute8;
472: End If;
473: If (p_rec.attribute9 = hr_api.g_varchar2) then
474: p_rec.attribute9 :=
475: per_sub_shd.g_old_rec.attribute9;

Line 475: per_sub_shd.g_old_rec.attribute9;

471: per_sub_shd.g_old_rec.attribute8;
472: End If;
473: If (p_rec.attribute9 = hr_api.g_varchar2) then
474: p_rec.attribute9 :=
475: per_sub_shd.g_old_rec.attribute9;
476: End If;
477: If (p_rec.attribute10 = hr_api.g_varchar2) then
478: p_rec.attribute10 :=
479: per_sub_shd.g_old_rec.attribute10;

Line 479: per_sub_shd.g_old_rec.attribute10;

475: per_sub_shd.g_old_rec.attribute9;
476: End If;
477: If (p_rec.attribute10 = hr_api.g_varchar2) then
478: p_rec.attribute10 :=
479: per_sub_shd.g_old_rec.attribute10;
480: End If;
481: If (p_rec.attribute11 = hr_api.g_varchar2) then
482: p_rec.attribute11 :=
483: per_sub_shd.g_old_rec.attribute11;

Line 483: per_sub_shd.g_old_rec.attribute11;

479: per_sub_shd.g_old_rec.attribute10;
480: End If;
481: If (p_rec.attribute11 = hr_api.g_varchar2) then
482: p_rec.attribute11 :=
483: per_sub_shd.g_old_rec.attribute11;
484: End If;
485: If (p_rec.attribute12 = hr_api.g_varchar2) then
486: p_rec.attribute12 :=
487: per_sub_shd.g_old_rec.attribute12;

Line 487: per_sub_shd.g_old_rec.attribute12;

483: per_sub_shd.g_old_rec.attribute11;
484: End If;
485: If (p_rec.attribute12 = hr_api.g_varchar2) then
486: p_rec.attribute12 :=
487: per_sub_shd.g_old_rec.attribute12;
488: End If;
489: If (p_rec.attribute13 = hr_api.g_varchar2) then
490: p_rec.attribute13 :=
491: per_sub_shd.g_old_rec.attribute13;

Line 491: per_sub_shd.g_old_rec.attribute13;

487: per_sub_shd.g_old_rec.attribute12;
488: End If;
489: If (p_rec.attribute13 = hr_api.g_varchar2) then
490: p_rec.attribute13 :=
491: per_sub_shd.g_old_rec.attribute13;
492: End If;
493: If (p_rec.attribute14 = hr_api.g_varchar2) then
494: p_rec.attribute14 :=
495: per_sub_shd.g_old_rec.attribute14;

Line 495: per_sub_shd.g_old_rec.attribute14;

491: per_sub_shd.g_old_rec.attribute13;
492: End If;
493: If (p_rec.attribute14 = hr_api.g_varchar2) then
494: p_rec.attribute14 :=
495: per_sub_shd.g_old_rec.attribute14;
496: End If;
497: If (p_rec.attribute15 = hr_api.g_varchar2) then
498: p_rec.attribute15 :=
499: per_sub_shd.g_old_rec.attribute15;

Line 499: per_sub_shd.g_old_rec.attribute15;

495: per_sub_shd.g_old_rec.attribute14;
496: End If;
497: If (p_rec.attribute15 = hr_api.g_varchar2) then
498: p_rec.attribute15 :=
499: per_sub_shd.g_old_rec.attribute15;
500: End If;
501: If (p_rec.attribute16 = hr_api.g_varchar2) then
502: p_rec.attribute16 :=
503: per_sub_shd.g_old_rec.attribute16;

Line 503: per_sub_shd.g_old_rec.attribute16;

499: per_sub_shd.g_old_rec.attribute15;
500: End If;
501: If (p_rec.attribute16 = hr_api.g_varchar2) then
502: p_rec.attribute16 :=
503: per_sub_shd.g_old_rec.attribute16;
504: End If;
505: If (p_rec.attribute17 = hr_api.g_varchar2) then
506: p_rec.attribute17 :=
507: per_sub_shd.g_old_rec.attribute17;

Line 507: per_sub_shd.g_old_rec.attribute17;

503: per_sub_shd.g_old_rec.attribute16;
504: End If;
505: If (p_rec.attribute17 = hr_api.g_varchar2) then
506: p_rec.attribute17 :=
507: per_sub_shd.g_old_rec.attribute17;
508: End If;
509: If (p_rec.attribute18 = hr_api.g_varchar2) then
510: p_rec.attribute18 :=
511: per_sub_shd.g_old_rec.attribute18;

Line 511: per_sub_shd.g_old_rec.attribute18;

507: per_sub_shd.g_old_rec.attribute17;
508: End If;
509: If (p_rec.attribute18 = hr_api.g_varchar2) then
510: p_rec.attribute18 :=
511: per_sub_shd.g_old_rec.attribute18;
512: End If;
513: If (p_rec.attribute19 = hr_api.g_varchar2) then
514: p_rec.attribute19 :=
515: per_sub_shd.g_old_rec.attribute19;

Line 515: per_sub_shd.g_old_rec.attribute19;

511: per_sub_shd.g_old_rec.attribute18;
512: End If;
513: If (p_rec.attribute19 = hr_api.g_varchar2) then
514: p_rec.attribute19 :=
515: per_sub_shd.g_old_rec.attribute19;
516: End If;
517: If (p_rec.attribute20 = hr_api.g_varchar2) then
518: p_rec.attribute20 :=
519: per_sub_shd.g_old_rec.attribute20;

Line 519: per_sub_shd.g_old_rec.attribute20;

515: per_sub_shd.g_old_rec.attribute19;
516: End If;
517: If (p_rec.attribute20 = hr_api.g_varchar2) then
518: p_rec.attribute20 :=
519: per_sub_shd.g_old_rec.attribute20;
520: End If;
521: If (p_rec.sub_information_category = hr_api.g_varchar2) then
522: p_rec.sub_information_category :=
523: per_sub_shd.g_old_rec.sub_information_category;

Line 523: per_sub_shd.g_old_rec.sub_information_category;

519: per_sub_shd.g_old_rec.attribute20;
520: End If;
521: If (p_rec.sub_information_category = hr_api.g_varchar2) then
522: p_rec.sub_information_category :=
523: per_sub_shd.g_old_rec.sub_information_category;
524: End If;
525: If (p_rec.sub_information1 = hr_api.g_varchar2) then
526: p_rec.sub_information1 :=
527: per_sub_shd.g_old_rec.sub_information1;

Line 527: per_sub_shd.g_old_rec.sub_information1;

523: per_sub_shd.g_old_rec.sub_information_category;
524: End If;
525: If (p_rec.sub_information1 = hr_api.g_varchar2) then
526: p_rec.sub_information1 :=
527: per_sub_shd.g_old_rec.sub_information1;
528: End If;
529: If (p_rec.sub_information2 = hr_api.g_varchar2) then
530: p_rec.sub_information2 :=
531: per_sub_shd.g_old_rec.sub_information2;

Line 531: per_sub_shd.g_old_rec.sub_information2;

527: per_sub_shd.g_old_rec.sub_information1;
528: End If;
529: If (p_rec.sub_information2 = hr_api.g_varchar2) then
530: p_rec.sub_information2 :=
531: per_sub_shd.g_old_rec.sub_information2;
532: End If;
533: If (p_rec.sub_information3 = hr_api.g_varchar2) then
534: p_rec.sub_information3 :=
535: per_sub_shd.g_old_rec.sub_information3;

Line 535: per_sub_shd.g_old_rec.sub_information3;

531: per_sub_shd.g_old_rec.sub_information2;
532: End If;
533: If (p_rec.sub_information3 = hr_api.g_varchar2) then
534: p_rec.sub_information3 :=
535: per_sub_shd.g_old_rec.sub_information3;
536: End If;
537: If (p_rec.sub_information4 = hr_api.g_varchar2) then
538: p_rec.sub_information4 :=
539: per_sub_shd.g_old_rec.sub_information4;

Line 539: per_sub_shd.g_old_rec.sub_information4;

535: per_sub_shd.g_old_rec.sub_information3;
536: End If;
537: If (p_rec.sub_information4 = hr_api.g_varchar2) then
538: p_rec.sub_information4 :=
539: per_sub_shd.g_old_rec.sub_information4;
540: End If;
541: If (p_rec.sub_information5 = hr_api.g_varchar2) then
542: p_rec.sub_information5 :=
543: per_sub_shd.g_old_rec.sub_information5;

Line 543: per_sub_shd.g_old_rec.sub_information5;

539: per_sub_shd.g_old_rec.sub_information4;
540: End If;
541: If (p_rec.sub_information5 = hr_api.g_varchar2) then
542: p_rec.sub_information5 :=
543: per_sub_shd.g_old_rec.sub_information5;
544: End If;
545: If (p_rec.sub_information6 = hr_api.g_varchar2) then
546: p_rec.sub_information6 :=
547: per_sub_shd.g_old_rec.sub_information6;

Line 547: per_sub_shd.g_old_rec.sub_information6;

543: per_sub_shd.g_old_rec.sub_information5;
544: End If;
545: If (p_rec.sub_information6 = hr_api.g_varchar2) then
546: p_rec.sub_information6 :=
547: per_sub_shd.g_old_rec.sub_information6;
548: End If;
549: If (p_rec.sub_information7 = hr_api.g_varchar2) then
550: p_rec.sub_information7 :=
551: per_sub_shd.g_old_rec.sub_information7;

Line 551: per_sub_shd.g_old_rec.sub_information7;

547: per_sub_shd.g_old_rec.sub_information6;
548: End If;
549: If (p_rec.sub_information7 = hr_api.g_varchar2) then
550: p_rec.sub_information7 :=
551: per_sub_shd.g_old_rec.sub_information7;
552: End If;
553: If (p_rec.sub_information8 = hr_api.g_varchar2) then
554: p_rec.sub_information8 :=
555: per_sub_shd.g_old_rec.sub_information8;

Line 555: per_sub_shd.g_old_rec.sub_information8;

551: per_sub_shd.g_old_rec.sub_information7;
552: End If;
553: If (p_rec.sub_information8 = hr_api.g_varchar2) then
554: p_rec.sub_information8 :=
555: per_sub_shd.g_old_rec.sub_information8;
556: End If;
557: If (p_rec.sub_information9 = hr_api.g_varchar2) then
558: p_rec.sub_information9 :=
559: per_sub_shd.g_old_rec.sub_information9;

Line 559: per_sub_shd.g_old_rec.sub_information9;

555: per_sub_shd.g_old_rec.sub_information8;
556: End If;
557: If (p_rec.sub_information9 = hr_api.g_varchar2) then
558: p_rec.sub_information9 :=
559: per_sub_shd.g_old_rec.sub_information9;
560: End If;
561: If (p_rec.sub_information10 = hr_api.g_varchar2) then
562: p_rec.sub_information10 :=
563: per_sub_shd.g_old_rec.sub_information10;

Line 563: per_sub_shd.g_old_rec.sub_information10;

559: per_sub_shd.g_old_rec.sub_information9;
560: End If;
561: If (p_rec.sub_information10 = hr_api.g_varchar2) then
562: p_rec.sub_information10 :=
563: per_sub_shd.g_old_rec.sub_information10;
564: End If;
565: If (p_rec.sub_information11 = hr_api.g_varchar2) then
566: p_rec.sub_information11 :=
567: per_sub_shd.g_old_rec.sub_information11;

Line 567: per_sub_shd.g_old_rec.sub_information11;

563: per_sub_shd.g_old_rec.sub_information10;
564: End If;
565: If (p_rec.sub_information11 = hr_api.g_varchar2) then
566: p_rec.sub_information11 :=
567: per_sub_shd.g_old_rec.sub_information11;
568: End If;
569: If (p_rec.sub_information12 = hr_api.g_varchar2) then
570: p_rec.sub_information12 :=
571: per_sub_shd.g_old_rec.sub_information12;

Line 571: per_sub_shd.g_old_rec.sub_information12;

567: per_sub_shd.g_old_rec.sub_information11;
568: End If;
569: If (p_rec.sub_information12 = hr_api.g_varchar2) then
570: p_rec.sub_information12 :=
571: per_sub_shd.g_old_rec.sub_information12;
572: End If;
573: If (p_rec.sub_information13 = hr_api.g_varchar2) then
574: p_rec.sub_information13 :=
575: per_sub_shd.g_old_rec.sub_information13;

Line 575: per_sub_shd.g_old_rec.sub_information13;

571: per_sub_shd.g_old_rec.sub_information12;
572: End If;
573: If (p_rec.sub_information13 = hr_api.g_varchar2) then
574: p_rec.sub_information13 :=
575: per_sub_shd.g_old_rec.sub_information13;
576: End If;
577: If (p_rec.sub_information14 = hr_api.g_varchar2) then
578: p_rec.sub_information14 :=
579: per_sub_shd.g_old_rec.sub_information14;

Line 579: per_sub_shd.g_old_rec.sub_information14;

575: per_sub_shd.g_old_rec.sub_information13;
576: End If;
577: If (p_rec.sub_information14 = hr_api.g_varchar2) then
578: p_rec.sub_information14 :=
579: per_sub_shd.g_old_rec.sub_information14;
580: End If;
581: If (p_rec.sub_information15 = hr_api.g_varchar2) then
582: p_rec.sub_information15 :=
583: per_sub_shd.g_old_rec.sub_information15;

Line 583: per_sub_shd.g_old_rec.sub_information15;

579: per_sub_shd.g_old_rec.sub_information14;
580: End If;
581: If (p_rec.sub_information15 = hr_api.g_varchar2) then
582: p_rec.sub_information15 :=
583: per_sub_shd.g_old_rec.sub_information15;
584: End If;
585: If (p_rec.sub_information16 = hr_api.g_varchar2) then
586: p_rec.sub_information16 :=
587: per_sub_shd.g_old_rec.sub_information16;

Line 587: per_sub_shd.g_old_rec.sub_information16;

583: per_sub_shd.g_old_rec.sub_information15;
584: End If;
585: If (p_rec.sub_information16 = hr_api.g_varchar2) then
586: p_rec.sub_information16 :=
587: per_sub_shd.g_old_rec.sub_information16;
588: End If;
589: If (p_rec.sub_information17 = hr_api.g_varchar2) then
590: p_rec.sub_information17 :=
591: per_sub_shd.g_old_rec.sub_information17;

Line 591: per_sub_shd.g_old_rec.sub_information17;

587: per_sub_shd.g_old_rec.sub_information16;
588: End If;
589: If (p_rec.sub_information17 = hr_api.g_varchar2) then
590: p_rec.sub_information17 :=
591: per_sub_shd.g_old_rec.sub_information17;
592: End If;
593: If (p_rec.sub_information18 = hr_api.g_varchar2) then
594: p_rec.sub_information18 :=
595: per_sub_shd.g_old_rec.sub_information18;

Line 595: per_sub_shd.g_old_rec.sub_information18;

591: per_sub_shd.g_old_rec.sub_information17;
592: End If;
593: If (p_rec.sub_information18 = hr_api.g_varchar2) then
594: p_rec.sub_information18 :=
595: per_sub_shd.g_old_rec.sub_information18;
596: End If;
597: If (p_rec.sub_information19 = hr_api.g_varchar2) then
598: p_rec.sub_information19 :=
599: per_sub_shd.g_old_rec.sub_information19;

Line 599: per_sub_shd.g_old_rec.sub_information19;

595: per_sub_shd.g_old_rec.sub_information18;
596: End If;
597: If (p_rec.sub_information19 = hr_api.g_varchar2) then
598: p_rec.sub_information19 :=
599: per_sub_shd.g_old_rec.sub_information19;
600: End If;
601: If (p_rec.sub_information20 = hr_api.g_varchar2) then
602: p_rec.sub_information20 :=
603: per_sub_shd.g_old_rec.sub_information20;

Line 603: per_sub_shd.g_old_rec.sub_information20;

599: per_sub_shd.g_old_rec.sub_information19;
600: End If;
601: If (p_rec.sub_information20 = hr_api.g_varchar2) then
602: p_rec.sub_information20 :=
603: per_sub_shd.g_old_rec.sub_information20;
604: End If;
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 10);
607: --

Line 615: p_rec in out nocopy per_sub_shd.g_rec_type,

611: -- |---------------------------------< upd >----------------------------------|
612: -- ----------------------------------------------------------------------------
613: Procedure upd
614: (
615: p_rec in out nocopy per_sub_shd.g_rec_type,
616: p_effective_date in date,
617: p_validate in boolean default false
618: ) is
619: --

Line 636: per_sub_shd.lck

632: End If;
633: --
634: -- We must lock the row which we need to update.
635: --
636: per_sub_shd.lck
637: (
638: p_rec.subjects_taken_id,
639: p_rec.object_version_number
640: );

Line 739: l_rec per_sub_shd.g_rec_type;

735: p_effective_date in date,
736: p_validate in boolean default false
737: ) is
738: --
739: l_rec per_sub_shd.g_rec_type;
740: l_proc varchar2(72) := g_package||'upd';
741: --
742: Begin
743: hr_utility.set_location('Entering:'||l_proc, 5);

Line 749: per_sub_shd.convert_args

745: -- Call conversion function to turn arguments into the
746: -- l_rec structure.
747: --
748: l_rec :=
749: per_sub_shd.convert_args
750: (
751: p_subjects_taken_id,
752: p_start_date,
753: p_major,