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_CRED_INT

Line 2070: FROM IGS_AD_INTERFACE_ALL ad , IGS_PE_CRED_INT cred

2066:
2067:
2068: CURSOR c_pe_cr_cur IS
2069: SELECT cst_insert dmlmode, cred.rowid, ad.person_id, cred.*
2070: FROM IGS_AD_INTERFACE_ALL ad , IGS_PE_CRED_INT cred
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'

Line 2084: FROM IGS_AD_INTERFACE_ALL ad , IGS_PE_CRED_INT cred

2080: OR ( p_rule = 'R' AND cred.match_ind IN ('16', '25') )
2081: )
2082: UNION ALL
2083: SELECT cst_update dmlmode, cred.rowid, ad.person_id, cred.*
2084: FROM IGS_AD_INTERFACE_ALL ad , IGS_PE_CRED_INT cred
2085: WHERE cred.interface_run_id = p_interface_run_id
2086: AND ad.status IN ('1', '4')
2087: AND cred.interface_id = ad.interface_id
2088: AND cred.status = '2'

Line 2262: UPDATE igs_pe_cred_int

2258: x_mode => 'R',
2259: x_rating_code => NVL( cp_pe_cr_rec.rating_code,cp_dup_cur_rec.rating_code)
2260: );
2261:
2262: UPDATE igs_pe_cred_int
2263: SET status = cst_s_val_1, error_code = cst_ec_val_NULL, match_ind = cst_mi_val_18
2264: WHERE interface_cred_id = cp_pe_cr_rec.interface_cred_id;
2265: ELSE
2266:

Line 2267: UPDATE igs_pe_cred_int

2263: SET status = cst_s_val_1, error_code = cst_ec_val_NULL, match_ind = cst_mi_val_18
2264: WHERE interface_cred_id = cp_pe_cr_rec.interface_cred_id;
2265: ELSE
2266:
2267: UPDATE igs_pe_cred_int
2268: SET
2269: status = cst_s_val_3
2270: , match_ind = DECODE (
2271: cp_pe_cr_rec.match_ind,

Line 2278: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_error_code,'IGS_PE_CRED_INT');

2274: , error_code = l_error_code
2275: WHERE rowid = cp_pe_cr_rec.rowid ;
2276: -- Here it is assumed that validate_pe_cred procedure can only return status values '1' or '3'
2277: IF p_enable_log = 'Y' THEN
2278: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_error_code,'IGS_PE_CRED_INT');
2279: END IF;
2280:
2281: END IF;
2282:

Line 2298: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');

2294: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2295: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
2296: l_error_text := l_msg_data;
2297: IF p_enable_log = 'Y' THEN
2298: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');
2299: END IF;
2300: ELSE
2301: l_error_text := NULL;
2302: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

Line 2320: UPDATE igs_pe_cred_int

2316: END IF;
2317:
2318: END IF;
2319:
2320: UPDATE igs_pe_cred_int
2321: SET
2322: status = cst_s_val_3
2323: , match_ind = DECODE (
2324: cp_pe_cr_rec.match_ind,

Line 2383: UPDATE igs_pe_cred_int

2379: x_recommender_organization=> cp_pe_cr_rec.recommender_organization,
2380: x_mode => 'R',
2381: x_rating_code => cp_pe_cr_rec.rating_code);
2382:
2383: UPDATE igs_pe_cred_int
2384: SET status = cst_s_val_1,
2385: error_code = cst_ec_val_NULL,
2386: match_ind = cst_mi_val_11
2387: WHERE interface_cred_id = cp_pe_cr_rec.interface_cred_id;

Line 2389: UPDATE igs_pe_cred_int

2385: error_code = cst_ec_val_NULL,
2386: match_ind = cst_mi_val_11
2387: WHERE interface_cred_id = cp_pe_cr_rec.interface_cred_id;
2388: ELSE
2389: UPDATE igs_pe_cred_int
2390: SET
2391: status = cst_s_val_3
2392: , match_ind = DECODE (
2393: cp_pe_cr_rec.match_ind,

Line 2401: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,'E322','IGS_PE_CRED_INT');

2397: WHERE rowid = cp_pe_cr_rec.rowid ;
2398:
2399: -- Here it is assumed that validate_pe_cred procedure can only return status values '1' or '3'
2400: IF p_enable_log = 'Y' THEN
2401: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,'E322','IGS_PE_CRED_INT');
2402: END IF;
2403:
2404: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2405:

Line 2435: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');

2431: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2432: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
2433: l_error_text := l_msg_data;
2434: IF p_enable_log = 'Y' THEN
2435: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');
2436: END IF;
2437: ELSE
2438: l_error_text := NULL;
2439: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

Line 2457: UPDATE igs_pe_cred_int

2453: END IF;
2454:
2455: END IF;
2456:
2457: UPDATE igs_pe_cred_int
2458: SET
2459: status = cst_s_val_3
2460: , match_ind = DECODE (
2461: cp_pe_cr_rec.match_ind,

Line 2489: UPDATE IGS_PE_CRED_INT

2485: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2486: END IF;
2487: -- 1. Set STATUS to 3 for interface records with RULE = E or I and MATCH IND is not null and not '15'
2488: IF p_rule IN ('E', 'I') THEN
2489: UPDATE IGS_PE_CRED_INT
2490: SET
2491: status = '3'
2492: , error_code = 'E700'
2493: WHERE interface_run_id = p_interface_run_id

Line 2501: UPDATE igs_pe_cred_int

2497: COMMIT;
2498:
2499: -- 2. Set STATUS to 1 for interface records with RULE = R and MATCH IND = 17,18,19,22,23,24,27
2500: IF p_rule = 'R' THEN
2501: UPDATE igs_pe_cred_int
2502: SET
2503: status = '1', error_code = NULL
2504: WHERE interface_run_id = p_interface_run_id
2505: AND status = '2'

Line 2512: UPDATE igs_pe_cred_int cred

2508: COMMIT;
2509:
2510: -- 3. Set STATUS to 3 for interface records with multiple matching duplicate system records for RULE = I
2511: IF p_rule = 'I' THEN
2512: UPDATE igs_pe_cred_int cred
2513: SET
2514: status = '3'
2515: , match_ind = '13'
2516: WHERE interface_run_id = p_interface_run_id

Line 2532: UPDATE igs_pe_cred_int cred

2528: COMMIT;
2529: -- 4. Set STATUS to 3 for interface records with multiple matching duplicate system record for RULE = R
2530: -- and either MATCH IND IN (15, 21) OR IS NULL
2531: IF p_rule = 'R' THEN
2532: UPDATE igs_pe_cred_int cred
2533: SET
2534: status = '3'
2535: , match_ind = '13'
2536: WHERE interface_run_id = p_interface_run_id

Line 2552: UPDATE IGS_PE_CRED_INT cred

2548: END IF;
2549: COMMIT;
2550: -- 3. Set STATUS to 1 and MATCH IND to 19 for interface records with RULE = E matching OSS record(s)
2551: IF p_rule = 'E' THEN
2552: UPDATE IGS_PE_CRED_INT cred
2553: SET
2554: status = '1'
2555: , match_ind = '19'
2556: WHERE interface_run_id = p_interface_run_id

Line 2606: UPDATE IGS_PE_CRED_INT cred

2602:
2603: /*Set STATUS to 1 and MATCH IND to 23 for interface records with RULE = R matching OSS record(s) in
2604: ALL updateable column values, if column nullification is not allowed then the 2 DECODE should be replaced by a single NVL*/
2605: IF p_rule = 'R' THEN
2606: UPDATE IGS_PE_CRED_INT cred
2607: SET
2608: status = '1'
2609: , match_ind = '23'
2610: WHERE interface_run_id = p_interface_run_id

Line 2635: UPDATE IGS_PE_CRED_INT cred

2631:
2632: --Set STATUS to 3 and MATCH IND = 20 for interface records with RULE = R and
2633: --MATCH IND <> 21, 25, ones failed above discrepancy check
2634: IF p_rule = 'R' THEN
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

Line 2662: UPDATE IGS_PE_CRED_INT cred

2658:
2659:
2660: --Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
2661: IF p_rule = 'R' THEN
2662: UPDATE IGS_PE_CRED_INT cred
2663: SET
2664: status = '3'
2665: , error_code = 'E700'
2666: WHERE interface_run_id = p_interface_run_id