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_VGR_UPD dependencies on PER_VGR_SHD

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

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

Line 102: per_vgr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 109: per_vgr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 110: per_vgr_shd.constraint_error

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

Line 114: per_vgr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 115: per_vgr_shd.constraint_error

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

Line 119: per_vgr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 120: per_vgr_shd.constraint_error

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

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

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

Line 159: Procedure pre_update(p_rec in per_vgr_shd.g_rec_type) is

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

Line 201: Procedure post_update(p_rec in per_vgr_shd.g_rec_type,

197: -- Internal Table Handler Use Only.
198: --
199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure post_update(p_rec in per_vgr_shd.g_rec_type,
202: p_effective_date in date) is -- Added for Bug# 1760707
203: --
204: l_proc varchar2(72) := g_package||'post_update';
205: --

Line 245: ,p_business_group_id_o => per_vgr_shd.g_old_rec.business_group_id

241: ,p_attribute19 => p_rec.attribute19
242: ,p_attribute20 => p_rec.attribute20
243: ,p_object_version_number => p_rec.object_version_number
244: ,p_grade_id => p_rec.grade_id
245: ,p_business_group_id_o => per_vgr_shd.g_old_rec.business_group_id
246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id
247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to

Line 246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id

242: ,p_attribute20 => p_rec.attribute20
243: ,p_object_version_number => p_rec.object_version_number
244: ,p_grade_id => p_rec.grade_id
245: ,p_business_group_id_o => per_vgr_shd.g_old_rec.business_group_id
246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id
247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id

Line 247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from

243: ,p_object_version_number => p_rec.object_version_number
244: ,p_grade_id => p_rec.grade_id
245: ,p_business_group_id_o => per_vgr_shd.g_old_rec.business_group_id
246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id
247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id

Line 248: ,p_comments_o => per_vgr_shd.g_old_rec.comments

244: ,p_grade_id => p_rec.grade_id
245: ,p_business_group_id_o => per_vgr_shd.g_old_rec.business_group_id
246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id
247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id

Line 249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to

245: ,p_business_group_id_o => per_vgr_shd.g_old_rec.business_group_id
246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id
247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date

Line 250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id

246: ,p_grade_id_o => per_vgr_shd.g_old_rec.grade_id
247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id

Line 251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id

247: ,p_date_from_o => per_vgr_shd.g_old_rec.date_from
248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id

Line 252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id

248: ,p_comments_o => per_vgr_shd.g_old_rec.comments
249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category

Line 253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date

249: ,p_date_to_o => per_vgr_shd.g_old_rec.date_to
250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1

Line 254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id

250: ,p_request_id_o => per_vgr_shd.g_old_rec.request_id
251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2

Line 255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id

251: ,p_program_application_id_o => per_vgr_shd.g_old_rec.program_application_id
252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3

Line 256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category

252: ,p_program_id_o => per_vgr_shd.g_old_rec.program_id
253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4

Line 257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1

253: ,p_program_update_date_o => per_vgr_shd.g_old_rec.program_update_date
254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5

Line 258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2

254: ,p_job_id_o => per_vgr_shd.g_old_rec.job_id
255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6

Line 259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3

255: ,p_position_id_o => per_vgr_shd.g_old_rec.position_id
256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7

Line 260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4

256: ,p_attribute_category_o => per_vgr_shd.g_old_rec.attribute_category
257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8

Line 261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5

257: ,p_attribute1_o => per_vgr_shd.g_old_rec.attribute1
258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9

Line 262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6

258: ,p_attribute2_o => per_vgr_shd.g_old_rec.attribute2
259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10

Line 263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7

259: ,p_attribute3_o => per_vgr_shd.g_old_rec.attribute3
260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11

Line 264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8

260: ,p_attribute4_o => per_vgr_shd.g_old_rec.attribute4
261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12

Line 265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9

261: ,p_attribute5_o => per_vgr_shd.g_old_rec.attribute5
262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13

Line 266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10

262: ,p_attribute6_o => per_vgr_shd.g_old_rec.attribute6
263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14

Line 267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11

263: ,p_attribute7_o => per_vgr_shd.g_old_rec.attribute7
264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15

Line 268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12

264: ,p_attribute8_o => per_vgr_shd.g_old_rec.attribute8
265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16

Line 269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13

265: ,p_attribute9_o => per_vgr_shd.g_old_rec.attribute9
266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17

Line 270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14

266: ,p_attribute10_o => per_vgr_shd.g_old_rec.attribute10
267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18

Line 271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15

267: ,p_attribute11_o => per_vgr_shd.g_old_rec.attribute11
268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19

Line 272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16

268: ,p_attribute12_o => per_vgr_shd.g_old_rec.attribute12
269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19
276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20

Line 273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17

269: ,p_attribute13_o => per_vgr_shd.g_old_rec.attribute13
270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19
276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20
277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number

Line 274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18

270: ,p_attribute14_o => per_vgr_shd.g_old_rec.attribute14
271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19
276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20
277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number
278: );

Line 275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19

271: ,p_attribute15_o => per_vgr_shd.g_old_rec.attribute15
272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19
276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20
277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number
278: );
279: --

Line 276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20

272: ,p_attribute16_o => per_vgr_shd.g_old_rec.attribute16
273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19
276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20
277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number
278: );
279: --
280: exception

Line 277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number

273: ,p_attribute17_o => per_vgr_shd.g_old_rec.attribute17
274: ,p_attribute18_o => per_vgr_shd.g_old_rec.attribute18
275: ,p_attribute19_o => per_vgr_shd.g_old_rec.attribute19
276: ,p_attribute20_o => per_vgr_shd.g_old_rec.attribute20
277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number
278: );
279: --
280: exception
281: when hr_api.cannot_find_prog_unit then

Line 336: Procedure convert_defs(p_rec in out nocopy per_vgr_shd.g_rec_type) is

332: -- Internal Table Handler Use Only.
333: --
334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure convert_defs(p_rec in out nocopy per_vgr_shd.g_rec_type) is
337: --
338: l_proc varchar2(72) := g_package||'convert_defs';
339: --
340: Begin

Line 351: per_vgr_shd.g_old_rec.business_group_id;

347: -- is being used then we must set to the 'current' argument value.
348: --
349: If (p_rec.business_group_id = hr_api.g_number) then
350: p_rec.business_group_id :=
351: per_vgr_shd.g_old_rec.business_group_id;
352: End If;
353: If (p_rec.grade_id = hr_api.g_number) then
354: p_rec.grade_id :=
355: per_vgr_shd.g_old_rec.grade_id;

Line 355: per_vgr_shd.g_old_rec.grade_id;

351: per_vgr_shd.g_old_rec.business_group_id;
352: End If;
353: If (p_rec.grade_id = hr_api.g_number) then
354: p_rec.grade_id :=
355: per_vgr_shd.g_old_rec.grade_id;
356: End If;
357: If (p_rec.date_from = hr_api.g_date) then
358: p_rec.date_from :=
359: per_vgr_shd.g_old_rec.date_from;

Line 359: per_vgr_shd.g_old_rec.date_from;

355: per_vgr_shd.g_old_rec.grade_id;
356: End If;
357: If (p_rec.date_from = hr_api.g_date) then
358: p_rec.date_from :=
359: per_vgr_shd.g_old_rec.date_from;
360: End If;
361: If (p_rec.comments = hr_api.g_varchar2) then
362: p_rec.comments :=
363: per_vgr_shd.g_old_rec.comments;

Line 363: per_vgr_shd.g_old_rec.comments;

359: per_vgr_shd.g_old_rec.date_from;
360: End If;
361: If (p_rec.comments = hr_api.g_varchar2) then
362: p_rec.comments :=
363: per_vgr_shd.g_old_rec.comments;
364: End If;
365: If (p_rec.date_to = hr_api.g_date) then
366: p_rec.date_to :=
367: per_vgr_shd.g_old_rec.date_to;

Line 367: per_vgr_shd.g_old_rec.date_to;

363: per_vgr_shd.g_old_rec.comments;
364: End If;
365: If (p_rec.date_to = hr_api.g_date) then
366: p_rec.date_to :=
367: per_vgr_shd.g_old_rec.date_to;
368: End If;
369: If (p_rec.job_id = hr_api.g_number) then
370: p_rec.job_id :=
371: per_vgr_shd.g_old_rec.job_id;

Line 371: per_vgr_shd.g_old_rec.job_id;

367: per_vgr_shd.g_old_rec.date_to;
368: End If;
369: If (p_rec.job_id = hr_api.g_number) then
370: p_rec.job_id :=
371: per_vgr_shd.g_old_rec.job_id;
372: End If;
373: If (p_rec.position_id = hr_api.g_number) then
374: p_rec.position_id :=
375: per_vgr_shd.g_old_rec.position_id;

Line 375: per_vgr_shd.g_old_rec.position_id;

371: per_vgr_shd.g_old_rec.job_id;
372: End If;
373: If (p_rec.position_id = hr_api.g_number) then
374: p_rec.position_id :=
375: per_vgr_shd.g_old_rec.position_id;
376: End If;
377: If (p_rec.request_id = hr_api.g_number) then
378: p_rec.request_id :=
379: per_vgr_shd.g_old_rec.request_id;

Line 379: per_vgr_shd.g_old_rec.request_id;

375: per_vgr_shd.g_old_rec.position_id;
376: End If;
377: If (p_rec.request_id = hr_api.g_number) then
378: p_rec.request_id :=
379: per_vgr_shd.g_old_rec.request_id;
380: End If;
381: If (p_rec.program_application_id = hr_api.g_number) then
382: p_rec.program_application_id :=
383: per_vgr_shd.g_old_rec.program_application_id;

Line 383: per_vgr_shd.g_old_rec.program_application_id;

379: per_vgr_shd.g_old_rec.request_id;
380: End If;
381: If (p_rec.program_application_id = hr_api.g_number) then
382: p_rec.program_application_id :=
383: per_vgr_shd.g_old_rec.program_application_id;
384: End If;
385: If (p_rec.program_id = hr_api.g_number) then
386: p_rec.program_id :=
387: per_vgr_shd.g_old_rec.program_id;

Line 387: per_vgr_shd.g_old_rec.program_id;

383: per_vgr_shd.g_old_rec.program_application_id;
384: End If;
385: If (p_rec.program_id = hr_api.g_number) then
386: p_rec.program_id :=
387: per_vgr_shd.g_old_rec.program_id;
388: End If;
389: If (p_rec.program_update_date = hr_api.g_date) then
390: p_rec.program_update_date :=
391: per_vgr_shd.g_old_rec.program_update_date;

Line 391: per_vgr_shd.g_old_rec.program_update_date;

387: per_vgr_shd.g_old_rec.program_id;
388: End If;
389: If (p_rec.program_update_date = hr_api.g_date) then
390: p_rec.program_update_date :=
391: per_vgr_shd.g_old_rec.program_update_date;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: per_vgr_shd.g_old_rec.attribute_category;

Line 395: per_vgr_shd.g_old_rec.attribute_category;

391: per_vgr_shd.g_old_rec.program_update_date;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: per_vgr_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: per_vgr_shd.g_old_rec.attribute1;

Line 399: per_vgr_shd.g_old_rec.attribute1;

395: per_vgr_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: per_vgr_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: per_vgr_shd.g_old_rec.attribute2;

Line 403: per_vgr_shd.g_old_rec.attribute2;

399: per_vgr_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: per_vgr_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: per_vgr_shd.g_old_rec.attribute3;

Line 407: per_vgr_shd.g_old_rec.attribute3;

403: per_vgr_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: per_vgr_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: per_vgr_shd.g_old_rec.attribute4;

Line 411: per_vgr_shd.g_old_rec.attribute4;

407: per_vgr_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: per_vgr_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: per_vgr_shd.g_old_rec.attribute5;

Line 415: per_vgr_shd.g_old_rec.attribute5;

411: per_vgr_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: per_vgr_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: per_vgr_shd.g_old_rec.attribute6;

Line 419: per_vgr_shd.g_old_rec.attribute6;

415: per_vgr_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: per_vgr_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: per_vgr_shd.g_old_rec.attribute7;

Line 423: per_vgr_shd.g_old_rec.attribute7;

419: per_vgr_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: per_vgr_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: per_vgr_shd.g_old_rec.attribute8;

Line 427: per_vgr_shd.g_old_rec.attribute8;

423: per_vgr_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: per_vgr_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: per_vgr_shd.g_old_rec.attribute9;

Line 431: per_vgr_shd.g_old_rec.attribute9;

427: per_vgr_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: per_vgr_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: per_vgr_shd.g_old_rec.attribute10;

Line 435: per_vgr_shd.g_old_rec.attribute10;

431: per_vgr_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: per_vgr_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: per_vgr_shd.g_old_rec.attribute11;

Line 439: per_vgr_shd.g_old_rec.attribute11;

435: per_vgr_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: per_vgr_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: per_vgr_shd.g_old_rec.attribute12;

Line 443: per_vgr_shd.g_old_rec.attribute12;

439: per_vgr_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: per_vgr_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: per_vgr_shd.g_old_rec.attribute13;

Line 447: per_vgr_shd.g_old_rec.attribute13;

443: per_vgr_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: per_vgr_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: per_vgr_shd.g_old_rec.attribute14;

Line 451: per_vgr_shd.g_old_rec.attribute14;

447: per_vgr_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: per_vgr_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: per_vgr_shd.g_old_rec.attribute15;

Line 455: per_vgr_shd.g_old_rec.attribute15;

451: per_vgr_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: per_vgr_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: per_vgr_shd.g_old_rec.attribute16;

Line 459: per_vgr_shd.g_old_rec.attribute16;

455: per_vgr_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: per_vgr_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: per_vgr_shd.g_old_rec.attribute17;

Line 463: per_vgr_shd.g_old_rec.attribute17;

459: per_vgr_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: per_vgr_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: per_vgr_shd.g_old_rec.attribute18;

Line 467: per_vgr_shd.g_old_rec.attribute18;

463: per_vgr_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: per_vgr_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: per_vgr_shd.g_old_rec.attribute19;

Line 471: per_vgr_shd.g_old_rec.attribute19;

467: per_vgr_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: per_vgr_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: per_vgr_shd.g_old_rec.attribute20;

Line 475: per_vgr_shd.g_old_rec.attribute20;

471: per_vgr_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: per_vgr_shd.g_old_rec.attribute20;
476: End If;
477:
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 488: p_rec in out nocopy per_vgr_shd.g_rec_type,

484: -- |---------------------------------< upd >----------------------------------|
485: -- ----------------------------------------------------------------------------
486: Procedure upd
487: (
488: p_rec in out nocopy per_vgr_shd.g_rec_type,
489: p_validate in boolean default false,
490: p_effective_date in date -- Added for Bug# 1760707
491: ) is
492: --

Line 509: per_vgr_shd.lck

505: End If;
506: --
507: -- We must lock the row which we need to update.
508: --
509: per_vgr_shd.lck
510: (
511: p_rec.valid_grade_id,
512: p_rec.object_version_number
513: );

Line 591: l_rec per_vgr_shd.g_rec_type;

587: p_object_version_number in out nocopy number,
588: p_validate in boolean default false
589: ) is
590: --
591: l_rec per_vgr_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'upd';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);

Line 601: per_vgr_shd.convert_args

597: -- Call conversion function to turn arguments into the
598: -- l_rec structure.
599: --
600: l_rec :=
601: per_vgr_shd.convert_args
602: (
603: p_valid_grade_id,
604: hr_api.g_number,
605: hr_api.g_number,