APPS.IRC_IPD_DEL dependencies on IRC_IPD_SHD

Line 52: (p_rec in irc_ipd_shd.g_rec_type

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

Line 75: irc_ipd_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: irc_ipd_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

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

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in irc_ipd_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 irc_ipd_shd.g_rec_type) is

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

Line 168: => irc_ipd_shd.g_old_rec.email_address

164: irc_ipd_rkd.after_delete
165: (p_pending_data_id
166: => p_rec.pending_data_id
167: ,p_email_address_o
168: => irc_ipd_shd.g_old_rec.email_address
169: ,p_vacancy_id_o
170: => irc_ipd_shd.g_old_rec.vacancy_id
171: ,p_last_name_o
172: => irc_ipd_shd.g_old_rec.last_name

Line 170: => irc_ipd_shd.g_old_rec.vacancy_id

166: => p_rec.pending_data_id
167: ,p_email_address_o
168: => irc_ipd_shd.g_old_rec.email_address
169: ,p_vacancy_id_o
170: => irc_ipd_shd.g_old_rec.vacancy_id
171: ,p_last_name_o
172: => irc_ipd_shd.g_old_rec.last_name
173: ,p_first_name_o
174: => irc_ipd_shd.g_old_rec.first_name

Line 172: => irc_ipd_shd.g_old_rec.last_name

168: => irc_ipd_shd.g_old_rec.email_address
169: ,p_vacancy_id_o
170: => irc_ipd_shd.g_old_rec.vacancy_id
171: ,p_last_name_o
172: => irc_ipd_shd.g_old_rec.last_name
173: ,p_first_name_o
174: => irc_ipd_shd.g_old_rec.first_name
175: ,p_user_password_o
176: => irc_ipd_shd.g_old_rec.user_password

Line 174: => irc_ipd_shd.g_old_rec.first_name

170: => irc_ipd_shd.g_old_rec.vacancy_id
171: ,p_last_name_o
172: => irc_ipd_shd.g_old_rec.last_name
173: ,p_first_name_o
174: => irc_ipd_shd.g_old_rec.first_name
175: ,p_user_password_o
176: => irc_ipd_shd.g_old_rec.user_password
177: ,p_resume_file_name_o
178: => irc_ipd_shd.g_old_rec.resume_file_name

Line 176: => irc_ipd_shd.g_old_rec.user_password

172: => irc_ipd_shd.g_old_rec.last_name
173: ,p_first_name_o
174: => irc_ipd_shd.g_old_rec.first_name
175: ,p_user_password_o
176: => irc_ipd_shd.g_old_rec.user_password
177: ,p_resume_file_name_o
178: => irc_ipd_shd.g_old_rec.resume_file_name
179: ,p_resume_description_o
180: => irc_ipd_shd.g_old_rec.resume_description

Line 178: => irc_ipd_shd.g_old_rec.resume_file_name

174: => irc_ipd_shd.g_old_rec.first_name
175: ,p_user_password_o
176: => irc_ipd_shd.g_old_rec.user_password
177: ,p_resume_file_name_o
178: => irc_ipd_shd.g_old_rec.resume_file_name
179: ,p_resume_description_o
180: => irc_ipd_shd.g_old_rec.resume_description
181: ,p_resume_mime_type_o
182: => irc_ipd_shd.g_old_rec.resume_mime_type

Line 180: => irc_ipd_shd.g_old_rec.resume_description

176: => irc_ipd_shd.g_old_rec.user_password
177: ,p_resume_file_name_o
178: => irc_ipd_shd.g_old_rec.resume_file_name
179: ,p_resume_description_o
180: => irc_ipd_shd.g_old_rec.resume_description
181: ,p_resume_mime_type_o
182: => irc_ipd_shd.g_old_rec.resume_mime_type
183: ,p_source_type_o
184: => irc_ipd_shd.g_old_rec.source_type

Line 182: => irc_ipd_shd.g_old_rec.resume_mime_type

178: => irc_ipd_shd.g_old_rec.resume_file_name
179: ,p_resume_description_o
180: => irc_ipd_shd.g_old_rec.resume_description
181: ,p_resume_mime_type_o
182: => irc_ipd_shd.g_old_rec.resume_mime_type
183: ,p_source_type_o
184: => irc_ipd_shd.g_old_rec.source_type
185: ,p_job_post_source_name_o
186: => irc_ipd_shd.g_old_rec.job_post_source_name

Line 184: => irc_ipd_shd.g_old_rec.source_type

180: => irc_ipd_shd.g_old_rec.resume_description
181: ,p_resume_mime_type_o
182: => irc_ipd_shd.g_old_rec.resume_mime_type
183: ,p_source_type_o
184: => irc_ipd_shd.g_old_rec.source_type
185: ,p_job_post_source_name_o
186: => irc_ipd_shd.g_old_rec.job_post_source_name
187: ,p_posting_content_id_o
188: => irc_ipd_shd.g_old_rec.posting_content_id

Line 186: => irc_ipd_shd.g_old_rec.job_post_source_name

182: => irc_ipd_shd.g_old_rec.resume_mime_type
183: ,p_source_type_o
184: => irc_ipd_shd.g_old_rec.source_type
185: ,p_job_post_source_name_o
186: => irc_ipd_shd.g_old_rec.job_post_source_name
187: ,p_posting_content_id_o
188: => irc_ipd_shd.g_old_rec.posting_content_id
189: ,p_person_id_o
190: => irc_ipd_shd.g_old_rec.person_id

Line 188: => irc_ipd_shd.g_old_rec.posting_content_id

184: => irc_ipd_shd.g_old_rec.source_type
185: ,p_job_post_source_name_o
186: => irc_ipd_shd.g_old_rec.job_post_source_name
187: ,p_posting_content_id_o
188: => irc_ipd_shd.g_old_rec.posting_content_id
189: ,p_person_id_o
190: => irc_ipd_shd.g_old_rec.person_id
191: ,p_processed_o
192: => irc_ipd_shd.g_old_rec.processed

Line 190: => irc_ipd_shd.g_old_rec.person_id

186: => irc_ipd_shd.g_old_rec.job_post_source_name
187: ,p_posting_content_id_o
188: => irc_ipd_shd.g_old_rec.posting_content_id
189: ,p_person_id_o
190: => irc_ipd_shd.g_old_rec.person_id
191: ,p_processed_o
192: => irc_ipd_shd.g_old_rec.processed
193: ,p_sex_o
194: => irc_ipd_shd.g_old_rec.sex

Line 192: => irc_ipd_shd.g_old_rec.processed

188: => irc_ipd_shd.g_old_rec.posting_content_id
189: ,p_person_id_o
190: => irc_ipd_shd.g_old_rec.person_id
191: ,p_processed_o
192: => irc_ipd_shd.g_old_rec.processed
193: ,p_sex_o
194: => irc_ipd_shd.g_old_rec.sex
195: ,p_date_of_birth_o
196: => irc_ipd_shd.g_old_rec.date_of_birth

Line 194: => irc_ipd_shd.g_old_rec.sex

190: => irc_ipd_shd.g_old_rec.person_id
191: ,p_processed_o
192: => irc_ipd_shd.g_old_rec.processed
193: ,p_sex_o
194: => irc_ipd_shd.g_old_rec.sex
195: ,p_date_of_birth_o
196: => irc_ipd_shd.g_old_rec.date_of_birth
197: ,p_per_information_category_o
198: => irc_ipd_shd.g_old_rec.per_information_category

Line 196: => irc_ipd_shd.g_old_rec.date_of_birth

192: => irc_ipd_shd.g_old_rec.processed
193: ,p_sex_o
194: => irc_ipd_shd.g_old_rec.sex
195: ,p_date_of_birth_o
196: => irc_ipd_shd.g_old_rec.date_of_birth
197: ,p_per_information_category_o
198: => irc_ipd_shd.g_old_rec.per_information_category
199: ,p_per_information1_o
200: => irc_ipd_shd.g_old_rec.per_information1

Line 198: => irc_ipd_shd.g_old_rec.per_information_category

194: => irc_ipd_shd.g_old_rec.sex
195: ,p_date_of_birth_o
196: => irc_ipd_shd.g_old_rec.date_of_birth
197: ,p_per_information_category_o
198: => irc_ipd_shd.g_old_rec.per_information_category
199: ,p_per_information1_o
200: => irc_ipd_shd.g_old_rec.per_information1
201: ,p_per_information2_o
202: => irc_ipd_shd.g_old_rec.per_information2

Line 200: => irc_ipd_shd.g_old_rec.per_information1

196: => irc_ipd_shd.g_old_rec.date_of_birth
197: ,p_per_information_category_o
198: => irc_ipd_shd.g_old_rec.per_information_category
199: ,p_per_information1_o
200: => irc_ipd_shd.g_old_rec.per_information1
201: ,p_per_information2_o
202: => irc_ipd_shd.g_old_rec.per_information2
203: ,p_per_information3_o
204: => irc_ipd_shd.g_old_rec.per_information3

Line 202: => irc_ipd_shd.g_old_rec.per_information2

198: => irc_ipd_shd.g_old_rec.per_information_category
199: ,p_per_information1_o
200: => irc_ipd_shd.g_old_rec.per_information1
201: ,p_per_information2_o
202: => irc_ipd_shd.g_old_rec.per_information2
203: ,p_per_information3_o
204: => irc_ipd_shd.g_old_rec.per_information3
205: ,p_per_information4_o
206: => irc_ipd_shd.g_old_rec.per_information4

Line 204: => irc_ipd_shd.g_old_rec.per_information3

200: => irc_ipd_shd.g_old_rec.per_information1
201: ,p_per_information2_o
202: => irc_ipd_shd.g_old_rec.per_information2
203: ,p_per_information3_o
204: => irc_ipd_shd.g_old_rec.per_information3
205: ,p_per_information4_o
206: => irc_ipd_shd.g_old_rec.per_information4
207: ,p_per_information5_o
208: => irc_ipd_shd.g_old_rec.per_information5

Line 206: => irc_ipd_shd.g_old_rec.per_information4

202: => irc_ipd_shd.g_old_rec.per_information2
203: ,p_per_information3_o
204: => irc_ipd_shd.g_old_rec.per_information3
205: ,p_per_information4_o
206: => irc_ipd_shd.g_old_rec.per_information4
207: ,p_per_information5_o
208: => irc_ipd_shd.g_old_rec.per_information5
209: ,p_per_information6_o
210: => irc_ipd_shd.g_old_rec.per_information6

Line 208: => irc_ipd_shd.g_old_rec.per_information5

204: => irc_ipd_shd.g_old_rec.per_information3
205: ,p_per_information4_o
206: => irc_ipd_shd.g_old_rec.per_information4
207: ,p_per_information5_o
208: => irc_ipd_shd.g_old_rec.per_information5
209: ,p_per_information6_o
210: => irc_ipd_shd.g_old_rec.per_information6
211: ,p_per_information7_o
212: => irc_ipd_shd.g_old_rec.per_information7

Line 210: => irc_ipd_shd.g_old_rec.per_information6

206: => irc_ipd_shd.g_old_rec.per_information4
207: ,p_per_information5_o
208: => irc_ipd_shd.g_old_rec.per_information5
209: ,p_per_information6_o
210: => irc_ipd_shd.g_old_rec.per_information6
211: ,p_per_information7_o
212: => irc_ipd_shd.g_old_rec.per_information7
213: ,p_per_information8_o
214: => irc_ipd_shd.g_old_rec.per_information8

Line 212: => irc_ipd_shd.g_old_rec.per_information7

208: => irc_ipd_shd.g_old_rec.per_information5
209: ,p_per_information6_o
210: => irc_ipd_shd.g_old_rec.per_information6
211: ,p_per_information7_o
212: => irc_ipd_shd.g_old_rec.per_information7
213: ,p_per_information8_o
214: => irc_ipd_shd.g_old_rec.per_information8
215: ,p_per_information9_o
216: => irc_ipd_shd.g_old_rec.per_information9

Line 214: => irc_ipd_shd.g_old_rec.per_information8

210: => irc_ipd_shd.g_old_rec.per_information6
211: ,p_per_information7_o
212: => irc_ipd_shd.g_old_rec.per_information7
213: ,p_per_information8_o
214: => irc_ipd_shd.g_old_rec.per_information8
215: ,p_per_information9_o
216: => irc_ipd_shd.g_old_rec.per_information9
217: ,p_per_information10_o
218: => irc_ipd_shd.g_old_rec.per_information10

Line 216: => irc_ipd_shd.g_old_rec.per_information9

212: => irc_ipd_shd.g_old_rec.per_information7
213: ,p_per_information8_o
214: => irc_ipd_shd.g_old_rec.per_information8
215: ,p_per_information9_o
216: => irc_ipd_shd.g_old_rec.per_information9
217: ,p_per_information10_o
218: => irc_ipd_shd.g_old_rec.per_information10
219: ,p_per_information11_o
220: => irc_ipd_shd.g_old_rec.per_information11

Line 218: => irc_ipd_shd.g_old_rec.per_information10

214: => irc_ipd_shd.g_old_rec.per_information8
215: ,p_per_information9_o
216: => irc_ipd_shd.g_old_rec.per_information9
217: ,p_per_information10_o
218: => irc_ipd_shd.g_old_rec.per_information10
219: ,p_per_information11_o
220: => irc_ipd_shd.g_old_rec.per_information11
221: ,p_per_information12_o
222: => irc_ipd_shd.g_old_rec.per_information12

Line 220: => irc_ipd_shd.g_old_rec.per_information11

216: => irc_ipd_shd.g_old_rec.per_information9
217: ,p_per_information10_o
218: => irc_ipd_shd.g_old_rec.per_information10
219: ,p_per_information11_o
220: => irc_ipd_shd.g_old_rec.per_information11
221: ,p_per_information12_o
222: => irc_ipd_shd.g_old_rec.per_information12
223: ,p_per_information13_o
224: => irc_ipd_shd.g_old_rec.per_information13

Line 222: => irc_ipd_shd.g_old_rec.per_information12

218: => irc_ipd_shd.g_old_rec.per_information10
219: ,p_per_information11_o
220: => irc_ipd_shd.g_old_rec.per_information11
221: ,p_per_information12_o
222: => irc_ipd_shd.g_old_rec.per_information12
223: ,p_per_information13_o
224: => irc_ipd_shd.g_old_rec.per_information13
225: ,p_per_information14_o
226: => irc_ipd_shd.g_old_rec.per_information14

Line 224: => irc_ipd_shd.g_old_rec.per_information13

220: => irc_ipd_shd.g_old_rec.per_information11
221: ,p_per_information12_o
222: => irc_ipd_shd.g_old_rec.per_information12
223: ,p_per_information13_o
224: => irc_ipd_shd.g_old_rec.per_information13
225: ,p_per_information14_o
226: => irc_ipd_shd.g_old_rec.per_information14
227: ,p_per_information15_o
228: => irc_ipd_shd.g_old_rec.per_information15

Line 226: => irc_ipd_shd.g_old_rec.per_information14

222: => irc_ipd_shd.g_old_rec.per_information12
223: ,p_per_information13_o
224: => irc_ipd_shd.g_old_rec.per_information13
225: ,p_per_information14_o
226: => irc_ipd_shd.g_old_rec.per_information14
227: ,p_per_information15_o
228: => irc_ipd_shd.g_old_rec.per_information15
229: ,p_per_information16_o
230: => irc_ipd_shd.g_old_rec.per_information16

Line 228: => irc_ipd_shd.g_old_rec.per_information15

224: => irc_ipd_shd.g_old_rec.per_information13
225: ,p_per_information14_o
226: => irc_ipd_shd.g_old_rec.per_information14
227: ,p_per_information15_o
228: => irc_ipd_shd.g_old_rec.per_information15
229: ,p_per_information16_o
230: => irc_ipd_shd.g_old_rec.per_information16
231: ,p_per_information17_o
232: => irc_ipd_shd.g_old_rec.per_information17

Line 230: => irc_ipd_shd.g_old_rec.per_information16

226: => irc_ipd_shd.g_old_rec.per_information14
227: ,p_per_information15_o
228: => irc_ipd_shd.g_old_rec.per_information15
229: ,p_per_information16_o
230: => irc_ipd_shd.g_old_rec.per_information16
231: ,p_per_information17_o
232: => irc_ipd_shd.g_old_rec.per_information17
233: ,p_per_information18_o
234: => irc_ipd_shd.g_old_rec.per_information18

Line 232: => irc_ipd_shd.g_old_rec.per_information17

228: => irc_ipd_shd.g_old_rec.per_information15
229: ,p_per_information16_o
230: => irc_ipd_shd.g_old_rec.per_information16
231: ,p_per_information17_o
232: => irc_ipd_shd.g_old_rec.per_information17
233: ,p_per_information18_o
234: => irc_ipd_shd.g_old_rec.per_information18
235: ,p_per_information19_o
236: => irc_ipd_shd.g_old_rec.per_information19

Line 234: => irc_ipd_shd.g_old_rec.per_information18

230: => irc_ipd_shd.g_old_rec.per_information16
231: ,p_per_information17_o
232: => irc_ipd_shd.g_old_rec.per_information17
233: ,p_per_information18_o
234: => irc_ipd_shd.g_old_rec.per_information18
235: ,p_per_information19_o
236: => irc_ipd_shd.g_old_rec.per_information19
237: ,p_per_information20_o
238: => irc_ipd_shd.g_old_rec.per_information20

Line 236: => irc_ipd_shd.g_old_rec.per_information19

232: => irc_ipd_shd.g_old_rec.per_information17
233: ,p_per_information18_o
234: => irc_ipd_shd.g_old_rec.per_information18
235: ,p_per_information19_o
236: => irc_ipd_shd.g_old_rec.per_information19
237: ,p_per_information20_o
238: => irc_ipd_shd.g_old_rec.per_information20
239: ,p_per_information21_o
240: => irc_ipd_shd.g_old_rec.per_information21

Line 238: => irc_ipd_shd.g_old_rec.per_information20

234: => irc_ipd_shd.g_old_rec.per_information18
235: ,p_per_information19_o
236: => irc_ipd_shd.g_old_rec.per_information19
237: ,p_per_information20_o
238: => irc_ipd_shd.g_old_rec.per_information20
239: ,p_per_information21_o
240: => irc_ipd_shd.g_old_rec.per_information21
241: ,p_per_information22_o
242: => irc_ipd_shd.g_old_rec.per_information22

Line 240: => irc_ipd_shd.g_old_rec.per_information21

236: => irc_ipd_shd.g_old_rec.per_information19
237: ,p_per_information20_o
238: => irc_ipd_shd.g_old_rec.per_information20
239: ,p_per_information21_o
240: => irc_ipd_shd.g_old_rec.per_information21
241: ,p_per_information22_o
242: => irc_ipd_shd.g_old_rec.per_information22
243: ,p_per_information23_o
244: => irc_ipd_shd.g_old_rec.per_information23

Line 242: => irc_ipd_shd.g_old_rec.per_information22

238: => irc_ipd_shd.g_old_rec.per_information20
239: ,p_per_information21_o
240: => irc_ipd_shd.g_old_rec.per_information21
241: ,p_per_information22_o
242: => irc_ipd_shd.g_old_rec.per_information22
243: ,p_per_information23_o
244: => irc_ipd_shd.g_old_rec.per_information23
245: ,p_per_information24_o
246: => irc_ipd_shd.g_old_rec.per_information24

Line 244: => irc_ipd_shd.g_old_rec.per_information23

240: => irc_ipd_shd.g_old_rec.per_information21
241: ,p_per_information22_o
242: => irc_ipd_shd.g_old_rec.per_information22
243: ,p_per_information23_o
244: => irc_ipd_shd.g_old_rec.per_information23
245: ,p_per_information24_o
246: => irc_ipd_shd.g_old_rec.per_information24
247: ,p_per_information25_o
248: => irc_ipd_shd.g_old_rec.per_information25

Line 246: => irc_ipd_shd.g_old_rec.per_information24

242: => irc_ipd_shd.g_old_rec.per_information22
243: ,p_per_information23_o
244: => irc_ipd_shd.g_old_rec.per_information23
245: ,p_per_information24_o
246: => irc_ipd_shd.g_old_rec.per_information24
247: ,p_per_information25_o
248: => irc_ipd_shd.g_old_rec.per_information25
249: ,p_per_information26_o
250: => irc_ipd_shd.g_old_rec.per_information26

Line 248: => irc_ipd_shd.g_old_rec.per_information25

244: => irc_ipd_shd.g_old_rec.per_information23
245: ,p_per_information24_o
246: => irc_ipd_shd.g_old_rec.per_information24
247: ,p_per_information25_o
248: => irc_ipd_shd.g_old_rec.per_information25
249: ,p_per_information26_o
250: => irc_ipd_shd.g_old_rec.per_information26
251: ,p_per_information27_o
252: => irc_ipd_shd.g_old_rec.per_information27

Line 250: => irc_ipd_shd.g_old_rec.per_information26

246: => irc_ipd_shd.g_old_rec.per_information24
247: ,p_per_information25_o
248: => irc_ipd_shd.g_old_rec.per_information25
249: ,p_per_information26_o
250: => irc_ipd_shd.g_old_rec.per_information26
251: ,p_per_information27_o
252: => irc_ipd_shd.g_old_rec.per_information27
253: ,p_per_information28_o
254: => irc_ipd_shd.g_old_rec.per_information28

Line 252: => irc_ipd_shd.g_old_rec.per_information27

248: => irc_ipd_shd.g_old_rec.per_information25
249: ,p_per_information26_o
250: => irc_ipd_shd.g_old_rec.per_information26
251: ,p_per_information27_o
252: => irc_ipd_shd.g_old_rec.per_information27
253: ,p_per_information28_o
254: => irc_ipd_shd.g_old_rec.per_information28
255: ,p_per_information29_o
256: => irc_ipd_shd.g_old_rec.per_information29

Line 254: => irc_ipd_shd.g_old_rec.per_information28

250: => irc_ipd_shd.g_old_rec.per_information26
251: ,p_per_information27_o
252: => irc_ipd_shd.g_old_rec.per_information27
253: ,p_per_information28_o
254: => irc_ipd_shd.g_old_rec.per_information28
255: ,p_per_information29_o
256: => irc_ipd_shd.g_old_rec.per_information29
257: ,p_per_information30_o
258: => irc_ipd_shd.g_old_rec.per_information30

Line 256: => irc_ipd_shd.g_old_rec.per_information29

252: => irc_ipd_shd.g_old_rec.per_information27
253: ,p_per_information28_o
254: => irc_ipd_shd.g_old_rec.per_information28
255: ,p_per_information29_o
256: => irc_ipd_shd.g_old_rec.per_information29
257: ,p_per_information30_o
258: => irc_ipd_shd.g_old_rec.per_information30
259: ,p_error_message_o
260: => irc_ipd_shd.g_old_rec.error_message

Line 258: => irc_ipd_shd.g_old_rec.per_information30

254: => irc_ipd_shd.g_old_rec.per_information28
255: ,p_per_information29_o
256: => irc_ipd_shd.g_old_rec.per_information29
257: ,p_per_information30_o
258: => irc_ipd_shd.g_old_rec.per_information30
259: ,p_error_message_o
260: => irc_ipd_shd.g_old_rec.error_message
261: ,p_creation_date_o
262: => irc_ipd_shd.g_old_rec.creation_date

Line 260: => irc_ipd_shd.g_old_rec.error_message

256: => irc_ipd_shd.g_old_rec.per_information29
257: ,p_per_information30_o
258: => irc_ipd_shd.g_old_rec.per_information30
259: ,p_error_message_o
260: => irc_ipd_shd.g_old_rec.error_message
261: ,p_creation_date_o
262: => irc_ipd_shd.g_old_rec.creation_date
263: ,p_last_update_date_o
264: => irc_ipd_shd.g_old_rec.last_update_date

Line 262: => irc_ipd_shd.g_old_rec.creation_date

258: => irc_ipd_shd.g_old_rec.per_information30
259: ,p_error_message_o
260: => irc_ipd_shd.g_old_rec.error_message
261: ,p_creation_date_o
262: => irc_ipd_shd.g_old_rec.creation_date
263: ,p_last_update_date_o
264: => irc_ipd_shd.g_old_rec.last_update_date
265: ,p_allow_access_o
266: => irc_ipd_shd.g_old_rec.allow_access

Line 264: => irc_ipd_shd.g_old_rec.last_update_date

260: => irc_ipd_shd.g_old_rec.error_message
261: ,p_creation_date_o
262: => irc_ipd_shd.g_old_rec.creation_date
263: ,p_last_update_date_o
264: => irc_ipd_shd.g_old_rec.last_update_date
265: ,p_allow_access_o
266: => irc_ipd_shd.g_old_rec.allow_access
267: ,p_visitor_resp_key_o
268: => irc_ipd_shd.g_old_rec.visitor_resp_key

Line 266: => irc_ipd_shd.g_old_rec.allow_access

262: => irc_ipd_shd.g_old_rec.creation_date
263: ,p_last_update_date_o
264: => irc_ipd_shd.g_old_rec.last_update_date
265: ,p_allow_access_o
266: => irc_ipd_shd.g_old_rec.allow_access
267: ,p_visitor_resp_key_o
268: => irc_ipd_shd.g_old_rec.visitor_resp_key
269: ,p_visitor_resp_appl_id_o
270: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id

Line 268: => irc_ipd_shd.g_old_rec.visitor_resp_key

264: => irc_ipd_shd.g_old_rec.last_update_date
265: ,p_allow_access_o
266: => irc_ipd_shd.g_old_rec.allow_access
267: ,p_visitor_resp_key_o
268: => irc_ipd_shd.g_old_rec.visitor_resp_key
269: ,p_visitor_resp_appl_id_o
270: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
271: ,p_security_group_key_o
272: => irc_ipd_shd.g_old_rec.security_group_key

Line 270: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id

266: => irc_ipd_shd.g_old_rec.allow_access
267: ,p_visitor_resp_key_o
268: => irc_ipd_shd.g_old_rec.visitor_resp_key
269: ,p_visitor_resp_appl_id_o
270: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
271: ,p_security_group_key_o
272: => irc_ipd_shd.g_old_rec.security_group_key
273: );
274: --

Line 272: => irc_ipd_shd.g_old_rec.security_group_key

268: => irc_ipd_shd.g_old_rec.visitor_resp_key
269: ,p_visitor_resp_appl_id_o
270: => irc_ipd_shd.g_old_rec.visitor_resp_appl_id
271: ,p_security_group_key_o
272: => irc_ipd_shd.g_old_rec.security_group_key
273: );
274: --
275: exception
276: --

Line 292: (p_rec in irc_ipd_shd.g_rec_type

288: -- ----------------------------------------------------------------------------
289: -- |---------------------------------< del >----------------------------------|
290: -- ----------------------------------------------------------------------------
291: Procedure del
292: (p_rec in irc_ipd_shd.g_rec_type
293: ) is
294: --
295: l_proc varchar2(72) := g_package||'del';
296: --

Line 302: irc_ipd_shd.lck

298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- We must lock the row which we need to delete.
301: --
302: irc_ipd_shd.lck
303: (p_rec.pending_data_id
304: );
305: --
306: -- Call the supporting delete validate operation

Line 337: l_rec irc_ipd_shd.g_rec_type;

333: Procedure del
334: (p_pending_data_id in number
335: ) is
336: --
337: l_rec irc_ipd_shd.g_rec_type;
338: l_proc varchar2(72) := g_package||'del';
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc, 5);