APPS.IGS_PE_DUP_PERSON dependencies on IGS_PE_IDENTIFY_DUPS

Line 89: Igs_Pe_Identify_Dups.g_match_set_id := x_match_set_id;

85: END IF;
86: CLOSE c_match_set_criteria;
87: END IF;
88:
89: Igs_Pe_Identify_Dups.g_match_set_id := x_match_set_id;
90: OPEN c_get_partial_if_null(x_match_set_id);
91: FETCH c_get_partial_if_null INTO partial_if_null_rec;
92: CLOSE c_get_partial_if_null;
93:

Line 94: Igs_Pe_Identify_Dups.g_partial_if_null := partial_if_null_rec.partial_if_null;

90: OPEN c_get_partial_if_null(x_match_set_id);
91: FETCH c_get_partial_if_null INTO partial_if_null_rec;
92: CLOSE c_get_partial_if_null;
93:
94: Igs_Pe_Identify_Dups.g_partial_if_null := partial_if_null_rec.partial_if_null;
95: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := partial_if_null_rec.exclude_inactive_ind;
96:
97: -- Populate the PL/SQL tables and other global variables used for caching :- Bug 3130316
98: l_count_exact := 1;

Line 95: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := partial_if_null_rec.exclude_inactive_ind;

91: FETCH c_get_partial_if_null INTO partial_if_null_rec;
92: CLOSE c_get_partial_if_null;
93:
94: Igs_Pe_Identify_Dups.g_partial_if_null := partial_if_null_rec.partial_if_null;
95: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := partial_if_null_rec.exclude_inactive_ind;
96:
97: -- Populate the PL/SQL tables and other global variables used for caching :- Bug 3130316
98: l_count_exact := 1;
99: l_count_partial := 1;

Line 103: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).data_element := matchset_data_rec.data_element;

99: l_count_partial := 1;
100: FOR matchset_data_rec IN c_matchset_data_cur(x_match_set_id) LOOP
101: IF matchset_data_rec.data_element NOT IN ('SURNAME','GIVEN_NAME_1_CHAR') THEN
102: IF matchset_data_rec.exact_include = 'Y' THEN
103: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).data_element := matchset_data_rec.data_element;
104: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;
105: l_count_exact := l_count_exact + 1;
106: END IF;
107: IF matchset_data_rec.partial_include = 'Y' THEN

Line 104: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;

100: FOR matchset_data_rec IN c_matchset_data_cur(x_match_set_id) LOOP
101: IF matchset_data_rec.data_element NOT IN ('SURNAME','GIVEN_NAME_1_CHAR') THEN
102: IF matchset_data_rec.exact_include = 'Y' THEN
103: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).data_element := matchset_data_rec.data_element;
104: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;
105: l_count_exact := l_count_exact + 1;
106: END IF;
107: IF matchset_data_rec.partial_include = 'Y' THEN
108: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;

Line 108: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;

104: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;
105: l_count_exact := l_count_exact + 1;
106: END IF;
107: IF matchset_data_rec.partial_include = 'Y' THEN
108: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;
109: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).drop_if_null := matchset_data_rec.drop_if_null;
110: l_count_partial := l_count_partial + 1;
111: END IF;
112: END IF;

Line 109: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).drop_if_null := matchset_data_rec.drop_if_null;

105: l_count_exact := l_count_exact + 1;
106: END IF;
107: IF matchset_data_rec.partial_include = 'Y' THEN
108: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;
109: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).drop_if_null := matchset_data_rec.drop_if_null;
110: l_count_partial := l_count_partial + 1;
111: END IF;
112: END IF;
113: END LOOP;

Line 115: Igs_Pe_Identify_Dups.form_dup_whereclause (

111: END IF;
112: END IF;
113: END LOOP;
114:
115: Igs_Pe_Identify_Dups.form_dup_whereclause (
116: x_errbuf => lv_errbuf,
117: x_retcode => lv_retcode,
118: x_match_set_id => x_match_set_id,
119: x_match_category => x_exact_partial,

Line 189: Igs_Pe_Identify_Dups.form_dup_whereclause (

185: IF lv_Do_Partial = 'Y' THEN
186: /*change made for bug number 2158920 */
187: x_exact_partial := 'P';
188:
189: Igs_Pe_Identify_Dups.form_dup_whereclause (
190: x_errbuf => lv_errbuf,
191: x_retcode => lv_retcode,
192: x_match_set_id => x_match_set_id,
193: x_match_category => x_exact_partial,