APPS.IGS_GE_VAL_PARAM dependencies on IGS_FI_FEE_CAT

Line 526: FUNCTION repp_val_fee_cat( p_fee_cat IN OUT NOCOPY IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,

522: -- MODIFICATION HISTORY
523: -- Person Date Comments
524: -- --------- -------- ------------------------------------------
525: -- MSONTER 21/08/98 Initial creation of function
526: FUNCTION repp_val_fee_cat( p_fee_cat IN OUT NOCOPY IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
527: p_msg_name OUT NOCOPY VARCHAR2)
528: RETURN BOOLEAN
529: AS
530: --

Line 532: CURSOR c_crs(cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)

528: RETURN BOOLEAN
529: AS
530: --
531: -- Local Cursors
532: CURSOR c_crs(cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)
533: IS
534: SELECT
535: 'x'
536: FROM IGS_FI_FEE_CAT fc

Line 536: FROM IGS_FI_FEE_CAT fc

532: CURSOR c_crs(cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)
533: IS
534: SELECT
535: 'x'
536: FROM IGS_FI_FEE_CAT fc
537: WHERE
538: fc.fee_cat LIKE cp_fee_cat
539: AND fc.closed_ind = 'N';
540: --

Line 546: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_FI_FEE_CAT','IGS_FI_FEE_CAT')

542: v_ok VARCHAR2(1) := NULL;
543: BEGIN
544: --
545: -- check for uppper case requirement
546: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_FI_FEE_CAT','IGS_FI_FEE_CAT')
547: THEN
548: p_fee_cat := UPPER(p_fee_cat);
549: END IF;
550: --