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.

[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PJI_REP_XBS_DENORM

Line 177: FROM pji_rep_xbs_denorm

173:
174:
175: SELECT COUNT(*)
176: INTO l_count
177: FROM pji_rep_xbs_denorm
178: WHERE sup_project_id = p_project_id
179: AND prg_flag = p_prg_flag
180: AND wbs_version_id = p_element_version_id
181: AND ROWNUM=1;

Line 206: DELETE FROM pji_rep_xbs_denorm

202: IF (l_count=0) OR l_update_flag THEN
203:
204: IF (l_update_flag) THEN
205:
206: DELETE FROM pji_rep_xbs_denorm
207: WHERE wbs_version_id = p_element_version_id
208: AND prg_flag = p_prg_flag;
209:
210: END IF;

Line 219: INSERT INTO pji_rep_xbs_denorm

215: /*
216: ** for initial structure information, get the structure record and change its
217: ** parent to -1, so that -1 is a unique parent which has only one child
218: */
219: INSERT INTO pji_rep_xbs_denorm
220: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
221: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
222: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
223: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 236: INSERT INTO pji_rep_xbs_denorm

232:
233: /*
234: ** Insert the self node for this project
235: */
236: INSERT INTO pji_rep_xbs_denorm
237: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
238: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
239: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
240: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 253: INSERT INTO pji_rep_xbs_denorm

249:
250: /*
251: ** for wbs structure information
252: */
253: INSERT INTO pji_rep_xbs_denorm
254: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
255: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
256: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
257: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 274: INSERT INTO pji_rep_xbs_denorm

270: AND ver.parent_structure_version_id = p_element_version_id
271: AND ver.object_type = 'PA_TASKS'
272: AND ver.proj_element_id = denorm.sub_emt_id;
273:
274: INSERT INTO pji_rep_xbs_denorm
275: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
276: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
277: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
278: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 333: INSERT INTO pji_rep_xbs_denorm

329: /*
330: ** Insert the virtual Header
331: */
332:
333: INSERT INTO pji_rep_xbs_denorm
334: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
335: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
336: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
337: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 365: INSERT INTO pji_rep_xbs_denorm

361:
362: /*
363: ** Insert the project level self amount
364: */
365: INSERT INTO pji_rep_xbs_denorm
366: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
367: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
368: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
369: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 402: INSERT INTO pji_rep_xbs_denorm

398:
399: /*
400: ** Insert wbs information inside each structure
401: */
402: INSERT INTO pji_rep_xbs_denorm
403: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
404: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
405: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
406: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 450: INSERT INTO pji_rep_xbs_denorm

446: /*
447: ** Insert the link between structure and the top level elements
448: */
449:
450: INSERT INTO pji_rep_xbs_denorm
451: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
452: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
453: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
454: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 498: INSERT INTO pji_rep_xbs_denorm

494:
495: /*
496: * Insert link from project to project
497: */
498: INSERT INTO pji_rep_xbs_denorm
499: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,
500: CHILD_ELEMENT_ID, PRG_FLAG, NAME, ROLLUP_FLAG, DISPLAY_CHILD_FLAG,
501: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY,
502: LAST_UPDATE_LOGIN, WBS_VERSION_ID,DISPLAY_SEQUENCE,OWNER_WBS_VERSION_ID,RELATIONSHIP_TYPE)

Line 544: UPDATE pji_rep_xbs_denorm

540: /*
541: * set rollup flag for elements have links to other projects
542: */
543:
544: UPDATE pji_rep_xbs_denorm
545: SET display_child_flag = 'Y'
546: WHERE rollup_flag = 'Y'
547: AND sup_project_id = p_project_id
548: AND prg_flag = 'Y'