APPS.IGS_FI_BAL_EX_F_TYPS_PKG dependencies on IGS_FI_FEE_TYPE

Line 99: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (

95:
96: IF (((old_references.fee_type = new_references.fee_type)) OR
97: ((new_references.fee_type IS NULL))) THEN
98: NULL;
99: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
100: new_references.fee_type
101: ) THEN
102: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
103: igs_ge_msg_stack.add;

Line 216: CURSOR c_sft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS

212: || Change History :
213: || Who When What
214: || (reverse chronological order - newest change first)
215: */
216: CURSOR c_sft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
217: SELECT s_fee_type
218: FROM igs_fi_fee_type
219: WHERE fee_type = cp_fee_type ;
220:

Line 218: FROM igs_fi_fee_type

214: || (reverse chronological order - newest change first)
215: */
216: CURSOR c_sft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
217: SELECT s_fee_type
218: FROM igs_fi_fee_type
219: WHERE fee_type = cp_fee_type ;
220:
221: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
222: BEGIN

Line 221: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;

217: SELECT s_fee_type
218: FROM igs_fi_fee_type
219: WHERE fee_type = cp_fee_type ;
220:
221: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
222: BEGIN
223: IF(p_inserting OR p_updating) THEN
224: OPEN c_sft(new_references.fee_type);
225: FETCH c_sft INTO l_s_fee_type;