APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_PJI_EXTRACTION_UTILS

Line 3174: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3170: DEGREE => l_p_degree);
3171: */
3172:
3173: if (l_extraction_type = 'FULL') then
3174: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3175: l_retcode,
3176: 'PJI_RM_WT_F_MV',
3177: 'C',
3178: 'N');

Line 3179: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3175: l_retcode,
3176: 'PJI_RM_WT_F_MV',
3177: 'C',
3178: 'N');
3179: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3180: l_retcode,
3181: 'PJI_RM_WTO_F_MV',
3182: 'C',
3183: 'N');

Line 3189: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3185: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3186: TABNAME => 'MLOG$_PJI_RM_RES_WT_F',
3187: PERCENT => 10,
3188: DEGREE => l_p_degree);
3189: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3190: l_retcode,
3191: 'PJI_RM_WT_F_MV',
3192: 'F',
3193: 'N');

Line 3198: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3194: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
3195: TABNAME => 'MLOG$_PJI_RM_WT_F_MV',
3196: PERCENT => 10,
3197: DEGREE => l_p_degree);
3198: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3199: l_retcode,
3200: 'PJI_RM_WTO_F_MV',
3201: 'F',
3202: 'N');

Line 3269: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3265: l_p_degree := 0;
3266: end if;
3267:
3268: if (l_extraction_type = 'FULL') then
3269: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3270: l_retcode,
3271: 'PJI_RM_ORG_F_MV',
3272: 'C',
3273: 'N');

Line 3274: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3270: l_retcode,
3271: 'PJI_RM_ORG_F_MV',
3272: 'C',
3273: 'N');
3274: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3275: l_retcode,
3276: 'PJI_RM_ORGO_F_MV',
3277: 'C',
3278: 'N');

Line 3284: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3280: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3281: TABNAME => 'MLOG$_PJI_RM_RES_F',
3282: PERCENT => 10,
3283: DEGREE => l_p_degree);
3284: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3285: l_retcode,
3286: 'PJI_RM_ORG_F_MV',
3287: 'F',
3288: 'N');

Line 3293: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3289: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
3290: TABNAME => 'MLOG$_PJI_RM_ORG_F_MV',
3291: PERCENT => 10,
3292: DEGREE => l_p_degree);
3293: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3294: l_retcode,
3295: 'PJI_RM_ORGO_F_MV',
3296: 'F',
3297: 'N');

Line 3362: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3358: l_p_degree := 0;
3359: end if;
3360:
3361: if (l_extraction_type = 'FULL') then
3362: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3363: l_retcode,
3364: 'PJI_RM_JOB_F_MV',
3365: 'C',
3366: 'N');

Line 3367: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3363: l_retcode,
3364: 'PJI_RM_JOB_F_MV',
3365: 'C',
3366: 'N');
3367: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3368: l_retcode,
3369: 'PJI_RM_JOBO_F_MV',
3370: 'C',
3371: 'N');

Line 3373: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3369: 'PJI_RM_JOBO_F_MV',
3370: 'C',
3371: 'N');
3372: else
3373: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3374: l_retcode,
3375: 'PJI_RM_JOB_F_MV',
3376: 'F',
3377: 'N');

Line 3382: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3378: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
3379: TABNAME => 'MLOG$_PJI_RM_JOB_F_MV',
3380: PERCENT => 10,
3381: DEGREE => l_p_degree);
3382: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3383: l_retcode,
3384: 'PJI_RM_JOBO_F_MV',
3385: 'F',
3386: 'N');

Line 3449: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3445: if (l_p_degree = 1) then
3446: l_p_degree := 0;
3447: end if;
3448:
3449: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3450: l_retcode,
3451: 'PJI_TIME_MV',
3452: 'C',
3453: 'N');

Line 3510: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3506: if (l_p_degree = 1) then
3507: l_p_degree := 0;
3508: end if;
3509:
3510: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3511: l_retcode,
3512: 'PJI_TIME_DAY_MV',
3513: 'C',
3514: 'N');

Line 3571: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

3567: if (l_p_degree = 1) then
3568: l_p_degree := 0;
3569: end if;
3570:
3571: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3572: l_retcode,
3573: 'PJI_TIME_TREND_MV',
3574: 'C',
3575: 'N');