eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_DB_CL_ROSTER dependencies on IGF_DB_CL_DISB_RESP_ALL

Line 130: l_cdbr_id igf_db_cl_disb_resp_all.cdbr_id%TYPE;

126: lv_tot_deficit_amt VARCHAR2(80);
127: lv_tot_net_cancel_amt VARCHAR2(80);
128: lv_tot_net_out_cancel_amt VARCHAR2(80);
129: l_actual_rec NUMBER DEFAULT 0;
130: l_cdbr_id igf_db_cl_disb_resp_all.cdbr_id%TYPE;
131: l_hold_rel_ind VARCHAR2(30);
132: l_pnote_code VARCHAR2(2);
133: l_pnote_status_date DATE;
134: l_fee_paid_1 NUMBER;

Line 945: l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE;

941: Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
942: ***************************************************************/
943:
944: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
945: l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE;
946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;

Line 948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;

944: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
945: l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE;
946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;
951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;

Line 949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;

945: l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE;
946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;
951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;

Line 950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;

946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;
951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:

Line 951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;

947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;
951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;

Line 952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;

948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;
951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;

Line 953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;

949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;
951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;

Line 955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;

951: l_net_disb_amt igf_db_cl_disb_resp_all.net_disb_amt%TYPE;
952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;

Line 956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;

952: l_fee_paid_2 igf_db_cl_disb_resp_all.fee_paid_2%TYPE;
953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;

Line 957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;

953: l_fee_paid_1 igf_db_cl_disb_resp_all.fee_paid_1%TYPE;
954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;

Line 958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;

954:
955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;
962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;

Line 959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;

955: l_late_disb_ind igf_db_cl_disb_resp_all.late_disb_ind%TYPE;
956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;
962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;
963:

Line 960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;

956: l_fund_dist_mthd igf_db_cl_disb_resp_all.fund_dist_mthd%TYPE;
957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;
962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;
963:
964: CURSOR cur_db_resp(l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE) IS

Line 961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;

957: l_prev_reported_ind igf_db_cl_disb_resp_all.prev_reported_ind%TYPE;
958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;
962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;
963:
964: CURSOR cur_db_resp(l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE) IS
965: SELECT cdresp.* FROM igf_db_cl_disb_resp cdresp

Line 962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;

958: l_fund_release_date igf_db_cl_disb_resp_all.fund_release_date%TYPE;
959: l_check_number igf_db_cl_disb_resp_all.check_number%TYPE;
960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;
962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;
963:
964: CURSOR cur_db_resp(l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE) IS
965: SELECT cdresp.* FROM igf_db_cl_disb_resp cdresp
966: WHERE cbth_id = l_cbth_id

Line 1050: CURSOR cur_awdisb(l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE,

1046: l_msg_str1 VARCHAR2(1000);
1047: l_msg_str2 VARCHAR2(4000);
1048: l_msg_str3 VARCHAR2(1000);
1049:
1050: CURSOR cur_awdisb(l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE,
1051: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
1052: IS
1053: SELECT
1054: disb.*