APPS.IGS_CO_SUBMIT dependencies on IGF_SL_DISB_LTR_V

Line 188: l_awd_ci_seq_number igf_sl_disb_ltr_v.ci_sequence_number%TYPE;

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;
192: l_crm_user_id NUMBER;

Line 189: l_awd_cal_type igf_sl_disb_ltr_v.ci_cal_type%TYPE;

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;
192: l_crm_user_id NUMBER;
193: l_email_address_dy hz_parties.email_address%TYPE;

Line 199: l_award_year_dy igf_sl_disb_ltr_v.award_year%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);
202: l_errbuf VARCHAR2 (1000);
203: -- Created new parameters as part of bug# 2472250