[Home] [Help]
136: WHERE awdint.batch_num = p_batch_num
137: AND awdint.ci_alternate_code = p_alternate_code
138: AND awdint.import_status_type IN ('U','R')
139: ORDER BY awdint.person_number, awdint.fund_code, awdint.award_number_txt;
140: l_out_person_id hz_parties.party_id%TYPE;
141: l_out_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
142:
143: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;
150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
151: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
152: g_award_id igf_aw_award_all.award_id%TYPE;
153: g_disb_net_amount igf_aw_li_dact_ints.disb_net_amt%TYPE;
154: g_person_id hz_parties.party_id%TYPE;
155: g_processing_string VARCHAR2(1000);
156: g_debug_string fnd_log_messages.message_text%TYPE;
157: g_debug_runtime_level NUMBER;
158: g_entry_point VARCHAR2(30);
877: ***************************************************************/
878: l_awd_rowid VARCHAR2(25);
879: l_alt_pell_schedule igf_aw_award_all.alt_pell_schedule%TYPE;
880:
881: CURSOR c_visa (cv_person_id hz_parties.party_id%TYPE ) IS
882: SELECT a.visa_type,
883: a.visa_category,
884: a.visa_number,
885: a.visa_expiry_date,
892: ORDER BY a.visa_expiry_date DESC;
893:
894: visa_rec c_visa%ROWTYPE;
895:
896: CURSOR c_hzp (cv_person_id hz_parties.party_id%TYPE ) IS
897: SELECT person_first_name,
898: person_last_name,
899: address1,
900: address2,
904: state,
905: province,
906: county,
907: country
908: FROM hz_parties
909: WHERE party_id = cv_person_id;
910:
911: hzp_rec c_hzp%ROWTYPE;
912: l_warning VARCHAR2(200);
3571:
3572: -------------------------------------------------------------------------------------------------------
3573: -- Generic Functions
3574: -------------------------------------------------------------------------------------------------------
3575: FUNCTION get_base_id_from_per_num (p_person_number hz_parties.party_number%TYPE,
3576: p_cal_type igs_ca_inst.cal_type%TYPE,
3577: p_sequence_number igs_ca_inst.sequence_number%TYPE
3578: ) RETURN NUMBER IS
3579: CURSOR cur_base_id IS
3578: ) RETURN NUMBER IS
3579: CURSOR cur_base_id IS
3580: SELECT base.base_id
3581: FROM igf_ap_fa_base_rec_all base,
3582: hz_parties hp
3583: WHERE
3584: base.ci_sequence_number = p_sequence_number
3585: AND base.ci_cal_type = p_cal_type
3586: AND base.person_id = hp.party_id