APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_SPLINT_STG

Line 72: p_adm_appl_id IN igs_ss_ad_splint_stg.ss_adm_appl_id%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);
74: --added by nshee during build for Applicant-BOSS SS Bug 2622488
75: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
76: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,

Line 1020: p_adm_appl_id IN igs_ss_ad_splint_stg.ss_adm_appl_id%TYPE,

1016: App_Exception.Raise_Exception;
1017: END insert_spl_talent;
1018:
1019: PROCEDURE insert_special_interest(p_person_id IN igs_ad_spl_interests.person_id%TYPE,
1020: p_adm_appl_id IN igs_ss_ad_splint_stg.ss_adm_appl_id%TYPE,
1021: p_adm_appl_number IN igs_ad_spl_interests.admission_appl_number%TYPE) AS
1022: /*****************************************************************************************
1023: Created By: [email protected]
1024: Date Created : 11-DEC-2001

Line 1037: FROM igs_ss_ad_splint_stg

1033: lv_mode VARCHAR2(1) DEFAULT 'R';
1034:
1035: CURSOR c_special_interest IS
1036: SELECT special_interest_type_id
1037: FROM igs_ss_ad_splint_stg
1038: WHERE ss_adm_appl_id = p_adm_appl_id;
1039:
1040: BEGIN
1041: logHeader('insert_special_interest', 'S');

Line 1422: DELETE FROM igs_ss_ad_splint_stg

1418:
1419: DELETE FROM igs_ss_ad_appint_stg
1420: WHERE ss_adm_appl_id = p_adm_appl_number;
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;