49:
50:
51: PROCEDURE FP_CI_UPDATE_IMPACT
52: (
53: p_ci_id IN pa_ci_impacts.ci_id%TYPE DEFAULT NULL,
54: p_status_code IN pa_ci_impacts.status_code%TYPE DEFAULT NULL,
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
50:
51: PROCEDURE FP_CI_UPDATE_IMPACT
52: (
53: p_ci_id IN pa_ci_impacts.ci_id%TYPE DEFAULT NULL,
54: p_status_code IN pa_ci_impacts.status_code%TYPE DEFAULT NULL,
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
58: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE DEFAULT NULL,
51: PROCEDURE FP_CI_UPDATE_IMPACT
52: (
53: p_ci_id IN pa_ci_impacts.ci_id%TYPE DEFAULT NULL,
54: p_status_code IN pa_ci_impacts.status_code%TYPE DEFAULT NULL,
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
58: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE DEFAULT NULL,
59: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,--For bug 3550073
52: (
53: p_ci_id IN pa_ci_impacts.ci_id%TYPE DEFAULT NULL,
54: p_status_code IN pa_ci_impacts.status_code%TYPE DEFAULT NULL,
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
58: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE DEFAULT NULL,
59: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,--For bug 3550073
60: p_commit_flag IN VARCHAR2 DEFAULT 'N',
53: p_ci_id IN pa_ci_impacts.ci_id%TYPE DEFAULT NULL,
54: p_status_code IN pa_ci_impacts.status_code%TYPE DEFAULT NULL,
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
58: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE DEFAULT NULL,
59: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,--For bug 3550073
60: p_commit_flag IN VARCHAR2 DEFAULT 'N',
61: p_init_msg_list IN VARCHAR2 DEFAULT 'N',
54: p_status_code IN pa_ci_impacts.status_code%TYPE DEFAULT NULL,
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
58: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE DEFAULT NULL,
59: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,--For bug 3550073
60: p_commit_flag IN VARCHAR2 DEFAULT 'N',
61: p_init_msg_list IN VARCHAR2 DEFAULT 'N',
62: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE DEFAULT NULL,
56: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE DEFAULT NULL,
57: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE DEFAULT NULL,
58: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE DEFAULT NULL,
59: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,--For bug 3550073
60: p_commit_flag IN VARCHAR2 DEFAULT 'N',
61: p_init_msg_list IN VARCHAR2 DEFAULT 'N',
62: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
90:
91: PROCEDURE FP_CI_MANUAL_MERGE
92: (
93: p_project_id IN NUMBER,
94: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,