[Home] [Help]
232: rec_cur_remit_addr cur_remit_addr%ROWTYPE;
233: rec_cur_bill_to_addr_usage cur_bill_to_addr_usage%ROWTYPE;
234: --
235:
236: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
237: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
238: l_v_usr_profl_name fnd_profile_options_vl.user_profile_option_name%TYPE := NULL;
239: l_v_bill_usg_lkp_type fnd_lookup_values.lookup_type%TYPE := 'PARTY_SITE_USE_CODE';
240: l_n_use_num NUMBER;
680:
681: l_planned_credits igs_fi_bill_pln_crd.pln_credit_amount%TYPE;
682: l_to_pay_amount igs_fi_bill.to_pay_amount%TYPE;
683: l_message_name fnd_new_messages.message_name%TYPE:=NULL;
684: l_pln_crd_setup igs_fi_control_all.planned_credits_ind%TYPE;
685: l_pln_crd_rowid VARCHAR2(25);
686: l_fee_cal_type igs_fi_bill_pln_crd.fee_cal_type%TYPE;
687: l_fee_ci_seq_num igs_fi_bill_pln_crd.fee_ci_sequence_number%TYPE;
688: l_flag BOOLEAN := TRUE;
686: l_fee_cal_type igs_fi_bill_pln_crd.fee_cal_type%TYPE;
687: l_fee_ci_seq_num igs_fi_bill_pln_crd.fee_ci_sequence_number%TYPE;
688: l_flag BOOLEAN := TRUE;
689: l_bill_desc igs_fi_bill_pln_crd.bill_desc%TYPE;
690: l_c_rec_installed igs_fi_control.rec_installed%TYPE;
691:
692: -- Bug #3813498 To get system fee type and fee class associated with the fee_type
693: CURSOR cur_fee_type(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
694: SELECT s_fee_type, fee_class
732: END IF;
733: CLOSE cur_bill_to_addr;
734:
735: --added as a part of bug:2293676
736: --Fetching the value of planned credits ind from igs_fi_control,
737: --if the out parameter returns any value then return
738: l_pln_crd_setup:=igs_fi_gen_001.finp_get_planned_credits_ind(l_message_name);
739: IF l_message_name IS NOT NULL THEN
740: fnd_message.set_name('IGS',l_message_name);