DBA Data[Home] [Help]

APPS.PER_PEA_UPD dependencies on PER_PEA_SHD

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

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

Line 104: per_pea_shd.g_api_dml := false; -- Unset the api dml status

100: attribute20 = p_rec.attribute20,
101: object_version_number = p_rec.object_version_number
102: where person_analysis_id = p_rec.person_analysis_id;
103: --
104: per_pea_shd.g_api_dml := false; -- Unset the api dml status
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: Exception

Line 111: per_pea_shd.g_api_dml := false; -- Unset the api dml status

107: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated

Line 112: per_pea_shd.constraint_error

108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status

Line 116: per_pea_shd.g_api_dml := false; -- Unset the api dml status

112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated

Line 117: per_pea_shd.constraint_error

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

Line 121: per_pea_shd.g_api_dml := false; -- Unset the api dml status

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

Line 122: per_pea_shd.constraint_error

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

Line 125: per_pea_shd.g_api_dml := false; -- Unset the api dml status

121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pea_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
127: End update_dml;
128: --
129: -- ----------------------------------------------------------------------------

Line 161: Procedure pre_update(p_rec in per_pea_shd.g_rec_type) is

157: -- Internal Table Handler Use Only.
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_update(p_rec in per_pea_shd.g_rec_type) is
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --
165: Begin

Line 204: (p_rec in per_pea_shd.g_rec_type) is

200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure post_update
204: (p_rec in per_pea_shd.g_rec_type) is
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207:
208: -- For BEN LER Check

Line 252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,

248: p_attribute18 => p_rec.attribute18,
249: p_attribute19 => p_rec.attribute19,
250: p_attribute20 => p_rec.attribute20,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,

Line 253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,

249: p_attribute19 => p_rec.attribute19,
250: p_attribute20 => p_rec.attribute20,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,

Line 254: p_person_id_o => per_pea_shd.g_old_rec.person_id,

250: p_attribute20 => p_rec.attribute20,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,

Line 255: p_comments_o => per_pea_shd.g_old_rec.comments,

251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,

Line 256: p_date_from_o => per_pea_shd.g_old_rec.date_from,

252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,

Line 257: p_date_to_o => per_pea_shd.g_old_rec.date_to,

253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,

Line 258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,

254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,

Line 259: p_request_id_o => per_pea_shd.g_old_rec.request_id,

255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,

Line 260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,

256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,

Line 261: p_program_id_o => per_pea_shd.g_old_rec.program_id,

257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,

Line 262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,

258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,

Line 263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,

259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,

Line 264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,

260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,

Line 265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,

261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,

Line 266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,

262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,

Line 267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,

263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,

Line 268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,

264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,

Line 269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,

265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,

Line 270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,

266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,

Line 271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,

267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,

Line 272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,

268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,

Line 273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,

269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,

Line 274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,

270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,

Line 275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,

271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,

Line 276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,

272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,

Line 277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,

273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,

Line 278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,

274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,

Line 279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,

275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,

Line 280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,

276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number

Line 281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,

277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );

Line 282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,

278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:

Line 283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,

279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
287: -- Start of BEN LER Check

Line 284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number

280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;

Line 288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;

284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;

Line 289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;

285: );
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;

Line 290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;

286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;

Line 291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;

287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;

Line 292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;

288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;

Line 293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;

289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;

Line 294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;

290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;

Line 295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;

291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;

Line 296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;

292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;

Line 297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;

293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;

Line 298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;

294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;

Line 299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;

295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;

Line 300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;

296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;

Line 301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;

297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;

Line 302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;

298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;

Line 303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;

299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;

Line 304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;

300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;

Line 305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;

301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;

Line 306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;

302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;

Line 307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;

303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;

Line 308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;

304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;

Line 309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;

305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;

Line 310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;

306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:

Line 311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;

307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
315: l_new_rec.person_id := p_rec.person_id;

Line 312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;

308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
315: l_new_rec.person_id := p_rec.person_id;
316: l_new_rec.business_group_id := p_rec.business_group_id;

Line 313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;

309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
315: l_new_rec.person_id := p_rec.person_id;
316: l_new_rec.business_group_id := p_rec.business_group_id;
317: l_new_rec.ANALYSIS_CRITERIA_ID := p_rec.ANALYSIS_CRITERIA_ID;

Line 409: Procedure convert_defs(p_rec in out nocopy per_pea_shd.g_rec_type) is

405: -- Internal Table Handler Use Only.
406: --
407: -- {End Of Comments}
408: -- ----------------------------------------------------------------------------
409: Procedure convert_defs(p_rec in out nocopy per_pea_shd.g_rec_type) is
410: --
411: l_proc varchar2(72) := g_package||'convert_defs';
412: --
413: Begin

Line 424: per_pea_shd.g_old_rec.business_group_id;

420: -- is being used then we must set to the 'current' argument value.
421: --
422: If (p_rec.business_group_id = hr_api.g_number) then
423: p_rec.business_group_id :=
424: per_pea_shd.g_old_rec.business_group_id;
425: End If;
426: If (p_rec.analysis_criteria_id = hr_api.g_number) then
427: p_rec.analysis_criteria_id :=
428: per_pea_shd.g_old_rec.analysis_criteria_id;

Line 428: per_pea_shd.g_old_rec.analysis_criteria_id;

424: per_pea_shd.g_old_rec.business_group_id;
425: End If;
426: If (p_rec.analysis_criteria_id = hr_api.g_number) then
427: p_rec.analysis_criteria_id :=
428: per_pea_shd.g_old_rec.analysis_criteria_id;
429: End If;
430: If (p_rec.person_id = hr_api.g_number) then
431: p_rec.person_id :=
432: per_pea_shd.g_old_rec.person_id;

Line 432: per_pea_shd.g_old_rec.person_id;

428: per_pea_shd.g_old_rec.analysis_criteria_id;
429: End If;
430: If (p_rec.person_id = hr_api.g_number) then
431: p_rec.person_id :=
432: per_pea_shd.g_old_rec.person_id;
433: End If;
434: If (p_rec.comments = hr_api.g_varchar2) then
435: p_rec.comments :=
436: per_pea_shd.g_old_rec.comments;

Line 436: per_pea_shd.g_old_rec.comments;

432: per_pea_shd.g_old_rec.person_id;
433: End If;
434: If (p_rec.comments = hr_api.g_varchar2) then
435: p_rec.comments :=
436: per_pea_shd.g_old_rec.comments;
437: End If;
438: If (p_rec.date_from = hr_api.g_date) then
439: p_rec.date_from :=
440: per_pea_shd.g_old_rec.date_from;

Line 440: per_pea_shd.g_old_rec.date_from;

436: per_pea_shd.g_old_rec.comments;
437: End If;
438: If (p_rec.date_from = hr_api.g_date) then
439: p_rec.date_from :=
440: per_pea_shd.g_old_rec.date_from;
441: End If;
442: If (p_rec.date_to = hr_api.g_date) then
443: p_rec.date_to :=
444: per_pea_shd.g_old_rec.date_to;

Line 444: per_pea_shd.g_old_rec.date_to;

440: per_pea_shd.g_old_rec.date_from;
441: End If;
442: If (p_rec.date_to = hr_api.g_date) then
443: p_rec.date_to :=
444: per_pea_shd.g_old_rec.date_to;
445: End If;
446: If (p_rec.id_flex_num = hr_api.g_number) then
447: p_rec.id_flex_num :=
448: per_pea_shd.g_old_rec.id_flex_num;

Line 448: per_pea_shd.g_old_rec.id_flex_num;

444: per_pea_shd.g_old_rec.date_to;
445: End If;
446: If (p_rec.id_flex_num = hr_api.g_number) then
447: p_rec.id_flex_num :=
448: per_pea_shd.g_old_rec.id_flex_num;
449: End If;
450: If (p_rec.request_id = hr_api.g_number) then
451: p_rec.request_id :=
452: per_pea_shd.g_old_rec.request_id;

Line 452: per_pea_shd.g_old_rec.request_id;

448: per_pea_shd.g_old_rec.id_flex_num;
449: End If;
450: If (p_rec.request_id = hr_api.g_number) then
451: p_rec.request_id :=
452: per_pea_shd.g_old_rec.request_id;
453: End If;
454: If (p_rec.program_application_id = hr_api.g_number) then
455: p_rec.program_application_id :=
456: per_pea_shd.g_old_rec.program_application_id;

Line 456: per_pea_shd.g_old_rec.program_application_id;

452: per_pea_shd.g_old_rec.request_id;
453: End If;
454: If (p_rec.program_application_id = hr_api.g_number) then
455: p_rec.program_application_id :=
456: per_pea_shd.g_old_rec.program_application_id;
457: End If;
458: If (p_rec.program_id = hr_api.g_number) then
459: p_rec.program_id :=
460: per_pea_shd.g_old_rec.program_id;

Line 460: per_pea_shd.g_old_rec.program_id;

456: per_pea_shd.g_old_rec.program_application_id;
457: End If;
458: If (p_rec.program_id = hr_api.g_number) then
459: p_rec.program_id :=
460: per_pea_shd.g_old_rec.program_id;
461: End If;
462: If (p_rec.program_update_date = hr_api.g_date) then
463: p_rec.program_update_date :=
464: per_pea_shd.g_old_rec.program_update_date;

Line 464: per_pea_shd.g_old_rec.program_update_date;

460: per_pea_shd.g_old_rec.program_id;
461: End If;
462: If (p_rec.program_update_date = hr_api.g_date) then
463: p_rec.program_update_date :=
464: per_pea_shd.g_old_rec.program_update_date;
465: End If;
466: If (p_rec.attribute_category = hr_api.g_varchar2) then
467: p_rec.attribute_category :=
468: per_pea_shd.g_old_rec.attribute_category;

Line 468: per_pea_shd.g_old_rec.attribute_category;

464: per_pea_shd.g_old_rec.program_update_date;
465: End If;
466: If (p_rec.attribute_category = hr_api.g_varchar2) then
467: p_rec.attribute_category :=
468: per_pea_shd.g_old_rec.attribute_category;
469: End If;
470: If (p_rec.attribute1 = hr_api.g_varchar2) then
471: p_rec.attribute1 :=
472: per_pea_shd.g_old_rec.attribute1;

Line 472: per_pea_shd.g_old_rec.attribute1;

468: per_pea_shd.g_old_rec.attribute_category;
469: End If;
470: If (p_rec.attribute1 = hr_api.g_varchar2) then
471: p_rec.attribute1 :=
472: per_pea_shd.g_old_rec.attribute1;
473: End If;
474: If (p_rec.attribute2 = hr_api.g_varchar2) then
475: p_rec.attribute2 :=
476: per_pea_shd.g_old_rec.attribute2;

Line 476: per_pea_shd.g_old_rec.attribute2;

472: per_pea_shd.g_old_rec.attribute1;
473: End If;
474: If (p_rec.attribute2 = hr_api.g_varchar2) then
475: p_rec.attribute2 :=
476: per_pea_shd.g_old_rec.attribute2;
477: End If;
478: If (p_rec.attribute3 = hr_api.g_varchar2) then
479: p_rec.attribute3 :=
480: per_pea_shd.g_old_rec.attribute3;

Line 480: per_pea_shd.g_old_rec.attribute3;

476: per_pea_shd.g_old_rec.attribute2;
477: End If;
478: If (p_rec.attribute3 = hr_api.g_varchar2) then
479: p_rec.attribute3 :=
480: per_pea_shd.g_old_rec.attribute3;
481: End If;
482: If (p_rec.attribute4 = hr_api.g_varchar2) then
483: p_rec.attribute4 :=
484: per_pea_shd.g_old_rec.attribute4;

Line 484: per_pea_shd.g_old_rec.attribute4;

480: per_pea_shd.g_old_rec.attribute3;
481: End If;
482: If (p_rec.attribute4 = hr_api.g_varchar2) then
483: p_rec.attribute4 :=
484: per_pea_shd.g_old_rec.attribute4;
485: End If;
486: If (p_rec.attribute5 = hr_api.g_varchar2) then
487: p_rec.attribute5 :=
488: per_pea_shd.g_old_rec.attribute5;

Line 488: per_pea_shd.g_old_rec.attribute5;

484: per_pea_shd.g_old_rec.attribute4;
485: End If;
486: If (p_rec.attribute5 = hr_api.g_varchar2) then
487: p_rec.attribute5 :=
488: per_pea_shd.g_old_rec.attribute5;
489: End If;
490: If (p_rec.attribute6 = hr_api.g_varchar2) then
491: p_rec.attribute6 :=
492: per_pea_shd.g_old_rec.attribute6;

Line 492: per_pea_shd.g_old_rec.attribute6;

488: per_pea_shd.g_old_rec.attribute5;
489: End If;
490: If (p_rec.attribute6 = hr_api.g_varchar2) then
491: p_rec.attribute6 :=
492: per_pea_shd.g_old_rec.attribute6;
493: End If;
494: If (p_rec.attribute7 = hr_api.g_varchar2) then
495: p_rec.attribute7 :=
496: per_pea_shd.g_old_rec.attribute7;

Line 496: per_pea_shd.g_old_rec.attribute7;

492: per_pea_shd.g_old_rec.attribute6;
493: End If;
494: If (p_rec.attribute7 = hr_api.g_varchar2) then
495: p_rec.attribute7 :=
496: per_pea_shd.g_old_rec.attribute7;
497: End If;
498: If (p_rec.attribute8 = hr_api.g_varchar2) then
499: p_rec.attribute8 :=
500: per_pea_shd.g_old_rec.attribute8;

Line 500: per_pea_shd.g_old_rec.attribute8;

496: per_pea_shd.g_old_rec.attribute7;
497: End If;
498: If (p_rec.attribute8 = hr_api.g_varchar2) then
499: p_rec.attribute8 :=
500: per_pea_shd.g_old_rec.attribute8;
501: End If;
502: If (p_rec.attribute9 = hr_api.g_varchar2) then
503: p_rec.attribute9 :=
504: per_pea_shd.g_old_rec.attribute9;

Line 504: per_pea_shd.g_old_rec.attribute9;

500: per_pea_shd.g_old_rec.attribute8;
501: End If;
502: If (p_rec.attribute9 = hr_api.g_varchar2) then
503: p_rec.attribute9 :=
504: per_pea_shd.g_old_rec.attribute9;
505: End If;
506: If (p_rec.attribute10 = hr_api.g_varchar2) then
507: p_rec.attribute10 :=
508: per_pea_shd.g_old_rec.attribute10;

Line 508: per_pea_shd.g_old_rec.attribute10;

504: per_pea_shd.g_old_rec.attribute9;
505: End If;
506: If (p_rec.attribute10 = hr_api.g_varchar2) then
507: p_rec.attribute10 :=
508: per_pea_shd.g_old_rec.attribute10;
509: End If;
510: If (p_rec.attribute11 = hr_api.g_varchar2) then
511: p_rec.attribute11 :=
512: per_pea_shd.g_old_rec.attribute11;

Line 512: per_pea_shd.g_old_rec.attribute11;

508: per_pea_shd.g_old_rec.attribute10;
509: End If;
510: If (p_rec.attribute11 = hr_api.g_varchar2) then
511: p_rec.attribute11 :=
512: per_pea_shd.g_old_rec.attribute11;
513: End If;
514: If (p_rec.attribute12 = hr_api.g_varchar2) then
515: p_rec.attribute12 :=
516: per_pea_shd.g_old_rec.attribute12;

Line 516: per_pea_shd.g_old_rec.attribute12;

512: per_pea_shd.g_old_rec.attribute11;
513: End If;
514: If (p_rec.attribute12 = hr_api.g_varchar2) then
515: p_rec.attribute12 :=
516: per_pea_shd.g_old_rec.attribute12;
517: End If;
518: If (p_rec.attribute13 = hr_api.g_varchar2) then
519: p_rec.attribute13 :=
520: per_pea_shd.g_old_rec.attribute13;

Line 520: per_pea_shd.g_old_rec.attribute13;

516: per_pea_shd.g_old_rec.attribute12;
517: End If;
518: If (p_rec.attribute13 = hr_api.g_varchar2) then
519: p_rec.attribute13 :=
520: per_pea_shd.g_old_rec.attribute13;
521: End If;
522: If (p_rec.attribute14 = hr_api.g_varchar2) then
523: p_rec.attribute14 :=
524: per_pea_shd.g_old_rec.attribute14;

Line 524: per_pea_shd.g_old_rec.attribute14;

520: per_pea_shd.g_old_rec.attribute13;
521: End If;
522: If (p_rec.attribute14 = hr_api.g_varchar2) then
523: p_rec.attribute14 :=
524: per_pea_shd.g_old_rec.attribute14;
525: End If;
526: If (p_rec.attribute15 = hr_api.g_varchar2) then
527: p_rec.attribute15 :=
528: per_pea_shd.g_old_rec.attribute15;

Line 528: per_pea_shd.g_old_rec.attribute15;

524: per_pea_shd.g_old_rec.attribute14;
525: End If;
526: If (p_rec.attribute15 = hr_api.g_varchar2) then
527: p_rec.attribute15 :=
528: per_pea_shd.g_old_rec.attribute15;
529: End If;
530: If (p_rec.attribute16 = hr_api.g_varchar2) then
531: p_rec.attribute16 :=
532: per_pea_shd.g_old_rec.attribute16;

Line 532: per_pea_shd.g_old_rec.attribute16;

528: per_pea_shd.g_old_rec.attribute15;
529: End If;
530: If (p_rec.attribute16 = hr_api.g_varchar2) then
531: p_rec.attribute16 :=
532: per_pea_shd.g_old_rec.attribute16;
533: End If;
534: If (p_rec.attribute17 = hr_api.g_varchar2) then
535: p_rec.attribute17 :=
536: per_pea_shd.g_old_rec.attribute17;

Line 536: per_pea_shd.g_old_rec.attribute17;

532: per_pea_shd.g_old_rec.attribute16;
533: End If;
534: If (p_rec.attribute17 = hr_api.g_varchar2) then
535: p_rec.attribute17 :=
536: per_pea_shd.g_old_rec.attribute17;
537: End If;
538: If (p_rec.attribute18 = hr_api.g_varchar2) then
539: p_rec.attribute18 :=
540: per_pea_shd.g_old_rec.attribute18;

Line 540: per_pea_shd.g_old_rec.attribute18;

536: per_pea_shd.g_old_rec.attribute17;
537: End If;
538: If (p_rec.attribute18 = hr_api.g_varchar2) then
539: p_rec.attribute18 :=
540: per_pea_shd.g_old_rec.attribute18;
541: End If;
542: If (p_rec.attribute19 = hr_api.g_varchar2) then
543: p_rec.attribute19 :=
544: per_pea_shd.g_old_rec.attribute19;

Line 544: per_pea_shd.g_old_rec.attribute19;

540: per_pea_shd.g_old_rec.attribute18;
541: End If;
542: If (p_rec.attribute19 = hr_api.g_varchar2) then
543: p_rec.attribute19 :=
544: per_pea_shd.g_old_rec.attribute19;
545: End If;
546: If (p_rec.attribute20 = hr_api.g_varchar2) then
547: p_rec.attribute20 :=
548: per_pea_shd.g_old_rec.attribute20;

Line 548: per_pea_shd.g_old_rec.attribute20;

544: per_pea_shd.g_old_rec.attribute19;
545: End If;
546: If (p_rec.attribute20 = hr_api.g_varchar2) then
547: p_rec.attribute20 :=
548: per_pea_shd.g_old_rec.attribute20;
549: End If;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: --

Line 560: p_rec in out nocopy per_pea_shd.g_rec_type,

556: -- |---------------------------------< upd >----------------------------------|
557: -- ----------------------------------------------------------------------------
558: Procedure upd
559: (
560: p_rec in out nocopy per_pea_shd.g_rec_type,
561: p_validate in boolean default false
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';

Line 565: l_rec per_pea_shd.g_rec_type;

561: p_validate in boolean default false
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';
565: l_rec per_pea_shd.g_rec_type;
566: l_object_version_number number;
567:
568: --
569: Begin

Line 585: per_pea_shd.lck

581: End If;
582: --
583: -- We must lock the row which we need to update.
584: --
585: per_pea_shd.lck
586: (
587: p_rec.person_analysis_id,
588: p_rec.object_version_number
589: );

Line 677: l_rec per_pea_shd.g_rec_type;

673: p_object_version_number in out nocopy number,
674: p_validate in boolean default false
675: ) is
676: --
677: l_rec per_pea_shd.g_rec_type;
678: l_proc varchar2(72) := g_package||'upd';
679: --
680: Begin
681: hr_utility.set_location('Entering:'||l_proc, 5);

Line 687: per_pea_shd.convert_args

683: -- Call conversion function to turn arguments into the
684: -- l_rec structure.
685: --
686: l_rec :=
687: per_pea_shd.convert_args
688: (
689: p_person_analysis_id,
690: hr_api.g_number,
691: p_analysis_criteria_id,