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.

APPS.IGF_DB_DL_ORIG_ACK dependencies on IGF_AW_DB_CHG_DTLS

Line 14: Replaced the reference of igf_db_awd_disb_dtl with igf_aw_db_chg_dtls table

10: Who When What
11: (reverse chronological order - newest change first)
12: bvisvana 19-Jul-2005 Bug 4101317 - added new exception INVALID_PHASE_IN_PARTICIPANT
13: ayedubat 20-OCT-2004 FA 149 COD-XML Standards build bug # 3416863
14: Replaced the reference of igf_db_awd_disb_dtl with igf_aw_db_chg_dtls table
15: Changed the logic as per the TD, FA149_TD_COD_XML_i1a.doc
16: veramach 29-Jan-2004 bug 3408092 added 2004-2005 in l_dl_version checks
17: sjadhav 31-Mar-2003 Bug 2863960
18: added desc for disb data displayed

Line 322: l_disb_status igf_aw_db_chg_dtls.disb_status%TYPE;

318: l_batch_id igf_sl_dl_batch.batch_id%TYPE;
319:
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

Line 323: l_disb_status_date igf_aw_db_chg_dtls.disb_status_date%TYPE;

319:
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

Line 355: l_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,

351:
352: -- ## Cursor to Get the award disbursements for the particular loannumber,award id ,disbursement Number and disbursement sequence number
353:
354: CURSOR cur_awdisb(l_loan_number igf_db_cl_disb_resp.loan_number%TYPE,
355: l_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
356: l_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
357: IS
358: SELECT adcd.*
359: FROM igf_aw_db_chg_dtls adcd,

Line 356: l_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)

352: -- ## Cursor to Get the award disbursements for the particular loannumber,award id ,disbursement Number and disbursement sequence number
353:
354: CURSOR cur_awdisb(l_loan_number igf_db_cl_disb_resp.loan_number%TYPE,
355: l_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
356: l_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
357: IS
358: SELECT adcd.*
359: FROM igf_aw_db_chg_dtls adcd,
360: igf_sl_loans sl

Line 359: FROM igf_aw_db_chg_dtls adcd,

355: l_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
356: l_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
357: IS
358: SELECT adcd.*
359: FROM igf_aw_db_chg_dtls adcd,
360: igf_sl_loans sl
361: WHERE
362: sl.loan_number = l_loan_number AND
363: adcd.award_id = sl.award_id AND

Line 533: -- ## Update the igf_aw_db_chg_dtls table with the disb status as Rejected

529: l_disb_status_date := TRUNC(SYSDATE);
530: END IF;
531:
532:
533: -- ## Update the igf_aw_db_chg_dtls table with the disb status as Rejected
534: -- ## and disb status date as current data
535:
536: IF lcur_db_resp.loc_disb_gross_amt IS NOT NULL
537: OR lcur_db_resp.loc_fee_1 IS NOT NULL

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 582: FROM igf_aw_db_chg_dtls adcd

578: DECLARE
579:
580: CURSOR c_tbh_cur IS
581: SELECT adcd.*,adcd.ROWID
582: FROM igf_aw_db_chg_dtls adcd
583: WHERE adcd.award_id = lcur_awdisb.award_id
584: AND adcd.disb_num = lcur_db_resp.disb_num
585: AND adcd.disb_seq_num = lcur_db_resp.disb_seq_num
586: FOR UPDATE OF adcd.award_id NOWAIT;

Line 591: igf_aw_db_chg_dtls_pkg.update_row (

587:
588: BEGIN
589: FOR tbh_rec in c_tbh_cur LOOP
590:
591: igf_aw_db_chg_dtls_pkg.update_row (
592: x_rowid => tbh_rec.ROWID,
593: x_award_id => tbh_rec.award_id,
594: x_disb_num => tbh_rec.disb_num,
595: x_disb_seq_num => tbh_rec.disb_seq_num,

Line 620: -- ## If the file type is Booking then pick up the data from the igf_aw_db_chg_dtls

616: END;
617: END IF;
618:
619:
620: -- ## If the file type is Booking then pick up the data from the igf_aw_db_chg_dtls
621: -- ## and update the igf_aw_db_chg_dtls with the disb status as booked, booking batch id
622: -- ## with the current batch ID and disb status date as current date
623:
624: ELSIF l_dl_file_type = 'DL_DISB_BOOK' THEN

Line 621: -- ## and update the igf_aw_db_chg_dtls with the disb status as booked, booking batch id

617: END IF;
618:
619:
620: -- ## If the file type is Booking then pick up the data from the igf_aw_db_chg_dtls
621: -- ## and update the igf_aw_db_chg_dtls with the disb status as booked, booking batch id
622: -- ## with the current batch ID and disb status date as current date
623:
624: ELSIF l_dl_file_type = 'DL_DISB_BOOK' THEN
625: DECLARE

Line 629: FROM igf_aw_db_chg_dtls adcd

625: DECLARE
626:
627: CURSOR c_tbh_cur IS
628: SELECT adcd.*, adcd.ROWID
629: FROM igf_aw_db_chg_dtls adcd
630: WHERE adcd.award_id = lcur_awdisb.award_id
631: AND adcd.disb_num = lcur_db_resp.disb_num
632: AND adcd.disb_seq_num = lcur_db_resp.disb_seq_num
633: FOR UPDATE OF adcd.award_id NOWAIT;

Line 639: igf_aw_db_chg_dtls_pkg.update_row (

635: BEGIN
636:
637: FOR tbh_recss in c_tbh_cur LOOP
638:
639: igf_aw_db_chg_dtls_pkg.update_row (
640: x_rowid => tbh_recss.ROWID,
641: x_award_id => tbh_recss.award_id,
642: x_disb_num => tbh_recss.disb_num,
643: x_disb_seq_num => tbh_recss.disb_seq_num,