DBA Data[Home] [Help]

APPS.GHR_HISTORY_CONV_RG dependencies on PER_PERSON_ANALYSES

Line 627: p_peranalyses_data in per_person_analyses%rowtype,

623: p_addresses_data in out nocopy per_addresses%rowtype);
624:
625:
626: Procedure conv_peranalyses_rg_to_hist_rg(
627: p_peranalyses_data in per_person_analyses%rowtype,
628: p_history_data in out nocopy ghr_pa_history%rowtype);
629:
630: Procedure conv_to_peranalyses_rg(
631: p_history_data in ghr_pa_history%rowtype,

Line 632: p_peranalyses_data in out nocopy per_person_analyses%rowtype);

628: p_history_data in out nocopy ghr_pa_history%rowtype);
629:
630: Procedure conv_to_peranalyses_rg(
631: p_history_data in ghr_pa_history%rowtype,
632: p_peranalyses_data in out nocopy per_person_analyses%rowtype);
633:
634: Procedure conv_to_peranalyses_rg(p_peranalyses_h_v in ghr_person_analyses_h_v%rowtype,
635: p_peranalyses_data out nocopy per_person_analyses%rowtype);
636:

Line 635: p_peranalyses_data out nocopy per_person_analyses%rowtype);

631: p_history_data in ghr_pa_history%rowtype,
632: p_peranalyses_data in out nocopy per_person_analyses%rowtype);
633:
634: Procedure conv_to_peranalyses_rg(p_peranalyses_h_v in ghr_person_analyses_h_v%rowtype,
635: p_peranalyses_data out nocopy per_person_analyses%rowtype);
636:
637: Procedure conv_to_peranalyses_rg(
638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639: p_business_group_id in per_person_analyses.business_group_id%type default null,

Line 638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,

634: Procedure conv_to_peranalyses_rg(p_peranalyses_h_v in ghr_person_analyses_h_v%rowtype,
635: p_peranalyses_data out nocopy per_person_analyses%rowtype);
636:
637: Procedure conv_to_peranalyses_rg(
638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639: p_business_group_id in per_person_analyses.business_group_id%type default null,
640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,

Line 639: p_business_group_id in per_person_analyses.business_group_id%type default null,

635: p_peranalyses_data out nocopy per_person_analyses%rowtype);
636:
637: Procedure conv_to_peranalyses_rg(
638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639: p_business_group_id in per_person_analyses.business_group_id%type default null,
640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,

Line 640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,

636:
637: Procedure conv_to_peranalyses_rg(
638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639: p_business_group_id in per_person_analyses.business_group_id%type default null,
640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,

Line 641: p_person_id in per_person_analyses.person_id%type default null,

637: Procedure conv_to_peranalyses_rg(
638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639: p_business_group_id in per_person_analyses.business_group_id%type default null,
640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,

Line 642: p_comments in per_person_analyses.comments%type default null,

638: p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639: p_business_group_id in per_person_analyses.business_group_id%type default null,
640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,

Line 643: p_date_from in per_person_analyses.date_from%type default null,

639: p_business_group_id in per_person_analyses.business_group_id%type default null,
640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,

Line 644: p_date_to in per_person_analyses.date_to%type default null,

640: p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,

Line 645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,

641: p_person_id in per_person_analyses.person_id%type default null,
642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,

Line 646: p_request_id in per_person_analyses.request_id%type default null,

642: p_comments in per_person_analyses.comments%type default null,
643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,

Line 647: p_program_application_id in per_person_analyses.program_application_id%type default null,

643: p_date_from in per_person_analyses.date_from%type default null,
644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,

Line 648: p_program_id in per_person_analyses.program_id%type default null,

644: p_date_to in per_person_analyses.date_to%type default null,
645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,

Line 649: p_program_update_date in per_person_analyses.program_update_date%type default null,

645: p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,

Line 650: p_attribute_category in per_person_analyses.attribute_category%type default null,

646: p_request_id in per_person_analyses.request_id%type default null,
647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,

Line 651: p_attribute1 in per_person_analyses.attribute1%type default null,

647: p_program_application_id in per_person_analyses.program_application_id%type default null,
648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,

Line 652: p_attribute2 in per_person_analyses.attribute2%type default null,

648: p_program_id in per_person_analyses.program_id%type default null,
649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,

Line 653: p_attribute3 in per_person_analyses.attribute3%type default null,

649: p_program_update_date in per_person_analyses.program_update_date%type default null,
650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,

Line 654: p_attribute4 in per_person_analyses.attribute4%type default null,

650: p_attribute_category in per_person_analyses.attribute_category%type default null,
651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,

Line 655: p_attribute5 in per_person_analyses.attribute5%type default null,

651: p_attribute1 in per_person_analyses.attribute1%type default null,
652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,

Line 656: p_attribute6 in per_person_analyses.attribute6%type default null,

652: p_attribute2 in per_person_analyses.attribute2%type default null,
653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,

Line 657: p_attribute7 in per_person_analyses.attribute7%type default null,

653: p_attribute3 in per_person_analyses.attribute3%type default null,
654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,

Line 658: p_attribute8 in per_person_analyses.attribute8%type default null,

654: p_attribute4 in per_person_analyses.attribute4%type default null,
655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,

Line 659: p_attribute9 in per_person_analyses.attribute9%type default null,

655: p_attribute5 in per_person_analyses.attribute5%type default null,
656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,

Line 660: p_attribute10 in per_person_analyses.attribute10%type default null,

656: p_attribute6 in per_person_analyses.attribute6%type default null,
657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,

Line 661: p_attribute11 in per_person_analyses.attribute11%type default null,

657: p_attribute7 in per_person_analyses.attribute7%type default null,
658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,

Line 662: p_attribute12 in per_person_analyses.attribute12%type default null,

658: p_attribute8 in per_person_analyses.attribute8%type default null,
659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,

Line 663: p_attribute13 in per_person_analyses.attribute13%type default null,

659: p_attribute9 in per_person_analyses.attribute9%type default null,
660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,

Line 664: p_attribute14 in per_person_analyses.attribute14%type default null,

660: p_attribute10 in per_person_analyses.attribute10%type default null,
661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,

Line 665: p_attribute15 in per_person_analyses.attribute15%type default null,

661: p_attribute11 in per_person_analyses.attribute11%type default null,
662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,

Line 666: p_attribute16 in per_person_analyses.attribute16%type default null,

662: p_attribute12 in per_person_analyses.attribute12%type default null,
663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,
670: p_attribute20 in per_person_analyses.attribute20%type default null,

Line 667: p_attribute17 in per_person_analyses.attribute17%type default null,

663: p_attribute13 in per_person_analyses.attribute13%type default null,
664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,
670: p_attribute20 in per_person_analyses.attribute20%type default null,
671: p_peranalyses_data in out nocopy per_person_analyses%rowtype );

Line 668: p_attribute18 in per_person_analyses.attribute18%type default null,

664: p_attribute14 in per_person_analyses.attribute14%type default null,
665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,
670: p_attribute20 in per_person_analyses.attribute20%type default null,
671: p_peranalyses_data in out nocopy per_person_analyses%rowtype );
672:

Line 669: p_attribute19 in per_person_analyses.attribute19%type default null,

665: p_attribute15 in per_person_analyses.attribute15%type default null,
666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,
670: p_attribute20 in per_person_analyses.attribute20%type default null,
671: p_peranalyses_data in out nocopy per_person_analyses%rowtype );
672:
673: Procedure convert_shadow_to_sf52 (

Line 670: p_attribute20 in per_person_analyses.attribute20%type default null,

666: p_attribute16 in per_person_analyses.attribute16%type default null,
667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,
670: p_attribute20 in per_person_analyses.attribute20%type default null,
671: p_peranalyses_data in out nocopy per_person_analyses%rowtype );
672:
673: Procedure convert_shadow_to_sf52 (
674: p_shadow in ghr_pa_request_shadow%rowtype,

Line 671: p_peranalyses_data in out nocopy per_person_analyses%rowtype );

667: p_attribute17 in per_person_analyses.attribute17%type default null,
668: p_attribute18 in per_person_analyses.attribute18%type default null,
669: p_attribute19 in per_person_analyses.attribute19%type default null,
670: p_attribute20 in per_person_analyses.attribute20%type default null,
671: p_peranalyses_data in out nocopy per_person_analyses%rowtype );
672:
673: Procedure convert_shadow_to_sf52 (
674: p_shadow in ghr_pa_request_shadow%rowtype,
675: p_sf52 out nocopy ghr_pa_requests%rowtype);