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_PE_PERS_IMP_001 dependencies on IGS_AD_IMP_STATS

Line 1259: -- call the procedure to store statistics in igs_ad_imp_stats

1255: UPDATE igs_ad_interface_all
1256: SET record_status = '1'
1257: WHERE interface_run_id = l_interface_run_id;
1258:
1259: -- call the procedure to store statistics in igs_ad_imp_stats
1260: pe_cat_stats('PERSON');
1261:
1262: -- Delete from the tables for Statistics
1263: pe_cat_stats('PERSON_STATISTICS_STAT');

Line 1278: -- call the procedure to store statistics in igs_ad_imp_stats

1274:
1275: DELETE FROM igs_ad_addr_int_all WHERE
1276: STATUS = '1' AND interface_run_id = l_interface_run_id;
1277:
1278: -- call the procedure to store statistics in igs_ad_imp_stats
1279: pe_cat_stats('PERSON_ID_TYPES');
1280:
1281: DELETE FROM igs_ad_api_int_all WHERE
1282: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1306: -- call the procedure to store statistics in igs_ad_imp_stats

1302:
1303: END IF;
1304:
1305: IF g_person_alias_inc THEN
1306: -- call the procedure to store statistics in igs_ad_imp_stats
1307: pe_cat_stats('PERSON_ALIAS');
1308:
1309: DELETE FROM IGS_AD_ALIAS_INT_all WHERE
1310: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1315: -- call the procedure to store statistics in igs_ad_imp_stats

1311:
1312: END IF;
1313:
1314: IF g_person_spcl_need_inc THEN
1315: -- call the procedure to store statistics in igs_ad_imp_stats
1316: pe_cat_stats('PERSON_SPECIAL_NEEDS');
1317:
1318: DELETE FROM igs_pe_sn_srvce_int WHERE
1319: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1330: -- call the procedure to store statistics in igs_ad_imp_stats

1326:
1327: END IF;
1328:
1329: IF g_person_emp_dtl_inc THEN
1330: -- call the procedure to store statistics in igs_ad_imp_stats
1331: pe_cat_stats('PERSON_EMPLOYMENT_DETAILS');
1332:
1333: DELETE FROM IGS_AD_EMP_INT_all WHERE
1334: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1340: -- call the procedure to store statistics in igs_ad_imp_stats

1336: END IF;
1337:
1338:
1339: IF g_person_int_dtl_inc THEN
1340: -- call the procedure to store statistics in igs_ad_imp_stats
1341: pe_cat_stats('PERSON_INTERNATIONAL_DETAILS');
1342:
1343: DELETE FROM IGS_PE_VST_HIST_INT WHERE
1344: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1372: -- call the procedure to store statistics in igs_ad_imp_stats

1368: END IF;
1369:
1370:
1371: IF g_person_hlth_ins_inc THEN
1372: -- call the procedure to store statistics in igs_ad_imp_stats
1373: pe_cat_stats('PERSON_HEALTH_INSURANCE');
1374:
1375: -- Delete from the table IGS_AD_HLTH_INS_INT
1376: DELETE FROM IGS_AD_HLTH_INS_INT_all WHERE

Line 1421: -- call the procedure to store statistics in igs_ad_imp_stats

1417: END IF;
1418:
1419: -- Delete from the table IGS_AD_ACADHONOR_INT
1420: IF g_person_acad_honors_inc THEN
1421: -- call the procedure to store statistics in igs_ad_imp_stats
1422: pe_cat_stats('PERSON_ACAD_HONORS');
1423:
1424: DELETE FROM IGS_AD_ACADHONOR_INT_all WHERE
1425: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1430: -- call the procedure to store statistics in igs_ad_imp_stats

1426:
1427: END IF;
1428:
1429: IF g_rel_empl_dtl_inc THEN
1430: -- call the procedure to store statistics in igs_ad_imp_stats
1431: pe_cat_stats('RELATIONS_EMPLOYMENT_DETAILS');
1432:
1433: DELETE FROM IGS_AD_RELEMP_INT_all WHERE
1434: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1439: -- call the procedure to store statistics in igs_ad_imp_stats

1435:
1436: END IF;
1437:
1438: IF g_rel_contact_inc THEN
1439: -- call the procedure to store statistics in igs_ad_imp_stats
1440: pe_cat_stats('RELATIONS_CONTACTS');
1441:
1442: DELETE FROM igs_ad_rel_con_int_all WHERE
1443: status = '1' AND interface_run_id = l_interface_run_id;

Line 1458: -- call the procedure to store statistics in igs_ad_imp_stats

1454:
1455: END IF;
1456:
1457: IF g_rel_acad_hist_inc THEN
1458: -- call the procedure to store statistics in igs_ad_imp_stats
1459: pe_cat_stats('RELATIONS_ACAD_HISTORY');
1460:
1461: DELETE FROM IGS_AD_RELACAD_INT_all WHERE
1462: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1468: -- call the procedure to store statistics in igs_ad_imp_stats

1464: END IF;
1465:
1466:
1467: IF g_person_rel_inc THEN
1468: -- call the procedure to store statistics in igs_ad_imp_stats
1469: pe_cat_stats('PERSON_RELATIONS');
1470:
1471:
1472: -- nsidana Bug 3533035 : First update the relations_int table to status 4 in case any child was not processed successfully. Then delete the records having status 1.

Line 1862: Purpose : This function is to insert the statistics into igs_ad_imp_stats.

1858: Created By : asbala
1859:
1860: Creation date : 9/23/2003
1861:
1862: Purpose : This function is to insert the statistics into igs_ad_imp_stats.
1863:
1864: Know limitations, enhancements or remarks
1865:
1866: Change History

Line 2043: INSERT INTO IGS_AD_IMP_STATS

2039: END IF;
2040:
2041: l_total_rec := l_success + l_error + l_warning;
2042: l_tab := 'IGS_AD_INTERFACE_ALL';
2043: INSERT INTO IGS_AD_IMP_STATS
2044: (
2045: INTERFACE_RUN_ID,
2046: SRC_CAT_CODE,
2047: ENTITY_NAME,

Line 2096: INSERT INTO IGS_AD_IMP_STATS

2092: l_warning := 0;
2093: END IF;
2094: l_total_rec := l_success + l_error + l_warning;
2095: l_tab := 'IGS_PE_TYPE_INT';
2096: INSERT INTO IGS_AD_IMP_STATS
2097: (
2098: INTERFACE_RUN_ID,
2099: SRC_CAT_CODE,
2100: ENTITY_NAME,

Line 2150: INSERT INTO IGS_AD_IMP_STATS

2146:
2147: l_total_rec := l_success + l_error + l_warning;
2148: l_tab := 'IGS_AD_STAT_INT_ALL';
2149: l_source_category := 'PERSON_STATISTICS';
2150: INSERT INTO IGS_AD_IMP_STATS
2151: (
2152: INTERFACE_RUN_ID,
2153: SRC_CAT_CODE,
2154: ENTITY_NAME,

Line 2204: INSERT INTO IGS_AD_IMP_STATS

2200: l_warning := 0;
2201: END IF;
2202: l_total_rec := l_success + l_error + l_warning;
2203: l_tab := 'IGS_PE_EIT_INT-STAT';
2204: INSERT INTO IGS_AD_IMP_STATS
2205: (
2206: INTERFACE_RUN_ID,
2207: SRC_CAT_CODE,
2208: ENTITY_NAME,

Line 2260: INSERT INTO IGS_AD_IMP_STATS

2256: END IF;
2257:
2258: l_total_rec := l_success + l_error + l_warning;
2259: l_tab := 'IGS_PE_RACE_INT';
2260: INSERT INTO IGS_AD_IMP_STATS
2261: (
2262: INTERFACE_RUN_ID,
2263: SRC_CAT_CODE,
2264: ENTITY_NAME,

Line 2314: INSERT INTO IGS_AD_IMP_STATS

2310: END IF;
2311:
2312: l_total_rec := l_success + l_error + l_warning;
2313: l_tab := 'IGS_AD_ADDR_INT_ALL';
2314: INSERT INTO IGS_AD_IMP_STATS
2315: (
2316: INTERFACE_RUN_ID,
2317: SRC_CAT_CODE,
2318: ENTITY_NAME,

Line 2370: INSERT INTO IGS_AD_IMP_STATS

2366: END IF;
2367:
2368: l_total_rec := l_success + l_error + l_warning;
2369: l_tab := 'IGS_AD_ADDRUSAGE_INT_ALL';
2370: INSERT INTO IGS_AD_IMP_STATS
2371: (
2372: INTERFACE_RUN_ID,
2373: SRC_CAT_CODE,
2374: ENTITY_NAME,

Line 2424: INSERT INTO IGS_AD_IMP_STATS

2420: END IF;
2421:
2422: l_total_rec := l_success + l_error + l_warning;
2423: l_tab := 'IGS_AD_ALIAS_INT_ALL';
2424: INSERT INTO IGS_AD_IMP_STATS
2425: (
2426: INTERFACE_RUN_ID,
2427: SRC_CAT_CODE,
2428: ENTITY_NAME,

Line 2480: INSERT INTO IGS_AD_IMP_STATS

2476: END IF;
2477:
2478: l_total_rec := l_success + l_error + l_warning;
2479: l_tab := 'IGS_AD_API_INT_ALL';
2480: INSERT INTO IGS_AD_IMP_STATS
2481: (
2482: INTERFACE_RUN_ID,
2483: SRC_CAT_CODE,
2484: ENTITY_NAME,

Line 2534: INSERT INTO IGS_AD_IMP_STATS

2530: END IF;
2531:
2532: l_total_rec := l_success + l_error + l_warning;
2533: l_tab := 'IGS_AD_DISABLTY_INT_ALL';
2534: INSERT INTO IGS_AD_IMP_STATS
2535: (
2536: INTERFACE_RUN_ID,
2537: SRC_CAT_CODE,
2538: ENTITY_NAME,

Line 2590: INSERT INTO IGS_AD_IMP_STATS

2586: END IF;
2587:
2588: l_total_rec := l_success + l_error + l_warning;
2589: l_tab := 'IGS_PE_SN_SRVCE_INT';
2590: INSERT INTO IGS_AD_IMP_STATS
2591: (
2592: INTERFACE_RUN_ID,
2593: SRC_CAT_CODE,
2594: ENTITY_NAME,

Line 2645: INSERT INTO IGS_AD_IMP_STATS

2641: l_warning := 0;
2642: END IF;
2643: l_total_rec := l_success + l_error + l_warning;
2644: l_tab := 'IGS_PE_SN_CONCT_INT';
2645: INSERT INTO IGS_AD_IMP_STATS
2646: (
2647: INTERFACE_RUN_ID,
2648: SRC_CAT_CODE,
2649: ENTITY_NAME,

Line 2699: INSERT INTO IGS_AD_IMP_STATS

2695: END IF;
2696:
2697: l_total_rec := l_total_rec + l_success + l_error + l_warning;
2698: l_tab := 'IGS_AD_EMP_INT_ALL';
2699: INSERT INTO IGS_AD_IMP_STATS
2700: (
2701: INTERFACE_RUN_ID,
2702: SRC_CAT_CODE,
2703: ENTITY_NAME,

Line 2753: INSERT INTO IGS_AD_IMP_STATS

2749: END IF;
2750:
2751: l_total_rec := l_success + l_error + l_warning;
2752: l_tab := 'IGS_PE_VISA_INT';
2753: INSERT INTO IGS_AD_IMP_STATS
2754: (
2755: INTERFACE_RUN_ID,
2756: SRC_CAT_CODE,
2757: ENTITY_NAME,

Line 2809: INSERT INTO IGS_AD_IMP_STATS

2805: END IF;
2806:
2807: l_total_rec := l_success + l_error + l_warning;
2808: l_tab := 'IGS_PE_PASSPORT_INT';
2809: INSERT INTO IGS_AD_IMP_STATS
2810: (
2811: INTERFACE_RUN_ID,
2812: SRC_CAT_CODE,
2813: ENTITY_NAME,

Line 2865: INSERT INTO IGS_AD_IMP_STATS

2861: END IF;
2862:
2863: l_total_rec := l_success + l_error + l_warning;
2864: l_tab := 'IGS_PE_VST_HIST_INT';
2865: INSERT INTO IGS_AD_IMP_STATS
2866: (
2867: INTERFACE_RUN_ID,
2868: SRC_CAT_CODE,
2869: ENTITY_NAME,

Line 2921: INSERT INTO IGS_AD_IMP_STATS

2917: END IF;
2918:
2919: l_total_rec := l_success + l_error + l_warning;
2920: l_tab := 'IGS_PE_EIT_INT-INTL';
2921: INSERT INTO IGS_AD_IMP_STATS
2922: (
2923: INTERFACE_RUN_ID,
2924: SRC_CAT_CODE,
2925: ENTITY_NAME,

Line 2976: INSERT INTO IGS_AD_IMP_STATS

2972: l_warning := 0;
2973: END IF;
2974: l_total_rec := l_success + l_error + l_warning;
2975: l_tab := 'IGS_PE_CITIZEN_INT';
2976: INSERT INTO IGS_AD_IMP_STATS
2977: (
2978: INTERFACE_RUN_ID,
2979: SRC_CAT_CODE,
2980: ENTITY_NAME,

Line 3032: INSERT INTO IGS_AD_IMP_STATS

3028: END IF;
3029:
3030: l_total_rec := l_success + l_error + l_warning;
3031: l_tab := 'IGS_PE_FUND_SRC_INT';
3032: INSERT INTO IGS_AD_IMP_STATS
3033: (
3034: INTERFACE_RUN_ID,
3035: SRC_CAT_CODE,
3036: ENTITY_NAME,

Line 3086: INSERT INTO IGS_AD_IMP_STATS

3082: END IF;
3083:
3084: l_total_rec := l_success + l_error + l_warning;
3085: l_tab := 'IGS_PE_IMMU_DTL_INT';
3086: INSERT INTO IGS_AD_IMP_STATS
3087: (
3088: INTERFACE_RUN_ID,
3089: SRC_CAT_CODE,
3090: ENTITY_NAME,

Line 3141: INSERT INTO IGS_AD_IMP_STATS

3137: l_warning := 0;
3138: END IF;
3139: l_total_rec := l_success + l_error + l_warning;
3140: l_tab := 'IGS_AD_HLTH_INS_INT_ALL';
3141: INSERT INTO IGS_AD_IMP_STATS
3142: (
3143: INTERFACE_RUN_ID,
3144: SRC_CAT_CODE,
3145: ENTITY_NAME,

Line 3195: INSERT INTO IGS_AD_IMP_STATS

3191: END IF;
3192:
3193: l_total_rec := l_success + l_error + l_warning;
3194: l_tab := 'IGS_AD_MILITARY_INT_ALL';
3195: INSERT INTO IGS_AD_IMP_STATS
3196: (
3197: INTERFACE_RUN_ID,
3198: SRC_CAT_CODE,
3199: ENTITY_NAME,

Line 3249: INSERT INTO IGS_AD_IMP_STATS

3245: END IF;
3246:
3247: l_total_rec := l_success + l_error + l_warning;
3248: l_tab := 'IGS_AD_EXCURR_INT_ALL';
3249: INSERT INTO IGS_AD_IMP_STATS
3250: (
3251: INTERFACE_RUN_ID,
3252: SRC_CAT_CODE,
3253: ENTITY_NAME,

Line 3303: INSERT INTO IGS_AD_IMP_STATS

3299: END IF;
3300:
3301: l_total_rec := l_success + l_error + l_warning;
3302: l_tab := 'IGS_AD_RELATIONS_INT_ALL';
3303: INSERT INTO IGS_AD_IMP_STATS
3304: (
3305: INTERFACE_RUN_ID,
3306: SRC_CAT_CODE,
3307: ENTITY_NAME,

Line 3357: INSERT INTO IGS_AD_IMP_STATS

3353: END IF;
3354:
3355: l_total_rec := l_success + l_error + l_warning;
3356: l_tab := 'IGS_PE_ATH_DTL_INT';
3357: INSERT INTO IGS_AD_IMP_STATS
3358: (
3359: INTERFACE_RUN_ID,
3360: SRC_CAT_CODE,
3361: ENTITY_NAME,

Line 3413: INSERT INTO IGS_AD_IMP_STATS

3409: END IF;
3410:
3411: l_total_rec := l_success + l_error + l_warning;
3412: l_tab := 'IGS_PE_ATH_PRG_INT';
3413: INSERT INTO IGS_AD_IMP_STATS
3414: (
3415: INTERFACE_RUN_ID,
3416: SRC_CAT_CODE,
3417: ENTITY_NAME,

Line 3467: INSERT INTO IGS_AD_IMP_STATS

3463: END IF;
3464:
3465: l_total_rec := l_success + l_error + l_warning;
3466: l_tab := 'IGS_AD_LANGUAGE_INT_ALL';
3467: INSERT INTO IGS_AD_IMP_STATS
3468: (
3469: INTERFACE_RUN_ID,
3470: SRC_CAT_CODE,
3471: ENTITY_NAME,

Line 3521: INSERT INTO IGS_AD_IMP_STATS

3517: END IF;
3518:
3519: l_total_rec := l_success + l_error + l_warning;
3520: l_tab := 'IGS_AD_CONTACTS_INT_ALL';
3521: INSERT INTO IGS_AD_IMP_STATS
3522: (
3523: INTERFACE_RUN_ID,
3524: SRC_CAT_CODE,
3525: ENTITY_NAME,

Line 3575: INSERT INTO IGS_AD_IMP_STATS

3571: END IF;
3572:
3573: l_total_rec := l_success + l_error + l_warning;
3574: l_tab := 'IGS_PE_FLNY_DTL_INT';
3575: INSERT INTO IGS_AD_IMP_STATS
3576: (
3577: INTERFACE_RUN_ID,
3578: SRC_CAT_CODE,
3579: ENTITY_NAME,

Line 3631: INSERT INTO IGS_AD_IMP_STATS

3627: END IF;
3628:
3629: l_total_rec := l_success + l_error + l_warning;
3630: l_tab := 'IGS_PE_HEAR_DTL_INT';
3631: INSERT INTO IGS_AD_IMP_STATS
3632: (
3633: INTERFACE_RUN_ID,
3634: SRC_CAT_CODE,
3635: ENTITY_NAME,

Line 3684: INSERT INTO IGS_AD_IMP_STATS

3680: l_warning := 0;
3681: END IF;
3682: l_total_rec := l_success + l_error + l_warning;
3683: l_tab := 'IGS_PE_HOUSING_INT';
3684: INSERT INTO IGS_AD_IMP_STATS
3685: (
3686: INTERFACE_RUN_ID,
3687: SRC_CAT_CODE,
3688: ENTITY_NAME,

Line 3738: INSERT INTO IGS_AD_IMP_STATS

3734: END IF;
3735:
3736: l_total_rec := l_success + l_error + l_warning;
3737: l_tab := 'IGS_AD_ACADHONOR_INT_ALL';
3738: INSERT INTO IGS_AD_IMP_STATS
3739: (
3740: INTERFACE_RUN_ID,
3741: SRC_CAT_CODE,
3742: ENTITY_NAME,

Line 3791: INSERT INTO IGS_AD_IMP_STATS

3787: l_warning := 0;
3788: END IF;
3789: l_total_rec := l_success + l_error + l_warning;
3790: l_tab := 'IGS_PE_RES_DTLS_INT';
3791: INSERT INTO IGS_AD_IMP_STATS
3792: (
3793: INTERFACE_RUN_ID,
3794: SRC_CAT_CODE,
3795: ENTITY_NAME,

Line 3845: INSERT INTO IGS_AD_IMP_STATS

3841: END IF;
3842:
3843: l_total_rec := l_success + l_error + l_warning;
3844: l_tab := 'IGS_AD_RELACAD_INT_ALL';
3845: INSERT INTO IGS_AD_IMP_STATS
3846: (
3847: INTERFACE_RUN_ID,
3848: SRC_CAT_CODE,
3849: ENTITY_NAME,

Line 3898: INSERT INTO IGS_AD_IMP_STATS

3894: END IF;
3895:
3896: l_total_rec := l_success + l_error + l_warning;
3897: l_tab := 'IGS_AD_RELADDR_INT_ALL';
3898: INSERT INTO IGS_AD_IMP_STATS
3899: (
3900: INTERFACE_RUN_ID,
3901: SRC_CAT_CODE,
3902: ENTITY_NAME,

Line 3950: INSERT INTO IGS_AD_IMP_STATS

3946: l_warning := 0;
3947: END IF;
3948: l_total_rec := l_success + l_error + l_warning;
3949: l_tab := 'IGS_AD_REL_CON_INT_ALL';
3950: INSERT INTO IGS_AD_IMP_STATS
3951: (
3952: INTERFACE_RUN_ID,
3953: SRC_CAT_CODE,
3954: ENTITY_NAME,

Line 4002: INSERT INTO IGS_AD_IMP_STATS

3998: l_warning := 0;
3999: END IF;
4000: l_total_rec := l_success + l_error + l_warning;
4001: l_tab := 'IGS_AD_RELEMP_INT_ALL';
4002: INSERT INTO IGS_AD_IMP_STATS
4003: (
4004: INTERFACE_RUN_ID,
4005: SRC_CAT_CODE,
4006: ENTITY_NAME,

Line 4056: INSERT INTO IGS_AD_IMP_STATS

4052: l_warning := 0;
4053: END IF;
4054: l_total_rec := l_success + l_error + l_warning;
4055: l_tab := 'IGS_PE_CRED_INT';
4056: INSERT INTO IGS_AD_IMP_STATS
4057: (
4058: INTERFACE_RUN_ID,
4059: SRC_CAT_CODE,
4060: ENTITY_NAME,

Line 4109: INSERT INTO IGS_AD_IMP_STATS

4105: l_warning := 0;
4106: END IF;
4107: l_total_rec := l_success + l_error + l_warning;
4108: l_tab := 'IGS_AD_ACADHIS_INT_ALL';
4109: INSERT INTO IGS_AD_IMP_STATS
4110: (
4111: INTERFACE_RUN_ID,
4112: SRC_CAT_CODE,
4113: ENTITY_NAME,

Line 4162: INSERT INTO IGS_AD_IMP_STATS

4158: l_warning := 0;
4159: END IF;
4160: l_total_rec := l_success + l_error + l_warning;
4161: l_tab := 'IGS_PE_PRIVACY_INT';
4162: INSERT INTO IGS_AD_IMP_STATS
4163: (
4164: INTERFACE_RUN_ID,
4165: SRC_CAT_CODE,
4166: ENTITY_NAME,