eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_EDUGOAL

Line 75: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%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,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488

Line 76: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%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,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,

Line 78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%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,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
82: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,

Line 79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee 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,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
82: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
83: x_return_status OUT NOCOPY VARCHAR2);

Line 1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,

1132: END IF;
1133: App_Exception.Raise_Exception;
1134: END insert_othinst;
1135: --dhan
1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
1138: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
1139: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
1140: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE) AS

Line 1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,

1133: App_Exception.Raise_Exception;
1134: END insert_othinst;
1135: --dhan
1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
1138: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
1139: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
1140: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE) AS
1141: /*****************************************************************************************

Line 1139: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,

1135: --dhan
1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
1138: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
1139: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
1140: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE) AS
1141: /*****************************************************************************************
1142: Created By: [email protected]
1143: Date Created : 11-DEC-2001

Line 1140: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE) AS

1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
1138: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
1139: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
1140: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE) AS
1141: /*****************************************************************************************
1142: Created By: [email protected]
1143: Date Created : 11-DEC-2001
1144: Purpose: 1. Inserts Post Educational Goal Details (For an Application Program Instance)

Line 1145: FLOW: IGS_AD_EDUGOAL_PKG.insert_row

1141: /*****************************************************************************************
1142: Created By: [email protected]
1143: Date Created : 11-DEC-2001
1144: Purpose: 1. Inserts Post Educational Goal Details (For an Application Program Instance)
1145: FLOW: IGS_AD_EDUGOAL_PKG.insert_row
1146: Known limitations,enhancements,remarks:
1147: Change History
1148: Who When What
1149: nshee 29-oct-2002 modified due to design change in build 2622488

Line 1152: l_post_edugoal_id IGS_AD_EDUGOAL.post_edugoal_id%TYPE;

1148: Who When What
1149: nshee 29-oct-2002 modified due to design change in build 2622488
1150: *****************************************************************************************/
1151: l_rowid VARCHAR2(25);
1152: l_post_edugoal_id IGS_AD_EDUGOAL.post_edugoal_id%TYPE;
1153: lv_mode VARCHAR2(1) DEFAULT 'R';
1154: CURSOR c_postenroll_edu_goal IS
1155: SELECT edu_goal_id
1156: FROM igs_ss_ad_edugoa_stg

Line 1172: logDetail('Before call to IGS_AD_EDUGOAL_PKG.insert_row', 'S');

1168: lv_mode := 'S';
1169: END IF;
1170: FOR c_postenroll_edu_goal_rec IN c_postenroll_edu_goal LOOP
1171: IF c_postenroll_edu_goal_rec.edu_goal_id IS NOT NULL THEN
1172: logDetail('Before call to IGS_AD_EDUGOAL_PKG.insert_row', 'S');
1173:
1174: l_rowid := '';
1175: l_post_edugoal_id := 0;
1176:

Line 1177: IGS_AD_EDUGOAL_PKG.insert_row(X_ROWID => l_rowid,

1173:
1174: l_rowid := '';
1175: l_post_edugoal_id := 0;
1176:
1177: IGS_AD_EDUGOAL_PKG.insert_row(X_ROWID => l_rowid,
1178: X_POST_EDUGOAL_ID => l_post_edugoal_id,
1179: X_PERSON_ID => p_person_id,
1180: X_ADMISSION_APPL_NUMBER => p_adm_appl_number,
1181: X_NOMINATED_COURSE_CD => p_nominated_course_cd,

Line 1192: 'Exception from IGS_AD_EDUGOAL_PKG.insert_row' || SQLERRM ||

1188: END LOOP;
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: logDetail('insert_edugoal_details' ||
1192: 'Exception from IGS_AD_EDUGOAL_PKG.insert_row' || SQLERRM ||
1193: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1194: 'S');
1195: IF FND_MSG_PUB.Count_Msg < 1 THEN
1196: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');