APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_RESOURCES_DENORM

Line 430: , tabname => 'PJI_RESOURCES_DENORM'

426: percent => 10,
427: degree => l_degree);
428: FND_STATS.GATHER_TABLE_STATS(
429: ownname => l_schema
430: , tabname => 'PJI_RESOURCES_DENORM'
431: , percent => 10
432: , degree => l_degree
433: );
434: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

Line 907: -- PJI_RESOURCES_DENORM.

903: -- -----------------------------------------------------
904: -- procedure UPDATE_RESOURCE_DATA
905: --
906: -- This procedure incrementally synchronizes PA_RESOURCES_DENORM with
907: -- PJI_RESOURCES_DENORM.
908: --
909: -- -----------------------------------------------------
910: procedure UPDATE_RESOURCE_DATA (p_process in varchar2) is
911:

Line 924: from PJI_RESOURCES_DENORM

920: end if;
921:
922: select count(*)
923: into l_row_count
924: from PJI_RESOURCES_DENORM
925: where ROWNUM = 1;
926:
927: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
928: 'TRANSITION') = 'Y' and

Line 955: PJI_RESOURCES_DENORM pji

951: else 'N'
952: end
953: from
954: PA_RESOURCES_DENORM pa,
955: PJI_RESOURCES_DENORM pji
956: where
957: pa.PERSON_ID = pji.PERSON_ID (+) and
958: pa.RESOURCE_ID = pji.RESOURCE_ID (+) and
959: pa.RESOURCE_NAME = pji.RESOURCE_NAME (+) and

Line 965: -- Determine delta between PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM

961: pa.RESOURCE_EFFECTIVE_START_DATE = pji.START_DATE (+) and
962: nvl(pa.RESOURCE_EFFECTIVE_END_DATE, l_max_date) = pji.END_DATE (+);
963:
964: -- --------------------------------------------------------------------
965: -- Determine delta between PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM
966: -- --------------------------------------------------------------------
967:
968: if (l_extraction_type <> 'FULL') then
969:

Line 985: PJI_RESOURCES_DENORM denorm

981: denorm.START_DATE,
982: denorm.END_DATE,
983: 'N'
984: from
985: PJI_RESOURCES_DENORM denorm
986: where
987: denorm.UTILIZATION_FLAG = 'Y' and
988: denorm.ROWID not in
989: (

Line 1016: PJI_RESOURCES_DENORM pji

1012: end
1013: from
1014: PJI_ROWID_RESOURCES_DENORM res_r,
1015: PA_RESOURCES_DENORM pa,
1016: PJI_RESOURCES_DENORM pji
1017: where
1018: res_r.PJI_ROWID is not null and
1019: res_r.CHANGE_FLAG = 'Y' and
1020: res_r.PA_ROWID = pa.ROWID and

Line 1047: -- Synchronize PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM

1043:
1044: end if;
1045:
1046: -- --------------------------------------------------------
1047: -- Synchronize PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM
1048: -- --------------------------------------------------------
1049:
1050: delete /*+ use_nl(denorm) rowid(denorm) */
1051: from PJI_RESOURCES_DENORM denorm

Line 1051: from PJI_RESOURCES_DENORM denorm

1047: -- Synchronize PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM
1048: -- --------------------------------------------------------
1049:
1050: delete /*+ use_nl(denorm) rowid(denorm) */
1051: from PJI_RESOURCES_DENORM denorm
1052: where
1053: denorm.ROWID not in
1054: (
1055: select /*+ index(res_r, PJI_ROWID_RESOURCES_DENORM_N1) */

Line 1065: update /*+ use_nl(denorm) rowid(denorm) */ PJI_RESOURCES_DENORM denorm

1061: );
1062:
1063: pji_utils.write2log(sql%rowcount || ' rows deleted.');
1064:
1065: update /*+ use_nl(denorm) rowid(denorm) */ PJI_RESOURCES_DENORM denorm
1066: set
1067: (
1068: JOB_ID,
1069: UTILIZATION_FLAG

Line 1096: insert into PJI_RESOURCES_DENORM

1092: );
1093:
1094: pji_utils.write2log(sql%rowcount || ' rows updated.');
1095:
1096: insert into PJI_RESOURCES_DENORM
1097: (
1098: PERSON_ID,
1099: RESOURCE_ID,
1100: RESOURCE_NAME,

Line 1243: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RESOURCES_DENORM', 'NORMAL', null);

1239: -- PJP intermediate summarization tables
1240: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1241:
1242: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJECT_CLASSES', '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);