APPS.PER_RET_DEL dependencies on PER_RET_SHD

Line 53: (p_rec in per_ret_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in per_ret_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --

Line 76: per_ret_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: per_ret_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;

Line 115: Procedure pre_delete(p_rec in per_ret_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in per_ret_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 157: Procedure post_delete(p_rec in per_ret_shd.g_rec_type) is

153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in per_ret_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 170: => per_ret_shd.g_old_rec.assignment_id

166: per_ret_rkd.after_delete
167: (p_cagr_retained_right_id
168: => p_rec.cagr_retained_right_id
169: ,p_assignment_id_o
170: => per_ret_shd.g_old_rec.assignment_id
171: ,p_cagr_entitlement_item_id_o
172: => per_ret_shd.g_old_rec.cagr_entitlement_item_id
173: ,p_collective_agreement_id_o
174: => per_ret_shd.g_old_rec.collective_agreement_id

Line 172: => per_ret_shd.g_old_rec.cagr_entitlement_item_id

168: => p_rec.cagr_retained_right_id
169: ,p_assignment_id_o
170: => per_ret_shd.g_old_rec.assignment_id
171: ,p_cagr_entitlement_item_id_o
172: => per_ret_shd.g_old_rec.cagr_entitlement_item_id
173: ,p_collective_agreement_id_o
174: => per_ret_shd.g_old_rec.collective_agreement_id
175: ,p_cagr_entitlement_id_o
176: => per_ret_shd.g_old_rec.cagr_entitlement_id

Line 174: => per_ret_shd.g_old_rec.collective_agreement_id

170: => per_ret_shd.g_old_rec.assignment_id
171: ,p_cagr_entitlement_item_id_o
172: => per_ret_shd.g_old_rec.cagr_entitlement_item_id
173: ,p_collective_agreement_id_o
174: => per_ret_shd.g_old_rec.collective_agreement_id
175: ,p_cagr_entitlement_id_o
176: => per_ret_shd.g_old_rec.cagr_entitlement_id
177: ,p_category_name_o
178: => per_ret_shd.g_old_rec.category_name

Line 176: => per_ret_shd.g_old_rec.cagr_entitlement_id

172: => per_ret_shd.g_old_rec.cagr_entitlement_item_id
173: ,p_collective_agreement_id_o
174: => per_ret_shd.g_old_rec.collective_agreement_id
175: ,p_cagr_entitlement_id_o
176: => per_ret_shd.g_old_rec.cagr_entitlement_id
177: ,p_category_name_o
178: => per_ret_shd.g_old_rec.category_name
179: ,p_element_type_id_o
180: => per_ret_shd.g_old_rec.element_type_id

Line 178: => per_ret_shd.g_old_rec.category_name

174: => per_ret_shd.g_old_rec.collective_agreement_id
175: ,p_cagr_entitlement_id_o
176: => per_ret_shd.g_old_rec.cagr_entitlement_id
177: ,p_category_name_o
178: => per_ret_shd.g_old_rec.category_name
179: ,p_element_type_id_o
180: => per_ret_shd.g_old_rec.element_type_id
181: ,p_input_value_id_o
182: => per_ret_shd.g_old_rec.input_value_id

Line 180: => per_ret_shd.g_old_rec.element_type_id

176: => per_ret_shd.g_old_rec.cagr_entitlement_id
177: ,p_category_name_o
178: => per_ret_shd.g_old_rec.category_name
179: ,p_element_type_id_o
180: => per_ret_shd.g_old_rec.element_type_id
181: ,p_input_value_id_o
182: => per_ret_shd.g_old_rec.input_value_id
183: ,p_cagr_api_id_o
184: => per_ret_shd.g_old_rec.cagr_api_id

Line 182: => per_ret_shd.g_old_rec.input_value_id

178: => per_ret_shd.g_old_rec.category_name
179: ,p_element_type_id_o
180: => per_ret_shd.g_old_rec.element_type_id
181: ,p_input_value_id_o
182: => per_ret_shd.g_old_rec.input_value_id
183: ,p_cagr_api_id_o
184: => per_ret_shd.g_old_rec.cagr_api_id
185: ,p_cagr_api_param_id_o
186: => per_ret_shd.g_old_rec.cagr_api_param_id

Line 184: => per_ret_shd.g_old_rec.cagr_api_id

180: => per_ret_shd.g_old_rec.element_type_id
181: ,p_input_value_id_o
182: => per_ret_shd.g_old_rec.input_value_id
183: ,p_cagr_api_id_o
184: => per_ret_shd.g_old_rec.cagr_api_id
185: ,p_cagr_api_param_id_o
186: => per_ret_shd.g_old_rec.cagr_api_param_id
187: ,p_cagr_entitlement_line_id_o
188: => per_ret_shd.g_old_rec.cagr_entitlement_line_id

Line 186: => per_ret_shd.g_old_rec.cagr_api_param_id

182: => per_ret_shd.g_old_rec.input_value_id
183: ,p_cagr_api_id_o
184: => per_ret_shd.g_old_rec.cagr_api_id
185: ,p_cagr_api_param_id_o
186: => per_ret_shd.g_old_rec.cagr_api_param_id
187: ,p_cagr_entitlement_line_id_o
188: => per_ret_shd.g_old_rec.cagr_entitlement_line_id
189: ,p_freeze_flag_o
190: => per_ret_shd.g_old_rec.freeze_flag

Line 188: => per_ret_shd.g_old_rec.cagr_entitlement_line_id

184: => per_ret_shd.g_old_rec.cagr_api_id
185: ,p_cagr_api_param_id_o
186: => per_ret_shd.g_old_rec.cagr_api_param_id
187: ,p_cagr_entitlement_line_id_o
188: => per_ret_shd.g_old_rec.cagr_entitlement_line_id
189: ,p_freeze_flag_o
190: => per_ret_shd.g_old_rec.freeze_flag
191: ,p_value_o
192: => per_ret_shd.g_old_rec.value

Line 190: => per_ret_shd.g_old_rec.freeze_flag

186: => per_ret_shd.g_old_rec.cagr_api_param_id
187: ,p_cagr_entitlement_line_id_o
188: => per_ret_shd.g_old_rec.cagr_entitlement_line_id
189: ,p_freeze_flag_o
190: => per_ret_shd.g_old_rec.freeze_flag
191: ,p_value_o
192: => per_ret_shd.g_old_rec.value
193: ,p_units_of_measure_o
194: => per_ret_shd.g_old_rec.units_of_measure

Line 192: => per_ret_shd.g_old_rec.value

188: => per_ret_shd.g_old_rec.cagr_entitlement_line_id
189: ,p_freeze_flag_o
190: => per_ret_shd.g_old_rec.freeze_flag
191: ,p_value_o
192: => per_ret_shd.g_old_rec.value
193: ,p_units_of_measure_o
194: => per_ret_shd.g_old_rec.units_of_measure
195: ,p_start_date_o
196: => per_ret_shd.g_old_rec.start_date

Line 194: => per_ret_shd.g_old_rec.units_of_measure

190: => per_ret_shd.g_old_rec.freeze_flag
191: ,p_value_o
192: => per_ret_shd.g_old_rec.value
193: ,p_units_of_measure_o
194: => per_ret_shd.g_old_rec.units_of_measure
195: ,p_start_date_o
196: => per_ret_shd.g_old_rec.start_date
197: ,p_end_date_o
198: => per_ret_shd.g_old_rec.end_date

Line 196: => per_ret_shd.g_old_rec.start_date

192: => per_ret_shd.g_old_rec.value
193: ,p_units_of_measure_o
194: => per_ret_shd.g_old_rec.units_of_measure
195: ,p_start_date_o
196: => per_ret_shd.g_old_rec.start_date
197: ,p_end_date_o
198: => per_ret_shd.g_old_rec.end_date
199: ,p_parent_spine_id_o
200: => per_ret_shd.g_old_rec.parent_spine_id

Line 198: => per_ret_shd.g_old_rec.end_date

194: => per_ret_shd.g_old_rec.units_of_measure
195: ,p_start_date_o
196: => per_ret_shd.g_old_rec.start_date
197: ,p_end_date_o
198: => per_ret_shd.g_old_rec.end_date
199: ,p_parent_spine_id_o
200: => per_ret_shd.g_old_rec.parent_spine_id
201: ,p_formula_id_o
202: => per_ret_shd.g_old_rec.formula_id

Line 200: => per_ret_shd.g_old_rec.parent_spine_id

196: => per_ret_shd.g_old_rec.start_date
197: ,p_end_date_o
198: => per_ret_shd.g_old_rec.end_date
199: ,p_parent_spine_id_o
200: => per_ret_shd.g_old_rec.parent_spine_id
201: ,p_formula_id_o
202: => per_ret_shd.g_old_rec.formula_id
203: ,p_oipl_id_o
204: => per_ret_shd.g_old_rec.oipl_id

Line 202: => per_ret_shd.g_old_rec.formula_id

198: => per_ret_shd.g_old_rec.end_date
199: ,p_parent_spine_id_o
200: => per_ret_shd.g_old_rec.parent_spine_id
201: ,p_formula_id_o
202: => per_ret_shd.g_old_rec.formula_id
203: ,p_oipl_id_o
204: => per_ret_shd.g_old_rec.oipl_id
205: ,p_step_id_o
206: => per_ret_shd.g_old_rec.step_id

Line 204: => per_ret_shd.g_old_rec.oipl_id

200: => per_ret_shd.g_old_rec.parent_spine_id
201: ,p_formula_id_o
202: => per_ret_shd.g_old_rec.formula_id
203: ,p_oipl_id_o
204: => per_ret_shd.g_old_rec.oipl_id
205: ,p_step_id_o
206: => per_ret_shd.g_old_rec.step_id
207: ,p_grade_spine_id_o
208: => per_ret_shd.g_old_rec.grade_spine_id

Line 206: => per_ret_shd.g_old_rec.step_id

202: => per_ret_shd.g_old_rec.formula_id
203: ,p_oipl_id_o
204: => per_ret_shd.g_old_rec.oipl_id
205: ,p_step_id_o
206: => per_ret_shd.g_old_rec.step_id
207: ,p_grade_spine_id_o
208: => per_ret_shd.g_old_rec.grade_spine_id
209: ,p_column_type_o
210: => per_ret_shd.g_old_rec.column_type

Line 208: => per_ret_shd.g_old_rec.grade_spine_id

204: => per_ret_shd.g_old_rec.oipl_id
205: ,p_step_id_o
206: => per_ret_shd.g_old_rec.step_id
207: ,p_grade_spine_id_o
208: => per_ret_shd.g_old_rec.grade_spine_id
209: ,p_column_type_o
210: => per_ret_shd.g_old_rec.column_type
211: ,p_column_size_o
212: => per_ret_shd.g_old_rec.column_size

Line 210: => per_ret_shd.g_old_rec.column_type

206: => per_ret_shd.g_old_rec.step_id
207: ,p_grade_spine_id_o
208: => per_ret_shd.g_old_rec.grade_spine_id
209: ,p_column_type_o
210: => per_ret_shd.g_old_rec.column_type
211: ,p_column_size_o
212: => per_ret_shd.g_old_rec.column_size
213: ,p_eligy_prfl_id_o
214: => per_ret_shd.g_old_rec.eligy_prfl_id

Line 212: => per_ret_shd.g_old_rec.column_size

208: => per_ret_shd.g_old_rec.grade_spine_id
209: ,p_column_type_o
210: => per_ret_shd.g_old_rec.column_type
211: ,p_column_size_o
212: => per_ret_shd.g_old_rec.column_size
213: ,p_eligy_prfl_id_o
214: => per_ret_shd.g_old_rec.eligy_prfl_id
215: ,p_object_version_number_o
216: => per_ret_shd.g_old_rec.object_version_number

Line 214: => per_ret_shd.g_old_rec.eligy_prfl_id

210: => per_ret_shd.g_old_rec.column_type
211: ,p_column_size_o
212: => per_ret_shd.g_old_rec.column_size
213: ,p_eligy_prfl_id_o
214: => per_ret_shd.g_old_rec.eligy_prfl_id
215: ,p_object_version_number_o
216: => per_ret_shd.g_old_rec.object_version_number
217: ,p_cagr_entitlement_result_id_o
218: => per_ret_shd.g_old_rec.cagr_entitlement_result_id

Line 216: => per_ret_shd.g_old_rec.object_version_number

212: => per_ret_shd.g_old_rec.column_size
213: ,p_eligy_prfl_id_o
214: => per_ret_shd.g_old_rec.eligy_prfl_id
215: ,p_object_version_number_o
216: => per_ret_shd.g_old_rec.object_version_number
217: ,p_cagr_entitlement_result_id_o
218: => per_ret_shd.g_old_rec.cagr_entitlement_result_id
219: ,p_business_group_id_o
220: => per_ret_shd.g_old_rec.business_group_id

Line 218: => per_ret_shd.g_old_rec.cagr_entitlement_result_id

214: => per_ret_shd.g_old_rec.eligy_prfl_id
215: ,p_object_version_number_o
216: => per_ret_shd.g_old_rec.object_version_number
217: ,p_cagr_entitlement_result_id_o
218: => per_ret_shd.g_old_rec.cagr_entitlement_result_id
219: ,p_business_group_id_o
220: => per_ret_shd.g_old_rec.business_group_id
221: ,p_flex_value_set_id_o
222: => per_ret_shd.g_old_rec.flex_value_set_id

Line 220: => per_ret_shd.g_old_rec.business_group_id

216: => per_ret_shd.g_old_rec.object_version_number
217: ,p_cagr_entitlement_result_id_o
218: => per_ret_shd.g_old_rec.cagr_entitlement_result_id
219: ,p_business_group_id_o
220: => per_ret_shd.g_old_rec.business_group_id
221: ,p_flex_value_set_id_o
222: => per_ret_shd.g_old_rec.flex_value_set_id
223: );
224: --

Line 222: => per_ret_shd.g_old_rec.flex_value_set_id

218: => per_ret_shd.g_old_rec.cagr_entitlement_result_id
219: ,p_business_group_id_o
220: => per_ret_shd.g_old_rec.business_group_id
221: ,p_flex_value_set_id_o
222: => per_ret_shd.g_old_rec.flex_value_set_id
223: );
224: --
225: exception
226: --

Line 243: (p_rec in per_ret_shd.g_rec_type

239: -- ----------------------------------------------------------------------------
240: -- |---------------------------------< del >----------------------------------|
241: -- ----------------------------------------------------------------------------
242: Procedure del
243: (p_rec in per_ret_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
247: --

Line 253: per_ret_shd.lck

249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- We must lock the row which we need to delete.
252: --
253: per_ret_shd.lck
254: (p_rec.cagr_retained_right_id
255: ,p_rec.object_version_number
256: );
257: --

Line 284: l_rec per_ret_shd.g_rec_type;

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