DBA Data[Home] [Help]

APPS.PER_JOB_UPD dependencies on PER_JOB_SHD

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

Line 65: per_job_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_job_shd.g_api_dml := true; -- Set the api dml status
66:
67: -- Bug 3213714
68: -- Restricting size of the name column
69: p_rec.name := substr(p_rec.name,1,700);

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

136:
137: --
138: hr_utility.set_location('Entering:'||l_proc, 7);
139: --
140: per_job_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: --
144: Exception

Line 148: per_job_shd.g_api_dml := false; -- Unset the api dml status

144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: hr_utility.set_location('Entering:'||l_proc, 20);
148: per_job_shd.g_api_dml := false; -- Unset the api dml status
149: per_job_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: hr_utility.set_location('Entering:'||l_proc, 21);

Line 149: per_job_shd.constraint_error

145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: hr_utility.set_location('Entering:'||l_proc, 20);
148: per_job_shd.g_api_dml := false; -- Unset the api dml status
149: per_job_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: hr_utility.set_location('Entering:'||l_proc, 21);
153: -- Parent integrity has been violated

Line 154: per_job_shd.g_api_dml := false; -- Unset the api dml status

150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: hr_utility.set_location('Entering:'||l_proc, 21);
153: -- Parent integrity has been violated
154: per_job_shd.g_api_dml := false; -- Unset the api dml status
155: per_job_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: hr_utility.set_location('Entering:'||l_proc, 22);

Line 155: per_job_shd.constraint_error

151: When hr_api.parent_integrity_violated Then
152: hr_utility.set_location('Entering:'||l_proc, 21);
153: -- Parent integrity has been violated
154: per_job_shd.g_api_dml := false; -- Unset the api dml status
155: per_job_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: hr_utility.set_location('Entering:'||l_proc, 22);
159: -- Unique integrity has been violated

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

156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: hr_utility.set_location('Entering:'||l_proc, 22);
159: -- Unique integrity has been violated
160: per_job_shd.g_api_dml := false; -- Unset the api dml status
161: per_job_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: hr_utility.set_location('Entering:'||l_proc, 23);

Line 161: per_job_shd.constraint_error

157: When hr_api.unique_integrity_violated Then
158: hr_utility.set_location('Entering:'||l_proc, 22);
159: -- Unique integrity has been violated
160: per_job_shd.g_api_dml := false; -- Unset the api dml status
161: per_job_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: hr_utility.set_location('Entering:'||l_proc, 23);
165: per_job_shd.g_api_dml := false; -- Unset the api dml status

Line 165: per_job_shd.g_api_dml := false; -- Unset the api dml status

161: per_job_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: hr_utility.set_location('Entering:'||l_proc, 23);
165: per_job_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
167: End update_dml;
168: --
169: -- ----------------------------------------------------------------------------

Line 201: Procedure pre_update(p_rec in per_job_shd.g_rec_type) is

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

Line 243: Procedure post_update(p_rec in per_job_shd.g_rec_type) is

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

Line 311: p_business_group_id_o => per_job_shd.g_old_rec.business_group_id,

307: p_benchmark_job_id => p_rec.benchmark_job_id,
308: p_emp_rights_flag => p_rec.emp_rights_flag,
309: p_job_group_id => p_rec.job_group_id,
310: p_object_version_number => p_rec.object_version_number,
311: p_business_group_id_o => per_job_shd.g_old_rec.business_group_id,
312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,
313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,

Line 312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,

308: p_emp_rights_flag => p_rec.emp_rights_flag,
309: p_job_group_id => p_rec.job_group_id,
310: p_object_version_number => p_rec.object_version_number,
311: p_business_group_id_o => per_job_shd.g_old_rec.business_group_id,
312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,
313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,

Line 313: p_date_from_o => per_job_shd.g_old_rec.date_from,

309: p_job_group_id => p_rec.job_group_id,
310: p_object_version_number => p_rec.object_version_number,
311: p_business_group_id_o => per_job_shd.g_old_rec.business_group_id,
312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,
313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,

Line 314: p_comments_o => per_job_shd.g_old_rec.comments,

310: p_object_version_number => p_rec.object_version_number,
311: p_business_group_id_o => per_job_shd.g_old_rec.business_group_id,
312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,
313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,

Line 315: p_date_to_o => per_job_shd.g_old_rec.date_to,

311: p_business_group_id_o => per_job_shd.g_old_rec.business_group_id,
312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,
313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,

Line 316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,

312: p_job_definition_id_o => per_job_shd.g_old_rec.job_definition_id,
313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,

Line 317: p_name_o => per_job_shd.g_old_rec.name,

313: p_date_from_o => per_job_shd.g_old_rec.date_from,
314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,

Line 318: p_request_id_o => per_job_shd.g_old_rec.request_id,

314: p_comments_o => per_job_shd.g_old_rec.comments,
315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,

Line 319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,

315: p_date_to_o => per_job_shd.g_old_rec.date_to,
316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,

Line 320: p_program_id_o => per_job_shd.g_old_rec.program_id,

316: p_approval_authority_o => per_job_shd.g_old_rec.approval_authority,
317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,

Line 321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,

317: p_name_o => per_job_shd.g_old_rec.name,
318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,

Line 322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,

318: p_request_id_o => per_job_shd.g_old_rec.request_id,
319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,

Line 323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,

319: p_program_application_id_o => per_job_shd.g_old_rec.program_application_id,
320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,

Line 324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,

320: p_program_id_o => per_job_shd.g_old_rec.program_id,
321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,

Line 325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,

321: p_program_update_date_o => per_job_shd.g_old_rec.program_update_date,
322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,

Line 326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,

322: p_attribute_category_o => per_job_shd.g_old_rec.attribute_category,
323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,

Line 327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,

323: p_attribute1_o => per_job_shd.g_old_rec.attribute1,
324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,

Line 328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,

324: p_attribute2_o => per_job_shd.g_old_rec.attribute2,
325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,

Line 329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,

325: p_attribute3_o => per_job_shd.g_old_rec.attribute3,
326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,

Line 330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,

326: p_attribute4_o => per_job_shd.g_old_rec.attribute4,
327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,

Line 331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,

327: p_attribute5_o => per_job_shd.g_old_rec.attribute5,
328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,

Line 332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,

328: p_attribute6_o => per_job_shd.g_old_rec.attribute6,
329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,

Line 333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,

329: p_attribute7_o => per_job_shd.g_old_rec.attribute7,
330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,

Line 334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,

330: p_attribute8_o => per_job_shd.g_old_rec.attribute8,
331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,

Line 335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,

331: p_attribute9_o => per_job_shd.g_old_rec.attribute9,
332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,

Line 336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,

332: p_attribute10_o => per_job_shd.g_old_rec.attribute10,
333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,

Line 337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,

333: p_attribute11_o => per_job_shd.g_old_rec.attribute11,
334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,

Line 338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,

334: p_attribute12_o => per_job_shd.g_old_rec.attribute12,
335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,

Line 339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,

335: p_attribute13_o => per_job_shd.g_old_rec.attribute13,
336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,

Line 340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,

336: p_attribute14_o => per_job_shd.g_old_rec.attribute14,
337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,

Line 341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,

337: p_attribute15_o => per_job_shd.g_old_rec.attribute15,
338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,

Line 342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,

338: p_attribute16_o => per_job_shd.g_old_rec.attribute16,
339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,

Line 343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,

339: p_attribute17_o => per_job_shd.g_old_rec.attribute17,
340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,

Line 344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,

340: p_attribute18_o => per_job_shd.g_old_rec.attribute18,
341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,

Line 345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,

341: p_attribute19_o => per_job_shd.g_old_rec.attribute19,
342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,

Line 346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,

342: p_attribute20_o => per_job_shd.g_old_rec.attribute20,
343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,

Line 347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,

343: p_job_information_category_o=> per_job_shd.g_old_rec.job_information_category,
344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,

Line 348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,

344: p_job_information1_o => per_job_shd.g_old_rec.job_information1,
345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,

Line 349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,

345: p_job_information2_o => per_job_shd.g_old_rec.job_information2,
346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,

Line 350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,

346: p_job_information3_o => per_job_shd.g_old_rec.job_information3,
347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,

Line 351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,

347: p_job_information4_o => per_job_shd.g_old_rec.job_information4,
348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,

Line 352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,

348: p_job_information5_o => per_job_shd.g_old_rec.job_information5,
349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,

Line 353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,

349: p_job_information6_o => per_job_shd.g_old_rec.job_information6,
350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,

Line 354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,

350: p_job_information7_o => per_job_shd.g_old_rec.job_information7,
351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,

Line 355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,

351: p_job_information8_o => per_job_shd.g_old_rec.job_information8,
352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,

Line 356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,

352: p_job_information9_o => per_job_shd.g_old_rec.job_information9,
353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,

Line 357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,

353: p_job_information10_o => per_job_shd.g_old_rec.job_information10,
354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,

Line 358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,

354: p_job_information11_o => per_job_shd.g_old_rec.job_information11,
355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,

Line 359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,

355: p_job_information12_o => per_job_shd.g_old_rec.job_information12,
356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,

Line 360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,

356: p_job_information13_o => per_job_shd.g_old_rec.job_information13,
357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,

Line 361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,

357: p_job_information14_o => per_job_shd.g_old_rec.job_information14,
358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,

Line 362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,

358: p_job_information15_o => per_job_shd.g_old_rec.job_information15,
359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,

Line 363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,

359: p_job_information16_o => per_job_shd.g_old_rec.job_information16,
360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,
367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,

Line 364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,

360: p_job_information17_o => per_job_shd.g_old_rec.job_information17,
361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,
367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,
368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number

Line 365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,

361: p_job_information18_o => per_job_shd.g_old_rec.job_information18,
362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,
367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,
368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number
369: );

Line 366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,

362: p_job_information19_o => per_job_shd.g_old_rec.job_information19,
363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,
367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,
368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number
369: );
370: exception

Line 367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,

363: p_job_information20_o => per_job_shd.g_old_rec.job_information20,
364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,
367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,
368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then

Line 368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number

364: p_benchmark_job_flag_o => per_job_shd.g_old_rec.benchmark_job_flag,
365: p_benchmark_job_id_o => per_job_shd.g_old_rec.benchmark_job_id,
366: p_emp_rights_flag_o => per_job_shd.g_old_rec.emp_rights_flag,
367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,
368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error

Line 426: Procedure convert_defs(p_rec in out nocopy per_job_shd.g_rec_type) is

422: -- Internal Table Handler Use Only.
423: --
424: -- {End Of Comments}
425: -- ----------------------------------------------------------------------------
426: Procedure convert_defs(p_rec in out nocopy per_job_shd.g_rec_type) is
427: --
428: l_proc varchar2(72) := g_package||'convert_defs';
429: --
430: Begin

Line 441: per_job_shd.g_old_rec.business_group_id;

437: -- is being used then we must set to the 'current' argument value.
438: --
439: If (p_rec.business_group_id = hr_api.g_number) then
440: p_rec.business_group_id :=
441: per_job_shd.g_old_rec.business_group_id;
442: End If;
443: hr_utility.set_location('Entering:'||p_rec.job_definition_id, 6);
444: If (p_rec.job_definition_id = hr_api.g_number) then
445: p_rec.job_definition_id :=

Line 446: per_job_shd.g_old_rec.job_definition_id;

442: End If;
443: hr_utility.set_location('Entering:'||p_rec.job_definition_id, 6);
444: If (p_rec.job_definition_id = hr_api.g_number) then
445: p_rec.job_definition_id :=
446: per_job_shd.g_old_rec.job_definition_id;
447: End If;
448: hr_utility.set_location('Entering:'||l_proc, 7);
449: If (p_rec.date_from = hr_api.g_date) then
450: p_rec.date_from :=

Line 451: per_job_shd.g_old_rec.date_from;

447: End If;
448: hr_utility.set_location('Entering:'||l_proc, 7);
449: If (p_rec.date_from = hr_api.g_date) then
450: p_rec.date_from :=
451: per_job_shd.g_old_rec.date_from;
452: End If;
453: hr_utility.set_location('Entering:'||l_proc, 8);
454: If (p_rec.comments = hr_api.g_varchar2) then
455: p_rec.comments :=

Line 456: per_job_shd.g_old_rec.comments;

452: End If;
453: hr_utility.set_location('Entering:'||l_proc, 8);
454: If (p_rec.comments = hr_api.g_varchar2) then
455: p_rec.comments :=
456: per_job_shd.g_old_rec.comments;
457: End If;
458: hr_utility.set_location('Entering:'||l_proc, 9);
459: If (p_rec.date_to = hr_api.g_date) then
460: p_rec.date_to :=

Line 461: per_job_shd.g_old_rec.date_to;

457: End If;
458: hr_utility.set_location('Entering:'||l_proc, 9);
459: If (p_rec.date_to = hr_api.g_date) then
460: p_rec.date_to :=
461: per_job_shd.g_old_rec.date_to;
462: End If;
463: hr_utility.set_location('Entering:'||p_rec.approval_authority, 10);
464: If (p_rec.approval_authority = hr_api.g_number) then
465: p_rec.approval_authority :=

Line 466: per_job_shd.g_old_rec.approval_authority;

462: End If;
463: hr_utility.set_location('Entering:'||p_rec.approval_authority, 10);
464: If (p_rec.approval_authority = hr_api.g_number) then
465: p_rec.approval_authority :=
466: per_job_shd.g_old_rec.approval_authority;
467: End If;
468: hr_utility.set_location('Entering:'||l_proc, 11);
469: If (p_rec.name = hr_api.g_varchar2) then
470: p_rec.name :=

Line 471: per_job_shd.g_old_rec.name;

467: End If;
468: hr_utility.set_location('Entering:'||l_proc, 11);
469: If (p_rec.name = hr_api.g_varchar2) then
470: p_rec.name :=
471: per_job_shd.g_old_rec.name;
472: End If;
473: hr_utility.set_location('Entering:'||p_rec.request_id , 12);
474: If (p_rec.request_id = hr_api.g_number) then
475: p_rec.request_id :=

Line 476: per_job_shd.g_old_rec.request_id;

472: End If;
473: hr_utility.set_location('Entering:'||p_rec.request_id , 12);
474: If (p_rec.request_id = hr_api.g_number) then
475: p_rec.request_id :=
476: per_job_shd.g_old_rec.request_id;
477: End If;
478: hr_utility.set_location('Entering:'||l_proc, 14);
479: If (p_rec.program_application_id = hr_api.g_number) then
480: p_rec.program_application_id :=

Line 481: per_job_shd.g_old_rec.program_application_id;

477: End If;
478: hr_utility.set_location('Entering:'||l_proc, 14);
479: If (p_rec.program_application_id = hr_api.g_number) then
480: p_rec.program_application_id :=
481: per_job_shd.g_old_rec.program_application_id;
482: End If;
483: hr_utility.set_location('Entering:'||l_proc, 15);
484: If (p_rec.program_id = hr_api.g_number) then
485: p_rec.program_id :=

Line 486: per_job_shd.g_old_rec.program_id;

482: End If;
483: hr_utility.set_location('Entering:'||l_proc, 15);
484: If (p_rec.program_id = hr_api.g_number) then
485: p_rec.program_id :=
486: per_job_shd.g_old_rec.program_id;
487: End If;
488: hr_utility.set_location('Entering:'||l_proc, 16);
489: If (p_rec.program_update_date = hr_api.g_date) then
490: p_rec.program_update_date :=

Line 491: per_job_shd.g_old_rec.program_update_date;

487: End If;
488: hr_utility.set_location('Entering:'||l_proc, 16);
489: If (p_rec.program_update_date = hr_api.g_date) then
490: p_rec.program_update_date :=
491: per_job_shd.g_old_rec.program_update_date;
492: End If;
493: hr_utility.set_location('Entering:'||l_proc, 17);
494: If (p_rec.attribute_category = hr_api.g_varchar2) then
495: p_rec.attribute_category :=

Line 496: per_job_shd.g_old_rec.attribute_category;

492: End If;
493: hr_utility.set_location('Entering:'||l_proc, 17);
494: If (p_rec.attribute_category = hr_api.g_varchar2) then
495: p_rec.attribute_category :=
496: per_job_shd.g_old_rec.attribute_category;
497: End If;
498: hr_utility.set_location('Entering:'||l_proc, 18);
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=

Line 501: per_job_shd.g_old_rec.attribute1;

497: End If;
498: hr_utility.set_location('Entering:'||l_proc, 18);
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: per_job_shd.g_old_rec.attribute1;
502: End If;
503: hr_utility.set_location('Entering:'||l_proc, 19);
504: If (p_rec.attribute2 = hr_api.g_varchar2) then
505: p_rec.attribute2 :=

Line 506: per_job_shd.g_old_rec.attribute2;

502: End If;
503: hr_utility.set_location('Entering:'||l_proc, 19);
504: If (p_rec.attribute2 = hr_api.g_varchar2) then
505: p_rec.attribute2 :=
506: per_job_shd.g_old_rec.attribute2;
507: End If;
508: hr_utility.set_location('Entering:'||l_proc, 20);
509: If (p_rec.attribute3 = hr_api.g_varchar2) then
510: p_rec.attribute3 :=

Line 511: per_job_shd.g_old_rec.attribute3;

507: End If;
508: hr_utility.set_location('Entering:'||l_proc, 20);
509: If (p_rec.attribute3 = hr_api.g_varchar2) then
510: p_rec.attribute3 :=
511: per_job_shd.g_old_rec.attribute3;
512: End If;
513: hr_utility.set_location('Entering:'||l_proc, 21);
514: If (p_rec.attribute4 = hr_api.g_varchar2) then
515: p_rec.attribute4 :=

Line 516: per_job_shd.g_old_rec.attribute4;

512: End If;
513: hr_utility.set_location('Entering:'||l_proc, 21);
514: If (p_rec.attribute4 = hr_api.g_varchar2) then
515: p_rec.attribute4 :=
516: per_job_shd.g_old_rec.attribute4;
517: End If;
518: hr_utility.set_location('Entering:'||l_proc, 22);
519: If (p_rec.attribute5 = hr_api.g_varchar2) then
520: p_rec.attribute5 :=

Line 521: per_job_shd.g_old_rec.attribute5;

517: End If;
518: hr_utility.set_location('Entering:'||l_proc, 22);
519: If (p_rec.attribute5 = hr_api.g_varchar2) then
520: p_rec.attribute5 :=
521: per_job_shd.g_old_rec.attribute5;
522: End If;
523: hr_utility.set_location('Entering:'||l_proc, 23);
524: If (p_rec.attribute6 = hr_api.g_varchar2) then
525: p_rec.attribute6 :=

Line 526: per_job_shd.g_old_rec.attribute6;

522: End If;
523: hr_utility.set_location('Entering:'||l_proc, 23);
524: If (p_rec.attribute6 = hr_api.g_varchar2) then
525: p_rec.attribute6 :=
526: per_job_shd.g_old_rec.attribute6;
527: End If;
528: hr_utility.set_location('Entering:'||l_proc, 24);
529: If (p_rec.attribute7 = hr_api.g_varchar2) then
530: p_rec.attribute7 :=

Line 531: per_job_shd.g_old_rec.attribute7;

527: End If;
528: hr_utility.set_location('Entering:'||l_proc, 24);
529: If (p_rec.attribute7 = hr_api.g_varchar2) then
530: p_rec.attribute7 :=
531: per_job_shd.g_old_rec.attribute7;
532: End If;
533: hr_utility.set_location('Entering:'||l_proc, 25);
534: If (p_rec.attribute8 = hr_api.g_varchar2) then
535: p_rec.attribute8 :=

Line 536: per_job_shd.g_old_rec.attribute8;

532: End If;
533: hr_utility.set_location('Entering:'||l_proc, 25);
534: If (p_rec.attribute8 = hr_api.g_varchar2) then
535: p_rec.attribute8 :=
536: per_job_shd.g_old_rec.attribute8;
537: End If;
538: hr_utility.set_location('Entering:'||l_proc, 26);
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=

Line 541: per_job_shd.g_old_rec.attribute9;

537: End If;
538: hr_utility.set_location('Entering:'||l_proc, 26);
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_job_shd.g_old_rec.attribute9;
542: End If;
543: hr_utility.set_location('Entering:'||l_proc, 27);
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=

Line 546: per_job_shd.g_old_rec.attribute10;

542: End If;
543: hr_utility.set_location('Entering:'||l_proc, 27);
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: per_job_shd.g_old_rec.attribute10;
547: End If;
548: hr_utility.set_location('Entering:'||l_proc, 28);
549: If (p_rec.attribute11 = hr_api.g_varchar2) then
550: p_rec.attribute11 :=

Line 551: per_job_shd.g_old_rec.attribute11;

547: End If;
548: hr_utility.set_location('Entering:'||l_proc, 28);
549: If (p_rec.attribute11 = hr_api.g_varchar2) then
550: p_rec.attribute11 :=
551: per_job_shd.g_old_rec.attribute11;
552: End If;
553: hr_utility.set_location('Entering:'||l_proc, 29);
554: If (p_rec.attribute12 = hr_api.g_varchar2) then
555: p_rec.attribute12 :=

Line 556: per_job_shd.g_old_rec.attribute12;

552: End If;
553: hr_utility.set_location('Entering:'||l_proc, 29);
554: If (p_rec.attribute12 = hr_api.g_varchar2) then
555: p_rec.attribute12 :=
556: per_job_shd.g_old_rec.attribute12;
557: End If;
558: hr_utility.set_location('Entering:'||l_proc, 30);
559: If (p_rec.attribute13 = hr_api.g_varchar2) then
560: p_rec.attribute13 :=

Line 561: per_job_shd.g_old_rec.attribute13;

557: End If;
558: hr_utility.set_location('Entering:'||l_proc, 30);
559: If (p_rec.attribute13 = hr_api.g_varchar2) then
560: p_rec.attribute13 :=
561: per_job_shd.g_old_rec.attribute13;
562: End If;
563: hr_utility.set_location('Entering:'||l_proc, 31);
564: If (p_rec.attribute14 = hr_api.g_varchar2) then
565: p_rec.attribute14 :=

Line 566: per_job_shd.g_old_rec.attribute14;

562: End If;
563: hr_utility.set_location('Entering:'||l_proc, 31);
564: If (p_rec.attribute14 = hr_api.g_varchar2) then
565: p_rec.attribute14 :=
566: per_job_shd.g_old_rec.attribute14;
567: End If;
568: hr_utility.set_location('Entering:'||l_proc, 32);
569: If (p_rec.attribute15 = hr_api.g_varchar2) then
570: p_rec.attribute15 :=

Line 571: per_job_shd.g_old_rec.attribute15;

567: End If;
568: hr_utility.set_location('Entering:'||l_proc, 32);
569: If (p_rec.attribute15 = hr_api.g_varchar2) then
570: p_rec.attribute15 :=
571: per_job_shd.g_old_rec.attribute15;
572: End If;
573: hr_utility.set_location('Entering:'||l_proc, 33);
574: If (p_rec.attribute16 = hr_api.g_varchar2) then
575: p_rec.attribute16 :=

Line 576: per_job_shd.g_old_rec.attribute16;

572: End If;
573: hr_utility.set_location('Entering:'||l_proc, 33);
574: If (p_rec.attribute16 = hr_api.g_varchar2) then
575: p_rec.attribute16 :=
576: per_job_shd.g_old_rec.attribute16;
577: End If;
578: hr_utility.set_location('Entering:'||l_proc, 34);
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=

Line 581: per_job_shd.g_old_rec.attribute17;

577: End If;
578: hr_utility.set_location('Entering:'||l_proc, 34);
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_job_shd.g_old_rec.attribute17;
582: End If;
583: hr_utility.set_location('Entering:'||l_proc, 35);
584: If (p_rec.attribute18 = hr_api.g_varchar2) then
585: p_rec.attribute18 :=

Line 586: per_job_shd.g_old_rec.attribute18;

582: End If;
583: hr_utility.set_location('Entering:'||l_proc, 35);
584: If (p_rec.attribute18 = hr_api.g_varchar2) then
585: p_rec.attribute18 :=
586: per_job_shd.g_old_rec.attribute18;
587: End If;
588: hr_utility.set_location('Entering:'||l_proc, 36);
589: If (p_rec.attribute19 = hr_api.g_varchar2) then
590: p_rec.attribute19 :=

Line 591: per_job_shd.g_old_rec.attribute19;

587: End If;
588: hr_utility.set_location('Entering:'||l_proc, 36);
589: If (p_rec.attribute19 = hr_api.g_varchar2) then
590: p_rec.attribute19 :=
591: per_job_shd.g_old_rec.attribute19;
592: End If;
593: hr_utility.set_location('Entering:'||l_proc, 37);
594: If (p_rec.attribute20 = hr_api.g_varchar2) then
595: p_rec.attribute20 :=

Line 596: per_job_shd.g_old_rec.attribute20;

592: End If;
593: hr_utility.set_location('Entering:'||l_proc, 37);
594: If (p_rec.attribute20 = hr_api.g_varchar2) then
595: p_rec.attribute20 :=
596: per_job_shd.g_old_rec.attribute20;
597: End If;
598: hr_utility.set_location('Entering:'||l_proc, 38);
599: If (p_rec.job_information_category = hr_api.g_varchar2) then
600: p_rec.job_information_category :=

Line 601: per_job_shd.g_old_rec.job_information_category;

597: End If;
598: hr_utility.set_location('Entering:'||l_proc, 38);
599: If (p_rec.job_information_category = hr_api.g_varchar2) then
600: p_rec.job_information_category :=
601: per_job_shd.g_old_rec.job_information_category;
602: End If;
603: hr_utility.set_location('Entering:'||l_proc, 39);
604: If (p_rec.job_information1= hr_api.g_varchar2) then
605: p_rec.job_information1 :=

Line 606: per_job_shd.g_old_rec.job_information1;

602: End If;
603: hr_utility.set_location('Entering:'||l_proc, 39);
604: If (p_rec.job_information1= hr_api.g_varchar2) then
605: p_rec.job_information1 :=
606: per_job_shd.g_old_rec.job_information1;
607: End If;
608: hr_utility.set_location('Entering:'||l_proc, 40);
609: If (p_rec.job_information2= hr_api.g_varchar2) then
610: p_rec.job_information2 :=

Line 611: per_job_shd.g_old_rec.job_information2;

607: End If;
608: hr_utility.set_location('Entering:'||l_proc, 40);
609: If (p_rec.job_information2= hr_api.g_varchar2) then
610: p_rec.job_information2 :=
611: per_job_shd.g_old_rec.job_information2;
612: End If;
613: hr_utility.set_location('Entering:'||l_proc, 41);
614: If (p_rec.job_information3= hr_api.g_varchar2) then
615: p_rec.job_information3 :=

Line 616: per_job_shd.g_old_rec.job_information3;

612: End If;
613: hr_utility.set_location('Entering:'||l_proc, 41);
614: If (p_rec.job_information3= hr_api.g_varchar2) then
615: p_rec.job_information3 :=
616: per_job_shd.g_old_rec.job_information3;
617: End If;
618: hr_utility.set_location('Entering:'||l_proc, 42);
619: If (p_rec.job_information4= hr_api.g_varchar2) then
620: p_rec.job_information4 :=

Line 621: per_job_shd.g_old_rec.job_information4;

617: End If;
618: hr_utility.set_location('Entering:'||l_proc, 42);
619: If (p_rec.job_information4= hr_api.g_varchar2) then
620: p_rec.job_information4 :=
621: per_job_shd.g_old_rec.job_information4;
622: End If;
623: hr_utility.set_location('Entering:'||l_proc, 43);
624: If (p_rec.job_information5= hr_api.g_varchar2) then
625: p_rec.job_information5 :=

Line 626: per_job_shd.g_old_rec.job_information5;

622: End If;
623: hr_utility.set_location('Entering:'||l_proc, 43);
624: If (p_rec.job_information5= hr_api.g_varchar2) then
625: p_rec.job_information5 :=
626: per_job_shd.g_old_rec.job_information5;
627: End If;
628: hr_utility.set_location('Entering:'||l_proc, 44);
629: If (p_rec.job_information6= hr_api.g_varchar2) then
630: p_rec.job_information6 :=

Line 631: per_job_shd.g_old_rec.job_information6;

627: End If;
628: hr_utility.set_location('Entering:'||l_proc, 44);
629: If (p_rec.job_information6= hr_api.g_varchar2) then
630: p_rec.job_information6 :=
631: per_job_shd.g_old_rec.job_information6;
632: End If;
633: hr_utility.set_location('Entering:'||l_proc, 45);
634: If (p_rec.job_information7= hr_api.g_varchar2) then
635: p_rec.job_information7 :=

Line 636: per_job_shd.g_old_rec.job_information7;

632: End If;
633: hr_utility.set_location('Entering:'||l_proc, 45);
634: If (p_rec.job_information7= hr_api.g_varchar2) then
635: p_rec.job_information7 :=
636: per_job_shd.g_old_rec.job_information7;
637: End If;
638: hr_utility.set_location('Entering:'||l_proc, 46);
639: If (p_rec.job_information8= hr_api.g_varchar2) then
640: p_rec.job_information8 :=

Line 641: per_job_shd.g_old_rec.job_information8;

637: End If;
638: hr_utility.set_location('Entering:'||l_proc, 46);
639: If (p_rec.job_information8= hr_api.g_varchar2) then
640: p_rec.job_information8 :=
641: per_job_shd.g_old_rec.job_information8;
642: End If;
643: hr_utility.set_location('Entering:'||l_proc, 47);
644: If (p_rec.job_information9= hr_api.g_varchar2) then
645: p_rec.job_information9 :=

Line 646: per_job_shd.g_old_rec.job_information9;

642: End If;
643: hr_utility.set_location('Entering:'||l_proc, 47);
644: If (p_rec.job_information9= hr_api.g_varchar2) then
645: p_rec.job_information9 :=
646: per_job_shd.g_old_rec.job_information9;
647: End If;
648: hr_utility.set_location('Entering:'||l_proc, 48);
649: If (p_rec.job_information10= hr_api.g_varchar2) then
650: p_rec.job_information10 :=

Line 651: per_job_shd.g_old_rec.job_information10;

647: End If;
648: hr_utility.set_location('Entering:'||l_proc, 48);
649: If (p_rec.job_information10= hr_api.g_varchar2) then
650: p_rec.job_information10 :=
651: per_job_shd.g_old_rec.job_information10;
652: End If;
653: hr_utility.set_location('Entering:'||l_proc, 49);
654: If (p_rec.job_information11= hr_api.g_varchar2) then
655: p_rec.job_information11:=

Line 656: per_job_shd.g_old_rec.job_information11;

652: End If;
653: hr_utility.set_location('Entering:'||l_proc, 49);
654: If (p_rec.job_information11= hr_api.g_varchar2) then
655: p_rec.job_information11:=
656: per_job_shd.g_old_rec.job_information11;
657: End If;
658: hr_utility.set_location('Entering:'||l_proc, 50);
659: If (p_rec.job_information12= hr_api.g_varchar2) then
660: p_rec.job_information12 :=

Line 661: per_job_shd.g_old_rec.job_information12;

657: End If;
658: hr_utility.set_location('Entering:'||l_proc, 50);
659: If (p_rec.job_information12= hr_api.g_varchar2) then
660: p_rec.job_information12 :=
661: per_job_shd.g_old_rec.job_information12;
662: End If;
663: hr_utility.set_location('Entering:'||l_proc, 51);
664: If (p_rec.job_information13= hr_api.g_varchar2) then
665: p_rec.job_information13 :=

Line 666: per_job_shd.g_old_rec.job_information13;

662: End If;
663: hr_utility.set_location('Entering:'||l_proc, 51);
664: If (p_rec.job_information13= hr_api.g_varchar2) then
665: p_rec.job_information13 :=
666: per_job_shd.g_old_rec.job_information13;
667: End If;
668: hr_utility.set_location('Entering:'||l_proc, 52);
669: If (p_rec.job_information14= hr_api.g_varchar2) then
670: p_rec.job_information14 :=

Line 671: per_job_shd.g_old_rec.job_information14;

667: End If;
668: hr_utility.set_location('Entering:'||l_proc, 52);
669: If (p_rec.job_information14= hr_api.g_varchar2) then
670: p_rec.job_information14 :=
671: per_job_shd.g_old_rec.job_information14;
672: End If;
673: hr_utility.set_location('Entering:'||l_proc, 53);
674: If (p_rec.job_information15= hr_api.g_varchar2) then
675: p_rec.job_information15 :=

Line 676: per_job_shd.g_old_rec.job_information15;

672: End If;
673: hr_utility.set_location('Entering:'||l_proc, 53);
674: If (p_rec.job_information15= hr_api.g_varchar2) then
675: p_rec.job_information15 :=
676: per_job_shd.g_old_rec.job_information15;
677: End If;
678: hr_utility.set_location('Entering:'||l_proc, 54);
679: If (p_rec.job_information16= hr_api.g_varchar2) then
680: p_rec.job_information16 :=

Line 681: per_job_shd.g_old_rec.job_information16;

677: End If;
678: hr_utility.set_location('Entering:'||l_proc, 54);
679: If (p_rec.job_information16= hr_api.g_varchar2) then
680: p_rec.job_information16 :=
681: per_job_shd.g_old_rec.job_information16;
682: End If;
683: hr_utility.set_location('Entering:'||l_proc, 55);
684: If (p_rec.job_information17= hr_api.g_varchar2) then
685: p_rec.job_information17 :=

Line 686: per_job_shd.g_old_rec.job_information17;

682: End If;
683: hr_utility.set_location('Entering:'||l_proc, 55);
684: If (p_rec.job_information17= hr_api.g_varchar2) then
685: p_rec.job_information17 :=
686: per_job_shd.g_old_rec.job_information17;
687: End If;
688: hr_utility.set_location('Entering:'||l_proc, 56);
689: If (p_rec.job_information18= hr_api.g_varchar2) then
690: p_rec.job_information18 :=

Line 691: per_job_shd.g_old_rec.job_information18;

687: End If;
688: hr_utility.set_location('Entering:'||l_proc, 56);
689: If (p_rec.job_information18= hr_api.g_varchar2) then
690: p_rec.job_information18 :=
691: per_job_shd.g_old_rec.job_information18;
692: End If;
693: hr_utility.set_location('Entering:'||l_proc, 57);
694: If (p_rec.job_information19= hr_api.g_varchar2) then
695: p_rec.job_information19 :=

Line 696: per_job_shd.g_old_rec.job_information19;

692: End If;
693: hr_utility.set_location('Entering:'||l_proc, 57);
694: If (p_rec.job_information19= hr_api.g_varchar2) then
695: p_rec.job_information19 :=
696: per_job_shd.g_old_rec.job_information19;
697: End If;
698: hr_utility.set_location('Entering:'||l_proc, 58);
699: If (p_rec.job_information20= hr_api.g_varchar2) then
700: p_rec.job_information20 :=

Line 701: per_job_shd.g_old_rec.job_information20;

697: End If;
698: hr_utility.set_location('Entering:'||l_proc, 58);
699: If (p_rec.job_information20= hr_api.g_varchar2) then
700: p_rec.job_information20 :=
701: per_job_shd.g_old_rec.job_information20;
702: End If;
703: hr_utility.set_location('Entering:'||l_proc, 59);
704: If (p_rec.benchmark_job_flag = hr_api.g_varchar2) then
705: p_rec.benchmark_job_flag :=

Line 706: per_job_shd.g_old_rec.benchmark_job_flag;

702: End If;
703: hr_utility.set_location('Entering:'||l_proc, 59);
704: If (p_rec.benchmark_job_flag = hr_api.g_varchar2) then
705: p_rec.benchmark_job_flag :=
706: per_job_shd.g_old_rec.benchmark_job_flag;
707: End If;
708: hr_utility.set_location('Entering:'||p_rec.benchmark_job_id, 60);
709: If (p_rec.benchmark_job_id = hr_api.g_number) then
710: p_rec.benchmark_job_id :=

Line 711: per_job_shd.g_old_rec.benchmark_job_id;

707: End If;
708: hr_utility.set_location('Entering:'||p_rec.benchmark_job_id, 60);
709: If (p_rec.benchmark_job_id = hr_api.g_number) then
710: p_rec.benchmark_job_id :=
711: per_job_shd.g_old_rec.benchmark_job_id;
712: End If;
713: hr_utility.set_location('Entering:'||l_proc, 61);
714: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
715: p_rec.emp_rights_flag :=

Line 716: per_job_shd.g_old_rec.emp_rights_flag;

712: End If;
713: hr_utility.set_location('Entering:'||l_proc, 61);
714: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
715: p_rec.emp_rights_flag :=
716: per_job_shd.g_old_rec.emp_rights_flag;
717: End If;
718: hr_utility.set_location('Entering:'||l_proc, 62);
719: If (p_rec.job_group_id = hr_api.g_number) then
720: p_rec.job_group_id :=

Line 721: per_job_shd.g_old_rec.job_group_id;

717: End If;
718: hr_utility.set_location('Entering:'||l_proc, 62);
719: If (p_rec.job_group_id = hr_api.g_number) then
720: p_rec.job_group_id :=
721: per_job_shd.g_old_rec.job_group_id;
722: End IF;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 10);
725: --

Line 733: p_rec in out nocopy per_job_shd.g_rec_type,

729: -- |---------------------------------< upd >----------------------------------|
730: -- ----------------------------------------------------------------------------
731: Procedure upd
732: (
733: p_rec in out nocopy per_job_shd.g_rec_type,
734: p_validate in boolean default false
735: ) is
736: --
737: l_proc varchar2(72) := g_package||'upd';

Line 753: per_job_shd.lck

749: End If;
750: --
751: -- We must lock the row which we need to update.
752: --
753: per_job_shd.lck
754: (
755: p_job_id => p_rec.job_id,
756: p_object_version_number => p_rec.object_version_number
757: );

Line 867: l_rec per_job_shd.g_rec_type;

863: p_object_version_number in out nocopy number,
864: p_validate in boolean default false
865: ) is
866: --
867: l_rec per_job_shd.g_rec_type;
868: l_proc varchar2(72) := g_package||'upd';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);

Line 877: per_job_shd.convert_args

873: -- Call conversion function to turn arguments into the
874: -- l_rec structure.
875: --
876: l_rec :=
877: per_job_shd.convert_args
878: (
879: p_job_id,
880: hr_api.g_number, -- p_business_group_id
881: p_job_definition_id,