APPS.IGS_AD_SS_APPL_PGS_PKG dependencies on IGS_SS_AD_SEC_STAT

Line 637: FROM IGS_SS_AD_SEC_STAT

633: WHERE admission_application_type = p_admission_application_type;
634:
635: CURSOR c_get_section_status(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE,cp_appl_id igs_ss_adm_appl_stg.ss_adm_appl_id%TYPE,cp_section_name igs_ad_ss_appl_pgs.page_name%TYPE) IS
636: SELECT section, completion_status
637: FROM IGS_SS_AD_SEC_STAT
638: WHERE ss_adm_appl_id=cp_appl_id
639: AND person_id=cp_person_id
640: AND section=cp_section_name;
641:

Line 656: FROM IGS_SS_AD_SEC_STAT

652: FOR c_get_incomplete_appl_data_rec IN c_get_incomplete_appl_data LOOP --1.5
653: FOR c_get_section_status_rec IN c_get_section_status(c_get_incomplete_appl_data_rec.person_id,c_get_incomplete_appl_data_rec.ss_adm_appl_id,c_get_page_setup_rec.page_name) LOOP --1.75
654: IF c_get_page_setup_rec.page_name = c_get_section_status_rec.section THEN
655: DELETE
656: FROM IGS_SS_AD_SEC_STAT
657: WHERE section = c_get_page_setup_rec.page_name
658: AND person_id = c_get_incomplete_appl_data_rec.person_id
659: AND ss_adm_appl_id = c_get_incomplete_appl_data_rec.ss_adm_appl_id;
660: ELSE

Line 670: INSERT INTO igs_ss_ad_sec_stat

666: FOR c_get_incomplete_appl_data_rec IN c_get_incomplete_appl_data LOOP --1.5
667: OPEN c_get_section_status(c_get_incomplete_appl_data_rec.person_id,c_get_incomplete_appl_data_rec.ss_adm_appl_id,c_get_page_setup_rec.page_name);
668: FETCH c_get_section_status INTO c_get_section_status_record;
669: IF c_get_section_status%NOTFOUND THEN
670: INSERT INTO igs_ss_ad_sec_stat
671: (
672: ss_adm_appl_id ,
673: person_id ,
674: section,