APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_SPL_INTERESTS

Line 71: PROCEDURE insert_special_interest(p_person_id IN igs_ad_spl_interests.person_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);
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,

Line 73: p_adm_appl_number IN igs_ad_spl_interests.admission_appl_number%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,
77: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,

Line 1019: PROCEDURE insert_special_interest(p_person_id IN igs_ad_spl_interests.person_id%TYPE,

1015: END IF;
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]

Line 1021: p_adm_appl_number IN igs_ad_spl_interests.admission_appl_number%TYPE) AS

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

Line 1032: l_spl_interest_id igs_ad_spl_interests.spl_interest_id%TYPE;

1028: Change History
1029: Who When What
1030: *****************************************************************************************/
1031: l_rowid VARCHAR2(25);
1032: l_spl_interest_id igs_ad_spl_interests.spl_interest_id%TYPE;
1033: lv_mode VARCHAR2(1) DEFAULT 'R';
1034:
1035: CURSOR c_special_interest IS
1036: SELECT special_interest_type_id

Line 1044: logDetail('Before call to IGS_AD_SPL_INTERESTS_PKG.insert_row',

1040: BEGIN
1041: logHeader('insert_special_interest', 'S');
1042: FOR c_special_interest_rec IN c_special_interest LOOP
1043: IF c_special_interest_rec.special_interest_type_id IS NOT NULL THEN
1044: logDetail('Before call to IGS_AD_SPL_INTERESTS_PKG.insert_row',
1045: 'S');
1046: l_rowid := '';
1047: l_spl_interest_id := 0;
1048:

Line 1054: IGS_AD_SPL_INTERESTS_PKG.insert_row(x_rowid => l_rowid,

1050: THEN
1051: lv_mode := 'S';
1052: END IF;
1053:
1054: IGS_AD_SPL_INTERESTS_PKG.insert_row(x_rowid => l_rowid,
1055: x_spl_interest_id => l_spl_interest_id,
1056: x_person_id => p_person_id,
1057: x_admission_appl_number => p_adm_appl_number,
1058: x_special_interest_type_id => c_special_interest_rec.special_interest_type_id,

Line 1066: 'Exception from IGS_AD_SPL_INTERESTS_PKG.insert_row ' ||

1062: END LOOP;
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: logDetail('Inside insert_special_interest' ||
1066: 'Exception from IGS_AD_SPL_INTERESTS_PKG.insert_row ' ||
1067: SQLERRM || 'person_id : ' ||
1068: IGS_GE_NUMBER.TO_CANN(p_person_id),
1069: 'S');
1070: IF FND_MSG_PUB.Count_Msg < 1 THEN