APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGS_CA_INST

Line 2958: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,

2954: END fnar_insert_row;
2955:
2956:
2957: PROCEDURE log_input_params( p_batch_num IN NUMBER,
2958: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
2959: p_delete_flag IN VARCHAR2 ) IS
2960: /*
2961: || Created By : masehgal
2962: || Created On : 28-May-2003

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

5835: *******************************************************************************/
5836: AS
5837:
5838: -- cursor to get alternate code for award year
5839: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
5840: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
5841: SELECT alternate_code
5842: FROM igs_ca_inst
5843: WHERE cal_type = cp_ci_cal_type

Line 5840: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

5836: AS
5837:
5838: -- cursor to get alternate code for award year
5839: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
5840: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
5841: SELECT alternate_code
5842: FROM igs_ca_inst
5843: WHERE cal_type = cp_ci_cal_type
5844: AND sequence_number = cp_ci_sequence_number ;

Line 5842: FROM igs_ca_inst

5838: -- cursor to get alternate code for award year
5839: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
5840: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
5841: SELECT alternate_code
5842: FROM igs_ca_inst
5843: WHERE cal_type = cp_ci_cal_type
5844: AND sequence_number = cp_ci_sequence_number ;
5845:
5846: -- cursor to get sys award year and award year status

Line 5860: CURSOR c_award_det(p_ci_cal_type igs_ca_inst.cal_type%TYPE,

5856: WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
5857: AND lookup_code =p_lookup_code
5858: AND enabled_flag = 'Y' ;
5859:
5860: CURSOR c_award_det(p_ci_cal_type igs_ca_inst.cal_type%TYPE,
5861: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
5862: SELECT BATCH_YEAR batch_year ,
5863: AWARD_YEAR_STATUS_CODE ,
5864: CSS_ACADEMIC_YEAR,

Line 5861: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

5857: AND lookup_code =p_lookup_code
5858: AND enabled_flag = 'Y' ;
5859:
5860: CURSOR c_award_det(p_ci_cal_type igs_ca_inst.cal_type%TYPE,
5861: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
5862: SELECT BATCH_YEAR batch_year ,
5863: AWARD_YEAR_STATUS_CODE ,
5864: CSS_ACADEMIC_YEAR,
5865: SYS_AWARD_YEAR

Line 5895: l_alternate_code igs_ca_inst.alternate_code%TYPE ;

5891:
5892: c_transaction_num_rec c_transaction_num%ROWTYPE;
5893: counter NUMBER;
5894: indx NUMBER;
5895: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
5896: l_ci_cal_type VARCHAR2(10);
5897: l_ci_sequence_number NUMBER;
5898: l_ret_profile VARCHAR2(2);
5899: l_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;