[Home] [Help]
62: TYPE crdrec IS RECORD(credit_id IGS_FI_CREDITS.Credit_Id%TYPE,
63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,
64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
67: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE,
68: credit_number IGS_FI_CREDITS.Credit_Number%TYPE);
69:
70: -- PL/SQL table for storing the credit records which are to be processed for
63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,
64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
67: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE,
68: credit_number IGS_FI_CREDITS.Credit_Number%TYPE);
69:
70: -- PL/SQL table for storing the credit records which are to be processed for
71: -- refunds
77: l_rfnd_cntr NUMBER(15);
78:
79: -- PL/SQL record for the distinct Sub Account and FTCI combination
80: TYPE rfndfee IS RECORD(fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
81: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
82: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE);
83:
84: -- PL/SQL table for storing the distinct fee periods to be refunded
85: TYPE rfndtab IS TABLE OF rfndfee
78:
79: -- PL/SQL record for the distinct Sub Account and FTCI combination
80: TYPE rfndfee IS RECORD(fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
81: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
82: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE);
83:
84: -- PL/SQL table for storing the distinct fee periods to be refunded
85: TYPE rfndtab IS TABLE OF rfndfee
86: INDEX BY BINARY_INTEGER;
278: AND cp_effective_date BETWEEN effective_start_date AND NVL(effective_end_date,cp_effective_date);
279:
280: -- Variables of data type as the column of a table
281: l_fee_type igs_fi_fee_type.fee_type%TYPE;
282: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
279:
280: -- Variables of data type as the column of a table
281: l_fee_type igs_fi_fee_type.fee_type%TYPE;
282: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
760: -- Cursor for getting the Fee Calendar Instance details.
761: CURSOR cur_cal(cp_cal_type VARCHAR2,
762: cp_seq_num NUMBER) IS
763: SELECT cal_type||' '||to_char(start_dt)||' '||to_char(end_dt) fee_prd
764: FROM igs_ca_inst
765: WHERE cal_type = cp_cal_type
766: AND sequence_number = cp_seq_num;
767:
768: -- Cursor for getting the Invoice Number based on the Invoice Id
791: l_reason fnd_new_messages.message_text%TYPE;
792: l_err_msg fnd_new_messages.message_name%TYPE;
793: l_determination igs_lookups_view.lookup_code%TYPE;
794: l_fee_type igs_fi_fee_type.fee_type%TYPE;
795: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
796: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;
798: l_party_number igs_fi_parties_v.person_number%TYPE;
799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
792: l_err_msg fnd_new_messages.message_name%TYPE;
793: l_determination igs_lookups_view.lookup_code%TYPE;
794: l_fee_type igs_fi_fee_type.fee_type%TYPE;
795: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
796: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;
798: l_party_number igs_fi_parties_v.person_number%TYPE;
799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;