APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGF_AP_BATCH_AW_MAP

Line 525: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;

521: l_debug_str VARCHAR2(4000) := NULL;
522: l_error igf_lookups_view.meaning%TYPE ;
523: l_cps_log VARCHAR2(1) ;
524: g_import_type VARCHAR2(1);
525: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
526:
527: FUNCTION convert_negative_char( pv_charnum IN VARCHAR2)
528: RETURN NUMBER
529: IS

Line 5887: IGF_AP_BATCH_AW_MAP

5883: BATCH_YEAR batch_year,
5884: AWARD_YEAR_STATUS_CODE,
5885: SYS_AWARD_YEAR
5886: FROM
5887: IGF_AP_BATCH_AW_MAP
5888: WHERE
5889: CI_CAL_TYPE = p_ci_cal_type
5890: AND CI_SEQUENCE_NUMBER = p_ci_sequence_number;
5891:

Line 5965: FROM igf_ap_batch_aw_map map

5961:
5962: -- cursor to get sys award year and award year status
5963: CURSOR c_get_stat( p_ci_cal_type VARCHAR2,p_ci_sequence_number NUMBER)IS
5964: SELECT award_year_status_code, sys_award_year
5965: FROM igf_ap_batch_aw_map map
5966: WHERE map.ci_cal_type = p_ci_cal_type
5967: AND map.ci_sequence_number = p_ci_sequence_number ;
5968:
5969: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;

Line 5969: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;

5965: FROM igf_ap_batch_aw_map map
5966: WHERE map.ci_cal_type = p_ci_cal_type
5967: AND map.ci_sequence_number = p_ci_sequence_number ;
5968:
5969: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
5970: l_batch_valid VARCHAR2(1) ;
5971:
5972: c_get_rowid_rec c_get_rowid%ROWTYPE;
5973:

Line 6042: FROM IGF_AP_BATCH_AW_MAP

6038: -- Get the details of sys award year
6039: CURSOR c_sys_aw_yr(p_ci_cal_type VARCHAR2,p_ci_sequence_number NUMBER)
6040: IS
6041: SELECT SYS_AWARD_YEAR
6042: FROM IGF_AP_BATCH_AW_MAP
6043: WHERE CI_CAL_TYPE = p_ci_cal_type
6044: AND CI_SEQUENCE_NUMBER=p_ci_sequence_number;
6045: c_sys_aw_yr_rec c_sys_aw_yr%ROWTYPE;
6046: TYPE message_rec IS RECORD