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.IRC_INP_DEL dependencies on IRC_INP_SHD

Line 52: (p_rec in irc_inp_shd.g_rec_type

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

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

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

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

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

Line 74: irc_inp_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: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
75: --
76: irc_inp_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then

Line 76: irc_inp_shd.constraint_error

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

Line 79: irc_inp_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 158: Procedure post_delete(p_rec in irc_inp_shd.g_rec_type) is

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

Line 168: => irc_inp_shd.g_old_rec.party_id

164: begin
165: --
166: irc_inp_rkd.after_delete
167: (p_party_id_o
168: => irc_inp_shd.g_old_rec.party_id
169: ,p_notification_preference_id => p_rec.notification_preference_id
170: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
171: ,p_matching_jobs_o
172: => irc_inp_shd.g_old_rec.matching_jobs

Line 170: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id

166: irc_inp_rkd.after_delete
167: (p_party_id_o
168: => irc_inp_shd.g_old_rec.party_id
169: ,p_notification_preference_id => p_rec.notification_preference_id
170: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
171: ,p_matching_jobs_o
172: => irc_inp_shd.g_old_rec.matching_jobs
173: ,p_matching_job_freq_o
174: => irc_inp_shd.g_old_rec.matching_job_freq

Line 172: => irc_inp_shd.g_old_rec.matching_jobs

168: => irc_inp_shd.g_old_rec.party_id
169: ,p_notification_preference_id => p_rec.notification_preference_id
170: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
171: ,p_matching_jobs_o
172: => irc_inp_shd.g_old_rec.matching_jobs
173: ,p_matching_job_freq_o
174: => irc_inp_shd.g_old_rec.matching_job_freq
175: ,p_attribute_category_o
176: => irc_inp_shd.g_old_rec.attribute_category

Line 174: => irc_inp_shd.g_old_rec.matching_job_freq

170: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
171: ,p_matching_jobs_o
172: => irc_inp_shd.g_old_rec.matching_jobs
173: ,p_matching_job_freq_o
174: => irc_inp_shd.g_old_rec.matching_job_freq
175: ,p_attribute_category_o
176: => irc_inp_shd.g_old_rec.attribute_category
177: ,p_receive_info_mail_o
178: => irc_inp_shd.g_old_rec.receive_info_mail

Line 176: => irc_inp_shd.g_old_rec.attribute_category

172: => irc_inp_shd.g_old_rec.matching_jobs
173: ,p_matching_job_freq_o
174: => irc_inp_shd.g_old_rec.matching_job_freq
175: ,p_attribute_category_o
176: => irc_inp_shd.g_old_rec.attribute_category
177: ,p_receive_info_mail_o
178: => irc_inp_shd.g_old_rec.receive_info_mail
179: ,p_allow_access_o
180: => irc_inp_shd.g_old_rec.allow_access

Line 178: => irc_inp_shd.g_old_rec.receive_info_mail

174: => irc_inp_shd.g_old_rec.matching_job_freq
175: ,p_attribute_category_o
176: => irc_inp_shd.g_old_rec.attribute_category
177: ,p_receive_info_mail_o
178: => irc_inp_shd.g_old_rec.receive_info_mail
179: ,p_allow_access_o
180: => irc_inp_shd.g_old_rec.allow_access
181: ,p_address_id_o
182: => irc_inp_shd.g_old_rec.address_id

Line 180: => irc_inp_shd.g_old_rec.allow_access

176: => irc_inp_shd.g_old_rec.attribute_category
177: ,p_receive_info_mail_o
178: => irc_inp_shd.g_old_rec.receive_info_mail
179: ,p_allow_access_o
180: => irc_inp_shd.g_old_rec.allow_access
181: ,p_address_id_o
182: => irc_inp_shd.g_old_rec.address_id
183: ,p_attribute1_o
184: => irc_inp_shd.g_old_rec.attribute1

Line 182: => irc_inp_shd.g_old_rec.address_id

178: => irc_inp_shd.g_old_rec.receive_info_mail
179: ,p_allow_access_o
180: => irc_inp_shd.g_old_rec.allow_access
181: ,p_address_id_o
182: => irc_inp_shd.g_old_rec.address_id
183: ,p_attribute1_o
184: => irc_inp_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => irc_inp_shd.g_old_rec.attribute2

Line 184: => irc_inp_shd.g_old_rec.attribute1

180: => irc_inp_shd.g_old_rec.allow_access
181: ,p_address_id_o
182: => irc_inp_shd.g_old_rec.address_id
183: ,p_attribute1_o
184: => irc_inp_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => irc_inp_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => irc_inp_shd.g_old_rec.attribute3

Line 186: => irc_inp_shd.g_old_rec.attribute2

182: => irc_inp_shd.g_old_rec.address_id
183: ,p_attribute1_o
184: => irc_inp_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => irc_inp_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => irc_inp_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => irc_inp_shd.g_old_rec.attribute4

Line 188: => irc_inp_shd.g_old_rec.attribute3

184: => irc_inp_shd.g_old_rec.attribute1
185: ,p_attribute2_o
186: => irc_inp_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => irc_inp_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => irc_inp_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => irc_inp_shd.g_old_rec.attribute5

Line 190: => irc_inp_shd.g_old_rec.attribute4

186: => irc_inp_shd.g_old_rec.attribute2
187: ,p_attribute3_o
188: => irc_inp_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => irc_inp_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => irc_inp_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => irc_inp_shd.g_old_rec.attribute6

Line 192: => irc_inp_shd.g_old_rec.attribute5

188: => irc_inp_shd.g_old_rec.attribute3
189: ,p_attribute4_o
190: => irc_inp_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => irc_inp_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => irc_inp_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => irc_inp_shd.g_old_rec.attribute7

Line 194: => irc_inp_shd.g_old_rec.attribute6

190: => irc_inp_shd.g_old_rec.attribute4
191: ,p_attribute5_o
192: => irc_inp_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => irc_inp_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => irc_inp_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => irc_inp_shd.g_old_rec.attribute8

Line 196: => irc_inp_shd.g_old_rec.attribute7

192: => irc_inp_shd.g_old_rec.attribute5
193: ,p_attribute6_o
194: => irc_inp_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => irc_inp_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => irc_inp_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => irc_inp_shd.g_old_rec.attribute9

Line 198: => irc_inp_shd.g_old_rec.attribute8

194: => irc_inp_shd.g_old_rec.attribute6
195: ,p_attribute7_o
196: => irc_inp_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => irc_inp_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => irc_inp_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => irc_inp_shd.g_old_rec.attribute10

Line 200: => irc_inp_shd.g_old_rec.attribute9

196: => irc_inp_shd.g_old_rec.attribute7
197: ,p_attribute8_o
198: => irc_inp_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => irc_inp_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => irc_inp_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => irc_inp_shd.g_old_rec.attribute11

Line 202: => irc_inp_shd.g_old_rec.attribute10

198: => irc_inp_shd.g_old_rec.attribute8
199: ,p_attribute9_o
200: => irc_inp_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => irc_inp_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => irc_inp_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => irc_inp_shd.g_old_rec.attribute12

Line 204: => irc_inp_shd.g_old_rec.attribute11

200: => irc_inp_shd.g_old_rec.attribute9
201: ,p_attribute10_o
202: => irc_inp_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => irc_inp_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => irc_inp_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => irc_inp_shd.g_old_rec.attribute13

Line 206: => irc_inp_shd.g_old_rec.attribute12

202: => irc_inp_shd.g_old_rec.attribute10
203: ,p_attribute11_o
204: => irc_inp_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => irc_inp_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => irc_inp_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => irc_inp_shd.g_old_rec.attribute14

Line 208: => irc_inp_shd.g_old_rec.attribute13

204: => irc_inp_shd.g_old_rec.attribute11
205: ,p_attribute12_o
206: => irc_inp_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => irc_inp_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => irc_inp_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => irc_inp_shd.g_old_rec.attribute15

Line 210: => irc_inp_shd.g_old_rec.attribute14

206: => irc_inp_shd.g_old_rec.attribute12
207: ,p_attribute13_o
208: => irc_inp_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => irc_inp_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => irc_inp_shd.g_old_rec.attribute15
213: ,p_attribute16_o
214: => irc_inp_shd.g_old_rec.attribute16

Line 212: => irc_inp_shd.g_old_rec.attribute15

208: => irc_inp_shd.g_old_rec.attribute13
209: ,p_attribute14_o
210: => irc_inp_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => irc_inp_shd.g_old_rec.attribute15
213: ,p_attribute16_o
214: => irc_inp_shd.g_old_rec.attribute16
215: ,p_attribute17_o
216: => irc_inp_shd.g_old_rec.attribute17

Line 214: => irc_inp_shd.g_old_rec.attribute16

210: => irc_inp_shd.g_old_rec.attribute14
211: ,p_attribute15_o
212: => irc_inp_shd.g_old_rec.attribute15
213: ,p_attribute16_o
214: => irc_inp_shd.g_old_rec.attribute16
215: ,p_attribute17_o
216: => irc_inp_shd.g_old_rec.attribute17
217: ,p_attribute18_o
218: => irc_inp_shd.g_old_rec.attribute18

Line 216: => irc_inp_shd.g_old_rec.attribute17

212: => irc_inp_shd.g_old_rec.attribute15
213: ,p_attribute16_o
214: => irc_inp_shd.g_old_rec.attribute16
215: ,p_attribute17_o
216: => irc_inp_shd.g_old_rec.attribute17
217: ,p_attribute18_o
218: => irc_inp_shd.g_old_rec.attribute18
219: ,p_attribute19_o
220: => irc_inp_shd.g_old_rec.attribute19

Line 218: => irc_inp_shd.g_old_rec.attribute18

214: => irc_inp_shd.g_old_rec.attribute16
215: ,p_attribute17_o
216: => irc_inp_shd.g_old_rec.attribute17
217: ,p_attribute18_o
218: => irc_inp_shd.g_old_rec.attribute18
219: ,p_attribute19_o
220: => irc_inp_shd.g_old_rec.attribute19
221: ,p_attribute20_o
222: => irc_inp_shd.g_old_rec.attribute20

Line 220: => irc_inp_shd.g_old_rec.attribute19

216: => irc_inp_shd.g_old_rec.attribute17
217: ,p_attribute18_o
218: => irc_inp_shd.g_old_rec.attribute18
219: ,p_attribute19_o
220: => irc_inp_shd.g_old_rec.attribute19
221: ,p_attribute20_o
222: => irc_inp_shd.g_old_rec.attribute20
223: ,p_attribute21_o
224: => irc_inp_shd.g_old_rec.attribute21

Line 222: => irc_inp_shd.g_old_rec.attribute20

218: => irc_inp_shd.g_old_rec.attribute18
219: ,p_attribute19_o
220: => irc_inp_shd.g_old_rec.attribute19
221: ,p_attribute20_o
222: => irc_inp_shd.g_old_rec.attribute20
223: ,p_attribute21_o
224: => irc_inp_shd.g_old_rec.attribute21
225: ,p_attribute22_o
226: => irc_inp_shd.g_old_rec.attribute22

Line 224: => irc_inp_shd.g_old_rec.attribute21

220: => irc_inp_shd.g_old_rec.attribute19
221: ,p_attribute20_o
222: => irc_inp_shd.g_old_rec.attribute20
223: ,p_attribute21_o
224: => irc_inp_shd.g_old_rec.attribute21
225: ,p_attribute22_o
226: => irc_inp_shd.g_old_rec.attribute22
227: ,p_attribute23_o
228: => irc_inp_shd.g_old_rec.attribute23

Line 226: => irc_inp_shd.g_old_rec.attribute22

222: => irc_inp_shd.g_old_rec.attribute20
223: ,p_attribute21_o
224: => irc_inp_shd.g_old_rec.attribute21
225: ,p_attribute22_o
226: => irc_inp_shd.g_old_rec.attribute22
227: ,p_attribute23_o
228: => irc_inp_shd.g_old_rec.attribute23
229: ,p_attribute24_o
230: => irc_inp_shd.g_old_rec.attribute24

Line 228: => irc_inp_shd.g_old_rec.attribute23

224: => irc_inp_shd.g_old_rec.attribute21
225: ,p_attribute22_o
226: => irc_inp_shd.g_old_rec.attribute22
227: ,p_attribute23_o
228: => irc_inp_shd.g_old_rec.attribute23
229: ,p_attribute24_o
230: => irc_inp_shd.g_old_rec.attribute24
231: ,p_attribute25_o
232: => irc_inp_shd.g_old_rec.attribute25

Line 230: => irc_inp_shd.g_old_rec.attribute24

226: => irc_inp_shd.g_old_rec.attribute22
227: ,p_attribute23_o
228: => irc_inp_shd.g_old_rec.attribute23
229: ,p_attribute24_o
230: => irc_inp_shd.g_old_rec.attribute24
231: ,p_attribute25_o
232: => irc_inp_shd.g_old_rec.attribute25
233: ,p_attribute26_o
234: => irc_inp_shd.g_old_rec.attribute26

Line 232: => irc_inp_shd.g_old_rec.attribute25

228: => irc_inp_shd.g_old_rec.attribute23
229: ,p_attribute24_o
230: => irc_inp_shd.g_old_rec.attribute24
231: ,p_attribute25_o
232: => irc_inp_shd.g_old_rec.attribute25
233: ,p_attribute26_o
234: => irc_inp_shd.g_old_rec.attribute26
235: ,p_attribute27_o
236: => irc_inp_shd.g_old_rec.attribute27

Line 234: => irc_inp_shd.g_old_rec.attribute26

230: => irc_inp_shd.g_old_rec.attribute24
231: ,p_attribute25_o
232: => irc_inp_shd.g_old_rec.attribute25
233: ,p_attribute26_o
234: => irc_inp_shd.g_old_rec.attribute26
235: ,p_attribute27_o
236: => irc_inp_shd.g_old_rec.attribute27
237: ,p_attribute28_o
238: => irc_inp_shd.g_old_rec.attribute28

Line 236: => irc_inp_shd.g_old_rec.attribute27

232: => irc_inp_shd.g_old_rec.attribute25
233: ,p_attribute26_o
234: => irc_inp_shd.g_old_rec.attribute26
235: ,p_attribute27_o
236: => irc_inp_shd.g_old_rec.attribute27
237: ,p_attribute28_o
238: => irc_inp_shd.g_old_rec.attribute28
239: ,p_attribute29_o
240: => irc_inp_shd.g_old_rec.attribute29

Line 238: => irc_inp_shd.g_old_rec.attribute28

234: => irc_inp_shd.g_old_rec.attribute26
235: ,p_attribute27_o
236: => irc_inp_shd.g_old_rec.attribute27
237: ,p_attribute28_o
238: => irc_inp_shd.g_old_rec.attribute28
239: ,p_attribute29_o
240: => irc_inp_shd.g_old_rec.attribute29
241: ,p_attribute30_o
242: => irc_inp_shd.g_old_rec.attribute30

Line 240: => irc_inp_shd.g_old_rec.attribute29

236: => irc_inp_shd.g_old_rec.attribute27
237: ,p_attribute28_o
238: => irc_inp_shd.g_old_rec.attribute28
239: ,p_attribute29_o
240: => irc_inp_shd.g_old_rec.attribute29
241: ,p_attribute30_o
242: => irc_inp_shd.g_old_rec.attribute30
243: ,p_object_version_number_o
244: => irc_inp_shd.g_old_rec.object_version_number

Line 242: => irc_inp_shd.g_old_rec.attribute30

238: => irc_inp_shd.g_old_rec.attribute28
239: ,p_attribute29_o
240: => irc_inp_shd.g_old_rec.attribute29
241: ,p_attribute30_o
242: => irc_inp_shd.g_old_rec.attribute30
243: ,p_object_version_number_o
244: => irc_inp_shd.g_old_rec.object_version_number
245: ,p_agency_id_o
246: => irc_inp_shd.g_old_rec.agency_id

Line 244: => irc_inp_shd.g_old_rec.object_version_number

240: => irc_inp_shd.g_old_rec.attribute29
241: ,p_attribute30_o
242: => irc_inp_shd.g_old_rec.attribute30
243: ,p_object_version_number_o
244: => irc_inp_shd.g_old_rec.object_version_number
245: ,p_agency_id_o
246: => irc_inp_shd.g_old_rec.agency_id
247: ,p_attempt_id_o
248: => irc_inp_shd.g_old_rec.attempt_id

Line 246: => irc_inp_shd.g_old_rec.agency_id

242: => irc_inp_shd.g_old_rec.attribute30
243: ,p_object_version_number_o
244: => irc_inp_shd.g_old_rec.object_version_number
245: ,p_agency_id_o
246: => irc_inp_shd.g_old_rec.agency_id
247: ,p_attempt_id_o
248: => irc_inp_shd.g_old_rec.attempt_id
249: );
250: --

Line 248: => irc_inp_shd.g_old_rec.attempt_id

244: => irc_inp_shd.g_old_rec.object_version_number
245: ,p_agency_id_o
246: => irc_inp_shd.g_old_rec.agency_id
247: ,p_attempt_id_o
248: => irc_inp_shd.g_old_rec.attempt_id
249: );
250: --
251: exception
252: --

Line 268: (p_rec in irc_inp_shd.g_rec_type

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

Line 278: irc_inp_shd.lck

274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- We must lock the row which we need to delete.
277: --
278: irc_inp_shd.lck
279: (p_rec.notification_preference_id
280: ,p_rec.object_version_number
281: );
282: --

Line 319: l_rec irc_inp_shd.g_rec_type;

315: (p_notification_preference_id in number
316: ,p_object_version_number in number
317: ) is
318: --
319: l_rec irc_inp_shd.g_rec_type;
320: l_proc varchar2(72) := g_package||'del';
321: --
322: Begin
323: hr_utility.set_location('Entering:'||l_proc, 5);