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_RES_DEL dependencies on PER_RES_SHD

Line 86: (p_rec in per_res_shd.g_rec_type

82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in per_res_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --

Line 109: per_res_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: --
109: per_res_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;

Line 148: Procedure pre_delete(p_rec in per_res_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in per_res_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin

Line 190: Procedure post_delete(p_rec in per_res_shd.g_rec_type) is

186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in per_res_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin

Line 207: => per_res_shd.g_old_rec.assignment_id

203: per_res_rkd.after_delete
204: (p_cagr_entitlement_result_id
205: => p_rec.cagr_entitlement_result_id
206: ,p_assignment_id_o
207: => per_res_shd.g_old_rec.assignment_id
208: ,p_start_date_o
209: => per_res_shd.g_old_rec.start_date
210: ,p_end_date_o
211: => per_res_shd.g_old_rec.end_date

Line 209: => per_res_shd.g_old_rec.start_date

205: => p_rec.cagr_entitlement_result_id
206: ,p_assignment_id_o
207: => per_res_shd.g_old_rec.assignment_id
208: ,p_start_date_o
209: => per_res_shd.g_old_rec.start_date
210: ,p_end_date_o
211: => per_res_shd.g_old_rec.end_date
212: ,p_collective_agreement_id_o
213: => per_res_shd.g_old_rec.collective_agreement_id

Line 211: => per_res_shd.g_old_rec.end_date

207: => per_res_shd.g_old_rec.assignment_id
208: ,p_start_date_o
209: => per_res_shd.g_old_rec.start_date
210: ,p_end_date_o
211: => per_res_shd.g_old_rec.end_date
212: ,p_collective_agreement_id_o
213: => per_res_shd.g_old_rec.collective_agreement_id
214: ,p_cagr_entitlement_item_id_o
215: => per_res_shd.g_old_rec.cagr_entitlement_item_id

Line 213: => per_res_shd.g_old_rec.collective_agreement_id

209: => per_res_shd.g_old_rec.start_date
210: ,p_end_date_o
211: => per_res_shd.g_old_rec.end_date
212: ,p_collective_agreement_id_o
213: => per_res_shd.g_old_rec.collective_agreement_id
214: ,p_cagr_entitlement_item_id_o
215: => per_res_shd.g_old_rec.cagr_entitlement_item_id
216: ,p_element_type_id_o
217: => per_res_shd.g_old_rec.element_type_id

Line 215: => per_res_shd.g_old_rec.cagr_entitlement_item_id

211: => per_res_shd.g_old_rec.end_date
212: ,p_collective_agreement_id_o
213: => per_res_shd.g_old_rec.collective_agreement_id
214: ,p_cagr_entitlement_item_id_o
215: => per_res_shd.g_old_rec.cagr_entitlement_item_id
216: ,p_element_type_id_o
217: => per_res_shd.g_old_rec.element_type_id
218: ,p_input_value_id_o
219: => per_res_shd.g_old_rec.input_value_id

Line 217: => per_res_shd.g_old_rec.element_type_id

213: => per_res_shd.g_old_rec.collective_agreement_id
214: ,p_cagr_entitlement_item_id_o
215: => per_res_shd.g_old_rec.cagr_entitlement_item_id
216: ,p_element_type_id_o
217: => per_res_shd.g_old_rec.element_type_id
218: ,p_input_value_id_o
219: => per_res_shd.g_old_rec.input_value_id
220: ,p_cagr_api_id_o
221: => per_res_shd.g_old_rec.cagr_api_id

Line 219: => per_res_shd.g_old_rec.input_value_id

215: => per_res_shd.g_old_rec.cagr_entitlement_item_id
216: ,p_element_type_id_o
217: => per_res_shd.g_old_rec.element_type_id
218: ,p_input_value_id_o
219: => per_res_shd.g_old_rec.input_value_id
220: ,p_cagr_api_id_o
221: => per_res_shd.g_old_rec.cagr_api_id
222: ,p_cagr_api_param_id_o
223: => per_res_shd.g_old_rec.cagr_api_param_id

Line 221: => per_res_shd.g_old_rec.cagr_api_id

217: => per_res_shd.g_old_rec.element_type_id
218: ,p_input_value_id_o
219: => per_res_shd.g_old_rec.input_value_id
220: ,p_cagr_api_id_o
221: => per_res_shd.g_old_rec.cagr_api_id
222: ,p_cagr_api_param_id_o
223: => per_res_shd.g_old_rec.cagr_api_param_id
224: ,p_category_name_o
225: => per_res_shd.g_old_rec.category_name

Line 223: => per_res_shd.g_old_rec.cagr_api_param_id

219: => per_res_shd.g_old_rec.input_value_id
220: ,p_cagr_api_id_o
221: => per_res_shd.g_old_rec.cagr_api_id
222: ,p_cagr_api_param_id_o
223: => per_res_shd.g_old_rec.cagr_api_param_id
224: ,p_category_name_o
225: => per_res_shd.g_old_rec.category_name
226: ,p_cagr_entitlement_id_o
227: => per_res_shd.g_old_rec.cagr_entitlement_id

Line 225: => per_res_shd.g_old_rec.category_name

221: => per_res_shd.g_old_rec.cagr_api_id
222: ,p_cagr_api_param_id_o
223: => per_res_shd.g_old_rec.cagr_api_param_id
224: ,p_category_name_o
225: => per_res_shd.g_old_rec.category_name
226: ,p_cagr_entitlement_id_o
227: => per_res_shd.g_old_rec.cagr_entitlement_id
228: ,p_cagr_entitlement_line_id_o
229: => per_res_shd.g_old_rec.cagr_entitlement_line_id

Line 227: => per_res_shd.g_old_rec.cagr_entitlement_id

223: => per_res_shd.g_old_rec.cagr_api_param_id
224: ,p_category_name_o
225: => per_res_shd.g_old_rec.category_name
226: ,p_cagr_entitlement_id_o
227: => per_res_shd.g_old_rec.cagr_entitlement_id
228: ,p_cagr_entitlement_line_id_o
229: => per_res_shd.g_old_rec.cagr_entitlement_line_id
230: ,p_value_o
231: => per_res_shd.g_old_rec.value

Line 229: => per_res_shd.g_old_rec.cagr_entitlement_line_id

225: => per_res_shd.g_old_rec.category_name
226: ,p_cagr_entitlement_id_o
227: => per_res_shd.g_old_rec.cagr_entitlement_id
228: ,p_cagr_entitlement_line_id_o
229: => per_res_shd.g_old_rec.cagr_entitlement_line_id
230: ,p_value_o
231: => per_res_shd.g_old_rec.value
232: ,p_units_of_measure_o
233: => per_res_shd.g_old_rec.units_of_measure

Line 231: => per_res_shd.g_old_rec.value

227: => per_res_shd.g_old_rec.cagr_entitlement_id
228: ,p_cagr_entitlement_line_id_o
229: => per_res_shd.g_old_rec.cagr_entitlement_line_id
230: ,p_value_o
231: => per_res_shd.g_old_rec.value
232: ,p_units_of_measure_o
233: => per_res_shd.g_old_rec.units_of_measure
234: ,p_range_from_o
235: => per_res_shd.g_old_rec.range_from

Line 233: => per_res_shd.g_old_rec.units_of_measure

229: => per_res_shd.g_old_rec.cagr_entitlement_line_id
230: ,p_value_o
231: => per_res_shd.g_old_rec.value
232: ,p_units_of_measure_o
233: => per_res_shd.g_old_rec.units_of_measure
234: ,p_range_from_o
235: => per_res_shd.g_old_rec.range_from
236: ,p_range_to_o
237: => per_res_shd.g_old_rec.range_to

Line 235: => per_res_shd.g_old_rec.range_from

231: => per_res_shd.g_old_rec.value
232: ,p_units_of_measure_o
233: => per_res_shd.g_old_rec.units_of_measure
234: ,p_range_from_o
235: => per_res_shd.g_old_rec.range_from
236: ,p_range_to_o
237: => per_res_shd.g_old_rec.range_to
238: ,p_grade_spine_id_o
239: => per_res_shd.g_old_rec.grade_spine_id

Line 237: => per_res_shd.g_old_rec.range_to

233: => per_res_shd.g_old_rec.units_of_measure
234: ,p_range_from_o
235: => per_res_shd.g_old_rec.range_from
236: ,p_range_to_o
237: => per_res_shd.g_old_rec.range_to
238: ,p_grade_spine_id_o
239: => per_res_shd.g_old_rec.grade_spine_id
240: ,p_parent_spine_id_o
241: => per_res_shd.g_old_rec.parent_spine_id

Line 239: => per_res_shd.g_old_rec.grade_spine_id

235: => per_res_shd.g_old_rec.range_from
236: ,p_range_to_o
237: => per_res_shd.g_old_rec.range_to
238: ,p_grade_spine_id_o
239: => per_res_shd.g_old_rec.grade_spine_id
240: ,p_parent_spine_id_o
241: => per_res_shd.g_old_rec.parent_spine_id
242: ,p_step_id_o
243: => per_res_shd.g_old_rec.step_id

Line 241: => per_res_shd.g_old_rec.parent_spine_id

237: => per_res_shd.g_old_rec.range_to
238: ,p_grade_spine_id_o
239: => per_res_shd.g_old_rec.grade_spine_id
240: ,p_parent_spine_id_o
241: => per_res_shd.g_old_rec.parent_spine_id
242: ,p_step_id_o
243: => per_res_shd.g_old_rec.step_id
244: ,p_from_step_id_o
245: => per_res_shd.g_old_rec.from_step_id

Line 243: => per_res_shd.g_old_rec.step_id

239: => per_res_shd.g_old_rec.grade_spine_id
240: ,p_parent_spine_id_o
241: => per_res_shd.g_old_rec.parent_spine_id
242: ,p_step_id_o
243: => per_res_shd.g_old_rec.step_id
244: ,p_from_step_id_o
245: => per_res_shd.g_old_rec.from_step_id
246: ,p_to_step_id_o
247: => per_res_shd.g_old_rec.to_step_id

Line 245: => per_res_shd.g_old_rec.from_step_id

241: => per_res_shd.g_old_rec.parent_spine_id
242: ,p_step_id_o
243: => per_res_shd.g_old_rec.step_id
244: ,p_from_step_id_o
245: => per_res_shd.g_old_rec.from_step_id
246: ,p_to_step_id_o
247: => per_res_shd.g_old_rec.to_step_id
248: ,p_beneficial_flag_o
249: => per_res_shd.g_old_rec.beneficial_flag

Line 247: => per_res_shd.g_old_rec.to_step_id

243: => per_res_shd.g_old_rec.step_id
244: ,p_from_step_id_o
245: => per_res_shd.g_old_rec.from_step_id
246: ,p_to_step_id_o
247: => per_res_shd.g_old_rec.to_step_id
248: ,p_beneficial_flag_o
249: => per_res_shd.g_old_rec.beneficial_flag
250: ,p_oipl_id_o
251: => per_res_shd.g_old_rec.oipl_id

Line 249: => per_res_shd.g_old_rec.beneficial_flag

245: => per_res_shd.g_old_rec.from_step_id
246: ,p_to_step_id_o
247: => per_res_shd.g_old_rec.to_step_id
248: ,p_beneficial_flag_o
249: => per_res_shd.g_old_rec.beneficial_flag
250: ,p_oipl_id_o
251: => per_res_shd.g_old_rec.oipl_id
252: ,p_chosen_flag_o
253: => per_res_shd.g_old_rec.chosen_flag

Line 251: => per_res_shd.g_old_rec.oipl_id

247: => per_res_shd.g_old_rec.to_step_id
248: ,p_beneficial_flag_o
249: => per_res_shd.g_old_rec.beneficial_flag
250: ,p_oipl_id_o
251: => per_res_shd.g_old_rec.oipl_id
252: ,p_chosen_flag_o
253: => per_res_shd.g_old_rec.chosen_flag
254: ,p_column_type_o
255: => per_res_shd.g_old_rec.column_type

Line 253: => per_res_shd.g_old_rec.chosen_flag

249: => per_res_shd.g_old_rec.beneficial_flag
250: ,p_oipl_id_o
251: => per_res_shd.g_old_rec.oipl_id
252: ,p_chosen_flag_o
253: => per_res_shd.g_old_rec.chosen_flag
254: ,p_column_type_o
255: => per_res_shd.g_old_rec.column_type
256: ,p_column_size_o
257: => per_res_shd.g_old_rec.column_size

Line 255: => per_res_shd.g_old_rec.column_type

251: => per_res_shd.g_old_rec.oipl_id
252: ,p_chosen_flag_o
253: => per_res_shd.g_old_rec.chosen_flag
254: ,p_column_type_o
255: => per_res_shd.g_old_rec.column_type
256: ,p_column_size_o
257: => per_res_shd.g_old_rec.column_size
258: ,p_cagr_request_id_o
259: => per_res_shd.g_old_rec.cagr_request_id

Line 257: => per_res_shd.g_old_rec.column_size

253: => per_res_shd.g_old_rec.chosen_flag
254: ,p_column_type_o
255: => per_res_shd.g_old_rec.column_type
256: ,p_column_size_o
257: => per_res_shd.g_old_rec.column_size
258: ,p_cagr_request_id_o
259: => per_res_shd.g_old_rec.cagr_request_id
260: ,p_business_group_id_o
261: => per_res_shd.g_old_rec.business_group_id

Line 259: => per_res_shd.g_old_rec.cagr_request_id

255: => per_res_shd.g_old_rec.column_type
256: ,p_column_size_o
257: => per_res_shd.g_old_rec.column_size
258: ,p_cagr_request_id_o
259: => per_res_shd.g_old_rec.cagr_request_id
260: ,p_business_group_id_o
261: => per_res_shd.g_old_rec.business_group_id
262: ,p_legislation_code_o
263: => per_res_shd.g_old_rec.legislation_code

Line 261: => per_res_shd.g_old_rec.business_group_id

257: => per_res_shd.g_old_rec.column_size
258: ,p_cagr_request_id_o
259: => per_res_shd.g_old_rec.cagr_request_id
260: ,p_business_group_id_o
261: => per_res_shd.g_old_rec.business_group_id
262: ,p_legislation_code_o
263: => per_res_shd.g_old_rec.legislation_code
264: ,p_eligy_prfl_id_o
265: => per_res_shd.g_old_rec.eligy_prfl_id

Line 263: => per_res_shd.g_old_rec.legislation_code

259: => per_res_shd.g_old_rec.cagr_request_id
260: ,p_business_group_id_o
261: => per_res_shd.g_old_rec.business_group_id
262: ,p_legislation_code_o
263: => per_res_shd.g_old_rec.legislation_code
264: ,p_eligy_prfl_id_o
265: => per_res_shd.g_old_rec.eligy_prfl_id
266: ,p_formula_id_o
267: => per_res_shd.g_old_rec.formula_id

Line 265: => per_res_shd.g_old_rec.eligy_prfl_id

261: => per_res_shd.g_old_rec.business_group_id
262: ,p_legislation_code_o
263: => per_res_shd.g_old_rec.legislation_code
264: ,p_eligy_prfl_id_o
265: => per_res_shd.g_old_rec.eligy_prfl_id
266: ,p_formula_id_o
267: => per_res_shd.g_old_rec.formula_id
268: ,p_object_version_number_o
269: => per_res_shd.g_old_rec.object_version_number

Line 267: => per_res_shd.g_old_rec.formula_id

263: => per_res_shd.g_old_rec.legislation_code
264: ,p_eligy_prfl_id_o
265: => per_res_shd.g_old_rec.eligy_prfl_id
266: ,p_formula_id_o
267: => per_res_shd.g_old_rec.formula_id
268: ,p_object_version_number_o
269: => per_res_shd.g_old_rec.object_version_number
270: );
271: --

Line 269: => per_res_shd.g_old_rec.object_version_number

265: => per_res_shd.g_old_rec.eligy_prfl_id
266: ,p_formula_id_o
267: => per_res_shd.g_old_rec.formula_id
268: ,p_object_version_number_o
269: => per_res_shd.g_old_rec.object_version_number
270: );
271: --
272: null;
273: exception

Line 291: (p_rec in per_res_shd.g_rec_type

287: -- ----------------------------------------------------------------------------
288: -- |---------------------------------< del >----------------------------------|
289: -- ----------------------------------------------------------------------------
290: Procedure del
291: (p_rec in per_res_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72) := g_package||'del';
295: --

Line 301: per_res_shd.lck

297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- We must lock the row which we need to delete.
300: --
301: per_res_shd.lck
302: (p_rec.cagr_entitlement_result_id
303: ,p_rec.object_version_number
304: );
305: --

Line 332: l_rec per_res_shd.g_rec_type;

328: (p_cagr_entitlement_result_id in number
329: ,p_object_version_number in number
330: ) is
331: --
332: l_rec per_res_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'del';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);