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.PER_CNI_UPD dependencies on PER_CNI_SHD

Line 55: (p_rec in out nocopy per_cni_shd.g_rec_type

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

Line 116: per_cni_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: per_cni_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --

Line 121: per_cni_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: per_cni_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --

Line 126: per_cni_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: per_cni_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;

Line 166: (p_rec in per_cni_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_update
166: (p_rec in per_cni_shd.g_rec_type
167: ) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --

Line 211: ,p_rec in per_cni_shd.g_rec_type

207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_effective_date in date
211: ,p_rec in per_cni_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --

Line 291: => per_cni_shd.g_old_rec.configuration_code

287: => p_rec.config_information_id
288: ,p_config_sequence
289: => p_rec.config_sequence
290: ,p_configuration_code_o
291: => per_cni_shd.g_old_rec.configuration_code
292: ,p_config_information_categor_o
293: => per_cni_shd.g_old_rec.config_information_category
294: ,p_config_information1_o
295: => per_cni_shd.g_old_rec.config_information1

Line 293: => per_cni_shd.g_old_rec.config_information_category

289: => p_rec.config_sequence
290: ,p_configuration_code_o
291: => per_cni_shd.g_old_rec.configuration_code
292: ,p_config_information_categor_o
293: => per_cni_shd.g_old_rec.config_information_category
294: ,p_config_information1_o
295: => per_cni_shd.g_old_rec.config_information1
296: ,p_config_information2_o
297: => per_cni_shd.g_old_rec.config_information2

Line 295: => per_cni_shd.g_old_rec.config_information1

291: => per_cni_shd.g_old_rec.configuration_code
292: ,p_config_information_categor_o
293: => per_cni_shd.g_old_rec.config_information_category
294: ,p_config_information1_o
295: => per_cni_shd.g_old_rec.config_information1
296: ,p_config_information2_o
297: => per_cni_shd.g_old_rec.config_information2
298: ,p_config_information3_o
299: => per_cni_shd.g_old_rec.config_information3

Line 297: => per_cni_shd.g_old_rec.config_information2

293: => per_cni_shd.g_old_rec.config_information_category
294: ,p_config_information1_o
295: => per_cni_shd.g_old_rec.config_information1
296: ,p_config_information2_o
297: => per_cni_shd.g_old_rec.config_information2
298: ,p_config_information3_o
299: => per_cni_shd.g_old_rec.config_information3
300: ,p_config_information4_o
301: => per_cni_shd.g_old_rec.config_information4

Line 299: => per_cni_shd.g_old_rec.config_information3

295: => per_cni_shd.g_old_rec.config_information1
296: ,p_config_information2_o
297: => per_cni_shd.g_old_rec.config_information2
298: ,p_config_information3_o
299: => per_cni_shd.g_old_rec.config_information3
300: ,p_config_information4_o
301: => per_cni_shd.g_old_rec.config_information4
302: ,p_config_information5_o
303: => per_cni_shd.g_old_rec.config_information5

Line 301: => per_cni_shd.g_old_rec.config_information4

297: => per_cni_shd.g_old_rec.config_information2
298: ,p_config_information3_o
299: => per_cni_shd.g_old_rec.config_information3
300: ,p_config_information4_o
301: => per_cni_shd.g_old_rec.config_information4
302: ,p_config_information5_o
303: => per_cni_shd.g_old_rec.config_information5
304: ,p_config_information6_o
305: => per_cni_shd.g_old_rec.config_information6

Line 303: => per_cni_shd.g_old_rec.config_information5

299: => per_cni_shd.g_old_rec.config_information3
300: ,p_config_information4_o
301: => per_cni_shd.g_old_rec.config_information4
302: ,p_config_information5_o
303: => per_cni_shd.g_old_rec.config_information5
304: ,p_config_information6_o
305: => per_cni_shd.g_old_rec.config_information6
306: ,p_config_information7_o
307: => per_cni_shd.g_old_rec.config_information7

Line 305: => per_cni_shd.g_old_rec.config_information6

301: => per_cni_shd.g_old_rec.config_information4
302: ,p_config_information5_o
303: => per_cni_shd.g_old_rec.config_information5
304: ,p_config_information6_o
305: => per_cni_shd.g_old_rec.config_information6
306: ,p_config_information7_o
307: => per_cni_shd.g_old_rec.config_information7
308: ,p_config_information8_o
309: => per_cni_shd.g_old_rec.config_information8

Line 307: => per_cni_shd.g_old_rec.config_information7

303: => per_cni_shd.g_old_rec.config_information5
304: ,p_config_information6_o
305: => per_cni_shd.g_old_rec.config_information6
306: ,p_config_information7_o
307: => per_cni_shd.g_old_rec.config_information7
308: ,p_config_information8_o
309: => per_cni_shd.g_old_rec.config_information8
310: ,p_config_information9_o
311: => per_cni_shd.g_old_rec.config_information9

Line 309: => per_cni_shd.g_old_rec.config_information8

305: => per_cni_shd.g_old_rec.config_information6
306: ,p_config_information7_o
307: => per_cni_shd.g_old_rec.config_information7
308: ,p_config_information8_o
309: => per_cni_shd.g_old_rec.config_information8
310: ,p_config_information9_o
311: => per_cni_shd.g_old_rec.config_information9
312: ,p_config_information10_o
313: => per_cni_shd.g_old_rec.config_information10

Line 311: => per_cni_shd.g_old_rec.config_information9

307: => per_cni_shd.g_old_rec.config_information7
308: ,p_config_information8_o
309: => per_cni_shd.g_old_rec.config_information8
310: ,p_config_information9_o
311: => per_cni_shd.g_old_rec.config_information9
312: ,p_config_information10_o
313: => per_cni_shd.g_old_rec.config_information10
314: ,p_config_information11_o
315: => per_cni_shd.g_old_rec.config_information11

Line 313: => per_cni_shd.g_old_rec.config_information10

309: => per_cni_shd.g_old_rec.config_information8
310: ,p_config_information9_o
311: => per_cni_shd.g_old_rec.config_information9
312: ,p_config_information10_o
313: => per_cni_shd.g_old_rec.config_information10
314: ,p_config_information11_o
315: => per_cni_shd.g_old_rec.config_information11
316: ,p_config_information12_o
317: => per_cni_shd.g_old_rec.config_information12

Line 315: => per_cni_shd.g_old_rec.config_information11

311: => per_cni_shd.g_old_rec.config_information9
312: ,p_config_information10_o
313: => per_cni_shd.g_old_rec.config_information10
314: ,p_config_information11_o
315: => per_cni_shd.g_old_rec.config_information11
316: ,p_config_information12_o
317: => per_cni_shd.g_old_rec.config_information12
318: ,p_config_information13_o
319: => per_cni_shd.g_old_rec.config_information13

Line 317: => per_cni_shd.g_old_rec.config_information12

313: => per_cni_shd.g_old_rec.config_information10
314: ,p_config_information11_o
315: => per_cni_shd.g_old_rec.config_information11
316: ,p_config_information12_o
317: => per_cni_shd.g_old_rec.config_information12
318: ,p_config_information13_o
319: => per_cni_shd.g_old_rec.config_information13
320: ,p_config_information14_o
321: => per_cni_shd.g_old_rec.config_information14

Line 319: => per_cni_shd.g_old_rec.config_information13

315: => per_cni_shd.g_old_rec.config_information11
316: ,p_config_information12_o
317: => per_cni_shd.g_old_rec.config_information12
318: ,p_config_information13_o
319: => per_cni_shd.g_old_rec.config_information13
320: ,p_config_information14_o
321: => per_cni_shd.g_old_rec.config_information14
322: ,p_config_information15_o
323: => per_cni_shd.g_old_rec.config_information15

Line 321: => per_cni_shd.g_old_rec.config_information14

317: => per_cni_shd.g_old_rec.config_information12
318: ,p_config_information13_o
319: => per_cni_shd.g_old_rec.config_information13
320: ,p_config_information14_o
321: => per_cni_shd.g_old_rec.config_information14
322: ,p_config_information15_o
323: => per_cni_shd.g_old_rec.config_information15
324: ,p_config_information16_o
325: => per_cni_shd.g_old_rec.config_information16

Line 323: => per_cni_shd.g_old_rec.config_information15

319: => per_cni_shd.g_old_rec.config_information13
320: ,p_config_information14_o
321: => per_cni_shd.g_old_rec.config_information14
322: ,p_config_information15_o
323: => per_cni_shd.g_old_rec.config_information15
324: ,p_config_information16_o
325: => per_cni_shd.g_old_rec.config_information16
326: ,p_config_information17_o
327: => per_cni_shd.g_old_rec.config_information17

Line 325: => per_cni_shd.g_old_rec.config_information16

321: => per_cni_shd.g_old_rec.config_information14
322: ,p_config_information15_o
323: => per_cni_shd.g_old_rec.config_information15
324: ,p_config_information16_o
325: => per_cni_shd.g_old_rec.config_information16
326: ,p_config_information17_o
327: => per_cni_shd.g_old_rec.config_information17
328: ,p_config_information18_o
329: => per_cni_shd.g_old_rec.config_information18

Line 327: => per_cni_shd.g_old_rec.config_information17

323: => per_cni_shd.g_old_rec.config_information15
324: ,p_config_information16_o
325: => per_cni_shd.g_old_rec.config_information16
326: ,p_config_information17_o
327: => per_cni_shd.g_old_rec.config_information17
328: ,p_config_information18_o
329: => per_cni_shd.g_old_rec.config_information18
330: ,p_config_information19_o
331: => per_cni_shd.g_old_rec.config_information19

Line 329: => per_cni_shd.g_old_rec.config_information18

325: => per_cni_shd.g_old_rec.config_information16
326: ,p_config_information17_o
327: => per_cni_shd.g_old_rec.config_information17
328: ,p_config_information18_o
329: => per_cni_shd.g_old_rec.config_information18
330: ,p_config_information19_o
331: => per_cni_shd.g_old_rec.config_information19
332: ,p_config_information20_o
333: => per_cni_shd.g_old_rec.config_information20

Line 331: => per_cni_shd.g_old_rec.config_information19

327: => per_cni_shd.g_old_rec.config_information17
328: ,p_config_information18_o
329: => per_cni_shd.g_old_rec.config_information18
330: ,p_config_information19_o
331: => per_cni_shd.g_old_rec.config_information19
332: ,p_config_information20_o
333: => per_cni_shd.g_old_rec.config_information20
334: ,p_config_information21_o
335: => per_cni_shd.g_old_rec.config_information21

Line 333: => per_cni_shd.g_old_rec.config_information20

329: => per_cni_shd.g_old_rec.config_information18
330: ,p_config_information19_o
331: => per_cni_shd.g_old_rec.config_information19
332: ,p_config_information20_o
333: => per_cni_shd.g_old_rec.config_information20
334: ,p_config_information21_o
335: => per_cni_shd.g_old_rec.config_information21
336: ,p_config_information22_o
337: => per_cni_shd.g_old_rec.config_information22

Line 335: => per_cni_shd.g_old_rec.config_information21

331: => per_cni_shd.g_old_rec.config_information19
332: ,p_config_information20_o
333: => per_cni_shd.g_old_rec.config_information20
334: ,p_config_information21_o
335: => per_cni_shd.g_old_rec.config_information21
336: ,p_config_information22_o
337: => per_cni_shd.g_old_rec.config_information22
338: ,p_config_information23_o
339: => per_cni_shd.g_old_rec.config_information23

Line 337: => per_cni_shd.g_old_rec.config_information22

333: => per_cni_shd.g_old_rec.config_information20
334: ,p_config_information21_o
335: => per_cni_shd.g_old_rec.config_information21
336: ,p_config_information22_o
337: => per_cni_shd.g_old_rec.config_information22
338: ,p_config_information23_o
339: => per_cni_shd.g_old_rec.config_information23
340: ,p_config_information24_o
341: => per_cni_shd.g_old_rec.config_information24

Line 339: => per_cni_shd.g_old_rec.config_information23

335: => per_cni_shd.g_old_rec.config_information21
336: ,p_config_information22_o
337: => per_cni_shd.g_old_rec.config_information22
338: ,p_config_information23_o
339: => per_cni_shd.g_old_rec.config_information23
340: ,p_config_information24_o
341: => per_cni_shd.g_old_rec.config_information24
342: ,p_config_information25_o
343: => per_cni_shd.g_old_rec.config_information25

Line 341: => per_cni_shd.g_old_rec.config_information24

337: => per_cni_shd.g_old_rec.config_information22
338: ,p_config_information23_o
339: => per_cni_shd.g_old_rec.config_information23
340: ,p_config_information24_o
341: => per_cni_shd.g_old_rec.config_information24
342: ,p_config_information25_o
343: => per_cni_shd.g_old_rec.config_information25
344: ,p_config_information26_o
345: => per_cni_shd.g_old_rec.config_information26

Line 343: => per_cni_shd.g_old_rec.config_information25

339: => per_cni_shd.g_old_rec.config_information23
340: ,p_config_information24_o
341: => per_cni_shd.g_old_rec.config_information24
342: ,p_config_information25_o
343: => per_cni_shd.g_old_rec.config_information25
344: ,p_config_information26_o
345: => per_cni_shd.g_old_rec.config_information26
346: ,p_config_information27_o
347: => per_cni_shd.g_old_rec.config_information27

Line 345: => per_cni_shd.g_old_rec.config_information26

341: => per_cni_shd.g_old_rec.config_information24
342: ,p_config_information25_o
343: => per_cni_shd.g_old_rec.config_information25
344: ,p_config_information26_o
345: => per_cni_shd.g_old_rec.config_information26
346: ,p_config_information27_o
347: => per_cni_shd.g_old_rec.config_information27
348: ,p_config_information28_o
349: => per_cni_shd.g_old_rec.config_information28

Line 347: => per_cni_shd.g_old_rec.config_information27

343: => per_cni_shd.g_old_rec.config_information25
344: ,p_config_information26_o
345: => per_cni_shd.g_old_rec.config_information26
346: ,p_config_information27_o
347: => per_cni_shd.g_old_rec.config_information27
348: ,p_config_information28_o
349: => per_cni_shd.g_old_rec.config_information28
350: ,p_config_information29_o
351: => per_cni_shd.g_old_rec.config_information29

Line 349: => per_cni_shd.g_old_rec.config_information28

345: => per_cni_shd.g_old_rec.config_information26
346: ,p_config_information27_o
347: => per_cni_shd.g_old_rec.config_information27
348: ,p_config_information28_o
349: => per_cni_shd.g_old_rec.config_information28
350: ,p_config_information29_o
351: => per_cni_shd.g_old_rec.config_information29
352: ,p_config_information30_o
353: => per_cni_shd.g_old_rec.config_information30

Line 351: => per_cni_shd.g_old_rec.config_information29

347: => per_cni_shd.g_old_rec.config_information27
348: ,p_config_information28_o
349: => per_cni_shd.g_old_rec.config_information28
350: ,p_config_information29_o
351: => per_cni_shd.g_old_rec.config_information29
352: ,p_config_information30_o
353: => per_cni_shd.g_old_rec.config_information30
354: ,p_config_sequence_o
355: => per_cni_shd.g_old_rec.config_sequence

Line 353: => per_cni_shd.g_old_rec.config_information30

349: => per_cni_shd.g_old_rec.config_information28
350: ,p_config_information29_o
351: => per_cni_shd.g_old_rec.config_information29
352: ,p_config_information30_o
353: => per_cni_shd.g_old_rec.config_information30
354: ,p_config_sequence_o
355: => per_cni_shd.g_old_rec.config_sequence
356: );
357: --

Line 355: => per_cni_shd.g_old_rec.config_sequence

351: => per_cni_shd.g_old_rec.config_information29
352: ,p_config_information30_o
353: => per_cni_shd.g_old_rec.config_information30
354: ,p_config_sequence_o
355: => per_cni_shd.g_old_rec.config_sequence
356: );
357: --
358: exception
359: --

Line 415: (p_rec in out nocopy per_cni_shd.g_rec_type

411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure convert_defs
415: (p_rec in out nocopy per_cni_shd.g_rec_type
416: ) is
417: --
418: Begin
419: --

Line 427: per_cni_shd.g_old_rec.configuration_code;

423: -- is being used then we must set to the 'current' argument value.
424: --
425: If (p_rec.configuration_code = hr_api.g_varchar2) then
426: p_rec.configuration_code :=
427: per_cni_shd.g_old_rec.configuration_code;
428: End If;
429: If (p_rec.config_information_category = hr_api.g_varchar2) then
430: p_rec.config_information_category :=
431: per_cni_shd.g_old_rec.config_information_category;

Line 431: per_cni_shd.g_old_rec.config_information_category;

427: per_cni_shd.g_old_rec.configuration_code;
428: End If;
429: If (p_rec.config_information_category = hr_api.g_varchar2) then
430: p_rec.config_information_category :=
431: per_cni_shd.g_old_rec.config_information_category;
432: End If;
433: If (p_rec.config_information1 = hr_api.g_varchar2) then
434: p_rec.config_information1 :=
435: per_cni_shd.g_old_rec.config_information1;

Line 435: per_cni_shd.g_old_rec.config_information1;

431: per_cni_shd.g_old_rec.config_information_category;
432: End If;
433: If (p_rec.config_information1 = hr_api.g_varchar2) then
434: p_rec.config_information1 :=
435: per_cni_shd.g_old_rec.config_information1;
436: End If;
437: If (p_rec.config_information2 = hr_api.g_varchar2) then
438: p_rec.config_information2 :=
439: per_cni_shd.g_old_rec.config_information2;

Line 439: per_cni_shd.g_old_rec.config_information2;

435: per_cni_shd.g_old_rec.config_information1;
436: End If;
437: If (p_rec.config_information2 = hr_api.g_varchar2) then
438: p_rec.config_information2 :=
439: per_cni_shd.g_old_rec.config_information2;
440: End If;
441: If (p_rec.config_information3 = hr_api.g_varchar2) then
442: p_rec.config_information3 :=
443: per_cni_shd.g_old_rec.config_information3;

Line 443: per_cni_shd.g_old_rec.config_information3;

439: per_cni_shd.g_old_rec.config_information2;
440: End If;
441: If (p_rec.config_information3 = hr_api.g_varchar2) then
442: p_rec.config_information3 :=
443: per_cni_shd.g_old_rec.config_information3;
444: End If;
445: If (p_rec.config_information4 = hr_api.g_varchar2) then
446: p_rec.config_information4 :=
447: per_cni_shd.g_old_rec.config_information4;

Line 447: per_cni_shd.g_old_rec.config_information4;

443: per_cni_shd.g_old_rec.config_information3;
444: End If;
445: If (p_rec.config_information4 = hr_api.g_varchar2) then
446: p_rec.config_information4 :=
447: per_cni_shd.g_old_rec.config_information4;
448: End If;
449: If (p_rec.config_information5 = hr_api.g_varchar2) then
450: p_rec.config_information5 :=
451: per_cni_shd.g_old_rec.config_information5;

Line 451: per_cni_shd.g_old_rec.config_information5;

447: per_cni_shd.g_old_rec.config_information4;
448: End If;
449: If (p_rec.config_information5 = hr_api.g_varchar2) then
450: p_rec.config_information5 :=
451: per_cni_shd.g_old_rec.config_information5;
452: End If;
453: If (p_rec.config_information6 = hr_api.g_varchar2) then
454: p_rec.config_information6 :=
455: per_cni_shd.g_old_rec.config_information6;

Line 455: per_cni_shd.g_old_rec.config_information6;

451: per_cni_shd.g_old_rec.config_information5;
452: End If;
453: If (p_rec.config_information6 = hr_api.g_varchar2) then
454: p_rec.config_information6 :=
455: per_cni_shd.g_old_rec.config_information6;
456: End If;
457: If (p_rec.config_information7 = hr_api.g_varchar2) then
458: p_rec.config_information7 :=
459: per_cni_shd.g_old_rec.config_information7;

Line 459: per_cni_shd.g_old_rec.config_information7;

455: per_cni_shd.g_old_rec.config_information6;
456: End If;
457: If (p_rec.config_information7 = hr_api.g_varchar2) then
458: p_rec.config_information7 :=
459: per_cni_shd.g_old_rec.config_information7;
460: End If;
461: If (p_rec.config_information8 = hr_api.g_varchar2) then
462: p_rec.config_information8 :=
463: per_cni_shd.g_old_rec.config_information8;

Line 463: per_cni_shd.g_old_rec.config_information8;

459: per_cni_shd.g_old_rec.config_information7;
460: End If;
461: If (p_rec.config_information8 = hr_api.g_varchar2) then
462: p_rec.config_information8 :=
463: per_cni_shd.g_old_rec.config_information8;
464: End If;
465: If (p_rec.config_information9 = hr_api.g_varchar2) then
466: p_rec.config_information9 :=
467: per_cni_shd.g_old_rec.config_information9;

Line 467: per_cni_shd.g_old_rec.config_information9;

463: per_cni_shd.g_old_rec.config_information8;
464: End If;
465: If (p_rec.config_information9 = hr_api.g_varchar2) then
466: p_rec.config_information9 :=
467: per_cni_shd.g_old_rec.config_information9;
468: End If;
469: If (p_rec.config_information10 = hr_api.g_varchar2) then
470: p_rec.config_information10 :=
471: per_cni_shd.g_old_rec.config_information10;

Line 471: per_cni_shd.g_old_rec.config_information10;

467: per_cni_shd.g_old_rec.config_information9;
468: End If;
469: If (p_rec.config_information10 = hr_api.g_varchar2) then
470: p_rec.config_information10 :=
471: per_cni_shd.g_old_rec.config_information10;
472: End If;
473: If (p_rec.config_information11 = hr_api.g_varchar2) then
474: p_rec.config_information11 :=
475: per_cni_shd.g_old_rec.config_information11;

Line 475: per_cni_shd.g_old_rec.config_information11;

471: per_cni_shd.g_old_rec.config_information10;
472: End If;
473: If (p_rec.config_information11 = hr_api.g_varchar2) then
474: p_rec.config_information11 :=
475: per_cni_shd.g_old_rec.config_information11;
476: End If;
477: If (p_rec.config_information12 = hr_api.g_varchar2) then
478: p_rec.config_information12 :=
479: per_cni_shd.g_old_rec.config_information12;

Line 479: per_cni_shd.g_old_rec.config_information12;

475: per_cni_shd.g_old_rec.config_information11;
476: End If;
477: If (p_rec.config_information12 = hr_api.g_varchar2) then
478: p_rec.config_information12 :=
479: per_cni_shd.g_old_rec.config_information12;
480: End If;
481: If (p_rec.config_information13 = hr_api.g_varchar2) then
482: p_rec.config_information13 :=
483: per_cni_shd.g_old_rec.config_information13;

Line 483: per_cni_shd.g_old_rec.config_information13;

479: per_cni_shd.g_old_rec.config_information12;
480: End If;
481: If (p_rec.config_information13 = hr_api.g_varchar2) then
482: p_rec.config_information13 :=
483: per_cni_shd.g_old_rec.config_information13;
484: End If;
485: If (p_rec.config_information14 = hr_api.g_varchar2) then
486: p_rec.config_information14 :=
487: per_cni_shd.g_old_rec.config_information14;

Line 487: per_cni_shd.g_old_rec.config_information14;

483: per_cni_shd.g_old_rec.config_information13;
484: End If;
485: If (p_rec.config_information14 = hr_api.g_varchar2) then
486: p_rec.config_information14 :=
487: per_cni_shd.g_old_rec.config_information14;
488: End If;
489: If (p_rec.config_information15 = hr_api.g_varchar2) then
490: p_rec.config_information15 :=
491: per_cni_shd.g_old_rec.config_information15;

Line 491: per_cni_shd.g_old_rec.config_information15;

487: per_cni_shd.g_old_rec.config_information14;
488: End If;
489: If (p_rec.config_information15 = hr_api.g_varchar2) then
490: p_rec.config_information15 :=
491: per_cni_shd.g_old_rec.config_information15;
492: End If;
493: If (p_rec.config_information16 = hr_api.g_varchar2) then
494: p_rec.config_information16 :=
495: per_cni_shd.g_old_rec.config_information16;

Line 495: per_cni_shd.g_old_rec.config_information16;

491: per_cni_shd.g_old_rec.config_information15;
492: End If;
493: If (p_rec.config_information16 = hr_api.g_varchar2) then
494: p_rec.config_information16 :=
495: per_cni_shd.g_old_rec.config_information16;
496: End If;
497: If (p_rec.config_information17 = hr_api.g_varchar2) then
498: p_rec.config_information17 :=
499: per_cni_shd.g_old_rec.config_information17;

Line 499: per_cni_shd.g_old_rec.config_information17;

495: per_cni_shd.g_old_rec.config_information16;
496: End If;
497: If (p_rec.config_information17 = hr_api.g_varchar2) then
498: p_rec.config_information17 :=
499: per_cni_shd.g_old_rec.config_information17;
500: End If;
501: If (p_rec.config_information18 = hr_api.g_varchar2) then
502: p_rec.config_information18 :=
503: per_cni_shd.g_old_rec.config_information18;

Line 503: per_cni_shd.g_old_rec.config_information18;

499: per_cni_shd.g_old_rec.config_information17;
500: End If;
501: If (p_rec.config_information18 = hr_api.g_varchar2) then
502: p_rec.config_information18 :=
503: per_cni_shd.g_old_rec.config_information18;
504: End If;
505: If (p_rec.config_information19 = hr_api.g_varchar2) then
506: p_rec.config_information19 :=
507: per_cni_shd.g_old_rec.config_information19;

Line 507: per_cni_shd.g_old_rec.config_information19;

503: per_cni_shd.g_old_rec.config_information18;
504: End If;
505: If (p_rec.config_information19 = hr_api.g_varchar2) then
506: p_rec.config_information19 :=
507: per_cni_shd.g_old_rec.config_information19;
508: End If;
509: If (p_rec.config_information20 = hr_api.g_varchar2) then
510: p_rec.config_information20 :=
511: per_cni_shd.g_old_rec.config_information20;

Line 511: per_cni_shd.g_old_rec.config_information20;

507: per_cni_shd.g_old_rec.config_information19;
508: End If;
509: If (p_rec.config_information20 = hr_api.g_varchar2) then
510: p_rec.config_information20 :=
511: per_cni_shd.g_old_rec.config_information20;
512: End If;
513: If (p_rec.config_information21 = hr_api.g_varchar2) then
514: p_rec.config_information21 :=
515: per_cni_shd.g_old_rec.config_information21;

Line 515: per_cni_shd.g_old_rec.config_information21;

511: per_cni_shd.g_old_rec.config_information20;
512: End If;
513: If (p_rec.config_information21 = hr_api.g_varchar2) then
514: p_rec.config_information21 :=
515: per_cni_shd.g_old_rec.config_information21;
516: End If;
517: If (p_rec.config_information22 = hr_api.g_varchar2) then
518: p_rec.config_information22 :=
519: per_cni_shd.g_old_rec.config_information22;

Line 519: per_cni_shd.g_old_rec.config_information22;

515: per_cni_shd.g_old_rec.config_information21;
516: End If;
517: If (p_rec.config_information22 = hr_api.g_varchar2) then
518: p_rec.config_information22 :=
519: per_cni_shd.g_old_rec.config_information22;
520: End If;
521: If (p_rec.config_information23 = hr_api.g_varchar2) then
522: p_rec.config_information23 :=
523: per_cni_shd.g_old_rec.config_information23;

Line 523: per_cni_shd.g_old_rec.config_information23;

519: per_cni_shd.g_old_rec.config_information22;
520: End If;
521: If (p_rec.config_information23 = hr_api.g_varchar2) then
522: p_rec.config_information23 :=
523: per_cni_shd.g_old_rec.config_information23;
524: End If;
525: If (p_rec.config_information24 = hr_api.g_varchar2) then
526: p_rec.config_information24 :=
527: per_cni_shd.g_old_rec.config_information24;

Line 527: per_cni_shd.g_old_rec.config_information24;

523: per_cni_shd.g_old_rec.config_information23;
524: End If;
525: If (p_rec.config_information24 = hr_api.g_varchar2) then
526: p_rec.config_information24 :=
527: per_cni_shd.g_old_rec.config_information24;
528: End If;
529: If (p_rec.config_information25 = hr_api.g_varchar2) then
530: p_rec.config_information25 :=
531: per_cni_shd.g_old_rec.config_information25;

Line 531: per_cni_shd.g_old_rec.config_information25;

527: per_cni_shd.g_old_rec.config_information24;
528: End If;
529: If (p_rec.config_information25 = hr_api.g_varchar2) then
530: p_rec.config_information25 :=
531: per_cni_shd.g_old_rec.config_information25;
532: End If;
533: If (p_rec.config_information26 = hr_api.g_varchar2) then
534: p_rec.config_information26 :=
535: per_cni_shd.g_old_rec.config_information26;

Line 535: per_cni_shd.g_old_rec.config_information26;

531: per_cni_shd.g_old_rec.config_information25;
532: End If;
533: If (p_rec.config_information26 = hr_api.g_varchar2) then
534: p_rec.config_information26 :=
535: per_cni_shd.g_old_rec.config_information26;
536: End If;
537: If (p_rec.config_information27 = hr_api.g_varchar2) then
538: p_rec.config_information27 :=
539: per_cni_shd.g_old_rec.config_information27;

Line 539: per_cni_shd.g_old_rec.config_information27;

535: per_cni_shd.g_old_rec.config_information26;
536: End If;
537: If (p_rec.config_information27 = hr_api.g_varchar2) then
538: p_rec.config_information27 :=
539: per_cni_shd.g_old_rec.config_information27;
540: End If;
541: If (p_rec.config_information28 = hr_api.g_varchar2) then
542: p_rec.config_information28 :=
543: per_cni_shd.g_old_rec.config_information28;

Line 543: per_cni_shd.g_old_rec.config_information28;

539: per_cni_shd.g_old_rec.config_information27;
540: End If;
541: If (p_rec.config_information28 = hr_api.g_varchar2) then
542: p_rec.config_information28 :=
543: per_cni_shd.g_old_rec.config_information28;
544: End If;
545: If (p_rec.config_information29 = hr_api.g_varchar2) then
546: p_rec.config_information29 :=
547: per_cni_shd.g_old_rec.config_information29;

Line 547: per_cni_shd.g_old_rec.config_information29;

543: per_cni_shd.g_old_rec.config_information28;
544: End If;
545: If (p_rec.config_information29 = hr_api.g_varchar2) then
546: p_rec.config_information29 :=
547: per_cni_shd.g_old_rec.config_information29;
548: End If;
549: If (p_rec.config_information30 = hr_api.g_varchar2) then
550: p_rec.config_information30 :=
551: per_cni_shd.g_old_rec.config_information30;

Line 551: per_cni_shd.g_old_rec.config_information30;

547: per_cni_shd.g_old_rec.config_information29;
548: End If;
549: If (p_rec.config_information30 = hr_api.g_varchar2) then
550: p_rec.config_information30 :=
551: per_cni_shd.g_old_rec.config_information30;
552: End If;
553: If (p_rec.config_sequence = hr_api.g_number) then
554: p_rec.config_sequence :=
555: per_cni_shd.g_old_rec.config_sequence;

Line 555: per_cni_shd.g_old_rec.config_sequence;

551: per_cni_shd.g_old_rec.config_information30;
552: End If;
553: If (p_rec.config_sequence = hr_api.g_number) then
554: p_rec.config_sequence :=
555: per_cni_shd.g_old_rec.config_sequence;
556: End If;
557: --
558: End convert_defs;
559: --

Line 565: ,p_rec in out nocopy per_cni_shd.g_rec_type

561: -- |---------------------------------< upd >----------------------------------|
562: -- ----------------------------------------------------------------------------
563: Procedure upd
564: (p_effective_date in date
565: ,p_rec in out nocopy per_cni_shd.g_rec_type
566: ) is
567: --
568: l_proc varchar2(72) := g_package||'upd';
569: --

Line 575: per_cni_shd.lck

571: hr_utility.set_location('Entering:'||l_proc, 5);
572: --
573: -- We must lock the row which we need to update.
574: --
575: per_cni_shd.lck
576: (p_rec.config_information_id
577: ,p_rec.object_version_number
578: );
579: --

Line 656: l_rec per_cni_shd.g_rec_type;

652: ,p_config_information30 in varchar2 default hr_api.g_varchar2
653: ,p_object_version_number In Out Nocopy Number
654: ) is
655: --
656: l_rec per_cni_shd.g_rec_type;
657: l_proc varchar2(72) := g_package||'upd';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);

Line 666: per_cni_shd.convert_args

662: -- Call conversion function to turn arguments into the
663: -- l_rec structure.
664: --
665: l_rec :=
666: per_cni_shd.convert_args
667: (p_configuration_code
668: ,p_config_information_category
669: ,p_config_information1
670: ,p_config_information2