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_IDP_UPD dependencies on IRC_IDP_SHD

Line 55: (p_rec in out nocopy irc_idp_shd.g_rec_type

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

Line 66: irc_idp_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_idp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the irc_default_postings Row
69: --
70: update irc_default_postings

Line 110: irc_idp_shd.g_api_dml := false; -- Unset the api dml status

106: ,attribute30 = p_rec.attribute30
107: ,object_version_number = p_rec.object_version_number
108: where default_posting_id = p_rec.default_posting_id;
109: --
110: irc_idp_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: --
114: Exception

Line 117: irc_idp_shd.g_api_dml := false; -- Unset the api dml status

113: --
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: irc_idp_shd.g_api_dml := false; -- Unset the api dml status
118: --
119: irc_idp_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then

Line 119: irc_idp_shd.constraint_error

115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: irc_idp_shd.g_api_dml := false; -- Unset the api dml status
118: --
119: irc_idp_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: irc_idp_shd.g_api_dml := false; -- Unset the api dml status

Line 123: irc_idp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 125: irc_idp_shd.constraint_error

121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: irc_idp_shd.g_api_dml := false; -- Unset the api dml status
124: --
125: irc_idp_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: irc_idp_shd.g_api_dml := false; -- Unset the api dml status

Line 129: irc_idp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 131: irc_idp_shd.constraint_error

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

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

130: --
131: irc_idp_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: irc_idp_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: Raise;
137: End update_dml;
138: --

Line 172: (p_rec in irc_idp_shd.g_rec_type

168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure pre_update
172: (p_rec in irc_idp_shd.g_rec_type
173: ) is
174: --
175: l_proc varchar2(72) := g_package||'pre_update';
176: --

Line 216: (p_rec in irc_idp_shd.g_rec_type

212: --
213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: Procedure post_update
216: (p_rec in irc_idp_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'post_update';
220: --

Line 299: => irc_idp_shd.g_old_rec.position_id

295: => p_rec.attribute30
296: ,p_object_version_number
297: => p_rec.object_version_number
298: ,p_position_id_o
299: => irc_idp_shd.g_old_rec.position_id
300: ,p_job_id_o
301: => irc_idp_shd.g_old_rec.job_id
302: ,p_attribute_category_o
303: => irc_idp_shd.g_old_rec.attribute_category

Line 301: => irc_idp_shd.g_old_rec.job_id

297: => p_rec.object_version_number
298: ,p_position_id_o
299: => irc_idp_shd.g_old_rec.position_id
300: ,p_job_id_o
301: => irc_idp_shd.g_old_rec.job_id
302: ,p_attribute_category_o
303: => irc_idp_shd.g_old_rec.attribute_category
304: ,p_organization_id_o
305: => irc_idp_shd.g_old_rec.organization_id

Line 303: => irc_idp_shd.g_old_rec.attribute_category

299: => irc_idp_shd.g_old_rec.position_id
300: ,p_job_id_o
301: => irc_idp_shd.g_old_rec.job_id
302: ,p_attribute_category_o
303: => irc_idp_shd.g_old_rec.attribute_category
304: ,p_organization_id_o
305: => irc_idp_shd.g_old_rec.organization_id
306: ,p_attribute1_o
307: => irc_idp_shd.g_old_rec.attribute1

Line 305: => irc_idp_shd.g_old_rec.organization_id

301: => irc_idp_shd.g_old_rec.job_id
302: ,p_attribute_category_o
303: => irc_idp_shd.g_old_rec.attribute_category
304: ,p_organization_id_o
305: => irc_idp_shd.g_old_rec.organization_id
306: ,p_attribute1_o
307: => irc_idp_shd.g_old_rec.attribute1
308: ,p_attribute2_o
309: => irc_idp_shd.g_old_rec.attribute2

Line 307: => irc_idp_shd.g_old_rec.attribute1

303: => irc_idp_shd.g_old_rec.attribute_category
304: ,p_organization_id_o
305: => irc_idp_shd.g_old_rec.organization_id
306: ,p_attribute1_o
307: => irc_idp_shd.g_old_rec.attribute1
308: ,p_attribute2_o
309: => irc_idp_shd.g_old_rec.attribute2
310: ,p_attribute3_o
311: => irc_idp_shd.g_old_rec.attribute3

Line 309: => irc_idp_shd.g_old_rec.attribute2

305: => irc_idp_shd.g_old_rec.organization_id
306: ,p_attribute1_o
307: => irc_idp_shd.g_old_rec.attribute1
308: ,p_attribute2_o
309: => irc_idp_shd.g_old_rec.attribute2
310: ,p_attribute3_o
311: => irc_idp_shd.g_old_rec.attribute3
312: ,p_attribute4_o
313: => irc_idp_shd.g_old_rec.attribute4

Line 311: => irc_idp_shd.g_old_rec.attribute3

307: => irc_idp_shd.g_old_rec.attribute1
308: ,p_attribute2_o
309: => irc_idp_shd.g_old_rec.attribute2
310: ,p_attribute3_o
311: => irc_idp_shd.g_old_rec.attribute3
312: ,p_attribute4_o
313: => irc_idp_shd.g_old_rec.attribute4
314: ,p_attribute5_o
315: => irc_idp_shd.g_old_rec.attribute5

Line 313: => irc_idp_shd.g_old_rec.attribute4

309: => irc_idp_shd.g_old_rec.attribute2
310: ,p_attribute3_o
311: => irc_idp_shd.g_old_rec.attribute3
312: ,p_attribute4_o
313: => irc_idp_shd.g_old_rec.attribute4
314: ,p_attribute5_o
315: => irc_idp_shd.g_old_rec.attribute5
316: ,p_attribute6_o
317: => irc_idp_shd.g_old_rec.attribute6

Line 315: => irc_idp_shd.g_old_rec.attribute5

311: => irc_idp_shd.g_old_rec.attribute3
312: ,p_attribute4_o
313: => irc_idp_shd.g_old_rec.attribute4
314: ,p_attribute5_o
315: => irc_idp_shd.g_old_rec.attribute5
316: ,p_attribute6_o
317: => irc_idp_shd.g_old_rec.attribute6
318: ,p_attribute7_o
319: => irc_idp_shd.g_old_rec.attribute7

Line 317: => irc_idp_shd.g_old_rec.attribute6

313: => irc_idp_shd.g_old_rec.attribute4
314: ,p_attribute5_o
315: => irc_idp_shd.g_old_rec.attribute5
316: ,p_attribute6_o
317: => irc_idp_shd.g_old_rec.attribute6
318: ,p_attribute7_o
319: => irc_idp_shd.g_old_rec.attribute7
320: ,p_attribute8_o
321: => irc_idp_shd.g_old_rec.attribute8

Line 319: => irc_idp_shd.g_old_rec.attribute7

315: => irc_idp_shd.g_old_rec.attribute5
316: ,p_attribute6_o
317: => irc_idp_shd.g_old_rec.attribute6
318: ,p_attribute7_o
319: => irc_idp_shd.g_old_rec.attribute7
320: ,p_attribute8_o
321: => irc_idp_shd.g_old_rec.attribute8
322: ,p_attribute9_o
323: => irc_idp_shd.g_old_rec.attribute9

Line 321: => irc_idp_shd.g_old_rec.attribute8

317: => irc_idp_shd.g_old_rec.attribute6
318: ,p_attribute7_o
319: => irc_idp_shd.g_old_rec.attribute7
320: ,p_attribute8_o
321: => irc_idp_shd.g_old_rec.attribute8
322: ,p_attribute9_o
323: => irc_idp_shd.g_old_rec.attribute9
324: ,p_attribute10_o
325: => irc_idp_shd.g_old_rec.attribute10

Line 323: => irc_idp_shd.g_old_rec.attribute9

319: => irc_idp_shd.g_old_rec.attribute7
320: ,p_attribute8_o
321: => irc_idp_shd.g_old_rec.attribute8
322: ,p_attribute9_o
323: => irc_idp_shd.g_old_rec.attribute9
324: ,p_attribute10_o
325: => irc_idp_shd.g_old_rec.attribute10
326: ,p_attribute11_o
327: => irc_idp_shd.g_old_rec.attribute11

Line 325: => irc_idp_shd.g_old_rec.attribute10

321: => irc_idp_shd.g_old_rec.attribute8
322: ,p_attribute9_o
323: => irc_idp_shd.g_old_rec.attribute9
324: ,p_attribute10_o
325: => irc_idp_shd.g_old_rec.attribute10
326: ,p_attribute11_o
327: => irc_idp_shd.g_old_rec.attribute11
328: ,p_attribute12_o
329: => irc_idp_shd.g_old_rec.attribute12

Line 327: => irc_idp_shd.g_old_rec.attribute11

323: => irc_idp_shd.g_old_rec.attribute9
324: ,p_attribute10_o
325: => irc_idp_shd.g_old_rec.attribute10
326: ,p_attribute11_o
327: => irc_idp_shd.g_old_rec.attribute11
328: ,p_attribute12_o
329: => irc_idp_shd.g_old_rec.attribute12
330: ,p_attribute13_o
331: => irc_idp_shd.g_old_rec.attribute13

Line 329: => irc_idp_shd.g_old_rec.attribute12

325: => irc_idp_shd.g_old_rec.attribute10
326: ,p_attribute11_o
327: => irc_idp_shd.g_old_rec.attribute11
328: ,p_attribute12_o
329: => irc_idp_shd.g_old_rec.attribute12
330: ,p_attribute13_o
331: => irc_idp_shd.g_old_rec.attribute13
332: ,p_attribute14_o
333: => irc_idp_shd.g_old_rec.attribute14

Line 331: => irc_idp_shd.g_old_rec.attribute13

327: => irc_idp_shd.g_old_rec.attribute11
328: ,p_attribute12_o
329: => irc_idp_shd.g_old_rec.attribute12
330: ,p_attribute13_o
331: => irc_idp_shd.g_old_rec.attribute13
332: ,p_attribute14_o
333: => irc_idp_shd.g_old_rec.attribute14
334: ,p_attribute15_o
335: => irc_idp_shd.g_old_rec.attribute15

Line 333: => irc_idp_shd.g_old_rec.attribute14

329: => irc_idp_shd.g_old_rec.attribute12
330: ,p_attribute13_o
331: => irc_idp_shd.g_old_rec.attribute13
332: ,p_attribute14_o
333: => irc_idp_shd.g_old_rec.attribute14
334: ,p_attribute15_o
335: => irc_idp_shd.g_old_rec.attribute15
336: ,p_attribute16_o
337: => irc_idp_shd.g_old_rec.attribute16

Line 335: => irc_idp_shd.g_old_rec.attribute15

331: => irc_idp_shd.g_old_rec.attribute13
332: ,p_attribute14_o
333: => irc_idp_shd.g_old_rec.attribute14
334: ,p_attribute15_o
335: => irc_idp_shd.g_old_rec.attribute15
336: ,p_attribute16_o
337: => irc_idp_shd.g_old_rec.attribute16
338: ,p_attribute17_o
339: => irc_idp_shd.g_old_rec.attribute17

Line 337: => irc_idp_shd.g_old_rec.attribute16

333: => irc_idp_shd.g_old_rec.attribute14
334: ,p_attribute15_o
335: => irc_idp_shd.g_old_rec.attribute15
336: ,p_attribute16_o
337: => irc_idp_shd.g_old_rec.attribute16
338: ,p_attribute17_o
339: => irc_idp_shd.g_old_rec.attribute17
340: ,p_attribute18_o
341: => irc_idp_shd.g_old_rec.attribute18

Line 339: => irc_idp_shd.g_old_rec.attribute17

335: => irc_idp_shd.g_old_rec.attribute15
336: ,p_attribute16_o
337: => irc_idp_shd.g_old_rec.attribute16
338: ,p_attribute17_o
339: => irc_idp_shd.g_old_rec.attribute17
340: ,p_attribute18_o
341: => irc_idp_shd.g_old_rec.attribute18
342: ,p_attribute19_o
343: => irc_idp_shd.g_old_rec.attribute19

Line 341: => irc_idp_shd.g_old_rec.attribute18

337: => irc_idp_shd.g_old_rec.attribute16
338: ,p_attribute17_o
339: => irc_idp_shd.g_old_rec.attribute17
340: ,p_attribute18_o
341: => irc_idp_shd.g_old_rec.attribute18
342: ,p_attribute19_o
343: => irc_idp_shd.g_old_rec.attribute19
344: ,p_attribute20_o
345: => irc_idp_shd.g_old_rec.attribute20

Line 343: => irc_idp_shd.g_old_rec.attribute19

339: => irc_idp_shd.g_old_rec.attribute17
340: ,p_attribute18_o
341: => irc_idp_shd.g_old_rec.attribute18
342: ,p_attribute19_o
343: => irc_idp_shd.g_old_rec.attribute19
344: ,p_attribute20_o
345: => irc_idp_shd.g_old_rec.attribute20
346: ,p_attribute21_o
347: => irc_idp_shd.g_old_rec.attribute21

Line 345: => irc_idp_shd.g_old_rec.attribute20

341: => irc_idp_shd.g_old_rec.attribute18
342: ,p_attribute19_o
343: => irc_idp_shd.g_old_rec.attribute19
344: ,p_attribute20_o
345: => irc_idp_shd.g_old_rec.attribute20
346: ,p_attribute21_o
347: => irc_idp_shd.g_old_rec.attribute21
348: ,p_attribute22_o
349: => irc_idp_shd.g_old_rec.attribute22

Line 347: => irc_idp_shd.g_old_rec.attribute21

343: => irc_idp_shd.g_old_rec.attribute19
344: ,p_attribute20_o
345: => irc_idp_shd.g_old_rec.attribute20
346: ,p_attribute21_o
347: => irc_idp_shd.g_old_rec.attribute21
348: ,p_attribute22_o
349: => irc_idp_shd.g_old_rec.attribute22
350: ,p_attribute23_o
351: => irc_idp_shd.g_old_rec.attribute23

Line 349: => irc_idp_shd.g_old_rec.attribute22

345: => irc_idp_shd.g_old_rec.attribute20
346: ,p_attribute21_o
347: => irc_idp_shd.g_old_rec.attribute21
348: ,p_attribute22_o
349: => irc_idp_shd.g_old_rec.attribute22
350: ,p_attribute23_o
351: => irc_idp_shd.g_old_rec.attribute23
352: ,p_attribute24_o
353: => irc_idp_shd.g_old_rec.attribute24

Line 351: => irc_idp_shd.g_old_rec.attribute23

347: => irc_idp_shd.g_old_rec.attribute21
348: ,p_attribute22_o
349: => irc_idp_shd.g_old_rec.attribute22
350: ,p_attribute23_o
351: => irc_idp_shd.g_old_rec.attribute23
352: ,p_attribute24_o
353: => irc_idp_shd.g_old_rec.attribute24
354: ,p_attribute25_o
355: => irc_idp_shd.g_old_rec.attribute25

Line 353: => irc_idp_shd.g_old_rec.attribute24

349: => irc_idp_shd.g_old_rec.attribute22
350: ,p_attribute23_o
351: => irc_idp_shd.g_old_rec.attribute23
352: ,p_attribute24_o
353: => irc_idp_shd.g_old_rec.attribute24
354: ,p_attribute25_o
355: => irc_idp_shd.g_old_rec.attribute25
356: ,p_attribute26_o
357: => irc_idp_shd.g_old_rec.attribute26

Line 355: => irc_idp_shd.g_old_rec.attribute25

351: => irc_idp_shd.g_old_rec.attribute23
352: ,p_attribute24_o
353: => irc_idp_shd.g_old_rec.attribute24
354: ,p_attribute25_o
355: => irc_idp_shd.g_old_rec.attribute25
356: ,p_attribute26_o
357: => irc_idp_shd.g_old_rec.attribute26
358: ,p_attribute27_o
359: => irc_idp_shd.g_old_rec.attribute27

Line 357: => irc_idp_shd.g_old_rec.attribute26

353: => irc_idp_shd.g_old_rec.attribute24
354: ,p_attribute25_o
355: => irc_idp_shd.g_old_rec.attribute25
356: ,p_attribute26_o
357: => irc_idp_shd.g_old_rec.attribute26
358: ,p_attribute27_o
359: => irc_idp_shd.g_old_rec.attribute27
360: ,p_attribute28_o
361: => irc_idp_shd.g_old_rec.attribute28

Line 359: => irc_idp_shd.g_old_rec.attribute27

355: => irc_idp_shd.g_old_rec.attribute25
356: ,p_attribute26_o
357: => irc_idp_shd.g_old_rec.attribute26
358: ,p_attribute27_o
359: => irc_idp_shd.g_old_rec.attribute27
360: ,p_attribute28_o
361: => irc_idp_shd.g_old_rec.attribute28
362: ,p_attribute29_o
363: => irc_idp_shd.g_old_rec.attribute29

Line 361: => irc_idp_shd.g_old_rec.attribute28

357: => irc_idp_shd.g_old_rec.attribute26
358: ,p_attribute27_o
359: => irc_idp_shd.g_old_rec.attribute27
360: ,p_attribute28_o
361: => irc_idp_shd.g_old_rec.attribute28
362: ,p_attribute29_o
363: => irc_idp_shd.g_old_rec.attribute29
364: ,p_attribute30_o
365: => irc_idp_shd.g_old_rec.attribute30

Line 363: => irc_idp_shd.g_old_rec.attribute29

359: => irc_idp_shd.g_old_rec.attribute27
360: ,p_attribute28_o
361: => irc_idp_shd.g_old_rec.attribute28
362: ,p_attribute29_o
363: => irc_idp_shd.g_old_rec.attribute29
364: ,p_attribute30_o
365: => irc_idp_shd.g_old_rec.attribute30
366: ,p_object_version_number_o
367: => irc_idp_shd.g_old_rec.object_version_number

Line 365: => irc_idp_shd.g_old_rec.attribute30

361: => irc_idp_shd.g_old_rec.attribute28
362: ,p_attribute29_o
363: => irc_idp_shd.g_old_rec.attribute29
364: ,p_attribute30_o
365: => irc_idp_shd.g_old_rec.attribute30
366: ,p_object_version_number_o
367: => irc_idp_shd.g_old_rec.object_version_number
368: );
369: --

Line 367: => irc_idp_shd.g_old_rec.object_version_number

363: => irc_idp_shd.g_old_rec.attribute29
364: ,p_attribute30_o
365: => irc_idp_shd.g_old_rec.attribute30
366: ,p_object_version_number_o
367: => irc_idp_shd.g_old_rec.object_version_number
368: );
369: --
370: exception
371: --

Line 427: (p_rec in out nocopy irc_idp_shd.g_rec_type

423: --
424: -- {End Of Comments}
425: -- ----------------------------------------------------------------------------
426: Procedure convert_defs
427: (p_rec in out nocopy irc_idp_shd.g_rec_type
428: ) is
429: --
430: Begin
431: --

Line 439: irc_idp_shd.g_old_rec.position_id;

435: -- is being used then we must set to the 'current' argument value.
436: --
437: If (p_rec.position_id = hr_api.g_number) then
438: p_rec.position_id :=
439: irc_idp_shd.g_old_rec.position_id;
440: End If;
441: If (p_rec.job_id = hr_api.g_number) then
442: p_rec.job_id :=
443: irc_idp_shd.g_old_rec.job_id;

Line 443: irc_idp_shd.g_old_rec.job_id;

439: irc_idp_shd.g_old_rec.position_id;
440: End If;
441: If (p_rec.job_id = hr_api.g_number) then
442: p_rec.job_id :=
443: irc_idp_shd.g_old_rec.job_id;
444: End If;
445: If (p_rec.attribute_category = hr_api.g_varchar2) then
446: p_rec.attribute_category :=
447: irc_idp_shd.g_old_rec.attribute_category;

Line 447: irc_idp_shd.g_old_rec.attribute_category;

443: irc_idp_shd.g_old_rec.job_id;
444: End If;
445: If (p_rec.attribute_category = hr_api.g_varchar2) then
446: p_rec.attribute_category :=
447: irc_idp_shd.g_old_rec.attribute_category;
448: End If;
449: If (p_rec.organization_id = hr_api.g_number) then
450: p_rec.organization_id :=
451: irc_idp_shd.g_old_rec.organization_id;

Line 451: irc_idp_shd.g_old_rec.organization_id;

447: irc_idp_shd.g_old_rec.attribute_category;
448: End If;
449: If (p_rec.organization_id = hr_api.g_number) then
450: p_rec.organization_id :=
451: irc_idp_shd.g_old_rec.organization_id;
452: End If;
453: If (p_rec.attribute1 = hr_api.g_varchar2) then
454: p_rec.attribute1 :=
455: irc_idp_shd.g_old_rec.attribute1;

Line 455: irc_idp_shd.g_old_rec.attribute1;

451: irc_idp_shd.g_old_rec.organization_id;
452: End If;
453: If (p_rec.attribute1 = hr_api.g_varchar2) then
454: p_rec.attribute1 :=
455: irc_idp_shd.g_old_rec.attribute1;
456: End If;
457: If (p_rec.attribute2 = hr_api.g_varchar2) then
458: p_rec.attribute2 :=
459: irc_idp_shd.g_old_rec.attribute2;

Line 459: irc_idp_shd.g_old_rec.attribute2;

455: irc_idp_shd.g_old_rec.attribute1;
456: End If;
457: If (p_rec.attribute2 = hr_api.g_varchar2) then
458: p_rec.attribute2 :=
459: irc_idp_shd.g_old_rec.attribute2;
460: End If;
461: If (p_rec.attribute3 = hr_api.g_varchar2) then
462: p_rec.attribute3 :=
463: irc_idp_shd.g_old_rec.attribute3;

Line 463: irc_idp_shd.g_old_rec.attribute3;

459: irc_idp_shd.g_old_rec.attribute2;
460: End If;
461: If (p_rec.attribute3 = hr_api.g_varchar2) then
462: p_rec.attribute3 :=
463: irc_idp_shd.g_old_rec.attribute3;
464: End If;
465: If (p_rec.attribute4 = hr_api.g_varchar2) then
466: p_rec.attribute4 :=
467: irc_idp_shd.g_old_rec.attribute4;

Line 467: irc_idp_shd.g_old_rec.attribute4;

463: irc_idp_shd.g_old_rec.attribute3;
464: End If;
465: If (p_rec.attribute4 = hr_api.g_varchar2) then
466: p_rec.attribute4 :=
467: irc_idp_shd.g_old_rec.attribute4;
468: End If;
469: If (p_rec.attribute5 = hr_api.g_varchar2) then
470: p_rec.attribute5 :=
471: irc_idp_shd.g_old_rec.attribute5;

Line 471: irc_idp_shd.g_old_rec.attribute5;

467: irc_idp_shd.g_old_rec.attribute4;
468: End If;
469: If (p_rec.attribute5 = hr_api.g_varchar2) then
470: p_rec.attribute5 :=
471: irc_idp_shd.g_old_rec.attribute5;
472: End If;
473: If (p_rec.attribute6 = hr_api.g_varchar2) then
474: p_rec.attribute6 :=
475: irc_idp_shd.g_old_rec.attribute6;

Line 475: irc_idp_shd.g_old_rec.attribute6;

471: irc_idp_shd.g_old_rec.attribute5;
472: End If;
473: If (p_rec.attribute6 = hr_api.g_varchar2) then
474: p_rec.attribute6 :=
475: irc_idp_shd.g_old_rec.attribute6;
476: End If;
477: If (p_rec.attribute7 = hr_api.g_varchar2) then
478: p_rec.attribute7 :=
479: irc_idp_shd.g_old_rec.attribute7;

Line 479: irc_idp_shd.g_old_rec.attribute7;

475: irc_idp_shd.g_old_rec.attribute6;
476: End If;
477: If (p_rec.attribute7 = hr_api.g_varchar2) then
478: p_rec.attribute7 :=
479: irc_idp_shd.g_old_rec.attribute7;
480: End If;
481: If (p_rec.attribute8 = hr_api.g_varchar2) then
482: p_rec.attribute8 :=
483: irc_idp_shd.g_old_rec.attribute8;

Line 483: irc_idp_shd.g_old_rec.attribute8;

479: irc_idp_shd.g_old_rec.attribute7;
480: End If;
481: If (p_rec.attribute8 = hr_api.g_varchar2) then
482: p_rec.attribute8 :=
483: irc_idp_shd.g_old_rec.attribute8;
484: End If;
485: If (p_rec.attribute9 = hr_api.g_varchar2) then
486: p_rec.attribute9 :=
487: irc_idp_shd.g_old_rec.attribute9;

Line 487: irc_idp_shd.g_old_rec.attribute9;

483: irc_idp_shd.g_old_rec.attribute8;
484: End If;
485: If (p_rec.attribute9 = hr_api.g_varchar2) then
486: p_rec.attribute9 :=
487: irc_idp_shd.g_old_rec.attribute9;
488: End If;
489: If (p_rec.attribute10 = hr_api.g_varchar2) then
490: p_rec.attribute10 :=
491: irc_idp_shd.g_old_rec.attribute10;

Line 491: irc_idp_shd.g_old_rec.attribute10;

487: irc_idp_shd.g_old_rec.attribute9;
488: End If;
489: If (p_rec.attribute10 = hr_api.g_varchar2) then
490: p_rec.attribute10 :=
491: irc_idp_shd.g_old_rec.attribute10;
492: End If;
493: If (p_rec.attribute11 = hr_api.g_varchar2) then
494: p_rec.attribute11 :=
495: irc_idp_shd.g_old_rec.attribute11;

Line 495: irc_idp_shd.g_old_rec.attribute11;

491: irc_idp_shd.g_old_rec.attribute10;
492: End If;
493: If (p_rec.attribute11 = hr_api.g_varchar2) then
494: p_rec.attribute11 :=
495: irc_idp_shd.g_old_rec.attribute11;
496: End If;
497: If (p_rec.attribute12 = hr_api.g_varchar2) then
498: p_rec.attribute12 :=
499: irc_idp_shd.g_old_rec.attribute12;

Line 499: irc_idp_shd.g_old_rec.attribute12;

495: irc_idp_shd.g_old_rec.attribute11;
496: End If;
497: If (p_rec.attribute12 = hr_api.g_varchar2) then
498: p_rec.attribute12 :=
499: irc_idp_shd.g_old_rec.attribute12;
500: End If;
501: If (p_rec.attribute13 = hr_api.g_varchar2) then
502: p_rec.attribute13 :=
503: irc_idp_shd.g_old_rec.attribute13;

Line 503: irc_idp_shd.g_old_rec.attribute13;

499: irc_idp_shd.g_old_rec.attribute12;
500: End If;
501: If (p_rec.attribute13 = hr_api.g_varchar2) then
502: p_rec.attribute13 :=
503: irc_idp_shd.g_old_rec.attribute13;
504: End If;
505: If (p_rec.attribute14 = hr_api.g_varchar2) then
506: p_rec.attribute14 :=
507: irc_idp_shd.g_old_rec.attribute14;

Line 507: irc_idp_shd.g_old_rec.attribute14;

503: irc_idp_shd.g_old_rec.attribute13;
504: End If;
505: If (p_rec.attribute14 = hr_api.g_varchar2) then
506: p_rec.attribute14 :=
507: irc_idp_shd.g_old_rec.attribute14;
508: End If;
509: If (p_rec.attribute15 = hr_api.g_varchar2) then
510: p_rec.attribute15 :=
511: irc_idp_shd.g_old_rec.attribute15;

Line 511: irc_idp_shd.g_old_rec.attribute15;

507: irc_idp_shd.g_old_rec.attribute14;
508: End If;
509: If (p_rec.attribute15 = hr_api.g_varchar2) then
510: p_rec.attribute15 :=
511: irc_idp_shd.g_old_rec.attribute15;
512: End If;
513: If (p_rec.attribute16 = hr_api.g_varchar2) then
514: p_rec.attribute16 :=
515: irc_idp_shd.g_old_rec.attribute16;

Line 515: irc_idp_shd.g_old_rec.attribute16;

511: irc_idp_shd.g_old_rec.attribute15;
512: End If;
513: If (p_rec.attribute16 = hr_api.g_varchar2) then
514: p_rec.attribute16 :=
515: irc_idp_shd.g_old_rec.attribute16;
516: End If;
517: If (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: irc_idp_shd.g_old_rec.attribute17;

Line 519: irc_idp_shd.g_old_rec.attribute17;

515: irc_idp_shd.g_old_rec.attribute16;
516: End If;
517: If (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: irc_idp_shd.g_old_rec.attribute17;
520: End If;
521: If (p_rec.attribute18 = hr_api.g_varchar2) then
522: p_rec.attribute18 :=
523: irc_idp_shd.g_old_rec.attribute18;

Line 523: irc_idp_shd.g_old_rec.attribute18;

519: irc_idp_shd.g_old_rec.attribute17;
520: End If;
521: If (p_rec.attribute18 = hr_api.g_varchar2) then
522: p_rec.attribute18 :=
523: irc_idp_shd.g_old_rec.attribute18;
524: End If;
525: If (p_rec.attribute19 = hr_api.g_varchar2) then
526: p_rec.attribute19 :=
527: irc_idp_shd.g_old_rec.attribute19;

Line 527: irc_idp_shd.g_old_rec.attribute19;

523: irc_idp_shd.g_old_rec.attribute18;
524: End If;
525: If (p_rec.attribute19 = hr_api.g_varchar2) then
526: p_rec.attribute19 :=
527: irc_idp_shd.g_old_rec.attribute19;
528: End If;
529: If (p_rec.attribute20 = hr_api.g_varchar2) then
530: p_rec.attribute20 :=
531: irc_idp_shd.g_old_rec.attribute20;

Line 531: irc_idp_shd.g_old_rec.attribute20;

527: irc_idp_shd.g_old_rec.attribute19;
528: End If;
529: If (p_rec.attribute20 = hr_api.g_varchar2) then
530: p_rec.attribute20 :=
531: irc_idp_shd.g_old_rec.attribute20;
532: End If;
533: If (p_rec.attribute21 = hr_api.g_varchar2) then
534: p_rec.attribute21 :=
535: irc_idp_shd.g_old_rec.attribute21;

Line 535: irc_idp_shd.g_old_rec.attribute21;

531: irc_idp_shd.g_old_rec.attribute20;
532: End If;
533: If (p_rec.attribute21 = hr_api.g_varchar2) then
534: p_rec.attribute21 :=
535: irc_idp_shd.g_old_rec.attribute21;
536: End If;
537: If (p_rec.attribute22 = hr_api.g_varchar2) then
538: p_rec.attribute22 :=
539: irc_idp_shd.g_old_rec.attribute22;

Line 539: irc_idp_shd.g_old_rec.attribute22;

535: irc_idp_shd.g_old_rec.attribute21;
536: End If;
537: If (p_rec.attribute22 = hr_api.g_varchar2) then
538: p_rec.attribute22 :=
539: irc_idp_shd.g_old_rec.attribute22;
540: End If;
541: If (p_rec.attribute23 = hr_api.g_varchar2) then
542: p_rec.attribute23 :=
543: irc_idp_shd.g_old_rec.attribute23;

Line 543: irc_idp_shd.g_old_rec.attribute23;

539: irc_idp_shd.g_old_rec.attribute22;
540: End If;
541: If (p_rec.attribute23 = hr_api.g_varchar2) then
542: p_rec.attribute23 :=
543: irc_idp_shd.g_old_rec.attribute23;
544: End If;
545: If (p_rec.attribute24 = hr_api.g_varchar2) then
546: p_rec.attribute24 :=
547: irc_idp_shd.g_old_rec.attribute24;

Line 547: irc_idp_shd.g_old_rec.attribute24;

543: irc_idp_shd.g_old_rec.attribute23;
544: End If;
545: If (p_rec.attribute24 = hr_api.g_varchar2) then
546: p_rec.attribute24 :=
547: irc_idp_shd.g_old_rec.attribute24;
548: End If;
549: If (p_rec.attribute25 = hr_api.g_varchar2) then
550: p_rec.attribute25 :=
551: irc_idp_shd.g_old_rec.attribute25;

Line 551: irc_idp_shd.g_old_rec.attribute25;

547: irc_idp_shd.g_old_rec.attribute24;
548: End If;
549: If (p_rec.attribute25 = hr_api.g_varchar2) then
550: p_rec.attribute25 :=
551: irc_idp_shd.g_old_rec.attribute25;
552: End If;
553: If (p_rec.attribute26 = hr_api.g_varchar2) then
554: p_rec.attribute26 :=
555: irc_idp_shd.g_old_rec.attribute26;

Line 555: irc_idp_shd.g_old_rec.attribute26;

551: irc_idp_shd.g_old_rec.attribute25;
552: End If;
553: If (p_rec.attribute26 = hr_api.g_varchar2) then
554: p_rec.attribute26 :=
555: irc_idp_shd.g_old_rec.attribute26;
556: End If;
557: If (p_rec.attribute27 = hr_api.g_varchar2) then
558: p_rec.attribute27 :=
559: irc_idp_shd.g_old_rec.attribute27;

Line 559: irc_idp_shd.g_old_rec.attribute27;

555: irc_idp_shd.g_old_rec.attribute26;
556: End If;
557: If (p_rec.attribute27 = hr_api.g_varchar2) then
558: p_rec.attribute27 :=
559: irc_idp_shd.g_old_rec.attribute27;
560: End If;
561: If (p_rec.attribute28 = hr_api.g_varchar2) then
562: p_rec.attribute28 :=
563: irc_idp_shd.g_old_rec.attribute28;

Line 563: irc_idp_shd.g_old_rec.attribute28;

559: irc_idp_shd.g_old_rec.attribute27;
560: End If;
561: If (p_rec.attribute28 = hr_api.g_varchar2) then
562: p_rec.attribute28 :=
563: irc_idp_shd.g_old_rec.attribute28;
564: End If;
565: If (p_rec.attribute29 = hr_api.g_varchar2) then
566: p_rec.attribute29 :=
567: irc_idp_shd.g_old_rec.attribute29;

Line 567: irc_idp_shd.g_old_rec.attribute29;

563: irc_idp_shd.g_old_rec.attribute28;
564: End If;
565: If (p_rec.attribute29 = hr_api.g_varchar2) then
566: p_rec.attribute29 :=
567: irc_idp_shd.g_old_rec.attribute29;
568: End If;
569: If (p_rec.attribute30 = hr_api.g_varchar2) then
570: p_rec.attribute30 :=
571: irc_idp_shd.g_old_rec.attribute30;

Line 571: irc_idp_shd.g_old_rec.attribute30;

567: irc_idp_shd.g_old_rec.attribute29;
568: End If;
569: If (p_rec.attribute30 = hr_api.g_varchar2) then
570: p_rec.attribute30 :=
571: irc_idp_shd.g_old_rec.attribute30;
572: End If;
573: --
574: End convert_defs;
575: --

Line 580: (p_rec in out nocopy irc_idp_shd.g_rec_type

576: -- ----------------------------------------------------------------------------
577: -- |---------------------------------< upd >----------------------------------|
578: -- ----------------------------------------------------------------------------
579: Procedure upd
580: (p_rec in out nocopy irc_idp_shd.g_rec_type
581: ) is
582: --
583: l_proc varchar2(72) := g_package||'upd';
584: --

Line 590: irc_idp_shd.lck

586: hr_utility.set_location('Entering:'||l_proc, 5);
587: --
588: -- We must lock the row which we need to update.
589: --
590: irc_idp_shd.lck
591: (p_rec.default_posting_id
592: ,p_rec.object_version_number
593: );
594: --

Line 663: l_rec irc_idp_shd.g_rec_type;

659: ,p_attribute29 in varchar2 default hr_api.g_varchar2
660: ,p_attribute30 in varchar2 default hr_api.g_varchar2
661: ) is
662: --
663: l_rec irc_idp_shd.g_rec_type;
664: l_proc varchar2(72) := g_package||'upd';
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);

Line 673: irc_idp_shd.convert_args

669: -- Call conversion function to turn arguments into the
670: -- l_rec structure.
671: --
672: l_rec :=
673: irc_idp_shd.convert_args
674: (p_default_posting_id
675: ,p_position_id
676: ,p_job_id
677: ,p_attribute_category