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_DENORM dependencies on PA_XBS_DENORM

Line 141: delete /+ index(xbs, PA_XBS_DENORM_N2) /

137: );
138: end if;
139:
140: -- ###perf_bug### Bug 3828726
141: delete /*+ index(xbs, PA_XBS_DENORM_N2) */
142: from pa_xbs_denorm xbs
143: where struct_type in ('WBS', 'XBS')
144: and struct_version_id = p_wbs_version_id;
145:

Line 142: from pa_xbs_denorm xbs

138: end if;
139:
140: -- ###perf_bug### Bug 3828726
141: delete /*+ index(xbs, PA_XBS_DENORM_N2) */
142: from pa_xbs_denorm xbs
143: where struct_type in ('WBS', 'XBS')
144: and struct_version_id = p_wbs_version_id;
145:
146: -- delete PRG slices for specific prg_group and p_wbs_version_id

Line 182: from pa_xbs_denorm

178: then
179:
180: -- ###performance###
181: delete
182: from pa_xbs_denorm
183: where struct_type = 'PRG'
184: and prg_group = l_prg_group_id;
185:
186: -- repopulate PRG slices PA_XBS_DENORM for a prg group

Line 186: -- repopulate PRG slices PA_XBS_DENORM for a prg group

182: from pa_xbs_denorm
183: where struct_type = 'PRG'
184: and prg_group = l_prg_group_id;
185:
186: -- repopulate PRG slices PA_XBS_DENORM for a prg group
187: prg_denorm_online(
188: p_worker_id,
189: 'ONLINE',
190: l_prg_group_id,

Line 197: delete /+ index(prg, PA_XBS_DENORM_N1) /

193:
194: else
195:
196: -- ###perf_bug### Bug 3828726
197: delete /*+ index(prg, PA_XBS_DENORM_N1) */
198: from pa_xbs_denorm prg
199: where struct_type = 'PRG'
200: and struct_version_id is null
201: and sup_id = p_wbs_version_id

Line 198: from pa_xbs_denorm prg

194: else
195:
196: -- ###perf_bug### Bug 3828726
197: delete /*+ index(prg, PA_XBS_DENORM_N1) */
198: from pa_xbs_denorm prg
199: where struct_type = 'PRG'
200: and struct_version_id is null
201: and sup_id = p_wbs_version_id
202: and sub_id = p_wbs_version_id;

Line 204: -- repopulate PRG slices PA_XBS_DENORM for a wbs_version_id

200: and struct_version_id is null
201: and sup_id = p_wbs_version_id
202: and sub_id = p_wbs_version_id;
203:
204: -- repopulate PRG slices PA_XBS_DENORM for a wbs_version_id
205: prg_denorm_online(
206: p_worker_id,
207: 'ONLINE',
208: null,

Line 214: -- repopulate WBS/XBS slices PA_XBS_DENORM for a wbs_version_id

210: );
211: end if;
212:
213: -- ----------------------------------------------
214: -- repopulate WBS/XBS slices PA_XBS_DENORM for a wbs_version_id
215:
216: wbs_denorm_online(
217: p_worker_id,
218: 'ONLINE',

Line 289: -- PA_XBS_DENORM is empty, populate from scratch

285: l_fpm_upgrade = 'P'
286: )
287: then
288:
289: -- PA_XBS_DENORM is empty, populate from scratch
290:
291: -- XBS normalization algorithm for all data in
292: -- the structures tables.
293:

Line 318: -- PA_XBS_DENORM contains data, repopulate a portion of it

314: or
315: l_extraction_type = 'PARTIAL'
316: )
317: then
318: -- PA_XBS_DENORM contains data, repopulate a portion of it
319:
320: -- delete WBS/XBS slices for specific struct_version_id -- ###delete###
321: FOR WBS_DELETE_NODE IN
322: (

Line 354: from PA_XBS_DENORM

350: );
351: end if;
352:
353: delete
354: from PA_XBS_DENORM
355: where 1=1
356: and STRUCT_TYPE in ('WBS', 'XBS')
357: and STRUCT_VERSION_ID = WBS_DELETE_NODE.event_object_id;
358:

Line 426: from PA_XBS_DENORM

422: );
423: end if;
424:
425: delete
426: from PA_XBS_DENORM
427: where 1=1
428: -- and struct_type = 'PRG'
429: and sup_project_id = PRG_PROJECT_NODE.project_id;
430:

Line 476: from PA_XBS_DENORM

472: );
473: end if;
474:
475: delete
476: from PA_XBS_DENORM
477: where 1=1
478: -- and struct_type = 'PRG'
479: and sup_project_id = PRG_PROJECT_NODE.project_id;
480:

Line 576: from pa_xbs_denorm

572: -- Declare statements --
573: /*bug#4590082, changed the WBS check to PRG slice check to see if any valid source version exists*/
574: cursor c_version_exists is select 1 from dual
575: where exists (select 1
576: from pa_xbs_denorm
577: where struct_version_id is null
578: and sup_id=p_wbs_version_id_from
579: and sub_id=p_wbs_version_id_from );
580: l_dummy NUMBER;

Line 623: from pa_xbs_denorm

619: select 1
620: into l_prg_exists
621: from dual
622: where exists (select 1
623: from pa_xbs_denorm
624: where struct_version_id is null
625: and sup_id=p_wbs_version_id_to
626: and sub_id=p_wbs_version_id_to);
627:

Line 668: from pa_xbs_denorm_temp temp

664: ,projv1s.element_version_id sup_id,projv1s.parent_structure_version_id struct_version_id
665: ,temp.sub_leaf_flag, temp.sup_level, temp.sub_level,temp.relationship_type
666: , decode( temp.struct_type,'WBS',l_top_proj_element_id,null) struct_emt_id
667: ,temp.sub_rollup_id,0,0,0,temp.sub_element_number,temp.subro_element_number
668: from pa_xbs_denorm_temp temp
669: ,PA_PROJ_ELEMENT_VERSIONS projv1s
670: ,pa_proj_elements proje1s
671: where proje1s.element_number= temp.sup_element_number
672: and proje1s.proj_element_id =projv1s.proj_element_id

Line 695: insert into PA_XBS_DENORM_temp

691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
693:
694: begin
695: insert into PA_XBS_DENORM_temp
696: (
697: struct_type, prg_group, sup_project_id,
698: sup_emt_id, sup_id, struct_version_id,
699: sub_leaf_flag, sup_level, sub_level,

Line 719: from pa_xbs_denorm xbs

715: ,(select decode( proje.object_type,'PA_TASKS',proje.element_number,'PA_STRUCTURES',to_char(l_top_proj_element_id ),null) from pa_proj_elements proje
716: where proje.proj_element_id= xbs.sup_emt_id ) sup_element_number
717: ,(select projec.element_number from pa_proj_elements projec
718: where projec.proj_element_id= xbs.subro_id) subro_element_number
719: from pa_xbs_denorm xbs
720: ,PA_PROJ_ELEMENT_VERSIONS projsup
721: where xbs.sup_emt_id =projsup.proj_element_id
722: and xbs.sup_id=projsup.element_version_id
723: and xbs.struct_version_id =p_wbs_version_id_from

Line 746: delete from pa_xbs_denorm_temp;

742: subro_idtab,
743: sub_element_numbertab,
744: subro_element_numbertab;
745:
746: delete from pa_xbs_denorm_temp;
747: IF struct_typetab.COUNT <>0 then
748: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
749: insert into PA_XBS_DENORM_temp
750: (

Line 749: insert into PA_XBS_DENORM_temp

745:
746: delete from pa_xbs_denorm_temp;
747: IF struct_typetab.COUNT <>0 then
748: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
749: insert into PA_XBS_DENORM_temp
750: (
751: struct_type
752: ,prg_group
753: ,sup_project_id

Line 812: from pa_xbs_denorm_temp temp

808: AND PROJE1.PROJ_ELEMENT_ID= PROJV1.PROJ_ELEMENT_ID
809: AND PROJV1.PARENT_STRUCTURE_VERSION_ID= TEMP.STRUCT_VERSION_ID
810: AND PROJV1.PARENT_STRUCTURE_VERSION_ID=p_wbs_version_id_to
811: ) subro_id
812: from pa_xbs_denorm_temp temp
813: ,PA_PROJ_ELEMENT_VERSIONS projv1b
814: ,pa_proj_elements proje1b
815: where proje1b.element_number= temp.sub_element_number
816: and proje1b.proj_element_id =projv1b.proj_element_id

Line 859: insert into PA_XBS_DENORM(

855: ,subro_idtab ;
856: --write_log('second fetch done 1');
857: IF struct_typetab.COUNT <>0 then
858: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
859: insert into PA_XBS_DENORM(
860: struct_type
861: ,prg_group
862: ,struct_version_id
863: ,sup_project_id

Line 905: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/

901: ,l_last_update_login
902: );
903: END IF;
904: /* The below insert replaces the call to Pji_Pjp_Sum_Rollup.update_xbs_denorm
905: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/
906: IF struct_typetab.COUNT <>0 then
907: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
908: insert into PJI_XBS_DENORM(
909: struct_type

Line 958: into PA_XBS_DENORM

954: -- write_log('insert bulk into xbs_Denorm done 1');
955: end;
956: /* inserting the PRG lines*/
957: insert
958: into PA_XBS_DENORM
959: (
960: struct_type,
961: prg_group,
962: struct_version_id,

Line 992: from PA_XBS_DENORM xbs

988: xbs.struct_emt_id,to_number(p_wbs_version_id_to) wsup_id,
989: to_number(p_wbs_version_id_to) wsub_id,l_last_update_date,
990: l_last_updated_by,l_creation_date,
991: l_created_by ,l_last_update_login
992: from PA_XBS_DENORM xbs
993: where xbs.struct_version_id is null
994: and xbs.sup_id=p_wbs_version_id_from
995: and xbs.sub_id=p_wbs_version_id_from;
996: --write_log('inert of PRG line done 1');

Line 1042: PA_XBS_DENORM den

1038: l_creation_date,
1039: l_created_by,
1040: l_last_update_login
1041: from
1042: PA_XBS_DENORM den
1043: where den.struct_version_id is null
1044: and den.sup_id=p_wbs_version_id_to
1045: and den.sub_id=p_wbs_version_id_to;
1046:

Line 1065: from pa_xbs_denorm xbs,

1061: xbs.sup_level,xbs.sub_level,
1062: xbs.relationship_type,xbs.sub_leaf_flag,
1063: xbs.struct_emt_id,xbs.sub_rollup_id,
1064: xbs.subro_id
1065: from pa_xbs_denorm xbs,
1066: PA_PROJ_ELEMENT_VERSIONS projsup
1067: where projsup.parent_structure_version_id= p_wbs_version_id_to
1068: and projsup.proj_element_id= xbs.sup_emt_id
1069: and xbs.struct_version_id= p_wbs_version_id_from;

Line 1109: insert into PA_XBS_DENORM(

1105: ,sub_rollup_idtab
1106: ,subro_idtab ;
1107: IF struct_typetab.COUNT <>0 then
1108: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
1109: insert into PA_XBS_DENORM(
1110: struct_type
1111: ,prg_group
1112: ,struct_version_id
1113: ,sup_project_id

Line 1155: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/

1151: ,l_last_update_login
1152: );
1153: END IF;
1154: /* The below insert replaces the call to Pji_Pjp_Sum_Rollup.update_xbs_denorm
1155: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/
1156: IF struct_typetab.COUNT <>0 then
1157: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
1158: insert into PJI_XBS_DENORM(
1159: struct_type

Line 1208: into PA_XBS_DENORM

1204: -- write_log('insert bulk into xbs_Denorm done 1');
1205: end;
1206: /* inserting the PRG lines*/
1207: insert
1208: into PA_XBS_DENORM
1209: (
1210: struct_type,
1211: prg_group,
1212: struct_version_id,

Line 1241: from PA_XBS_DENORM xbs

1237: xbs.struct_emt_id,to_number(p_wbs_version_id_to) wsup_id,
1238: to_number(p_wbs_version_id_to) wsub_id,l_last_update_date,
1239: l_last_updated_by,l_creation_date,
1240: l_created_by ,l_last_update_login
1241: from PA_XBS_DENORM xbs
1242: where xbs.struct_version_id is null
1243: and xbs.sup_id=p_wbs_version_id_from
1244: and xbs.sub_id=p_wbs_version_id_from;
1245:

Line 1289: PA_XBS_DENORM den

1285: l_creation_date,
1286: l_created_by,
1287: l_last_update_login
1288: from
1289: PA_XBS_DENORM den
1290: where den.struct_version_id is null
1291: and den.sup_id=p_wbs_version_id_to
1292: and den.sub_id=p_wbs_version_id_to;
1293: end if;

Line 5313: -- (PJI_FP_AGGR_XBS) to the actual denorm table (PA_XBS_DENORM)

5309: -- 19-MAR-2004 aartola Created
5310: --
5311: --
5312: -- *** This procedure merges data from the denorm interim table
5313: -- (PJI_FP_AGGR_XBS) to the actual denorm table (PA_XBS_DENORM)
5314: --
5315: -- After calling this procedure, the contents of the interim table
5316: -- need to be deleted.
5317: --

Line 5362: into PA_XBS_DENORM

5358:
5359: then
5360:
5361: insert
5362: into PA_XBS_DENORM
5363: (
5364: struct_type,
5365: prg_group,
5366: struct_emt_id,

Line 5408: PA_XBS_DENORM denorm

5404: l_creation_date,
5405: l_created_by,
5406: l_last_update_login
5407: from PJI_FP_AGGR_XBS interim,
5408: PA_XBS_DENORM denorm
5409: where 1=1
5410: and interim.worker_id = p_worker_id
5411: and nvl(interim.struct_type, -1) = nvl(denorm.struct_type (+), -1)
5412: and nvl(interim.prg_group, -1) = nvl(denorm.prg_group (+), -1)

Line 5439: into PA_XBS_DENORM

5435:
5436: then
5437:
5438: insert
5439: into PA_XBS_DENORM
5440: (
5441: struct_type,
5442: prg_group,
5443: struct_emt_id,

Line 5496: into PA_XBS_DENORM

5492:
5493: else -- UPGRADE, PARTIAL, INCREMENTAL
5494:
5495: insert
5496: into PA_XBS_DENORM
5497: (
5498: struct_type,
5499: prg_group,
5500: struct_emt_id,