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

Line 51: Procedure delete_dml(p_rec in per_jbr_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_jbr_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_jbr_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_jbr_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_job_requirements row.
61: --
62: delete from per_job_requirements

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

61: --
62: delete from per_job_requirements
63: where job_requirement_id = p_rec.job_requirement_id;
64: --
65: per_jbr_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_jbr_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_jbr_shd.g_api_dml := false; -- Unset the api dml status
73: per_jbr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_jbr_shd.g_api_dml := false; -- Unset the api dml status

Line 73: per_jbr_shd.constraint_error

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

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

72: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
73: per_jbr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_jbr_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_jbr_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_jbr_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_jbr_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_jbr_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

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

163: begin
164: per_jbr_rkd.after_delete
165: (
166: p_job_requirement_id => p_rec.job_requirement_id,
167: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,

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

164: per_jbr_rkd.after_delete
165: (
166: p_job_requirement_id => p_rec.job_requirement_id,
167: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,

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

165: (
166: p_job_requirement_id => p_rec.job_requirement_id,
167: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,

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

166: p_job_requirement_id => p_rec.job_requirement_id,
167: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,

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

167: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
175: p_request_id_o => per_jbr_shd.g_old_rec.request_id,

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

168: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
175: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
176: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,

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

169: p_comments_o => per_jbr_shd.g_old_rec.comments,
170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
175: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
176: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
177: p_program_id_o => per_jbr_shd.g_old_rec.program_id,

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

170: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
175: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
176: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
177: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
178: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,

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

171: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
175: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
176: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
177: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
178: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
179: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,

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

172: p_essential_o => per_jbr_shd.g_old_rec.essential,
173: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
174: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
175: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
176: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
177: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
178: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
179: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
180: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 200: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number

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

Line 219: p_rec in per_jbr_shd.g_rec_type,

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

Line 239: per_jbr_shd.lck

235: End If;
236: --
237: -- We must lock the row which we need to delete.
238: --
239: per_jbr_shd.lck
240: (
241: p_rec.job_requirement_id,
242: p_rec.object_version_number
243: );

Line 287: l_rec per_jbr_shd.g_rec_type;

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