APPS.PJI_REP_UTIL dependencies on PJI_XBS_DENORM

Line 390: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 412: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 425: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 438: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 451: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 465: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 534: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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

Line 548: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

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