APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_SPL_TALENTS

Line 68: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_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,
72: p_adm_appl_id IN igs_ss_ad_splint_stg.ss_adm_appl_id%TYPE,

Line 70: p_adm_appl_number IN igs_ad_spl_talents.admission_appl_number%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,
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

Line 960: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,

956: END IF;
957: App_Exception.Raise_Exception;
958: END insert_applicant_intent;
959:
960: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,
961: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%TYPE,
962: p_adm_appl_number IN igs_ad_spl_talents.admission_appl_number%TYPE) AS
963: /*****************************************************************************************
964: Created By: [email protected]

Line 962: p_adm_appl_number IN igs_ad_spl_talents.admission_appl_number%TYPE) AS

958: END insert_applicant_intent;
959:
960: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,
961: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%TYPE,
962: p_adm_appl_number IN igs_ad_spl_talents.admission_appl_number%TYPE) AS
963: /*****************************************************************************************
964: Created By: [email protected]
965: Date Created : 11-DEC-2001
966: Purpose: 1. Inserts Academic Honors Details (For an Application)

Line 974: l_spl_talent_id igs_ad_spl_talents.spl_talent_id%TYPE;

970: Who When What
971: *****************************************************************************************/
972:
973: l_rowid VARCHAR2(25);
974: l_spl_talent_id igs_ad_spl_talents.spl_talent_id%TYPE;
975: lv_mode VARCHAR2(1) DEFAULT 'R';
976:
977: CURSOR c_spl_talent IS
978: SELECT special_talent_type_id

Line 986: logDetail('Before call to IGS_AD_SPL_TALENTS_PKG.insert_row', 'S');

982: BEGIN
983: logHeader('insert_spl_talent', 'S');
984: FOR c_spl_talent_rec IN c_spl_talent LOOP
985: IF c_spl_talent_rec.special_talent_type_id IS NOT NULL THEN
986: logDetail('Before call to IGS_AD_SPL_TALENTS_PKG.insert_row', 'S');
987: l_rowid := '';
988: l_spl_talent_id := 0;
989:
990:

Line 995: IGS_AD_SPL_TALENTS_PKG.insert_row(x_rowid => l_rowid,

991: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
992: THEN
993: lv_mode := 'S';
994: END IF;
995: IGS_AD_SPL_TALENTS_PKG.insert_row(x_rowid => l_rowid,
996: x_spl_talent_id => l_spl_talent_id,
997: x_person_id => p_person_id,
998: x_admission_appl_number => p_adm_appl_number,
999: x_special_talent_type_id => c_spl_talent_rec.special_talent_type_id,

Line 1007: 'Exception from IGS_AD_SPL_TALENTS_PKG.insert_row ' ||

1003: END LOOP;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: logDetail('Inside insert_spl_talent' ||
1007: 'Exception from IGS_AD_SPL_TALENTS_PKG.insert_row ' ||
1008: SQLERRM || 'person_id : ' ||
1009: IGS_GE_NUMBER.TO_CANN(p_person_id),
1010: 'S');
1011: IF FND_MSG_PUB.Count_Msg < 1 THEN