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_REP_UTIL dependencies on PJI_REP_XBS_DENORM

Line 54: delete from pji_rep_xbs_denorm where project_id = p_project_id ;

50: delete from pa_olap_xbs_denorm_TMP ;
51:
52: delete from pa_olap_wbs_header;
53:
54: delete from pji_rep_xbs_denorm where project_id = p_project_id ;
55:
56: insert into pa_olap_xbs_denorm_TMP (
57: STRUCT_TYPE,PRG_GROUP,STRUCT_VERSION_ID,SUP_PROJECT_ID,SUP_ID,SUP_EMT_ID,SUBRO_ID,SUB_ID,
58: SUB_EMT_ID,SUP_LEVEL,SUB_LEVEL,SUB_ROLLUP_ID,SUB_LEAF_FLAG,

Line 114: INSERT INTO pji_rep_xbs_denorm

110: select proj_element_id into p_elem_id from pa_proj_element_versions
111: where element_version_id = t_element_version_id;
112:
113:
114: INSERT INTO pji_rep_xbs_denorm
115: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
116: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
117: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
118: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 128: INSERT INTO pji_rep_xbs_denorm

124: WHERE 1=1
125: AND struct_ver.project_id = p_project_id
126: AND struct_ver.element_version_id = t_element_version_id;
127:
128: INSERT INTO pji_rep_xbs_denorm
129: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
130: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
131: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
132: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 142: INSERT INTO pji_rep_xbs_denorm

138: WHERE 1=1
139: AND struct_ver.project_id = p_project_id
140: AND struct_ver.element_version_id = t_element_version_id;
141:
142: INSERT INTO pji_rep_xbs_denorm
143: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
144: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
145: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
146: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 377: FROM pji_rep_xbs_denorm

373: -- OLAP END
374:
375: SELECT COUNT(*)
376: INTO l_count
377: FROM pji_rep_xbs_denorm
378: WHERE sup_project_id = p_project_id
379: AND prg_flag = p_prg_flag
380: AND wbs_version_id = p_element_version_id
381: AND ROWNUM=1;

Line 489: DELETE FROM pji_rep_xbs_denorm

485: -- OLAP ENDS
486:
487: IF (l_update_flag) THEN
488:
489: DELETE FROM pji_rep_xbs_denorm
490: WHERE wbs_version_id = p_element_version_id
491: AND prg_flag = p_prg_flag;
492:
493: END IF;

Line 502: INSERT INTO pji_rep_xbs_denorm

498: /*
499: ** for initial structure information, get the structure record and change its
500: ** parent to -1, so that -1 is a unique parent which has only one child
501: */
502: INSERT INTO pji_rep_xbs_denorm
503: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
504: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
505: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
506: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 519: INSERT INTO pji_rep_xbs_denorm

515:
516: /*
517: ** Insert the self node for this project
518: */
519: INSERT INTO pji_rep_xbs_denorm
520: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
521: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
522: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
523: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 538: INSERT INTO pji_rep_xbs_denorm

534:
535: /*
536: ** for wbs structure information
537: */
538: INSERT INTO pji_rep_xbs_denorm
539: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
540: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
541: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
542: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 559: INSERT INTO pji_rep_xbs_denorm

555: AND ver.parent_structure_version_id = p_element_version_id
556: AND ver.object_type = 'PA_TASKS'
557: AND ver.proj_element_id = denorm.sub_emt_id;
558:
559: INSERT INTO pji_rep_xbs_denorm
560: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
561: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
562: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
563: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 622: INSERT INTO pji_rep_xbs_denorm

618: /*
619: ** Insert the virtual Header
620: */
621:
622: INSERT INTO pji_rep_xbs_denorm
623: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
624: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
625: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
626: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 654: INSERT INTO pji_rep_xbs_denorm

650:
651: /*
652: ** Insert the project level self amount
653: */
654: INSERT INTO pji_rep_xbs_denorm
655: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
656: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
657: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
658: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 691: INSERT INTO pji_rep_xbs_denorm

687:
688: /*
689: ** Insert wbs information inside each structure
690: */
691: INSERT INTO pji_rep_xbs_denorm
692: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
693: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
694: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
695: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 739: INSERT INTO pji_rep_xbs_denorm

735: /*
736: ** Insert the link between structure and the top level elements
737: */
738:
739: INSERT INTO pji_rep_xbs_denorm
740: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
741: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
742: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
743: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 787: INSERT INTO pji_rep_xbs_denorm

783:
784: /*
785: * Insert link from project to project
786: */
787: INSERT INTO pji_rep_xbs_denorm
788: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
789: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
790: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
791: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 833: UPDATE pji_rep_xbs_denorm

829: /*
830: * set rollup flag for elements have links to other projects
831: */
832:
833: UPDATE pji_rep_xbs_denorm
834: SET display_child_flag = 'Y'
835: WHERE rollup_flag = 'Y'
836: AND sup_project_id = p_project_id
837: AND prg_flag = 'Y'