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

Line 51: Procedure delete_dml(p_rec in per_vgr_shd.g_rec_type) is

47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_vgr_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_vgr_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_vgr_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_valid_grades row.
61: --
62: delete from per_valid_grades

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

61: --
62: delete from per_valid_grades
63: where valid_grade_id = p_rec.valid_grade_id;
64: --
65: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
73: per_vgr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_vgr_shd.g_api_dml := false; -- Unset the api dml status

Line 73: per_vgr_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
73: per_vgr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
73: per_vgr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in per_vgr_shd.g_rec_type) is

108: -- Internal Table Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_vgr_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in per_vgr_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in per_vgr_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

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

162: begin
163: per_vgr_rkd.after_delete
164: (
165: p_valid_grade_id =>p_rec.valid_grade_id
166: ,p_business_group_id_o =>per_vgr_shd.g_old_rec.business_group_id
167: ,p_grade_id_o =>per_vgr_shd.g_old_rec.grade_id
168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to

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

163: per_vgr_rkd.after_delete
164: (
165: p_valid_grade_id =>p_rec.valid_grade_id
166: ,p_business_group_id_o =>per_vgr_shd.g_old_rec.business_group_id
167: ,p_grade_id_o =>per_vgr_shd.g_old_rec.grade_id
168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id

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

164: (
165: p_valid_grade_id =>p_rec.valid_grade_id
166: ,p_business_group_id_o =>per_vgr_shd.g_old_rec.business_group_id
167: ,p_grade_id_o =>per_vgr_shd.g_old_rec.grade_id
168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id

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

165: p_valid_grade_id =>p_rec.valid_grade_id
166: ,p_business_group_id_o =>per_vgr_shd.g_old_rec.business_group_id
167: ,p_grade_id_o =>per_vgr_shd.g_old_rec.grade_id
168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id

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

166: ,p_business_group_id_o =>per_vgr_shd.g_old_rec.business_group_id
167: ,p_grade_id_o =>per_vgr_shd.g_old_rec.grade_id
168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id

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

167: ,p_grade_id_o =>per_vgr_shd.g_old_rec.grade_id
168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id

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

168: ,p_date_from_o =>per_vgr_shd.g_old_rec.date_from
169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date

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

169: ,p_comments_o =>per_vgr_shd.g_old_rec.comments
170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category

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

170: ,p_date_to_o =>per_vgr_shd.g_old_rec.date_to
171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1

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

171: ,p_job_id_o =>per_vgr_shd.g_old_rec.job_id
172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2

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

172: ,p_position_id_o =>per_vgr_shd.g_old_rec.position_id
173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3

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

173: ,p_request_id_o =>per_vgr_shd.g_old_rec.request_id
174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4

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

174: ,p_program_application_id_o =>per_vgr_shd.g_old_rec.program_application_id
175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5

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

175: ,p_program_id_o =>per_vgr_shd.g_old_rec.program_id
176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6

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

176: ,p_program_update_date_o =>per_vgr_shd.g_old_rec.program_update_date
177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7

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

177: ,p_attribute_category_o =>per_vgr_shd.g_old_rec.attribute_category
178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8

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

178: ,p_attribute1_o =>per_vgr_shd.g_old_rec.attribute1
179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9

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

179: ,p_attribute2_o =>per_vgr_shd.g_old_rec.attribute2
180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10

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

180: ,p_attribute3_o =>per_vgr_shd.g_old_rec.attribute3
181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11

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

181: ,p_attribute4_o =>per_vgr_shd.g_old_rec.attribute4
182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12

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

182: ,p_attribute5_o =>per_vgr_shd.g_old_rec.attribute5
183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13

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

183: ,p_attribute6_o =>per_vgr_shd.g_old_rec.attribute6
184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14

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

184: ,p_attribute7_o =>per_vgr_shd.g_old_rec.attribute7
185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15

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

185: ,p_attribute8_o =>per_vgr_shd.g_old_rec.attribute8
186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16

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

186: ,p_attribute9_o =>per_vgr_shd.g_old_rec.attribute9
187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17

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

187: ,p_attribute10_o =>per_vgr_shd.g_old_rec.attribute10
188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18

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

188: ,p_attribute11_o =>per_vgr_shd.g_old_rec.attribute11
189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19

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

189: ,p_attribute12_o =>per_vgr_shd.g_old_rec.attribute12
190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19
197: ,p_attribute20_o =>per_vgr_shd.g_old_rec.attribute20

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

190: ,p_attribute13_o =>per_vgr_shd.g_old_rec.attribute13
191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19
197: ,p_attribute20_o =>per_vgr_shd.g_old_rec.attribute20
198: ,p_object_version_number_o =>per_vgr_shd.g_old_rec.object_version_number

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

191: ,p_attribute14_o =>per_vgr_shd.g_old_rec.attribute14
192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19
197: ,p_attribute20_o =>per_vgr_shd.g_old_rec.attribute20
198: ,p_object_version_number_o =>per_vgr_shd.g_old_rec.object_version_number
199: );

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

192: ,p_attribute15_o =>per_vgr_shd.g_old_rec.attribute15
193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19
197: ,p_attribute20_o =>per_vgr_shd.g_old_rec.attribute20
198: ,p_object_version_number_o =>per_vgr_shd.g_old_rec.object_version_number
199: );
200: exception

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

193: ,p_attribute16_o =>per_vgr_shd.g_old_rec.attribute16
194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19
197: ,p_attribute20_o =>per_vgr_shd.g_old_rec.attribute20
198: ,p_object_version_number_o =>per_vgr_shd.g_old_rec.object_version_number
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then

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

194: ,p_attribute17_o =>per_vgr_shd.g_old_rec.attribute17
195: ,p_attribute18_o =>per_vgr_shd.g_old_rec.attribute18
196: ,p_attribute19_o =>per_vgr_shd.g_old_rec.attribute19
197: ,p_attribute20_o =>per_vgr_shd.g_old_rec.attribute20
198: ,p_object_version_number_o =>per_vgr_shd.g_old_rec.object_version_number
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error

Line 216: p_rec in per_vgr_shd.g_rec_type,

212: -- |---------------------------------< del >----------------------------------|
213: -- ----------------------------------------------------------------------------
214: Procedure del
215: (
216: p_rec in per_vgr_shd.g_rec_type,
217: p_validate in boolean default false
218: ) is
219: --
220: l_proc varchar2(72) := g_package||'del';

Line 236: per_vgr_shd.lck

232: End If;
233: --
234: -- We must lock the row which we need to delete.
235: --
236: per_vgr_shd.lck
237: (
238: p_rec.valid_grade_id,
239: p_rec.object_version_number
240: );

Line 284: l_rec per_vgr_shd.g_rec_type;

280: p_object_version_number in number,
281: p_validate in boolean default false
282: ) is
283: --
284: l_rec per_vgr_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'del';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);