APPS.IGF_AW_LI_IMPORT dependencies on IGF_AP_BATCH_AW_MAP

Line 143: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;

139: ORDER BY awdint.person_number, awdint.fund_code, awdint.award_number_txt;
140: l_out_person_id hz_parties.party_id%TYPE;
141: l_out_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
142:
143: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;
145:
146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;

Line 144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;

140: l_out_person_id hz_parties.party_id%TYPE;
141: l_out_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
142:
143: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;
145:
146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
148: g_fund_code igf_aw_fund_mast_all.fund_code%TYPE;

Line 146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;

142:
143: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;
145:
146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
148: g_fund_code igf_aw_fund_mast_all.fund_code%TYPE;
149: g_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

Line 147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;

143: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;
145:
146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
148: g_fund_code igf_aw_fund_mast_all.fund_code%TYPE;
149: g_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
151: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 3274: FROM igf_ap_batch_aw_map

3270: -- cursor to verify if the cal_type and seq_number are present in the system award year
3271: CURSOR cur_in_award_year_form(x_ci_cal_type igs_ca_inst.cal_type%TYPE,
3272: x_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
3273: SELECT award_year_status_code, sys_award_year
3274: FROM igf_ap_batch_aw_map
3275: WHERE ci_cal_type = x_ci_cal_type
3276: AND ci_sequence_number = x_ci_sequence_number;
3277: l_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
3278: l_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;

Line 3277: l_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;

3273: SELECT award_year_status_code, sys_award_year
3274: FROM igf_ap_batch_aw_map
3275: WHERE ci_cal_type = x_ci_cal_type
3276: AND ci_sequence_number = x_ci_sequence_number;
3277: l_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
3278: l_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
3279: l_return_status_awd VARCHAR2(1);
3280:
3281: PROCEDURE del_or_upd_int_records(p_operation IN VARCHAR2,

Line 3278: l_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;

3274: FROM igf_ap_batch_aw_map
3275: WHERE ci_cal_type = x_ci_cal_type
3276: AND ci_sequence_number = x_ci_sequence_number;
3277: l_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
3278: l_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
3279: l_return_status_awd VARCHAR2(1);
3280:
3281: PROCEDURE del_or_upd_int_records(p_operation IN VARCHAR2,
3282: ctx_li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,