[Home] [Help]
85: IS
86: /***************************************************************
87: Created By : SYkrishn
88: Date Created By : APR/05/2002
89: Purpose : Gets the value of planned credits indicator from IGS_FI_CONTROL_ALL.
90: Known Limitations,Enhancements or Remarks:
91: Change History :
92: Who When What
93:
92: Who When What
93:
94: ***************************************************************/
95:
96: l_v_planned_credits_ind igs_fi_control_all.planned_credits_ind%TYPE := NULL;
97: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
98:
99: BEGIN
100: --Call the genric function to get the value
439: l_return_stat BOOLEAN;
440:
441: -- Changes due to SFCR018
442: -- Call the local function to get the value of planned_credits_ind
443: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
444: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
445: l_n_planned_credit igs_fi_credits.amount%TYPE := 0;
446: -- Changes due to SFCR018
447:
609: WHERE fee_type = cp_fee_type;
610:
611: l_cur_desc igs_fi_inv_int.invoice_desc%TYPE;
612:
613: l_v_currency igs_fi_control_all.currency_cd%TYPE;
614: l_v_curr_desc fnd_currencies_tl.name%TYPE;
615: l_v_message_name fnd_new_messages.message_name%TYPE;
616: l_v_tran_type igs_lookup_values.meaning%TYPE := lookup_desc('TRANSACTION_TYPE',p_cur_plan.plan_type);
617: l_v_pmt_plan igs_lookup_values.meaning%TYPE := lookup_desc('IGS_FI_LOCKBOX','PAYMENT_PLAN');
1292: l_grt_min_bal_amt BOOLEAN := TRUE;
1293:
1294: -- Changes due to SFCR018
1295: -- Call the local function to get the value of planned_credits_ind
1296: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
1297: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
1298: l_n_planned_credit igs_fi_credits.amount%TYPE := 0;
1299: --changes due to Enh#2562745.
1300: l_message_name fnd_new_messages.message_name%TYPE;