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_IMP_010 dependencies on IGS_AD_APPL

Line 98: l_admission_cat igs_ad_appl.admission_cat%TYPE;

94: l_msg_count NUMBER ;
95: l_msg_data VARCHAR2(2000);
96: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
97:
98: l_admission_cat igs_ad_appl.admission_cat%TYPE;
99: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
100:
101: BEGIN
102: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 99: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;

95: l_msg_data VARCHAR2(2000);
96: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
97:
98: l_admission_cat igs_ad_appl.admission_cat%TYPE;
99: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
100:
101: BEGIN
102: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
103:

Line 157: igs_ad_appl_notes_pkg.INSERT_ROW(

153: BEGIN
154: SAVEPOINT before_create;
155: l_msg_at_index := igs_ge_msg_stack.count_msg;
156:
157: igs_ad_appl_notes_pkg.INSERT_ROW(
158: X_ROWID => l_Rowid,
159: X_APPL_NOTES_ID => l_Appl_Notes_Id,
160: x_Person_Id => notes_rec.person_id,
161: X_Admission_Appl_Number => notes_rec.Admission_Appl_Number,

Line 277: FROM igs_ad_appl_notes mn_rec

273: , error_text = cst_et_val_E678
274: WHERE interface_run_id = p_interface_run_id
275: AND status = cst_s_val_2
276: AND EXISTS ( SELECT 1
277: FROM igs_ad_appl_notes mn_rec
278: WHERE mn_rec.person_id = in_rec.person_id
279: AND mn_rec.admission_appl_number = in_rec.admission_appl_number
280: AND mn_rec.nominated_course_cd = in_rec.nominated_course_cd
281: AND mn_rec.note_type_id = in_rec.note_type_id

Line 323: l_admission_cat igs_ad_appl.admission_cat%TYPE;

319: l_msg_count NUMBER ;
320: l_msg_data VARCHAR2(2000);
321: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
322:
323: l_admission_cat igs_ad_appl.admission_cat%TYPE;
324: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
325:
326: BEGIN
327:

Line 324: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;

320: l_msg_data VARCHAR2(2000);
321: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
322:
323: l_admission_cat igs_ad_appl.admission_cat%TYPE;
324: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
325:
326: BEGIN
327:
328: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 557: l_admission_cat igs_ad_appl.admission_cat%TYPE;

553: l_records_processed NUMBER;
554: l_rowid VARCHAR2(30);
555: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;
556:
557: l_admission_cat igs_ad_appl.admission_cat%TYPE;
558: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
559:
560: BEGIN
561:

Line 558: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;

554: l_rowid VARCHAR2(30);
555: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;
556:
557: l_admission_cat igs_ad_appl.admission_cat%TYPE;
558: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
559:
560: BEGIN
561:
562: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN