APPS.IGF_DB_DL_ORIG_ACK dependencies on IGF_DB_DL_DISB_RESP

Line 51: In the call to igf_db_dl_disb_resp_pkg.insert_row passed NULL to x_sch_code_status,x_loan_num_status,

47: Desc:DL VERSION TO BE CHECKED FOR DL CHANGE ORIG AND DISB ORIGINATION LOAN PROGRAMS.
48: Who When What
49: vvutukur 21-Feb-2003 Enh#2758823.FA117 Build. Modified the if condition to include 03-04 removing 02-03.
50: ie., Changed IF l_dl_version IN ('2001-2002','2002-2003') to IF l_dl_version IN ('2002-2003','2003-2004').
51: In the call to igf_db_dl_disb_resp_pkg.insert_row passed NULL to x_sch_code_status,x_loan_num_status,
52: x_disb_num_status,x_trans_date_status,x_trans_date_status.
53: mesriniv 19-MAR-2002 Added Version 2002-2003 check
54: (reverse chronological order - newest change first)
55: ***************************************************************/

Line 78: x_ddrp_id igf_db_dl_disb_resp.ddrp_id%TYPE;

74: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
75: l_dl_version igf_lookups_view.lookup_code%TYPE;
76: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
77: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
78: x_ddrp_id igf_db_dl_disb_resp.ddrp_id%TYPE;
79: -- ## Cursor for formulating the header
80:
81: CURSOR c_header
82: IS

Line 227: igf_db_dl_disb_resp_pkg.insert_row (

223: IF l_dl_file_type IN ('DL_DISB_ACK','DL_DISB_BOOK') THEN
224: FOR lcur_disb IN cur_disb LOOP
225: l_actual_rec := l_actual_rec + 1;
226:
227: igf_db_dl_disb_resp_pkg.insert_row (
228: x_mode => 'R',
229: x_rowid => l_rowid,
230: x_ddrp_id => x_ddrp_id,
231: x_dbth_id => l_dbth_id,

Line 324: l_disb_ack_date igf_db_dl_disb_resp.ack_date%TYPE DEFAULT NULL;

320: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;
321: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
322: l_disb_status igf_aw_db_chg_dtls.disb_status%TYPE;
323: l_disb_status_date igf_aw_db_chg_dtls.disb_status_date%TYPE;
324: l_disb_ack_date igf_db_dl_disb_resp.ack_date%TYPE DEFAULT NULL;
325:
326: l_mesg_str1 VARCHAR2(4000); -- ## String to put in the log file
327: l_mesg_str2 VARCHAR2(4000); -- ## String to put in the log file
328: l_mesg_str3 VARCHAR2(4000); -- ## String to put in the log file

Line 348: FROM igf_db_dl_disb_resp

344:
345: CURSOR cur_db_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)
346: IS
347: SELECT *
348: FROM igf_db_dl_disb_resp
349: WHERE dbth_id = l_dbth_id
350: AND status = 'N';
351:
352: -- ## Cursor to Get the award disbursements for the particular loannumber,award id ,disbursement Number and disbursement sequence number

Line 395: PROCEDURE log_start(p_loan_number igf_db_dl_disb_resp.loan_number%TYPE,

391:
392:
393: -- ## Local Procedure to print the Loan Number, Disb Number and Disb Seq Num in the LOG File
394:
395: PROCEDURE log_start(p_loan_number igf_db_dl_disb_resp.loan_number%TYPE,
396: p_disb_num igf_db_dl_disb_resp.disb_num%TYPE,
397: p_disb_seq_num igf_db_dl_disb_resp.disb_seq_num%TYPE
398: )
399: AS

Line 396: p_disb_num igf_db_dl_disb_resp.disb_num%TYPE,

392:
393: -- ## Local Procedure to print the Loan Number, Disb Number and Disb Seq Num in the LOG File
394:
395: PROCEDURE log_start(p_loan_number igf_db_dl_disb_resp.loan_number%TYPE,
396: p_disb_num igf_db_dl_disb_resp.disb_num%TYPE,
397: p_disb_seq_num igf_db_dl_disb_resp.disb_seq_num%TYPE
398: )
399: AS
400: BEGIN

Line 397: p_disb_seq_num igf_db_dl_disb_resp.disb_seq_num%TYPE

393: -- ## Local Procedure to print the Loan Number, Disb Number and Disb Seq Num in the LOG File
394:
395: PROCEDURE log_start(p_loan_number igf_db_dl_disb_resp.loan_number%TYPE,
396: p_disb_num igf_db_dl_disb_resp.disb_num%TYPE,
397: p_disb_seq_num igf_db_dl_disb_resp.disb_seq_num%TYPE
398: )
399: AS
400: BEGIN
401:

Line 542: -- ## in the tables like igf_aw_db_chg_dtls and igf_db_dl_disb_resp.If any

538: OR lcur_db_resp.loc_disb_net_amt IS NOT NULL THEN
539:
540: --
541: -- ## Compare If there is any difference exists between amt and fee fields
542: -- ## in the tables like igf_aw_db_chg_dtls and igf_db_dl_disb_resp.If any
543: -- ## difference exists then log it in the file.
544: -- ## Below, NVL(,lcur_awdisb.field) is given so that, if the field in flat file
545: -- ## is NULL, then it means that it matches with the values sent by the school.
546: --

Line 668: -- ## Update the igf_db_dl_disb_resp table with the status as Y(Processed);

664: END;
665: END IF;
666:
667:
668: -- ## Update the igf_db_dl_disb_resp table with the status as Y(Processed);
669:
670:
671: igf_db_dl_disb_resp_pkg.update_row (
672: x_mode => 'R',

Line 671: igf_db_dl_disb_resp_pkg.update_row (

667:
668: -- ## Update the igf_db_dl_disb_resp table with the status as Y(Processed);
669:
670:
671: igf_db_dl_disb_resp_pkg.update_row (
672: x_mode => 'R',
673: x_rowid => lcur_db_resp.row_id,
674: x_ddrp_id => lcur_db_resp.ddrp_id,
675: x_dbth_id => lcur_db_resp.dbth_id,