APPS.HR_ITP_DEL dependencies on HR_ITP_SHD

Line 52: (p_rec in hr_itp_shd.g_rec_type

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

Line 90: hr_itp_shd.constraint_error

86: Exception
87: When hr_api.child_integrity_violated then
88: -- Child integrity has been violated
89: --
90: hr_itp_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: --
94: Raise;

Line 129: Procedure pre_delete(p_rec in hr_itp_shd.g_rec_type) is

125: -- Internal Row Handler Use Only.
126: --
127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure pre_delete(p_rec in hr_itp_shd.g_rec_type) is
130: --
131: l_proc varchar2(72) := g_package||'pre_delete';
132: --
133: Begin

Line 171: Procedure post_delete(p_rec in hr_itp_shd.g_rec_type) is

167: -- Internal Row Handler Use Only.
168: --
169: -- {End Of Comments}
170: -- -----------------------------------------------------------------------------
171: Procedure post_delete(p_rec in hr_itp_shd.g_rec_type) is
172: --
173: l_proc varchar2(72) := g_package||'post_delete';
174: --
175: Begin

Line 183: => hr_itp_shd.g_old_rec.object_version_number

179: hr_itp_rkd.after_delete
180: (p_item_property_id
181: => p_rec.item_property_id
182: ,p_object_version_number_o
183: => hr_itp_shd.g_old_rec.object_version_number
184: ,p_form_item_id_o
185: => hr_itp_shd.g_old_rec.form_item_id
186: ,p_template_item_id_o
187: => hr_itp_shd.g_old_rec.template_item_id

Line 185: => hr_itp_shd.g_old_rec.form_item_id

181: => p_rec.item_property_id
182: ,p_object_version_number_o
183: => hr_itp_shd.g_old_rec.object_version_number
184: ,p_form_item_id_o
185: => hr_itp_shd.g_old_rec.form_item_id
186: ,p_template_item_id_o
187: => hr_itp_shd.g_old_rec.template_item_id
188: ,p_template_item_context_id_o
189: => hr_itp_shd.g_old_rec.template_item_context_id

Line 187: => hr_itp_shd.g_old_rec.template_item_id

183: => hr_itp_shd.g_old_rec.object_version_number
184: ,p_form_item_id_o
185: => hr_itp_shd.g_old_rec.form_item_id
186: ,p_template_item_id_o
187: => hr_itp_shd.g_old_rec.template_item_id
188: ,p_template_item_context_id_o
189: => hr_itp_shd.g_old_rec.template_item_context_id
190: ,p_alignment_o
191: => hr_itp_shd.g_old_rec.alignment

Line 189: => hr_itp_shd.g_old_rec.template_item_context_id

185: => hr_itp_shd.g_old_rec.form_item_id
186: ,p_template_item_id_o
187: => hr_itp_shd.g_old_rec.template_item_id
188: ,p_template_item_context_id_o
189: => hr_itp_shd.g_old_rec.template_item_context_id
190: ,p_alignment_o
191: => hr_itp_shd.g_old_rec.alignment
192: ,p_bevel_o
193: => hr_itp_shd.g_old_rec.bevel

Line 191: => hr_itp_shd.g_old_rec.alignment

187: => hr_itp_shd.g_old_rec.template_item_id
188: ,p_template_item_context_id_o
189: => hr_itp_shd.g_old_rec.template_item_context_id
190: ,p_alignment_o
191: => hr_itp_shd.g_old_rec.alignment
192: ,p_bevel_o
193: => hr_itp_shd.g_old_rec.bevel
194: ,p_case_restriction_o
195: => hr_itp_shd.g_old_rec.case_restriction

Line 193: => hr_itp_shd.g_old_rec.bevel

189: => hr_itp_shd.g_old_rec.template_item_context_id
190: ,p_alignment_o
191: => hr_itp_shd.g_old_rec.alignment
192: ,p_bevel_o
193: => hr_itp_shd.g_old_rec.bevel
194: ,p_case_restriction_o
195: => hr_itp_shd.g_old_rec.case_restriction
196: ,p_enabled_o
197: => hr_itp_shd.g_old_rec.enabled

Line 195: => hr_itp_shd.g_old_rec.case_restriction

191: => hr_itp_shd.g_old_rec.alignment
192: ,p_bevel_o
193: => hr_itp_shd.g_old_rec.bevel
194: ,p_case_restriction_o
195: => hr_itp_shd.g_old_rec.case_restriction
196: ,p_enabled_o
197: => hr_itp_shd.g_old_rec.enabled
198: ,p_format_mask_o
199: => hr_itp_shd.g_old_rec.format_mask

Line 197: => hr_itp_shd.g_old_rec.enabled

193: => hr_itp_shd.g_old_rec.bevel
194: ,p_case_restriction_o
195: => hr_itp_shd.g_old_rec.case_restriction
196: ,p_enabled_o
197: => hr_itp_shd.g_old_rec.enabled
198: ,p_format_mask_o
199: => hr_itp_shd.g_old_rec.format_mask
200: ,p_height_o
201: => hr_itp_shd.g_old_rec.height

Line 199: => hr_itp_shd.g_old_rec.format_mask

195: => hr_itp_shd.g_old_rec.case_restriction
196: ,p_enabled_o
197: => hr_itp_shd.g_old_rec.enabled
198: ,p_format_mask_o
199: => hr_itp_shd.g_old_rec.format_mask
200: ,p_height_o
201: => hr_itp_shd.g_old_rec.height
202: ,p_information_formula_id_o
203: => hr_itp_shd.g_old_rec.information_formula_id

Line 201: => hr_itp_shd.g_old_rec.height

197: => hr_itp_shd.g_old_rec.enabled
198: ,p_format_mask_o
199: => hr_itp_shd.g_old_rec.format_mask
200: ,p_height_o
201: => hr_itp_shd.g_old_rec.height
202: ,p_information_formula_id_o
203: => hr_itp_shd.g_old_rec.information_formula_id
204: ,p_information_param_item_id1_o
205: => hr_itp_shd.g_old_rec.information_parameter_item_id1

Line 203: => hr_itp_shd.g_old_rec.information_formula_id

199: => hr_itp_shd.g_old_rec.format_mask
200: ,p_height_o
201: => hr_itp_shd.g_old_rec.height
202: ,p_information_formula_id_o
203: => hr_itp_shd.g_old_rec.information_formula_id
204: ,p_information_param_item_id1_o
205: => hr_itp_shd.g_old_rec.information_parameter_item_id1
206: ,p_information_param_item_id2_o
207: => hr_itp_shd.g_old_rec.information_parameter_item_id2

Line 205: => hr_itp_shd.g_old_rec.information_parameter_item_id1

201: => hr_itp_shd.g_old_rec.height
202: ,p_information_formula_id_o
203: => hr_itp_shd.g_old_rec.information_formula_id
204: ,p_information_param_item_id1_o
205: => hr_itp_shd.g_old_rec.information_parameter_item_id1
206: ,p_information_param_item_id2_o
207: => hr_itp_shd.g_old_rec.information_parameter_item_id2
208: ,p_information_param_item_id3_o
209: => hr_itp_shd.g_old_rec.information_parameter_item_id3

Line 207: => hr_itp_shd.g_old_rec.information_parameter_item_id2

203: => hr_itp_shd.g_old_rec.information_formula_id
204: ,p_information_param_item_id1_o
205: => hr_itp_shd.g_old_rec.information_parameter_item_id1
206: ,p_information_param_item_id2_o
207: => hr_itp_shd.g_old_rec.information_parameter_item_id2
208: ,p_information_param_item_id3_o
209: => hr_itp_shd.g_old_rec.information_parameter_item_id3
210: ,p_information_param_item_id4_o
211: => hr_itp_shd.g_old_rec.information_parameter_item_id4

Line 209: => hr_itp_shd.g_old_rec.information_parameter_item_id3

205: => hr_itp_shd.g_old_rec.information_parameter_item_id1
206: ,p_information_param_item_id2_o
207: => hr_itp_shd.g_old_rec.information_parameter_item_id2
208: ,p_information_param_item_id3_o
209: => hr_itp_shd.g_old_rec.information_parameter_item_id3
210: ,p_information_param_item_id4_o
211: => hr_itp_shd.g_old_rec.information_parameter_item_id4
212: ,p_information_param_item_id5_o
213: => hr_itp_shd.g_old_rec.information_parameter_item_id5

Line 211: => hr_itp_shd.g_old_rec.information_parameter_item_id4

207: => hr_itp_shd.g_old_rec.information_parameter_item_id2
208: ,p_information_param_item_id3_o
209: => hr_itp_shd.g_old_rec.information_parameter_item_id3
210: ,p_information_param_item_id4_o
211: => hr_itp_shd.g_old_rec.information_parameter_item_id4
212: ,p_information_param_item_id5_o
213: => hr_itp_shd.g_old_rec.information_parameter_item_id5
214: ,p_insert_allowed_o
215: => hr_itp_shd.g_old_rec.insert_allowed

Line 213: => hr_itp_shd.g_old_rec.information_parameter_item_id5

209: => hr_itp_shd.g_old_rec.information_parameter_item_id3
210: ,p_information_param_item_id4_o
211: => hr_itp_shd.g_old_rec.information_parameter_item_id4
212: ,p_information_param_item_id5_o
213: => hr_itp_shd.g_old_rec.information_parameter_item_id5
214: ,p_insert_allowed_o
215: => hr_itp_shd.g_old_rec.insert_allowed
216: ,p_prompt_alignment_offset_o
217: => hr_itp_shd.g_old_rec.prompt_alignment_offset

Line 215: => hr_itp_shd.g_old_rec.insert_allowed

211: => hr_itp_shd.g_old_rec.information_parameter_item_id4
212: ,p_information_param_item_id5_o
213: => hr_itp_shd.g_old_rec.information_parameter_item_id5
214: ,p_insert_allowed_o
215: => hr_itp_shd.g_old_rec.insert_allowed
216: ,p_prompt_alignment_offset_o
217: => hr_itp_shd.g_old_rec.prompt_alignment_offset
218: ,p_prompt_display_style_o
219: => hr_itp_shd.g_old_rec.prompt_display_style

Line 217: => hr_itp_shd.g_old_rec.prompt_alignment_offset

213: => hr_itp_shd.g_old_rec.information_parameter_item_id5
214: ,p_insert_allowed_o
215: => hr_itp_shd.g_old_rec.insert_allowed
216: ,p_prompt_alignment_offset_o
217: => hr_itp_shd.g_old_rec.prompt_alignment_offset
218: ,p_prompt_display_style_o
219: => hr_itp_shd.g_old_rec.prompt_display_style
220: ,p_prompt_edge_o
221: => hr_itp_shd.g_old_rec.prompt_edge

Line 219: => hr_itp_shd.g_old_rec.prompt_display_style

215: => hr_itp_shd.g_old_rec.insert_allowed
216: ,p_prompt_alignment_offset_o
217: => hr_itp_shd.g_old_rec.prompt_alignment_offset
218: ,p_prompt_display_style_o
219: => hr_itp_shd.g_old_rec.prompt_display_style
220: ,p_prompt_edge_o
221: => hr_itp_shd.g_old_rec.prompt_edge
222: ,p_prompt_edge_alignment_o
223: => hr_itp_shd.g_old_rec.prompt_edge_alignment

Line 221: => hr_itp_shd.g_old_rec.prompt_edge

217: => hr_itp_shd.g_old_rec.prompt_alignment_offset
218: ,p_prompt_display_style_o
219: => hr_itp_shd.g_old_rec.prompt_display_style
220: ,p_prompt_edge_o
221: => hr_itp_shd.g_old_rec.prompt_edge
222: ,p_prompt_edge_alignment_o
223: => hr_itp_shd.g_old_rec.prompt_edge_alignment
224: ,p_prompt_edge_offset_o
225: => hr_itp_shd.g_old_rec.prompt_edge_offset

Line 223: => hr_itp_shd.g_old_rec.prompt_edge_alignment

219: => hr_itp_shd.g_old_rec.prompt_display_style
220: ,p_prompt_edge_o
221: => hr_itp_shd.g_old_rec.prompt_edge
222: ,p_prompt_edge_alignment_o
223: => hr_itp_shd.g_old_rec.prompt_edge_alignment
224: ,p_prompt_edge_offset_o
225: => hr_itp_shd.g_old_rec.prompt_edge_offset
226: ,p_prompt_text_alignment_o
227: => hr_itp_shd.g_old_rec.prompt_text_alignment

Line 225: => hr_itp_shd.g_old_rec.prompt_edge_offset

221: => hr_itp_shd.g_old_rec.prompt_edge
222: ,p_prompt_edge_alignment_o
223: => hr_itp_shd.g_old_rec.prompt_edge_alignment
224: ,p_prompt_edge_offset_o
225: => hr_itp_shd.g_old_rec.prompt_edge_offset
226: ,p_prompt_text_alignment_o
227: => hr_itp_shd.g_old_rec.prompt_text_alignment
228: ,p_query_allowed_o
229: => hr_itp_shd.g_old_rec.query_allowed

Line 227: => hr_itp_shd.g_old_rec.prompt_text_alignment

223: => hr_itp_shd.g_old_rec.prompt_edge_alignment
224: ,p_prompt_edge_offset_o
225: => hr_itp_shd.g_old_rec.prompt_edge_offset
226: ,p_prompt_text_alignment_o
227: => hr_itp_shd.g_old_rec.prompt_text_alignment
228: ,p_query_allowed_o
229: => hr_itp_shd.g_old_rec.query_allowed
230: ,p_required_o
231: => hr_itp_shd.g_old_rec.required

Line 229: => hr_itp_shd.g_old_rec.query_allowed

225: => hr_itp_shd.g_old_rec.prompt_edge_offset
226: ,p_prompt_text_alignment_o
227: => hr_itp_shd.g_old_rec.prompt_text_alignment
228: ,p_query_allowed_o
229: => hr_itp_shd.g_old_rec.query_allowed
230: ,p_required_o
231: => hr_itp_shd.g_old_rec.required
232: ,p_update_allowed_o
233: => hr_itp_shd.g_old_rec.update_allowed

Line 231: => hr_itp_shd.g_old_rec.required

227: => hr_itp_shd.g_old_rec.prompt_text_alignment
228: ,p_query_allowed_o
229: => hr_itp_shd.g_old_rec.query_allowed
230: ,p_required_o
231: => hr_itp_shd.g_old_rec.required
232: ,p_update_allowed_o
233: => hr_itp_shd.g_old_rec.update_allowed
234: ,p_validation_formula_id_o
235: => hr_itp_shd.g_old_rec.validation_formula_id

Line 233: => hr_itp_shd.g_old_rec.update_allowed

229: => hr_itp_shd.g_old_rec.query_allowed
230: ,p_required_o
231: => hr_itp_shd.g_old_rec.required
232: ,p_update_allowed_o
233: => hr_itp_shd.g_old_rec.update_allowed
234: ,p_validation_formula_id_o
235: => hr_itp_shd.g_old_rec.validation_formula_id
236: ,p_validation_param_item_id1_o
237: => hr_itp_shd.g_old_rec.validation_parameter_item_id1

Line 235: => hr_itp_shd.g_old_rec.validation_formula_id

231: => hr_itp_shd.g_old_rec.required
232: ,p_update_allowed_o
233: => hr_itp_shd.g_old_rec.update_allowed
234: ,p_validation_formula_id_o
235: => hr_itp_shd.g_old_rec.validation_formula_id
236: ,p_validation_param_item_id1_o
237: => hr_itp_shd.g_old_rec.validation_parameter_item_id1
238: ,p_validation_param_item_id2_o
239: => hr_itp_shd.g_old_rec.validation_parameter_item_id2

Line 237: => hr_itp_shd.g_old_rec.validation_parameter_item_id1

233: => hr_itp_shd.g_old_rec.update_allowed
234: ,p_validation_formula_id_o
235: => hr_itp_shd.g_old_rec.validation_formula_id
236: ,p_validation_param_item_id1_o
237: => hr_itp_shd.g_old_rec.validation_parameter_item_id1
238: ,p_validation_param_item_id2_o
239: => hr_itp_shd.g_old_rec.validation_parameter_item_id2
240: ,p_validation_param_item_id3_o
241: => hr_itp_shd.g_old_rec.validation_parameter_item_id3

Line 239: => hr_itp_shd.g_old_rec.validation_parameter_item_id2

235: => hr_itp_shd.g_old_rec.validation_formula_id
236: ,p_validation_param_item_id1_o
237: => hr_itp_shd.g_old_rec.validation_parameter_item_id1
238: ,p_validation_param_item_id2_o
239: => hr_itp_shd.g_old_rec.validation_parameter_item_id2
240: ,p_validation_param_item_id3_o
241: => hr_itp_shd.g_old_rec.validation_parameter_item_id3
242: ,p_validation_param_item_id4_o
243: => hr_itp_shd.g_old_rec.validation_parameter_item_id4

Line 241: => hr_itp_shd.g_old_rec.validation_parameter_item_id3

237: => hr_itp_shd.g_old_rec.validation_parameter_item_id1
238: ,p_validation_param_item_id2_o
239: => hr_itp_shd.g_old_rec.validation_parameter_item_id2
240: ,p_validation_param_item_id3_o
241: => hr_itp_shd.g_old_rec.validation_parameter_item_id3
242: ,p_validation_param_item_id4_o
243: => hr_itp_shd.g_old_rec.validation_parameter_item_id4
244: ,p_validation_param_item_id5_o
245: => hr_itp_shd.g_old_rec.validation_parameter_item_id5

Line 243: => hr_itp_shd.g_old_rec.validation_parameter_item_id4

239: => hr_itp_shd.g_old_rec.validation_parameter_item_id2
240: ,p_validation_param_item_id3_o
241: => hr_itp_shd.g_old_rec.validation_parameter_item_id3
242: ,p_validation_param_item_id4_o
243: => hr_itp_shd.g_old_rec.validation_parameter_item_id4
244: ,p_validation_param_item_id5_o
245: => hr_itp_shd.g_old_rec.validation_parameter_item_id5
246: ,p_visible_o
247: => hr_itp_shd.g_old_rec.visible

Line 245: => hr_itp_shd.g_old_rec.validation_parameter_item_id5

241: => hr_itp_shd.g_old_rec.validation_parameter_item_id3
242: ,p_validation_param_item_id4_o
243: => hr_itp_shd.g_old_rec.validation_parameter_item_id4
244: ,p_validation_param_item_id5_o
245: => hr_itp_shd.g_old_rec.validation_parameter_item_id5
246: ,p_visible_o
247: => hr_itp_shd.g_old_rec.visible
248: ,p_width_o
249: => hr_itp_shd.g_old_rec.width

Line 247: => hr_itp_shd.g_old_rec.visible

243: => hr_itp_shd.g_old_rec.validation_parameter_item_id4
244: ,p_validation_param_item_id5_o
245: => hr_itp_shd.g_old_rec.validation_parameter_item_id5
246: ,p_visible_o
247: => hr_itp_shd.g_old_rec.visible
248: ,p_width_o
249: => hr_itp_shd.g_old_rec.width
250: ,p_x_position_o
251: => hr_itp_shd.g_old_rec.x_position

Line 249: => hr_itp_shd.g_old_rec.width

245: => hr_itp_shd.g_old_rec.validation_parameter_item_id5
246: ,p_visible_o
247: => hr_itp_shd.g_old_rec.visible
248: ,p_width_o
249: => hr_itp_shd.g_old_rec.width
250: ,p_x_position_o
251: => hr_itp_shd.g_old_rec.x_position
252: ,p_y_position_o
253: => hr_itp_shd.g_old_rec.y_position

Line 251: => hr_itp_shd.g_old_rec.x_position

247: => hr_itp_shd.g_old_rec.visible
248: ,p_width_o
249: => hr_itp_shd.g_old_rec.width
250: ,p_x_position_o
251: => hr_itp_shd.g_old_rec.x_position
252: ,p_y_position_o
253: => hr_itp_shd.g_old_rec.y_position
254: ,p_information_category_o
255: => hr_itp_shd.g_old_rec.information_category

Line 253: => hr_itp_shd.g_old_rec.y_position

249: => hr_itp_shd.g_old_rec.width
250: ,p_x_position_o
251: => hr_itp_shd.g_old_rec.x_position
252: ,p_y_position_o
253: => hr_itp_shd.g_old_rec.y_position
254: ,p_information_category_o
255: => hr_itp_shd.g_old_rec.information_category
256: ,p_information1_o
257: => hr_itp_shd.g_old_rec.information1

Line 255: => hr_itp_shd.g_old_rec.information_category

251: => hr_itp_shd.g_old_rec.x_position
252: ,p_y_position_o
253: => hr_itp_shd.g_old_rec.y_position
254: ,p_information_category_o
255: => hr_itp_shd.g_old_rec.information_category
256: ,p_information1_o
257: => hr_itp_shd.g_old_rec.information1
258: ,p_information2_o
259: => hr_itp_shd.g_old_rec.information2

Line 257: => hr_itp_shd.g_old_rec.information1

253: => hr_itp_shd.g_old_rec.y_position
254: ,p_information_category_o
255: => hr_itp_shd.g_old_rec.information_category
256: ,p_information1_o
257: => hr_itp_shd.g_old_rec.information1
258: ,p_information2_o
259: => hr_itp_shd.g_old_rec.information2
260: ,p_information3_o
261: => hr_itp_shd.g_old_rec.information3

Line 259: => hr_itp_shd.g_old_rec.information2

255: => hr_itp_shd.g_old_rec.information_category
256: ,p_information1_o
257: => hr_itp_shd.g_old_rec.information1
258: ,p_information2_o
259: => hr_itp_shd.g_old_rec.information2
260: ,p_information3_o
261: => hr_itp_shd.g_old_rec.information3
262: ,p_information4_o
263: => hr_itp_shd.g_old_rec.information4

Line 261: => hr_itp_shd.g_old_rec.information3

257: => hr_itp_shd.g_old_rec.information1
258: ,p_information2_o
259: => hr_itp_shd.g_old_rec.information2
260: ,p_information3_o
261: => hr_itp_shd.g_old_rec.information3
262: ,p_information4_o
263: => hr_itp_shd.g_old_rec.information4
264: ,p_information5_o
265: => hr_itp_shd.g_old_rec.information5

Line 263: => hr_itp_shd.g_old_rec.information4

259: => hr_itp_shd.g_old_rec.information2
260: ,p_information3_o
261: => hr_itp_shd.g_old_rec.information3
262: ,p_information4_o
263: => hr_itp_shd.g_old_rec.information4
264: ,p_information5_o
265: => hr_itp_shd.g_old_rec.information5
266: ,p_information6_o
267: => hr_itp_shd.g_old_rec.information6

Line 265: => hr_itp_shd.g_old_rec.information5

261: => hr_itp_shd.g_old_rec.information3
262: ,p_information4_o
263: => hr_itp_shd.g_old_rec.information4
264: ,p_information5_o
265: => hr_itp_shd.g_old_rec.information5
266: ,p_information6_o
267: => hr_itp_shd.g_old_rec.information6
268: ,p_information7_o
269: => hr_itp_shd.g_old_rec.information7

Line 267: => hr_itp_shd.g_old_rec.information6

263: => hr_itp_shd.g_old_rec.information4
264: ,p_information5_o
265: => hr_itp_shd.g_old_rec.information5
266: ,p_information6_o
267: => hr_itp_shd.g_old_rec.information6
268: ,p_information7_o
269: => hr_itp_shd.g_old_rec.information7
270: ,p_information8_o
271: => hr_itp_shd.g_old_rec.information8

Line 269: => hr_itp_shd.g_old_rec.information7

265: => hr_itp_shd.g_old_rec.information5
266: ,p_information6_o
267: => hr_itp_shd.g_old_rec.information6
268: ,p_information7_o
269: => hr_itp_shd.g_old_rec.information7
270: ,p_information8_o
271: => hr_itp_shd.g_old_rec.information8
272: ,p_information9_o
273: => hr_itp_shd.g_old_rec.information9

Line 271: => hr_itp_shd.g_old_rec.information8

267: => hr_itp_shd.g_old_rec.information6
268: ,p_information7_o
269: => hr_itp_shd.g_old_rec.information7
270: ,p_information8_o
271: => hr_itp_shd.g_old_rec.information8
272: ,p_information9_o
273: => hr_itp_shd.g_old_rec.information9
274: ,p_information10_o
275: => hr_itp_shd.g_old_rec.information10

Line 273: => hr_itp_shd.g_old_rec.information9

269: => hr_itp_shd.g_old_rec.information7
270: ,p_information8_o
271: => hr_itp_shd.g_old_rec.information8
272: ,p_information9_o
273: => hr_itp_shd.g_old_rec.information9
274: ,p_information10_o
275: => hr_itp_shd.g_old_rec.information10
276: ,p_information11_o
277: => hr_itp_shd.g_old_rec.information11

Line 275: => hr_itp_shd.g_old_rec.information10

271: => hr_itp_shd.g_old_rec.information8
272: ,p_information9_o
273: => hr_itp_shd.g_old_rec.information9
274: ,p_information10_o
275: => hr_itp_shd.g_old_rec.information10
276: ,p_information11_o
277: => hr_itp_shd.g_old_rec.information11
278: ,p_information12_o
279: => hr_itp_shd.g_old_rec.information12

Line 277: => hr_itp_shd.g_old_rec.information11

273: => hr_itp_shd.g_old_rec.information9
274: ,p_information10_o
275: => hr_itp_shd.g_old_rec.information10
276: ,p_information11_o
277: => hr_itp_shd.g_old_rec.information11
278: ,p_information12_o
279: => hr_itp_shd.g_old_rec.information12
280: ,p_information13_o
281: => hr_itp_shd.g_old_rec.information13

Line 279: => hr_itp_shd.g_old_rec.information12

275: => hr_itp_shd.g_old_rec.information10
276: ,p_information11_o
277: => hr_itp_shd.g_old_rec.information11
278: ,p_information12_o
279: => hr_itp_shd.g_old_rec.information12
280: ,p_information13_o
281: => hr_itp_shd.g_old_rec.information13
282: ,p_information14_o
283: => hr_itp_shd.g_old_rec.information14

Line 281: => hr_itp_shd.g_old_rec.information13

277: => hr_itp_shd.g_old_rec.information11
278: ,p_information12_o
279: => hr_itp_shd.g_old_rec.information12
280: ,p_information13_o
281: => hr_itp_shd.g_old_rec.information13
282: ,p_information14_o
283: => hr_itp_shd.g_old_rec.information14
284: ,p_information15_o
285: => hr_itp_shd.g_old_rec.information15

Line 283: => hr_itp_shd.g_old_rec.information14

279: => hr_itp_shd.g_old_rec.information12
280: ,p_information13_o
281: => hr_itp_shd.g_old_rec.information13
282: ,p_information14_o
283: => hr_itp_shd.g_old_rec.information14
284: ,p_information15_o
285: => hr_itp_shd.g_old_rec.information15
286: ,p_information16_o
287: => hr_itp_shd.g_old_rec.information16

Line 285: => hr_itp_shd.g_old_rec.information15

281: => hr_itp_shd.g_old_rec.information13
282: ,p_information14_o
283: => hr_itp_shd.g_old_rec.information14
284: ,p_information15_o
285: => hr_itp_shd.g_old_rec.information15
286: ,p_information16_o
287: => hr_itp_shd.g_old_rec.information16
288: ,p_information17_o
289: => hr_itp_shd.g_old_rec.information17

Line 287: => hr_itp_shd.g_old_rec.information16

283: => hr_itp_shd.g_old_rec.information14
284: ,p_information15_o
285: => hr_itp_shd.g_old_rec.information15
286: ,p_information16_o
287: => hr_itp_shd.g_old_rec.information16
288: ,p_information17_o
289: => hr_itp_shd.g_old_rec.information17
290: ,p_information18_o
291: => hr_itp_shd.g_old_rec.information18

Line 289: => hr_itp_shd.g_old_rec.information17

285: => hr_itp_shd.g_old_rec.information15
286: ,p_information16_o
287: => hr_itp_shd.g_old_rec.information16
288: ,p_information17_o
289: => hr_itp_shd.g_old_rec.information17
290: ,p_information18_o
291: => hr_itp_shd.g_old_rec.information18
292: ,p_information19_o
293: => hr_itp_shd.g_old_rec.information19

Line 291: => hr_itp_shd.g_old_rec.information18

287: => hr_itp_shd.g_old_rec.information16
288: ,p_information17_o
289: => hr_itp_shd.g_old_rec.information17
290: ,p_information18_o
291: => hr_itp_shd.g_old_rec.information18
292: ,p_information19_o
293: => hr_itp_shd.g_old_rec.information19
294: ,p_information20_o
295: => hr_itp_shd.g_old_rec.information20

Line 293: => hr_itp_shd.g_old_rec.information19

289: => hr_itp_shd.g_old_rec.information17
290: ,p_information18_o
291: => hr_itp_shd.g_old_rec.information18
292: ,p_information19_o
293: => hr_itp_shd.g_old_rec.information19
294: ,p_information20_o
295: => hr_itp_shd.g_old_rec.information20
296: ,p_information21_o
297: => hr_itp_shd.g_old_rec.information21

Line 295: => hr_itp_shd.g_old_rec.information20

291: => hr_itp_shd.g_old_rec.information18
292: ,p_information19_o
293: => hr_itp_shd.g_old_rec.information19
294: ,p_information20_o
295: => hr_itp_shd.g_old_rec.information20
296: ,p_information21_o
297: => hr_itp_shd.g_old_rec.information21
298: ,p_information22_o
299: => hr_itp_shd.g_old_rec.information22

Line 297: => hr_itp_shd.g_old_rec.information21

293: => hr_itp_shd.g_old_rec.information19
294: ,p_information20_o
295: => hr_itp_shd.g_old_rec.information20
296: ,p_information21_o
297: => hr_itp_shd.g_old_rec.information21
298: ,p_information22_o
299: => hr_itp_shd.g_old_rec.information22
300: ,p_information23_o
301: => hr_itp_shd.g_old_rec.information23

Line 299: => hr_itp_shd.g_old_rec.information22

295: => hr_itp_shd.g_old_rec.information20
296: ,p_information21_o
297: => hr_itp_shd.g_old_rec.information21
298: ,p_information22_o
299: => hr_itp_shd.g_old_rec.information22
300: ,p_information23_o
301: => hr_itp_shd.g_old_rec.information23
302: ,p_information24_o
303: => hr_itp_shd.g_old_rec.information24

Line 301: => hr_itp_shd.g_old_rec.information23

297: => hr_itp_shd.g_old_rec.information21
298: ,p_information22_o
299: => hr_itp_shd.g_old_rec.information22
300: ,p_information23_o
301: => hr_itp_shd.g_old_rec.information23
302: ,p_information24_o
303: => hr_itp_shd.g_old_rec.information24
304: ,p_information25_o
305: => hr_itp_shd.g_old_rec.information25

Line 303: => hr_itp_shd.g_old_rec.information24

299: => hr_itp_shd.g_old_rec.information22
300: ,p_information23_o
301: => hr_itp_shd.g_old_rec.information23
302: ,p_information24_o
303: => hr_itp_shd.g_old_rec.information24
304: ,p_information25_o
305: => hr_itp_shd.g_old_rec.information25
306: ,p_information26_o
307: => hr_itp_shd.g_old_rec.information26

Line 305: => hr_itp_shd.g_old_rec.information25

301: => hr_itp_shd.g_old_rec.information23
302: ,p_information24_o
303: => hr_itp_shd.g_old_rec.information24
304: ,p_information25_o
305: => hr_itp_shd.g_old_rec.information25
306: ,p_information26_o
307: => hr_itp_shd.g_old_rec.information26
308: ,p_information27_o
309: => hr_itp_shd.g_old_rec.information27

Line 307: => hr_itp_shd.g_old_rec.information26

303: => hr_itp_shd.g_old_rec.information24
304: ,p_information25_o
305: => hr_itp_shd.g_old_rec.information25
306: ,p_information26_o
307: => hr_itp_shd.g_old_rec.information26
308: ,p_information27_o
309: => hr_itp_shd.g_old_rec.information27
310: ,p_information28_o
311: => hr_itp_shd.g_old_rec.information28

Line 309: => hr_itp_shd.g_old_rec.information27

305: => hr_itp_shd.g_old_rec.information25
306: ,p_information26_o
307: => hr_itp_shd.g_old_rec.information26
308: ,p_information27_o
309: => hr_itp_shd.g_old_rec.information27
310: ,p_information28_o
311: => hr_itp_shd.g_old_rec.information28
312: ,p_information29_o
313: => hr_itp_shd.g_old_rec.information29

Line 311: => hr_itp_shd.g_old_rec.information28

307: => hr_itp_shd.g_old_rec.information26
308: ,p_information27_o
309: => hr_itp_shd.g_old_rec.information27
310: ,p_information28_o
311: => hr_itp_shd.g_old_rec.information28
312: ,p_information29_o
313: => hr_itp_shd.g_old_rec.information29
314: ,p_information30_o
315: => hr_itp_shd.g_old_rec.information30

Line 313: => hr_itp_shd.g_old_rec.information29

309: => hr_itp_shd.g_old_rec.information27
310: ,p_information28_o
311: => hr_itp_shd.g_old_rec.information28
312: ,p_information29_o
313: => hr_itp_shd.g_old_rec.information29
314: ,p_information30_o
315: => hr_itp_shd.g_old_rec.information30
316: ,p_next_navigation_item_id_o
317: => hr_itp_shd.g_old_rec.next_navigation_item_id

Line 315: => hr_itp_shd.g_old_rec.information30

311: => hr_itp_shd.g_old_rec.information28
312: ,p_information29_o
313: => hr_itp_shd.g_old_rec.information29
314: ,p_information30_o
315: => hr_itp_shd.g_old_rec.information30
316: ,p_next_navigation_item_id_o
317: => hr_itp_shd.g_old_rec.next_navigation_item_id
318: ,p_prev_navigation_item_id_o
319: => hr_itp_shd.g_old_rec.previous_navigation_item_id

Line 317: => hr_itp_shd.g_old_rec.next_navigation_item_id

313: => hr_itp_shd.g_old_rec.information29
314: ,p_information30_o
315: => hr_itp_shd.g_old_rec.information30
316: ,p_next_navigation_item_id_o
317: => hr_itp_shd.g_old_rec.next_navigation_item_id
318: ,p_prev_navigation_item_id_o
319: => hr_itp_shd.g_old_rec.previous_navigation_item_id
320: );
321: --

Line 319: => hr_itp_shd.g_old_rec.previous_navigation_item_id

315: => hr_itp_shd.g_old_rec.information30
316: ,p_next_navigation_item_id_o
317: => hr_itp_shd.g_old_rec.next_navigation_item_id
318: ,p_prev_navigation_item_id_o
319: => hr_itp_shd.g_old_rec.previous_navigation_item_id
320: );
321: --
322: exception
323: --

Line 339: (p_rec in hr_itp_shd.g_rec_type

335: -- ----------------------------------------------------------------------------
336: -- |---------------------------------< del >----------------------------------|
337: -- ----------------------------------------------------------------------------
338: Procedure del
339: (p_rec in hr_itp_shd.g_rec_type
340: ) is
341: --
342: l_proc varchar2(72) := g_package||'del';
343: --

Line 349: hr_itp_shd.lck

345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: -- We must lock the row which we need to delete.
348: --
349: hr_itp_shd.lck
350: (p_rec.item_property_id
351: ,p_rec.object_version_number
352: );
353: --

Line 380: l_rec hr_itp_shd.g_rec_type;

376: (p_item_property_id in number
377: ,p_object_version_number in number
378: ) is
379: --
380: l_rec hr_itp_shd.g_rec_type;
381: l_proc varchar2(72) := g_package||'del';
382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);