[Home] [Help]
37: --------------------------------------------------------------*/
38:
39: CURSOR award_year_cal_cur (cp_award_id IGF_AW_AWD_DISB_ALL.award_id%TYPE) IS
40: SELECT fmast.ci_cal_type,fmast.ci_sequence_number, awd.award_status
41: FROM IGF_AW_AWARD_ALL awd,
42: IGF_AW_FUND_MAST fmast
43: WHERE awd.award_id = cp_award_id
44: AND awd.fund_id = fmast.fund_id;
45: award_year_cal_rec award_year_cal_cur%ROWTYPE;
892: ,disb_num
893: FROM igf_aw_awd_disb
894: WHERE row_id = cp_rowid;
895:
896: CURSOR c_igf_sl_lorlar(cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
897: SELECT lar.loan_number
898: ,lar.loan_status
899: ,lor.prc_type_code
900: ,lor.cl_rec_status
922:
923: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
924: l_v_message_name fnd_new_messages.message_name%TYPE;
925: l_b_return_status BOOLEAN;
926: l_n_award_id igf_aw_award_all.award_id%TYPE;
927: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
928: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
929: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
930: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
1018: || Change History :
1019: || Who When What
1020: || (reverse chronological order - newest change first)
1021: --------------------------------------------------------------------*/
1022: CURSOR c_igf_sl_lorlar(cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1023: SELECT lar.loan_number
1024: ,lar.loan_status
1025: ,lor.prc_type_code
1026: ,lor.cl_rec_status
1035: l_v_message_name fnd_new_messages.message_name%TYPE;
1036: l_b_return_status BOOLEAN;
1037: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
1038: l_v_rowid ROWID;
1039: l_n_award_id igf_aw_award_all.award_id%TYPE;
1040: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1041: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1042: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
1043: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;