DBA Data[Home] [Help]

APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on PER_STARTUP_PERSON_TYPES_PKG

Line 1: package body PER_STARTUP_PERSON_TYPES_PKG as

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,

Line 517: PER_STARTUP_PERSON_TYPES_PKG.POPULATE_KEY(

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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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(

Line 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;

Line 606: end PER_STARTUP_PERSON_TYPES_PKG;

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;