APPS.IGS_FI_F_CAT_FEE_LBL_PKG dependencies on IGS_FI_FEE_AS

Line 117: -- checks if there are records in the IGS_FI_FEE_AS table

113: SELECT s_fee_trigger_cat
114: FROM igs_fi_fee_type
115: WHERE fee_type = cp_fee_type;
116:
117: -- checks if there are records in the IGS_FI_FEE_AS table
118: -- for the input FTCI and a NULL fee Category.
119: CURSOR c_ftci(cp_fee_type IN igs_fi_fee_as.fee_type%TYPE,
120: cp_fee_cal_type IN igs_fi_fee_as.fee_cal_type%TYPE,
121: cp_fee_ci_sequence_number IN igs_fi_fee_as.fee_ci_sequence_number%TYPE

Line 119: CURSOR c_ftci(cp_fee_type IN igs_fi_fee_as.fee_type%TYPE,

115: WHERE fee_type = cp_fee_type;
116:
117: -- checks if there are records in the IGS_FI_FEE_AS table
118: -- for the input FTCI and a NULL fee Category.
119: CURSOR c_ftci(cp_fee_type IN igs_fi_fee_as.fee_type%TYPE,
120: cp_fee_cal_type IN igs_fi_fee_as.fee_cal_type%TYPE,
121: cp_fee_ci_sequence_number IN igs_fi_fee_as.fee_ci_sequence_number%TYPE
122: ) IS
123: SELECT 'x'

Line 120: cp_fee_cal_type IN igs_fi_fee_as.fee_cal_type%TYPE,

116:
117: -- checks if there are records in the IGS_FI_FEE_AS table
118: -- for the input FTCI and a NULL fee Category.
119: CURSOR c_ftci(cp_fee_type IN igs_fi_fee_as.fee_type%TYPE,
120: cp_fee_cal_type IN igs_fi_fee_as.fee_cal_type%TYPE,
121: cp_fee_ci_sequence_number IN igs_fi_fee_as.fee_ci_sequence_number%TYPE
122: ) IS
123: SELECT 'x'
124: FROM igs_fi_fee_as

Line 121: cp_fee_ci_sequence_number IN igs_fi_fee_as.fee_ci_sequence_number%TYPE

117: -- checks if there are records in the IGS_FI_FEE_AS table
118: -- for the input FTCI and a NULL fee Category.
119: CURSOR c_ftci(cp_fee_type IN igs_fi_fee_as.fee_type%TYPE,
120: cp_fee_cal_type IN igs_fi_fee_as.fee_cal_type%TYPE,
121: cp_fee_ci_sequence_number IN igs_fi_fee_as.fee_ci_sequence_number%TYPE
122: ) IS
123: SELECT 'x'
124: FROM igs_fi_fee_as
125: WHERE fee_type = cp_fee_type

Line 124: FROM igs_fi_fee_as

120: cp_fee_cal_type IN igs_fi_fee_as.fee_cal_type%TYPE,
121: cp_fee_ci_sequence_number IN igs_fi_fee_as.fee_ci_sequence_number%TYPE
122: ) IS
123: SELECT 'x'
124: FROM igs_fi_fee_as
125: WHERE fee_type = cp_fee_type
126: AND fee_cal_type = cp_fee_cal_type
127: AND fee_ci_sequence_number = cp_fee_ci_sequence_number
128: AND fee_cat IS NULL;

Line 218: -- This is introduced to implement the foreign key IGS_FI_FEE_AS_PKG.GET_FK_IGS_FI_F_CAT_FEE_LBL

214: -- added by schodava
215: -- If the system Fee trigger category is 'INSTITUTION' then,
216: -- Check whether the fee type calendar instance is present in the Fee Assessment table.
217: -- If it is, then restrict deletion of the Fee type from the IGS_FI_F_CAT_FEE_LBL_ALL table.
218: -- This is introduced to implement the foreign key IGS_FI_FEE_AS_PKG.GET_FK_IGS_FI_F_CAT_FEE_LBL
219: -- for a null fee_cat in the IGS_FI_FEE_AS table.
220:
221: END BeforeRowInsertUpdateDelete1;
222:

Line 219: -- for a null fee_cat in the IGS_FI_FEE_AS table.

215: -- If the system Fee trigger category is 'INSTITUTION' then,
216: -- Check whether the fee type calendar instance is present in the Fee Assessment table.
217: -- If it is, then restrict deletion of the Fee type from the IGS_FI_F_CAT_FEE_LBL_ALL table.
218: -- This is introduced to implement the foreign key IGS_FI_FEE_AS_PKG.GET_FK_IGS_FI_F_CAT_FEE_LBL
219: -- for a null fee_cat in the IGS_FI_FEE_AS table.
220:
221: END BeforeRowInsertUpdateDelete1;
222:
223: -- Trigger description :-