APPS.IGS_PE_IDENTIFY_DUPS dependencies on IGS_PE_MTCH_SET_DATA_ALL

Line 87: data_element igs_pe_mtch_set_data_all.data_element%TYPE,

83:
84: r_record_dup_rel_rec r_record_dup_rel;
85:
86: TYPE r_matchset_partial IS RECORD(
87: data_element igs_pe_mtch_set_data_all.data_element%TYPE,
88: drop_if_null igs_pe_mtch_set_data_all.drop_if_null%TYPE);
89:
90: TYPE t_matchset IS TABLE OF r_matchset_partial INDEX BY BINARY_INTEGER;
91:

Line 88: drop_if_null igs_pe_mtch_set_data_all.drop_if_null%TYPE);

84: r_record_dup_rel_rec r_record_dup_rel;
85:
86: TYPE r_matchset_partial IS RECORD(
87: data_element igs_pe_mtch_set_data_all.data_element%TYPE,
88: drop_if_null igs_pe_mtch_set_data_all.drop_if_null%TYPE);
89:
90: TYPE t_matchset IS TABLE OF r_matchset_partial INDEX BY BINARY_INTEGER;
91:
92: -- global variables added as part of Bug 3130316, Duplicate Person Matching Performance Improvements

Line 97: g_addr_type_din igs_pe_mtch_set_data_all.drop_if_null%TYPE;

93: g_partial_if_null igs_pe_match_sets.partial_if_null%TYPE;
94: g_exclude_inactive_ind igs_pe_match_sets.exclude_inactive_ind%TYPE;
95: g_match_set_id igs_pe_match_sets.match_set_id%TYPE;
96: g_source_type_id NUMBER; -- nsidana Bug 3633341
97: g_addr_type_din igs_pe_mtch_set_data_all.drop_if_null%TYPE;
98: g_person_id_type_din igs_pe_mtch_set_data_all.drop_if_null%TYPE;
99: g_matchset_exact t_matchset;
100: g_matchset_partial t_matchset;
101:

Line 98: g_person_id_type_din igs_pe_mtch_set_data_all.drop_if_null%TYPE;

94: g_exclude_inactive_ind igs_pe_match_sets.exclude_inactive_ind%TYPE;
95: g_match_set_id igs_pe_match_sets.match_set_id%TYPE;
96: g_source_type_id NUMBER; -- nsidana Bug 3633341
97: g_addr_type_din igs_pe_mtch_set_data_all.drop_if_null%TYPE;
98: g_person_id_type_din igs_pe_mtch_set_data_all.drop_if_null%TYPE;
99: g_matchset_exact t_matchset;
100: g_matchset_partial t_matchset;
101:
102: PROCEDURE Find_dup_rel_per(