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_013 dependencies on IGS_PE_CREDENTIALS

Line 2075: AND ( NOT EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS

2071: WHERE cred.interface_run_id = p_interface_run_id
2072: AND ad.status IN ('1', '4')
2073: AND cred.interface_id = ad.interface_id
2074: AND cred.status = '2'
2075: AND ( NOT EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS
2076: WHERE person_id = ad.person_id
2077: AND credential_type_id = cred.credential_type_id
2078: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2079: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) )

Line 2090: AND EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS

2086: AND ad.status IN ('1', '4')
2087: AND cred.interface_id = ad.interface_id
2088: AND cred.status = '2'
2089: AND ( p_rule = 'I' OR (p_rule = 'R' AND cred.match_ind = cst_mi_val_21))
2090: AND EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS
2091: WHERE person_id = ad.person_id
2092: AND credential_type_id = cred.credential_type_id
2093: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2094: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))

Line 2101: igs_pe_credentials pcreds

2097: CURSOR c_dup_cur(cp_pe_cr_rec c_pe_cr_cur%ROWTYPE) IS
2098: SELECT
2099: pcreds.rowid, pcreds.*
2100: FROM
2101: igs_pe_credentials pcreds
2102: WHERE
2103: person_id = cp_pe_cr_rec.person_id
2104: AND credential_type_id = cp_pe_cr_rec.credential_type_id
2105: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) = TRUNC(NVL(cp_pe_cr_rec.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')));

Line 2247: igs_pe_credentials_pkg.update_row(

2243: p_status => l_status,
2244: p_error_code =>l_error_code
2245: );
2246: IF l_status ='1' THEN
2247: igs_pe_credentials_pkg.update_row(
2248: x_rowid => dup_cur_rec.rowid,
2249: x_credential_id => dup_cur_rec.credential_id,
2250: x_person_id => cp_dup_cur_rec.person_id,
2251: x_credential_type_id => cp_dup_cur_rec.credential_type_id,

Line 2349: l_credential_id igs_pe_credentials.credential_id%TYPE;

2345: **********************************************/
2346: l_status VARCHAR2(1);
2347: l_error_code VARCHAR2(30);
2348: l_rowid VARCHAR2(25);
2349: l_credential_id igs_pe_credentials.credential_id%TYPE;
2350:
2351: BEGIN
2352: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2353: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.begin';

Line 2369: igs_pe_credentials_pkg.insert_row(

2365: );
2366: IF l_status ='1' THEN
2367: l_rowid := NULL;
2368: l_credential_id := NULL;
2369: igs_pe_credentials_pkg.insert_row(
2370: x_rowid => l_rowid,
2371: x_credential_id => l_credential_id,
2372: x_person_id => cp_pe_cr_rec.person_id,
2373: x_credential_type_id => cp_pe_cr_rec.credential_type_id,

Line 2519: FROM igs_pe_credentials cred_oss

2515: , match_ind = '13'
2516: WHERE interface_run_id = p_interface_run_id
2517: AND status = '2'
2518: AND 1 < ( SELECT COUNT(*)
2519: FROM igs_pe_credentials cred_oss
2520: WHERE person_id = (SELECT person_id FROM igs_ad_interface_all
2521: WHERE interface_id = cred.interface_id)
2522: AND credential_type_id = cred.credential_type_id
2523: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

Line 2540: FROM igs_pe_credentials cred_oss

2536: WHERE interface_run_id = p_interface_run_id
2537: AND status = '2'
2538: AND NVL(match_ind, '15') IN ('15', '21')
2539: AND 1 < ( SELECT COUNT(*)
2540: FROM igs_pe_credentials cred_oss
2541: WHERE person_id = (SELECT person_id FROM igs_ad_interface_all
2542: WHERE interface_id = cred.interface_id)
2543: AND credential_type_id = cred.credential_type_id
2544: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

Line 2558: AND EXISTS ( SELECT 1 FROM IGS_PE_CREDENTIALS

2554: status = '1'
2555: , match_ind = '19'
2556: WHERE interface_run_id = p_interface_run_id
2557: AND status = '2'
2558: AND EXISTS ( SELECT 1 FROM IGS_PE_CREDENTIALS
2559: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2560: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2561: AND credential_type_id = cred.credential_type_id
2562: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

Line 2615: igs_pe_credentials

2611: AND status = '2'
2612: AND NVL (match_ind, '15') = '15'
2613: AND EXISTS ( SELECT 'x'
2614: FROM
2615: igs_pe_credentials
2616: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2617: WHERE interface_id = cred.interface_id
2618: AND interface_run_id = p_interface_run_id)
2619: AND credential_type_id = cred.credential_type_id

Line 2639: , dup_credential_id= (SELECT credential_id FROM igs_pe_credentials

2635: UPDATE IGS_PE_CRED_INT cred
2636: SET
2637: status = '3'
2638: , match_ind = '20'
2639: , dup_credential_id= (SELECT credential_id FROM igs_pe_credentials
2640: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2641: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2642: AND credential_type_id = cred.credential_type_id
2643: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

Line 2648: AND EXISTS (SELECT credential_id FROM igs_pe_credentials

2644: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))
2645: WHERE interface_run_id = p_interface_run_id
2646: AND status = '2'
2647: AND NVL (match_ind, '15') = '15'
2648: AND EXISTS (SELECT credential_id FROM igs_pe_credentials
2649: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2650: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2651: AND credential_type_id = cred.credential_type_id
2652: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =