eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_JBR_UPD dependencies on PER_JBR_SHD

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

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

Line 106: per_jbr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 113: per_jbr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 114: per_jbr_shd.constraint_error

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

Line 118: per_jbr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 119: per_jbr_shd.constraint_error

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

Line 123: per_jbr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 124: per_jbr_shd.constraint_error

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

Line 127: per_jbr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 163: Procedure pre_update(p_rec in per_jbr_shd.g_rec_type) is

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

Line 205: Procedure post_update(p_rec in per_jbr_shd.g_rec_type) is

201: -- Internal Table Handler Use Only.
202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure post_update(p_rec in per_jbr_shd.g_rec_type) is
206: --
207: l_proc varchar2(72) := g_package||'post_update';
208: --
209: Begin

Line 251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,

247: p_attribute18 => p_rec.attribute18,
248: p_attribute19 => p_rec.attribute19,
249: p_attribute20 => p_rec.attribute20,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,

Line 252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,

248: p_attribute19 => p_rec.attribute19,
249: p_attribute20 => p_rec.attribute20,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,

Line 253: p_comments_o => per_jbr_shd.g_old_rec.comments,

249: p_attribute20 => p_rec.attribute20,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,

Line 254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,

250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,

Line 255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,

251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,

Line 256: p_essential_o => per_jbr_shd.g_old_rec.essential,

252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,

Line 257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,

253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,

Line 258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,

254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,

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

255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,

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

256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,

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

257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
285: );
286: exception
287: when hr_api.cannot_find_prog_unit then

Line 284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number

280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
285: );
286: exception
287: when hr_api.cannot_find_prog_unit then
288: hr_api.cannot_find_prog_unit_error

Line 342: Procedure convert_defs(p_rec in out nocopy per_jbr_shd.g_rec_type) is

338: -- Internal Table Handler Use Only.
339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure convert_defs(p_rec in out nocopy per_jbr_shd.g_rec_type) is
343: --
344: l_proc varchar2(72) := g_package||'convert_defs';
345: --
346: Begin

Line 357: per_jbr_shd.g_old_rec.business_group_id;

353: -- is being used then we must set to the 'current' argument value.
354: --
355: If (p_rec.business_group_id = hr_api.g_number) then
356: p_rec.business_group_id :=
357: per_jbr_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.analysis_criteria_id = hr_api.g_number) then
360: p_rec.analysis_criteria_id :=
361: per_jbr_shd.g_old_rec.analysis_criteria_id;

Line 361: per_jbr_shd.g_old_rec.analysis_criteria_id;

357: per_jbr_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.analysis_criteria_id = hr_api.g_number) then
360: p_rec.analysis_criteria_id :=
361: per_jbr_shd.g_old_rec.analysis_criteria_id;
362: End If;
363: If (p_rec.comments = hr_api.g_varchar2) then
364: p_rec.comments :=
365: per_jbr_shd.g_old_rec.comments;

Line 365: per_jbr_shd.g_old_rec.comments;

361: per_jbr_shd.g_old_rec.analysis_criteria_id;
362: End If;
363: If (p_rec.comments = hr_api.g_varchar2) then
364: p_rec.comments :=
365: per_jbr_shd.g_old_rec.comments;
366: End If;
367: If (p_rec.date_from = hr_api.g_date) then
368: p_rec.date_from :=
369: per_jbr_shd.g_old_rec.date_from;

Line 369: per_jbr_shd.g_old_rec.date_from;

365: per_jbr_shd.g_old_rec.comments;
366: End If;
367: If (p_rec.date_from = hr_api.g_date) then
368: p_rec.date_from :=
369: per_jbr_shd.g_old_rec.date_from;
370: End If;
371: If (p_rec.date_to = hr_api.g_date) then
372: p_rec.date_to :=
373: per_jbr_shd.g_old_rec.date_to;

Line 373: per_jbr_shd.g_old_rec.date_to;

369: per_jbr_shd.g_old_rec.date_from;
370: End If;
371: If (p_rec.date_to = hr_api.g_date) then
372: p_rec.date_to :=
373: per_jbr_shd.g_old_rec.date_to;
374: End If;
375: If (p_rec.essential = hr_api.g_varchar2) then
376: p_rec.essential :=
377: per_jbr_shd.g_old_rec.essential;

Line 377: per_jbr_shd.g_old_rec.essential;

373: per_jbr_shd.g_old_rec.date_to;
374: End If;
375: If (p_rec.essential = hr_api.g_varchar2) then
376: p_rec.essential :=
377: per_jbr_shd.g_old_rec.essential;
378: End If;
379: If (p_rec.job_id = hr_api.g_number) then
380: p_rec.job_id :=
381: per_jbr_shd.g_old_rec.job_id;

Line 381: per_jbr_shd.g_old_rec.job_id;

377: per_jbr_shd.g_old_rec.essential;
378: End If;
379: If (p_rec.job_id = hr_api.g_number) then
380: p_rec.job_id :=
381: per_jbr_shd.g_old_rec.job_id;
382: End If;
383: If (p_rec.position_id = hr_api.g_number) then
384: p_rec.position_id :=
385: per_jbr_shd.g_old_rec.position_id;

Line 385: per_jbr_shd.g_old_rec.position_id;

381: per_jbr_shd.g_old_rec.job_id;
382: End If;
383: If (p_rec.position_id = hr_api.g_number) then
384: p_rec.position_id :=
385: per_jbr_shd.g_old_rec.position_id;
386: End If;
387: If (p_rec.request_id = hr_api.g_number) then
388: p_rec.request_id :=
389: per_jbr_shd.g_old_rec.request_id;

Line 389: per_jbr_shd.g_old_rec.request_id;

385: per_jbr_shd.g_old_rec.position_id;
386: End If;
387: If (p_rec.request_id = hr_api.g_number) then
388: p_rec.request_id :=
389: per_jbr_shd.g_old_rec.request_id;
390: End If;
391: If (p_rec.program_application_id = hr_api.g_number) then
392: p_rec.program_application_id :=
393: per_jbr_shd.g_old_rec.program_application_id;

Line 393: per_jbr_shd.g_old_rec.program_application_id;

389: per_jbr_shd.g_old_rec.request_id;
390: End If;
391: If (p_rec.program_application_id = hr_api.g_number) then
392: p_rec.program_application_id :=
393: per_jbr_shd.g_old_rec.program_application_id;
394: End If;
395: If (p_rec.program_id = hr_api.g_number) then
396: p_rec.program_id :=
397: per_jbr_shd.g_old_rec.program_id;

Line 397: per_jbr_shd.g_old_rec.program_id;

393: per_jbr_shd.g_old_rec.program_application_id;
394: End If;
395: If (p_rec.program_id = hr_api.g_number) then
396: p_rec.program_id :=
397: per_jbr_shd.g_old_rec.program_id;
398: End If;
399: If (p_rec.program_update_date = hr_api.g_date) then
400: p_rec.program_update_date :=
401: per_jbr_shd.g_old_rec.program_update_date;

Line 401: per_jbr_shd.g_old_rec.program_update_date;

397: per_jbr_shd.g_old_rec.program_id;
398: End If;
399: If (p_rec.program_update_date = hr_api.g_date) then
400: p_rec.program_update_date :=
401: per_jbr_shd.g_old_rec.program_update_date;
402: End If;
403: If (p_rec.attribute_category = hr_api.g_varchar2) then
404: p_rec.attribute_category :=
405: per_jbr_shd.g_old_rec.attribute_category;

Line 405: per_jbr_shd.g_old_rec.attribute_category;

401: per_jbr_shd.g_old_rec.program_update_date;
402: End If;
403: If (p_rec.attribute_category = hr_api.g_varchar2) then
404: p_rec.attribute_category :=
405: per_jbr_shd.g_old_rec.attribute_category;
406: End If;
407: If (p_rec.attribute1 = hr_api.g_varchar2) then
408: p_rec.attribute1 :=
409: per_jbr_shd.g_old_rec.attribute1;

Line 409: per_jbr_shd.g_old_rec.attribute1;

405: per_jbr_shd.g_old_rec.attribute_category;
406: End If;
407: If (p_rec.attribute1 = hr_api.g_varchar2) then
408: p_rec.attribute1 :=
409: per_jbr_shd.g_old_rec.attribute1;
410: End If;
411: If (p_rec.attribute2 = hr_api.g_varchar2) then
412: p_rec.attribute2 :=
413: per_jbr_shd.g_old_rec.attribute2;

Line 413: per_jbr_shd.g_old_rec.attribute2;

409: per_jbr_shd.g_old_rec.attribute1;
410: End If;
411: If (p_rec.attribute2 = hr_api.g_varchar2) then
412: p_rec.attribute2 :=
413: per_jbr_shd.g_old_rec.attribute2;
414: End If;
415: If (p_rec.attribute3 = hr_api.g_varchar2) then
416: p_rec.attribute3 :=
417: per_jbr_shd.g_old_rec.attribute3;

Line 417: per_jbr_shd.g_old_rec.attribute3;

413: per_jbr_shd.g_old_rec.attribute2;
414: End If;
415: If (p_rec.attribute3 = hr_api.g_varchar2) then
416: p_rec.attribute3 :=
417: per_jbr_shd.g_old_rec.attribute3;
418: End If;
419: If (p_rec.attribute4 = hr_api.g_varchar2) then
420: p_rec.attribute4 :=
421: per_jbr_shd.g_old_rec.attribute4;

Line 421: per_jbr_shd.g_old_rec.attribute4;

417: per_jbr_shd.g_old_rec.attribute3;
418: End If;
419: If (p_rec.attribute4 = hr_api.g_varchar2) then
420: p_rec.attribute4 :=
421: per_jbr_shd.g_old_rec.attribute4;
422: End If;
423: If (p_rec.attribute5 = hr_api.g_varchar2) then
424: p_rec.attribute5 :=
425: per_jbr_shd.g_old_rec.attribute5;

Line 425: per_jbr_shd.g_old_rec.attribute5;

421: per_jbr_shd.g_old_rec.attribute4;
422: End If;
423: If (p_rec.attribute5 = hr_api.g_varchar2) then
424: p_rec.attribute5 :=
425: per_jbr_shd.g_old_rec.attribute5;
426: End If;
427: If (p_rec.attribute6 = hr_api.g_varchar2) then
428: p_rec.attribute6 :=
429: per_jbr_shd.g_old_rec.attribute6;

Line 429: per_jbr_shd.g_old_rec.attribute6;

425: per_jbr_shd.g_old_rec.attribute5;
426: End If;
427: If (p_rec.attribute6 = hr_api.g_varchar2) then
428: p_rec.attribute6 :=
429: per_jbr_shd.g_old_rec.attribute6;
430: End If;
431: If (p_rec.attribute7 = hr_api.g_varchar2) then
432: p_rec.attribute7 :=
433: per_jbr_shd.g_old_rec.attribute7;

Line 433: per_jbr_shd.g_old_rec.attribute7;

429: per_jbr_shd.g_old_rec.attribute6;
430: End If;
431: If (p_rec.attribute7 = hr_api.g_varchar2) then
432: p_rec.attribute7 :=
433: per_jbr_shd.g_old_rec.attribute7;
434: End If;
435: If (p_rec.attribute8 = hr_api.g_varchar2) then
436: p_rec.attribute8 :=
437: per_jbr_shd.g_old_rec.attribute8;

Line 437: per_jbr_shd.g_old_rec.attribute8;

433: per_jbr_shd.g_old_rec.attribute7;
434: End If;
435: If (p_rec.attribute8 = hr_api.g_varchar2) then
436: p_rec.attribute8 :=
437: per_jbr_shd.g_old_rec.attribute8;
438: End If;
439: If (p_rec.attribute9 = hr_api.g_varchar2) then
440: p_rec.attribute9 :=
441: per_jbr_shd.g_old_rec.attribute9;

Line 441: per_jbr_shd.g_old_rec.attribute9;

437: per_jbr_shd.g_old_rec.attribute8;
438: End If;
439: If (p_rec.attribute9 = hr_api.g_varchar2) then
440: p_rec.attribute9 :=
441: per_jbr_shd.g_old_rec.attribute9;
442: End If;
443: If (p_rec.attribute10 = hr_api.g_varchar2) then
444: p_rec.attribute10 :=
445: per_jbr_shd.g_old_rec.attribute10;

Line 445: per_jbr_shd.g_old_rec.attribute10;

441: per_jbr_shd.g_old_rec.attribute9;
442: End If;
443: If (p_rec.attribute10 = hr_api.g_varchar2) then
444: p_rec.attribute10 :=
445: per_jbr_shd.g_old_rec.attribute10;
446: End If;
447: If (p_rec.attribute11 = hr_api.g_varchar2) then
448: p_rec.attribute11 :=
449: per_jbr_shd.g_old_rec.attribute11;

Line 449: per_jbr_shd.g_old_rec.attribute11;

445: per_jbr_shd.g_old_rec.attribute10;
446: End If;
447: If (p_rec.attribute11 = hr_api.g_varchar2) then
448: p_rec.attribute11 :=
449: per_jbr_shd.g_old_rec.attribute11;
450: End If;
451: If (p_rec.attribute12 = hr_api.g_varchar2) then
452: p_rec.attribute12 :=
453: per_jbr_shd.g_old_rec.attribute12;

Line 453: per_jbr_shd.g_old_rec.attribute12;

449: per_jbr_shd.g_old_rec.attribute11;
450: End If;
451: If (p_rec.attribute12 = hr_api.g_varchar2) then
452: p_rec.attribute12 :=
453: per_jbr_shd.g_old_rec.attribute12;
454: End If;
455: If (p_rec.attribute13 = hr_api.g_varchar2) then
456: p_rec.attribute13 :=
457: per_jbr_shd.g_old_rec.attribute13;

Line 457: per_jbr_shd.g_old_rec.attribute13;

453: per_jbr_shd.g_old_rec.attribute12;
454: End If;
455: If (p_rec.attribute13 = hr_api.g_varchar2) then
456: p_rec.attribute13 :=
457: per_jbr_shd.g_old_rec.attribute13;
458: End If;
459: If (p_rec.attribute14 = hr_api.g_varchar2) then
460: p_rec.attribute14 :=
461: per_jbr_shd.g_old_rec.attribute14;

Line 461: per_jbr_shd.g_old_rec.attribute14;

457: per_jbr_shd.g_old_rec.attribute13;
458: End If;
459: If (p_rec.attribute14 = hr_api.g_varchar2) then
460: p_rec.attribute14 :=
461: per_jbr_shd.g_old_rec.attribute14;
462: End If;
463: If (p_rec.attribute15 = hr_api.g_varchar2) then
464: p_rec.attribute15 :=
465: per_jbr_shd.g_old_rec.attribute15;

Line 465: per_jbr_shd.g_old_rec.attribute15;

461: per_jbr_shd.g_old_rec.attribute14;
462: End If;
463: If (p_rec.attribute15 = hr_api.g_varchar2) then
464: p_rec.attribute15 :=
465: per_jbr_shd.g_old_rec.attribute15;
466: End If;
467: If (p_rec.attribute16 = hr_api.g_varchar2) then
468: p_rec.attribute16 :=
469: per_jbr_shd.g_old_rec.attribute16;

Line 469: per_jbr_shd.g_old_rec.attribute16;

465: per_jbr_shd.g_old_rec.attribute15;
466: End If;
467: If (p_rec.attribute16 = hr_api.g_varchar2) then
468: p_rec.attribute16 :=
469: per_jbr_shd.g_old_rec.attribute16;
470: End If;
471: If (p_rec.attribute17 = hr_api.g_varchar2) then
472: p_rec.attribute17 :=
473: per_jbr_shd.g_old_rec.attribute17;

Line 473: per_jbr_shd.g_old_rec.attribute17;

469: per_jbr_shd.g_old_rec.attribute16;
470: End If;
471: If (p_rec.attribute17 = hr_api.g_varchar2) then
472: p_rec.attribute17 :=
473: per_jbr_shd.g_old_rec.attribute17;
474: End If;
475: If (p_rec.attribute18 = hr_api.g_varchar2) then
476: p_rec.attribute18 :=
477: per_jbr_shd.g_old_rec.attribute18;

Line 477: per_jbr_shd.g_old_rec.attribute18;

473: per_jbr_shd.g_old_rec.attribute17;
474: End If;
475: If (p_rec.attribute18 = hr_api.g_varchar2) then
476: p_rec.attribute18 :=
477: per_jbr_shd.g_old_rec.attribute18;
478: End If;
479: If (p_rec.attribute19 = hr_api.g_varchar2) then
480: p_rec.attribute19 :=
481: per_jbr_shd.g_old_rec.attribute19;

Line 481: per_jbr_shd.g_old_rec.attribute19;

477: per_jbr_shd.g_old_rec.attribute18;
478: End If;
479: If (p_rec.attribute19 = hr_api.g_varchar2) then
480: p_rec.attribute19 :=
481: per_jbr_shd.g_old_rec.attribute19;
482: End If;
483: If (p_rec.attribute20 = hr_api.g_varchar2) then
484: p_rec.attribute20 :=
485: per_jbr_shd.g_old_rec.attribute20;

Line 485: per_jbr_shd.g_old_rec.attribute20;

481: per_jbr_shd.g_old_rec.attribute19;
482: End If;
483: If (p_rec.attribute20 = hr_api.g_varchar2) then
484: p_rec.attribute20 :=
485: per_jbr_shd.g_old_rec.attribute20;
486: End If;
487:
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 498: p_rec in out nocopy per_jbr_shd.g_rec_type,

494: -- |---------------------------------< upd >----------------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure upd
497: (
498: p_rec in out nocopy per_jbr_shd.g_rec_type,
499: p_validate in boolean default false
500: ) is
501: --
502: l_proc varchar2(72) := g_package||'upd';

Line 518: per_jbr_shd.lck

514: End If;
515: --
516: -- We must lock the row which we need to update.
517: --
518: per_jbr_shd.lck
519: (
520: p_rec.job_requirement_id,
521: p_rec.object_version_number
522: );

Line 603: l_rec per_jbr_shd.g_rec_type;

599: p_object_version_number in out nocopy number,
600: p_validate in boolean default false
601: ) is
602: --
603: l_rec per_jbr_shd.g_rec_type;
604: l_proc varchar2(72) := g_package||'upd';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);

Line 613: per_jbr_shd.convert_args

609: -- Call conversion function to turn arguments into the
610: -- l_rec structure.
611: --
612: l_rec :=
613: per_jbr_shd.convert_args
614: (
615: p_job_requirement_id,
616: hr_api.g_number,
617: p_analysis_criteria_id,