[Home] [Help]
25: g_fabase c_fabase%ROWTYPE ;
26:
27:
28: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
29: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
30: p_delete_flag IN VARCHAR2 ) IS
31: /*
32: || Created By : masehgal
33: || Created On : 28-May-2003
433: g_skip_person BOOLEAN := FALSE ;
434: g_skip_record BOOLEAN := FALSE ;
435: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
436: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
437: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
438: l_rec_processed NUMBER;
439: l_rec_imported NUMBER;
440: l_last_person_number igf_ap_li_vern_ints.person_number%TYPE ;
441: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
480:
481: person_rec c_get_persons%ROWTYPE ;
482:
483: -- cursor to get alternate code for award year
484: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
485: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
486: SELECT alternate_code
487: FROM igs_ca_inst
488: WHERE cal_type = cp_ci_cal_type
481: person_rec c_get_persons%ROWTYPE ;
482:
483: -- cursor to get alternate code for award year
484: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
485: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
486: SELECT alternate_code
487: FROM igs_ca_inst
488: WHERE cal_type = cp_ci_cal_type
489: AND sequence_number = cp_ci_sequence_number ;
483: -- cursor to get alternate code for award year
484: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
485: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
486: SELECT alternate_code
487: FROM igs_ca_inst
488: WHERE cal_type = cp_ci_cal_type
489: AND sequence_number = cp_ci_sequence_number ;
490:
491: -- check SAR Field Number done