APPS.IGS_AD_IMP_007 dependencies on IGS_AD_API_INT_ALL

Line 1900: FROM igs_ad_api_int_all mi, igs_ad_interface_all I

1896: -- Create the cursor using the following select statement.
1897:
1898: CURSOR API(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1899: SELECT mi.*, i.person_id
1900: FROM igs_ad_api_int_all mi, igs_ad_interface_all I
1901: WHERE mi.interface_run_id = cp_interface_run_id
1902: AND mi.interface_id = i.interface_id
1903: AND i.interface_run_id = cp_interface_run_id
1904: AND mi.status = '2'

Line 2049: UPDATE igs_ad_api_int_all

2045: RETURN TRUE;
2046:
2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: UPDATE igs_ad_api_int_all
2050: SET status = '3',
2051: error_code = l_error_code
2052: WHERE interface_api_id = p_api_rec.interface_api_id;
2053:

Line 2228: UPDATE igs_ad_api_int_all

2224: P_CATEGORY => 'PERSON_ID_TYPES');
2225:
2226: -- If rule is E or I, then if the match_ind is not null, the combination is invalid
2227: IF l_rule IN ('E','I') THEN
2228: UPDATE igs_ad_api_int_all
2229: SET status = cst_stat_val_3,
2230: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
2231: WHERE match_ind IS NOT NULL
2232: AND interface_run_id = l_interface_run_id

Line 2238: UPDATE igs_ad_api_int_all mi

2234: END IF;
2235:
2236: -- If rule is E and duplicate exists, update match_ind to 19 and status to 1
2237: IF l_rule = 'E' THEN
2238: UPDATE igs_ad_api_int_all mi
2239: SET status = cst_stat_val_1,
2240: match_ind = cst_mi_val_19
2241: WHERE mi.interface_run_id = l_interface_run_id
2242: AND mi.status = cst_stat_val_2

Line 2256: UPDATE igs_ad_api_int_all

2252:
2253: -- If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
2254: -- processed in prior runs and didn't get updated .. update to status 1
2255: IF l_rule = 'R' THEN
2256: UPDATE igs_ad_api_int_all
2257: SET status = cst_stat_val_1
2258: WHERE interface_run_id = l_interface_run_id
2259: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
2260: AND status = cst_stat_val_2;

Line 2265: UPDATE igs_ad_api_int_all

2261: END IF;
2262:
2263: -- If rule is R and match_ind is neither 21 nor 25 then error
2264: IF l_rule = 'R' THEN
2265: UPDATE igs_ad_api_int_all
2266: SET status = cst_stat_val_3,
2267: ERROR_CODE = cst_err_val_695
2268: WHERE interface_run_id = l_interface_run_id
2269: AND (match_ind IS NOT NULL AND match_ind NOT IN (cst_mi_val_21,cst_mi_val_25))

Line 2275: UPDATE igs_ad_api_int_all mi

2271: END IF;
2272:
2273: -- If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
2274: IF l_rule = 'R' THEN
2275: UPDATE igs_ad_api_int_all mi
2276: SET status = cst_stat_val_1,
2277: match_ind = cst_mi_val_23
2278: WHERE mi.interface_run_id = l_interface_run_id
2279: AND mi.match_ind IS NULL

Line 2316: UPDATE igs_ad_api_int_all mi

2312: );
2313: END IF;
2314: -- If rule in R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
2315: IF l_rule = 'R' THEN
2316: UPDATE igs_ad_api_int_all mi
2317: SET status = cst_stat_val_3,
2318: match_ind = cst_mi_val_20
2319: WHERE mi.interface_run_id = l_interface_run_id
2320: AND mi.match_ind IS NULL

Line 2360: UPDATE IGS_AD_API_INT_ALL

2356: */
2357: IF (l_ucas_action = 'S')
2358: THEN
2359: -- Skip the record, no action reqd. Just mark it as processed.
2360: UPDATE IGS_AD_API_INT_ALL
2361: SET ERROR_CODE = NULL,
2362: STATUS = '1'
2363: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;
2364: ELSIF (l_ucas_action = 'E')

Line 2367: UPDATE IGS_AD_API_INT_ALL

2363: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;
2364: ELSIF (l_ucas_action = 'E')
2365: THEN
2366: -- Skip the record and set the error code.
2367: UPDATE IGS_AD_API_INT_ALL
2368: SET error_code = l_ucas_error_code,
2369: STATUS = '3'
2370: WHERE interface_api_id = api_rec.interface_api_id;
2371: ELSE

Line 2375: UPDATE IGS_AD_API_INT_ALL

2371: ELSE
2372: -- Process the record in case of 'P'. Create a new record.
2373: crt_person_id_types(p_api_rec=>api_rec,p_error_code=>l_error_code,p_status=>l_status);
2374:
2375: UPDATE IGS_AD_API_INT_ALL
2376: SET ERROR_CODE = l_error_code,
2377: STATUS = l_status
2378: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;
2379:

Line 2426: UPDATE IGS_AD_API_INT_ALL

2422: X_ATTRIBUTE19 =>NVL(api_rec.attribute19 ,check_dur_rec.attribute19),
2423: X_ATTRIBUTE20 =>NVL(api_rec.attribute20 ,check_dur_rec.attribute20),
2424: X_REGION_CD =>NVL(api_rec.region_cd ,check_dur_rec.region_cd));
2425:
2426: UPDATE IGS_AD_API_INT_ALL
2427: SET ERROR_CODE = NULL,
2428: MATCH_IND = cst_mi_val_18,
2429: STATUS = cst_stat_val_1
2430: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;

Line 2476: UPDATE IGS_AD_API_INT_ALL

2472: IF l_enable_log = 'Y' THEN
2473: igs_ad_imp_001.logerrormessage(api_rec.interface_api_id,l_error_code);
2474: END IF;
2475:
2476: UPDATE IGS_AD_API_INT_ALL
2477: SET ERROR_CODE = l_error_code,
2478: STATUS = '3'
2479: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;
2480:

Line 2518: UPDATE IGS_AD_API_INT_ALL

2514: X_ATTRIBUTE19 =>NVL(api_rec.attribute19 ,check_dur_rec.attribute19),
2515: X_ATTRIBUTE20 =>NVL(api_rec.attribute20 ,check_dur_rec.attribute20),
2516: X_REGION_CD =>NVL(api_rec.region_cd ,check_dur_rec.region_cd));
2517:
2518: UPDATE IGS_AD_API_INT_ALL
2519: SET ERROR_CODE = NULL,
2520: MATCH_IND = cst_mi_val_18,
2521: STATUS = cst_stat_val_1
2522: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;

Line 2565: UPDATE IGS_AD_API_INT_ALL

2561: IF l_enable_log = 'Y' THEN
2562: igs_ad_imp_001.logerrormessage(api_rec.interface_api_id,l_error_code);
2563: END IF;
2564:
2565: UPDATE IGS_AD_API_INT_ALL
2566: SET ERROR_CODE = l_error_code,
2567: STATUS = '3'
2568: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;
2569:

Line 2581: UPDATE IGS_AD_API_INT_ALL

2577: (p_api_rec=>api_rec,
2578: p_error_code=>l_error_code,
2579: p_status=>l_status);
2580:
2581: UPDATE IGS_AD_API_INT_ALL
2582: SET ERROR_CODE = l_error_code,
2583: STATUS = l_status
2584: WHERE INTERFACE_API_ID = API_REC.INTERFACE_API_ID;
2585: