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_IPC_DEL dependencies on IRC_IPC_SHD

Line 52: (p_rec in irc_ipc_shd.g_rec_type

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

Line 60: irc_ipc_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_ipc_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the irc_posting_contents row.
63: --
64: delete from irc_posting_contents

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

63: --
64: delete from irc_posting_contents
65: where posting_content_id = p_rec.posting_content_id;
66: --
67: irc_ipc_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_ipc_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_ipc_shd.g_api_dml := false; -- Unset the api dml status
75: --
76: irc_ipc_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then

Line 76: irc_ipc_shd.constraint_error

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

Line 80: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 116: Procedure pre_delete(p_rec in irc_ipc_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_ipc_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_ipc_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_ipc_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'post_delete';
161: --
162: Begin

Line 170: => irc_ipc_shd.g_old_rec.display_manager_info

166: irc_ipc_rkd.after_delete
167: (p_posting_content_id
168: => p_rec.posting_content_id
169: ,p_display_manager_info_o
170: => irc_ipc_shd.g_old_rec.display_manager_info
171: ,p_display_recruiter_info_o
172: => irc_ipc_shd.g_old_rec.display_recruiter_info
173: ,p_attribute_category_o
174: => irc_ipc_shd.g_old_rec.attribute_category

Line 172: => irc_ipc_shd.g_old_rec.display_recruiter_info

168: => p_rec.posting_content_id
169: ,p_display_manager_info_o
170: => irc_ipc_shd.g_old_rec.display_manager_info
171: ,p_display_recruiter_info_o
172: => irc_ipc_shd.g_old_rec.display_recruiter_info
173: ,p_attribute_category_o
174: => irc_ipc_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => irc_ipc_shd.g_old_rec.attribute1

Line 174: => irc_ipc_shd.g_old_rec.attribute_category

170: => irc_ipc_shd.g_old_rec.display_manager_info
171: ,p_display_recruiter_info_o
172: => irc_ipc_shd.g_old_rec.display_recruiter_info
173: ,p_attribute_category_o
174: => irc_ipc_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => irc_ipc_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => irc_ipc_shd.g_old_rec.attribute2

Line 176: => irc_ipc_shd.g_old_rec.attribute1

172: => irc_ipc_shd.g_old_rec.display_recruiter_info
173: ,p_attribute_category_o
174: => irc_ipc_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => irc_ipc_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => irc_ipc_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => irc_ipc_shd.g_old_rec.attribute3

Line 178: => irc_ipc_shd.g_old_rec.attribute2

174: => irc_ipc_shd.g_old_rec.attribute_category
175: ,p_attribute1_o
176: => irc_ipc_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => irc_ipc_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => irc_ipc_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => irc_ipc_shd.g_old_rec.attribute4

Line 180: => irc_ipc_shd.g_old_rec.attribute3

176: => irc_ipc_shd.g_old_rec.attribute1
177: ,p_attribute2_o
178: => irc_ipc_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => irc_ipc_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => irc_ipc_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => irc_ipc_shd.g_old_rec.attribute5

Line 182: => irc_ipc_shd.g_old_rec.attribute4

178: => irc_ipc_shd.g_old_rec.attribute2
179: ,p_attribute3_o
180: => irc_ipc_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => irc_ipc_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => irc_ipc_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => irc_ipc_shd.g_old_rec.attribute6

Line 184: => irc_ipc_shd.g_old_rec.attribute5

180: => irc_ipc_shd.g_old_rec.attribute3
181: ,p_attribute4_o
182: => irc_ipc_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => irc_ipc_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => irc_ipc_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => irc_ipc_shd.g_old_rec.attribute7

Line 186: => irc_ipc_shd.g_old_rec.attribute6

182: => irc_ipc_shd.g_old_rec.attribute4
183: ,p_attribute5_o
184: => irc_ipc_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => irc_ipc_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => irc_ipc_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => irc_ipc_shd.g_old_rec.attribute8

Line 188: => irc_ipc_shd.g_old_rec.attribute7

184: => irc_ipc_shd.g_old_rec.attribute5
185: ,p_attribute6_o
186: => irc_ipc_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => irc_ipc_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => irc_ipc_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => irc_ipc_shd.g_old_rec.attribute9

Line 190: => irc_ipc_shd.g_old_rec.attribute8

186: => irc_ipc_shd.g_old_rec.attribute6
187: ,p_attribute7_o
188: => irc_ipc_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => irc_ipc_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => irc_ipc_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => irc_ipc_shd.g_old_rec.attribute10

Line 192: => irc_ipc_shd.g_old_rec.attribute9

188: => irc_ipc_shd.g_old_rec.attribute7
189: ,p_attribute8_o
190: => irc_ipc_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => irc_ipc_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => irc_ipc_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => irc_ipc_shd.g_old_rec.attribute11

Line 194: => irc_ipc_shd.g_old_rec.attribute10

190: => irc_ipc_shd.g_old_rec.attribute8
191: ,p_attribute9_o
192: => irc_ipc_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => irc_ipc_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => irc_ipc_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => irc_ipc_shd.g_old_rec.attribute12

Line 196: => irc_ipc_shd.g_old_rec.attribute11

192: => irc_ipc_shd.g_old_rec.attribute9
193: ,p_attribute10_o
194: => irc_ipc_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => irc_ipc_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => irc_ipc_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => irc_ipc_shd.g_old_rec.attribute13

Line 198: => irc_ipc_shd.g_old_rec.attribute12

194: => irc_ipc_shd.g_old_rec.attribute10
195: ,p_attribute11_o
196: => irc_ipc_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => irc_ipc_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => irc_ipc_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => irc_ipc_shd.g_old_rec.attribute14

Line 200: => irc_ipc_shd.g_old_rec.attribute13

196: => irc_ipc_shd.g_old_rec.attribute11
197: ,p_attribute12_o
198: => irc_ipc_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => irc_ipc_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => irc_ipc_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => irc_ipc_shd.g_old_rec.attribute15

Line 202: => irc_ipc_shd.g_old_rec.attribute14

198: => irc_ipc_shd.g_old_rec.attribute12
199: ,p_attribute13_o
200: => irc_ipc_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => irc_ipc_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => irc_ipc_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => irc_ipc_shd.g_old_rec.attribute16

Line 204: => irc_ipc_shd.g_old_rec.attribute15

200: => irc_ipc_shd.g_old_rec.attribute13
201: ,p_attribute14_o
202: => irc_ipc_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => irc_ipc_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => irc_ipc_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => irc_ipc_shd.g_old_rec.attribute17

Line 206: => irc_ipc_shd.g_old_rec.attribute16

202: => irc_ipc_shd.g_old_rec.attribute14
203: ,p_attribute15_o
204: => irc_ipc_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => irc_ipc_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => irc_ipc_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => irc_ipc_shd.g_old_rec.attribute18

Line 208: => irc_ipc_shd.g_old_rec.attribute17

204: => irc_ipc_shd.g_old_rec.attribute15
205: ,p_attribute16_o
206: => irc_ipc_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => irc_ipc_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => irc_ipc_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => irc_ipc_shd.g_old_rec.attribute19

Line 210: => irc_ipc_shd.g_old_rec.attribute18

206: => irc_ipc_shd.g_old_rec.attribute16
207: ,p_attribute17_o
208: => irc_ipc_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => irc_ipc_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => irc_ipc_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => irc_ipc_shd.g_old_rec.attribute20

Line 212: => irc_ipc_shd.g_old_rec.attribute19

208: => irc_ipc_shd.g_old_rec.attribute17
209: ,p_attribute18_o
210: => irc_ipc_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => irc_ipc_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => irc_ipc_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => irc_ipc_shd.g_old_rec.attribute21

Line 214: => irc_ipc_shd.g_old_rec.attribute20

210: => irc_ipc_shd.g_old_rec.attribute18
211: ,p_attribute19_o
212: => irc_ipc_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => irc_ipc_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => irc_ipc_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => irc_ipc_shd.g_old_rec.attribute22

Line 216: => irc_ipc_shd.g_old_rec.attribute21

212: => irc_ipc_shd.g_old_rec.attribute19
213: ,p_attribute20_o
214: => irc_ipc_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => irc_ipc_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => irc_ipc_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => irc_ipc_shd.g_old_rec.attribute23

Line 218: => irc_ipc_shd.g_old_rec.attribute22

214: => irc_ipc_shd.g_old_rec.attribute20
215: ,p_attribute21_o
216: => irc_ipc_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => irc_ipc_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => irc_ipc_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => irc_ipc_shd.g_old_rec.attribute24

Line 220: => irc_ipc_shd.g_old_rec.attribute23

216: => irc_ipc_shd.g_old_rec.attribute21
217: ,p_attribute22_o
218: => irc_ipc_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => irc_ipc_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => irc_ipc_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => irc_ipc_shd.g_old_rec.attribute25

Line 222: => irc_ipc_shd.g_old_rec.attribute24

218: => irc_ipc_shd.g_old_rec.attribute22
219: ,p_attribute23_o
220: => irc_ipc_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => irc_ipc_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => irc_ipc_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => irc_ipc_shd.g_old_rec.attribute26

Line 224: => irc_ipc_shd.g_old_rec.attribute25

220: => irc_ipc_shd.g_old_rec.attribute23
221: ,p_attribute24_o
222: => irc_ipc_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => irc_ipc_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => irc_ipc_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => irc_ipc_shd.g_old_rec.attribute27

Line 226: => irc_ipc_shd.g_old_rec.attribute26

222: => irc_ipc_shd.g_old_rec.attribute24
223: ,p_attribute25_o
224: => irc_ipc_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => irc_ipc_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => irc_ipc_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => irc_ipc_shd.g_old_rec.attribute28

Line 228: => irc_ipc_shd.g_old_rec.attribute27

224: => irc_ipc_shd.g_old_rec.attribute25
225: ,p_attribute26_o
226: => irc_ipc_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => irc_ipc_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => irc_ipc_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => irc_ipc_shd.g_old_rec.attribute29

Line 230: => irc_ipc_shd.g_old_rec.attribute28

226: => irc_ipc_shd.g_old_rec.attribute26
227: ,p_attribute27_o
228: => irc_ipc_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => irc_ipc_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => irc_ipc_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => irc_ipc_shd.g_old_rec.attribute30

Line 232: => irc_ipc_shd.g_old_rec.attribute29

228: => irc_ipc_shd.g_old_rec.attribute27
229: ,p_attribute28_o
230: => irc_ipc_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => irc_ipc_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => irc_ipc_shd.g_old_rec.attribute30
235: ,p_ipc_information_category_o
236: => irc_ipc_shd.g_old_rec.ipc_information_category

Line 234: => irc_ipc_shd.g_old_rec.attribute30

230: => irc_ipc_shd.g_old_rec.attribute28
231: ,p_attribute29_o
232: => irc_ipc_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => irc_ipc_shd.g_old_rec.attribute30
235: ,p_ipc_information_category_o
236: => irc_ipc_shd.g_old_rec.ipc_information_category
237: ,p_ipc_information1_o
238: => irc_ipc_shd.g_old_rec.ipc_information1

Line 236: => irc_ipc_shd.g_old_rec.ipc_information_category

232: => irc_ipc_shd.g_old_rec.attribute29
233: ,p_attribute30_o
234: => irc_ipc_shd.g_old_rec.attribute30
235: ,p_ipc_information_category_o
236: => irc_ipc_shd.g_old_rec.ipc_information_category
237: ,p_ipc_information1_o
238: => irc_ipc_shd.g_old_rec.ipc_information1
239: ,p_ipc_information2_o
240: => irc_ipc_shd.g_old_rec.ipc_information2

Line 238: => irc_ipc_shd.g_old_rec.ipc_information1

234: => irc_ipc_shd.g_old_rec.attribute30
235: ,p_ipc_information_category_o
236: => irc_ipc_shd.g_old_rec.ipc_information_category
237: ,p_ipc_information1_o
238: => irc_ipc_shd.g_old_rec.ipc_information1
239: ,p_ipc_information2_o
240: => irc_ipc_shd.g_old_rec.ipc_information2
241: ,p_ipc_information3_o
242: => irc_ipc_shd.g_old_rec.ipc_information3

Line 240: => irc_ipc_shd.g_old_rec.ipc_information2

236: => irc_ipc_shd.g_old_rec.ipc_information_category
237: ,p_ipc_information1_o
238: => irc_ipc_shd.g_old_rec.ipc_information1
239: ,p_ipc_information2_o
240: => irc_ipc_shd.g_old_rec.ipc_information2
241: ,p_ipc_information3_o
242: => irc_ipc_shd.g_old_rec.ipc_information3
243: ,p_ipc_information4_o
244: => irc_ipc_shd.g_old_rec.ipc_information4

Line 242: => irc_ipc_shd.g_old_rec.ipc_information3

238: => irc_ipc_shd.g_old_rec.ipc_information1
239: ,p_ipc_information2_o
240: => irc_ipc_shd.g_old_rec.ipc_information2
241: ,p_ipc_information3_o
242: => irc_ipc_shd.g_old_rec.ipc_information3
243: ,p_ipc_information4_o
244: => irc_ipc_shd.g_old_rec.ipc_information4
245: ,p_ipc_information5_o
246: => irc_ipc_shd.g_old_rec.ipc_information5

Line 244: => irc_ipc_shd.g_old_rec.ipc_information4

240: => irc_ipc_shd.g_old_rec.ipc_information2
241: ,p_ipc_information3_o
242: => irc_ipc_shd.g_old_rec.ipc_information3
243: ,p_ipc_information4_o
244: => irc_ipc_shd.g_old_rec.ipc_information4
245: ,p_ipc_information5_o
246: => irc_ipc_shd.g_old_rec.ipc_information5
247: ,p_ipc_information6_o
248: => irc_ipc_shd.g_old_rec.ipc_information6

Line 246: => irc_ipc_shd.g_old_rec.ipc_information5

242: => irc_ipc_shd.g_old_rec.ipc_information3
243: ,p_ipc_information4_o
244: => irc_ipc_shd.g_old_rec.ipc_information4
245: ,p_ipc_information5_o
246: => irc_ipc_shd.g_old_rec.ipc_information5
247: ,p_ipc_information6_o
248: => irc_ipc_shd.g_old_rec.ipc_information6
249: ,p_ipc_information7_o
250: => irc_ipc_shd.g_old_rec.ipc_information7

Line 248: => irc_ipc_shd.g_old_rec.ipc_information6

244: => irc_ipc_shd.g_old_rec.ipc_information4
245: ,p_ipc_information5_o
246: => irc_ipc_shd.g_old_rec.ipc_information5
247: ,p_ipc_information6_o
248: => irc_ipc_shd.g_old_rec.ipc_information6
249: ,p_ipc_information7_o
250: => irc_ipc_shd.g_old_rec.ipc_information7
251: ,p_ipc_information8_o
252: => irc_ipc_shd.g_old_rec.ipc_information8

Line 250: => irc_ipc_shd.g_old_rec.ipc_information7

246: => irc_ipc_shd.g_old_rec.ipc_information5
247: ,p_ipc_information6_o
248: => irc_ipc_shd.g_old_rec.ipc_information6
249: ,p_ipc_information7_o
250: => irc_ipc_shd.g_old_rec.ipc_information7
251: ,p_ipc_information8_o
252: => irc_ipc_shd.g_old_rec.ipc_information8
253: ,p_ipc_information9_o
254: => irc_ipc_shd.g_old_rec.ipc_information9

Line 252: => irc_ipc_shd.g_old_rec.ipc_information8

248: => irc_ipc_shd.g_old_rec.ipc_information6
249: ,p_ipc_information7_o
250: => irc_ipc_shd.g_old_rec.ipc_information7
251: ,p_ipc_information8_o
252: => irc_ipc_shd.g_old_rec.ipc_information8
253: ,p_ipc_information9_o
254: => irc_ipc_shd.g_old_rec.ipc_information9
255: ,p_ipc_information10_o
256: => irc_ipc_shd.g_old_rec.ipc_information10

Line 254: => irc_ipc_shd.g_old_rec.ipc_information9

250: => irc_ipc_shd.g_old_rec.ipc_information7
251: ,p_ipc_information8_o
252: => irc_ipc_shd.g_old_rec.ipc_information8
253: ,p_ipc_information9_o
254: => irc_ipc_shd.g_old_rec.ipc_information9
255: ,p_ipc_information10_o
256: => irc_ipc_shd.g_old_rec.ipc_information10
257: ,p_ipc_information11_o
258: => irc_ipc_shd.g_old_rec.ipc_information11

Line 256: => irc_ipc_shd.g_old_rec.ipc_information10

252: => irc_ipc_shd.g_old_rec.ipc_information8
253: ,p_ipc_information9_o
254: => irc_ipc_shd.g_old_rec.ipc_information9
255: ,p_ipc_information10_o
256: => irc_ipc_shd.g_old_rec.ipc_information10
257: ,p_ipc_information11_o
258: => irc_ipc_shd.g_old_rec.ipc_information11
259: ,p_ipc_information12_o
260: => irc_ipc_shd.g_old_rec.ipc_information12

Line 258: => irc_ipc_shd.g_old_rec.ipc_information11

254: => irc_ipc_shd.g_old_rec.ipc_information9
255: ,p_ipc_information10_o
256: => irc_ipc_shd.g_old_rec.ipc_information10
257: ,p_ipc_information11_o
258: => irc_ipc_shd.g_old_rec.ipc_information11
259: ,p_ipc_information12_o
260: => irc_ipc_shd.g_old_rec.ipc_information12
261: ,p_ipc_information13_o
262: => irc_ipc_shd.g_old_rec.ipc_information13

Line 260: => irc_ipc_shd.g_old_rec.ipc_information12

256: => irc_ipc_shd.g_old_rec.ipc_information10
257: ,p_ipc_information11_o
258: => irc_ipc_shd.g_old_rec.ipc_information11
259: ,p_ipc_information12_o
260: => irc_ipc_shd.g_old_rec.ipc_information12
261: ,p_ipc_information13_o
262: => irc_ipc_shd.g_old_rec.ipc_information13
263: ,p_ipc_information14_o
264: => irc_ipc_shd.g_old_rec.ipc_information14

Line 262: => irc_ipc_shd.g_old_rec.ipc_information13

258: => irc_ipc_shd.g_old_rec.ipc_information11
259: ,p_ipc_information12_o
260: => irc_ipc_shd.g_old_rec.ipc_information12
261: ,p_ipc_information13_o
262: => irc_ipc_shd.g_old_rec.ipc_information13
263: ,p_ipc_information14_o
264: => irc_ipc_shd.g_old_rec.ipc_information14
265: ,p_ipc_information15_o
266: => irc_ipc_shd.g_old_rec.ipc_information15

Line 264: => irc_ipc_shd.g_old_rec.ipc_information14

260: => irc_ipc_shd.g_old_rec.ipc_information12
261: ,p_ipc_information13_o
262: => irc_ipc_shd.g_old_rec.ipc_information13
263: ,p_ipc_information14_o
264: => irc_ipc_shd.g_old_rec.ipc_information14
265: ,p_ipc_information15_o
266: => irc_ipc_shd.g_old_rec.ipc_information15
267: ,p_ipc_information16_o
268: => irc_ipc_shd.g_old_rec.ipc_information16

Line 266: => irc_ipc_shd.g_old_rec.ipc_information15

262: => irc_ipc_shd.g_old_rec.ipc_information13
263: ,p_ipc_information14_o
264: => irc_ipc_shd.g_old_rec.ipc_information14
265: ,p_ipc_information15_o
266: => irc_ipc_shd.g_old_rec.ipc_information15
267: ,p_ipc_information16_o
268: => irc_ipc_shd.g_old_rec.ipc_information16
269: ,p_ipc_information17_o
270: => irc_ipc_shd.g_old_rec.ipc_information17

Line 268: => irc_ipc_shd.g_old_rec.ipc_information16

264: => irc_ipc_shd.g_old_rec.ipc_information14
265: ,p_ipc_information15_o
266: => irc_ipc_shd.g_old_rec.ipc_information15
267: ,p_ipc_information16_o
268: => irc_ipc_shd.g_old_rec.ipc_information16
269: ,p_ipc_information17_o
270: => irc_ipc_shd.g_old_rec.ipc_information17
271: ,p_ipc_information18_o
272: => irc_ipc_shd.g_old_rec.ipc_information18

Line 270: => irc_ipc_shd.g_old_rec.ipc_information17

266: => irc_ipc_shd.g_old_rec.ipc_information15
267: ,p_ipc_information16_o
268: => irc_ipc_shd.g_old_rec.ipc_information16
269: ,p_ipc_information17_o
270: => irc_ipc_shd.g_old_rec.ipc_information17
271: ,p_ipc_information18_o
272: => irc_ipc_shd.g_old_rec.ipc_information18
273: ,p_ipc_information19_o
274: => irc_ipc_shd.g_old_rec.ipc_information19

Line 272: => irc_ipc_shd.g_old_rec.ipc_information18

268: => irc_ipc_shd.g_old_rec.ipc_information16
269: ,p_ipc_information17_o
270: => irc_ipc_shd.g_old_rec.ipc_information17
271: ,p_ipc_information18_o
272: => irc_ipc_shd.g_old_rec.ipc_information18
273: ,p_ipc_information19_o
274: => irc_ipc_shd.g_old_rec.ipc_information19
275: ,p_ipc_information20_o
276: => irc_ipc_shd.g_old_rec.ipc_information20

Line 274: => irc_ipc_shd.g_old_rec.ipc_information19

270: => irc_ipc_shd.g_old_rec.ipc_information17
271: ,p_ipc_information18_o
272: => irc_ipc_shd.g_old_rec.ipc_information18
273: ,p_ipc_information19_o
274: => irc_ipc_shd.g_old_rec.ipc_information19
275: ,p_ipc_information20_o
276: => irc_ipc_shd.g_old_rec.ipc_information20
277: ,p_ipc_information21_o
278: => irc_ipc_shd.g_old_rec.ipc_information21

Line 276: => irc_ipc_shd.g_old_rec.ipc_information20

272: => irc_ipc_shd.g_old_rec.ipc_information18
273: ,p_ipc_information19_o
274: => irc_ipc_shd.g_old_rec.ipc_information19
275: ,p_ipc_information20_o
276: => irc_ipc_shd.g_old_rec.ipc_information20
277: ,p_ipc_information21_o
278: => irc_ipc_shd.g_old_rec.ipc_information21
279: ,p_ipc_information22_o
280: => irc_ipc_shd.g_old_rec.ipc_information22

Line 278: => irc_ipc_shd.g_old_rec.ipc_information21

274: => irc_ipc_shd.g_old_rec.ipc_information19
275: ,p_ipc_information20_o
276: => irc_ipc_shd.g_old_rec.ipc_information20
277: ,p_ipc_information21_o
278: => irc_ipc_shd.g_old_rec.ipc_information21
279: ,p_ipc_information22_o
280: => irc_ipc_shd.g_old_rec.ipc_information22
281: ,p_ipc_information23_o
282: => irc_ipc_shd.g_old_rec.ipc_information23

Line 280: => irc_ipc_shd.g_old_rec.ipc_information22

276: => irc_ipc_shd.g_old_rec.ipc_information20
277: ,p_ipc_information21_o
278: => irc_ipc_shd.g_old_rec.ipc_information21
279: ,p_ipc_information22_o
280: => irc_ipc_shd.g_old_rec.ipc_information22
281: ,p_ipc_information23_o
282: => irc_ipc_shd.g_old_rec.ipc_information23
283: ,p_ipc_information24_o
284: => irc_ipc_shd.g_old_rec.ipc_information24

Line 282: => irc_ipc_shd.g_old_rec.ipc_information23

278: => irc_ipc_shd.g_old_rec.ipc_information21
279: ,p_ipc_information22_o
280: => irc_ipc_shd.g_old_rec.ipc_information22
281: ,p_ipc_information23_o
282: => irc_ipc_shd.g_old_rec.ipc_information23
283: ,p_ipc_information24_o
284: => irc_ipc_shd.g_old_rec.ipc_information24
285: ,p_ipc_information25_o
286: => irc_ipc_shd.g_old_rec.ipc_information25

Line 284: => irc_ipc_shd.g_old_rec.ipc_information24

280: => irc_ipc_shd.g_old_rec.ipc_information22
281: ,p_ipc_information23_o
282: => irc_ipc_shd.g_old_rec.ipc_information23
283: ,p_ipc_information24_o
284: => irc_ipc_shd.g_old_rec.ipc_information24
285: ,p_ipc_information25_o
286: => irc_ipc_shd.g_old_rec.ipc_information25
287: ,p_ipc_information26_o
288: => irc_ipc_shd.g_old_rec.ipc_information26

Line 286: => irc_ipc_shd.g_old_rec.ipc_information25

282: => irc_ipc_shd.g_old_rec.ipc_information23
283: ,p_ipc_information24_o
284: => irc_ipc_shd.g_old_rec.ipc_information24
285: ,p_ipc_information25_o
286: => irc_ipc_shd.g_old_rec.ipc_information25
287: ,p_ipc_information26_o
288: => irc_ipc_shd.g_old_rec.ipc_information26
289: ,p_ipc_information27_o
290: => irc_ipc_shd.g_old_rec.ipc_information27

Line 288: => irc_ipc_shd.g_old_rec.ipc_information26

284: => irc_ipc_shd.g_old_rec.ipc_information24
285: ,p_ipc_information25_o
286: => irc_ipc_shd.g_old_rec.ipc_information25
287: ,p_ipc_information26_o
288: => irc_ipc_shd.g_old_rec.ipc_information26
289: ,p_ipc_information27_o
290: => irc_ipc_shd.g_old_rec.ipc_information27
291: ,p_ipc_information28_o
292: => irc_ipc_shd.g_old_rec.ipc_information28

Line 290: => irc_ipc_shd.g_old_rec.ipc_information27

286: => irc_ipc_shd.g_old_rec.ipc_information25
287: ,p_ipc_information26_o
288: => irc_ipc_shd.g_old_rec.ipc_information26
289: ,p_ipc_information27_o
290: => irc_ipc_shd.g_old_rec.ipc_information27
291: ,p_ipc_information28_o
292: => irc_ipc_shd.g_old_rec.ipc_information28
293: ,p_ipc_information29_o
294: => irc_ipc_shd.g_old_rec.ipc_information29

Line 292: => irc_ipc_shd.g_old_rec.ipc_information28

288: => irc_ipc_shd.g_old_rec.ipc_information26
289: ,p_ipc_information27_o
290: => irc_ipc_shd.g_old_rec.ipc_information27
291: ,p_ipc_information28_o
292: => irc_ipc_shd.g_old_rec.ipc_information28
293: ,p_ipc_information29_o
294: => irc_ipc_shd.g_old_rec.ipc_information29
295: ,p_ipc_information30_o
296: => irc_ipc_shd.g_old_rec.ipc_information30

Line 294: => irc_ipc_shd.g_old_rec.ipc_information29

290: => irc_ipc_shd.g_old_rec.ipc_information27
291: ,p_ipc_information28_o
292: => irc_ipc_shd.g_old_rec.ipc_information28
293: ,p_ipc_information29_o
294: => irc_ipc_shd.g_old_rec.ipc_information29
295: ,p_ipc_information30_o
296: => irc_ipc_shd.g_old_rec.ipc_information30
297: ,p_object_version_number_o
298: => irc_ipc_shd.g_old_rec.object_version_number

Line 296: => irc_ipc_shd.g_old_rec.ipc_information30

292: => irc_ipc_shd.g_old_rec.ipc_information28
293: ,p_ipc_information29_o
294: => irc_ipc_shd.g_old_rec.ipc_information29
295: ,p_ipc_information30_o
296: => irc_ipc_shd.g_old_rec.ipc_information30
297: ,p_object_version_number_o
298: => irc_ipc_shd.g_old_rec.object_version_number
299: ,p_date_approved_o
300: => irc_ipc_shd.g_old_rec.date_approved

Line 298: => irc_ipc_shd.g_old_rec.object_version_number

294: => irc_ipc_shd.g_old_rec.ipc_information29
295: ,p_ipc_information30_o
296: => irc_ipc_shd.g_old_rec.ipc_information30
297: ,p_object_version_number_o
298: => irc_ipc_shd.g_old_rec.object_version_number
299: ,p_date_approved_o
300: => irc_ipc_shd.g_old_rec.date_approved
301: ,p_recruiter_full_name_o
302: => irc_ipc_shd.g_old_rec.recruiter_full_name

Line 300: => irc_ipc_shd.g_old_rec.date_approved

296: => irc_ipc_shd.g_old_rec.ipc_information30
297: ,p_object_version_number_o
298: => irc_ipc_shd.g_old_rec.object_version_number
299: ,p_date_approved_o
300: => irc_ipc_shd.g_old_rec.date_approved
301: ,p_recruiter_full_name_o
302: => irc_ipc_shd.g_old_rec.recruiter_full_name
303: ,p_recruiter_email_o
304: => irc_ipc_shd.g_old_rec.recruiter_email

Line 302: => irc_ipc_shd.g_old_rec.recruiter_full_name

298: => irc_ipc_shd.g_old_rec.object_version_number
299: ,p_date_approved_o
300: => irc_ipc_shd.g_old_rec.date_approved
301: ,p_recruiter_full_name_o
302: => irc_ipc_shd.g_old_rec.recruiter_full_name
303: ,p_recruiter_email_o
304: => irc_ipc_shd.g_old_rec.recruiter_email
305: ,p_recruiter_work_telephone_o
306: => irc_ipc_shd.g_old_rec.recruiter_work_telephone

Line 304: => irc_ipc_shd.g_old_rec.recruiter_email

300: => irc_ipc_shd.g_old_rec.date_approved
301: ,p_recruiter_full_name_o
302: => irc_ipc_shd.g_old_rec.recruiter_full_name
303: ,p_recruiter_email_o
304: => irc_ipc_shd.g_old_rec.recruiter_email
305: ,p_recruiter_work_telephone_o
306: => irc_ipc_shd.g_old_rec.recruiter_work_telephone
307: ,p_manager_full_name_o
308: => irc_ipc_shd.g_old_rec.manager_full_name

Line 306: => irc_ipc_shd.g_old_rec.recruiter_work_telephone

302: => irc_ipc_shd.g_old_rec.recruiter_full_name
303: ,p_recruiter_email_o
304: => irc_ipc_shd.g_old_rec.recruiter_email
305: ,p_recruiter_work_telephone_o
306: => irc_ipc_shd.g_old_rec.recruiter_work_telephone
307: ,p_manager_full_name_o
308: => irc_ipc_shd.g_old_rec.manager_full_name
309: ,p_manager_email_o
310: => irc_ipc_shd.g_old_rec.manager_email

Line 308: => irc_ipc_shd.g_old_rec.manager_full_name

304: => irc_ipc_shd.g_old_rec.recruiter_email
305: ,p_recruiter_work_telephone_o
306: => irc_ipc_shd.g_old_rec.recruiter_work_telephone
307: ,p_manager_full_name_o
308: => irc_ipc_shd.g_old_rec.manager_full_name
309: ,p_manager_email_o
310: => irc_ipc_shd.g_old_rec.manager_email
311: ,p_manager_work_telephone_o
312: => irc_ipc_shd.g_old_rec.manager_work_telephone

Line 310: => irc_ipc_shd.g_old_rec.manager_email

306: => irc_ipc_shd.g_old_rec.recruiter_work_telephone
307: ,p_manager_full_name_o
308: => irc_ipc_shd.g_old_rec.manager_full_name
309: ,p_manager_email_o
310: => irc_ipc_shd.g_old_rec.manager_email
311: ,p_manager_work_telephone_o
312: => irc_ipc_shd.g_old_rec.manager_work_telephone
313: );
314: --

Line 312: => irc_ipc_shd.g_old_rec.manager_work_telephone

308: => irc_ipc_shd.g_old_rec.manager_full_name
309: ,p_manager_email_o
310: => irc_ipc_shd.g_old_rec.manager_email
311: ,p_manager_work_telephone_o
312: => irc_ipc_shd.g_old_rec.manager_work_telephone
313: );
314: --
315: exception
316: --

Line 332: (p_rec in irc_ipc_shd.g_rec_type

328: -- ----------------------------------------------------------------------------
329: -- |---------------------------------< del >----------------------------------|
330: -- ----------------------------------------------------------------------------
331: Procedure del
332: (p_rec in irc_ipc_shd.g_rec_type
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'del';
336: --

Line 342: irc_ipc_shd.lck

338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: -- We must lock the row which we need to delete.
341: --
342: irc_ipc_shd.lck
343: (p_rec.posting_content_id
344: ,p_rec.object_version_number
345: );
346: --

Line 373: l_rec irc_ipc_shd.g_rec_type;

369: (p_posting_content_id in number
370: ,p_object_version_number in number
371: ) is
372: --
373: l_rec irc_ipc_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'del';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);