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 PA_PROJECTS_ALL

Line 409: ( p_project_id IN pa_projects_all.project_id%TYPE

405: This is a wrapper API which does the consistency check
406: for program in workplan context.
407: */
408: PROCEDURE CHECK_WP_PARAM_CONSISTENCY
409: ( p_project_id IN pa_projects_all.project_id%TYPE
410: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
411: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
412: ,p_published_flag IN VARCHAR2
413: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE

Line 414: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE

410: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
411: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
412: ,p_published_flag IN VARCHAR2
413: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
414: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
415: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
416: ,x_pc_flag OUT NOCOPY VARCHAR2
417: ,x_pfc_flag OUT NOCOPY VARCHAR2
418: ,x_margin_flag OUT NOCOPY VARCHAR2

Line 431: ( p_project_id IN pa_projects_all.project_id%TYPE

427: check if all the projects in the program hierarchy contain
428: the same project and project functional currency.
429: */
430: PROCEDURE CHECK_WP_CURRENCY_CONSISTENCY
431: ( p_project_id IN pa_projects_all.project_id%TYPE
432: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
433: ,x_pc_flag OUT NOCOPY VARCHAR2
434: ,x_pfc_flag OUT NOCOPY VARCHAR2
435: ,x_return_status OUT NOCOPY VARCHAR2

Line 444: ( p_project_id IN pa_projects_all.project_id%TYPE

440: check if all the linked structure versions in the
441: program hierarchy have the same margin mask.
442: */
443: PROCEDURE CHECK_WP_MARGIN_CONSISTENCY
444: ( p_project_id IN pa_projects_all.project_id%TYPE
445: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
446: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
447: ,x_margin_flag OUT NOCOPY VARCHAR2
448: ,x_return_status OUT NOCOPY VARCHAR2

Line 457: ( p_project_id IN pa_projects_all.project_id%TYPE

453: check if all the structure versions in the program hierarchy
454: have the same status. ie published/not published.
455: */
456: PROCEDURE CHECK_WP_STATUS_CONSISTENCY
457: ( p_project_id IN pa_projects_all.project_id%TYPE
458: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
459: ,p_published_flag IN VARCHAR2
460: ,x_workpub_flag OUT NOCOPY VARCHAR2
461: ,x_return_status OUT NOCOPY VARCHAR2

Line 470: ( p_project_id IN pa_projects_all.project_id%TYPE

466: check if all the structure versions in the program hierarchy have
467: same time phasing.
468: */
469: PROCEDURE CHECK_WP_TIME_CONSISTENCY
470: ( p_project_id IN pa_projects_all.project_id%TYPE
471: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
472: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
473: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
474: ,x_time_phase_flag OUT NOCOPY VARCHAR2

Line 473: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE

469: PROCEDURE CHECK_WP_TIME_CONSISTENCY
470: ( p_project_id IN pa_projects_all.project_id%TYPE
471: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
472: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
473: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
474: ,x_time_phase_flag OUT NOCOPY VARCHAR2
475: ,x_return_status OUT NOCOPY VARCHAR2
476: ,x_msg_count OUT NOCOPY NUMBER
477: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 484: ( p_project_id IN pa_projects_all.project_id%TYPE

480: check if all the structure versions in the program hierarchy have
481: the same RBS.
482: */
483: PROCEDURE CHECK_WP_RBS_CONSISTENCY
484: ( p_project_id IN pa_projects_all.project_id%TYPE
485: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
486: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
487: ,x_rbs_flag OUT NOCOPY VARCHAR2
488: ,x_return_status OUT NOCOPY VARCHAR2

Line 493: ( p_project_id IN pa_projects_all.project_id%TYPE)

489: ,x_msg_count OUT NOCOPY NUMBER
490: ,x_msg_data OUT NOCOPY VARCHAR2);
491:
492: FUNCTION GET_WP_BASELINED_PLAN_VERSION
493: ( p_project_id IN pa_projects_all.project_id%TYPE)
494: RETURN NUMBER;
495:
496: FUNCTION GET_WP_LATEST_VERSION
497: ( p_project_id IN pa_projects_all.project_id%TYPE)

Line 497: ( p_project_id IN pa_projects_all.project_id%TYPE)

493: ( p_project_id IN pa_projects_all.project_id%TYPE)
494: RETURN NUMBER;
495:
496: FUNCTION GET_WP_LATEST_VERSION
497: ( p_project_id IN pa_projects_all.project_id%TYPE)
498: RETURN NUMBER;
499:
500: FUNCTION GET_DEFAULT_EXPANSION_LEVEL
501: ( p_project_id IN pa_projects_all.project_id%TYPE

Line 501: ( p_project_id IN pa_projects_all.project_id%TYPE

497: ( p_project_id IN pa_projects_all.project_id%TYPE)
498: RETURN NUMBER;
499:
500: FUNCTION GET_DEFAULT_EXPANSION_LEVEL
501: ( p_project_id IN pa_projects_all.project_id%TYPE
502: ,p_object_type IN VARCHAR2) -- Task/Resource indicated by 'T' or 'R'
503: RETURN NUMBER;
504:
505: /* Gets all the default plan type ids for a give project */

Line 553: p_project_id IN pa_projects_all.project_id%TYPE

549: * have the same GL or same PA calendar or not. If GL calendar is same then x_gl_flag
550: * will return 'T' else 'F'. This logic is true for PA calendar also.
551: */
552: PROCEDURE Check_Perf_Cal_Consistency(
553: p_project_id IN pa_projects_all.project_id%TYPE
554: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
555: ,x_gl_flag OUT NOCOPY VARCHAR2
556: ,x_pa_flag OUT NOCOPY VARCHAR2
557: ,x_return_status OUT NOCOPY VARCHAR2

Line 567: p_project_id IN pa_projects_all.project_id%TYPE

563: * have the same Project Functional Currency (PFC) or not. If PFC is same then x_pfc_flag
564: * will return 'T' else 'F'.
565: */
566: PROCEDURE Check_Perf_Curr_Consistency(
567: p_project_id IN pa_projects_all.project_id%TYPE
568: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
569: ,x_pfc_flag OUT NOCOPY VARCHAR2
570: ,x_return_status OUT NOCOPY VARCHAR2
571: ,x_msg_count OUT NOCOPY NUMBER

Line 627: p_project_id IN pa_projects_all.project_id%TYPE

623: x_return_status OUT NOCOPY VARCHAR2);
624:
625:
626: PROCEDURE GET_PROCESS_STATUS_MSG(
627: p_project_id IN pa_projects_all.project_id%TYPE
628: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
629: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
630: , p_prg_flag IN VARCHAR2 := NULL
631: , x_message_name OUT NOCOPY VARCHAR2