APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_FI_FEE_TYPE

Line 7623: IF NOT igs_fi_fee_type_pkg.get_pk_for_validation (p_usec_sp_fee_rec.fee_type ) THEN

7619: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
7620: p_usec_sp_fee_rec.status := 'E';
7621: END IF;
7622:
7623: IF NOT igs_fi_fee_type_pkg.get_pk_for_validation (p_usec_sp_fee_rec.fee_type ) THEN
7624: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'FEE_TYPE', 'IGS_FI_LOCKBOX', FALSE);
7625: p_usec_sp_fee_rec.status := 'E';
7626: END IF;
7627:

Line 7689: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS

7685: END Assign_default;
7686:
7687: PROCEDURE Business_validation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS
7688:
7689: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
7690: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
7691: FROM igs_fi_fee_type ft,
7692: igs_fi_f_typ_ca_inst ftci,
7693: igs_ca_inst ci,

Line 7691: FROM igs_fi_fee_type ft,

7687: PROCEDURE Business_validation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS
7688:
7689: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
7690: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
7691: FROM igs_fi_fee_type ft,
7692: igs_fi_f_typ_ca_inst ftci,
7693: igs_ca_inst ci,
7694: igs_ca_type ct,
7695: igs_ca_stat cs

Line 10251: IF NOT igs_fi_fee_type_pkg.get_pk_for_validation (p_usec_ret_rec.fee_type ) THEN

10247: RETURN;
10248: END IF;
10249:
10250: --Check for the existence of the Fee Type
10251: IF NOT igs_fi_fee_type_pkg.get_pk_for_validation (p_usec_ret_rec.fee_type ) THEN
10252: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'FEE_TYPE', 'IGS_FI_LOCKBOX', FALSE);
10253: p_usec_ret_rec.status := 'E';
10254: END IF;
10255:

Line 10349: FROM igs_fi_fee_type ft,

10345: l_message_name VARCHAR2(30);
10346:
10347: CURSOR cur_fee(cp_fee_type IN VARCHAR2) IS
10348: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
10349: FROM igs_fi_fee_type ft,
10350: igs_fi_f_typ_ca_inst ftci,
10351: igs_ca_inst ci,
10352: igs_ca_type ct,
10353: igs_ca_stat cs