[Home] [Help]
385: This is a wrapper API which does the consistency check
386: for program in workplan context.
387: */
388: PROCEDURE CHECK_WP_PARAM_CONSISTENCY
389: ( p_project_id IN pa_projects_all.project_id%TYPE
390: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
391: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
392: ,p_published_flag IN VARCHAR2
393: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
390: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
391: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
392: ,p_published_flag IN VARCHAR2
393: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
394: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
395: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
396: ,x_pc_flag OUT NOCOPY VARCHAR2
397: ,x_pfc_flag OUT NOCOPY VARCHAR2
398: ,x_margin_flag OUT NOCOPY VARCHAR2
407: check if all the projects in the program hierarchy contain
408: the same project and project functional currency.
409: */
410: PROCEDURE CHECK_WP_CURRENCY_CONSISTENCY
411: ( p_project_id IN pa_projects_all.project_id%TYPE
412: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
413: ,x_pc_flag OUT NOCOPY VARCHAR2
414: ,x_pfc_flag OUT NOCOPY VARCHAR2
415: ,x_return_status OUT NOCOPY VARCHAR2
420: check if all the linked structure versions in the
421: program hierarchy have the same margin mask.
422: */
423: PROCEDURE CHECK_WP_MARGIN_CONSISTENCY
424: ( p_project_id IN pa_projects_all.project_id%TYPE
425: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
426: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
427: ,x_margin_flag OUT NOCOPY VARCHAR2
428: ,x_return_status OUT NOCOPY VARCHAR2
433: check if all the structure versions in the program hierarchy
434: have the same status. ie published/not published.
435: */
436: PROCEDURE CHECK_WP_STATUS_CONSISTENCY
437: ( p_project_id IN pa_projects_all.project_id%TYPE
438: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
439: ,p_published_flag IN VARCHAR2
440: ,x_workpub_flag OUT NOCOPY VARCHAR2
441: ,x_return_status OUT NOCOPY VARCHAR2
446: check if all the structure versions in the program hierarchy have
447: same time phasing.
448: */
449: PROCEDURE CHECK_WP_TIME_CONSISTENCY
450: ( p_project_id IN pa_projects_all.project_id%TYPE
451: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
452: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
453: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
454: ,x_time_phase_flag OUT NOCOPY VARCHAR2
449: PROCEDURE CHECK_WP_TIME_CONSISTENCY
450: ( p_project_id IN pa_projects_all.project_id%TYPE
451: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
452: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
453: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
454: ,x_time_phase_flag OUT NOCOPY VARCHAR2
455: ,x_return_status OUT NOCOPY VARCHAR2
456: ,x_msg_count OUT NOCOPY NUMBER
457: ,x_msg_data OUT NOCOPY VARCHAR2);
460: check if all the structure versions in the program hierarchy have
461: the same RBS.
462: */
463: PROCEDURE CHECK_WP_RBS_CONSISTENCY
464: ( p_project_id IN pa_projects_all.project_id%TYPE
465: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
466: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
467: ,x_rbs_flag OUT NOCOPY VARCHAR2
468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_msg_count OUT NOCOPY NUMBER
470: ,x_msg_data OUT NOCOPY VARCHAR2);
471:
472: FUNCTION GET_WP_BASELINED_PLAN_VERSION
473: ( p_project_id IN pa_projects_all.project_id%TYPE)
474: RETURN NUMBER;
475:
476: FUNCTION GET_WP_LATEST_VERSION
477: ( p_project_id IN pa_projects_all.project_id%TYPE)
473: ( p_project_id IN pa_projects_all.project_id%TYPE)
474: RETURN NUMBER;
475:
476: FUNCTION GET_WP_LATEST_VERSION
477: ( p_project_id IN pa_projects_all.project_id%TYPE)
478: RETURN NUMBER;
479:
480: FUNCTION GET_DEFAULT_EXPANSION_LEVEL
481: ( p_project_id IN pa_projects_all.project_id%TYPE
477: ( p_project_id IN pa_projects_all.project_id%TYPE)
478: RETURN NUMBER;
479:
480: FUNCTION GET_DEFAULT_EXPANSION_LEVEL
481: ( p_project_id IN pa_projects_all.project_id%TYPE
482: ,p_object_type IN VARCHAR2) -- Task/Resource indicated by 'T' or 'R'
483: RETURN NUMBER;
484:
485: /* Gets all the default plan type ids for a give project */
529: * have the same GL or same PA calendar or not. If GL calendar is same then x_gl_flag
530: * will return 'T' else 'F'. This logic is true for PA calendar also.
531: */
532: PROCEDURE Check_Perf_Cal_Consistency(
533: p_project_id IN pa_projects_all.project_id%TYPE
534: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
535: ,x_gl_flag OUT NOCOPY VARCHAR2
536: ,x_pa_flag OUT NOCOPY VARCHAR2
537: ,x_return_status OUT NOCOPY VARCHAR2
543: * have the same Project Functional Currency (PFC) or not. If PFC is same then x_pfc_flag
544: * will return 'T' else 'F'.
545: */
546: PROCEDURE Check_Perf_Curr_Consistency(
547: p_project_id IN pa_projects_all.project_id%TYPE
548: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
549: ,x_pfc_flag OUT NOCOPY VARCHAR2
550: ,x_return_status OUT NOCOPY VARCHAR2
551: ,x_msg_count OUT NOCOPY NUMBER
603: x_return_status OUT NOCOPY VARCHAR2);
604:
605:
606: PROCEDURE GET_PROCESS_STATUS_MSG(
607: p_project_id IN pa_projects_all.project_id%TYPE
608: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
609: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
610: , p_prg_flag IN VARCHAR2 := NULL
611: , x_message_name OUT NOCOPY VARCHAR2