APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_APPINT_STG

Line 66: p_adm_appl_id IN igs_ss_ad_appint_stg.ss_adm_appl_id%TYPE,

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);
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);

Line 882: p_adm_appl_id IN igs_ss_ad_appint_stg.ss_adm_appl_id%TYPE,

878: App_Exception.Raise_Exception;
879: END insert_acad_interest;
880:
881: PROCEDURE insert_applicant_intent(p_person_id IN igs_ad_app_intent.person_id%TYPE,
882: p_adm_appl_id IN igs_ss_ad_appint_stg.ss_adm_appl_id%TYPE,
883: p_adm_appl_number IN igs_ad_app_intent.admission_appl_number%TYPE) AS
884: /*****************************************************************************************
885: Created By: [email protected]
886: Date Created : 11-DEC-2001

Line 900: FROM igs_ss_ad_appint_stg

896: lv_mode VARCHAR2(1) DEFAULT 'R';
897:
898: CURSOR c_applicant_intent IS
899: SELECT intent_type_id
900: FROM igs_ss_ad_appint_stg
901: WHERE ss_adm_appl_id = p_adm_appl_id;
902:
903: BEGIN
904: logHeader('insert_applicant_intent', 'S');

Line 1419: DELETE FROM igs_ss_ad_appint_stg

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;
1421:
1422: DELETE FROM igs_ss_ad_splint_stg
1423: WHERE ss_adm_appl_id = p_adm_appl_number;