APPS.IGS_AD_IMP_004 dependencies on IGS_AD_PS_APPL_INST_ALL

Line 837: l_app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE;

833: lv_rowid VARCHAR2(20);
834: v_description VARCHAR2(2000);
835: l_error_code VARCHAR2(4);
836: l_error_text VARCHAR2(2000);
837: l_app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE;
838: l_msg_at_index NUMBER ;
839: l_return_status VARCHAR2(1);
840: l_msg_count NUMBER ;
841: l_msg_data VARCHAR2(2000);

Line 849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;

845: l_expected_completion_yr IGS_AD_PS_APPL_INST.expected_completion_yr%TYPE;
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