846: l_expected_completion_perd IGS_AD_PS_APPL_INST.expected_completion_perd%TYPE;
847:
848: l_finaid_apply_date igs_ad_ps_appl_inst.finaid_apply_date%TYPE;
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
847:
848: l_finaid_apply_date igs_ad_ps_appl_inst.finaid_apply_date%TYPE;
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
855: l_rowid VARCHAR2(25);
848: l_finaid_apply_date igs_ad_ps_appl_inst.finaid_apply_date%TYPE;
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
855: l_rowid VARCHAR2(25);
856: l_org_id NUMBER(15);
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
855: l_rowid VARCHAR2(25);
856: l_org_id NUMBER(15);
857: l_type_instance_id NUMBER;