APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_RBS_DENORM

Line 6369: insert into PJI_RBS_DENORM_DELTA delta_i

6365: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
6366:
6367: if (l_extraction_type = 'RBS') then
6368:
6369: insert into PJI_RBS_DENORM_DELTA delta_i
6370: (
6371: WORKER_ID,
6372: STRUCT_VERSION_ID,
6373: SUP_ID,

Line 6428: PJI_RBS_DENORM rbs,

6424: rbs.SUB_LEVEL SUB_LEVEL_OLD,
6425: 'X' SUB_LEAF_FLAG,
6426: -1 SIGN
6427: from
6428: PJI_RBS_DENORM rbs,
6429: PJI_PA_PROJ_EVENTS_LOG log
6430: where
6431: log.WORKER_ID = p_worker_id and
6432: log.EVENT_TYPE = 'RBS_PUSH' and

Line 19022: insert into PJI_RBS_DENORM den_i

19018:
19019: if (nvl(l_fpm_upgrade, 'P') <> 'C' and
19020: l_extraction_type = 'FULL') then
19021:
19022: insert into PJI_RBS_DENORM den_i
19023: (
19024: STRUCT_VERSION_ID,
19025: SUP_ID,
19026: SUBRO_ID,

Line 19052: PJI_RBS_DENORM pji

19048: l_created_by,
19049: l_last_update_login
19050: from
19051: PA_RBS_DENORM pa,
19052: PJI_RBS_DENORM pji
19053: where
19054: nvl(pa.STRUCT_VERSION_ID, -1)
19055: = nvl(pji.STRUCT_VERSION_ID (+), -1) and
19056: nvl(pa.SUP_ID, -1) = nvl(pji.SUP_ID (+), -1) and

Line 19073: insert into PJI_RBS_DENORM

19069: /* Added for Bug 9099240 Start */
19070: if PA_RBS_MAPPING.g_max_rbs_id1 is not null or
19071: PA_RBS_MAPPING.g_max_rbs_id2 is not null then
19072:
19073: insert into PJI_RBS_DENORM
19074: (
19075: STRUCT_VERSION_ID,
19076: SUP_ID,
19077: SUBRO_ID,

Line 19107: delete from PJI_RBS_DENORM

19103:
19104: else
19105: /* Added for Bug 9099240 End */
19106:
19107: delete from PJI_RBS_DENORM
19108: where STRUCT_VERSION_ID in (select log.EVENT_OBJECT
19109: from PJI_PA_PROJ_EVENTS_LOG log
19110: where log.WORKER_ID = p_worker_id and
19111: log.EVENT_TYPE = 'PJI_RBS_CHANGE');

Line 19113: insert into PJI_RBS_DENORM

19109: from PJI_PA_PROJ_EVENTS_LOG log
19110: where log.WORKER_ID = p_worker_id and
19111: log.EVENT_TYPE = 'PJI_RBS_CHANGE');
19112:
19113: insert into PJI_RBS_DENORM
19114: (
19115: STRUCT_VERSION_ID,
19116: SUP_ID,
19117: SUBRO_ID,

Line 19160: delete from PJI_RBS_DENORM

19156: end if; /* Added for Bug 9099240 */
19157:
19158: elsif (l_extraction_type = 'RBS') then
19159:
19160: delete from PJI_RBS_DENORM
19161: where STRUCT_VERSION_ID in (select
19162: decode(log.EVENT_TYPE,
19163: 'RBS_PUSH',
19164: decode(invert.INVERT_ID,

Line 19179: insert into PJI_RBS_DENORM

19175: log.WORKER_ID = p_worker_id and
19176: log.EVENT_TYPE in ('RBS_PUSH',
19177: 'RBS_DELETE'));
19178:
19179: insert into PJI_RBS_DENORM
19180: (
19181: STRUCT_VERSION_ID,
19182: SUP_ID,
19183: SUBRO_ID,

Line 19235: insert into PJI_RBS_DENORM

19231: /* Added for Bug 9099240 Start */
19232: if PA_RBS_MAPPING.g_max_rbs_id1 is not null or
19233: PA_RBS_MAPPING.g_max_rbs_id2 is not null then
19234:
19235: insert into PJI_RBS_DENORM
19236: (
19237: STRUCT_VERSION_ID,
19238: SUP_ID,
19239: SUBRO_ID,

Line 19269: delete from PJI_RBS_DENORM

19265:
19266: else
19267: /* Added for Bug 9099240 End */
19268:
19269: delete from PJI_RBS_DENORM
19270: where STRUCT_VERSION_ID = g_rbs_version;
19271:
19272: insert into PJI_RBS_DENORM
19273: (

Line 19272: insert into PJI_RBS_DENORM

19268:
19269: delete from PJI_RBS_DENORM
19270: where STRUCT_VERSION_ID = g_rbs_version;
19271:
19272: insert into PJI_RBS_DENORM
19273: (
19274: STRUCT_VERSION_ID,
19275: SUP_ID,
19276: SUBRO_ID,

Line 19305: -- delete from PJI_RBS_DENORM_DELTA_T;

19301: PA_RBS_DENORM den
19302: where
19303: den.STRUCT_VERSION_ID = g_rbs_version;
19304:
19305: -- delete from PJI_RBS_DENORM_DELTA_T;
19306:
19307: end if; /* Added for Bug 9099240 */
19308:
19309: end if;

Line 20384: 'PJI_RBS_DENORM_DELTA',

20380: l_tab12 := 'Y';
20381: end if;
20382: if l_tab13 = 'N' then
20383: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
20384: 'PJI_RBS_DENORM_DELTA',
20385: 'PARTITION',
20386: 'P' || p_worker_id);
20387: l_tab13 := 'Y';
20388: end if;