APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_AC_AGGR_PJP1

Line 5889: insert into PJI_AC_AGGR_PJP1 pjp1_i

5885: /* spliited the SQL to remove unnecessasry hits based on extraction type */
5886: IF l_extraction_type='PARTIAL' THEN -- Bug#5453009 Performance Fix .
5887: -- Sql was split into 2 for Partial and Non Partial Flows
5888:
5889: insert into PJI_AC_AGGR_PJP1 pjp1_i
5890: (
5891: WORKER_ID,
5892: RECORD_TYPE,
5893: PRG_LEVEL,

Line 6253: insert into PJI_AC_AGGR_PJP1 pjp1_i

6249: nvl(sum(CUSTOM14), 0) = 0 and
6250: nvl(sum(CUSTOM15), 0) = 0);
6251:
6252: else
6253: insert into PJI_AC_AGGR_PJP1 pjp1_i
6254: (
6255: WORKER_ID,
6256: RECORD_TYPE,
6257: PRG_LEVEL,

Line 12153: insert into PJI_AC_AGGR_PJP1

12149: STEP_SEQ = l_level_seq;
12150:
12151: -- rollup project hiearchy
12152:
12153: insert into PJI_AC_AGGR_PJP1
12154: (
12155: WORKER_ID,
12156: RECORD_TYPE,
12157: PRG_LEVEL,

Line 12415: PJI_AC_AGGR_PJP1 pjp1,

12411: pjp1.CUSTOM13,
12412: pjp1.CUSTOM14,
12413: pjp1.CUSTOM15
12414: from
12415: PJI_AC_AGGR_PJP1 pjp1,
12416: PJI_PJP_WBS_HEADER wbs_hdr,
12417: PA_XBS_DENORM wbs,
12418: PJI_XBS_DENORM prg,
12419: (

Line 12511: PJI_AC_AGGR_PJP1 pjp1,

12507: pjp1.CUSTOM13,
12508: pjp1.CUSTOM14,
12509: pjp1.CUSTOM15
12510: from
12511: PJI_AC_AGGR_PJP1 pjp1,
12512: PJI_PJP_WBS_HEADER wbs_hdr,
12513: PJI_XBS_DENORM prg
12514: where
12515: prg.STRUCT_TYPE = 'PRG' and

Line 12783: insert into PJI_AC_AGGR_PJP1_T

12779: while (l_level > 0) loop
12780:
12781: -- rollup project hiearchy
12782:
12783: insert into PJI_AC_AGGR_PJP1_T
12784: (
12785: WORKER_ID,
12786: RECORD_TYPE,
12787: PRG_LEVEL,

Line 13046: PJI_AC_AGGR_PJP1_T pjp1,

13042: pjp1.CUSTOM13,
13043: pjp1.CUSTOM14,
13044: pjp1.CUSTOM15
13045: from
13046: PJI_AC_AGGR_PJP1_T pjp1,
13047: PJI_PJP_WBS_HEADER wbs_hdr,
13048: PA_XBS_DENORM wbs,
13049: PJI_XBS_DENORM prg,
13050: (

Line 13142: PJI_AC_AGGR_PJP1_T pjp1,

13138: pjp1.CUSTOM13,
13139: pjp1.CUSTOM14,
13140: pjp1.CUSTOM15
13141: from
13142: PJI_AC_AGGR_PJP1_T pjp1,
13143: PJI_PJP_WBS_HEADER wbs_hdr,
13144: PJI_XBS_DENORM prg
13145: where
13146: prg.STRUCT_TYPE = 'PRG' and

Line 14763: insert into PJI_AC_AGGR_PJP1 pjp1_i

14759: STEP_SEQ = l_level_seq;
14760:
14761: -- rollup project hiearchy
14762:
14763: insert into PJI_AC_AGGR_PJP1 pjp1_i
14764: (
14765: WORKER_ID,
14766: RECORD_TYPE,
14767: PRG_LEVEL,

Line 15020: PJI_AC_AGGR_PJP1 pjp1,

15016: pjp1.CUSTOM13,
15017: pjp1.CUSTOM14,
15018: pjp1.CUSTOM15
15019: from
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

Line 15744: insert into PJI_AC_AGGR_PJP1 pjp1_i

15740: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
15741: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
15742: nvl(sum(pjp1.CUSTOM15), 0) = 0);
15743:
15744: insert into PJI_AC_AGGR_PJP1 pjp1_i
15745: (
15746: WORKER_ID,
15747: RECORD_TYPE,
15748: PRG_LEVEL,

Line 15861: PJI_AC_AGGR_PJP1 pjp1

15857: sum(pjp1.CUSTOM13) CUSTOM13,
15858: sum(pjp1.CUSTOM14) CUSTOM14,
15859: sum(pjp1.CUSTOM15) CUSTOM15
15860: from
15861: PJI_AC_AGGR_PJP1 pjp1
15862: where
15863: pjp1.WORKER_ID = p_worker_id
15864: group by
15865: pjp1.WORKER_ID,

Line 15965: from PJI_AC_AGGR_PJP1 pjp1

15961: where pjp1.WORKER_ID = p_worker_id and
15962: nvl(pjp1.LINE_TYPE, 'X') <> 'AGGR_PLAN';
15963:
15964: delete
15965: from PJI_AC_AGGR_PJP1 pjp1
15966: where pjp1.WORKER_ID = p_worker_id and
15967: nvl(pjp1.RECORD_TYPE, 'X') <> 'A';
15968:
15969: end if;

Line 18025: 'PJI_AC_AGGR_PJP1',

18021: 'PARTITION',
18022: 'P' || p_worker_id);
18023:
18024: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
18025: 'PJI_AC_AGGR_PJP1',
18026: 'PARTITION',
18027: 'P' || p_worker_id);
18028:
18029: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

Line 18073: delete from PJI_AC_AGGR_PJP1_T;

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;
18074:
18075: end if;
18076:
18077: end CLEANUP;