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_CO_SUBMIT dependencies on IGS_CO_INTERAC_HIST

Line 185: l_adm_appl_number igs_co_interac_hist.adm_application_number%TYPE;

181: l_send_letter VARCHAR2 (10);
182: l_sql_stmt VARCHAR2 (32767);
183: -- these variables are required becuase when it is FAM related, Admission Application detials will be Null and when
184: -- the letter is NON FAM, then Adm Application details are needed and Award cal type and seq num will be Null.
185: l_adm_appl_number igs_co_interac_hist.adm_application_number%TYPE;
186: l_nominated_course_cd igs_co_interac_hist.nominated_course_cd%TYPE;
187: l_appl_sequence_number igs_co_interac_hist.ci_sequence_number%TYPE;
188: l_awd_ci_seq_number igf_sl_disb_ltr_v.ci_sequence_number%TYPE;
189: l_awd_cal_type igf_sl_disb_ltr_v.ci_cal_type%TYPE;

Line 186: l_nominated_course_cd igs_co_interac_hist.nominated_course_cd%TYPE;

182: l_sql_stmt VARCHAR2 (32767);
183: -- these variables are required becuase when it is FAM related, Admission Application detials will be Null and when
184: -- the letter is NON FAM, then Adm Application details are needed and Award cal type and seq num will be Null.
185: l_adm_appl_number igs_co_interac_hist.adm_application_number%TYPE;
186: l_nominated_course_cd igs_co_interac_hist.nominated_course_cd%TYPE;
187: l_appl_sequence_number igs_co_interac_hist.ci_sequence_number%TYPE;
188: l_awd_ci_seq_number igf_sl_disb_ltr_v.ci_sequence_number%TYPE;
189: l_awd_cal_type igf_sl_disb_ltr_v.ci_cal_type%TYPE;
190: l_gen_request_id igs_co_ou_co_ref.request_id%TYPE;

Line 187: l_appl_sequence_number igs_co_interac_hist.ci_sequence_number%TYPE;

183: -- these variables are required becuase when it is FAM related, Admission Application detials will be Null and when
184: -- the letter is NON FAM, then Adm Application details are needed and Award cal type and seq num will be Null.
185: l_adm_appl_number igs_co_interac_hist.adm_application_number%TYPE;
186: l_nominated_course_cd igs_co_interac_hist.nominated_course_cd%TYPE;
187: l_appl_sequence_number igs_co_interac_hist.ci_sequence_number%TYPE;
188: l_awd_ci_seq_number igf_sl_disb_ltr_v.ci_sequence_number%TYPE;
189: l_awd_cal_type igf_sl_disb_ltr_v.ci_cal_type%TYPE;
190: l_gen_request_id igs_co_ou_co_ref.request_id%TYPE;
191: l_fulfillment_req NUMBER;

Line 195: l_adm_appl_number_dy igs_co_interac_hist.adm_application_number%TYPE;

191: l_fulfillment_req NUMBER;
192: l_crm_user_id NUMBER;
193: l_email_address_dy hz_parties.email_address%TYPE;
194: l_person_id_dy igs_pe_person.person_id%TYPE;
195: l_adm_appl_number_dy igs_co_interac_hist.adm_application_number%TYPE;
196: l_nominated_course_cd_dy igs_co_interac_hist.nominated_course_cd%TYPE;
197: l_appl_sequence_number_dy igs_co_interac_hist.ci_sequence_number%TYPE;
198: l_panel_code_dy igs_ad_interview_letters_v.panel_code%TYPE;
199: l_award_year_dy igf_sl_disb_ltr_v.award_year%TYPE;

Line 196: l_nominated_course_cd_dy igs_co_interac_hist.nominated_course_cd%TYPE;

192: l_crm_user_id NUMBER;
193: l_email_address_dy hz_parties.email_address%TYPE;
194: l_person_id_dy igs_pe_person.person_id%TYPE;
195: l_adm_appl_number_dy igs_co_interac_hist.adm_application_number%TYPE;
196: l_nominated_course_cd_dy igs_co_interac_hist.nominated_course_cd%TYPE;
197: l_appl_sequence_number_dy igs_co_interac_hist.ci_sequence_number%TYPE;
198: l_panel_code_dy igs_ad_interview_letters_v.panel_code%TYPE;
199: l_award_year_dy igf_sl_disb_ltr_v.award_year%TYPE;
200: l_exception VARCHAR2 (1);

Line 197: l_appl_sequence_number_dy igs_co_interac_hist.ci_sequence_number%TYPE;

193: l_email_address_dy hz_parties.email_address%TYPE;
194: l_person_id_dy igs_pe_person.person_id%TYPE;
195: l_adm_appl_number_dy igs_co_interac_hist.adm_application_number%TYPE;
196: l_nominated_course_cd_dy igs_co_interac_hist.nominated_course_cd%TYPE;
197: l_appl_sequence_number_dy igs_co_interac_hist.ci_sequence_number%TYPE;
198: l_panel_code_dy igs_ad_interview_letters_v.panel_code%TYPE;
199: l_award_year_dy igf_sl_disb_ltr_v.award_year%TYPE;
200: l_exception VARCHAR2 (1);
201: l_retcode NUMBER (1);