APPS.IGS_AD_GEN_014 dependencies on IGS_AD_PRCS_CAT_STEP

Line 123: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

119: v_cond_offer_fee_allowed_ind VARCHAR2(1) DEFAULT 'N';
120: cst_error CONSTANT VARCHAR2(1) := 'E';
121: cst_warn CONSTANT VARCHAR2(1) := 'W';
122: CURSOR c_apcs (
123: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
124: cp_s_admission_process_type
125: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
126: SELECT s_admission_step_type
127: FROM IGS_AD_PRCS_CAT_STEP

Line 125: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

121: cst_warn CONSTANT VARCHAR2(1) := 'W';
122: CURSOR c_apcs (
123: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
124: cp_s_admission_process_type
125: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
126: SELECT s_admission_step_type
127: FROM IGS_AD_PRCS_CAT_STEP
128: WHERE admission_cat = cp_admission_cat AND
129: s_admission_process_type = cp_s_admission_process_type AND

Line 127: FROM IGS_AD_PRCS_CAT_STEP

123: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
124: cp_s_admission_process_type
125: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
126: SELECT s_admission_step_type
127: FROM IGS_AD_PRCS_CAT_STEP
128: WHERE admission_cat = cp_admission_cat AND
129: s_admission_process_type = cp_s_admission_process_type AND
130: step_group_type <> 'TRACK'; --2402377
131: -- Have to find the last admission_appl_number used.

Line 441: v_pref_limit IGS_AD_PRCS_CAT_STEP.step_type_restriction_num%TYPE DEFAULT NULL;

437: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
438: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
439: v_message_name VARCHAR2(30) DEFAULT 0;
440: v_return_type VARCHAR2(1) DEFAULT NULL;
441: v_pref_limit IGS_AD_PRCS_CAT_STEP.step_type_restriction_num%TYPE DEFAULT NULL;
442: v_late_appl_allowed_ind VARCHAR2(1) DEFAULT 'N';
443: v_req_reconsider_allowed_ind VARCHAR2(1) DEFAULT 'N';
444: v_req_adv_standing_allowed_ind VARCHAR2(1) DEFAULT 'N';
445: v_check_course_encumb VARCHAR2(1) DEFAULT 'N';

Line 455: FROM IGS_AD_PRCS_CAT_STEP

451: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)
452: IS
453: SELECT s_admission_step_type,
454: step_type_restriction_num
455: FROM IGS_AD_PRCS_CAT_STEP
456: WHERE admission_cat = cp_admission_cat AND
457: s_admission_process_type = cp_s_admission_process_type AND
458: step_group_type <> 'TRACK'; -- 2402377
459:

Line 926: FROM IGS_AD_PRCS_CAT_STEP

922: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)
923: IS
924: SELECT s_admission_step_type,
925: step_type_restriction_num
926: FROM IGS_AD_PRCS_CAT_STEP
927: WHERE admission_cat = cp_admission_cat AND
928: s_admission_process_type = cp_s_admission_process_type AND
929: step_group_type <> 'TRACK'; -- 2402377
930:

Line 1821: IGS_AD_PRCS_CAT_STEP

1817: BEGIN
1818: SELECT 'X'
1819: INTO L_VAR
1820: FROM
1821: IGS_AD_PRCS_CAT_STEP
1822: WHERE
1823: S_ADMISSION_STEP_TYPE = 'UN-CRS-LOC'
1824: AND ADMISSION_CAT = p_admission_cat
1825: AND S_ADMISSION_PROCESS_TYPE = p_s_admission_process_type

Line 1837: IGS_AD_PRCS_CAT_STEP

1833: BEGIN
1834: SELECT 'X'
1835: INTO L_VAR
1836: FROM
1837: IGS_AD_PRCS_CAT_STEP
1838: WHERE
1839: S_ADMISSION_STEP_TYPE = 'UN-CRS-MOD'
1840: AND ADMISSION_CAT = p_admission_cat
1841: AND S_ADMISSION_PROCESS_TYPE = p_s_admission_process_type

Line 1853: IGS_AD_PRCS_CAT_STEP

1849: BEGIN
1850: SELECT 'X'
1851: INTO L_VAR
1852: FROM
1853: IGS_AD_PRCS_CAT_STEP
1854: WHERE
1855:
1856: S_ADMISSION_STEP_TYPE = 'UN-CRS-MOD'
1857: AND ADMISSION_CAT = p_admission_cat

Line 1913: SELECT '1' FROM IGS_AD_PRCS_CAT_STEP_ALL

1909:
1910: l_adm_cat_rec c_adm_cat%ROWTYPE;
1911:
1912: CURSOR c_apc_step_included (cp_adm_pro_type IN VARCHAR2, cp_admission_cat IN VARCHAR2,cp_admission_step_type IN VARCHAR2) IS
1913: SELECT '1' FROM IGS_AD_PRCS_CAT_STEP_ALL
1914: WHERE ADMISSION_CAT = cp_admission_cat
1915: AND S_ADMISSION_PROCESS_TYPE =cp_adm_pro_type
1916: AND S_ADMISSION_STEP_TYPE = cp_admission_step_type;
1917: