APPS.IGS_AD_GEN_003 dependencies on IGS_AD_PRCS_CAT_STEP

Line 497: FROM IGS_AD_PRCS_CAT_STEP apcs

493: v_unit_set_step BOOLEAN DEFAULT FALSE;
494: v_un_crs_us BOOLEAN DEFAULT FALSE;
495: CURSOR c_apcs IS
496: SELECT apcs.s_admission_step_type
497: FROM IGS_AD_PRCS_CAT_STEP apcs
498: WHERE admission_cat = p_admission_cat AND
499: s_admission_process_type = p_s_admission_process_type AND
500: mandatory_step_ind = 'Y' AND
501: step_group_type <> 'TRACK'; -- 2402377

Line 753: PROCEDURE get_entr_doc_apc (p_admission_cat IN IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

749: IGS_GE_MSG_STACK.ADD;
750: App_Exception.Raise_Exception;
751: END admp_get_apcs_mndtry;
752:
753: PROCEDURE get_entr_doc_apc (p_admission_cat IN IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
754: p_s_admission_process_type IN IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
755: l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,
756: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE) IS
757: /*****************************************************************************************

Line 754: p_s_admission_process_type IN IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,

750: App_Exception.Raise_Exception;
751: END admp_get_apcs_mndtry;
752:
753: PROCEDURE get_entr_doc_apc (p_admission_cat IN IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
754: p_s_admission_process_type IN IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
755: l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,
756: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE) IS
757: /*****************************************************************************************
758: Created By: [email protected]

Line 766: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

762: Change History
763: Who When What
764: *****************************************************************************************/
765: CURSOR c_apcs_step (
766: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
767: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
768: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
769: SELECT apcs.s_admission_step_type
770: FROM IGS_AD_PRCS_CAT_STEP apcs

Line 767: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,

763: Who When What
764: *****************************************************************************************/
765: CURSOR c_apcs_step (
766: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
767: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
768: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
769: SELECT apcs.s_admission_step_type
770: FROM IGS_AD_PRCS_CAT_STEP apcs
771: WHERE apcs.admission_cat = cp_admission_cat AND

Line 768: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS

764: *****************************************************************************************/
765: CURSOR c_apcs_step (
766: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
767: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
768: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
769: SELECT apcs.s_admission_step_type
770: FROM IGS_AD_PRCS_CAT_STEP apcs
771: WHERE apcs.admission_cat = cp_admission_cat AND
772: apcs.s_admission_process_type = cp_s_admission_process_type AND

Line 770: FROM IGS_AD_PRCS_CAT_STEP apcs

766: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
767: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
768: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
769: SELECT apcs.s_admission_step_type
770: FROM IGS_AD_PRCS_CAT_STEP apcs
771: WHERE apcs.admission_cat = cp_admission_cat AND
772: apcs.s_admission_process_type = cp_s_admission_process_type AND
773: apcs.s_admission_step_type = cp_s_admission_step_type AND
774: apcs.step_group_type = 'OUTCOME';

Line 775: l_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE;

771: WHERE apcs.admission_cat = cp_admission_cat AND
772: apcs.s_admission_process_type = cp_s_admission_process_type AND
773: apcs.s_admission_step_type = cp_s_admission_step_type AND
774: apcs.step_group_type = 'OUTCOME';
775: l_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE;
776: BEGIN
777: IF p_s_admission_process_type = 'NON-AWARD' THEN
778: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('NOT-APPLIC');
779: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('NOT-APPLIC');

Line 817: FROM igs_ad_prcs_cat_step_all apcs, igs_ad_appl_all appl

813: *****************************************************************************************/
814: -- will fetch first CORE_OPTIONAL then CORE if both present
815: CURSOR c_get_core_or_optional_unit IS
816: SELECT apcs.s_admission_step_type
817: FROM igs_ad_prcs_cat_step_all apcs, igs_ad_appl_all appl
818: WHERE appl.person_id = p_person_id
819: AND appl.admission_appl_number = p_admission_appl_number
820: AND apcs.admission_cat = appl.admission_cat
821: AND apcs.s_admission_process_type = appl.s_admission_process_type

Line 826: l_s_admission_step_type igs_ad_prcs_cat_step_all.s_admission_step_type%TYPE;

822: AND apcs.step_group_type = 'UNIT-VAL'
823: AND apcs.s_admission_step_type IN ('CORE','CORE_OPTIONAL')
824: ORDER BY apcs.s_admission_step_type desc;
825:
826: l_s_admission_step_type igs_ad_prcs_cat_step_all.s_admission_step_type%TYPE;
827: BEGIN
828: IF p_person_id IS NOT NULL AND p_admission_appl_number IS NOT NULL THEN
829: OPEN c_get_core_or_optional_unit;
830: FETCH c_get_core_or_optional_unit INTO l_s_admission_step_type;

Line 891: FROM IGS_AD_PRCS_CAT_STEP

887: l_out_dt DATE;
888:
889: CURSOR c_apc_step IS
890: SELECT 'X'
891: FROM IGS_AD_PRCS_CAT_STEP
892: WHERE admission_cat = p_admission_cat AND
893: s_admission_process_type = p_s_admission_process_type AND
894: s_admission_step_type = 'LATE-APP' AND
895: step_group_type <> 'TRACK';