APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGS_CA_INST

Line 3173: l_adm_seq igs_ca_inst.sequence_number%TYPE;

3169:
3170: l_person_type igs_pe_person_types.person_type_code%TYPE;
3171: l_inq_cal_type igs_ad_cal_conf.inq_cal_type%TYPE;
3172: l_rowid ROWID;
3173: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3174: l_acad_cal_type igs_ca_type.cal_type%TYPE;
3175: l_acad_seq igs_ca_inst.sequence_number%TYPE;
3176: ln_typ_id igs_pe_typ_instances_all.type_instance_id%TYPE;
3177: l_adm_alternate_code igs_ca_inst.alternate_code%TYPE;

Line 3175: l_acad_seq igs_ca_inst.sequence_number%TYPE;

3171: l_inq_cal_type igs_ad_cal_conf.inq_cal_type%TYPE;
3172: l_rowid ROWID;
3173: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3174: l_acad_cal_type igs_ca_type.cal_type%TYPE;
3175: l_acad_seq igs_ca_inst.sequence_number%TYPE;
3176: ln_typ_id igs_pe_typ_instances_all.type_instance_id%TYPE;
3177: l_adm_alternate_code igs_ca_inst.alternate_code%TYPE;
3178: l_message VARCHAR2(30);
3179: lv_return_status VARCHAR2(10);

Line 3177: l_adm_alternate_code igs_ca_inst.alternate_code%TYPE;

3173: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3174: l_acad_cal_type igs_ca_type.cal_type%TYPE;
3175: l_acad_seq igs_ca_inst.sequence_number%TYPE;
3176: ln_typ_id igs_pe_typ_instances_all.type_instance_id%TYPE;
3177: l_adm_alternate_code igs_ca_inst.alternate_code%TYPE;
3178: l_message VARCHAR2(30);
3179: lv_return_status VARCHAR2(10);
3180: lv_msg_data VARCHAR2(2000);
3181: lv_msg_count NUMBER;

Line 4459: FROM igs_ca_inst cal

4455:
4456: CURSOR cur_alt_code ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
4457: x_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ) IS
4458: SELECT cal.alternate_code
4459: FROM igs_ca_inst cal
4460: WHERE cal.cal_type = x_ci_cal_type
4461: AND cal.sequence_number = x_ci_sequence_number;
4462:
4463: CURSOR c_profile(cp_cal_type VARCHAR2,cp_seq_number NUMBER) IS