APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_PRCS_CAT_STEP

Line 364: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

360: v_cond_offer_fee_allowed_ind VARCHAR2(1) DEFAULT 'N';
361: cst_error CONSTANT VARCHAR2(1) := 'E';
362: cst_warn CONSTANT VARCHAR2(1) := 'W';
363: CURSOR c_apcs (
364: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
365: cp_s_admission_process_type
366: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
367: SELECT s_admission_step_type
368: FROM IGS_AD_PRCS_CAT_STEP

Line 366: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

362: cst_warn CONSTANT VARCHAR2(1) := 'W';
363: CURSOR c_apcs (
364: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
365: cp_s_admission_process_type
366: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
367: SELECT s_admission_step_type
368: FROM IGS_AD_PRCS_CAT_STEP
369: WHERE admission_cat = cp_admission_cat AND
370: s_admission_process_type = cp_s_admission_process_type

Line 368: FROM IGS_AD_PRCS_CAT_STEP

364: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
365: cp_s_admission_process_type
366: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
367: SELECT s_admission_step_type
368: FROM IGS_AD_PRCS_CAT_STEP
369: WHERE admission_cat = cp_admission_cat AND
370: s_admission_process_type = cp_s_admission_process_type
371: AND step_group_type <> 'TRACK';
372: -- Have to find the last admission_appl_number used.

Line 2503: IGS_AD_PRCS_CAT_STEP.step_type_restriction_num%TYPE DEFAULT NULL;

2499: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
2500: v_message_name VARCHAR2(30) DEFAULT 0;
2501: v_return_type VARCHAR2(1) DEFAULT NULL;
2502: v_pref_limit
2503: IGS_AD_PRCS_CAT_STEP.step_type_restriction_num%TYPE DEFAULT NULL;
2504: v_late_appl_allowed_ind VARCHAR2(1) DEFAULT 'N';
2505: v_req_reconsider_allowed_ind VARCHAR2(1) DEFAULT 'N';
2506: v_req_adv_standing_allowed_ind VARCHAR2(1) DEFAULT 'N';
2507: CURSOR c_apcs(

Line 2511: FROM IGS_AD_PRCS_CAT_STEP apcs

2507: CURSOR c_apcs(
2508: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE) IS
2509: SELECT apcs.s_admission_step_type,
2510: step_type_restriction_num
2511: FROM IGS_AD_PRCS_CAT_STEP apcs
2512: WHERE apcs.admission_cat = cp_admission_cat AND
2513: apcs.s_admission_process_type = 'COURSE' AND
2514: apcs.step_group_type <> 'TRACK'; --2402377
2515: lv_rowid VARCHAR2(25);