APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_AW_AWD_DISB_ALL

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