1: package body PER_STARTUP_PERSON_TYPES_PKG as
2: /* $Header: pespt01t.pkb 115.21 2003/10/27 07:07:36 skota ship $ */
3:
4: procedure POPULATE_KEY (
5: p_seeded_person_type_key in varchar2,
513:
514: PROCEDURE data_upgrade
515: is
516: begin
517: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
518: p_seeded_person_type_key => 'EXTERNAL'
519: ,p_user_person_type => 'External'
520: ,p_system_person_type => 'OTHER');
521: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
517: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
518: p_seeded_person_type_key => 'EXTERNAL'
519: ,p_user_person_type => 'External'
520: ,p_system_person_type => 'OTHER');
521: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
522: p_seeded_person_type_key => 'CONTACT'
523: ,p_user_person_type => 'Contact'
524: ,p_system_person_type => 'OTHER');
525: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
521: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
522: p_seeded_person_type_key => 'CONTACT'
523: ,p_user_person_type => 'Contact'
524: ,p_system_person_type => 'OTHER');
525: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
526: p_seeded_person_type_key => 'EMPLOYEE'
527: ,p_user_person_type => 'Employee'
528: ,p_system_person_type => 'EMP');
529: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
525: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
526: p_seeded_person_type_key => 'EMPLOYEE'
527: ,p_user_person_type => 'Employee'
528: ,p_system_person_type => 'EMP');
529: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
530: p_seeded_person_type_key => 'APPLICANT'
531: ,p_user_person_type => 'Applicant'
532: ,p_system_person_type => 'APL');
533: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
529: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
530: p_seeded_person_type_key => 'APPLICANT'
531: ,p_user_person_type => 'Applicant'
532: ,p_system_person_type => 'APL');
533: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
534: p_seeded_person_type_key => 'APL_EX_APL'
535: ,p_user_person_type => 'Applicant and Ex-applicant'
536: ,p_system_person_type => 'APL_EX_APL');
537: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
533: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
534: p_seeded_person_type_key => 'APL_EX_APL'
535: ,p_user_person_type => 'Applicant and Ex-applicant'
536: ,p_system_person_type => 'APL_EX_APL');
537: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
538: p_seeded_person_type_key => 'BENEFICIARY'
539: ,p_user_person_type => 'Beneficiary'
540: ,p_system_person_type => 'BNF');
541: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
537: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
538: p_seeded_person_type_key => 'BENEFICIARY'
539: ,p_user_person_type => 'Beneficiary'
540: ,p_system_person_type => 'BNF');
541: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
542: p_seeded_person_type_key => 'DEPENDENT'
543: ,p_user_person_type => 'Dependent'
544: ,p_system_person_type => 'DPNT');
545: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
541: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
542: p_seeded_person_type_key => 'DEPENDENT'
543: ,p_user_person_type => 'Dependent'
544: ,p_system_person_type => 'DPNT');
545: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
546: p_seeded_person_type_key => 'EMP_APL'
547: ,p_user_person_type => 'Employee and Applicant'
548: ,p_system_person_type => 'EMP_APL');
549: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
545: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
546: p_seeded_person_type_key => 'EMP_APL'
547: ,p_user_person_type => 'Employee and Applicant'
548: ,p_system_person_type => 'EMP_APL');
549: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
550: p_seeded_person_type_key => 'EX_APL'
551: ,p_user_person_type => 'Ex-applicant'
552: ,p_system_person_type => 'EX_APL');
553: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
549: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
550: p_seeded_person_type_key => 'EX_APL'
551: ,p_user_person_type => 'Ex-applicant'
552: ,p_system_person_type => 'EX_APL');
553: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
554: p_seeded_person_type_key => 'EX_EMP'
555: ,p_user_person_type => 'Ex-employee'
556: ,p_system_person_type => 'EX_EMP');
557: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
553: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
554: p_seeded_person_type_key => 'EX_EMP'
555: ,p_user_person_type => 'Ex-employee'
556: ,p_system_person_type => 'EX_EMP');
557: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
558: p_seeded_person_type_key => 'EX_EMP_APL'
559: ,p_user_person_type => 'Ex-employee and Applicant'
560: ,p_system_person_type => 'EX_EMP_APL');
561: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
557: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
558: p_seeded_person_type_key => 'EX_EMP_APL'
559: ,p_user_person_type => 'Ex-employee and Applicant'
560: ,p_system_person_type => 'EX_EMP_APL');
561: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
562: p_seeded_person_type_key => 'FRMR_FMLY_MMBR'
563: ,p_user_person_type => 'Former Family Member'
564: ,p_system_person_type => 'FRMR_FMLY_MMBR');
565: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
561: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
562: p_seeded_person_type_key => 'FRMR_FMLY_MMBR'
563: ,p_user_person_type => 'Former Family Member'
564: ,p_system_person_type => 'FRMR_FMLY_MMBR');
565: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
566: p_seeded_person_type_key => 'FRMR_SPS'
567: ,p_user_person_type => 'Former Spouse'
568: ,p_system_person_type => 'FRMR_SPS');
569: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
565: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
566: p_seeded_person_type_key => 'FRMR_SPS'
567: ,p_user_person_type => 'Former Spouse'
568: ,p_system_person_type => 'FRMR_SPS');
569: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
570: p_seeded_person_type_key => 'PARTICIPANT'
571: ,p_user_person_type => 'Participant'
572: ,p_system_person_type => 'PRTN');
573: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
569: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
570: p_seeded_person_type_key => 'PARTICIPANT'
571: ,p_user_person_type => 'Participant'
572: ,p_system_person_type => 'PRTN');
573: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
574: p_seeded_person_type_key => 'RETIREE'
575: ,p_user_person_type => 'Retiree'
576: ,p_system_person_type => 'RETIREE');
577: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
573: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
574: p_seeded_person_type_key => 'RETIREE'
575: ,p_user_person_type => 'Retiree'
576: ,p_system_person_type => 'RETIREE');
577: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
578: p_seeded_person_type_key => 'SRVNG_FMLY_MMBR'
579: ,p_user_person_type => 'Surviving Family Member'
580: ,p_system_person_type => 'SRVNG_FMLY_MMBR');
581: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
577: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
578: p_seeded_person_type_key => 'SRVNG_FMLY_MMBR'
579: ,p_user_person_type => 'Surviving Family Member'
580: ,p_system_person_type => 'SRVNG_FMLY_MMBR');
581: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
582: p_seeded_person_type_key => 'SRVNG_SPS'
583: ,p_user_person_type => 'Surviving Spouse'
584: ,p_system_person_type => 'SRVNG_SPS');
585: /*PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
581: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
582: p_seeded_person_type_key => 'SRVNG_SPS'
583: ,p_user_person_type => 'Surviving Spouse'
584: ,p_system_person_type => 'SRVNG_SPS');
585: /*PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
586: p_seeded_person_type_key => 'EX_CWK'
587: ,p_user_person_type => 'Ex-Contingent Worker'
588: ,p_system_person_type => 'EX_CWK');*/
589: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
585: /*PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
586: p_seeded_person_type_key => 'EX_CWK'
587: ,p_user_person_type => 'Ex-Contingent Worker'
588: ,p_system_person_type => 'EX_CWK');*/
589: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
590: p_seeded_person_type_key => 'SRVNG_DP'
591: ,p_user_person_type => 'Surviving Domestic Partner'
592: ,p_system_person_type => 'SRVNG_DP');
593: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
589: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
590: p_seeded_person_type_key => 'SRVNG_DP'
591: ,p_user_person_type => 'Surviving Domestic Partner'
592: ,p_system_person_type => 'SRVNG_DP');
593: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
594: p_seeded_person_type_key => 'SRVNG_DPFM'
595: ,p_user_person_type => 'Surviving Domestic Partner Family Member'
596: ,p_system_person_type => 'SRVNG_DPFM');
597: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
593: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
594: p_seeded_person_type_key => 'SRVNG_DPFM'
595: ,p_user_person_type => 'Surviving Domestic Partner Family Member'
596: ,p_system_person_type => 'SRVNG_DPFM');
597: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
598: p_seeded_person_type_key => 'FRMR_DP'
599: ,p_user_person_type => 'Former Domestic Partner'
600: ,p_system_person_type => 'FRMR_DP');
601: /*PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
597: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
598: p_seeded_person_type_key => 'FRMR_DP'
599: ,p_user_person_type => 'Former Domestic Partner'
600: ,p_system_person_type => 'FRMR_DP');
601: /*PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(
602: p_seeded_person_type_key => 'CWK'
603: ,p_user_person_type => 'Contingent Worker'
604: ,p_system_person_type => 'CWK');*/
605: end;
602: p_seeded_person_type_key => 'CWK'
603: ,p_user_person_type => 'Contingent Worker'
604: ,p_system_person_type => 'CWK');*/
605: end;
606: end PER_STARTUP_PERSON_TYPES_PKG;