52: l_tracking_id igs_tr_item.tracking_id%TYPE;
53: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;
54: l_message_name VARCHAR2(30);
55: l_found BOOLEAN;
56: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
57: l_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
59: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
60: l_admission_cat igs_ad_cat.admission_cat%TYPE;
53: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;
54: l_message_name VARCHAR2(30);
55: l_found BOOLEAN;
56: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
57: l_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
59: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
60: l_admission_cat igs_ad_cat.admission_cat%TYPE;
61: l_s_adm_process_typ igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
54: l_message_name VARCHAR2(30);
55: l_found BOOLEAN;
56: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
57: l_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
59: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
60: l_admission_cat igs_ad_cat.admission_cat%TYPE;
61: l_s_adm_process_typ igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
62: --
55: l_found BOOLEAN;
56: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
57: l_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
59: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
60: l_admission_cat igs_ad_cat.admission_cat%TYPE;
61: l_s_adm_process_typ igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
62: --
63: -- Get eligible application instances for ADM_PROCESSING