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_ILP_UPD dependencies on IRC_ILP_SHD

Line 55: (p_rec in out nocopy irc_ilp_shd.g_rec_type

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

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

Line 113: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

109: ,attribute30 = p_rec.attribute30
110: ,object_version_number = p_rec.object_version_number
111: where location_pref_id = p_rec.location_pref_id;
112: --
113: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception

Line 120: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 121: irc_ilp_shd.constraint_error

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

Line 125: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 126: irc_ilp_shd.constraint_error

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

Line 130: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 131: irc_ilp_shd.constraint_error

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

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

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

Line 171: (p_rec in irc_ilp_shd.g_rec_type

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

Line 216: ,p_rec in irc_ilp_shd.g_rec_type

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

Line 306: => irc_ilp_shd.g_old_rec.object_id

302: => p_rec.attribute30
303: ,p_object_version_number
304: => p_rec.object_version_number
305: ,p_object_id_o
306: => irc_ilp_shd.g_old_rec.object_id
307: ,p_object_type_o
308: => irc_ilp_shd.g_old_rec.object_type
309: ,p_rec_area_id_o
310: => irc_ilp_shd.g_old_rec.rec_area_id

Line 308: => irc_ilp_shd.g_old_rec.object_type

304: => p_rec.object_version_number
305: ,p_object_id_o
306: => irc_ilp_shd.g_old_rec.object_id
307: ,p_object_type_o
308: => irc_ilp_shd.g_old_rec.object_type
309: ,p_rec_area_id_o
310: => irc_ilp_shd.g_old_rec.rec_area_id
311: ,p_business_group_id_o
312: => irc_ilp_shd.g_old_rec.business_group_id

Line 310: => irc_ilp_shd.g_old_rec.rec_area_id

306: => irc_ilp_shd.g_old_rec.object_id
307: ,p_object_type_o
308: => irc_ilp_shd.g_old_rec.object_type
309: ,p_rec_area_id_o
310: => irc_ilp_shd.g_old_rec.rec_area_id
311: ,p_business_group_id_o
312: => irc_ilp_shd.g_old_rec.business_group_id
313: ,p_country_code_o
314: => irc_ilp_shd.g_old_rec.country_code

Line 312: => irc_ilp_shd.g_old_rec.business_group_id

308: => irc_ilp_shd.g_old_rec.object_type
309: ,p_rec_area_id_o
310: => irc_ilp_shd.g_old_rec.rec_area_id
311: ,p_business_group_id_o
312: => irc_ilp_shd.g_old_rec.business_group_id
313: ,p_country_code_o
314: => irc_ilp_shd.g_old_rec.country_code
315: ,p_location_id_o
316: => irc_ilp_shd.g_old_rec.location_id

Line 314: => irc_ilp_shd.g_old_rec.country_code

310: => irc_ilp_shd.g_old_rec.rec_area_id
311: ,p_business_group_id_o
312: => irc_ilp_shd.g_old_rec.business_group_id
313: ,p_country_code_o
314: => irc_ilp_shd.g_old_rec.country_code
315: ,p_location_id_o
316: => irc_ilp_shd.g_old_rec.location_id
317: ,p_attribute_category_o
318: => irc_ilp_shd.g_old_rec.attribute_category

Line 316: => irc_ilp_shd.g_old_rec.location_id

312: => irc_ilp_shd.g_old_rec.business_group_id
313: ,p_country_code_o
314: => irc_ilp_shd.g_old_rec.country_code
315: ,p_location_id_o
316: => irc_ilp_shd.g_old_rec.location_id
317: ,p_attribute_category_o
318: => irc_ilp_shd.g_old_rec.attribute_category
319: ,p_attribute1_o
320: => irc_ilp_shd.g_old_rec.attribute1

Line 318: => irc_ilp_shd.g_old_rec.attribute_category

314: => irc_ilp_shd.g_old_rec.country_code
315: ,p_location_id_o
316: => irc_ilp_shd.g_old_rec.location_id
317: ,p_attribute_category_o
318: => irc_ilp_shd.g_old_rec.attribute_category
319: ,p_attribute1_o
320: => irc_ilp_shd.g_old_rec.attribute1
321: ,p_attribute2_o
322: => irc_ilp_shd.g_old_rec.attribute2

Line 320: => irc_ilp_shd.g_old_rec.attribute1

316: => irc_ilp_shd.g_old_rec.location_id
317: ,p_attribute_category_o
318: => irc_ilp_shd.g_old_rec.attribute_category
319: ,p_attribute1_o
320: => irc_ilp_shd.g_old_rec.attribute1
321: ,p_attribute2_o
322: => irc_ilp_shd.g_old_rec.attribute2
323: ,p_attribute3_o
324: => irc_ilp_shd.g_old_rec.attribute3

Line 322: => irc_ilp_shd.g_old_rec.attribute2

318: => irc_ilp_shd.g_old_rec.attribute_category
319: ,p_attribute1_o
320: => irc_ilp_shd.g_old_rec.attribute1
321: ,p_attribute2_o
322: => irc_ilp_shd.g_old_rec.attribute2
323: ,p_attribute3_o
324: => irc_ilp_shd.g_old_rec.attribute3
325: ,p_attribute4_o
326: => irc_ilp_shd.g_old_rec.attribute4

Line 324: => irc_ilp_shd.g_old_rec.attribute3

320: => irc_ilp_shd.g_old_rec.attribute1
321: ,p_attribute2_o
322: => irc_ilp_shd.g_old_rec.attribute2
323: ,p_attribute3_o
324: => irc_ilp_shd.g_old_rec.attribute3
325: ,p_attribute4_o
326: => irc_ilp_shd.g_old_rec.attribute4
327: ,p_attribute5_o
328: => irc_ilp_shd.g_old_rec.attribute5

Line 326: => irc_ilp_shd.g_old_rec.attribute4

322: => irc_ilp_shd.g_old_rec.attribute2
323: ,p_attribute3_o
324: => irc_ilp_shd.g_old_rec.attribute3
325: ,p_attribute4_o
326: => irc_ilp_shd.g_old_rec.attribute4
327: ,p_attribute5_o
328: => irc_ilp_shd.g_old_rec.attribute5
329: ,p_attribute6_o
330: => irc_ilp_shd.g_old_rec.attribute6

Line 328: => irc_ilp_shd.g_old_rec.attribute5

324: => irc_ilp_shd.g_old_rec.attribute3
325: ,p_attribute4_o
326: => irc_ilp_shd.g_old_rec.attribute4
327: ,p_attribute5_o
328: => irc_ilp_shd.g_old_rec.attribute5
329: ,p_attribute6_o
330: => irc_ilp_shd.g_old_rec.attribute6
331: ,p_attribute7_o
332: => irc_ilp_shd.g_old_rec.attribute7

Line 330: => irc_ilp_shd.g_old_rec.attribute6

326: => irc_ilp_shd.g_old_rec.attribute4
327: ,p_attribute5_o
328: => irc_ilp_shd.g_old_rec.attribute5
329: ,p_attribute6_o
330: => irc_ilp_shd.g_old_rec.attribute6
331: ,p_attribute7_o
332: => irc_ilp_shd.g_old_rec.attribute7
333: ,p_attribute8_o
334: => irc_ilp_shd.g_old_rec.attribute8

Line 332: => irc_ilp_shd.g_old_rec.attribute7

328: => irc_ilp_shd.g_old_rec.attribute5
329: ,p_attribute6_o
330: => irc_ilp_shd.g_old_rec.attribute6
331: ,p_attribute7_o
332: => irc_ilp_shd.g_old_rec.attribute7
333: ,p_attribute8_o
334: => irc_ilp_shd.g_old_rec.attribute8
335: ,p_attribute9_o
336: => irc_ilp_shd.g_old_rec.attribute9

Line 334: => irc_ilp_shd.g_old_rec.attribute8

330: => irc_ilp_shd.g_old_rec.attribute6
331: ,p_attribute7_o
332: => irc_ilp_shd.g_old_rec.attribute7
333: ,p_attribute8_o
334: => irc_ilp_shd.g_old_rec.attribute8
335: ,p_attribute9_o
336: => irc_ilp_shd.g_old_rec.attribute9
337: ,p_attribute10_o
338: => irc_ilp_shd.g_old_rec.attribute10

Line 336: => irc_ilp_shd.g_old_rec.attribute9

332: => irc_ilp_shd.g_old_rec.attribute7
333: ,p_attribute8_o
334: => irc_ilp_shd.g_old_rec.attribute8
335: ,p_attribute9_o
336: => irc_ilp_shd.g_old_rec.attribute9
337: ,p_attribute10_o
338: => irc_ilp_shd.g_old_rec.attribute10
339: ,p_attribute11_o
340: => irc_ilp_shd.g_old_rec.attribute11

Line 338: => irc_ilp_shd.g_old_rec.attribute10

334: => irc_ilp_shd.g_old_rec.attribute8
335: ,p_attribute9_o
336: => irc_ilp_shd.g_old_rec.attribute9
337: ,p_attribute10_o
338: => irc_ilp_shd.g_old_rec.attribute10
339: ,p_attribute11_o
340: => irc_ilp_shd.g_old_rec.attribute11
341: ,p_attribute12_o
342: => irc_ilp_shd.g_old_rec.attribute12

Line 340: => irc_ilp_shd.g_old_rec.attribute11

336: => irc_ilp_shd.g_old_rec.attribute9
337: ,p_attribute10_o
338: => irc_ilp_shd.g_old_rec.attribute10
339: ,p_attribute11_o
340: => irc_ilp_shd.g_old_rec.attribute11
341: ,p_attribute12_o
342: => irc_ilp_shd.g_old_rec.attribute12
343: ,p_attribute13_o
344: => irc_ilp_shd.g_old_rec.attribute13

Line 342: => irc_ilp_shd.g_old_rec.attribute12

338: => irc_ilp_shd.g_old_rec.attribute10
339: ,p_attribute11_o
340: => irc_ilp_shd.g_old_rec.attribute11
341: ,p_attribute12_o
342: => irc_ilp_shd.g_old_rec.attribute12
343: ,p_attribute13_o
344: => irc_ilp_shd.g_old_rec.attribute13
345: ,p_attribute14_o
346: => irc_ilp_shd.g_old_rec.attribute14

Line 344: => irc_ilp_shd.g_old_rec.attribute13

340: => irc_ilp_shd.g_old_rec.attribute11
341: ,p_attribute12_o
342: => irc_ilp_shd.g_old_rec.attribute12
343: ,p_attribute13_o
344: => irc_ilp_shd.g_old_rec.attribute13
345: ,p_attribute14_o
346: => irc_ilp_shd.g_old_rec.attribute14
347: ,p_attribute15_o
348: => irc_ilp_shd.g_old_rec.attribute15

Line 346: => irc_ilp_shd.g_old_rec.attribute14

342: => irc_ilp_shd.g_old_rec.attribute12
343: ,p_attribute13_o
344: => irc_ilp_shd.g_old_rec.attribute13
345: ,p_attribute14_o
346: => irc_ilp_shd.g_old_rec.attribute14
347: ,p_attribute15_o
348: => irc_ilp_shd.g_old_rec.attribute15
349: ,p_attribute16_o
350: => irc_ilp_shd.g_old_rec.attribute16

Line 348: => irc_ilp_shd.g_old_rec.attribute15

344: => irc_ilp_shd.g_old_rec.attribute13
345: ,p_attribute14_o
346: => irc_ilp_shd.g_old_rec.attribute14
347: ,p_attribute15_o
348: => irc_ilp_shd.g_old_rec.attribute15
349: ,p_attribute16_o
350: => irc_ilp_shd.g_old_rec.attribute16
351: ,p_attribute17_o
352: => irc_ilp_shd.g_old_rec.attribute17

Line 350: => irc_ilp_shd.g_old_rec.attribute16

346: => irc_ilp_shd.g_old_rec.attribute14
347: ,p_attribute15_o
348: => irc_ilp_shd.g_old_rec.attribute15
349: ,p_attribute16_o
350: => irc_ilp_shd.g_old_rec.attribute16
351: ,p_attribute17_o
352: => irc_ilp_shd.g_old_rec.attribute17
353: ,p_attribute18_o
354: => irc_ilp_shd.g_old_rec.attribute18

Line 352: => irc_ilp_shd.g_old_rec.attribute17

348: => irc_ilp_shd.g_old_rec.attribute15
349: ,p_attribute16_o
350: => irc_ilp_shd.g_old_rec.attribute16
351: ,p_attribute17_o
352: => irc_ilp_shd.g_old_rec.attribute17
353: ,p_attribute18_o
354: => irc_ilp_shd.g_old_rec.attribute18
355: ,p_attribute19_o
356: => irc_ilp_shd.g_old_rec.attribute19

Line 354: => irc_ilp_shd.g_old_rec.attribute18

350: => irc_ilp_shd.g_old_rec.attribute16
351: ,p_attribute17_o
352: => irc_ilp_shd.g_old_rec.attribute17
353: ,p_attribute18_o
354: => irc_ilp_shd.g_old_rec.attribute18
355: ,p_attribute19_o
356: => irc_ilp_shd.g_old_rec.attribute19
357: ,p_attribute20_o
358: => irc_ilp_shd.g_old_rec.attribute20

Line 356: => irc_ilp_shd.g_old_rec.attribute19

352: => irc_ilp_shd.g_old_rec.attribute17
353: ,p_attribute18_o
354: => irc_ilp_shd.g_old_rec.attribute18
355: ,p_attribute19_o
356: => irc_ilp_shd.g_old_rec.attribute19
357: ,p_attribute20_o
358: => irc_ilp_shd.g_old_rec.attribute20
359: ,p_attribute21_o
360: => irc_ilp_shd.g_old_rec.attribute21

Line 358: => irc_ilp_shd.g_old_rec.attribute20

354: => irc_ilp_shd.g_old_rec.attribute18
355: ,p_attribute19_o
356: => irc_ilp_shd.g_old_rec.attribute19
357: ,p_attribute20_o
358: => irc_ilp_shd.g_old_rec.attribute20
359: ,p_attribute21_o
360: => irc_ilp_shd.g_old_rec.attribute21
361: ,p_attribute22_o
362: => irc_ilp_shd.g_old_rec.attribute22

Line 360: => irc_ilp_shd.g_old_rec.attribute21

356: => irc_ilp_shd.g_old_rec.attribute19
357: ,p_attribute20_o
358: => irc_ilp_shd.g_old_rec.attribute20
359: ,p_attribute21_o
360: => irc_ilp_shd.g_old_rec.attribute21
361: ,p_attribute22_o
362: => irc_ilp_shd.g_old_rec.attribute22
363: ,p_attribute23_o
364: => irc_ilp_shd.g_old_rec.attribute23

Line 362: => irc_ilp_shd.g_old_rec.attribute22

358: => irc_ilp_shd.g_old_rec.attribute20
359: ,p_attribute21_o
360: => irc_ilp_shd.g_old_rec.attribute21
361: ,p_attribute22_o
362: => irc_ilp_shd.g_old_rec.attribute22
363: ,p_attribute23_o
364: => irc_ilp_shd.g_old_rec.attribute23
365: ,p_attribute24_o
366: => irc_ilp_shd.g_old_rec.attribute24

Line 364: => irc_ilp_shd.g_old_rec.attribute23

360: => irc_ilp_shd.g_old_rec.attribute21
361: ,p_attribute22_o
362: => irc_ilp_shd.g_old_rec.attribute22
363: ,p_attribute23_o
364: => irc_ilp_shd.g_old_rec.attribute23
365: ,p_attribute24_o
366: => irc_ilp_shd.g_old_rec.attribute24
367: ,p_attribute25_o
368: => irc_ilp_shd.g_old_rec.attribute25

Line 366: => irc_ilp_shd.g_old_rec.attribute24

362: => irc_ilp_shd.g_old_rec.attribute22
363: ,p_attribute23_o
364: => irc_ilp_shd.g_old_rec.attribute23
365: ,p_attribute24_o
366: => irc_ilp_shd.g_old_rec.attribute24
367: ,p_attribute25_o
368: => irc_ilp_shd.g_old_rec.attribute25
369: ,p_attribute26_o
370: => irc_ilp_shd.g_old_rec.attribute26

Line 368: => irc_ilp_shd.g_old_rec.attribute25

364: => irc_ilp_shd.g_old_rec.attribute23
365: ,p_attribute24_o
366: => irc_ilp_shd.g_old_rec.attribute24
367: ,p_attribute25_o
368: => irc_ilp_shd.g_old_rec.attribute25
369: ,p_attribute26_o
370: => irc_ilp_shd.g_old_rec.attribute26
371: ,p_attribute27_o
372: => irc_ilp_shd.g_old_rec.attribute27

Line 370: => irc_ilp_shd.g_old_rec.attribute26

366: => irc_ilp_shd.g_old_rec.attribute24
367: ,p_attribute25_o
368: => irc_ilp_shd.g_old_rec.attribute25
369: ,p_attribute26_o
370: => irc_ilp_shd.g_old_rec.attribute26
371: ,p_attribute27_o
372: => irc_ilp_shd.g_old_rec.attribute27
373: ,p_attribute28_o
374: => irc_ilp_shd.g_old_rec.attribute28

Line 372: => irc_ilp_shd.g_old_rec.attribute27

368: => irc_ilp_shd.g_old_rec.attribute25
369: ,p_attribute26_o
370: => irc_ilp_shd.g_old_rec.attribute26
371: ,p_attribute27_o
372: => irc_ilp_shd.g_old_rec.attribute27
373: ,p_attribute28_o
374: => irc_ilp_shd.g_old_rec.attribute28
375: ,p_attribute29_o
376: => irc_ilp_shd.g_old_rec.attribute29

Line 374: => irc_ilp_shd.g_old_rec.attribute28

370: => irc_ilp_shd.g_old_rec.attribute26
371: ,p_attribute27_o
372: => irc_ilp_shd.g_old_rec.attribute27
373: ,p_attribute28_o
374: => irc_ilp_shd.g_old_rec.attribute28
375: ,p_attribute29_o
376: => irc_ilp_shd.g_old_rec.attribute29
377: ,p_attribute30_o
378: => irc_ilp_shd.g_old_rec.attribute30

Line 376: => irc_ilp_shd.g_old_rec.attribute29

372: => irc_ilp_shd.g_old_rec.attribute27
373: ,p_attribute28_o
374: => irc_ilp_shd.g_old_rec.attribute28
375: ,p_attribute29_o
376: => irc_ilp_shd.g_old_rec.attribute29
377: ,p_attribute30_o
378: => irc_ilp_shd.g_old_rec.attribute30
379: ,p_object_version_number_o
380: => irc_ilp_shd.g_old_rec.object_version_number

Line 378: => irc_ilp_shd.g_old_rec.attribute30

374: => irc_ilp_shd.g_old_rec.attribute28
375: ,p_attribute29_o
376: => irc_ilp_shd.g_old_rec.attribute29
377: ,p_attribute30_o
378: => irc_ilp_shd.g_old_rec.attribute30
379: ,p_object_version_number_o
380: => irc_ilp_shd.g_old_rec.object_version_number
381: );
382: --

Line 380: => irc_ilp_shd.g_old_rec.object_version_number

376: => irc_ilp_shd.g_old_rec.attribute29
377: ,p_attribute30_o
378: => irc_ilp_shd.g_old_rec.attribute30
379: ,p_object_version_number_o
380: => irc_ilp_shd.g_old_rec.object_version_number
381: );
382: --
383: exception
384: --

Line 440: (p_rec in out nocopy irc_ilp_shd.g_rec_type

436: --
437: -- {End Of Comments}
438: -- ----------------------------------------------------------------------------
439: Procedure convert_defs
440: (p_rec in out nocopy irc_ilp_shd.g_rec_type
441: ) is
442: --
443: Begin
444: --

Line 452: irc_ilp_shd.g_old_rec.object_id;

448: -- is being used then we must set to the 'current' argument value.
449: --
450: If (p_rec.object_id = hr_api.g_number) then
451: p_rec.object_id :=
452: irc_ilp_shd.g_old_rec.object_id;
453: End If;
454: If (p_rec.object_type = hr_api.g_varchar2) then
455: p_rec.object_type :=
456: irc_ilp_shd.g_old_rec.object_type;

Line 456: irc_ilp_shd.g_old_rec.object_type;

452: irc_ilp_shd.g_old_rec.object_id;
453: End If;
454: If (p_rec.object_type = hr_api.g_varchar2) then
455: p_rec.object_type :=
456: irc_ilp_shd.g_old_rec.object_type;
457: End If;
458: If (p_rec.rec_area_id = hr_api.g_number) then
459: p_rec.rec_area_id :=
460: irc_ilp_shd.g_old_rec.rec_area_id;

Line 460: irc_ilp_shd.g_old_rec.rec_area_id;

456: irc_ilp_shd.g_old_rec.object_type;
457: End If;
458: If (p_rec.rec_area_id = hr_api.g_number) then
459: p_rec.rec_area_id :=
460: irc_ilp_shd.g_old_rec.rec_area_id;
461: End If;
462: If (p_rec.business_group_id = hr_api.g_number) then
463: p_rec.business_group_id :=
464: irc_ilp_shd.g_old_rec.business_group_id;

Line 464: irc_ilp_shd.g_old_rec.business_group_id;

460: irc_ilp_shd.g_old_rec.rec_area_id;
461: End If;
462: If (p_rec.business_group_id = hr_api.g_number) then
463: p_rec.business_group_id :=
464: irc_ilp_shd.g_old_rec.business_group_id;
465: End If;
466: If (p_rec.country_code = hr_api.g_varchar2) then
467: p_rec.country_code :=
468: irc_ilp_shd.g_old_rec.country_code;

Line 468: irc_ilp_shd.g_old_rec.country_code;

464: irc_ilp_shd.g_old_rec.business_group_id;
465: End If;
466: If (p_rec.country_code = hr_api.g_varchar2) then
467: p_rec.country_code :=
468: irc_ilp_shd.g_old_rec.country_code;
469: End If;
470: If (p_rec.location_id = hr_api.g_number) then
471: p_rec.location_id :=
472: irc_ilp_shd.g_old_rec.location_id;

Line 472: irc_ilp_shd.g_old_rec.location_id;

468: irc_ilp_shd.g_old_rec.country_code;
469: End If;
470: If (p_rec.location_id = hr_api.g_number) then
471: p_rec.location_id :=
472: irc_ilp_shd.g_old_rec.location_id;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: irc_ilp_shd.g_old_rec.attribute_category;

Line 476: irc_ilp_shd.g_old_rec.attribute_category;

472: irc_ilp_shd.g_old_rec.location_id;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: irc_ilp_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: irc_ilp_shd.g_old_rec.attribute1;

Line 480: irc_ilp_shd.g_old_rec.attribute1;

476: irc_ilp_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: irc_ilp_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: irc_ilp_shd.g_old_rec.attribute2;

Line 484: irc_ilp_shd.g_old_rec.attribute2;

480: irc_ilp_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: irc_ilp_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: irc_ilp_shd.g_old_rec.attribute3;

Line 488: irc_ilp_shd.g_old_rec.attribute3;

484: irc_ilp_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: irc_ilp_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: irc_ilp_shd.g_old_rec.attribute4;

Line 492: irc_ilp_shd.g_old_rec.attribute4;

488: irc_ilp_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: irc_ilp_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: irc_ilp_shd.g_old_rec.attribute5;

Line 496: irc_ilp_shd.g_old_rec.attribute5;

492: irc_ilp_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: irc_ilp_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: irc_ilp_shd.g_old_rec.attribute6;

Line 500: irc_ilp_shd.g_old_rec.attribute6;

496: irc_ilp_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: irc_ilp_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: irc_ilp_shd.g_old_rec.attribute7;

Line 504: irc_ilp_shd.g_old_rec.attribute7;

500: irc_ilp_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: irc_ilp_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: irc_ilp_shd.g_old_rec.attribute8;

Line 508: irc_ilp_shd.g_old_rec.attribute8;

504: irc_ilp_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: irc_ilp_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: irc_ilp_shd.g_old_rec.attribute9;

Line 512: irc_ilp_shd.g_old_rec.attribute9;

508: irc_ilp_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: irc_ilp_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: irc_ilp_shd.g_old_rec.attribute10;

Line 516: irc_ilp_shd.g_old_rec.attribute10;

512: irc_ilp_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: irc_ilp_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: irc_ilp_shd.g_old_rec.attribute11;

Line 520: irc_ilp_shd.g_old_rec.attribute11;

516: irc_ilp_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: irc_ilp_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: irc_ilp_shd.g_old_rec.attribute12;

Line 524: irc_ilp_shd.g_old_rec.attribute12;

520: irc_ilp_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: irc_ilp_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: irc_ilp_shd.g_old_rec.attribute13;

Line 528: irc_ilp_shd.g_old_rec.attribute13;

524: irc_ilp_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: irc_ilp_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: irc_ilp_shd.g_old_rec.attribute14;

Line 532: irc_ilp_shd.g_old_rec.attribute14;

528: irc_ilp_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: irc_ilp_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: irc_ilp_shd.g_old_rec.attribute15;

Line 536: irc_ilp_shd.g_old_rec.attribute15;

532: irc_ilp_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: irc_ilp_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: irc_ilp_shd.g_old_rec.attribute16;

Line 540: irc_ilp_shd.g_old_rec.attribute16;

536: irc_ilp_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: irc_ilp_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: irc_ilp_shd.g_old_rec.attribute17;

Line 544: irc_ilp_shd.g_old_rec.attribute17;

540: irc_ilp_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: irc_ilp_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: irc_ilp_shd.g_old_rec.attribute18;

Line 548: irc_ilp_shd.g_old_rec.attribute18;

544: irc_ilp_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: irc_ilp_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: irc_ilp_shd.g_old_rec.attribute19;

Line 552: irc_ilp_shd.g_old_rec.attribute19;

548: irc_ilp_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: irc_ilp_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: irc_ilp_shd.g_old_rec.attribute20;

Line 556: irc_ilp_shd.g_old_rec.attribute20;

552: irc_ilp_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: irc_ilp_shd.g_old_rec.attribute20;
557: End If;
558: If (p_rec.attribute21 = hr_api.g_varchar2) then
559: p_rec.attribute21 :=
560: irc_ilp_shd.g_old_rec.attribute21;

Line 560: irc_ilp_shd.g_old_rec.attribute21;

556: irc_ilp_shd.g_old_rec.attribute20;
557: End If;
558: If (p_rec.attribute21 = hr_api.g_varchar2) then
559: p_rec.attribute21 :=
560: irc_ilp_shd.g_old_rec.attribute21;
561: End If;
562: If (p_rec.attribute22 = hr_api.g_varchar2) then
563: p_rec.attribute22 :=
564: irc_ilp_shd.g_old_rec.attribute22;

Line 564: irc_ilp_shd.g_old_rec.attribute22;

560: irc_ilp_shd.g_old_rec.attribute21;
561: End If;
562: If (p_rec.attribute22 = hr_api.g_varchar2) then
563: p_rec.attribute22 :=
564: irc_ilp_shd.g_old_rec.attribute22;
565: End If;
566: If (p_rec.attribute23 = hr_api.g_varchar2) then
567: p_rec.attribute23 :=
568: irc_ilp_shd.g_old_rec.attribute23;

Line 568: irc_ilp_shd.g_old_rec.attribute23;

564: irc_ilp_shd.g_old_rec.attribute22;
565: End If;
566: If (p_rec.attribute23 = hr_api.g_varchar2) then
567: p_rec.attribute23 :=
568: irc_ilp_shd.g_old_rec.attribute23;
569: End If;
570: If (p_rec.attribute24 = hr_api.g_varchar2) then
571: p_rec.attribute24 :=
572: irc_ilp_shd.g_old_rec.attribute24;

Line 572: irc_ilp_shd.g_old_rec.attribute24;

568: irc_ilp_shd.g_old_rec.attribute23;
569: End If;
570: If (p_rec.attribute24 = hr_api.g_varchar2) then
571: p_rec.attribute24 :=
572: irc_ilp_shd.g_old_rec.attribute24;
573: End If;
574: If (p_rec.attribute25 = hr_api.g_varchar2) then
575: p_rec.attribute25 :=
576: irc_ilp_shd.g_old_rec.attribute25;

Line 576: irc_ilp_shd.g_old_rec.attribute25;

572: irc_ilp_shd.g_old_rec.attribute24;
573: End If;
574: If (p_rec.attribute25 = hr_api.g_varchar2) then
575: p_rec.attribute25 :=
576: irc_ilp_shd.g_old_rec.attribute25;
577: End If;
578: If (p_rec.attribute26 = hr_api.g_varchar2) then
579: p_rec.attribute26 :=
580: irc_ilp_shd.g_old_rec.attribute26;

Line 580: irc_ilp_shd.g_old_rec.attribute26;

576: irc_ilp_shd.g_old_rec.attribute25;
577: End If;
578: If (p_rec.attribute26 = hr_api.g_varchar2) then
579: p_rec.attribute26 :=
580: irc_ilp_shd.g_old_rec.attribute26;
581: End If;
582: If (p_rec.attribute27 = hr_api.g_varchar2) then
583: p_rec.attribute27 :=
584: irc_ilp_shd.g_old_rec.attribute27;

Line 584: irc_ilp_shd.g_old_rec.attribute27;

580: irc_ilp_shd.g_old_rec.attribute26;
581: End If;
582: If (p_rec.attribute27 = hr_api.g_varchar2) then
583: p_rec.attribute27 :=
584: irc_ilp_shd.g_old_rec.attribute27;
585: End If;
586: If (p_rec.attribute28 = hr_api.g_varchar2) then
587: p_rec.attribute28 :=
588: irc_ilp_shd.g_old_rec.attribute28;

Line 588: irc_ilp_shd.g_old_rec.attribute28;

584: irc_ilp_shd.g_old_rec.attribute27;
585: End If;
586: If (p_rec.attribute28 = hr_api.g_varchar2) then
587: p_rec.attribute28 :=
588: irc_ilp_shd.g_old_rec.attribute28;
589: End If;
590: If (p_rec.attribute29 = hr_api.g_varchar2) then
591: p_rec.attribute29 :=
592: irc_ilp_shd.g_old_rec.attribute29;

Line 592: irc_ilp_shd.g_old_rec.attribute29;

588: irc_ilp_shd.g_old_rec.attribute28;
589: End If;
590: If (p_rec.attribute29 = hr_api.g_varchar2) then
591: p_rec.attribute29 :=
592: irc_ilp_shd.g_old_rec.attribute29;
593: End If;
594: If (p_rec.attribute30 = hr_api.g_varchar2) then
595: p_rec.attribute30 :=
596: irc_ilp_shd.g_old_rec.attribute30;

Line 596: irc_ilp_shd.g_old_rec.attribute30;

592: irc_ilp_shd.g_old_rec.attribute29;
593: End If;
594: If (p_rec.attribute30 = hr_api.g_varchar2) then
595: p_rec.attribute30 :=
596: irc_ilp_shd.g_old_rec.attribute30;
597: End If;
598: --
599: End convert_defs;
600: --

Line 606: ,p_rec in out nocopy irc_ilp_shd.g_rec_type

602: -- |---------------------------------< upd >----------------------------------|
603: -- ----------------------------------------------------------------------------
604: Procedure upd
605: (p_effective_date in date
606: ,p_rec in out nocopy irc_ilp_shd.g_rec_type
607: ) is
608: --
609: l_proc varchar2(72) := g_package||'upd';
610: --

Line 616: irc_ilp_shd.lck

612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- We must lock the row which we need to update.
615: --
616: irc_ilp_shd.lck
617: (p_rec.location_pref_id
618: ,p_rec.object_version_number
619: );
620: --

Line 701: l_rec irc_ilp_shd.g_rec_type;

697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
699: ) is
700: --
701: l_rec irc_ilp_shd.g_rec_type;
702: l_proc varchar2(72) := g_package||'upd';
703: --
704: Begin
705: hr_utility.set_location('Entering:'||l_proc, 5);

Line 711: irc_ilp_shd.convert_args

707: -- Call conversion function to turn arguments into the
708: -- l_rec structure.
709: --
710: l_rec :=
711: irc_ilp_shd.convert_args
712: (p_location_pref_id
713: ,p_object_id
714: ,p_object_type
715: ,p_rec_area_id