DBA Data[Home] [Help]

APPS.IGS_AD_GEN_003 dependencies on IGS_AD_GEN_009

Line 778: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('NOT-APPLIC');

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');
780: ELSE
781: OPEN c_apcs_step(p_admission_cat,p_s_admission_process_type,'DFLT_ENTRY_QUAL');
782: FETCH c_apcs_step INTO l_s_admission_step_type;

Line 779: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('NOT-APPLIC');

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');
780: ELSE
781: OPEN c_apcs_step(p_admission_cat,p_s_admission_process_type,'DFLT_ENTRY_QUAL');
782: FETCH c_apcs_step INTO l_s_admission_step_type;
783: IF c_apcs_step%FOUND AND l_s_admission_step_type = 'DFLT_ENTRY_QUAL' THEN

Line 784: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('QUALIFIED');

780: ELSE
781: OPEN c_apcs_step(p_admission_cat,p_s_admission_process_type,'DFLT_ENTRY_QUAL');
782: FETCH c_apcs_step INTO l_s_admission_step_type;
783: IF c_apcs_step%FOUND AND l_s_admission_step_type = 'DFLT_ENTRY_QUAL' THEN
784: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('QUALIFIED');
785: ELSE
786: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('PENDING');
787: END IF;
788: CLOSE c_apcs_step;

Line 786: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('PENDING');

782: FETCH c_apcs_step INTO l_s_admission_step_type;
783: IF c_apcs_step%FOUND AND l_s_admission_step_type = 'DFLT_ENTRY_QUAL' THEN
784: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('QUALIFIED');
785: ELSE
786: l_adm_entr_qual_status := IGS_AD_GEN_009.admp_get_sys_aeqs('PENDING');
787: END IF;
788: CLOSE c_apcs_step;
789:
790: OPEN c_apcs_step(p_admission_cat,p_s_admission_process_type,'DFLT_DOC_STATUS');

Line 793: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('SATISFIED');

789:
790: OPEN c_apcs_step(p_admission_cat,p_s_admission_process_type,'DFLT_DOC_STATUS');
791: FETCH c_apcs_step INTO l_s_admission_step_type;
792: IF c_apcs_step%FOUND AND l_s_admission_step_type = 'DFLT_DOC_STATUS' THEN
793: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('SATISFIED');
794: ELSE
795: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('PENDING');
796: END IF;
797: CLOSE c_apcs_step;

Line 795: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('PENDING');

791: FETCH c_apcs_step INTO l_s_admission_step_type;
792: IF c_apcs_step%FOUND AND l_s_admission_step_type = 'DFLT_DOC_STATUS' THEN
793: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('SATISFIED');
794: ELSE
795: l_adm_doc_status:= IGS_AD_GEN_009.admp_get_sys_ads('PENDING');
796: END IF;
797: CLOSE c_apcs_step;
798: END IF;
799: END get_entr_doc_apc;