eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 381: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

377: WHERE person_id = cp_person_id AND
378: admission_appl_number = cp_admission_appl_number AND
379: nominated_course_cd = cp_nominated_course_cd;
380: CURSOR c_apcs (
381: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
382: cp_s_admission_process_type
383: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
384: SELECT s_admission_step_type,
385: step_type_restriction_num

Line 383: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

379: nominated_course_cd = cp_nominated_course_cd;
380: CURSOR c_apcs (
381: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
382: cp_s_admission_process_type
383: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
384: SELECT s_admission_step_type,
385: step_type_restriction_num
386: FROM IGS_AD_PRCS_CAT_STEP
387: WHERE admission_cat = cp_admission_cat AND

Line 386: FROM IGS_AD_PRCS_CAT_STEP

382: cp_s_admission_process_type
383: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
384: SELECT s_admission_step_type,
385: step_type_restriction_num
386: FROM IGS_AD_PRCS_CAT_STEP
387: WHERE admission_cat = cp_admission_cat AND
388: s_admission_process_type = cp_s_admission_process_type AND
389: step_group_type <> 'TRACK'; --2402377
390: CURSOR c_pti (

Line 1954: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

1950: p_updating IN BOOLEAN,
1951: p_deleting IN BOOLEAN
1952: ) IS
1953: CURSOR c_apcs (
1954: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
1955: cp_s_admission_process_type
1956: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
1957: SELECT s_admission_step_type,
1958: step_type_restriction_num

Line 1956: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

1952: ) IS
1953: CURSOR c_apcs (
1954: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
1955: cp_s_admission_process_type
1956: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
1957: SELECT s_admission_step_type,
1958: step_type_restriction_num
1959: FROM IGS_AD_PRCS_CAT_STEP
1960: WHERE admission_cat = cp_admission_cat AND

Line 1959: FROM IGS_AD_PRCS_CAT_STEP

1955: cp_s_admission_process_type
1956: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
1957: SELECT s_admission_step_type,
1958: step_type_restriction_num
1959: FROM IGS_AD_PRCS_CAT_STEP
1960: WHERE admission_cat = cp_admission_cat AND
1961: s_admission_process_type = cp_s_admission_process_type AND
1962: step_group_type <> 'TRACK'; --2402377
1963: v_row_validated boolean := FALSE; -- added as a part of VAW008 to handle mutation