80: FROM sys.dual;
81:
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
81:
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
90: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
90: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
91: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
305: FROM dual;
306:
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
306:
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
315: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
315: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
316: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
873:
874:
875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
874:
875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;
875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;
883:
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;
883:
884: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;