APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_ACAD_INTEREST

Line 62: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,

58: p_ss_adm_appl_id IN igs_ss_app_pgm_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,

Line 64: p_adm_appl_number IN igs_ad_acad_interest.admission_appl_number%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);
68: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,

Line 819: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,

815: App_Exception.Raise_Exception;
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]

Line 821: p_adm_appl_number IN igs_ad_acad_interest.admission_appl_number%TYPE) AS

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
825: Purpose: 1. Inserts Academic Honors Details (For an Application)

Line 833: l_acad_interest_id igs_ad_acad_interest.acad_interest_id%TYPE;

829: Who When What
830: *****************************************************************************************/
831:
832: l_rowid VARCHAR2(25);
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

Line 844: logDetail('Before call to IGS_AD_ACAD_INTEREST_PKG.insert_row',

840: BEGIN
841: logHeader('insert_acad_interest', 'S');
842: FOR c_acad_interest_rec IN c_acad_interest LOOP
843: IF c_acad_interest_rec.field_of_study IS NOT NULL THEN
844: logDetail('Before call to IGS_AD_ACAD_INTEREST_PKG.insert_row',
845: 'S');
846: l_rowid := '';
847: l_acad_interest_id := 0;
848:

Line 856: IGS_AD_ACAD_INTEREST_PKG.insert_row(x_rowid => l_rowid,

852: lv_mode := 'S';
853: END IF;
854:
855:
856: IGS_AD_ACAD_INTEREST_PKG.insert_row(x_rowid => l_rowid,
857: x_acad_interest_id => l_acad_interest_id,
858: x_person_id => p_person_id,
859: x_admission_appl_number => p_adm_appl_number,
860: x_field_of_study => c_acad_interest_rec.field_of_study,

Line 869: 'Exception from IGS_AD_ACAD_INTEREST_PKG.insert_row ' ||

865: EXCEPTION
866: WHEN OTHERS THEN
867:
868: logDetail('Inside insert_acad_interest' ||
869: 'Exception from IGS_AD_ACAD_INTEREST_PKG.insert_row ' ||
870: SQLERRM || 'person_id : ' ||
871: IGS_GE_NUMBER.TO_CANN(p_person_id),
872: 'S');
873: IF FND_MSG_PUB.Count_Msg < 1 THEN