DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on PJI_PJI_EXTRACTION_UTILS

Line 1755: PJI_PJI_EXTRACTION_UTILS.SEED_PJI_RM_STATS;

1751: procedure WORKER (p_worker_id in number) is
1752:
1753: begin
1754:
1755: PJI_PJI_EXTRACTION_UTILS.SEED_PJI_RM_STATS;
1756:
1757: PJI_PJI_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
1758:
1759: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

Line 1757: PJI_PJI_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;

1753: begin
1754:
1755: PJI_PJI_EXTRACTION_UTILS.SEED_PJI_RM_STATS;
1756:
1757: PJI_PJI_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
1758:
1759: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1760: tabname => 'PJI_ORG_EXTR_INFO',
1761: percent => 10,

Line 1782: PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_ORG_HRCHY;

1778: -- always incremental.
1779: PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES;
1780:
1781: -- Populates PJI_ORG_DENORM to be used with the Materialized views
1782: PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_ORG_HRCHY;
1783:
1784: PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);
1785: PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);
1786: PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id );