APPS.PJI_REP_UTIL dependencies on PJI_XBS_DENORM

Line 410: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
414: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE

Line 432: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
436: ,x_msg_count OUT NOCOPY NUMBER

Line 445: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
449: ,x_msg_count OUT NOCOPY NUMBER

Line 458: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
462: ,x_msg_count OUT NOCOPY NUMBER

Line 471: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
475: ,x_return_status OUT NOCOPY VARCHAR2

Line 485: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
489: ,x_msg_count OUT NOCOPY NUMBER

Line 554: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
558: ,x_msg_count OUT NOCOPY NUMBER

Line 568: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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
572: ,x_msg_data OUT NOCOPY VARCHAR2);