APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_RECORD_MATCH

Line 17: g_setup_score igf_ap_record_match%ROWTYPE;

13: g_dup_rec NUMBER := 0;
14: g_review_count NUMBER := 0;
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

Line 30: g_match_code igf_ap_record_match_all.match_code%TYPE;

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;
34: g_del_success_int_rec VARCHAR2(1); -- Global var for holding p_del_int parameter value

Line 48: CURSOR cur_setup_score (cp_match_code igf_ap_record_match_all.match_code%TYPE) IS

44: -- pl/sql table def for deleting from match details using BULK operation.
45: TYPE match_details_amd_id IS TABLE OF igf_ap_match_details.amd_id%TYPE;
46: g_amd_id_tab match_details_amd_id;
47:
48: CURSOR cur_setup_score (cp_match_code igf_ap_record_match_all.match_code%TYPE) IS
49: SELECT *
50: FROM igf_ap_record_match
51: WHERE match_code = cp_match_code
52: AND enabled_flag = 'Y';

Line 50: FROM igf_ap_record_match

46: g_amd_id_tab match_details_amd_id;
47:
48: CURSOR cur_setup_score (cp_match_code igf_ap_record_match_all.match_code%TYPE) IS
49: SELECT *
50: FROM igf_ap_record_match
51: WHERE match_code = cp_match_code
52: AND enabled_flag = 'Y';
53:
54:

Line 4032: p_match_setup igf_ap_record_match%ROWTYPE,

4028:
4029:
4030:
4031: PROCEDURE calculate_match_score(p_isir_rec igf_ap_isir_ints%ROWTYPE,
4032: p_match_setup igf_ap_record_match%ROWTYPE,
4033: p_match_dtls_rec igf_ap_match_details%ROWTYPE,
4034: p_apm_id NUMBER,
4035: p_person_id NUMBER)
4036: IS

Line 8235: p_match_code IN igf_ap_record_match_all.match_code%TYPE,

8231:
8232: END check_ptyp_code;
8233:
8234: PROCEDURE wrpr_refresh_matches(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,
8235: p_match_code IN igf_ap_record_match_all.match_code%TYPE,
8236: p_return_status OUT NOCOPY VARCHAR2,
8237: p_message_out OUT NOCOPY VARCHAR2)
8238: IS
8239: /*