DBA Data[Home] [Help]

APPS.PJI_FM_SUM_ROLLUP_FIN dependencies on PJI_PJI_EXTRACTION_UTILS

Line 5172: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5168: end if;
5169: */
5170:
5171: if (l_extraction_type = 'FULL') then
5172: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5173: l_retcode,
5174: 'PJI_FP_ORG_ET_WT_F_MV',
5175: 'C',
5176: 'N');

Line 5177: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5173: l_retcode,
5174: 'PJI_FP_ORG_ET_WT_F_MV',
5175: 'C',
5176: 'N');
5177: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5178: l_retcode,
5179: 'PJI_FP_ORGO_ET_WT_F_MV',
5180: 'C',
5181: 'N');

Line 5187: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5183: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5184: TABNAME => 'MLOG$_PJI_FP_PROJ_ET_WT_F',
5185: PERCENT => 10,
5186: DEGREE => l_p_degree);
5187: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5188: l_retcode,
5189: 'PJI_FP_ORG_ET_WT_F_MV',
5190: 'F',
5191: 'N');

Line 5196: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5192: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5193: TABNAME => 'MLOG$_PJI_FP_ORG_ET_WT_F_M',
5194: PERCENT => 10,
5195: DEGREE => l_p_degree);
5196: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5197: l_retcode,
5198: 'PJI_FP_ORGO_ET_WT_F_MV',
5199: 'F',
5200: 'N');

Line 5272: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5268: PERCENT => 10,
5269: DEGREE => l_p_degree);
5270:
5271: if (l_extraction_type = 'FULL') then
5272: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5273: l_retcode,
5274: 'PJI_FP_CLS_ET_WT_F_MV',
5275: 'C',
5276: 'N');

Line 5277: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5273: l_retcode,
5274: 'PJI_FP_CLS_ET_WT_F_MV',
5275: 'C',
5276: 'N');
5277: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5278: l_retcode,
5279: 'PJI_FP_CLSO_ET_WT_F_MV',
5280: 'C',
5281: 'N');

Line 5283: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5279: 'PJI_FP_CLSO_ET_WT_F_MV',
5280: 'C',
5281: 'N');
5282: else
5283: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5284: l_retcode,
5285: 'PJI_FP_CLS_ET_WT_F_MV',
5286: 'F',
5287: 'N');

Line 5292: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5288: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5289: TABNAME => 'MLOG$_PJI_FP_CLS_ET_WT_F_M',
5290: PERCENT => 10,
5291: DEGREE => l_p_degree);
5292: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5293: l_retcode,
5294: 'PJI_FP_CLSO_ET_WT_F_MV',
5295: 'F',
5296: 'N');

Line 5363: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5359: l_p_degree := 0;
5360: end if;
5361:
5362: if (l_extraction_type = 'FULL') then
5363: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5364: l_retcode,
5365: 'PJI_FP_ORG_ET_F_MV',
5366: 'C',
5367: 'N');

Line 5368: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5364: l_retcode,
5365: 'PJI_FP_ORG_ET_F_MV',
5366: 'C',
5367: 'N');
5368: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5369: l_retcode,
5370: 'PJI_FP_ORGO_ET_F_MV',
5371: 'C',
5372: 'N');

Line 5378: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5374: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5375: TABNAME => 'MLOG$_PJI_FP_PROJ_ET_F',
5376: PERCENT => 10,
5377: DEGREE => l_p_degree);
5378: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5379: l_retcode,
5380: 'PJI_FP_ORG_ET_F_MV',
5381: 'F',
5382: 'N');

Line 5387: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5383: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5384: TABNAME => 'MLOG$_PJI_FP_ORG_ET_F_MV',
5385: PERCENT => 10,
5386: DEGREE => l_p_degree);
5387: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5388: l_retcode,
5389: 'PJI_FP_ORGO_ET_F_MV',
5390: 'F',
5391: 'N');

Line 5456: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5452: l_p_degree := 0;
5453: end if;
5454:
5455: if (l_extraction_type = 'FULL') then
5456: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5457: l_retcode,
5458: 'PJI_FP_CLS_ET_F_MV',
5459: 'C',
5460: 'N');

Line 5461: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5457: l_retcode,
5458: 'PJI_FP_CLS_ET_F_MV',
5459: 'C',
5460: 'N');
5461: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5462: l_retcode,
5463: 'PJI_FP_CLSO_ET_F_MV',
5464: 'C',
5465: 'N');

Line 5467: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5463: 'PJI_FP_CLSO_ET_F_MV',
5464: 'C',
5465: 'N');
5466: else
5467: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5468: l_retcode,
5469: 'PJI_FP_CLS_ET_F_MV',
5470: 'F',
5471: 'N');

Line 5476: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5472: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5473: TABNAME => 'MLOG$_PJI_FP_CLS_ET_F_MV',
5474: PERCENT => 10,
5475: DEGREE => l_p_degree);
5476: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5477: l_retcode,
5478: 'PJI_FP_CLSO_ET_F_MV',
5479: 'F',
5480: 'N');

Line 5548: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5544: l_p_degree := 0;
5545: end if;
5546:
5547: if (l_extraction_type = 'FULL') then
5548: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5549: l_retcode,
5550: 'PJI_FP_ORG_F_MV',
5551: 'C',
5552: 'N');

Line 5553: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5549: l_retcode,
5550: 'PJI_FP_ORG_F_MV',
5551: 'C',
5552: 'N');
5553: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5554: l_retcode,
5555: 'PJI_FP_ORGO_F_MV',
5556: 'C',
5557: 'N');

Line 5563: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5559: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5560: TABNAME => 'MLOG$_PJI_FP_PROJ_F',
5561: PERCENT => 10,
5562: DEGREE => l_p_degree);
5563: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5564: l_retcode,
5565: 'PJI_FP_ORG_F_MV',
5566: 'F',
5567: 'N');

Line 5572: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5568: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5569: TABNAME => 'MLOG$_PJI_FP_ORG_F_MV',
5570: PERCENT => 10,
5571: DEGREE => l_p_degree);
5572: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5573: l_retcode,
5574: 'PJI_FP_ORGO_F_MV',
5575: 'F',
5576: 'N');

Line 5641: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5637: l_p_degree := 0;
5638: end if;
5639:
5640: if (l_extraction_type = 'FULL') then
5641: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5642: l_retcode,
5643: 'PJI_FP_CLS_F_MV',
5644: 'C',
5645: 'N');

Line 5646: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5642: l_retcode,
5643: 'PJI_FP_CLS_F_MV',
5644: 'C',
5645: 'N');
5646: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5647: l_retcode,
5648: 'PJI_FP_CLSO_F_MV',
5649: 'C',
5650: 'N');

Line 5652: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5648: 'PJI_FP_CLSO_F_MV',
5649: 'C',
5650: 'N');
5651: else
5652: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5653: l_retcode,
5654: 'PJI_FP_CLS_F_MV',
5655: 'F',
5656: 'N');

Line 5661: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

5657: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5658: TABNAME => 'MLOG$_PJI_FP_CLS_F_MV',
5659: PERCENT => 10,
5660: DEGREE => l_p_degree);
5661: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5662: l_retcode,
5663: 'PJI_FP_CLSO_F_MV',
5664: 'F',
5665: 'N');