APPS.PQH_PLG_UPD dependencies on HR_API

Line 116: When hr_api.check_integrity_violated Then

112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: --
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pqh_plg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then

Line 119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 120: When hr_api.parent_integrity_violated Then

116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pqh_plg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: pqh_plg_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then

Line 123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 124: When hr_api.unique_integrity_violated Then

120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: pqh_plg_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: pqh_plg_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then

Line 127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 311: when hr_api.cannot_find_prog_unit then

307: );
308: --
309: exception
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'pqh_process_log'
315: ,p_hook_type => 'AU');

Line 313: hr_api.cannot_find_prog_unit_error

309: exception
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'pqh_process_log'
315: ,p_hook_type => 'AU');
316: --
317: end;

Line 381: If (p_rec.module_cd = hr_api.g_varchar2) then

377: -- p_rec plsql record structure
378: -- to see if a system default is being used. If a system default
379: -- is being used then we must set to the 'current' argument value.
380: --
381: If (p_rec.module_cd = hr_api.g_varchar2) then
382: p_rec.module_cd :=
383: pqh_plg_shd.g_old_rec.module_cd;
384: End If;
385: If (p_rec.txn_id = hr_api.g_number) then

Line 385: If (p_rec.txn_id = hr_api.g_number) then

381: If (p_rec.module_cd = hr_api.g_varchar2) then
382: p_rec.module_cd :=
383: pqh_plg_shd.g_old_rec.module_cd;
384: End If;
385: If (p_rec.txn_id = hr_api.g_number) then
386: p_rec.txn_id :=
387: pqh_plg_shd.g_old_rec.txn_id;
388: End If;
389: If (p_rec.master_process_log_id = hr_api.g_number) then

Line 389: If (p_rec.master_process_log_id = hr_api.g_number) then

385: If (p_rec.txn_id = hr_api.g_number) then
386: p_rec.txn_id :=
387: pqh_plg_shd.g_old_rec.txn_id;
388: End If;
389: If (p_rec.master_process_log_id = hr_api.g_number) then
390: p_rec.master_process_log_id :=
391: pqh_plg_shd.g_old_rec.master_process_log_id;
392: End If;
393: If (p_rec.message_text = hr_api.g_varchar2) then

Line 393: If (p_rec.message_text = hr_api.g_varchar2) then

389: If (p_rec.master_process_log_id = hr_api.g_number) then
390: p_rec.master_process_log_id :=
391: pqh_plg_shd.g_old_rec.master_process_log_id;
392: End If;
393: If (p_rec.message_text = hr_api.g_varchar2) then
394: p_rec.message_text :=
395: pqh_plg_shd.g_old_rec.message_text;
396: End If;
397: If (p_rec.message_type_cd = hr_api.g_varchar2) then

Line 397: If (p_rec.message_type_cd = hr_api.g_varchar2) then

393: If (p_rec.message_text = hr_api.g_varchar2) then
394: p_rec.message_text :=
395: pqh_plg_shd.g_old_rec.message_text;
396: End If;
397: If (p_rec.message_type_cd = hr_api.g_varchar2) then
398: p_rec.message_type_cd :=
399: pqh_plg_shd.g_old_rec.message_type_cd;
400: End If;
401: If (p_rec.batch_status = hr_api.g_varchar2) then

Line 401: If (p_rec.batch_status = hr_api.g_varchar2) then

397: If (p_rec.message_type_cd = hr_api.g_varchar2) then
398: p_rec.message_type_cd :=
399: pqh_plg_shd.g_old_rec.message_type_cd;
400: End If;
401: If (p_rec.batch_status = hr_api.g_varchar2) then
402: p_rec.batch_status :=
403: pqh_plg_shd.g_old_rec.batch_status;
404: End If;
405: If (p_rec.batch_start_date = hr_api.g_date) then

Line 405: If (p_rec.batch_start_date = hr_api.g_date) then

401: If (p_rec.batch_status = hr_api.g_varchar2) then
402: p_rec.batch_status :=
403: pqh_plg_shd.g_old_rec.batch_status;
404: End If;
405: If (p_rec.batch_start_date = hr_api.g_date) then
406: p_rec.batch_start_date :=
407: pqh_plg_shd.g_old_rec.batch_start_date;
408: End If;
409: If (p_rec.batch_end_date = hr_api.g_date) then

Line 409: If (p_rec.batch_end_date = hr_api.g_date) then

405: If (p_rec.batch_start_date = hr_api.g_date) then
406: p_rec.batch_start_date :=
407: pqh_plg_shd.g_old_rec.batch_start_date;
408: End If;
409: If (p_rec.batch_end_date = hr_api.g_date) then
410: p_rec.batch_end_date :=
411: pqh_plg_shd.g_old_rec.batch_end_date;
412: End If;
413: If (p_rec.txn_table_route_id = hr_api.g_number) then

Line 413: If (p_rec.txn_table_route_id = hr_api.g_number) then

409: If (p_rec.batch_end_date = hr_api.g_date) then
410: p_rec.batch_end_date :=
411: pqh_plg_shd.g_old_rec.batch_end_date;
412: End If;
413: If (p_rec.txn_table_route_id = hr_api.g_number) then
414: p_rec.txn_table_route_id :=
415: pqh_plg_shd.g_old_rec.txn_table_route_id;
416: End If;
417: If (p_rec.log_context = hr_api.g_varchar2) then

Line 417: If (p_rec.log_context = hr_api.g_varchar2) then

413: If (p_rec.txn_table_route_id = hr_api.g_number) then
414: p_rec.txn_table_route_id :=
415: pqh_plg_shd.g_old_rec.txn_table_route_id;
416: End If;
417: If (p_rec.log_context = hr_api.g_varchar2) then
418: p_rec.log_context :=
419: pqh_plg_shd.g_old_rec.log_context;
420: End If;
421: If (p_rec.information_category = hr_api.g_varchar2) then

Line 421: If (p_rec.information_category = hr_api.g_varchar2) then

417: If (p_rec.log_context = hr_api.g_varchar2) then
418: p_rec.log_context :=
419: pqh_plg_shd.g_old_rec.log_context;
420: End If;
421: If (p_rec.information_category = hr_api.g_varchar2) then
422: p_rec.information_category :=
423: pqh_plg_shd.g_old_rec.information_category;
424: End If;
425: If (p_rec.information1 = hr_api.g_varchar2) then

Line 425: If (p_rec.information1 = hr_api.g_varchar2) then

421: If (p_rec.information_category = hr_api.g_varchar2) then
422: p_rec.information_category :=
423: pqh_plg_shd.g_old_rec.information_category;
424: End If;
425: If (p_rec.information1 = hr_api.g_varchar2) then
426: p_rec.information1 :=
427: pqh_plg_shd.g_old_rec.information1;
428: End If;
429: If (p_rec.information2 = hr_api.g_varchar2) then

Line 429: If (p_rec.information2 = hr_api.g_varchar2) then

425: If (p_rec.information1 = hr_api.g_varchar2) then
426: p_rec.information1 :=
427: pqh_plg_shd.g_old_rec.information1;
428: End If;
429: If (p_rec.information2 = hr_api.g_varchar2) then
430: p_rec.information2 :=
431: pqh_plg_shd.g_old_rec.information2;
432: End If;
433: If (p_rec.information3 = hr_api.g_varchar2) then

Line 433: If (p_rec.information3 = hr_api.g_varchar2) then

429: If (p_rec.information2 = hr_api.g_varchar2) then
430: p_rec.information2 :=
431: pqh_plg_shd.g_old_rec.information2;
432: End If;
433: If (p_rec.information3 = hr_api.g_varchar2) then
434: p_rec.information3 :=
435: pqh_plg_shd.g_old_rec.information3;
436: End If;
437: If (p_rec.information4 = hr_api.g_varchar2) then

Line 437: If (p_rec.information4 = hr_api.g_varchar2) then

433: If (p_rec.information3 = hr_api.g_varchar2) then
434: p_rec.information3 :=
435: pqh_plg_shd.g_old_rec.information3;
436: End If;
437: If (p_rec.information4 = hr_api.g_varchar2) then
438: p_rec.information4 :=
439: pqh_plg_shd.g_old_rec.information4;
440: End If;
441: If (p_rec.information5 = hr_api.g_varchar2) then

Line 441: If (p_rec.information5 = hr_api.g_varchar2) then

437: If (p_rec.information4 = hr_api.g_varchar2) then
438: p_rec.information4 :=
439: pqh_plg_shd.g_old_rec.information4;
440: End If;
441: If (p_rec.information5 = hr_api.g_varchar2) then
442: p_rec.information5 :=
443: pqh_plg_shd.g_old_rec.information5;
444: End If;
445: If (p_rec.information6 = hr_api.g_varchar2) then

Line 445: If (p_rec.information6 = hr_api.g_varchar2) then

441: If (p_rec.information5 = hr_api.g_varchar2) then
442: p_rec.information5 :=
443: pqh_plg_shd.g_old_rec.information5;
444: End If;
445: If (p_rec.information6 = hr_api.g_varchar2) then
446: p_rec.information6 :=
447: pqh_plg_shd.g_old_rec.information6;
448: End If;
449: If (p_rec.information7 = hr_api.g_varchar2) then

Line 449: If (p_rec.information7 = hr_api.g_varchar2) then

445: If (p_rec.information6 = hr_api.g_varchar2) then
446: p_rec.information6 :=
447: pqh_plg_shd.g_old_rec.information6;
448: End If;
449: If (p_rec.information7 = hr_api.g_varchar2) then
450: p_rec.information7 :=
451: pqh_plg_shd.g_old_rec.information7;
452: End If;
453: If (p_rec.information8 = hr_api.g_varchar2) then

Line 453: If (p_rec.information8 = hr_api.g_varchar2) then

449: If (p_rec.information7 = hr_api.g_varchar2) then
450: p_rec.information7 :=
451: pqh_plg_shd.g_old_rec.information7;
452: End If;
453: If (p_rec.information8 = hr_api.g_varchar2) then
454: p_rec.information8 :=
455: pqh_plg_shd.g_old_rec.information8;
456: End If;
457: If (p_rec.information9 = hr_api.g_varchar2) then

Line 457: If (p_rec.information9 = hr_api.g_varchar2) then

453: If (p_rec.information8 = hr_api.g_varchar2) then
454: p_rec.information8 :=
455: pqh_plg_shd.g_old_rec.information8;
456: End If;
457: If (p_rec.information9 = hr_api.g_varchar2) then
458: p_rec.information9 :=
459: pqh_plg_shd.g_old_rec.information9;
460: End If;
461: If (p_rec.information10 = hr_api.g_varchar2) then

Line 461: If (p_rec.information10 = hr_api.g_varchar2) then

457: If (p_rec.information9 = hr_api.g_varchar2) then
458: p_rec.information9 :=
459: pqh_plg_shd.g_old_rec.information9;
460: End If;
461: If (p_rec.information10 = hr_api.g_varchar2) then
462: p_rec.information10 :=
463: pqh_plg_shd.g_old_rec.information10;
464: End If;
465: If (p_rec.information11 = hr_api.g_varchar2) then

Line 465: If (p_rec.information11 = hr_api.g_varchar2) then

461: If (p_rec.information10 = hr_api.g_varchar2) then
462: p_rec.information10 :=
463: pqh_plg_shd.g_old_rec.information10;
464: End If;
465: If (p_rec.information11 = hr_api.g_varchar2) then
466: p_rec.information11 :=
467: pqh_plg_shd.g_old_rec.information11;
468: End If;
469: If (p_rec.information12 = hr_api.g_varchar2) then

Line 469: If (p_rec.information12 = hr_api.g_varchar2) then

465: If (p_rec.information11 = hr_api.g_varchar2) then
466: p_rec.information11 :=
467: pqh_plg_shd.g_old_rec.information11;
468: End If;
469: If (p_rec.information12 = hr_api.g_varchar2) then
470: p_rec.information12 :=
471: pqh_plg_shd.g_old_rec.information12;
472: End If;
473: If (p_rec.information13 = hr_api.g_varchar2) then

Line 473: If (p_rec.information13 = hr_api.g_varchar2) then

469: If (p_rec.information12 = hr_api.g_varchar2) then
470: p_rec.information12 :=
471: pqh_plg_shd.g_old_rec.information12;
472: End If;
473: If (p_rec.information13 = hr_api.g_varchar2) then
474: p_rec.information13 :=
475: pqh_plg_shd.g_old_rec.information13;
476: End If;
477: If (p_rec.information14 = hr_api.g_varchar2) then

Line 477: If (p_rec.information14 = hr_api.g_varchar2) then

473: If (p_rec.information13 = hr_api.g_varchar2) then
474: p_rec.information13 :=
475: pqh_plg_shd.g_old_rec.information13;
476: End If;
477: If (p_rec.information14 = hr_api.g_varchar2) then
478: p_rec.information14 :=
479: pqh_plg_shd.g_old_rec.information14;
480: End If;
481: If (p_rec.information15 = hr_api.g_varchar2) then

Line 481: If (p_rec.information15 = hr_api.g_varchar2) then

477: If (p_rec.information14 = hr_api.g_varchar2) then
478: p_rec.information14 :=
479: pqh_plg_shd.g_old_rec.information14;
480: End If;
481: If (p_rec.information15 = hr_api.g_varchar2) then
482: p_rec.information15 :=
483: pqh_plg_shd.g_old_rec.information15;
484: End If;
485: If (p_rec.information16 = hr_api.g_varchar2) then

Line 485: If (p_rec.information16 = hr_api.g_varchar2) then

481: If (p_rec.information15 = hr_api.g_varchar2) then
482: p_rec.information15 :=
483: pqh_plg_shd.g_old_rec.information15;
484: End If;
485: If (p_rec.information16 = hr_api.g_varchar2) then
486: p_rec.information16 :=
487: pqh_plg_shd.g_old_rec.information16;
488: End If;
489: If (p_rec.information17 = hr_api.g_varchar2) then

Line 489: If (p_rec.information17 = hr_api.g_varchar2) then

485: If (p_rec.information16 = hr_api.g_varchar2) then
486: p_rec.information16 :=
487: pqh_plg_shd.g_old_rec.information16;
488: End If;
489: If (p_rec.information17 = hr_api.g_varchar2) then
490: p_rec.information17 :=
491: pqh_plg_shd.g_old_rec.information17;
492: End If;
493: If (p_rec.information18 = hr_api.g_varchar2) then

Line 493: If (p_rec.information18 = hr_api.g_varchar2) then

489: If (p_rec.information17 = hr_api.g_varchar2) then
490: p_rec.information17 :=
491: pqh_plg_shd.g_old_rec.information17;
492: End If;
493: If (p_rec.information18 = hr_api.g_varchar2) then
494: p_rec.information18 :=
495: pqh_plg_shd.g_old_rec.information18;
496: End If;
497: If (p_rec.information19 = hr_api.g_varchar2) then

Line 497: If (p_rec.information19 = hr_api.g_varchar2) then

493: If (p_rec.information18 = hr_api.g_varchar2) then
494: p_rec.information18 :=
495: pqh_plg_shd.g_old_rec.information18;
496: End If;
497: If (p_rec.information19 = hr_api.g_varchar2) then
498: p_rec.information19 :=
499: pqh_plg_shd.g_old_rec.information19;
500: End If;
501: If (p_rec.information20 = hr_api.g_varchar2) then

Line 501: If (p_rec.information20 = hr_api.g_varchar2) then

497: If (p_rec.information19 = hr_api.g_varchar2) then
498: p_rec.information19 :=
499: pqh_plg_shd.g_old_rec.information19;
500: End If;
501: If (p_rec.information20 = hr_api.g_varchar2) then
502: p_rec.information20 :=
503: pqh_plg_shd.g_old_rec.information20;
504: End If;
505: If (p_rec.information21 = hr_api.g_varchar2) then

Line 505: If (p_rec.information21 = hr_api.g_varchar2) then

501: If (p_rec.information20 = hr_api.g_varchar2) then
502: p_rec.information20 :=
503: pqh_plg_shd.g_old_rec.information20;
504: End If;
505: If (p_rec.information21 = hr_api.g_varchar2) then
506: p_rec.information21 :=
507: pqh_plg_shd.g_old_rec.information21;
508: End If;
509: If (p_rec.information22 = hr_api.g_varchar2) then

Line 509: If (p_rec.information22 = hr_api.g_varchar2) then

505: If (p_rec.information21 = hr_api.g_varchar2) then
506: p_rec.information21 :=
507: pqh_plg_shd.g_old_rec.information21;
508: End If;
509: If (p_rec.information22 = hr_api.g_varchar2) then
510: p_rec.information22 :=
511: pqh_plg_shd.g_old_rec.information22;
512: End If;
513: If (p_rec.information23 = hr_api.g_varchar2) then

Line 513: If (p_rec.information23 = hr_api.g_varchar2) then

509: If (p_rec.information22 = hr_api.g_varchar2) then
510: p_rec.information22 :=
511: pqh_plg_shd.g_old_rec.information22;
512: End If;
513: If (p_rec.information23 = hr_api.g_varchar2) then
514: p_rec.information23 :=
515: pqh_plg_shd.g_old_rec.information23;
516: End If;
517: If (p_rec.information24 = hr_api.g_varchar2) then

Line 517: If (p_rec.information24 = hr_api.g_varchar2) then

513: If (p_rec.information23 = hr_api.g_varchar2) then
514: p_rec.information23 :=
515: pqh_plg_shd.g_old_rec.information23;
516: End If;
517: If (p_rec.information24 = hr_api.g_varchar2) then
518: p_rec.information24 :=
519: pqh_plg_shd.g_old_rec.information24;
520: End If;
521: If (p_rec.information25 = hr_api.g_varchar2) then

Line 521: If (p_rec.information25 = hr_api.g_varchar2) then

517: If (p_rec.information24 = hr_api.g_varchar2) then
518: p_rec.information24 :=
519: pqh_plg_shd.g_old_rec.information24;
520: End If;
521: If (p_rec.information25 = hr_api.g_varchar2) then
522: p_rec.information25 :=
523: pqh_plg_shd.g_old_rec.information25;
524: End If;
525: If (p_rec.information26 = hr_api.g_varchar2) then

Line 525: If (p_rec.information26 = hr_api.g_varchar2) then

521: If (p_rec.information25 = hr_api.g_varchar2) then
522: p_rec.information25 :=
523: pqh_plg_shd.g_old_rec.information25;
524: End If;
525: If (p_rec.information26 = hr_api.g_varchar2) then
526: p_rec.information26 :=
527: pqh_plg_shd.g_old_rec.information26;
528: End If;
529: If (p_rec.information27 = hr_api.g_varchar2) then

Line 529: If (p_rec.information27 = hr_api.g_varchar2) then

525: If (p_rec.information26 = hr_api.g_varchar2) then
526: p_rec.information26 :=
527: pqh_plg_shd.g_old_rec.information26;
528: End If;
529: If (p_rec.information27 = hr_api.g_varchar2) then
530: p_rec.information27 :=
531: pqh_plg_shd.g_old_rec.information27;
532: End If;
533: If (p_rec.information28 = hr_api.g_varchar2) then

Line 533: If (p_rec.information28 = hr_api.g_varchar2) then

529: If (p_rec.information27 = hr_api.g_varchar2) then
530: p_rec.information27 :=
531: pqh_plg_shd.g_old_rec.information27;
532: End If;
533: If (p_rec.information28 = hr_api.g_varchar2) then
534: p_rec.information28 :=
535: pqh_plg_shd.g_old_rec.information28;
536: End If;
537: If (p_rec.information29 = hr_api.g_varchar2) then

Line 537: If (p_rec.information29 = hr_api.g_varchar2) then

533: If (p_rec.information28 = hr_api.g_varchar2) then
534: p_rec.information28 :=
535: pqh_plg_shd.g_old_rec.information28;
536: End If;
537: If (p_rec.information29 = hr_api.g_varchar2) then
538: p_rec.information29 :=
539: pqh_plg_shd.g_old_rec.information29;
540: End If;
541: If (p_rec.information30 = hr_api.g_varchar2) then

Line 541: If (p_rec.information30 = hr_api.g_varchar2) then

537: If (p_rec.information29 = hr_api.g_varchar2) then
538: p_rec.information29 :=
539: pqh_plg_shd.g_old_rec.information29;
540: End If;
541: If (p_rec.information30 = hr_api.g_varchar2) then
542: p_rec.information30 :=
543: pqh_plg_shd.g_old_rec.information30;
544: End If;
545:

Line 604: p_module_cd in varchar2 default hr_api.g_varchar2,

600: Procedure upd
601: (
602: p_effective_date in date,
603: p_process_log_id in number,
604: p_module_cd in varchar2 default hr_api.g_varchar2,
605: p_txn_id in number default hr_api.g_number,
606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,

Line 605: p_txn_id in number default hr_api.g_number,

601: (
602: p_effective_date in date,
603: p_process_log_id in number,
604: p_module_cd in varchar2 default hr_api.g_varchar2,
605: p_txn_id in number default hr_api.g_number,
606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,

Line 606: p_master_process_log_id in number default hr_api.g_number,

602: p_effective_date in date,
603: p_process_log_id in number,
604: p_module_cd in varchar2 default hr_api.g_varchar2,
605: p_txn_id in number default hr_api.g_number,
606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,

Line 607: p_message_text in varchar2 default hr_api.g_varchar2,

603: p_process_log_id in number,
604: p_module_cd in varchar2 default hr_api.g_varchar2,
605: p_txn_id in number default hr_api.g_number,
606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,

Line 608: p_message_type_cd in varchar2 default hr_api.g_varchar2,

604: p_module_cd in varchar2 default hr_api.g_varchar2,
605: p_txn_id in number default hr_api.g_number,
606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,

Line 609: p_batch_status in varchar2 default hr_api.g_varchar2,

605: p_txn_id in number default hr_api.g_number,
606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,

Line 610: p_batch_start_date in date default hr_api.g_date,

606: p_master_process_log_id in number default hr_api.g_number,
607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,

Line 611: p_batch_end_date in date default hr_api.g_date,

607: p_message_text in varchar2 default hr_api.g_varchar2,
608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,

Line 612: p_txn_table_route_id in number default hr_api.g_number,

608: p_message_type_cd in varchar2 default hr_api.g_varchar2,
609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,

Line 613: p_log_context in varchar2 default hr_api.g_varchar2,

609: p_batch_status in varchar2 default hr_api.g_varchar2,
610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,

Line 614: p_information_category in varchar2 default hr_api.g_varchar2,

610: p_batch_start_date in date default hr_api.g_date,
611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,

Line 615: p_information1 in varchar2 default hr_api.g_varchar2,

611: p_batch_end_date in date default hr_api.g_date,
612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,

Line 616: p_information2 in varchar2 default hr_api.g_varchar2,

612: p_txn_table_route_id in number default hr_api.g_number,
613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,

Line 617: p_information3 in varchar2 default hr_api.g_varchar2,

613: p_log_context in varchar2 default hr_api.g_varchar2,
614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,

Line 618: p_information4 in varchar2 default hr_api.g_varchar2,

614: p_information_category in varchar2 default hr_api.g_varchar2,
615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,

Line 619: p_information5 in varchar2 default hr_api.g_varchar2,

615: p_information1 in varchar2 default hr_api.g_varchar2,
616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,

Line 620: p_information6 in varchar2 default hr_api.g_varchar2,

616: p_information2 in varchar2 default hr_api.g_varchar2,
617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,

Line 621: p_information7 in varchar2 default hr_api.g_varchar2,

617: p_information3 in varchar2 default hr_api.g_varchar2,
618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,

Line 622: p_information8 in varchar2 default hr_api.g_varchar2,

618: p_information4 in varchar2 default hr_api.g_varchar2,
619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,

Line 623: p_information9 in varchar2 default hr_api.g_varchar2,

619: p_information5 in varchar2 default hr_api.g_varchar2,
620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,

Line 624: p_information10 in varchar2 default hr_api.g_varchar2,

620: p_information6 in varchar2 default hr_api.g_varchar2,
621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,

Line 625: p_information11 in varchar2 default hr_api.g_varchar2,

621: p_information7 in varchar2 default hr_api.g_varchar2,
622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,

Line 626: p_information12 in varchar2 default hr_api.g_varchar2,

622: p_information8 in varchar2 default hr_api.g_varchar2,
623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,

Line 627: p_information13 in varchar2 default hr_api.g_varchar2,

623: p_information9 in varchar2 default hr_api.g_varchar2,
624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,

Line 628: p_information14 in varchar2 default hr_api.g_varchar2,

624: p_information10 in varchar2 default hr_api.g_varchar2,
625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,

Line 629: p_information15 in varchar2 default hr_api.g_varchar2,

625: p_information11 in varchar2 default hr_api.g_varchar2,
626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,

Line 630: p_information16 in varchar2 default hr_api.g_varchar2,

626: p_information12 in varchar2 default hr_api.g_varchar2,
627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,

Line 631: p_information17 in varchar2 default hr_api.g_varchar2,

627: p_information13 in varchar2 default hr_api.g_varchar2,
628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,

Line 632: p_information18 in varchar2 default hr_api.g_varchar2,

628: p_information14 in varchar2 default hr_api.g_varchar2,
629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,

Line 633: p_information19 in varchar2 default hr_api.g_varchar2,

629: p_information15 in varchar2 default hr_api.g_varchar2,
630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,

Line 634: p_information20 in varchar2 default hr_api.g_varchar2,

630: p_information16 in varchar2 default hr_api.g_varchar2,
631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,

Line 635: p_information21 in varchar2 default hr_api.g_varchar2,

631: p_information17 in varchar2 default hr_api.g_varchar2,
632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,

Line 636: p_information22 in varchar2 default hr_api.g_varchar2,

632: p_information18 in varchar2 default hr_api.g_varchar2,
633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,

Line 637: p_information23 in varchar2 default hr_api.g_varchar2,

633: p_information19 in varchar2 default hr_api.g_varchar2,
634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,

Line 638: p_information24 in varchar2 default hr_api.g_varchar2,

634: p_information20 in varchar2 default hr_api.g_varchar2,
635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,

Line 639: p_information25 in varchar2 default hr_api.g_varchar2,

635: p_information21 in varchar2 default hr_api.g_varchar2,
636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,
643: p_information29 in varchar2 default hr_api.g_varchar2,

Line 640: p_information26 in varchar2 default hr_api.g_varchar2,

636: p_information22 in varchar2 default hr_api.g_varchar2,
637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,
643: p_information29 in varchar2 default hr_api.g_varchar2,
644: p_information30 in varchar2 default hr_api.g_varchar2,

Line 641: p_information27 in varchar2 default hr_api.g_varchar2,

637: p_information23 in varchar2 default hr_api.g_varchar2,
638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,
643: p_information29 in varchar2 default hr_api.g_varchar2,
644: p_information30 in varchar2 default hr_api.g_varchar2,
645: p_object_version_number in out nocopy number

Line 642: p_information28 in varchar2 default hr_api.g_varchar2,

638: p_information24 in varchar2 default hr_api.g_varchar2,
639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,
643: p_information29 in varchar2 default hr_api.g_varchar2,
644: p_information30 in varchar2 default hr_api.g_varchar2,
645: p_object_version_number in out nocopy number
646: ) is

Line 643: p_information29 in varchar2 default hr_api.g_varchar2,

639: p_information25 in varchar2 default hr_api.g_varchar2,
640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,
643: p_information29 in varchar2 default hr_api.g_varchar2,
644: p_information30 in varchar2 default hr_api.g_varchar2,
645: p_object_version_number in out nocopy number
646: ) is
647: --

Line 644: p_information30 in varchar2 default hr_api.g_varchar2,

640: p_information26 in varchar2 default hr_api.g_varchar2,
641: p_information27 in varchar2 default hr_api.g_varchar2,
642: p_information28 in varchar2 default hr_api.g_varchar2,
643: p_information29 in varchar2 default hr_api.g_varchar2,
644: p_information30 in varchar2 default hr_api.g_varchar2,
645: p_object_version_number in out nocopy number
646: ) is
647: --
648: l_rec pqh_plg_shd.g_rec_type;