DBA Data[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_SL_GEN

Line 2544: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'

2540:
2541: -- FA 122 Loan Enhancents 30-sep-2003 Added the base_id parameter to the get_loan_fee1 , get_loan_fee1 calls
2542:
2543: -- Get the Direct and Federal/Common Loan limit Amounts
2544: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'
2545: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
2546: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
2547: l_fmast.ci_cal_type ,
2548: l_fmast.ci_sequence_number,

Line 2545: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN

2541: -- FA 122 Loan Enhancents 30-sep-2003 Added the base_id parameter to the get_loan_fee1 , get_loan_fee1 calls
2542:
2543: -- Get the Direct and Federal/Common Loan limit Amounts
2544: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'
2545: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
2546: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
2547: l_fmast.ci_cal_type ,
2548: l_fmast.ci_sequence_number,
2549: l_base_id,

Line 2554: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN

2550: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));
2551: END IF;
2552:
2553: -- Get the Guarantor fee % for Commonline Loans
2554: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
2555: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,
2556: l_fmast.ci_cal_type ,
2557: l_fmast.ci_sequence_number,
2558: l_base_id,

Line 2728: ( (igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE') OR

2724: -- Delay Disb date by the "disb_delay_days" if necessary
2725: -- Check for disbursement delay days linked to NSLDS only for the first disbusement
2726: -- Note- NSLDS is applicable only for DL and CL loans
2727: IF (l_disb_num = 1) AND
2728: ( (igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE') OR
2729: (igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE')
2730: ) THEN
2731:
2732: l_disb_date1 := NULL;

Line 2729: (igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE')

2725: -- Check for disbursement delay days linked to NSLDS only for the first disbusement
2726: -- Note- NSLDS is applicable only for DL and CL loans
2727: IF (l_disb_num = 1) AND
2728: ( (igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE') OR
2729: (igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE')
2730: ) THEN
2731:
2732: l_disb_date1 := NULL;
2733: OPEN c_nslds ( l_person_number.person_id );

Line 2771: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

2767: l_fee_amt1 := NULL;
2768: l_fee_amt2 := NULL;
2769:
2770: -- masehgal TRUNC these values also .. then use these for "other than" dl computations
2771: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2772: l_fee_amt1 := NVL(l_awd_disb.offered_amt,0) * (NVL(l_fee1,0) / 100) ;
2773: l_fee_amt1 := TRUNC(l_fee_amt1);
2774: ELSE
2775: l_fee_amt1 := 0;

Line 2782: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

2778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2779: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after truncating, l_fee_amt1 is '||l_fee_amt1);
2780: END IF;
2781: -- Get the Guarantor fee for Commonline Loans
2782: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2783: l_fee_amt2 := NVL(l_awd_disb.offered_amt,0) * (NVL(l_fee2,0) / 100) ;
2784: l_fee_amt2 := TRUNC(l_fee_amt2);
2785: ELSE
2786: l_fee_amt2 := 0;

Line 2795: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

2791: END IF;
2792:
2793: -- For LOANs, get the Hold Release Indicator which is defined at the fund level
2794: -- FA 122 Loans Enhancemnets added the l_auto_late_ind variable to get the auto_late_ind
2795: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2796: l_hold_rel_ind := igf_sl_award.get_cl_hold_rel_ind(
2797: l_fmast.fed_fund_code,
2798: l_fmast.ci_cal_type,
2799: l_fmast.ci_sequence_number,

Line 2845: IF igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

2841: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'for last disb insert remaining amount!ln_db_act_gross_amt:'||ln_db_act_gross_amt);
2843: END IF;
2844: -- Incase of Direct Loans round off amounts
2845: IF igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2846: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
2848: END IF;
2849: -- sjadhav Bug 2411031

Line 2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');

2843: END IF;
2844: -- Incase of Direct Loans round off amounts
2845: IF igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2846: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
2848: END IF;
2849: -- sjadhav Bug 2411031
2850: -- Changed sequence of calling igf_sl_award.get_loan_amts and igf_sl_roundoff_digits_pkg.gross_fees_roundoff.
2851: -- This is done becuase first round off disbursement gross amount should be calculated first and then net amount / fee amount etc

Line 2884: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

2880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after calling igf_sl_award.get_loan_amts,l_awd_disb.temp_num_val1:'||l_awd_disb.temp_num_val1);
2881: END IF;
2882:
2883: -- masehgal rounding off for CL
2884: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
2887: END IF;
2888: -- we are passing dummys here for Net and Fee amount as they will be calculated later on

Line 2886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');

2882:
2883: -- masehgal rounding off for CL
2884: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
2887: END IF;
2888: -- we are passing dummys here for Net and Fee amount as they will be calculated later on
2889: igf_sl_roundoff_digits_pkg.cl_gross_fees_roundoff(
2890: p_last_disb_num => ln_total_disb_num,

Line 2906: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');

2902: l_rebate := NULL;
2903:
2904: ELSE
2905: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2906: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
2907: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
2908: END IF;
2909: -- For funds other than the loans, calculate the Total Net amount
2910: l_awd_disb.temp_num_val1 := NVL(ln_db_act_gross_amt, 0);

Line 2907: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');

2903:
2904: ELSE
2905: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2906: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
2907: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
2908: END IF;
2909: -- For funds other than the loans, calculate the Total Net amount
2910: l_awd_disb.temp_num_val1 := NVL(ln_db_act_gross_amt, 0);
2911: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3232: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'

3228:
3229: -- FA 122 Loan Enhancents 30-sep-2003 Added the base_id parameter to the get_loan_fee1 , get_loan_fee1 calls
3230:
3231: -- Get the Direct and Federal/Common Loan limit Amounts
3232: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'
3233: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
3234: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
3235: l_fmast.ci_cal_type ,
3236: l_fmast.ci_sequence_number,

Line 3233: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN

3229: -- FA 122 Loan Enhancents 30-sep-2003 Added the base_id parameter to the get_loan_fee1 , get_loan_fee1 calls
3230:
3231: -- Get the Direct and Federal/Common Loan limit Amounts
3232: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'
3233: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
3234: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
3235: l_fmast.ci_cal_type ,
3236: l_fmast.ci_sequence_number,
3237: l_base_id,

Line 3242: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN

3238: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));
3239: END IF;
3240:
3241: -- Get the Guarantor fee % for Commonline Loans
3242: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
3243: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,
3244: l_fmast.ci_cal_type ,
3245: l_fmast.ci_sequence_number,
3246: l_base_id,

Line 3399: ( (igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE') OR

3395: -- Delay Disb date by the "disb_delay_days" if necessary
3396: -- Check for disbursement delay days linked to NSLDS only for the first disbusement
3397: -- Note- NSLDS is applicable only for DL and CL loans
3398: IF (l_disb_num = 1) AND
3399: ( (igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE') OR
3400: (igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE')
3401: ) THEN
3402:
3403: l_disb_date1 := NULL;

Line 3400: (igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE')

3396: -- Check for disbursement delay days linked to NSLDS only for the first disbusement
3397: -- Note- NSLDS is applicable only for DL and CL loans
3398: IF (l_disb_num = 1) AND
3399: ( (igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE') OR
3400: (igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE')
3401: ) THEN
3402:
3403: l_disb_date1 := NULL;
3404: OPEN c_nslds ( l_person_number.person_id );

Line 3443: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

3439: l_fee_amt1 := NULL;
3440: l_fee_amt2 := NULL;
3441:
3442: -- masehgal TRUNC these values also .. then use these for "other than" dl computations
3443: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3444: l_fee_amt1 := NVL(l_awd_disb.offered_amt,0) * (NVL(l_fee1,0) / 100) ;
3445: l_fee_amt1 := TRUNC(l_fee_amt1);
3446: ELSE
3447: l_fee_amt1 := 0;

Line 3454: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

3450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after truncating, l_fee_amt1 is '||l_fee_amt1);
3452: END IF;
3453: -- Get the Guarantor fee for Commonline Loans
3454: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3455: l_fee_amt2 := NVL(l_awd_disb.offered_amt,0) * (NVL(l_fee2,0) / 100) ;
3456: l_fee_amt2 := TRUNC(l_fee_amt2);
3457: ELSE
3458: l_fee_amt2 := 0;

Line 3467: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

3463: END IF;
3464:
3465: -- For LOANs, get the Hold Release Indicator which is defined at the fund level
3466: -- FA 122 Loans Enhancemnets added the l_auto_late_ind variable to get the auto_late_ind
3467: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3468: l_hold_rel_ind := igf_sl_award.get_cl_hold_rel_ind(
3469: l_fmast.fed_fund_code,
3470: l_fmast.ci_cal_type,
3471: l_fmast.ci_sequence_number,

Line 3517: IF igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

3513: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3514: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'for last disb insert remaining amount!ln_db_act_gross_amt:'||ln_db_act_gross_amt);
3515: END IF;
3516: -- Incase of Direct Loans round off amounts
3517: IF igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3518: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
3520: END IF;
3521: -- sjadhav Bug 2411031

Line 3519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');

3515: END IF;
3516: -- Incase of Direct Loans round off amounts
3517: IF igf_sl_gen.chk_dl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3518: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
3520: END IF;
3521: -- sjadhav Bug 2411031
3522: -- Changed sequence of calling igf_sl_award.get_loan_amts and igf_sl_roundoff_digits_pkg.gross_fees_roundoff.
3523: -- This is done becuase first round off disbursement gross amount should be calculated first and then net amount / fee amount etc

Line 3553: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

3549: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after calling igf_sl_award.get_loan_amts,l_awd_disb.temp_num_val1:'||l_awd_disb.temp_num_val1);
3550: END IF;
3551:
3552: -- masehgal rounding off for CL
3553: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3554: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
3556: END IF;
3557: -- we are passing dummys here for Net and Fee amount as they will be calculated later on

Line 3555: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');

3551:
3552: -- masehgal rounding off for CL
3553: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3554: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
3556: END IF;
3557: -- we are passing dummys here for Net and Fee amount as they will be calculated later on
3558: igf_sl_roundoff_digits_pkg.cl_gross_fees_roundoff(
3559: p_last_disb_num => ln_total_disb_num,

Line 3575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');

3571: l_rebate := NULL;
3572:
3573: ELSE
3574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
3576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
3577: END IF;
3578: -- For funds other than the loans, calculate the Total Net amount
3579: l_awd_disb.temp_num_val1 := NVL(ln_db_act_gross_amt, 0);

Line 3576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');

3572:
3573: ELSE
3574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
3576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_cl_fed_fund_code('||l_fmast.fed_fund_code||')=FALSE');
3577: END IF;
3578: -- For funds other than the loans, calculate the Total Net amount
3579: l_awd_disb.temp_num_val1 := NVL(ln_db_act_gross_amt, 0);
3580: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN