[Home] [Help]
1899: l_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
1900: l_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
1901: l_old_awd igf_aw_award_all.award_id%TYPE;
1902: l_new_awd igf_aw_award_all.award_id%TYPE;
1903: l_old_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1904: l_old_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1905: l_new_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1906: l_new_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1907: p_message VARCHAR2(1000);
1900: l_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
1901: l_old_awd igf_aw_award_all.award_id%TYPE;
1902: l_new_awd igf_aw_award_all.award_id%TYPE;
1903: l_old_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1904: l_old_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1905: l_new_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1906: l_new_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1907: p_message VARCHAR2(1000);
1908: l_status VARCHAR2(1);
1901: l_old_awd igf_aw_award_all.award_id%TYPE;
1902: l_new_awd igf_aw_award_all.award_id%TYPE;
1903: l_old_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1904: l_old_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1905: l_new_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1906: l_new_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1907: p_message VARCHAR2(1000);
1908: l_status VARCHAR2(1);
1909: l_record_found BOOLEAN;
1902: l_new_awd igf_aw_award_all.award_id%TYPE;
1903: l_old_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1904: l_old_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1905: l_new_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1906: l_new_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1907: p_message VARCHAR2(1000);
1908: l_status VARCHAR2(1);
1909: l_record_found BOOLEAN;
1910: BEGIN