[Home] [Help]
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);
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,
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);
71: PROCEDURE insert_special_interest(p_person_id IN igs_ad_spl_interests.person_id%TYPE,
877: END IF;
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]
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
887: Purpose: 1. Inserts Academic Honors Details (For an Application)
891: Who When What
892: *****************************************************************************************/
893:
894: l_rowid VARCHAR2(25);
895: l_app_intent_id igs_ad_app_intent.app_intent_id%TYPE;
896: lv_mode VARCHAR2(1) DEFAULT 'R';
897:
898: CURSOR c_applicant_intent IS
899: SELECT intent_type_id
903: BEGIN
904: logHeader('insert_applicant_intent', 'S');
905: FOR c_applicant_intent_rec IN c_applicant_intent LOOP
906: IF c_applicant_intent_rec.intent_type_id IS NOT NULL THEN
907: logDetail('Before call to IGS_AD_APP_INTENT_PKG.insert_row', 'S');
908: l_rowid := '';
909: l_app_intent_id := 0;
910:
911: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
911: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
912: THEN
913: lv_mode := 'S';
914: END IF;
915: IGS_AD_APP_INTENT_PKG.insert_row(x_rowid => l_rowid,
916: x_app_intent_id => l_app_intent_id,
917: x_person_id => p_person_id,
918: x_admission_appl_number => p_adm_appl_number,
919: x_intent_type_id => c_applicant_intent_rec.intent_type_id,
944: END LOOP;
945: EXCEPTION
946: WHEN OTHERS THEN
947: logDetail('Inside insert_applicant_intent' ||
948: 'Exception from IGS_AD_APP_INTENT_PKG.insert_row ' ||
949: SQLERRM || 'person_id : ' ||
950: IGS_GE_NUMBER.TO_CANN(p_person_id),
951: 'S');
952: IF FND_MSG_PUB.Count_Msg < 1 THEN