APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_ACADIN_STG

Line 63: p_adm_appl_id IN igs_ss_ad_acadin_stg.ss_adm_appl_id%TYPE,

59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);
61: --added by nshee during build for Applicant-BOSS SS Bug 2622488
62: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,
63: p_adm_appl_id IN igs_ss_ad_acadin_stg.ss_adm_appl_id%TYPE,
64: p_adm_appl_number IN igs_ad_acad_interest.admission_appl_number%TYPE);
65: PROCEDURE insert_applicant_intent(p_person_id IN igs_ad_app_intent.person_id%TYPE,
66: p_adm_appl_id IN igs_ss_ad_appint_stg.ss_adm_appl_id%TYPE,
67: p_adm_appl_number IN igs_ad_app_intent.admission_appl_number%TYPE);

Line 820: p_adm_appl_id IN igs_ss_ad_acadin_stg.ss_adm_appl_id%TYPE,

816: END insert_unit_set_dtls;
817:
818: --added by nshee during build for Applicant-BOSS SS Bug 2622488
819: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,
820: p_adm_appl_id IN igs_ss_ad_acadin_stg.ss_adm_appl_id%TYPE,
821: p_adm_appl_number IN igs_ad_acad_interest.admission_appl_number%TYPE) AS
822: /*****************************************************************************************
823: Created By: [email protected]
824: Date Created : 11-DEC-2001

Line 837: FROM igs_ss_ad_acadin_stg

833: l_acad_interest_id igs_ad_acad_interest.acad_interest_id%TYPE;
834: lv_mode VARCHAR2(1) DEFAULT 'R';
835: CURSOR c_acad_interest IS
836: SELECT field_of_study
837: FROM igs_ss_ad_acadin_stg
838: WHERE ss_adm_appl_id = p_adm_appl_id;
839:
840: BEGIN
841: logHeader('insert_acad_interest', 'S');

Line 1416: DELETE FROM igs_ss_ad_acadin_stg

1412: FROM igs_ss_app_pgm_stg
1413: WHERE ss_adm_appl_id = p_adm_appl_number
1414: AND person_id = p_person_id);
1415:
1416: DELETE FROM igs_ss_ad_acadin_stg
1417: WHERE ss_adm_appl_id = p_adm_appl_number;
1418:
1419: DELETE FROM igs_ss_ad_appint_stg
1420: WHERE ss_adm_appl_id = p_adm_appl_number;

Line 3946: CURSOR c_acad_int(cp_Appl_Num IGS_SS_AD_ACADIN_STG.SS_ADM_APPL_ID%TYPE) IS

3942: FROM IGS_SS_AD_OTHINS_STG
3943: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3944:
3945: -- Academic Interest- ACAD_INTEREST
3946: CURSOR c_acad_int(cp_Appl_Num IGS_SS_AD_ACADIN_STG.SS_ADM_APPL_ID%TYPE) IS
3947: SELECT 'x'
3948: FROM IGS_SS_AD_ACADIN_STG
3949: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3950:

Line 3948: FROM IGS_SS_AD_ACADIN_STG

3944:
3945: -- Academic Interest- ACAD_INTEREST
3946: CURSOR c_acad_int(cp_Appl_Num IGS_SS_AD_ACADIN_STG.SS_ADM_APPL_ID%TYPE) IS
3947: SELECT 'x'
3948: FROM IGS_SS_AD_ACADIN_STG
3949: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3950:
3951: -- Special Talents- SPECIAL_TALENTS
3952: CURSOR c_spl_tal(cp_Appl_Num IGS_SS_AD_SPLTAL_STG.SS_ADM_APPL_ID%TYPE) IS