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.HXC_EGC_DEL dependencies on HXC_EGC_SHD

Line 51: (p_rec in hxc_egc_shd.g_rec_type

47: -- Internal Row Handler Use Only.
48: --
49: -- ----------------------------------------------------------------------------
50: Procedure delete_dml
51: (p_rec in hxc_egc_shd.g_rec_type
52: ) is
53: --
54: l_proc varchar2(72);
55: --

Line 62: hxc_egc_shd.g_api_dml := true; -- Set the api dml status

58: l_proc := g_package||'delete_dml';
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: end if;
61: --
62: hxc_egc_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the hxc_entity_group_comps row.
65: --
66: delete from hxc_entity_group_comps

Line 69: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

65: --
66: delete from hxc_entity_group_comps
67: where entity_group_comp_id = p_rec.entity_group_comp_id;
68: --
69: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
70: --
71: if g_debug then
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: end if;

Line 78: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

74: --
75: Exception
76: When hr_api.child_integrity_violated then
77: -- Child integrity has been violated
78: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
79: hxc_egc_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then
82: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

Line 79: hxc_egc_shd.constraint_error

75: Exception
76: When hr_api.child_integrity_violated then
77: -- Child integrity has been violated
78: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
79: hxc_egc_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then
82: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
83: Raise;

Line 82: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

78: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
79: hxc_egc_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then
82: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
83: Raise;
84: End delete_dml;
85: --
86: -- ----------------------------------------------------------------------------

Line 116: Procedure pre_delete(p_rec in hxc_egc_shd.g_rec_type) is

112: -- Access Status:
113: -- Internal Row Handler Use Only.
114: --
115: -- ----------------------------------------------------------------------------
116: Procedure pre_delete(p_rec in hxc_egc_shd.g_rec_type) is
117: --
118: l_proc varchar2(72);
119: --
120: Begin

Line 159: Procedure post_delete(p_rec in hxc_egc_shd.g_rec_type) is

155: -- Access Status:
156: -- Internal Row Handler Use Only.
157: --
158: -- -----------------------------------------------------------------------------
159: Procedure post_delete(p_rec in hxc_egc_shd.g_rec_type) is
160: --
161: l_proc varchar2(72);
162: --
163: Begin

Line 174: => hxc_egc_shd.g_old_rec.entity_group_id

170: hxc_egc_rkd.after_delete
171: (p_entity_group_comp_id
172: => p_rec.entity_group_comp_id
173: ,p_entity_group_id_o
174: => hxc_egc_shd.g_old_rec.entity_group_id
175: ,p_entity_id_o
176: => hxc_egc_shd.g_old_rec.entity_id
177: ,p_entity_type_o
178: => hxc_egc_shd.g_old_rec.entity_type

Line 176: => hxc_egc_shd.g_old_rec.entity_id

172: => p_rec.entity_group_comp_id
173: ,p_entity_group_id_o
174: => hxc_egc_shd.g_old_rec.entity_group_id
175: ,p_entity_id_o
176: => hxc_egc_shd.g_old_rec.entity_id
177: ,p_entity_type_o
178: => hxc_egc_shd.g_old_rec.entity_type
179: ,p_attribute_category_o
180: => hxc_egc_shd.g_old_rec.attribute_category

Line 178: => hxc_egc_shd.g_old_rec.entity_type

174: => hxc_egc_shd.g_old_rec.entity_group_id
175: ,p_entity_id_o
176: => hxc_egc_shd.g_old_rec.entity_id
177: ,p_entity_type_o
178: => hxc_egc_shd.g_old_rec.entity_type
179: ,p_attribute_category_o
180: => hxc_egc_shd.g_old_rec.attribute_category
181: ,p_attribute1_o
182: => hxc_egc_shd.g_old_rec.attribute1

Line 180: => hxc_egc_shd.g_old_rec.attribute_category

176: => hxc_egc_shd.g_old_rec.entity_id
177: ,p_entity_type_o
178: => hxc_egc_shd.g_old_rec.entity_type
179: ,p_attribute_category_o
180: => hxc_egc_shd.g_old_rec.attribute_category
181: ,p_attribute1_o
182: => hxc_egc_shd.g_old_rec.attribute1
183: ,p_attribute2_o
184: => hxc_egc_shd.g_old_rec.attribute2

Line 182: => hxc_egc_shd.g_old_rec.attribute1

178: => hxc_egc_shd.g_old_rec.entity_type
179: ,p_attribute_category_o
180: => hxc_egc_shd.g_old_rec.attribute_category
181: ,p_attribute1_o
182: => hxc_egc_shd.g_old_rec.attribute1
183: ,p_attribute2_o
184: => hxc_egc_shd.g_old_rec.attribute2
185: ,p_attribute3_o
186: => hxc_egc_shd.g_old_rec.attribute3

Line 184: => hxc_egc_shd.g_old_rec.attribute2

180: => hxc_egc_shd.g_old_rec.attribute_category
181: ,p_attribute1_o
182: => hxc_egc_shd.g_old_rec.attribute1
183: ,p_attribute2_o
184: => hxc_egc_shd.g_old_rec.attribute2
185: ,p_attribute3_o
186: => hxc_egc_shd.g_old_rec.attribute3
187: ,p_attribute4_o
188: => hxc_egc_shd.g_old_rec.attribute4

Line 186: => hxc_egc_shd.g_old_rec.attribute3

182: => hxc_egc_shd.g_old_rec.attribute1
183: ,p_attribute2_o
184: => hxc_egc_shd.g_old_rec.attribute2
185: ,p_attribute3_o
186: => hxc_egc_shd.g_old_rec.attribute3
187: ,p_attribute4_o
188: => hxc_egc_shd.g_old_rec.attribute4
189: ,p_attribute5_o
190: => hxc_egc_shd.g_old_rec.attribute5

Line 188: => hxc_egc_shd.g_old_rec.attribute4

184: => hxc_egc_shd.g_old_rec.attribute2
185: ,p_attribute3_o
186: => hxc_egc_shd.g_old_rec.attribute3
187: ,p_attribute4_o
188: => hxc_egc_shd.g_old_rec.attribute4
189: ,p_attribute5_o
190: => hxc_egc_shd.g_old_rec.attribute5
191: ,p_attribute6_o
192: => hxc_egc_shd.g_old_rec.attribute6

Line 190: => hxc_egc_shd.g_old_rec.attribute5

186: => hxc_egc_shd.g_old_rec.attribute3
187: ,p_attribute4_o
188: => hxc_egc_shd.g_old_rec.attribute4
189: ,p_attribute5_o
190: => hxc_egc_shd.g_old_rec.attribute5
191: ,p_attribute6_o
192: => hxc_egc_shd.g_old_rec.attribute6
193: ,p_attribute7_o
194: => hxc_egc_shd.g_old_rec.attribute7

Line 192: => hxc_egc_shd.g_old_rec.attribute6

188: => hxc_egc_shd.g_old_rec.attribute4
189: ,p_attribute5_o
190: => hxc_egc_shd.g_old_rec.attribute5
191: ,p_attribute6_o
192: => hxc_egc_shd.g_old_rec.attribute6
193: ,p_attribute7_o
194: => hxc_egc_shd.g_old_rec.attribute7
195: ,p_attribute8_o
196: => hxc_egc_shd.g_old_rec.attribute8

Line 194: => hxc_egc_shd.g_old_rec.attribute7

190: => hxc_egc_shd.g_old_rec.attribute5
191: ,p_attribute6_o
192: => hxc_egc_shd.g_old_rec.attribute6
193: ,p_attribute7_o
194: => hxc_egc_shd.g_old_rec.attribute7
195: ,p_attribute8_o
196: => hxc_egc_shd.g_old_rec.attribute8
197: ,p_attribute9_o
198: => hxc_egc_shd.g_old_rec.attribute9

Line 196: => hxc_egc_shd.g_old_rec.attribute8

192: => hxc_egc_shd.g_old_rec.attribute6
193: ,p_attribute7_o
194: => hxc_egc_shd.g_old_rec.attribute7
195: ,p_attribute8_o
196: => hxc_egc_shd.g_old_rec.attribute8
197: ,p_attribute9_o
198: => hxc_egc_shd.g_old_rec.attribute9
199: ,p_attribute10_o
200: => hxc_egc_shd.g_old_rec.attribute10

Line 198: => hxc_egc_shd.g_old_rec.attribute9

194: => hxc_egc_shd.g_old_rec.attribute7
195: ,p_attribute8_o
196: => hxc_egc_shd.g_old_rec.attribute8
197: ,p_attribute9_o
198: => hxc_egc_shd.g_old_rec.attribute9
199: ,p_attribute10_o
200: => hxc_egc_shd.g_old_rec.attribute10
201: ,p_attribute11_o
202: => hxc_egc_shd.g_old_rec.attribute11

Line 200: => hxc_egc_shd.g_old_rec.attribute10

196: => hxc_egc_shd.g_old_rec.attribute8
197: ,p_attribute9_o
198: => hxc_egc_shd.g_old_rec.attribute9
199: ,p_attribute10_o
200: => hxc_egc_shd.g_old_rec.attribute10
201: ,p_attribute11_o
202: => hxc_egc_shd.g_old_rec.attribute11
203: ,p_attribute12_o
204: => hxc_egc_shd.g_old_rec.attribute12

Line 202: => hxc_egc_shd.g_old_rec.attribute11

198: => hxc_egc_shd.g_old_rec.attribute9
199: ,p_attribute10_o
200: => hxc_egc_shd.g_old_rec.attribute10
201: ,p_attribute11_o
202: => hxc_egc_shd.g_old_rec.attribute11
203: ,p_attribute12_o
204: => hxc_egc_shd.g_old_rec.attribute12
205: ,p_attribute13_o
206: => hxc_egc_shd.g_old_rec.attribute13

Line 204: => hxc_egc_shd.g_old_rec.attribute12

200: => hxc_egc_shd.g_old_rec.attribute10
201: ,p_attribute11_o
202: => hxc_egc_shd.g_old_rec.attribute11
203: ,p_attribute12_o
204: => hxc_egc_shd.g_old_rec.attribute12
205: ,p_attribute13_o
206: => hxc_egc_shd.g_old_rec.attribute13
207: ,p_attribute14_o
208: => hxc_egc_shd.g_old_rec.attribute14

Line 206: => hxc_egc_shd.g_old_rec.attribute13

202: => hxc_egc_shd.g_old_rec.attribute11
203: ,p_attribute12_o
204: => hxc_egc_shd.g_old_rec.attribute12
205: ,p_attribute13_o
206: => hxc_egc_shd.g_old_rec.attribute13
207: ,p_attribute14_o
208: => hxc_egc_shd.g_old_rec.attribute14
209: ,p_attribute15_o
210: => hxc_egc_shd.g_old_rec.attribute15

Line 208: => hxc_egc_shd.g_old_rec.attribute14

204: => hxc_egc_shd.g_old_rec.attribute12
205: ,p_attribute13_o
206: => hxc_egc_shd.g_old_rec.attribute13
207: ,p_attribute14_o
208: => hxc_egc_shd.g_old_rec.attribute14
209: ,p_attribute15_o
210: => hxc_egc_shd.g_old_rec.attribute15
211: ,p_attribute16_o
212: => hxc_egc_shd.g_old_rec.attribute16

Line 210: => hxc_egc_shd.g_old_rec.attribute15

206: => hxc_egc_shd.g_old_rec.attribute13
207: ,p_attribute14_o
208: => hxc_egc_shd.g_old_rec.attribute14
209: ,p_attribute15_o
210: => hxc_egc_shd.g_old_rec.attribute15
211: ,p_attribute16_o
212: => hxc_egc_shd.g_old_rec.attribute16
213: ,p_attribute17_o
214: => hxc_egc_shd.g_old_rec.attribute17

Line 212: => hxc_egc_shd.g_old_rec.attribute16

208: => hxc_egc_shd.g_old_rec.attribute14
209: ,p_attribute15_o
210: => hxc_egc_shd.g_old_rec.attribute15
211: ,p_attribute16_o
212: => hxc_egc_shd.g_old_rec.attribute16
213: ,p_attribute17_o
214: => hxc_egc_shd.g_old_rec.attribute17
215: ,p_attribute18_o
216: => hxc_egc_shd.g_old_rec.attribute18

Line 214: => hxc_egc_shd.g_old_rec.attribute17

210: => hxc_egc_shd.g_old_rec.attribute15
211: ,p_attribute16_o
212: => hxc_egc_shd.g_old_rec.attribute16
213: ,p_attribute17_o
214: => hxc_egc_shd.g_old_rec.attribute17
215: ,p_attribute18_o
216: => hxc_egc_shd.g_old_rec.attribute18
217: ,p_attribute19_o
218: => hxc_egc_shd.g_old_rec.attribute19

Line 216: => hxc_egc_shd.g_old_rec.attribute18

212: => hxc_egc_shd.g_old_rec.attribute16
213: ,p_attribute17_o
214: => hxc_egc_shd.g_old_rec.attribute17
215: ,p_attribute18_o
216: => hxc_egc_shd.g_old_rec.attribute18
217: ,p_attribute19_o
218: => hxc_egc_shd.g_old_rec.attribute19
219: ,p_attribute20_o
220: => hxc_egc_shd.g_old_rec.attribute20

Line 218: => hxc_egc_shd.g_old_rec.attribute19

214: => hxc_egc_shd.g_old_rec.attribute17
215: ,p_attribute18_o
216: => hxc_egc_shd.g_old_rec.attribute18
217: ,p_attribute19_o
218: => hxc_egc_shd.g_old_rec.attribute19
219: ,p_attribute20_o
220: => hxc_egc_shd.g_old_rec.attribute20
221: ,p_attribute21_o
222: => hxc_egc_shd.g_old_rec.attribute21

Line 220: => hxc_egc_shd.g_old_rec.attribute20

216: => hxc_egc_shd.g_old_rec.attribute18
217: ,p_attribute19_o
218: => hxc_egc_shd.g_old_rec.attribute19
219: ,p_attribute20_o
220: => hxc_egc_shd.g_old_rec.attribute20
221: ,p_attribute21_o
222: => hxc_egc_shd.g_old_rec.attribute21
223: ,p_attribute22_o
224: => hxc_egc_shd.g_old_rec.attribute22

Line 222: => hxc_egc_shd.g_old_rec.attribute21

218: => hxc_egc_shd.g_old_rec.attribute19
219: ,p_attribute20_o
220: => hxc_egc_shd.g_old_rec.attribute20
221: ,p_attribute21_o
222: => hxc_egc_shd.g_old_rec.attribute21
223: ,p_attribute22_o
224: => hxc_egc_shd.g_old_rec.attribute22
225: ,p_attribute23_o
226: => hxc_egc_shd.g_old_rec.attribute23

Line 224: => hxc_egc_shd.g_old_rec.attribute22

220: => hxc_egc_shd.g_old_rec.attribute20
221: ,p_attribute21_o
222: => hxc_egc_shd.g_old_rec.attribute21
223: ,p_attribute22_o
224: => hxc_egc_shd.g_old_rec.attribute22
225: ,p_attribute23_o
226: => hxc_egc_shd.g_old_rec.attribute23
227: ,p_attribute24_o
228: => hxc_egc_shd.g_old_rec.attribute24

Line 226: => hxc_egc_shd.g_old_rec.attribute23

222: => hxc_egc_shd.g_old_rec.attribute21
223: ,p_attribute22_o
224: => hxc_egc_shd.g_old_rec.attribute22
225: ,p_attribute23_o
226: => hxc_egc_shd.g_old_rec.attribute23
227: ,p_attribute24_o
228: => hxc_egc_shd.g_old_rec.attribute24
229: ,p_attribute25_o
230: => hxc_egc_shd.g_old_rec.attribute25

Line 228: => hxc_egc_shd.g_old_rec.attribute24

224: => hxc_egc_shd.g_old_rec.attribute22
225: ,p_attribute23_o
226: => hxc_egc_shd.g_old_rec.attribute23
227: ,p_attribute24_o
228: => hxc_egc_shd.g_old_rec.attribute24
229: ,p_attribute25_o
230: => hxc_egc_shd.g_old_rec.attribute25
231: ,p_attribute26_o
232: => hxc_egc_shd.g_old_rec.attribute26

Line 230: => hxc_egc_shd.g_old_rec.attribute25

226: => hxc_egc_shd.g_old_rec.attribute23
227: ,p_attribute24_o
228: => hxc_egc_shd.g_old_rec.attribute24
229: ,p_attribute25_o
230: => hxc_egc_shd.g_old_rec.attribute25
231: ,p_attribute26_o
232: => hxc_egc_shd.g_old_rec.attribute26
233: ,p_attribute27_o
234: => hxc_egc_shd.g_old_rec.attribute27

Line 232: => hxc_egc_shd.g_old_rec.attribute26

228: => hxc_egc_shd.g_old_rec.attribute24
229: ,p_attribute25_o
230: => hxc_egc_shd.g_old_rec.attribute25
231: ,p_attribute26_o
232: => hxc_egc_shd.g_old_rec.attribute26
233: ,p_attribute27_o
234: => hxc_egc_shd.g_old_rec.attribute27
235: ,p_attribute28_o
236: => hxc_egc_shd.g_old_rec.attribute28

Line 234: => hxc_egc_shd.g_old_rec.attribute27

230: => hxc_egc_shd.g_old_rec.attribute25
231: ,p_attribute26_o
232: => hxc_egc_shd.g_old_rec.attribute26
233: ,p_attribute27_o
234: => hxc_egc_shd.g_old_rec.attribute27
235: ,p_attribute28_o
236: => hxc_egc_shd.g_old_rec.attribute28
237: ,p_attribute29_o
238: => hxc_egc_shd.g_old_rec.attribute29

Line 236: => hxc_egc_shd.g_old_rec.attribute28

232: => hxc_egc_shd.g_old_rec.attribute26
233: ,p_attribute27_o
234: => hxc_egc_shd.g_old_rec.attribute27
235: ,p_attribute28_o
236: => hxc_egc_shd.g_old_rec.attribute28
237: ,p_attribute29_o
238: => hxc_egc_shd.g_old_rec.attribute29
239: ,p_attribute30_o
240: => hxc_egc_shd.g_old_rec.attribute30

Line 238: => hxc_egc_shd.g_old_rec.attribute29

234: => hxc_egc_shd.g_old_rec.attribute27
235: ,p_attribute28_o
236: => hxc_egc_shd.g_old_rec.attribute28
237: ,p_attribute29_o
238: => hxc_egc_shd.g_old_rec.attribute29
239: ,p_attribute30_o
240: => hxc_egc_shd.g_old_rec.attribute30
241: ,p_object_version_number_o
242: => hxc_egc_shd.g_old_rec.object_version_number

Line 240: => hxc_egc_shd.g_old_rec.attribute30

236: => hxc_egc_shd.g_old_rec.attribute28
237: ,p_attribute29_o
238: => hxc_egc_shd.g_old_rec.attribute29
239: ,p_attribute30_o
240: => hxc_egc_shd.g_old_rec.attribute30
241: ,p_object_version_number_o
242: => hxc_egc_shd.g_old_rec.object_version_number
243: );
244: --

Line 242: => hxc_egc_shd.g_old_rec.object_version_number

238: => hxc_egc_shd.g_old_rec.attribute29
239: ,p_attribute30_o
240: => hxc_egc_shd.g_old_rec.attribute30
241: ,p_object_version_number_o
242: => hxc_egc_shd.g_old_rec.object_version_number
243: );
244: --
245: exception
246: --

Line 264: (p_rec in hxc_egc_shd.g_rec_type

260: -- ----------------------------------------------------------------------------
261: -- |---------------------------------< del >----------------------------------|
262: -- ----------------------------------------------------------------------------
263: Procedure del
264: (p_rec in hxc_egc_shd.g_rec_type
265: ) is
266: --
267: l_proc varchar2(72);
268: --

Line 278: hxc_egc_shd.lck

274: end if;
275: --
276: -- We must lock the row which we need to delete.
277: --
278: hxc_egc_shd.lck
279: (p_rec.entity_group_comp_id
280: ,p_rec.object_version_number
281: );
282: --

Line 309: l_rec hxc_egc_shd.g_rec_type;

305: (p_entity_group_comp_id in number
306: ,p_object_version_number in number
307: ) is
308: --
309: l_rec hxc_egc_shd.g_rec_type;
310: l_proc varchar2(72);
311: --
312: Begin
313: g_debug:=hr_utility.debug_enabled;