DBA Data[Home] [Help]

APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGS_CA_INST

Line 132: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,

128: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
129: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
130:
131: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
132: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
133: p_delete_flag IN VARCHAR2)
134: IS
135: /*
136: || Created By : rasahoo

Line 3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,

3149: l_num_of_disb_rec NUMBER := 0;
3150: lb_write_log BOOLEAN := FALSE;
3151: l_loan_id_msg VARCHAR(10);
3152: -- cursor to get alternate code for award year
3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
3155: SELECT alternate_code
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type

Line 3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

3150: lb_write_log BOOLEAN := FALSE;
3151: l_loan_id_msg VARCHAR(10);
3152: -- cursor to get alternate code for award year
3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
3155: SELECT alternate_code
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3158: AND sequence_number = cp_ci_sequence_number ;

Line 3156: FROM igs_ca_inst

3152: -- cursor to get alternate code for award year
3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
3155: SELECT alternate_code
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3158: AND sequence_number = cp_ci_sequence_number ;
3159:
3160: l_alternate_code igs_ca_inst.alternate_code%TYPE ;

Line 3160: l_alternate_code igs_ca_inst.alternate_code%TYPE ;

3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3158: AND sequence_number = cp_ci_sequence_number ;
3159:
3160: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
3161:
3162: CURSOR c_award_year (cp_cal_type VARCHAR2,
3163: cp_seq_num NUMBER)
3164: IS