APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_AD_PRCS_CAT_STEP

Line 325: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

321:
322:
323:
324: CURSOR c_apcs (
325: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
326: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
327: SELECT
328: 'Y'
329: FROM

Line 326: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

322:
323:
324: CURSOR c_apcs (
325: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
326: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
327: SELECT
328: 'Y'
329: FROM
330: IGS_AD_PRCS_CAT_STEP

Line 330: IGS_AD_PRCS_CAT_STEP

326: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
327: SELECT
328: 'Y'
329: FROM
330: IGS_AD_PRCS_CAT_STEP
331: WHERE
332: admission_cat = cp_s_admission_process_type
333: AND s_admission_process_type = cp_s_admission_process_type
334: AND s_admission_step_type = 'PRE-ENROL'

Line 370: CURSOR c_check_reconsider (cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE,

366: v_message_name VARCHAR2(2000);
367: v_warn_level VARCHAR2(2000);
368:
369: -- cursor to get whether APC step of RECONSIDER is attached to the given APC (rghosh bug#2860852 - Request for Reconsideration Import)
370: CURSOR c_check_reconsider (cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE,
371: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
372: SELECT 'X'
373: FROM IGS_AD_PRCS_CAT_STEP
374: WHERE admission_cat = cp_admission_cat

Line 371: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

367: v_warn_level VARCHAR2(2000);
368:
369: -- cursor to get whether APC step of RECONSIDER is attached to the given APC (rghosh bug#2860852 - Request for Reconsideration Import)
370: CURSOR c_check_reconsider (cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE,
371: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
372: SELECT 'X'
373: FROM IGS_AD_PRCS_CAT_STEP
374: WHERE admission_cat = cp_admission_cat
375: AND s_admission_process_type = cp_s_admission_process_type

Line 373: FROM IGS_AD_PRCS_CAT_STEP

369: -- cursor to get whether APC step of RECONSIDER is attached to the given APC (rghosh bug#2860852 - Request for Reconsideration Import)
370: CURSOR c_check_reconsider (cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE,
371: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
372: SELECT 'X'
373: FROM IGS_AD_PRCS_CAT_STEP
374: WHERE admission_cat = cp_admission_cat
375: AND s_admission_process_type = cp_s_admission_process_type
376: AND s_admission_step_type = 'RECONSIDER';
377: