APPS.IGS_AD_VAL_ACAI dependencies on IGS_CO_CAT

Line 837: FROM IGS_CO_CAT_MAP

833:
834: CURSOR c_ccm (
835: cp_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE) IS
836: SELECT 'x'
837: FROM IGS_CO_CAT_MAP
838: WHERE admission_cat = p_admission_cat AND
839: correspondence_cat = cp_correspondence_cat;
840:
841: CURSOR c_scae IS

Line 2554: FROM IGS_CO_CAT_MAP

2550: -- course attempts the student may have
2551: DECLARE
2552: CURSOR c_ccm IS
2553: Select 'x'
2554: FROM IGS_CO_CAT_MAP
2555: WHERE correspondence_cat = p_correspondence_cat AND
2556: admission_cat = p_admission_cat;
2557: v_x VARCHAR2(1) := NULL;
2558: v_message_name VARCHAR2(30);

Line 2591: -- Validate if IGS_CO_CAT.correspondence_cat is closed.

2587: IGS_GE_MSG_STACK.ADD;
2588: APP_EXCEPTION.RAISE_EXCEPTION;
2589: END admp_val_acai_cc;
2590: --
2591: -- Validate if IGS_CO_CAT.correspondence_cat is closed.
2592: FUNCTION corp_val_cc_closed(
2593: p_correspondence_cat IN VARCHAR2 ,
2594: p_message_name OUT NOCOPY VARCHAR2 )
2595: RETURN BOOLEAN AS

Line 2597: --Validate if IGS_CO_CAT.correspondence_cat is closed

2593: p_correspondence_cat IN VARCHAR2 ,
2594: p_message_name OUT NOCOPY VARCHAR2 )
2595: RETURN BOOLEAN AS
2596: BEGIN --corp_val_cc_closed
2597: --Validate if IGS_CO_CAT.correspondence_cat is closed
2598: DECLARE
2599: v_closed_ind IGS_CO_CAT.closed_ind%TYPE;
2600: CURSOR c_cc IS
2601: SELECT cc.closed_ind

Line 2599: v_closed_ind IGS_CO_CAT.closed_ind%TYPE;

2595: RETURN BOOLEAN AS
2596: BEGIN --corp_val_cc_closed
2597: --Validate if IGS_CO_CAT.correspondence_cat is closed
2598: DECLARE
2599: v_closed_ind IGS_CO_CAT.closed_ind%TYPE;
2600: CURSOR c_cc IS
2601: SELECT cc.closed_ind
2602: FROM IGS_CO_CAT cc
2603: WHERE cc.correspondence_cat = p_correspondence_cat;

Line 2602: FROM IGS_CO_CAT cc

2598: DECLARE
2599: v_closed_ind IGS_CO_CAT.closed_ind%TYPE;
2600: CURSOR c_cc IS
2601: SELECT cc.closed_ind
2602: FROM IGS_CO_CAT cc
2603: WHERE cc.correspondence_cat = p_correspondence_cat;
2604: BEGIN
2605: --- Set the default message number
2606: p_message_name := NULL;