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_UPD dependencies on IRC_INP_SHD

Line 55: (p_rec in out nocopy irc_inp_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_inp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

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

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: irc_inp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the irc_notification_preferences Row
69: --
70: update irc_notification_preferences

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

111: ,agency_id = p_rec.agency_id
112: ,attempt_id = p_rec.attempt_id
113: where notification_preference_id = p_rec.notification_preference_id;
114: --
115: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: Exception

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

118: --
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: irc_inp_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then

Line 124: irc_inp_shd.constraint_error

120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: irc_inp_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: irc_inp_shd.g_api_dml := false; -- Unset the api dml status

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

124: irc_inp_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: irc_inp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then

Line 130: irc_inp_shd.constraint_error

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: irc_inp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: irc_inp_shd.g_api_dml := false; -- Unset the api dml status

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

130: irc_inp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: irc_inp_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then

Line 136: irc_inp_shd.constraint_error

132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: irc_inp_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
140: --

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

135: --
136: irc_inp_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
140: --
141: Raise;
142: End update_dml;
143: --

Line 177: (p_rec in irc_inp_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update
177: (p_rec in irc_inp_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --

Line 222: ,p_rec in irc_inp_shd.g_rec_type

218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure post_update
221: (p_effective_date in date
222: ,p_rec in irc_inp_shd.g_rec_type
223: ) is
224: --
225: l_proc varchar2(72) := g_package||'post_update';
226: --

Line 316: => irc_inp_shd.g_old_rec.matching_jobs

312: => p_rec.agency_id
313: ,p_attempt_id
314: => p_rec.attempt_id
315: ,p_matching_jobs_o
316: => irc_inp_shd.g_old_rec.matching_jobs
317: ,p_matching_job_freq_o
318: => irc_inp_shd.g_old_rec.matching_job_freq
319: ,p_attribute_category_o
320: => irc_inp_shd.g_old_rec.attribute_category

Line 318: => irc_inp_shd.g_old_rec.matching_job_freq

314: => p_rec.attempt_id
315: ,p_matching_jobs_o
316: => irc_inp_shd.g_old_rec.matching_jobs
317: ,p_matching_job_freq_o
318: => irc_inp_shd.g_old_rec.matching_job_freq
319: ,p_attribute_category_o
320: => irc_inp_shd.g_old_rec.attribute_category
321: ,p_receive_info_mail_o
322: => irc_inp_shd.g_old_rec.receive_info_mail

Line 320: => irc_inp_shd.g_old_rec.attribute_category

316: => irc_inp_shd.g_old_rec.matching_jobs
317: ,p_matching_job_freq_o
318: => irc_inp_shd.g_old_rec.matching_job_freq
319: ,p_attribute_category_o
320: => irc_inp_shd.g_old_rec.attribute_category
321: ,p_receive_info_mail_o
322: => irc_inp_shd.g_old_rec.receive_info_mail
323: ,p_allow_access_o
324: => irc_inp_shd.g_old_rec.allow_access

Line 322: => irc_inp_shd.g_old_rec.receive_info_mail

318: => irc_inp_shd.g_old_rec.matching_job_freq
319: ,p_attribute_category_o
320: => irc_inp_shd.g_old_rec.attribute_category
321: ,p_receive_info_mail_o
322: => irc_inp_shd.g_old_rec.receive_info_mail
323: ,p_allow_access_o
324: => irc_inp_shd.g_old_rec.allow_access
325: ,p_address_id_o
326: => irc_inp_shd.g_old_rec.address_id

Line 324: => irc_inp_shd.g_old_rec.allow_access

320: => irc_inp_shd.g_old_rec.attribute_category
321: ,p_receive_info_mail_o
322: => irc_inp_shd.g_old_rec.receive_info_mail
323: ,p_allow_access_o
324: => irc_inp_shd.g_old_rec.allow_access
325: ,p_address_id_o
326: => irc_inp_shd.g_old_rec.address_id
327: ,p_attribute1_o
328: => irc_inp_shd.g_old_rec.attribute1

Line 326: => irc_inp_shd.g_old_rec.address_id

322: => irc_inp_shd.g_old_rec.receive_info_mail
323: ,p_allow_access_o
324: => irc_inp_shd.g_old_rec.allow_access
325: ,p_address_id_o
326: => irc_inp_shd.g_old_rec.address_id
327: ,p_attribute1_o
328: => irc_inp_shd.g_old_rec.attribute1
329: ,p_attribute2_o
330: => irc_inp_shd.g_old_rec.attribute2

Line 328: => irc_inp_shd.g_old_rec.attribute1

324: => irc_inp_shd.g_old_rec.allow_access
325: ,p_address_id_o
326: => irc_inp_shd.g_old_rec.address_id
327: ,p_attribute1_o
328: => irc_inp_shd.g_old_rec.attribute1
329: ,p_attribute2_o
330: => irc_inp_shd.g_old_rec.attribute2
331: ,p_attribute3_o
332: => irc_inp_shd.g_old_rec.attribute3

Line 330: => irc_inp_shd.g_old_rec.attribute2

326: => irc_inp_shd.g_old_rec.address_id
327: ,p_attribute1_o
328: => irc_inp_shd.g_old_rec.attribute1
329: ,p_attribute2_o
330: => irc_inp_shd.g_old_rec.attribute2
331: ,p_attribute3_o
332: => irc_inp_shd.g_old_rec.attribute3
333: ,p_attribute4_o
334: => irc_inp_shd.g_old_rec.attribute4

Line 332: => irc_inp_shd.g_old_rec.attribute3

328: => irc_inp_shd.g_old_rec.attribute1
329: ,p_attribute2_o
330: => irc_inp_shd.g_old_rec.attribute2
331: ,p_attribute3_o
332: => irc_inp_shd.g_old_rec.attribute3
333: ,p_attribute4_o
334: => irc_inp_shd.g_old_rec.attribute4
335: ,p_attribute5_o
336: => irc_inp_shd.g_old_rec.attribute5

Line 334: => irc_inp_shd.g_old_rec.attribute4

330: => irc_inp_shd.g_old_rec.attribute2
331: ,p_attribute3_o
332: => irc_inp_shd.g_old_rec.attribute3
333: ,p_attribute4_o
334: => irc_inp_shd.g_old_rec.attribute4
335: ,p_attribute5_o
336: => irc_inp_shd.g_old_rec.attribute5
337: ,p_attribute6_o
338: => irc_inp_shd.g_old_rec.attribute6

Line 336: => irc_inp_shd.g_old_rec.attribute5

332: => irc_inp_shd.g_old_rec.attribute3
333: ,p_attribute4_o
334: => irc_inp_shd.g_old_rec.attribute4
335: ,p_attribute5_o
336: => irc_inp_shd.g_old_rec.attribute5
337: ,p_attribute6_o
338: => irc_inp_shd.g_old_rec.attribute6
339: ,p_attribute7_o
340: => irc_inp_shd.g_old_rec.attribute7

Line 338: => irc_inp_shd.g_old_rec.attribute6

334: => irc_inp_shd.g_old_rec.attribute4
335: ,p_attribute5_o
336: => irc_inp_shd.g_old_rec.attribute5
337: ,p_attribute6_o
338: => irc_inp_shd.g_old_rec.attribute6
339: ,p_attribute7_o
340: => irc_inp_shd.g_old_rec.attribute7
341: ,p_attribute8_o
342: => irc_inp_shd.g_old_rec.attribute8

Line 340: => irc_inp_shd.g_old_rec.attribute7

336: => irc_inp_shd.g_old_rec.attribute5
337: ,p_attribute6_o
338: => irc_inp_shd.g_old_rec.attribute6
339: ,p_attribute7_o
340: => irc_inp_shd.g_old_rec.attribute7
341: ,p_attribute8_o
342: => irc_inp_shd.g_old_rec.attribute8
343: ,p_attribute9_o
344: => irc_inp_shd.g_old_rec.attribute9

Line 342: => irc_inp_shd.g_old_rec.attribute8

338: => irc_inp_shd.g_old_rec.attribute6
339: ,p_attribute7_o
340: => irc_inp_shd.g_old_rec.attribute7
341: ,p_attribute8_o
342: => irc_inp_shd.g_old_rec.attribute8
343: ,p_attribute9_o
344: => irc_inp_shd.g_old_rec.attribute9
345: ,p_attribute10_o
346: => irc_inp_shd.g_old_rec.attribute10

Line 344: => irc_inp_shd.g_old_rec.attribute9

340: => irc_inp_shd.g_old_rec.attribute7
341: ,p_attribute8_o
342: => irc_inp_shd.g_old_rec.attribute8
343: ,p_attribute9_o
344: => irc_inp_shd.g_old_rec.attribute9
345: ,p_attribute10_o
346: => irc_inp_shd.g_old_rec.attribute10
347: ,p_attribute11_o
348: => irc_inp_shd.g_old_rec.attribute11

Line 346: => irc_inp_shd.g_old_rec.attribute10

342: => irc_inp_shd.g_old_rec.attribute8
343: ,p_attribute9_o
344: => irc_inp_shd.g_old_rec.attribute9
345: ,p_attribute10_o
346: => irc_inp_shd.g_old_rec.attribute10
347: ,p_attribute11_o
348: => irc_inp_shd.g_old_rec.attribute11
349: ,p_attribute12_o
350: => irc_inp_shd.g_old_rec.attribute12

Line 348: => irc_inp_shd.g_old_rec.attribute11

344: => irc_inp_shd.g_old_rec.attribute9
345: ,p_attribute10_o
346: => irc_inp_shd.g_old_rec.attribute10
347: ,p_attribute11_o
348: => irc_inp_shd.g_old_rec.attribute11
349: ,p_attribute12_o
350: => irc_inp_shd.g_old_rec.attribute12
351: ,p_attribute13_o
352: => irc_inp_shd.g_old_rec.attribute13

Line 350: => irc_inp_shd.g_old_rec.attribute12

346: => irc_inp_shd.g_old_rec.attribute10
347: ,p_attribute11_o
348: => irc_inp_shd.g_old_rec.attribute11
349: ,p_attribute12_o
350: => irc_inp_shd.g_old_rec.attribute12
351: ,p_attribute13_o
352: => irc_inp_shd.g_old_rec.attribute13
353: ,p_attribute14_o
354: => irc_inp_shd.g_old_rec.attribute14

Line 352: => irc_inp_shd.g_old_rec.attribute13

348: => irc_inp_shd.g_old_rec.attribute11
349: ,p_attribute12_o
350: => irc_inp_shd.g_old_rec.attribute12
351: ,p_attribute13_o
352: => irc_inp_shd.g_old_rec.attribute13
353: ,p_attribute14_o
354: => irc_inp_shd.g_old_rec.attribute14
355: ,p_attribute15_o
356: => irc_inp_shd.g_old_rec.attribute15

Line 354: => irc_inp_shd.g_old_rec.attribute14

350: => irc_inp_shd.g_old_rec.attribute12
351: ,p_attribute13_o
352: => irc_inp_shd.g_old_rec.attribute13
353: ,p_attribute14_o
354: => irc_inp_shd.g_old_rec.attribute14
355: ,p_attribute15_o
356: => irc_inp_shd.g_old_rec.attribute15
357: ,p_attribute16_o
358: => irc_inp_shd.g_old_rec.attribute16

Line 356: => irc_inp_shd.g_old_rec.attribute15

352: => irc_inp_shd.g_old_rec.attribute13
353: ,p_attribute14_o
354: => irc_inp_shd.g_old_rec.attribute14
355: ,p_attribute15_o
356: => irc_inp_shd.g_old_rec.attribute15
357: ,p_attribute16_o
358: => irc_inp_shd.g_old_rec.attribute16
359: ,p_attribute17_o
360: => irc_inp_shd.g_old_rec.attribute17

Line 358: => irc_inp_shd.g_old_rec.attribute16

354: => irc_inp_shd.g_old_rec.attribute14
355: ,p_attribute15_o
356: => irc_inp_shd.g_old_rec.attribute15
357: ,p_attribute16_o
358: => irc_inp_shd.g_old_rec.attribute16
359: ,p_attribute17_o
360: => irc_inp_shd.g_old_rec.attribute17
361: ,p_attribute18_o
362: => irc_inp_shd.g_old_rec.attribute18

Line 360: => irc_inp_shd.g_old_rec.attribute17

356: => irc_inp_shd.g_old_rec.attribute15
357: ,p_attribute16_o
358: => irc_inp_shd.g_old_rec.attribute16
359: ,p_attribute17_o
360: => irc_inp_shd.g_old_rec.attribute17
361: ,p_attribute18_o
362: => irc_inp_shd.g_old_rec.attribute18
363: ,p_attribute19_o
364: => irc_inp_shd.g_old_rec.attribute19

Line 362: => irc_inp_shd.g_old_rec.attribute18

358: => irc_inp_shd.g_old_rec.attribute16
359: ,p_attribute17_o
360: => irc_inp_shd.g_old_rec.attribute17
361: ,p_attribute18_o
362: => irc_inp_shd.g_old_rec.attribute18
363: ,p_attribute19_o
364: => irc_inp_shd.g_old_rec.attribute19
365: ,p_attribute20_o
366: => irc_inp_shd.g_old_rec.attribute20

Line 364: => irc_inp_shd.g_old_rec.attribute19

360: => irc_inp_shd.g_old_rec.attribute17
361: ,p_attribute18_o
362: => irc_inp_shd.g_old_rec.attribute18
363: ,p_attribute19_o
364: => irc_inp_shd.g_old_rec.attribute19
365: ,p_attribute20_o
366: => irc_inp_shd.g_old_rec.attribute20
367: ,p_attribute21_o
368: => irc_inp_shd.g_old_rec.attribute21

Line 366: => irc_inp_shd.g_old_rec.attribute20

362: => irc_inp_shd.g_old_rec.attribute18
363: ,p_attribute19_o
364: => irc_inp_shd.g_old_rec.attribute19
365: ,p_attribute20_o
366: => irc_inp_shd.g_old_rec.attribute20
367: ,p_attribute21_o
368: => irc_inp_shd.g_old_rec.attribute21
369: ,p_attribute22_o
370: => irc_inp_shd.g_old_rec.attribute22

Line 368: => irc_inp_shd.g_old_rec.attribute21

364: => irc_inp_shd.g_old_rec.attribute19
365: ,p_attribute20_o
366: => irc_inp_shd.g_old_rec.attribute20
367: ,p_attribute21_o
368: => irc_inp_shd.g_old_rec.attribute21
369: ,p_attribute22_o
370: => irc_inp_shd.g_old_rec.attribute22
371: ,p_attribute23_o
372: => irc_inp_shd.g_old_rec.attribute23

Line 370: => irc_inp_shd.g_old_rec.attribute22

366: => irc_inp_shd.g_old_rec.attribute20
367: ,p_attribute21_o
368: => irc_inp_shd.g_old_rec.attribute21
369: ,p_attribute22_o
370: => irc_inp_shd.g_old_rec.attribute22
371: ,p_attribute23_o
372: => irc_inp_shd.g_old_rec.attribute23
373: ,p_attribute24_o
374: => irc_inp_shd.g_old_rec.attribute24

Line 372: => irc_inp_shd.g_old_rec.attribute23

368: => irc_inp_shd.g_old_rec.attribute21
369: ,p_attribute22_o
370: => irc_inp_shd.g_old_rec.attribute22
371: ,p_attribute23_o
372: => irc_inp_shd.g_old_rec.attribute23
373: ,p_attribute24_o
374: => irc_inp_shd.g_old_rec.attribute24
375: ,p_attribute25_o
376: => irc_inp_shd.g_old_rec.attribute25

Line 374: => irc_inp_shd.g_old_rec.attribute24

370: => irc_inp_shd.g_old_rec.attribute22
371: ,p_attribute23_o
372: => irc_inp_shd.g_old_rec.attribute23
373: ,p_attribute24_o
374: => irc_inp_shd.g_old_rec.attribute24
375: ,p_attribute25_o
376: => irc_inp_shd.g_old_rec.attribute25
377: ,p_attribute26_o
378: => irc_inp_shd.g_old_rec.attribute26

Line 376: => irc_inp_shd.g_old_rec.attribute25

372: => irc_inp_shd.g_old_rec.attribute23
373: ,p_attribute24_o
374: => irc_inp_shd.g_old_rec.attribute24
375: ,p_attribute25_o
376: => irc_inp_shd.g_old_rec.attribute25
377: ,p_attribute26_o
378: => irc_inp_shd.g_old_rec.attribute26
379: ,p_attribute27_o
380: => irc_inp_shd.g_old_rec.attribute27

Line 378: => irc_inp_shd.g_old_rec.attribute26

374: => irc_inp_shd.g_old_rec.attribute24
375: ,p_attribute25_o
376: => irc_inp_shd.g_old_rec.attribute25
377: ,p_attribute26_o
378: => irc_inp_shd.g_old_rec.attribute26
379: ,p_attribute27_o
380: => irc_inp_shd.g_old_rec.attribute27
381: ,p_attribute28_o
382: => irc_inp_shd.g_old_rec.attribute28

Line 380: => irc_inp_shd.g_old_rec.attribute27

376: => irc_inp_shd.g_old_rec.attribute25
377: ,p_attribute26_o
378: => irc_inp_shd.g_old_rec.attribute26
379: ,p_attribute27_o
380: => irc_inp_shd.g_old_rec.attribute27
381: ,p_attribute28_o
382: => irc_inp_shd.g_old_rec.attribute28
383: ,p_attribute29_o
384: => irc_inp_shd.g_old_rec.attribute29

Line 382: => irc_inp_shd.g_old_rec.attribute28

378: => irc_inp_shd.g_old_rec.attribute26
379: ,p_attribute27_o
380: => irc_inp_shd.g_old_rec.attribute27
381: ,p_attribute28_o
382: => irc_inp_shd.g_old_rec.attribute28
383: ,p_attribute29_o
384: => irc_inp_shd.g_old_rec.attribute29
385: ,p_attribute30_o
386: => irc_inp_shd.g_old_rec.attribute30

Line 384: => irc_inp_shd.g_old_rec.attribute29

380: => irc_inp_shd.g_old_rec.attribute27
381: ,p_attribute28_o
382: => irc_inp_shd.g_old_rec.attribute28
383: ,p_attribute29_o
384: => irc_inp_shd.g_old_rec.attribute29
385: ,p_attribute30_o
386: => irc_inp_shd.g_old_rec.attribute30
387: ,p_object_version_number_o
388: => irc_inp_shd.g_old_rec.object_version_number

Line 386: => irc_inp_shd.g_old_rec.attribute30

382: => irc_inp_shd.g_old_rec.attribute28
383: ,p_attribute29_o
384: => irc_inp_shd.g_old_rec.attribute29
385: ,p_attribute30_o
386: => irc_inp_shd.g_old_rec.attribute30
387: ,p_object_version_number_o
388: => irc_inp_shd.g_old_rec.object_version_number
389: ,p_party_id_o
390: => irc_inp_shd.g_old_rec.party_id

Line 388: => irc_inp_shd.g_old_rec.object_version_number

384: => irc_inp_shd.g_old_rec.attribute29
385: ,p_attribute30_o
386: => irc_inp_shd.g_old_rec.attribute30
387: ,p_object_version_number_o
388: => irc_inp_shd.g_old_rec.object_version_number
389: ,p_party_id_o
390: => irc_inp_shd.g_old_rec.party_id
391: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
392: ,p_agency_id_o => irc_inp_shd.g_old_rec.agency_id

Line 390: => irc_inp_shd.g_old_rec.party_id

386: => irc_inp_shd.g_old_rec.attribute30
387: ,p_object_version_number_o
388: => irc_inp_shd.g_old_rec.object_version_number
389: ,p_party_id_o
390: => irc_inp_shd.g_old_rec.party_id
391: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
392: ,p_agency_id_o => irc_inp_shd.g_old_rec.agency_id
393: ,p_attempt_id_o
394: => irc_inp_shd.g_old_rec.attempt_id

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

387: ,p_object_version_number_o
388: => irc_inp_shd.g_old_rec.object_version_number
389: ,p_party_id_o
390: => irc_inp_shd.g_old_rec.party_id
391: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
392: ,p_agency_id_o => irc_inp_shd.g_old_rec.agency_id
393: ,p_attempt_id_o
394: => irc_inp_shd.g_old_rec.attempt_id
395: );

Line 392: ,p_agency_id_o => irc_inp_shd.g_old_rec.agency_id

388: => irc_inp_shd.g_old_rec.object_version_number
389: ,p_party_id_o
390: => irc_inp_shd.g_old_rec.party_id
391: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
392: ,p_agency_id_o => irc_inp_shd.g_old_rec.agency_id
393: ,p_attempt_id_o
394: => irc_inp_shd.g_old_rec.attempt_id
395: );
396: --

Line 394: => irc_inp_shd.g_old_rec.attempt_id

390: => irc_inp_shd.g_old_rec.party_id
391: ,p_person_id_o => irc_inp_shd.g_old_rec.person_id
392: ,p_agency_id_o => irc_inp_shd.g_old_rec.agency_id
393: ,p_attempt_id_o
394: => irc_inp_shd.g_old_rec.attempt_id
395: );
396: --
397: exception
398: --

Line 454: (p_rec in out nocopy irc_inp_shd.g_rec_type

450: --
451: -- {End Of Comments}
452: -- ----------------------------------------------------------------------------
453: Procedure convert_defs
454: (p_rec in out nocopy irc_inp_shd.g_rec_type
455: ) is
456: --
457: Begin
458: --

Line 466: irc_inp_shd.g_old_rec.party_id;

462: -- is being used then we must set to the 'current' argument value.
463: --
464: If (p_rec.party_id = hr_api.g_number) then
465: p_rec.party_id :=
466: irc_inp_shd.g_old_rec.party_id;
467: End If;
468: If (p_rec.person_id = hr_api.g_number) then
469: p_rec.person_id :=
470: irc_inp_shd.g_old_rec.person_id;

Line 470: irc_inp_shd.g_old_rec.person_id;

466: irc_inp_shd.g_old_rec.party_id;
467: End If;
468: If (p_rec.person_id = hr_api.g_number) then
469: p_rec.person_id :=
470: irc_inp_shd.g_old_rec.person_id;
471: End If;
472: If (p_rec.matching_jobs = hr_api.g_varchar2) then
473: p_rec.matching_jobs :=
474: irc_inp_shd.g_old_rec.matching_jobs;

Line 474: irc_inp_shd.g_old_rec.matching_jobs;

470: irc_inp_shd.g_old_rec.person_id;
471: End If;
472: If (p_rec.matching_jobs = hr_api.g_varchar2) then
473: p_rec.matching_jobs :=
474: irc_inp_shd.g_old_rec.matching_jobs;
475: End If;
476: If (p_rec.matching_job_freq = hr_api.g_varchar2) then
477: p_rec.matching_job_freq :=
478: irc_inp_shd.g_old_rec.matching_job_freq;

Line 478: irc_inp_shd.g_old_rec.matching_job_freq;

474: irc_inp_shd.g_old_rec.matching_jobs;
475: End If;
476: If (p_rec.matching_job_freq = hr_api.g_varchar2) then
477: p_rec.matching_job_freq :=
478: irc_inp_shd.g_old_rec.matching_job_freq;
479: End If;
480: If (p_rec.attribute_category = hr_api.g_varchar2) then
481: p_rec.attribute_category :=
482: irc_inp_shd.g_old_rec.attribute_category;

Line 482: irc_inp_shd.g_old_rec.attribute_category;

478: irc_inp_shd.g_old_rec.matching_job_freq;
479: End If;
480: If (p_rec.attribute_category = hr_api.g_varchar2) then
481: p_rec.attribute_category :=
482: irc_inp_shd.g_old_rec.attribute_category;
483: End If;
484: If (p_rec.receive_info_mail = hr_api.g_varchar2) then
485: p_rec.receive_info_mail :=
486: irc_inp_shd.g_old_rec.receive_info_mail;

Line 486: irc_inp_shd.g_old_rec.receive_info_mail;

482: irc_inp_shd.g_old_rec.attribute_category;
483: End If;
484: If (p_rec.receive_info_mail = hr_api.g_varchar2) then
485: p_rec.receive_info_mail :=
486: irc_inp_shd.g_old_rec.receive_info_mail;
487: End If;
488: If (p_rec.allow_access = hr_api.g_varchar2) then
489: p_rec.allow_access :=
490: irc_inp_shd.g_old_rec.allow_access;

Line 490: irc_inp_shd.g_old_rec.allow_access;

486: irc_inp_shd.g_old_rec.receive_info_mail;
487: End If;
488: If (p_rec.allow_access = hr_api.g_varchar2) then
489: p_rec.allow_access :=
490: irc_inp_shd.g_old_rec.allow_access;
491: End If;
492: If (p_rec.address_id = hr_api.g_number) then
493: p_rec.address_id :=
494: irc_inp_shd.g_old_rec.address_id;

Line 494: irc_inp_shd.g_old_rec.address_id;

490: irc_inp_shd.g_old_rec.allow_access;
491: End If;
492: If (p_rec.address_id = hr_api.g_number) then
493: p_rec.address_id :=
494: irc_inp_shd.g_old_rec.address_id;
495: End If;
496: If (p_rec.attribute1 = hr_api.g_varchar2) then
497: p_rec.attribute1 :=
498: irc_inp_shd.g_old_rec.attribute1;

Line 498: irc_inp_shd.g_old_rec.attribute1;

494: irc_inp_shd.g_old_rec.address_id;
495: End If;
496: If (p_rec.attribute1 = hr_api.g_varchar2) then
497: p_rec.attribute1 :=
498: irc_inp_shd.g_old_rec.attribute1;
499: End If;
500: If (p_rec.attribute2 = hr_api.g_varchar2) then
501: p_rec.attribute2 :=
502: irc_inp_shd.g_old_rec.attribute2;

Line 502: irc_inp_shd.g_old_rec.attribute2;

498: irc_inp_shd.g_old_rec.attribute1;
499: End If;
500: If (p_rec.attribute2 = hr_api.g_varchar2) then
501: p_rec.attribute2 :=
502: irc_inp_shd.g_old_rec.attribute2;
503: End If;
504: If (p_rec.attribute3 = hr_api.g_varchar2) then
505: p_rec.attribute3 :=
506: irc_inp_shd.g_old_rec.attribute3;

Line 506: irc_inp_shd.g_old_rec.attribute3;

502: irc_inp_shd.g_old_rec.attribute2;
503: End If;
504: If (p_rec.attribute3 = hr_api.g_varchar2) then
505: p_rec.attribute3 :=
506: irc_inp_shd.g_old_rec.attribute3;
507: End If;
508: If (p_rec.attribute4 = hr_api.g_varchar2) then
509: p_rec.attribute4 :=
510: irc_inp_shd.g_old_rec.attribute4;

Line 510: irc_inp_shd.g_old_rec.attribute4;

506: irc_inp_shd.g_old_rec.attribute3;
507: End If;
508: If (p_rec.attribute4 = hr_api.g_varchar2) then
509: p_rec.attribute4 :=
510: irc_inp_shd.g_old_rec.attribute4;
511: End If;
512: If (p_rec.attribute5 = hr_api.g_varchar2) then
513: p_rec.attribute5 :=
514: irc_inp_shd.g_old_rec.attribute5;

Line 514: irc_inp_shd.g_old_rec.attribute5;

510: irc_inp_shd.g_old_rec.attribute4;
511: End If;
512: If (p_rec.attribute5 = hr_api.g_varchar2) then
513: p_rec.attribute5 :=
514: irc_inp_shd.g_old_rec.attribute5;
515: End If;
516: If (p_rec.attribute6 = hr_api.g_varchar2) then
517: p_rec.attribute6 :=
518: irc_inp_shd.g_old_rec.attribute6;

Line 518: irc_inp_shd.g_old_rec.attribute6;

514: irc_inp_shd.g_old_rec.attribute5;
515: End If;
516: If (p_rec.attribute6 = hr_api.g_varchar2) then
517: p_rec.attribute6 :=
518: irc_inp_shd.g_old_rec.attribute6;
519: End If;
520: If (p_rec.attribute7 = hr_api.g_varchar2) then
521: p_rec.attribute7 :=
522: irc_inp_shd.g_old_rec.attribute7;

Line 522: irc_inp_shd.g_old_rec.attribute7;

518: irc_inp_shd.g_old_rec.attribute6;
519: End If;
520: If (p_rec.attribute7 = hr_api.g_varchar2) then
521: p_rec.attribute7 :=
522: irc_inp_shd.g_old_rec.attribute7;
523: End If;
524: If (p_rec.attribute8 = hr_api.g_varchar2) then
525: p_rec.attribute8 :=
526: irc_inp_shd.g_old_rec.attribute8;

Line 526: irc_inp_shd.g_old_rec.attribute8;

522: irc_inp_shd.g_old_rec.attribute7;
523: End If;
524: If (p_rec.attribute8 = hr_api.g_varchar2) then
525: p_rec.attribute8 :=
526: irc_inp_shd.g_old_rec.attribute8;
527: End If;
528: If (p_rec.attribute9 = hr_api.g_varchar2) then
529: p_rec.attribute9 :=
530: irc_inp_shd.g_old_rec.attribute9;

Line 530: irc_inp_shd.g_old_rec.attribute9;

526: irc_inp_shd.g_old_rec.attribute8;
527: End If;
528: If (p_rec.attribute9 = hr_api.g_varchar2) then
529: p_rec.attribute9 :=
530: irc_inp_shd.g_old_rec.attribute9;
531: End If;
532: If (p_rec.attribute10 = hr_api.g_varchar2) then
533: p_rec.attribute10 :=
534: irc_inp_shd.g_old_rec.attribute10;

Line 534: irc_inp_shd.g_old_rec.attribute10;

530: irc_inp_shd.g_old_rec.attribute9;
531: End If;
532: If (p_rec.attribute10 = hr_api.g_varchar2) then
533: p_rec.attribute10 :=
534: irc_inp_shd.g_old_rec.attribute10;
535: End If;
536: If (p_rec.attribute11 = hr_api.g_varchar2) then
537: p_rec.attribute11 :=
538: irc_inp_shd.g_old_rec.attribute11;

Line 538: irc_inp_shd.g_old_rec.attribute11;

534: irc_inp_shd.g_old_rec.attribute10;
535: End If;
536: If (p_rec.attribute11 = hr_api.g_varchar2) then
537: p_rec.attribute11 :=
538: irc_inp_shd.g_old_rec.attribute11;
539: End If;
540: If (p_rec.attribute12 = hr_api.g_varchar2) then
541: p_rec.attribute12 :=
542: irc_inp_shd.g_old_rec.attribute12;

Line 542: irc_inp_shd.g_old_rec.attribute12;

538: irc_inp_shd.g_old_rec.attribute11;
539: End If;
540: If (p_rec.attribute12 = hr_api.g_varchar2) then
541: p_rec.attribute12 :=
542: irc_inp_shd.g_old_rec.attribute12;
543: End If;
544: If (p_rec.attribute13 = hr_api.g_varchar2) then
545: p_rec.attribute13 :=
546: irc_inp_shd.g_old_rec.attribute13;

Line 546: irc_inp_shd.g_old_rec.attribute13;

542: irc_inp_shd.g_old_rec.attribute12;
543: End If;
544: If (p_rec.attribute13 = hr_api.g_varchar2) then
545: p_rec.attribute13 :=
546: irc_inp_shd.g_old_rec.attribute13;
547: End If;
548: If (p_rec.attribute14 = hr_api.g_varchar2) then
549: p_rec.attribute14 :=
550: irc_inp_shd.g_old_rec.attribute14;

Line 550: irc_inp_shd.g_old_rec.attribute14;

546: irc_inp_shd.g_old_rec.attribute13;
547: End If;
548: If (p_rec.attribute14 = hr_api.g_varchar2) then
549: p_rec.attribute14 :=
550: irc_inp_shd.g_old_rec.attribute14;
551: End If;
552: If (p_rec.attribute15 = hr_api.g_varchar2) then
553: p_rec.attribute15 :=
554: irc_inp_shd.g_old_rec.attribute15;

Line 554: irc_inp_shd.g_old_rec.attribute15;

550: irc_inp_shd.g_old_rec.attribute14;
551: End If;
552: If (p_rec.attribute15 = hr_api.g_varchar2) then
553: p_rec.attribute15 :=
554: irc_inp_shd.g_old_rec.attribute15;
555: End If;
556: If (p_rec.attribute16 = hr_api.g_varchar2) then
557: p_rec.attribute16 :=
558: irc_inp_shd.g_old_rec.attribute16;

Line 558: irc_inp_shd.g_old_rec.attribute16;

554: irc_inp_shd.g_old_rec.attribute15;
555: End If;
556: If (p_rec.attribute16 = hr_api.g_varchar2) then
557: p_rec.attribute16 :=
558: irc_inp_shd.g_old_rec.attribute16;
559: End If;
560: If (p_rec.attribute17 = hr_api.g_varchar2) then
561: p_rec.attribute17 :=
562: irc_inp_shd.g_old_rec.attribute17;

Line 562: irc_inp_shd.g_old_rec.attribute17;

558: irc_inp_shd.g_old_rec.attribute16;
559: End If;
560: If (p_rec.attribute17 = hr_api.g_varchar2) then
561: p_rec.attribute17 :=
562: irc_inp_shd.g_old_rec.attribute17;
563: End If;
564: If (p_rec.attribute18 = hr_api.g_varchar2) then
565: p_rec.attribute18 :=
566: irc_inp_shd.g_old_rec.attribute18;

Line 566: irc_inp_shd.g_old_rec.attribute18;

562: irc_inp_shd.g_old_rec.attribute17;
563: End If;
564: If (p_rec.attribute18 = hr_api.g_varchar2) then
565: p_rec.attribute18 :=
566: irc_inp_shd.g_old_rec.attribute18;
567: End If;
568: If (p_rec.attribute19 = hr_api.g_varchar2) then
569: p_rec.attribute19 :=
570: irc_inp_shd.g_old_rec.attribute19;

Line 570: irc_inp_shd.g_old_rec.attribute19;

566: irc_inp_shd.g_old_rec.attribute18;
567: End If;
568: If (p_rec.attribute19 = hr_api.g_varchar2) then
569: p_rec.attribute19 :=
570: irc_inp_shd.g_old_rec.attribute19;
571: End If;
572: If (p_rec.attribute20 = hr_api.g_varchar2) then
573: p_rec.attribute20 :=
574: irc_inp_shd.g_old_rec.attribute20;

Line 574: irc_inp_shd.g_old_rec.attribute20;

570: irc_inp_shd.g_old_rec.attribute19;
571: End If;
572: If (p_rec.attribute20 = hr_api.g_varchar2) then
573: p_rec.attribute20 :=
574: irc_inp_shd.g_old_rec.attribute20;
575: End If;
576: If (p_rec.attribute21 = hr_api.g_varchar2) then
577: p_rec.attribute21 :=
578: irc_inp_shd.g_old_rec.attribute21;

Line 578: irc_inp_shd.g_old_rec.attribute21;

574: irc_inp_shd.g_old_rec.attribute20;
575: End If;
576: If (p_rec.attribute21 = hr_api.g_varchar2) then
577: p_rec.attribute21 :=
578: irc_inp_shd.g_old_rec.attribute21;
579: End If;
580: If (p_rec.attribute22 = hr_api.g_varchar2) then
581: p_rec.attribute22 :=
582: irc_inp_shd.g_old_rec.attribute22;

Line 582: irc_inp_shd.g_old_rec.attribute22;

578: irc_inp_shd.g_old_rec.attribute21;
579: End If;
580: If (p_rec.attribute22 = hr_api.g_varchar2) then
581: p_rec.attribute22 :=
582: irc_inp_shd.g_old_rec.attribute22;
583: End If;
584: If (p_rec.attribute23 = hr_api.g_varchar2) then
585: p_rec.attribute23 :=
586: irc_inp_shd.g_old_rec.attribute23;

Line 586: irc_inp_shd.g_old_rec.attribute23;

582: irc_inp_shd.g_old_rec.attribute22;
583: End If;
584: If (p_rec.attribute23 = hr_api.g_varchar2) then
585: p_rec.attribute23 :=
586: irc_inp_shd.g_old_rec.attribute23;
587: End If;
588: If (p_rec.attribute24 = hr_api.g_varchar2) then
589: p_rec.attribute24 :=
590: irc_inp_shd.g_old_rec.attribute24;

Line 590: irc_inp_shd.g_old_rec.attribute24;

586: irc_inp_shd.g_old_rec.attribute23;
587: End If;
588: If (p_rec.attribute24 = hr_api.g_varchar2) then
589: p_rec.attribute24 :=
590: irc_inp_shd.g_old_rec.attribute24;
591: End If;
592: If (p_rec.attribute25 = hr_api.g_varchar2) then
593: p_rec.attribute25 :=
594: irc_inp_shd.g_old_rec.attribute25;

Line 594: irc_inp_shd.g_old_rec.attribute25;

590: irc_inp_shd.g_old_rec.attribute24;
591: End If;
592: If (p_rec.attribute25 = hr_api.g_varchar2) then
593: p_rec.attribute25 :=
594: irc_inp_shd.g_old_rec.attribute25;
595: End If;
596: If (p_rec.attribute26 = hr_api.g_varchar2) then
597: p_rec.attribute26 :=
598: irc_inp_shd.g_old_rec.attribute26;

Line 598: irc_inp_shd.g_old_rec.attribute26;

594: irc_inp_shd.g_old_rec.attribute25;
595: End If;
596: If (p_rec.attribute26 = hr_api.g_varchar2) then
597: p_rec.attribute26 :=
598: irc_inp_shd.g_old_rec.attribute26;
599: End If;
600: If (p_rec.attribute27 = hr_api.g_varchar2) then
601: p_rec.attribute27 :=
602: irc_inp_shd.g_old_rec.attribute27;

Line 602: irc_inp_shd.g_old_rec.attribute27;

598: irc_inp_shd.g_old_rec.attribute26;
599: End If;
600: If (p_rec.attribute27 = hr_api.g_varchar2) then
601: p_rec.attribute27 :=
602: irc_inp_shd.g_old_rec.attribute27;
603: End If;
604: If (p_rec.attribute28 = hr_api.g_varchar2) then
605: p_rec.attribute28 :=
606: irc_inp_shd.g_old_rec.attribute28;

Line 606: irc_inp_shd.g_old_rec.attribute28;

602: irc_inp_shd.g_old_rec.attribute27;
603: End If;
604: If (p_rec.attribute28 = hr_api.g_varchar2) then
605: p_rec.attribute28 :=
606: irc_inp_shd.g_old_rec.attribute28;
607: End If;
608: If (p_rec.attribute29 = hr_api.g_varchar2) then
609: p_rec.attribute29 :=
610: irc_inp_shd.g_old_rec.attribute29;

Line 610: irc_inp_shd.g_old_rec.attribute29;

606: irc_inp_shd.g_old_rec.attribute28;
607: End If;
608: If (p_rec.attribute29 = hr_api.g_varchar2) then
609: p_rec.attribute29 :=
610: irc_inp_shd.g_old_rec.attribute29;
611: End If;
612: If (p_rec.attribute30 = hr_api.g_varchar2) then
613: p_rec.attribute30 :=
614: irc_inp_shd.g_old_rec.attribute30;

Line 614: irc_inp_shd.g_old_rec.attribute30;

610: irc_inp_shd.g_old_rec.attribute29;
611: End If;
612: If (p_rec.attribute30 = hr_api.g_varchar2) then
613: p_rec.attribute30 :=
614: irc_inp_shd.g_old_rec.attribute30;
615: End If;
616: If (p_rec.agency_id = hr_api.g_number) then
617: p_rec.agency_id :=
618: irc_inp_shd.g_old_rec.agency_id;

Line 618: irc_inp_shd.g_old_rec.agency_id;

614: irc_inp_shd.g_old_rec.attribute30;
615: End If;
616: If (p_rec.agency_id = hr_api.g_number) then
617: p_rec.agency_id :=
618: irc_inp_shd.g_old_rec.agency_id;
619: End If;
620: If (p_rec.attempt_id = hr_api.g_number) then
621: p_rec.attempt_id :=
622: irc_inp_shd.g_old_rec.attempt_id;

Line 622: irc_inp_shd.g_old_rec.attempt_id;

618: irc_inp_shd.g_old_rec.agency_id;
619: End If;
620: If (p_rec.attempt_id = hr_api.g_number) then
621: p_rec.attempt_id :=
622: irc_inp_shd.g_old_rec.attempt_id;
623: End If;
624: --
625: End convert_defs;
626: --

Line 632: ,p_rec in out nocopy irc_inp_shd.g_rec_type

628: -- |---------------------------------< upd >----------------------------------|
629: -- ----------------------------------------------------------------------------
630: Procedure upd
631: (p_effective_date in date
632: ,p_rec in out nocopy irc_inp_shd.g_rec_type
633: ) is
634: --
635: l_proc varchar2(72) := g_package||'upd';
636: --

Line 642: irc_inp_shd.lck

638: hr_utility.set_location('Entering:'||l_proc, 5);
639: --
640: -- We must lock the row which we need to update.
641: --
642: irc_inp_shd.lck
643: (p_rec.notification_preference_id
644: ,p_rec.object_version_number
645: );
646: --

Line 735: l_rec irc_inp_shd.g_rec_type;

731: ,p_agency_id in number default hr_api.g_number
732: ,p_attempt_id in number default hr_api.g_number
733: ) is
734: --
735: l_rec irc_inp_shd.g_rec_type;
736: l_proc varchar2(72) := g_package||'upd';
737: --
738: Begin
739: hr_utility.set_location('Entering:'||l_proc, 5);

Line 745: irc_inp_shd.convert_args

741: -- Call conversion function to turn arguments into the
742: -- l_rec structure.
743: --
744: l_rec :=
745: irc_inp_shd.convert_args
746: (p_party_id
747: ,p_person_id
748: ,p_notification_preference_id
749: ,p_matching_jobs