APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_ORG_DENORM

Line 396: , tabname => 'PJI_ORG_DENORM'

392:
393: -- gather statistics for PJI metadata tables
394: FND_STATS.GATHER_TABLE_STATS(
395: ownname => l_schema
396: , tabname => 'PJI_ORG_DENORM'
397: , percent => 50
398: , degree => l_degree
399: );
400: FND_STATS.GATHER_TABLE_STATS(

Line 784: -- PJI_ORG_DENORM. This is required because incremental updates on

780: -- -----------------------------------------------------
781: -- procedure UPDATE_PJI_ORG_HRCHY
782: --
783: -- This procedure incrementally synchronizes HRI_ORG_HRCHY_SUMMARY with
784: -- PJI_ORG_DENORM. This is required because incremental updates on
785: -- HRI_ORG_HRCHY_SUMMARY are performed by deleting the entire table and
786: -- repopulating it. This would cause slow mview refreshes.
787: --
788: -- -----------------------------------------------------

Line 816: PJI_ORG_DENORM pji

812: else 'N'
813: end
814: from
815: HRI_ORG_HRCHY_SUMMARY hri,
816: PJI_ORG_DENORM pji
817: where
818: hri.ORG_STRUCTURE_VERSION_ID = l_org_structure_version_id and
819: hri.ORGANIZATION_ID = pji.ORGANIZATION_ID (+) and
820: hri.SUB_ORGANIZATION_ID = pji.SUB_ORGANIZATION_ID (+);

Line 823: from PJI_ORG_DENORM denorm

819: hri.ORGANIZATION_ID = pji.ORGANIZATION_ID (+) and
820: hri.SUB_ORGANIZATION_ID = pji.SUB_ORGANIZATION_ID (+);
821:
822: delete /*+ use_nl(denorm) rowid(denorm) */
823: from PJI_ORG_DENORM denorm
824: where
825: denorm.ROWID not in
826: (
827: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */

Line 837: update /*+ use_nl(denorm) rowid(denorm) */ PJI_ORG_DENORM denorm

833: );
834:
835: pji_utils.write2log(sql%rowcount || ' rows deleted.');
836:
837: update /*+ use_nl(denorm) rowid(denorm) */ PJI_ORG_DENORM denorm
838: set
839: (
840: ORGANIZATION_LEVEL,
841: SUB_ORGANIZATION_LEVEL

Line 868: insert into PJI_ORG_DENORM

864: );
865:
866: pji_utils.write2log(sql%rowcount || ' rows updated.');
867:
868: insert into PJI_ORG_DENORM
869: (
870: ORGANIZATION_ID,
871: ORGANIZATION_LEVEL,
872: SUB_ORGANIZATION_ID,

Line 1247: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_ORG_DENORM', 'NORMAL', null);

1243: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RESOURCES_DENORM', 'NORMAL', null);
1244: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RM_WORK_TYPE_INFO', 'NORMAL', null);
1245: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_CLASS_CATEGORIES', 'NORMAL', null);
1246: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_CLASS_CODES', 'NORMAL', null);
1247: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_ORG_DENORM', 'NORMAL', null);
1248:
1249: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_HELPER_BATCH_MAP', 'NORMAL', null);
1250: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJI_PROJ_EXTR_STATUS','NORMAL', null);
1251: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJI_PROJ_BATCH_MAP', 'NORMAL', null);