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_MTCH_SET_DATA

Line 3036: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS

3032: SELECT partial_if_null,primary_addr_flag, exclude_inactive_ind
3033: FROM igs_pe_match_sets_all
3034: WHERE match_set_id = cp_match_set_id;
3035:
3036: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS
3037: SELECT data_element, drop_if_null, partial_include, exact_include
3038: FROM igs_pe_mtch_set_data_all
3039: WHERE match_set_id = cp_match_set_id;
3040:

Line 3038: FROM igs_pe_mtch_set_data_all

3034: WHERE match_set_id = cp_match_set_id;
3035:
3036: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS
3037: SELECT data_element, drop_if_null, partial_include, exact_include
3038: FROM igs_pe_mtch_set_data_all
3039: WHERE match_set_id = cp_match_set_id;
3040:
3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v
3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,

Line 3078: CURSOR addr_personid_type_cur(cp_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,

3074: FROM IGS_AD_INTERFACE_all
3075: WHERE interface_id = cp_interface_id;
3076:
3077: -- Cursor to check whether the set up is done for Address type/person id type in th ematch set.
3078: CURSOR addr_personid_type_cur(cp_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,
3079: cp_type igs_pe_mtch_set_data.data_element%TYPE) IS
3080: SELECT value
3081: FROM igs_pe_mtch_set_data md
3082: WHERE match_set_id = cp_match_set_id

Line 3079: cp_type igs_pe_mtch_set_data.data_element%TYPE) IS

3075: WHERE interface_id = cp_interface_id;
3076:
3077: -- Cursor to check whether the set up is done for Address type/person id type in th ematch set.
3078: CURSOR addr_personid_type_cur(cp_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,
3079: cp_type igs_pe_mtch_set_data.data_element%TYPE) IS
3080: SELECT value
3081: FROM igs_pe_mtch_set_data md
3082: WHERE match_set_id = cp_match_set_id
3083: AND md.data_element =cp_type;

Line 3081: FROM igs_pe_mtch_set_data md

3077: -- Cursor to check whether the set up is done for Address type/person id type in th ematch set.
3078: CURSOR addr_personid_type_cur(cp_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,
3079: cp_type igs_pe_mtch_set_data.data_element%TYPE) IS
3080: SELECT value
3081: FROM igs_pe_mtch_set_data md
3082: WHERE match_set_id = cp_match_set_id
3083: AND md.data_element =cp_type;
3084:
3085:

Line 3150: l_addrtype igs_pe_mtch_set_data.VALUE%TYPE;

3146: get_global_var_rec c_get_global_var%ROWTYPE;
3147: matchset_data_rec c_matchset_data_cur%ROWTYPE;
3148: l_count_exact NUMBER;
3149: l_count_partial NUMBER;
3150: l_addrtype igs_pe_mtch_set_data.VALUE%TYPE;
3151: l_personidtype igs_pe_mtch_set_data.VALUE%TYPE;
3152: l_match_ind igs_ad_interface.match_ind%TYPE;
3153:
3154: BEGIN

Line 3151: l_personidtype igs_pe_mtch_set_data.VALUE%TYPE;

3147: matchset_data_rec c_matchset_data_cur%ROWTYPE;
3148: l_count_exact NUMBER;
3149: l_count_partial NUMBER;
3150: l_addrtype igs_pe_mtch_set_data.VALUE%TYPE;
3151: l_personidtype igs_pe_mtch_set_data.VALUE%TYPE;
3152: l_match_ind igs_ad_interface.match_ind%TYPE;
3153:
3154: BEGIN
3155: