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_SL_CL_ORIG_ACK dependencies on IGF_AW_AWD_DISB

Line 45: -- Impacts of obsoleting columns from igf_aw_awd_disb_all

41: -- Record Type Indicator corrected
42: -- smadathi 29-oct-2004 Bug 3416936. Added new business logic as part of
43: -- CL4 changes
44: -- veramach July 2004 FA 151 HR Integration (bug#3709292)
45: -- Impacts of obsoleting columns from igf_aw_awd_disb_all
46: ---------------------------------------------------------------------------------
47: -- sjadhav 21-Jan-2004 Bug 3387706. Lender should be updated by process
48: -- Added logic to updat the Lender/Guarantor Info
49: -- Added more log messages

Line 53: -- veramach 04-Nov-03 FA 125 Multiple Distr methods - changed signature of igf_aw_awd_disb_pkg.update_row(added attendance_type_code) in procedure upd_disb_details

49: -- Added more log messages
50: ---------------------------------------------------------------------------------
51: -- veramach 11-Dec-2003 Bug # 3184891
52: -- removed calls to igf_ap_gen.write_log and added common logging
53: -- veramach 04-Nov-03 FA 125 Multiple Distr methods - changed signature of igf_aw_awd_disb_pkg.update_row(added attendance_type_code) in procedure upd_disb_details
54: -- ugummall 21-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
55: -- removed cur_school_id and l_school_id and their
56: -- references. Removed the clause which meant for selection
57: -- based on school_id from the cur_Hrecord cursor as the job

Line 108: -- IGF_AW_AWD_DISB table to 'Y'.

104: -- insert records into IGF_DB_DISB_HOLDS
105: -- table with hold 'EXTERNAL' and
106: -- hold type 'SYSTEM' and also
107: -- update manual_hold_ind flag in
108: -- IGF_AW_AWD_DISB table to 'Y'.
109: -- enh bug no-2154941.
110: ---------------------------------------------------------------------------------
111: -- ssawhney 2nd jan TBH call of IGF_AW_AWD_DISB table
112: -- changed in Stud Emp build

Line 111: -- ssawhney 2nd jan TBH call of IGF_AW_AWD_DISB table

107: -- update manual_hold_ind flag in
108: -- IGF_AW_AWD_DISB table to 'Y'.
109: -- enh bug no-2154941.
110: ---------------------------------------------------------------------------------
111: -- ssawhney 2nd jan TBH call of IGF_AW_AWD_DISB table
112: -- changed in Stud Emp build
113: -- en bug no 2161847
114: ---------------------------------------------------------------------------------
115: -- mesriniv 13/07/2001 Bug 1806850

Line 117: -- igf_aw_awd_disb_pkg.update_row since 9 columns

113: -- en bug no 2161847
114: ---------------------------------------------------------------------------------
115: -- mesriniv 13/07/2001 Bug 1806850
116: -- Modified the call to
117: -- igf_aw_awd_disb_pkg.update_row since 9 columns
118: -- were added to the table igf_aw_awd_disb_all.
119: ---------------------------------------------------------------------------------
120: -- ENH BUG NO: 1769051 ENH DESCRIPTION: Loan Processing -
121: -- Nov 2001 DLD

Line 118: -- were added to the table igf_aw_awd_disb_all.

114: ---------------------------------------------------------------------------------
115: -- mesriniv 13/07/2001 Bug 1806850
116: -- Modified the call to
117: -- igf_aw_awd_disb_pkg.update_row since 9 columns
118: -- were added to the table igf_aw_awd_disb_all.
119: ---------------------------------------------------------------------------------
120: -- ENH BUG NO: 1769051 ENH DESCRIPTION: Loan Processing -
121: -- Nov 2001 DLD
122: ---------------------------------------------------------------------------------

Line 3311: Format @8 Record with Data in the IGF_AW_AWD_DISB table

3307: /***************************************************************
3308: Created By : mesriniv
3309: Date Created By : 2000/12/07
3310: Purpose : To Compare the Disbursement Amounts specified in the
3311: Format @8 Record with Data in the IGF_AW_AWD_DISB table
3312: Known Limitations,Enhancements or Remarks
3313: Change History :
3314: Who When What
3315: bvisvana 12-Sept-2005 Bug # 4575843.

Line 3321: l_award_id igf_aw_awd_disb_all.award_id%TYPE;

3317: ***************************************************************/
3318:
3319: l_old_count NUMBER;
3320: l_new_count NUMBER;
3321: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
3322: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
3323: l_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
3324:
3325:

Line 3322: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

3318:
3319: l_old_count NUMBER;
3320: l_new_count NUMBER;
3321: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
3322: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
3323: l_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
3324:
3325:
3326: --Count the No.of Disbursements for the award id in Awards Disbursements Table

Line 3323: l_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;

3319: l_old_count NUMBER;
3320: l_new_count NUMBER;
3321: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
3322: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
3323: l_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
3324:
3325:
3326: --Count the No.of Disbursements for the award id in Awards Disbursements Table
3327: CURSOR cur_count_old_disb

Line 3329: SELECT award_id, NVL(COUNT(disb_num),0) FROM igf_aw_awd_disb

3325:
3326: --Count the No.of Disbursements for the award id in Awards Disbursements Table
3327: CURSOR cur_count_old_disb
3328: IS
3329: SELECT award_id, NVL(COUNT(disb_num),0) FROM igf_aw_awd_disb
3330: WHERE award_id = (SELECT award_id FROM igf_sl_loans
3331: WHERE NVL(external_loan_id_txt,loan_number) = p_loan_number)
3332: GROUP BY award_id;
3333:

Line 3346: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb

3342: -- currently in our system.
3343: CURSOR cur_disb_same_data IS
3344: SELECT disb_num, disb_gross_amt FROM
3345: ((
3346: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
3347: WHERE award_id = l_award_id
3348: MINUS
3349: SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8
3350: WHERE clrp1_id = loaded_1rec.clrp1_id

Line 3356: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb

3352: UNION ALL
3353: (SELECT clrp8_id, disb_gross_amt FROM igf_sl_cl_resp_r8_all clrp8
3354: WHERE clrp1_id = loaded_1rec.clrp1_id
3355: MINUS
3356: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
3357: WHERE award_id = l_award_id
3358: )
3359: );
3360:

Line 3372: SELECT * FROM igf_aw_awd_disb

3368:
3369: --Select the old Disbursements for the award id in Awards Disbursements Table
3370: CURSOR cur_old_disbursements
3371: IS
3372: SELECT * FROM igf_aw_awd_disb
3373: WHERE award_id = l_award_id
3374: ORDER BY disb_num;
3375:
3376:

Line 3539: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS

3535: WHERE clrp1_id = loaded_1rec.clrp1_id
3536: AND resp_record_status = p_rec_status;
3537:
3538: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,
3539: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
3540: SELECT adisb.* FROM igf_aw_awd_disb adisb
3541: WHERE award_id = p_award_id AND disb_num = p_disb_num
3542: FOR UPDATE OF manual_hold_ind NOWAIT;
3543: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;

Line 3540: SELECT adisb.* FROM igf_aw_awd_disb adisb

3536: AND resp_record_status = p_rec_status;
3537:
3538: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,
3539: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
3540: SELECT adisb.* FROM igf_aw_awd_disb adisb
3541: WHERE award_id = p_award_id AND disb_num = p_disb_num
3542: FOR UPDATE OF manual_hold_ind NOWAIT;
3543: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;
3544:

Line 3641: PROCEDURE upd_disb_details(p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

3637: END show_differing_disb_details;
3638:
3639: --Procedure to update award disbursments Fee details with values from the File
3640:
3641: PROCEDURE upd_disb_details(p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
3642: /***************************************************************
3643: Change History :
3644: Who When What
3645: bvisvana 12-Sept-2005 Bug # 4575843

Line 3656: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS

3652: WHERE clrp1_id = loaded_1rec.clrp1_id
3653: AND resp_record_status = p_rec_status;
3654:
3655: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,
3656: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
3657: SELECT adisb.* FROM igf_aw_awd_disb adisb
3658: WHERE award_id = p_award_id AND disb_num = p_disb_num
3659: FOR UPDATE OF manual_hold_ind NOWAIT;
3660: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;

Line 3657: SELECT adisb.* FROM igf_aw_awd_disb adisb

3653: AND resp_record_status = p_rec_status;
3654:
3655: CURSOR c_tbh_cur(p_award_id igf_aw_award.award_id%TYPE,
3656: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
3657: SELECT adisb.* FROM igf_aw_awd_disb adisb
3658: WHERE award_id = p_award_id AND disb_num = p_disb_num
3659: FOR UPDATE OF manual_hold_ind NOWAIT;
3660: l_resp_record_status igf_sl_cl_resp_r8_all.resp_record_status%TYPE;
3661: BEGIN

Line 3689: igf_aw_awd_disb_pkg.update_row (

3685: fnd_message.set_token('DISB_NUM',loc_disb.clrp8_id);
3686: fnd_file.put_line(fnd_file.log,fnd_message.get);
3687:
3688: -- Update Flag Check
3689: igf_aw_awd_disb_pkg.update_row (
3690: x_Mode => 'R',
3691: x_rowid => tbh_rec.row_id,
3692: x_award_id => tbh_rec.award_id,
3693: x_disb_num => tbh_rec.disb_num,

Line 3765: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb_all.award_id%TYPE)

3761:
3762: END upd_disb_details;
3763:
3764:
3765: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb_all.award_id%TYPE)
3766: AS
3767: CURSOR c_tbh_cur(p_trans_type igf_aw_awd_disb.trans_type%TYPE)
3768: IS
3769: SELECT adisb.* FROM igf_aw_awd_disb adisb

Line 3767: CURSOR c_tbh_cur(p_trans_type igf_aw_awd_disb.trans_type%TYPE)

3763:
3764:
3765: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb_all.award_id%TYPE)
3766: AS
3767: CURSOR c_tbh_cur(p_trans_type igf_aw_awd_disb.trans_type%TYPE)
3768: IS
3769: SELECT adisb.* FROM igf_aw_awd_disb adisb
3770: WHERE award_id = p_award_id and
3771: trans_type = p_trans_type ;

Line 3769: SELECT adisb.* FROM igf_aw_awd_disb adisb

3765: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb_all.award_id%TYPE)
3766: AS
3767: CURSOR c_tbh_cur(p_trans_type igf_aw_awd_disb.trans_type%TYPE)
3768: IS
3769: SELECT adisb.* FROM igf_aw_awd_disb adisb
3770: WHERE award_id = p_award_id and
3771: trans_type = p_trans_type ;
3772:
3773: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,