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.

[Home] [Help]

APPS.IGS_GR_GEN_002 dependencies on IGS_GR_GRADUAND_ALL

Line 813: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

809: END grdp_ins_graduand;
810:
811:
812: PROCEDURE grdp_ins_gr_hist(
813: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

Line 814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

810:
811:
812: PROCEDURE grdp_ins_gr_hist(
813: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

Line 815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,

811:
812: PROCEDURE grdp_ins_gr_hist(
813: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

Line 816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,

812: PROCEDURE grdp_ins_gr_hist(
813: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

Line 817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

813: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

814: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

815: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

816: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

817: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

818: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
826: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

819: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
826: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
827: p_old_honours_level VARCHAR2 DEFAULT NULL,

Line 824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

820: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
826: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
827: p_old_honours_level VARCHAR2 DEFAULT NULL,
828: p_new_honours_level VARCHAR2 DEFAULT NULL,

Line 825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

821: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
826: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
827: p_old_honours_level VARCHAR2 DEFAULT NULL,
828: p_new_honours_level VARCHAR2 DEFAULT NULL,
829: p_old_conferral_dt DATE DEFAULT NULL,

Line 826: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

822: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
823: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
824: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
825: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
826: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
827: p_old_honours_level VARCHAR2 DEFAULT NULL,
828: p_new_honours_level VARCHAR2 DEFAULT NULL,
829: p_old_conferral_dt DATE DEFAULT NULL,
830: p_new_conferral_dt DATE DEFAULT NULL,

Line 831: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

827: p_old_honours_level VARCHAR2 DEFAULT NULL,
828: p_new_honours_level VARCHAR2 DEFAULT NULL,
829: p_old_conferral_dt DATE DEFAULT NULL,
830: p_new_conferral_dt DATE DEFAULT NULL,
831: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

828: p_new_honours_level VARCHAR2 DEFAULT NULL,
829: p_old_conferral_dt DATE DEFAULT NULL,
830: p_new_conferral_dt DATE DEFAULT NULL,
831: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

829: p_old_conferral_dt DATE DEFAULT NULL,
830: p_new_conferral_dt DATE DEFAULT NULL,
831: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

Line 834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

830: p_new_conferral_dt DATE DEFAULT NULL,
831: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

Line 835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

831: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

Line 836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

832: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

Line 837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

833: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

Line 838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

834: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

Line 839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

835: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

Line 840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

836: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

Line 841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

837: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

Line 842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

838: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

Line 843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

839: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

Line 844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

840: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

Line 845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

841: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

842: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

843: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

844: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

845: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

Line 850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

846: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

Line 851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

847: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

Line 852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

848: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

Line 853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

849: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,

Line 854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

850: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
858: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE )

Line 855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

851: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
858: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE )
859: AS

Line 856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

852: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
858: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE )
859: AS
860: l_org_id NUMBER(15);

Line 857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,

853: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
858: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE )
859: AS
860: l_org_id NUMBER(15);
861: BEGIN -- grdp_ins_gr_hist

Line 858: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE )

854: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
855: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
856: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
857: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
858: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE )
859: AS
860: l_org_id NUMBER(15);
861: BEGIN -- grdp_ins_gr_hist
862: -- Insert IGS_GR_GRADUAND history(IGS_GR_GRADUAND_HIST)

Line 1111: cp_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE,

1107: --
1108: -- sepalani Bug# 5074150
1109: --
1110: CURSOR c_gr_upd (
1111: cp_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE,
1112: cp_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE) IS
1113: SELECT rowid, gr.*
1114: FROM IGS_GR_GRADUAND_ALL gr
1115: WHERE gr.person_id = cp_person_id AND

Line 1112: cp_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE) IS

1108: -- sepalani Bug# 5074150
1109: --
1110: CURSOR c_gr_upd (
1111: cp_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE,
1112: cp_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE) IS
1113: SELECT rowid, gr.*
1114: FROM IGS_GR_GRADUAND_ALL gr
1115: WHERE gr.person_id = cp_person_id AND
1116: gr.create_dt = cp_create_dt

Line 1114: FROM IGS_GR_GRADUAND_ALL gr

1110: CURSOR c_gr_upd (
1111: cp_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE,
1112: cp_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE) IS
1113: SELECT rowid, gr.*
1114: FROM IGS_GR_GRADUAND_ALL gr
1115: WHERE gr.person_id = cp_person_id AND
1116: gr.create_dt = cp_create_dt
1117: FOR UPDATE OF s_graduand_type NOWAIT;
1118: v_gr_del c_gr_upd%ROWTYPE;