eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_IDENTIFY_DUPS

Line 1910: IF ((l_source_type_id1 = Igs_Pe_Identify_Dups.g_source_type_id) OR (l_source_type_id2 = Igs_Pe_Identify_Dups.g_source_type_id))THEN

1906: OPEN source_type_cur('UCAS APPL');
1907: FETCH source_type_cur INTO l_source_type_id2;
1908: CLOSE source_type_cur;
1909:
1910: IF ((l_source_type_id1 = Igs_Pe_Identify_Dups.g_source_type_id) OR (l_source_type_id2 = Igs_Pe_Identify_Dups.g_source_type_id))THEN
1911: -- source cat is UCAS PER / UCAS APPL.
1912: l_call_ucas_user_hook := TRUE;
1913: END IF;
1914:

Line 3160: Igs_Pe_Identify_Dups.g_match_set_id := p_match_set_id;

3156: l_enable_log := igs_ad_imp_001.g_enable_log;
3157: l_prog_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
3158: l_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls.';
3159: -- populate global variables
3160: Igs_Pe_Identify_Dups.g_match_set_id := p_match_set_id;
3161: Igs_Pe_Identify_Dups.g_source_type_id := p_d_source_type_id;
3162: l_default_date := TRUNC(SYSDATE);
3163: l_addrtype := NULL;
3164: l_personidtype := NULL;

Line 3161: Igs_Pe_Identify_Dups.g_source_type_id := p_d_source_type_id;

3157: l_prog_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
3158: l_label := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls.';
3159: -- populate global variables
3160: Igs_Pe_Identify_Dups.g_match_set_id := p_match_set_id;
3161: Igs_Pe_Identify_Dups.g_source_type_id := p_d_source_type_id;
3162: l_default_date := TRUNC(SYSDATE);
3163: l_addrtype := NULL;
3164: l_personidtype := NULL;
3165:

Line 3168: Igs_Pe_Identify_Dups.g_partial_if_null := get_global_var_rec.partial_if_null;

3164: l_personidtype := NULL;
3165:
3166: OPEN c_get_global_var(p_match_set_id);
3167: FETCH c_get_global_var INTO get_global_var_rec;
3168: Igs_Pe_Identify_Dups.g_partial_if_null := get_global_var_rec.partial_if_null;
3169: Igs_Pe_Identify_Dups.g_primary_addr_flag := get_global_var_rec.primary_addr_flag;
3170: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := get_global_var_rec.exclude_inactive_ind;
3171: CLOSE c_get_global_var;
3172:

Line 3169: Igs_Pe_Identify_Dups.g_primary_addr_flag := get_global_var_rec.primary_addr_flag;

3165:
3166: OPEN c_get_global_var(p_match_set_id);
3167: FETCH c_get_global_var INTO get_global_var_rec;
3168: Igs_Pe_Identify_Dups.g_partial_if_null := get_global_var_rec.partial_if_null;
3169: Igs_Pe_Identify_Dups.g_primary_addr_flag := get_global_var_rec.primary_addr_flag;
3170: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := get_global_var_rec.exclude_inactive_ind;
3171: CLOSE c_get_global_var;
3172:
3173: l_count_exact := 1;

Line 3170: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := get_global_var_rec.exclude_inactive_ind;

3166: OPEN c_get_global_var(p_match_set_id);
3167: FETCH c_get_global_var INTO get_global_var_rec;
3168: Igs_Pe_Identify_Dups.g_partial_if_null := get_global_var_rec.partial_if_null;
3169: Igs_Pe_Identify_Dups.g_primary_addr_flag := get_global_var_rec.primary_addr_flag;
3170: Igs_Pe_Identify_Dups.g_exclude_inactive_ind := get_global_var_rec.exclude_inactive_ind;
3171: CLOSE c_get_global_var;
3172:
3173: l_count_exact := 1;
3174: l_count_partial := 1;

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

3175:
3176: FOR matchset_data_rec IN c_matchset_data_cur(p_match_set_id) LOOP
3177: IF matchset_data_rec.data_element NOT IN ('SURNAME','GIVEN_NAME_1_CHAR') THEN
3178: IF matchset_data_rec.exact_include = 'Y' THEN
3179: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).data_element := matchset_data_rec.data_element;
3180: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;
3181: l_count_exact := l_count_exact + 1;
3182: END IF;
3183: IF matchset_data_rec.partial_include = 'Y' THEN

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

3176: FOR matchset_data_rec IN c_matchset_data_cur(p_match_set_id) LOOP
3177: IF matchset_data_rec.data_element NOT IN ('SURNAME','GIVEN_NAME_1_CHAR') THEN
3178: IF matchset_data_rec.exact_include = 'Y' THEN
3179: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).data_element := matchset_data_rec.data_element;
3180: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;
3181: l_count_exact := l_count_exact + 1;
3182: END IF;
3183: IF matchset_data_rec.partial_include = 'Y' THEN
3184: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;

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

3180: Igs_Pe_Identify_Dups.g_matchset_exact(l_count_exact).drop_if_null := matchset_data_rec.drop_if_null;
3181: l_count_exact := l_count_exact + 1;
3182: END IF;
3183: IF matchset_data_rec.partial_include = 'Y' THEN
3184: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;
3185: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).drop_if_null := matchset_data_rec.drop_if_null;
3186: l_count_partial := l_count_partial + 1;
3187: END IF;
3188:

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

3181: l_count_exact := l_count_exact + 1;
3182: END IF;
3183: IF matchset_data_rec.partial_include = 'Y' THEN
3184: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).data_element := matchset_data_rec.data_element;
3185: Igs_Pe_Identify_Dups.g_matchset_partial(l_count_partial).drop_if_null := matchset_data_rec.drop_if_null;
3186: l_count_partial := l_count_partial + 1;
3187: END IF;
3188:
3189: IF matchset_data_rec.data_element = 'ADDR_TYPE' THEN

Line 3190: Igs_Pe_Identify_Dups.g_addr_type_din := matchset_data_rec.drop_if_null;

3186: l_count_partial := l_count_partial + 1;
3187: END IF;
3188:
3189: IF matchset_data_rec.data_element = 'ADDR_TYPE' THEN
3190: Igs_Pe_Identify_Dups.g_addr_type_din := matchset_data_rec.drop_if_null;
3191: END IF;
3192: IF matchset_data_rec.data_element = 'PERSON_ID_TYPE' THEN
3193: Igs_Pe_Identify_Dups.g_person_id_type_din := matchset_data_rec.drop_if_null;
3194: END IF;

Line 3193: Igs_Pe_Identify_Dups.g_person_id_type_din := matchset_data_rec.drop_if_null;

3189: IF matchset_data_rec.data_element = 'ADDR_TYPE' THEN
3190: Igs_Pe_Identify_Dups.g_addr_type_din := matchset_data_rec.drop_if_null;
3191: END IF;
3192: IF matchset_data_rec.data_element = 'PERSON_ID_TYPE' THEN
3193: Igs_Pe_Identify_Dups.g_person_id_type_din := matchset_data_rec.drop_if_null;
3194: END IF;
3195: END IF;
3196: END LOOP;
3197: