APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_SPLTAL_STG

Line 69: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%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);
68: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,
69: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%TYPE,
70: p_adm_appl_number IN igs_ad_spl_talents.admission_appl_number%TYPE);
71: PROCEDURE insert_special_interest(p_person_id IN igs_ad_spl_interests.person_id%TYPE,
72: p_adm_appl_id IN igs_ss_ad_splint_stg.ss_adm_appl_id%TYPE,
73: p_adm_appl_number IN igs_ad_spl_interests.admission_appl_number%TYPE);

Line 961: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%TYPE,

957: App_Exception.Raise_Exception;
958: END insert_applicant_intent;
959:
960: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,
961: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%TYPE,
962: p_adm_appl_number IN igs_ad_spl_talents.admission_appl_number%TYPE) AS
963: /*****************************************************************************************
964: Created By: [email protected]
965: Date Created : 11-DEC-2001

Line 979: FROM igs_ss_ad_spltal_stg

975: lv_mode VARCHAR2(1) DEFAULT 'R';
976:
977: CURSOR c_spl_talent IS
978: SELECT special_talent_type_id
979: FROM igs_ss_ad_spltal_stg
980: WHERE ss_adm_appl_id = p_adm_appl_id;
981:
982: BEGIN
983: logHeader('insert_spl_talent', 'S');

Line 1425: DELETE FROM igs_ss_ad_spltal_stg

1421:
1422: DELETE FROM igs_ss_ad_splint_stg
1423: WHERE ss_adm_appl_id = p_adm_appl_number;
1424:
1425: DELETE FROM igs_ss_ad_spltal_stg
1426: WHERE ss_adm_appl_id = p_adm_appl_number;
1427: --added by nshee during build for Applicant-BOSS SS Bug 2622488
1428: -- needs to include in the
1429: -- delete stg table records section

Line 3952: CURSOR c_spl_tal(cp_Appl_Num IGS_SS_AD_SPLTAL_STG.SS_ADM_APPL_ID%TYPE) IS

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
3953: SELECT 'x'
3954: FROM IGS_SS_AD_SPLTAL_STG
3955: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3956:

Line 3954: FROM IGS_SS_AD_SPLTAL_STG

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
3953: SELECT 'x'
3954: FROM IGS_SS_AD_SPLTAL_STG
3955: WHERE SS_ADM_APPL_ID = cp_Appl_Num;
3956:
3957: -- Extracurricular Activities- EXTRACUR_ACTIVITIES
3958: CURSOR c_ext_curr(cp_person_id igs_ad_appl.person_id%TYPE) IS