APPS.IGS_PE_DUP_PERSON dependencies on IGS_PE_MATCH_SETS

Line 40: l_match_set_id igs_pe_match_sets_all.match_set_id%TYPE;

36: lnRows NUMBER(5);
37: l_where_clause VARCHAR2(32767) := ' person_id IN ( ';
38: l_person_id hz_parties.party_id%TYPE;
39: l_match_found BOOLEAN := FALSE;
40: l_match_set_id igs_pe_match_sets_all.match_set_id%TYPE;
41:
42: -- Cursor to check value of Profile Option: Duplicate Match Criteria
43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,
44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,

Line 44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,

40: l_match_set_id igs_pe_match_sets_all.match_set_id%TYPE;
41:
42: -- Cursor to check value of Profile Option: Duplicate Match Criteria
43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,
44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,
45: cp_closed_ind igs_pe_match_sets_all.closed_ind%TYPE) IS
46: SELECT match.match_set_id
47: FROM igs_pe_match_sets_all match,igs_pe_src_types src
48: WHERE src.system_source_type = cp_system_source_type AND

Line 45: cp_closed_ind igs_pe_match_sets_all.closed_ind%TYPE) IS

41:
42: -- Cursor to check value of Profile Option: Duplicate Match Criteria
43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,
44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,
45: cp_closed_ind igs_pe_match_sets_all.closed_ind%TYPE) IS
46: SELECT match.match_set_id
47: FROM igs_pe_match_sets_all match,igs_pe_src_types src
48: WHERE src.system_source_type = cp_system_source_type AND
49: src.source_type_id = match.source_type_id AND

Line 47: FROM igs_pe_match_sets_all match,igs_pe_src_types src

43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,
44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,
45: cp_closed_ind igs_pe_match_sets_all.closed_ind%TYPE) IS
46: SELECT match.match_set_id
47: FROM igs_pe_match_sets_all match,igs_pe_src_types src
48: WHERE src.system_source_type = cp_system_source_type AND
49: src.source_type_id = match.source_type_id AND
50: match.match_set_id = cp_match_set_id AND
51: match.closed_ind = cp_closed_ind;

Line 54: CURSOR c_get_partial_if_null(cp_match_set_id igs_pe_match_sets.partial_if_null%TYPE) IS

50: match.match_set_id = cp_match_set_id AND
51: match.closed_ind = cp_closed_ind;
52:
53: -- cursor to populate global variable g_partial_if_null
54: CURSOR c_get_partial_if_null(cp_match_set_id igs_pe_match_sets.partial_if_null%TYPE) IS
55: SELECT partial_if_null,exclude_inactive_ind
56: FROM igs_pe_match_sets
57: WHERE match_set_id = cp_match_set_id;
58:

Line 56: FROM igs_pe_match_sets

52:
53: -- cursor to populate global variable g_partial_if_null
54: CURSOR c_get_partial_if_null(cp_match_set_id igs_pe_match_sets.partial_if_null%TYPE) IS
55: SELECT partial_if_null,exclude_inactive_ind
56: FROM igs_pe_match_sets
57: WHERE match_set_id = cp_match_set_id;
58:
59: partial_if_null_rec c_get_partial_if_null%ROWTYPE;
60: