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_DL_DISB_ORIG 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: Change History
11: Who When What
12: (reverse chronological order - newest change first)
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 p_dl_version checks
17: ugummall 23-OCT-2003 Bug 3102439. FA 126 Multiple FA Offices.
18: Modified the cursor cur_disb_dtl to include the clause which

Line 113: FROM igf_aw_db_chg_dtls adtlv,

109:
110: CURSOR cur_disb_dtl(lv_ci_cal_type igs_ca_inst.cal_type%TYPE,
111: lv_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
112: SELECT '1'
113: FROM igf_aw_db_chg_dtls adtlv,
114: igf_aw_award awd,
115: igf_sl_loans lar,
116: igf_ap_fa_base_rec fabase
117: WHERE -- ## Pick up all records with SF Status 1)"to be Posted" and Pick up Disbursements with Future dates and within 7 Future days,

Line 348: FROM igf_aw_db_chg_dtls adtlv,

344: -- ## Cursor to Retrieve the disbursements being credited to the Students Account
345:
346: CURSOR cur_disb_dtl IS
347: SELECT adtlv.*, fabase.base_id, lar.loan_number
348: FROM igf_aw_db_chg_dtls adtlv,
349: igf_aw_award awd,
350: igf_sl_loans lar,
351: igf_ap_fa_base_rec fabase
352: WHERE

Line 387: CURSOR cur_get_prev_date (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,

383: FROM igf_aw_awd_disb
384: WHERE award_id = cp_award_id;
385:
386:
387: CURSOR cur_get_prev_date (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
388: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
389: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
390: IS
391: SELECT disb_date

Line 388: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,

384: WHERE award_id = cp_award_id;
385:
386:
387: CURSOR cur_get_prev_date (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
388: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
389: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
390: IS
391: SELECT disb_date
392: FROM igf_aw_db_chg_dtls

Line 389: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)

385:
386:
387: CURSOR cur_get_prev_date (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
388: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
389: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
390: IS
391: SELECT disb_date
392: FROM igf_aw_db_chg_dtls
393: WHERE award_id = cp_award_id

Line 392: FROM igf_aw_db_chg_dtls

388: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
389: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE)
390: IS
391: SELECT disb_date
392: FROM igf_aw_db_chg_dtls
393: WHERE award_id = cp_award_id
394: AND disb_num = cp_disb_num
395: AND disb_seq_num = cp_disb_seq_num;
396:

Line 397: ld_date igf_aw_db_chg_dtls.disb_date%TYPE;

393: WHERE award_id = cp_award_id
394: AND disb_num = cp_disb_num
395: AND disb_seq_num = cp_disb_seq_num;
396:
397: ld_date igf_aw_db_chg_dtls.disb_date%TYPE;
398: l_min_disb_num igf_aw_db_chg_dtls.disb_num%TYPE;
399:
400: lcur_disb_dtl cur_disb_dtl%ROWTYPE; -- ## Cursor Type for the Disb Cursor
401: lcur_fund_dtl cur_fund_details%ROWTYPE;

Line 398: l_min_disb_num igf_aw_db_chg_dtls.disb_num%TYPE;

394: AND disb_num = cp_disb_num
395: AND disb_seq_num = cp_disb_seq_num;
396:
397: ld_date igf_aw_db_chg_dtls.disb_date%TYPE;
398: l_min_disb_num igf_aw_db_chg_dtls.disb_num%TYPE;
399:
400: lcur_disb_dtl cur_disb_dtl%ROWTYPE; -- ## Cursor Type for the Disb Cursor
401: lcur_fund_dtl cur_fund_details%ROWTYPE;
402: lcur_fund_dtl_temp cur_fund_details%ROWTYPE;

Line 556: -- ## Update the igf_aw_db_chg_dtls table with the disb_status as sent

552: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
553: END IF;
554: fnd_file.put_line(FND_FILE.OUTPUT, l_Trans_Rec); -- ## Write the Transaction Record to file
555:
556: -- ## Update the igf_aw_db_chg_dtls table with the disb_status as sent
557: -- ## , disb_status_date as sysdate and disb_batch_id as current batch id
558: -- ## for each award ID,disbnum and disb_seq_num.
559:
560: DECLARE

Line 563: SELECT igf_aw_db_chg_dtls.*,igf_aw_db_chg_dtls.ROWID

559:
560: DECLARE
561:
562: CURSOR c_tbh_cur IS
563: SELECT igf_aw_db_chg_dtls.*,igf_aw_db_chg_dtls.ROWID
564: FROM igf_aw_db_chg_dtls
565: WHERE award_id = lcur_disb_dtl.award_Id
566: AND disb_num = lcur_disb_dtl.disb_num
567: AND disb_seq_num = lcur_disb_dtl.disb_seq_num

Line 564: FROM igf_aw_db_chg_dtls

560: DECLARE
561:
562: CURSOR c_tbh_cur IS
563: SELECT igf_aw_db_chg_dtls.*,igf_aw_db_chg_dtls.ROWID
564: FROM igf_aw_db_chg_dtls
565: WHERE award_id = lcur_disb_dtl.award_Id
566: AND disb_num = lcur_disb_dtl.disb_num
567: AND disb_seq_num = lcur_disb_dtl.disb_seq_num
568: FOR UPDATE OF award_Id NOWAIT;

Line 572: igf_aw_db_chg_dtls_pkg.update_row (

568: FOR UPDATE OF award_Id NOWAIT;
569: BEGIN
570: FOR tbh_rec in c_tbh_cur LOOP
571:
572: igf_aw_db_chg_dtls_pkg.update_row (
573: x_rowid => tbh_rec.ROWID,
574: x_award_id => tbh_rec.award_id,
575: x_disb_num => tbh_rec.disb_num,
576: x_disb_seq_num => tbh_rec.disb_seq_num,