APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_F_TYP_CA_INST

Line 122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

118:
119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;
121:
122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
124: p_c_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
125: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
126: /***********************************************************************************************

Line 123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;
121:
122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
124: p_c_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
125: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
126: /***********************************************************************************************
127:

Line 124: p_c_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,

120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;
121:
122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
124: p_c_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
125: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
126: /***********************************************************************************************
127:
128: Created By: Amit Gairola

Line 149: CURSOR cur_ftci(cp_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

145: l_temp VARCHAR2(1);
146: l_bool BOOLEAN;
147:
148: -- Cursor for validating the Fee Type Calendar Instance for active FTCI
149: CURSOR cur_ftci(cp_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
150: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
151: cp_c_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS

Line 150: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

146: l_bool BOOLEAN;
147:
148: -- Cursor for validating the Fee Type Calendar Instance for active FTCI
149: CURSOR cur_ftci(cp_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
150: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
151: cp_c_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
154: SELECT 'x'

Line 151: cp_c_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

147:
148: -- Cursor for validating the Fee Type Calendar Instance for active FTCI
149: CURSOR cur_ftci(cp_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
150: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
151: cp_c_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
154: SELECT 'x'
155: FROM igs_fi_f_typ_ca_inst ftci,

Line 155: FROM igs_fi_f_typ_ca_inst ftci,

151: cp_c_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
154: SELECT 'x'
155: FROM igs_fi_f_typ_ca_inst ftci,
156: igs_fi_fee_str_stat fsst
157: WHERE ftci.fee_cal_type = cp_c_fee_cal_type
158: AND ftci.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
159: AND ftci.fee_type = cp_c_fee_type

Line 1212: sapanigr 09-Feb-2006 Bug 5018036 - Modifed cursor 'cur_ret' to take values from base table 'igs_fi_f_typ_ca_inst_all'.

1208: format amounts by rounding off to currency precision
1209: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_inv_int
1210: and igs_fi_invln_int are now rounded off to currency precision
1211: sapanigr 24-Feb-2006 Bug 5018036 - Removed cursor 'cur_ret' and cursor variable 'l_ret_rec' as it was not being used anywhere in the code.
1212: sapanigr 09-Feb-2006 Bug 5018036 - Modifed cursor 'cur_ret' to take values from base table 'igs_fi_f_typ_ca_inst_all'.
1213: The view igs_fi_f_typ_ca_inst_lkp_v used earlier lead to high shared memory usage.
1214: abshriva 24-Oct-2005 Bug 4680553 - The Message 'IGS_FI_WAV_TRANS_CREATED' was removed as it was being
1215: called in error page when waiver transaction was successful
1216: pathipat 05-Oct-2005 Bug 4383148 - Fees not assessed if attendance type cannot be derived

Line 1213: The view igs_fi_f_typ_ca_inst_lkp_v used earlier lead to high shared memory usage.

1209: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_inv_int
1210: and igs_fi_invln_int are now rounded off to currency precision
1211: sapanigr 24-Feb-2006 Bug 5018036 - Removed cursor 'cur_ret' and cursor variable 'l_ret_rec' as it was not being used anywhere in the code.
1212: sapanigr 09-Feb-2006 Bug 5018036 - Modifed cursor 'cur_ret' to take values from base table 'igs_fi_f_typ_ca_inst_all'.
1213: The view igs_fi_f_typ_ca_inst_lkp_v used earlier lead to high shared memory usage.
1214: abshriva 24-Oct-2005 Bug 4680553 - The Message 'IGS_FI_WAV_TRANS_CREATED' was removed as it was being
1215: called in error page when waiver transaction was successful
1216: pathipat 05-Oct-2005 Bug 4383148 - Fees not assessed if attendance type cannot be derived
1217: Removed invocation of validate_atd_mode and validate_atd_type