[Home] [Help]
15: g_rec_not_ins BOOLEAN := TRUE;
16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;
17: g_setup_score igf_ap_record_match%ROWTYPE;
18: g_isir_intrface_rec igf_ap_isir_ints%ROWTYPE;
19: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
20: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
21: g_pell_match_type VARCHAR2(1) ; -- Stores the Type of Pell match done Duplicate/New rec
22: g_base_id NUMBER;
23: g_called_from_process BOOLEAN := FALSE;
16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;
17: g_setup_score igf_ap_record_match%ROWTYPE;
18: g_isir_intrface_rec igf_ap_isir_ints%ROWTYPE;
19: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
20: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
21: g_pell_match_type VARCHAR2(1) ; -- Stores the Type of Pell match done Duplicate/New rec
22: g_base_id NUMBER;
23: g_called_from_process BOOLEAN := FALSE;
24: g_fa_base_rec igf_ap_fa_base_rec%ROWTYPE; -- Will be populated once and used in all places
25: g_max_tran_num VARCHAR2(2); -- Stores the max transaction number
26: g_person_id NUMBER;
27: g_count_corr NUMBER ;
28:
29: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
30: g_match_code igf_ap_record_match_all.match_code%TYPE;
31: g_separator_line VARCHAR2(100);
32: g_total_recs_processed NUMBER := 0;
33: g_rec_processed_status igf_ap_isir_ints_all.record_status%TYPE;
3055:
3056:
3057: PROCEDURE create_admission_rec(
3058: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
3059: p_batch_year igf_ap_batch_aw_map_all.batch_year%TYPE
3060: )
3061: IS
3062: /*
3063: || Created By : rasingh
4981: CURSOR cur_isir_corr (cp_base_id igf_ap_isir_matched.base_id%TYPE,
4982: cp_corr_stat VARCHAR2 ) IS
4983: SELECT corr.*,
4984: sar.sar_field_name column_name
4985: FROM igf_ap_batch_aw_map map,
4986: igf_ap_ISIR_corr corr,
4987: igf_fc_sar_cd_mst sar,
4988: igf_ap_isir_matched isir
4989: WHERE map.ci_cal_type = g_ci_cal_type
7455: lv_apm_id igf_ap_person_match.apm_id%TYPE := NULL;
7456:
7457: CURSOR cur_batch_aw_map(cp_batch_yr NUMBER) IS
7458: SELECT ci_cal_type,ci_sequence_number
7459: FROM igf_ap_batch_aw_map
7460: WHERE batch_year = cp_batch_yr;
7461:
7462: CURSOR cur_isir_intrface(cp_si_id NUMBER) IS
7463: SELECT iia.*
7800: -- Get all the records from base table which are having same person id and the given batch year
7801: CURSOR cur_fa_base_record (pn_person_id NUMBER, ln_batch_year NUMBER) IS
7802: SELECT ifb.*
7803: FROM igf_ap_fa_base_rec ifb,
7804: igf_ap_batch_aw_map ibm
7805: WHERE ifb.person_id = pn_person_id
7806: AND ibm.ci_sequence_number = ifb.ci_sequence_number
7807: AND ibm.ci_cal_type = ifb.ci_cal_type
7808: AND ibm.batch_year = ln_batch_year;
7957: iii.birth_date,
7958: iii.batch_year_num,
7959: iii.record_status
7960: FROM igf_ap_isir_ints iii,
7961: igf_ap_batch_aw_map ibm
7962: WHERE original_ssn_txt = pn_ssn
7963: AND iii.last_name = pv_last_name
7964: AND iii.birth_date = pd_date_of_birth
7965: AND ibm.ci_sequence_number = pn_ci_sequence_number
8253: WHERE si_id = cp_si_id;
8254:
8255: CURSOR cur_award_year_dtl(cp_batch_year igf_ap_isir_ints.batch_year_num%TYPE) IS
8256: SELECT ci_sequence_number,ci_cal_type
8257: FROM igf_ap_batch_aw_map
8258: WHERE batch_year = cp_batch_year;
8259:
8260: award_year_dtl_rec cur_award_year_dtl%ROWTYPE;
8261:
8410:
8411: -- Added cp_batch_year as a part of Bug Fix 4241350
8412: CURSOR cur_base_id_rec(cp_person_id NUMBER, cp_batch_year NUMBER) IS
8413: SELECT base_id
8414: FROM igf_ap_fa_base_rec br, igf_ap_batch_aw_map am
8415: WHERE person_id = cp_person_id
8416: AND br.ci_cal_type = am.ci_cal_type
8417: AND br.ci_sequence_number = am.ci_sequence_number
8418: AND am.batch_year = cp_batch_year;