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_009 dependencies on IGS_PE_MTCH_SET_DATA

Line 1310: p_addr_type IN igs_pe_mtch_set_data.VALUE%TYPE,

1306: p_d_match_set_id IN NUMBER,
1307: p_interface_id IN igs_ad_interface.interface_id%TYPE,
1308: p_match_ind IN OUT NOCOPY igs_ad_interface.match_ind%TYPE,
1309: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
1310: p_addr_type IN igs_pe_mtch_set_data.VALUE%TYPE,
1311: p_person_id_type IN igs_pe_mtch_set_data.VALUE%TYPE) AS
1312: /*
1313: || Created By : pkpatel
1314: || Created On : 10-DEC-2001

Line 1311: p_person_id_type IN igs_pe_mtch_set_data.VALUE%TYPE) AS

1307: p_interface_id IN igs_ad_interface.interface_id%TYPE,
1308: p_match_ind IN OUT NOCOPY igs_ad_interface.match_ind%TYPE,
1309: p_person_id OUT NOCOPY igs_ad_interface.person_id%TYPE,
1310: p_addr_type IN igs_pe_mtch_set_data.VALUE%TYPE,
1311: p_person_id_type IN igs_pe_mtch_set_data.VALUE%TYPE) AS
1312: /*
1313: || Created By : pkpatel
1314: || Created On : 10-DEC-2001
1315: || Purpose :

Line 1340: CURSOR c_stat_data_element(cp_d_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,

1336: l_enable_log VARCHAR2(1);
1337: l_request_id NUMBER;
1338:
1339: -- ssawhney SWS104, check for ethnic origin if it exists in the matchset.
1340: CURSOR c_stat_data_element(cp_d_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,
1341: cp_lookup_code igs_pe_mtch_set_data.data_element%TYPE,
1342: cp_din VARCHAR2)
1343: IS
1344: SELECT md.exact_include

Line 1341: cp_lookup_code igs_pe_mtch_set_data.data_element%TYPE,

1337: l_request_id NUMBER;
1338:
1339: -- ssawhney SWS104, check for ethnic origin if it exists in the matchset.
1340: CURSOR c_stat_data_element(cp_d_match_set_id igs_pe_mtch_set_data.match_set_id%TYPE,
1341: cp_lookup_code igs_pe_mtch_set_data.data_element%TYPE,
1342: cp_din VARCHAR2)
1343: IS
1344: SELECT md.exact_include
1345: FROM igs_pe_mtch_set_data md

Line 1345: FROM igs_pe_mtch_set_data md

1341: cp_lookup_code igs_pe_mtch_set_data.data_element%TYPE,
1342: cp_din VARCHAR2)
1343: IS
1344: SELECT md.exact_include
1345: FROM igs_pe_mtch_set_data md
1346: WHERE md.match_set_id = cp_d_match_set_id
1347: AND md.data_element = cp_lookup_code
1348: AND md.drop_if_null = cp_din;
1349: