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_EVT_DEL dependencies on PER_EVT_SHD

Line 52: (p_rec in per_evt_shd.g_rec_type

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

Line 60: per_evt_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 10);
59: --
60: per_evt_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_events row.
63: --
64: delete from per_events

Line 67: per_evt_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from per_events
65: where event_id = p_rec.event_id;
66: --
67: per_evt_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 20);
70: --
71: Exception

Line 74: per_evt_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_evt_shd.g_api_dml := false; -- Unset the api dml status
75: per_evt_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 75: per_evt_shd.constraint_error

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

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

74: per_evt_shd.g_api_dml := false; -- Unset the api dml status
75: per_evt_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_evt_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in per_evt_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in per_evt_shd.g_rec_type) is

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

Line 168: => per_evt_shd.g_old_rec.business_group_id

164: per_evt_rkd.after_delete
165: (p_event_id
166: => p_rec.event_id
167: ,p_business_group_id_o
168: => per_evt_shd.g_old_rec.business_group_id
169: ,p_location_id_o
170: => per_evt_shd.g_old_rec.location_id
171: ,p_internal_contact_person_id_o
172: => per_evt_shd.g_old_rec.internal_contact_person_id

Line 170: => per_evt_shd.g_old_rec.location_id

166: => p_rec.event_id
167: ,p_business_group_id_o
168: => per_evt_shd.g_old_rec.business_group_id
169: ,p_location_id_o
170: => per_evt_shd.g_old_rec.location_id
171: ,p_internal_contact_person_id_o
172: => per_evt_shd.g_old_rec.internal_contact_person_id
173: ,p_organization_run_by_id_o
174: => per_evt_shd.g_old_rec.organization_run_by_id

Line 172: => per_evt_shd.g_old_rec.internal_contact_person_id

168: => per_evt_shd.g_old_rec.business_group_id
169: ,p_location_id_o
170: => per_evt_shd.g_old_rec.location_id
171: ,p_internal_contact_person_id_o
172: => per_evt_shd.g_old_rec.internal_contact_person_id
173: ,p_organization_run_by_id_o
174: => per_evt_shd.g_old_rec.organization_run_by_id
175: ,p_assignment_id_o
176: => per_evt_shd.g_old_rec.assignment_id

Line 174: => per_evt_shd.g_old_rec.organization_run_by_id

170: => per_evt_shd.g_old_rec.location_id
171: ,p_internal_contact_person_id_o
172: => per_evt_shd.g_old_rec.internal_contact_person_id
173: ,p_organization_run_by_id_o
174: => per_evt_shd.g_old_rec.organization_run_by_id
175: ,p_assignment_id_o
176: => per_evt_shd.g_old_rec.assignment_id
177: ,p_date_start_o
178: => per_evt_shd.g_old_rec.date_start

Line 176: => per_evt_shd.g_old_rec.assignment_id

172: => per_evt_shd.g_old_rec.internal_contact_person_id
173: ,p_organization_run_by_id_o
174: => per_evt_shd.g_old_rec.organization_run_by_id
175: ,p_assignment_id_o
176: => per_evt_shd.g_old_rec.assignment_id
177: ,p_date_start_o
178: => per_evt_shd.g_old_rec.date_start
179: ,p_type_o
180: => per_evt_shd.g_old_rec.type

Line 178: => per_evt_shd.g_old_rec.date_start

174: => per_evt_shd.g_old_rec.organization_run_by_id
175: ,p_assignment_id_o
176: => per_evt_shd.g_old_rec.assignment_id
177: ,p_date_start_o
178: => per_evt_shd.g_old_rec.date_start
179: ,p_type_o
180: => per_evt_shd.g_old_rec.type
181: ,p_comments_o
182: => per_evt_shd.g_old_rec.comments

Line 180: => per_evt_shd.g_old_rec.type

176: => per_evt_shd.g_old_rec.assignment_id
177: ,p_date_start_o
178: => per_evt_shd.g_old_rec.date_start
179: ,p_type_o
180: => per_evt_shd.g_old_rec.type
181: ,p_comments_o
182: => per_evt_shd.g_old_rec.comments
183: ,p_contact_telephone_number_o
184: => per_evt_shd.g_old_rec.contact_telephone_number

Line 182: => per_evt_shd.g_old_rec.comments

178: => per_evt_shd.g_old_rec.date_start
179: ,p_type_o
180: => per_evt_shd.g_old_rec.type
181: ,p_comments_o
182: => per_evt_shd.g_old_rec.comments
183: ,p_contact_telephone_number_o
184: => per_evt_shd.g_old_rec.contact_telephone_number
185: ,p_date_end_o
186: => per_evt_shd.g_old_rec.date_end

Line 184: => per_evt_shd.g_old_rec.contact_telephone_number

180: => per_evt_shd.g_old_rec.type
181: ,p_comments_o
182: => per_evt_shd.g_old_rec.comments
183: ,p_contact_telephone_number_o
184: => per_evt_shd.g_old_rec.contact_telephone_number
185: ,p_date_end_o
186: => per_evt_shd.g_old_rec.date_end
187: ,p_emp_or_apl_o
188: => per_evt_shd.g_old_rec.emp_or_apl

Line 186: => per_evt_shd.g_old_rec.date_end

182: => per_evt_shd.g_old_rec.comments
183: ,p_contact_telephone_number_o
184: => per_evt_shd.g_old_rec.contact_telephone_number
185: ,p_date_end_o
186: => per_evt_shd.g_old_rec.date_end
187: ,p_emp_or_apl_o
188: => per_evt_shd.g_old_rec.emp_or_apl
189: ,p_event_or_interview_o
190: => per_evt_shd.g_old_rec.event_or_interview

Line 188: => per_evt_shd.g_old_rec.emp_or_apl

184: => per_evt_shd.g_old_rec.contact_telephone_number
185: ,p_date_end_o
186: => per_evt_shd.g_old_rec.date_end
187: ,p_emp_or_apl_o
188: => per_evt_shd.g_old_rec.emp_or_apl
189: ,p_event_or_interview_o
190: => per_evt_shd.g_old_rec.event_or_interview
191: ,p_external_contact_o
192: => per_evt_shd.g_old_rec.external_contact

Line 190: => per_evt_shd.g_old_rec.event_or_interview

186: => per_evt_shd.g_old_rec.date_end
187: ,p_emp_or_apl_o
188: => per_evt_shd.g_old_rec.emp_or_apl
189: ,p_event_or_interview_o
190: => per_evt_shd.g_old_rec.event_or_interview
191: ,p_external_contact_o
192: => per_evt_shd.g_old_rec.external_contact
193: ,p_time_end_o
194: => per_evt_shd.g_old_rec.time_end

Line 192: => per_evt_shd.g_old_rec.external_contact

188: => per_evt_shd.g_old_rec.emp_or_apl
189: ,p_event_or_interview_o
190: => per_evt_shd.g_old_rec.event_or_interview
191: ,p_external_contact_o
192: => per_evt_shd.g_old_rec.external_contact
193: ,p_time_end_o
194: => per_evt_shd.g_old_rec.time_end
195: ,p_time_start_o
196: => per_evt_shd.g_old_rec.time_start

Line 194: => per_evt_shd.g_old_rec.time_end

190: => per_evt_shd.g_old_rec.event_or_interview
191: ,p_external_contact_o
192: => per_evt_shd.g_old_rec.external_contact
193: ,p_time_end_o
194: => per_evt_shd.g_old_rec.time_end
195: ,p_time_start_o
196: => per_evt_shd.g_old_rec.time_start
197: ,p_request_id_o
198: => per_evt_shd.g_old_rec.request_id

Line 196: => per_evt_shd.g_old_rec.time_start

192: => per_evt_shd.g_old_rec.external_contact
193: ,p_time_end_o
194: => per_evt_shd.g_old_rec.time_end
195: ,p_time_start_o
196: => per_evt_shd.g_old_rec.time_start
197: ,p_request_id_o
198: => per_evt_shd.g_old_rec.request_id
199: ,p_program_application_id_o
200: => per_evt_shd.g_old_rec.program_application_id

Line 198: => per_evt_shd.g_old_rec.request_id

194: => per_evt_shd.g_old_rec.time_end
195: ,p_time_start_o
196: => per_evt_shd.g_old_rec.time_start
197: ,p_request_id_o
198: => per_evt_shd.g_old_rec.request_id
199: ,p_program_application_id_o
200: => per_evt_shd.g_old_rec.program_application_id
201: ,p_program_id_o
202: => per_evt_shd.g_old_rec.program_id

Line 200: => per_evt_shd.g_old_rec.program_application_id

196: => per_evt_shd.g_old_rec.time_start
197: ,p_request_id_o
198: => per_evt_shd.g_old_rec.request_id
199: ,p_program_application_id_o
200: => per_evt_shd.g_old_rec.program_application_id
201: ,p_program_id_o
202: => per_evt_shd.g_old_rec.program_id
203: ,p_program_update_date_o
204: => per_evt_shd.g_old_rec.program_update_date

Line 202: => per_evt_shd.g_old_rec.program_id

198: => per_evt_shd.g_old_rec.request_id
199: ,p_program_application_id_o
200: => per_evt_shd.g_old_rec.program_application_id
201: ,p_program_id_o
202: => per_evt_shd.g_old_rec.program_id
203: ,p_program_update_date_o
204: => per_evt_shd.g_old_rec.program_update_date
205: ,p_attribute_category_o
206: => per_evt_shd.g_old_rec.attribute_category

Line 204: => per_evt_shd.g_old_rec.program_update_date

200: => per_evt_shd.g_old_rec.program_application_id
201: ,p_program_id_o
202: => per_evt_shd.g_old_rec.program_id
203: ,p_program_update_date_o
204: => per_evt_shd.g_old_rec.program_update_date
205: ,p_attribute_category_o
206: => per_evt_shd.g_old_rec.attribute_category
207: ,p_attribute1_o
208: => per_evt_shd.g_old_rec.attribute1

Line 206: => per_evt_shd.g_old_rec.attribute_category

202: => per_evt_shd.g_old_rec.program_id
203: ,p_program_update_date_o
204: => per_evt_shd.g_old_rec.program_update_date
205: ,p_attribute_category_o
206: => per_evt_shd.g_old_rec.attribute_category
207: ,p_attribute1_o
208: => per_evt_shd.g_old_rec.attribute1
209: ,p_attribute2_o
210: => per_evt_shd.g_old_rec.attribute2

Line 208: => per_evt_shd.g_old_rec.attribute1

204: => per_evt_shd.g_old_rec.program_update_date
205: ,p_attribute_category_o
206: => per_evt_shd.g_old_rec.attribute_category
207: ,p_attribute1_o
208: => per_evt_shd.g_old_rec.attribute1
209: ,p_attribute2_o
210: => per_evt_shd.g_old_rec.attribute2
211: ,p_attribute3_o
212: => per_evt_shd.g_old_rec.attribute3

Line 210: => per_evt_shd.g_old_rec.attribute2

206: => per_evt_shd.g_old_rec.attribute_category
207: ,p_attribute1_o
208: => per_evt_shd.g_old_rec.attribute1
209: ,p_attribute2_o
210: => per_evt_shd.g_old_rec.attribute2
211: ,p_attribute3_o
212: => per_evt_shd.g_old_rec.attribute3
213: ,p_attribute4_o
214: => per_evt_shd.g_old_rec.attribute4

Line 212: => per_evt_shd.g_old_rec.attribute3

208: => per_evt_shd.g_old_rec.attribute1
209: ,p_attribute2_o
210: => per_evt_shd.g_old_rec.attribute2
211: ,p_attribute3_o
212: => per_evt_shd.g_old_rec.attribute3
213: ,p_attribute4_o
214: => per_evt_shd.g_old_rec.attribute4
215: ,p_attribute5_o
216: => per_evt_shd.g_old_rec.attribute5

Line 214: => per_evt_shd.g_old_rec.attribute4

210: => per_evt_shd.g_old_rec.attribute2
211: ,p_attribute3_o
212: => per_evt_shd.g_old_rec.attribute3
213: ,p_attribute4_o
214: => per_evt_shd.g_old_rec.attribute4
215: ,p_attribute5_o
216: => per_evt_shd.g_old_rec.attribute5
217: ,p_attribute6_o
218: => per_evt_shd.g_old_rec.attribute6

Line 216: => per_evt_shd.g_old_rec.attribute5

212: => per_evt_shd.g_old_rec.attribute3
213: ,p_attribute4_o
214: => per_evt_shd.g_old_rec.attribute4
215: ,p_attribute5_o
216: => per_evt_shd.g_old_rec.attribute5
217: ,p_attribute6_o
218: => per_evt_shd.g_old_rec.attribute6
219: ,p_attribute7_o
220: => per_evt_shd.g_old_rec.attribute7

Line 218: => per_evt_shd.g_old_rec.attribute6

214: => per_evt_shd.g_old_rec.attribute4
215: ,p_attribute5_o
216: => per_evt_shd.g_old_rec.attribute5
217: ,p_attribute6_o
218: => per_evt_shd.g_old_rec.attribute6
219: ,p_attribute7_o
220: => per_evt_shd.g_old_rec.attribute7
221: ,p_attribute8_o
222: => per_evt_shd.g_old_rec.attribute8

Line 220: => per_evt_shd.g_old_rec.attribute7

216: => per_evt_shd.g_old_rec.attribute5
217: ,p_attribute6_o
218: => per_evt_shd.g_old_rec.attribute6
219: ,p_attribute7_o
220: => per_evt_shd.g_old_rec.attribute7
221: ,p_attribute8_o
222: => per_evt_shd.g_old_rec.attribute8
223: ,p_attribute9_o
224: => per_evt_shd.g_old_rec.attribute9

Line 222: => per_evt_shd.g_old_rec.attribute8

218: => per_evt_shd.g_old_rec.attribute6
219: ,p_attribute7_o
220: => per_evt_shd.g_old_rec.attribute7
221: ,p_attribute8_o
222: => per_evt_shd.g_old_rec.attribute8
223: ,p_attribute9_o
224: => per_evt_shd.g_old_rec.attribute9
225: ,p_attribute10_o
226: => per_evt_shd.g_old_rec.attribute10

Line 224: => per_evt_shd.g_old_rec.attribute9

220: => per_evt_shd.g_old_rec.attribute7
221: ,p_attribute8_o
222: => per_evt_shd.g_old_rec.attribute8
223: ,p_attribute9_o
224: => per_evt_shd.g_old_rec.attribute9
225: ,p_attribute10_o
226: => per_evt_shd.g_old_rec.attribute10
227: ,p_attribute11_o
228: => per_evt_shd.g_old_rec.attribute11

Line 226: => per_evt_shd.g_old_rec.attribute10

222: => per_evt_shd.g_old_rec.attribute8
223: ,p_attribute9_o
224: => per_evt_shd.g_old_rec.attribute9
225: ,p_attribute10_o
226: => per_evt_shd.g_old_rec.attribute10
227: ,p_attribute11_o
228: => per_evt_shd.g_old_rec.attribute11
229: ,p_attribute12_o
230: => per_evt_shd.g_old_rec.attribute12

Line 228: => per_evt_shd.g_old_rec.attribute11

224: => per_evt_shd.g_old_rec.attribute9
225: ,p_attribute10_o
226: => per_evt_shd.g_old_rec.attribute10
227: ,p_attribute11_o
228: => per_evt_shd.g_old_rec.attribute11
229: ,p_attribute12_o
230: => per_evt_shd.g_old_rec.attribute12
231: ,p_attribute13_o
232: => per_evt_shd.g_old_rec.attribute13

Line 230: => per_evt_shd.g_old_rec.attribute12

226: => per_evt_shd.g_old_rec.attribute10
227: ,p_attribute11_o
228: => per_evt_shd.g_old_rec.attribute11
229: ,p_attribute12_o
230: => per_evt_shd.g_old_rec.attribute12
231: ,p_attribute13_o
232: => per_evt_shd.g_old_rec.attribute13
233: ,p_attribute14_o
234: => per_evt_shd.g_old_rec.attribute14

Line 232: => per_evt_shd.g_old_rec.attribute13

228: => per_evt_shd.g_old_rec.attribute11
229: ,p_attribute12_o
230: => per_evt_shd.g_old_rec.attribute12
231: ,p_attribute13_o
232: => per_evt_shd.g_old_rec.attribute13
233: ,p_attribute14_o
234: => per_evt_shd.g_old_rec.attribute14
235: ,p_attribute15_o
236: => per_evt_shd.g_old_rec.attribute15

Line 234: => per_evt_shd.g_old_rec.attribute14

230: => per_evt_shd.g_old_rec.attribute12
231: ,p_attribute13_o
232: => per_evt_shd.g_old_rec.attribute13
233: ,p_attribute14_o
234: => per_evt_shd.g_old_rec.attribute14
235: ,p_attribute15_o
236: => per_evt_shd.g_old_rec.attribute15
237: ,p_attribute16_o
238: => per_evt_shd.g_old_rec.attribute16

Line 236: => per_evt_shd.g_old_rec.attribute15

232: => per_evt_shd.g_old_rec.attribute13
233: ,p_attribute14_o
234: => per_evt_shd.g_old_rec.attribute14
235: ,p_attribute15_o
236: => per_evt_shd.g_old_rec.attribute15
237: ,p_attribute16_o
238: => per_evt_shd.g_old_rec.attribute16
239: ,p_attribute17_o
240: => per_evt_shd.g_old_rec.attribute17

Line 238: => per_evt_shd.g_old_rec.attribute16

234: => per_evt_shd.g_old_rec.attribute14
235: ,p_attribute15_o
236: => per_evt_shd.g_old_rec.attribute15
237: ,p_attribute16_o
238: => per_evt_shd.g_old_rec.attribute16
239: ,p_attribute17_o
240: => per_evt_shd.g_old_rec.attribute17
241: ,p_attribute18_o
242: => per_evt_shd.g_old_rec.attribute18

Line 240: => per_evt_shd.g_old_rec.attribute17

236: => per_evt_shd.g_old_rec.attribute15
237: ,p_attribute16_o
238: => per_evt_shd.g_old_rec.attribute16
239: ,p_attribute17_o
240: => per_evt_shd.g_old_rec.attribute17
241: ,p_attribute18_o
242: => per_evt_shd.g_old_rec.attribute18
243: ,p_attribute19_o
244: => per_evt_shd.g_old_rec.attribute19

Line 242: => per_evt_shd.g_old_rec.attribute18

238: => per_evt_shd.g_old_rec.attribute16
239: ,p_attribute17_o
240: => per_evt_shd.g_old_rec.attribute17
241: ,p_attribute18_o
242: => per_evt_shd.g_old_rec.attribute18
243: ,p_attribute19_o
244: => per_evt_shd.g_old_rec.attribute19
245: ,p_attribute20_o
246: => per_evt_shd.g_old_rec.attribute20

Line 244: => per_evt_shd.g_old_rec.attribute19

240: => per_evt_shd.g_old_rec.attribute17
241: ,p_attribute18_o
242: => per_evt_shd.g_old_rec.attribute18
243: ,p_attribute19_o
244: => per_evt_shd.g_old_rec.attribute19
245: ,p_attribute20_o
246: => per_evt_shd.g_old_rec.attribute20
247: ,p_party_id_o
248: => per_evt_shd.g_old_rec.party_id

Line 246: => per_evt_shd.g_old_rec.attribute20

242: => per_evt_shd.g_old_rec.attribute18
243: ,p_attribute19_o
244: => per_evt_shd.g_old_rec.attribute19
245: ,p_attribute20_o
246: => per_evt_shd.g_old_rec.attribute20
247: ,p_party_id_o
248: => per_evt_shd.g_old_rec.party_id
249: ,p_object_version_number_o
250: => per_evt_shd.g_old_rec.object_version_number

Line 248: => per_evt_shd.g_old_rec.party_id

244: => per_evt_shd.g_old_rec.attribute19
245: ,p_attribute20_o
246: => per_evt_shd.g_old_rec.attribute20
247: ,p_party_id_o
248: => per_evt_shd.g_old_rec.party_id
249: ,p_object_version_number_o
250: => per_evt_shd.g_old_rec.object_version_number
251: );
252: --

Line 250: => per_evt_shd.g_old_rec.object_version_number

246: => per_evt_shd.g_old_rec.attribute20
247: ,p_party_id_o
248: => per_evt_shd.g_old_rec.party_id
249: ,p_object_version_number_o
250: => per_evt_shd.g_old_rec.object_version_number
251: );
252: --
253: exception
254: --

Line 270: (p_rec in per_evt_shd.g_rec_type

266: -- ----------------------------------------------------------------------------
267: -- |---------------------------------< del >----------------------------------|
268: -- ----------------------------------------------------------------------------
269: Procedure del
270: (p_rec in per_evt_shd.g_rec_type
271: ) is
272: --
273: l_proc varchar2(72) := g_package||'del';
274: --

Line 280: per_evt_shd.lck

276: hr_utility.set_location('Entering:'||l_proc, 10);
277: --
278: -- We must lock the row which we need to delete.
279: --
280: per_evt_shd.lck
281: (p_rec.event_id
282: ,p_rec.object_version_number
283: );
284: --

Line 312: l_rec per_evt_shd.g_rec_type;

308: (p_event_id in number
309: ,p_object_version_number in number
310: ) is
311: --
312: l_rec per_evt_shd.g_rec_type;
313: l_proc varchar2(72) := g_package||'del';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 10);