eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_XBS_DENORM_DELTA

Line 2544: insert into PJI_XBS_DENORM_DELTA delta_i

2540: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
2541:
2542: if (l_extraction_type = 'INCREMENTAL') then
2543:
2544: insert into PJI_XBS_DENORM_DELTA delta_i
2545: (
2546: WORKER_ID,
2547: EVENT_ID,
2548: STRUCT_TYPE,

Line 2819: PJI_XBS_DENORM_DELTA prg,

2815: 'N' ATTRIBUTE18, -- PROG_REP_USAGE_FLAG
2816: null ATTRIBUTE19, -- update header only
2817: 'NEW_CONVERTED_RBS_PRG_EVENT' ATTRIBUTE20 -- flg converted events
2818: from
2819: PJI_XBS_DENORM_DELTA prg,
2820: PJI_PJP_RBS_HEADER sup_rbs_hdr,
2821: PA_PROJ_ELEMENT_VERSIONS sub_ver,
2822: PA_RBS_VERSIONS_B hdr
2823: where

Line 2975: insert into PJI_XBS_DENORM_DELTA_T

2971: else -- online mode
2972:
2973: -- get WBS delta for online processing
2974:
2975: insert into PJI_XBS_DENORM_DELTA_T
2976: (
2977: WORKER_ID,
2978: STRUCT_TYPE,
2979: PRG_GROUP,

Line 8778: PJI_XBS_DENORM_DELTA wbs,

8774: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
8775: from
8776: PJI_PA_PROJ_EVENTS_LOG log,
8777: PJI_PJP_WBS_HEADER wbs_hdr,
8778: PJI_XBS_DENORM_DELTA wbs,
8779: PJI_XBS_DENORM prg,
8780: PJI_FP_XBS_ACCUM_F fpr,
8781: (
8782: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 8874: PJI_XBS_DENORM_DELTA prg_delta

8870: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8871: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8872: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8873: ) invert,
8874: PJI_XBS_DENORM_DELTA prg_delta
8875: where
8876: prg.STRUCT_TYPE = 'PRG' and
8877: prg.SUB_ROLLUP_ID is not null and
8878: prg.SUB_LEVEL = l_level and

Line 10085: PJI_XBS_DENORM_DELTA_T wbs,

10081: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10082: from
10083: PA_PJI_PROJ_EVENTS_LOG log,
10084: PJI_PJP_WBS_HEADER wbs_hdr,
10085: PJI_XBS_DENORM_DELTA_T wbs,
10086: PJI_XBS_DENORM prg,
10087: PJI_FP_XBS_ACCUM_F fpr,
10088: (
10089: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 12606: PJI_XBS_DENORM_DELTA wbs,

12602: wbs.SIGN * acr.CUSTOM15 CUSTOM15
12603: from
12604: PJI_PA_PROJ_EVENTS_LOG log,
12605: PJI_PJP_WBS_HEADER wbs_hdr,
12606: PJI_XBS_DENORM_DELTA wbs,
12607: PJI_XBS_DENORM prg,
12608: PJI_AC_XBS_ACCUM_F acr,
12609: (
12610: select 1 WBS_SUP_LEVEL,

Line 12664: PJI_XBS_DENORM_DELTA prg_delta

12660: 'Y' PUSHUP_FLAG
12661: from
12662: PJI_PJP_PROJ_BATCH_MAP map,
12663: PJI_XBS_DENORM prg,
12664: PJI_XBS_DENORM_DELTA prg_delta
12665: where
12666: prg.STRUCT_TYPE = 'PRG' and
12667: prg.RELATIONSHIP_TYPE = 'LF' and
12668: prg.SUB_ROLLUP_ID is not null and

Line 13238: PJI_XBS_DENORM_DELTA_T wbs,

13234: wbs.SIGN * acr.CUSTOM15 CUSTOM15
13235: from
13236: PA_PJI_PROJ_EVENTS_LOG log,
13237: PJI_PJP_WBS_HEADER wbs_hdr,
13238: PJI_XBS_DENORM_DELTA_T wbs,
13239: PJI_XBS_DENORM prg,
13240: PJI_AC_XBS_ACCUM_F acr,
13241: (
13242: select 1 WBS_SUP_LEVEL,

Line 13432: PJI_XBS_DENORM_DELTA den

13428: nvl(max(den.SUP_LEVEL), 0)
13429: into
13430: l_level
13431: from
13432: PJI_XBS_DENORM_DELTA den
13433: where
13434: den.WORKER_ID = p_worker_id and
13435: den.STRUCT_TYPE = 'PRG';
13436:

Line 13463: PJI_XBS_DENORM_DELTA

13459: (
13460: select
13461: SUP_LEVEL
13462: from
13463: PJI_XBS_DENORM_DELTA
13464: where
13465: worker_id = p_worker_id and
13466: STRUCT_TYPE = 'PRG'
13467: union all

Line 13484: PJI_XBS_DENORM_DELTA

13480: (
13481: select
13482: 1
13483: from
13484: PJI_XBS_DENORM_DELTA
13485: where
13486: WORKER_ID = p_worker_id and
13487: ROWNUM = 1
13488: )

Line 14008: PJI_XBS_DENORM_DELTA prg,

14004: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
14005: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
14006: prg.SIGN * fpr.CUSTOM15 CUSTOM15
14007: from
14008: PJI_XBS_DENORM_DELTA prg,
14009: PA_PROJ_ELEMENTS prj_emt,
14010: PJI_PJP_WBS_HEADER wbs_hdr,
14011: PJI_FP_XBS_ACCUM_F fpr,
14012: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 14412: PJI_XBS_DENORM_DELTA prg_delta,

14408: PJI_FP_AGGR_PJP1 pjp1,
14409: PJI_PJP_WBS_HEADER wbs_hdr,
14410: PA_PROJ_ELEMENTS prj_emt,
14411: PA_XBS_DENORM prg,
14412: PJI_XBS_DENORM_DELTA prg_delta,
14413: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14414: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14415: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14416: (

Line 14670: PJI_XBS_DENORM_DELTA den

14666: nvl(max(den.SUP_LEVEL), 0)
14667: into
14668: l_level
14669: from
14670: PJI_XBS_DENORM_DELTA den
14671: where
14672: den.WORKER_ID = p_worker_id and
14673: den.STRUCT_TYPE = 'PRG';
14674:

Line 14701: PJI_XBS_DENORM_DELTA

14697: (
14698: select
14699: SUP_LEVEL
14700: from
14701: PJI_XBS_DENORM_DELTA
14702: where
14703: worker_id = p_worker_id and
14704: STRUCT_TYPE = 'PRG'
14705: union all

Line 14722: PJI_XBS_DENORM_DELTA

14718: (
14719: select
14720: 1
14721: from
14722: PJI_XBS_DENORM_DELTA
14723: where
14724: WORKER_ID = p_worker_id and
14725: ROWNUM = 1
14726: )

Line 14944: PJI_XBS_DENORM_DELTA prg,

14940: prg.SIGN * acr.CUSTOM13 CUSTOM13,
14941: prg.SIGN * acr.CUSTOM14 CUSTOM14,
14942: prg.SIGN * acr.CUSTOM15 CUSTOM15
14943: from
14944: PJI_XBS_DENORM_DELTA prg,
14945: PA_PROJ_ELEMENTS prj_emt,
14946: PJI_PJP_WBS_HEADER wbs_hdr,
14947: PJI_AC_XBS_ACCUM_F acr
14948: where

Line 15024: PJI_XBS_DENORM_DELTA prg_delta

15020: PJI_AC_AGGR_PJP1 pjp1,
15021: PJI_PJP_WBS_HEADER wbs_hdr,
15022: PA_PROJ_ELEMENTS prj_emt,
15023: PA_XBS_DENORM prg,
15024: PJI_XBS_DENORM_DELTA prg_delta
15025: where
15026: prg.STRUCT_TYPE = 'PRG' and
15027: prg.SUP_LEVEL = l_level and
15028: nvl(prg.SUB_ROLLUP_ID,

Line 16784: delete from PJI_XBS_DENORM_DELTA_T;

16780: -- g_new_struct_version);
16781:
16782: end if;
16783:
16784: delete from PJI_XBS_DENORM_DELTA_T;
16785:
16786: end if;
16787:
16788: end UPDATE_XBS_DENORM;

Line 18040: 'PJI_XBS_DENORM_DELTA',

18036: 'PARTITION',
18037: 'P' || p_worker_id);
18038:
18039: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
18040: 'PJI_XBS_DENORM_DELTA',
18041: 'PARTITION',
18042: 'P' || p_worker_id);
18043:
18044: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

Line 18069: delete from PJI_XBS_DENORM_DELTA_T;

18065: commit;
18066:
18067: else -- online mode
18068:
18069: delete from PJI_XBS_DENORM_DELTA_T;
18070:
18071: delete from PJI_FP_AGGR_PJP1_T;
18072:
18073: delete from PJI_AC_AGGR_PJP1_T;