APPS.HXC_HPH_DEL dependencies on HXC_HPH_SHD

Line 53: (p_rec in hxc_hph_shd.g_rec_type

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

Line 81: hxc_hph_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: --
81: hxc_hph_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: --
85: Raise;

Line 120: Procedure pre_delete(p_rec in hxc_hph_shd.g_rec_type) is

116: -- Internal Row Handler Use Only.
117: --
118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: Procedure pre_delete(p_rec in hxc_hph_shd.g_rec_type) is
121: --
122: l_proc varchar2(72);
123: --
124: Begin

Line 165: Procedure post_delete(p_rec in hxc_hph_shd.g_rec_type) is

161: -- Internal Row Handler Use Only.
162: --
163: -- {End Of Comments}
164: -- -----------------------------------------------------------------------------
165: Procedure post_delete(p_rec in hxc_hph_shd.g_rec_type) is
166: --
167: l_proc varchar2(72);
168: --
169: Begin

Line 180: => hxc_hph_shd.g_old_rec.type

176: hxc_hph_rkd.after_delete
177: (p_pref_hierarchy_id
178: => p_rec.pref_hierarchy_id
179: ,p_type_o
180: => hxc_hph_shd.g_old_rec.type
181: ,p_name_o
182: => hxc_hph_shd.g_old_rec.name
183: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
184: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code

Line 182: => hxc_hph_shd.g_old_rec.name

178: => p_rec.pref_hierarchy_id
179: ,p_type_o
180: => hxc_hph_shd.g_old_rec.type
181: ,p_name_o
182: => hxc_hph_shd.g_old_rec.name
183: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
184: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
185: ,p_parent_pref_hierarchy_id_o
186: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id

Line 186: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id

182: => hxc_hph_shd.g_old_rec.name
183: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
184: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
185: ,p_parent_pref_hierarchy_id_o
186: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id
187: ,p_edit_allowed_o
188: => hxc_hph_shd.g_old_rec.edit_allowed
189: ,p_displayed_o
190: => hxc_hph_shd.g_old_rec.displayed

Line 188: => hxc_hph_shd.g_old_rec.edit_allowed

184: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
185: ,p_parent_pref_hierarchy_id_o
186: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id
187: ,p_edit_allowed_o
188: => hxc_hph_shd.g_old_rec.edit_allowed
189: ,p_displayed_o
190: => hxc_hph_shd.g_old_rec.displayed
191: ,p_pref_definition_id_o
192: => hxc_hph_shd.g_old_rec.pref_definition_id

Line 190: => hxc_hph_shd.g_old_rec.displayed

186: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id
187: ,p_edit_allowed_o
188: => hxc_hph_shd.g_old_rec.edit_allowed
189: ,p_displayed_o
190: => hxc_hph_shd.g_old_rec.displayed
191: ,p_pref_definition_id_o
192: => hxc_hph_shd.g_old_rec.pref_definition_id
193: ,p_attribute_category_o
194: => hxc_hph_shd.g_old_rec.attribute_category

Line 192: => hxc_hph_shd.g_old_rec.pref_definition_id

188: => hxc_hph_shd.g_old_rec.edit_allowed
189: ,p_displayed_o
190: => hxc_hph_shd.g_old_rec.displayed
191: ,p_pref_definition_id_o
192: => hxc_hph_shd.g_old_rec.pref_definition_id
193: ,p_attribute_category_o
194: => hxc_hph_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hph_shd.g_old_rec.attribute1

Line 194: => hxc_hph_shd.g_old_rec.attribute_category

190: => hxc_hph_shd.g_old_rec.displayed
191: ,p_pref_definition_id_o
192: => hxc_hph_shd.g_old_rec.pref_definition_id
193: ,p_attribute_category_o
194: => hxc_hph_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hph_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hph_shd.g_old_rec.attribute2

Line 196: => hxc_hph_shd.g_old_rec.attribute1

192: => hxc_hph_shd.g_old_rec.pref_definition_id
193: ,p_attribute_category_o
194: => hxc_hph_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hph_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hph_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hph_shd.g_old_rec.attribute3

Line 198: => hxc_hph_shd.g_old_rec.attribute2

194: => hxc_hph_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => hxc_hph_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hph_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hph_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hph_shd.g_old_rec.attribute4

Line 200: => hxc_hph_shd.g_old_rec.attribute3

196: => hxc_hph_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => hxc_hph_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hph_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hph_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hph_shd.g_old_rec.attribute5

Line 202: => hxc_hph_shd.g_old_rec.attribute4

198: => hxc_hph_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => hxc_hph_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hph_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hph_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hph_shd.g_old_rec.attribute6

Line 204: => hxc_hph_shd.g_old_rec.attribute5

200: => hxc_hph_shd.g_old_rec.attribute3
201: ,p_attribute4_o
202: => hxc_hph_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hph_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hph_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hph_shd.g_old_rec.attribute7

Line 206: => hxc_hph_shd.g_old_rec.attribute6

202: => hxc_hph_shd.g_old_rec.attribute4
203: ,p_attribute5_o
204: => hxc_hph_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hph_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hph_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hph_shd.g_old_rec.attribute8

Line 208: => hxc_hph_shd.g_old_rec.attribute7

204: => hxc_hph_shd.g_old_rec.attribute5
205: ,p_attribute6_o
206: => hxc_hph_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hph_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hph_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hph_shd.g_old_rec.attribute9

Line 210: => hxc_hph_shd.g_old_rec.attribute8

206: => hxc_hph_shd.g_old_rec.attribute6
207: ,p_attribute7_o
208: => hxc_hph_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hph_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hph_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hph_shd.g_old_rec.attribute10

Line 212: => hxc_hph_shd.g_old_rec.attribute9

208: => hxc_hph_shd.g_old_rec.attribute7
209: ,p_attribute8_o
210: => hxc_hph_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hph_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hph_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hph_shd.g_old_rec.attribute11

Line 214: => hxc_hph_shd.g_old_rec.attribute10

210: => hxc_hph_shd.g_old_rec.attribute8
211: ,p_attribute9_o
212: => hxc_hph_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hph_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hph_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hph_shd.g_old_rec.attribute12

Line 216: => hxc_hph_shd.g_old_rec.attribute11

212: => hxc_hph_shd.g_old_rec.attribute9
213: ,p_attribute10_o
214: => hxc_hph_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hph_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hph_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hph_shd.g_old_rec.attribute13

Line 218: => hxc_hph_shd.g_old_rec.attribute12

214: => hxc_hph_shd.g_old_rec.attribute10
215: ,p_attribute11_o
216: => hxc_hph_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hph_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hph_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hph_shd.g_old_rec.attribute14

Line 220: => hxc_hph_shd.g_old_rec.attribute13

216: => hxc_hph_shd.g_old_rec.attribute11
217: ,p_attribute12_o
218: => hxc_hph_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hph_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hph_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hph_shd.g_old_rec.attribute15

Line 222: => hxc_hph_shd.g_old_rec.attribute14

218: => hxc_hph_shd.g_old_rec.attribute12
219: ,p_attribute13_o
220: => hxc_hph_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hph_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hph_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hph_shd.g_old_rec.attribute16

Line 224: => hxc_hph_shd.g_old_rec.attribute15

220: => hxc_hph_shd.g_old_rec.attribute13
221: ,p_attribute14_o
222: => hxc_hph_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hph_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hph_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hph_shd.g_old_rec.attribute17

Line 226: => hxc_hph_shd.g_old_rec.attribute16

222: => hxc_hph_shd.g_old_rec.attribute14
223: ,p_attribute15_o
224: => hxc_hph_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hph_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hph_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hph_shd.g_old_rec.attribute18

Line 228: => hxc_hph_shd.g_old_rec.attribute17

224: => hxc_hph_shd.g_old_rec.attribute15
225: ,p_attribute16_o
226: => hxc_hph_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hph_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hph_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hph_shd.g_old_rec.attribute19

Line 230: => hxc_hph_shd.g_old_rec.attribute18

226: => hxc_hph_shd.g_old_rec.attribute16
227: ,p_attribute17_o
228: => hxc_hph_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hph_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hph_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hph_shd.g_old_rec.attribute20

Line 232: => hxc_hph_shd.g_old_rec.attribute19

228: => hxc_hph_shd.g_old_rec.attribute17
229: ,p_attribute18_o
230: => hxc_hph_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hph_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hph_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hph_shd.g_old_rec.attribute21

Line 234: => hxc_hph_shd.g_old_rec.attribute20

230: => hxc_hph_shd.g_old_rec.attribute18
231: ,p_attribute19_o
232: => hxc_hph_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hph_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hph_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hph_shd.g_old_rec.attribute22

Line 236: => hxc_hph_shd.g_old_rec.attribute21

232: => hxc_hph_shd.g_old_rec.attribute19
233: ,p_attribute20_o
234: => hxc_hph_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hph_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hph_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hph_shd.g_old_rec.attribute23

Line 238: => hxc_hph_shd.g_old_rec.attribute22

234: => hxc_hph_shd.g_old_rec.attribute20
235: ,p_attribute21_o
236: => hxc_hph_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hph_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hph_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hph_shd.g_old_rec.attribute24

Line 240: => hxc_hph_shd.g_old_rec.attribute23

236: => hxc_hph_shd.g_old_rec.attribute21
237: ,p_attribute22_o
238: => hxc_hph_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hph_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hph_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hph_shd.g_old_rec.attribute25

Line 242: => hxc_hph_shd.g_old_rec.attribute24

238: => hxc_hph_shd.g_old_rec.attribute22
239: ,p_attribute23_o
240: => hxc_hph_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hph_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hph_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hph_shd.g_old_rec.attribute26

Line 244: => hxc_hph_shd.g_old_rec.attribute25

240: => hxc_hph_shd.g_old_rec.attribute23
241: ,p_attribute24_o
242: => hxc_hph_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hph_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hph_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hph_shd.g_old_rec.attribute27

Line 246: => hxc_hph_shd.g_old_rec.attribute26

242: => hxc_hph_shd.g_old_rec.attribute24
243: ,p_attribute25_o
244: => hxc_hph_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hph_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hph_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hph_shd.g_old_rec.attribute28

Line 248: => hxc_hph_shd.g_old_rec.attribute27

244: => hxc_hph_shd.g_old_rec.attribute25
245: ,p_attribute26_o
246: => hxc_hph_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hph_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hph_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hph_shd.g_old_rec.attribute29

Line 250: => hxc_hph_shd.g_old_rec.attribute28

246: => hxc_hph_shd.g_old_rec.attribute26
247: ,p_attribute27_o
248: => hxc_hph_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hph_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hph_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hph_shd.g_old_rec.attribute30

Line 252: => hxc_hph_shd.g_old_rec.attribute29

248: => hxc_hph_shd.g_old_rec.attribute27
249: ,p_attribute28_o
250: => hxc_hph_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hph_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hph_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hph_shd.g_old_rec.object_version_number

Line 254: => hxc_hph_shd.g_old_rec.attribute30

250: => hxc_hph_shd.g_old_rec.attribute28
251: ,p_attribute29_o
252: => hxc_hph_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hph_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hph_shd.g_old_rec.object_version_number
257: ,p_orig_pref_hierarchy_id_o
258: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id

Line 256: => hxc_hph_shd.g_old_rec.object_version_number

252: => hxc_hph_shd.g_old_rec.attribute29
253: ,p_attribute30_o
254: => hxc_hph_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hph_shd.g_old_rec.object_version_number
257: ,p_orig_pref_hierarchy_id_o
258: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
259: ,p_orig_parent_hierarchy_id_o
260: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id

Line 258: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id

254: => hxc_hph_shd.g_old_rec.attribute30
255: ,p_object_version_number_o
256: => hxc_hph_shd.g_old_rec.object_version_number
257: ,p_orig_pref_hierarchy_id_o
258: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
259: ,p_orig_parent_hierarchy_id_o
260: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
261: ,p_top_level_parent_id_o --Performance Fix
262: => hxc_hph_shd.g_old_rec.top_level_parent_id

Line 260: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id

256: => hxc_hph_shd.g_old_rec.object_version_number
257: ,p_orig_pref_hierarchy_id_o
258: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
259: ,p_orig_parent_hierarchy_id_o
260: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
261: ,p_top_level_parent_id_o --Performance Fix
262: => hxc_hph_shd.g_old_rec.top_level_parent_id
263: ,p_code_o
264: => hxc_hph_shd.g_old_rec.code

Line 262: => hxc_hph_shd.g_old_rec.top_level_parent_id

258: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
259: ,p_orig_parent_hierarchy_id_o
260: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
261: ,p_top_level_parent_id_o --Performance Fix
262: => hxc_hph_shd.g_old_rec.top_level_parent_id
263: ,p_code_o
264: => hxc_hph_shd.g_old_rec.code
265: );
266: --

Line 264: => hxc_hph_shd.g_old_rec.code

260: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
261: ,p_top_level_parent_id_o --Performance Fix
262: => hxc_hph_shd.g_old_rec.top_level_parent_id
263: ,p_code_o
264: => hxc_hph_shd.g_old_rec.code
265: );
266: --
267: exception
268: --

Line 286: (p_rec in hxc_hph_shd.g_rec_type

282: -- ----------------------------------------------------------------------------
283: -- |---------------------------------< del >----------------------------------|
284: -- ----------------------------------------------------------------------------
285: Procedure del
286: (p_rec in hxc_hph_shd.g_rec_type
287: ) is
288: --
289: l_proc varchar2(72);
290: --

Line 300: hxc_hph_shd.lck

296: end if;
297: --
298: -- We must lock the row which we need to delete.
299: --
300: hxc_hph_shd.lck
301: (p_rec.pref_hierarchy_id
302: ,p_rec.object_version_number
303: );
304: --

Line 331: l_rec hxc_hph_shd.g_rec_type;

327: (p_pref_hierarchy_id in number
328: ,p_object_version_number in number
329: ) is
330: --
331: l_rec hxc_hph_shd.g_rec_type;
332: l_proc varchar2(72);
333: --
334: Begin
335: if g_debug then