APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_RBS_DENORM

Line 3115: insert into PJI_RBS_DENORM_DELTA delta_i

3111: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
3112:
3113: if (l_extraction_type = 'RBS') then
3114:
3115: insert into PJI_RBS_DENORM_DELTA delta_i
3116: (
3117: WORKER_ID,
3118: STRUCT_VERSION_ID,
3119: SUP_ID,

Line 3174: PJI_RBS_DENORM rbs,

3170: rbs.SUB_LEVEL SUB_LEVEL_OLD,
3171: 'X' SUB_LEAF_FLAG,
3172: -1 SIGN
3173: from
3174: PJI_RBS_DENORM rbs,
3175: PJI_PA_PROJ_EVENTS_LOG log
3176: where
3177: log.WORKER_ID = p_worker_id and
3178: log.EVENT_TYPE = 'RBS_PUSH' and

Line 16840: insert into PJI_RBS_DENORM den_i

16836:
16837: if (nvl(l_fpm_upgrade, 'P') <> 'C' and
16838: l_extraction_type = 'FULL') then
16839:
16840: insert into PJI_RBS_DENORM den_i
16841: (
16842: STRUCT_VERSION_ID,
16843: SUP_ID,
16844: SUBRO_ID,

Line 16870: PJI_RBS_DENORM pji

16866: l_created_by,
16867: l_last_update_login
16868: from
16869: PA_RBS_DENORM pa,
16870: PJI_RBS_DENORM pji
16871: where
16872: nvl(pa.STRUCT_VERSION_ID, -1)
16873: = nvl(pji.STRUCT_VERSION_ID (+), -1) and
16874: nvl(pa.SUP_ID, -1) = nvl(pji.SUP_ID (+), -1) and

Line 16887: delete from PJI_RBS_DENORM

16883: elsif (l_extraction_type = 'INCREMENTAL' or
16884: (nvl(l_fpm_upgrade, 'P') = 'C' and
16885: l_extraction_type = 'FULL')) then
16886:
16887: delete from PJI_RBS_DENORM
16888: where STRUCT_VERSION_ID in (select log.EVENT_OBJECT
16889: from PJI_PA_PROJ_EVENTS_LOG log
16890: where log.WORKER_ID = p_worker_id and
16891: log.EVENT_TYPE = 'PJI_RBS_CHANGE');

Line 16893: insert into PJI_RBS_DENORM

16889: from PJI_PA_PROJ_EVENTS_LOG log
16890: where log.WORKER_ID = p_worker_id and
16891: log.EVENT_TYPE = 'PJI_RBS_CHANGE');
16892:
16893: insert into PJI_RBS_DENORM
16894: (
16895: STRUCT_VERSION_ID,
16896: SUP_ID,
16897: SUBRO_ID,

Line 16938: delete from PJI_RBS_DENORM

16934: den.STRUCT_VERSION_ID = log.EVENT_OBJECT;
16935:
16936: elsif (l_extraction_type = 'RBS') then
16937:
16938: delete from PJI_RBS_DENORM
16939: where STRUCT_VERSION_ID in (select
16940: decode(log.EVENT_TYPE,
16941: 'RBS_PUSH',
16942: decode(invert.INVERT_ID,

Line 16957: insert into PJI_RBS_DENORM

16953: log.WORKER_ID = p_worker_id and
16954: log.EVENT_TYPE in ('RBS_PUSH',
16955: 'RBS_DELETE'));
16956:
16957: insert into PJI_RBS_DENORM
16958: (
16959: STRUCT_VERSION_ID,
16960: SUP_ID,
16961: SUBRO_ID,

Line 17009: delete from PJI_RBS_DENORM

17005: commit;
17006:
17007: else -- online mode
17008:
17009: delete from PJI_RBS_DENORM
17010: where STRUCT_VERSION_ID = g_rbs_version;
17011:
17012: insert into PJI_RBS_DENORM
17013: (

Line 17012: insert into PJI_RBS_DENORM

17008:
17009: delete from PJI_RBS_DENORM
17010: where STRUCT_VERSION_ID = g_rbs_version;
17011:
17012: insert into PJI_RBS_DENORM
17013: (
17014: STRUCT_VERSION_ID,
17015: SUP_ID,
17016: SUBRO_ID,

Line 17045: -- delete from PJI_RBS_DENORM_DELTA_T;

17041: PA_RBS_DENORM den
17042: where
17043: den.STRUCT_VERSION_ID = g_rbs_version;
17044:
17045: -- delete from PJI_RBS_DENORM_DELTA_T;
17046:
17047: end if;
17048:
17049: end UPDATE_RBS_DENORM;

Line 18045: 'PJI_RBS_DENORM_DELTA',

18041: 'PARTITION',
18042: 'P' || p_worker_id);
18043:
18044: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
18045: 'PJI_RBS_DENORM_DELTA',
18046: 'PARTITION',
18047: 'P' || p_worker_id);
18048:
18049: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,