[Home] [Help]
PACKAGE: APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG
Source
1 PACKAGE Pa_Fp_Control_Items_Impact_Pkg AUTHID CURRENT_USER AS
2 /* $Header: PAFPCIIS.pls 120.1 2005/08/19 16:24:44 mwasowic noship $ */
3 PROCEDURE Maintain_Ctrl_Item_Version
4 (
5 p_project_id IN Pa_Projects_All.Project_Id%TYPE,
6 p_ci_id IN NUMBER,
7 p_fp_pref_code IN VARCHAR2,
8 p_fin_plan_type_id_cost IN NUMBER,
9 p_fin_plan_type_id_rev IN NUMBER,
10 p_fin_plan_type_id_all IN NUMBER,
11 p_est_proj_raw_cost IN NUMBER,
12 p_est_proj_bd_cost IN NUMBER,
13 p_est_proj_revenue IN NUMBER,
14 p_est_qty IN NUMBER,
15 p_est_equip_qty IN NUMBER, -- FP.M
16 p_button_pressed_from_page IN VARCHAR2 DEFAULT 'NONE',
17 p_impacted_task_id IN NUMBER,
18 p_agreement_id IN NUMBER DEFAULT NULL,
19 p_agreement_number IN VARCHAR2 DEFAULT NULL,
20 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23 x_plan_version_id OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
24 PROCEDURE Maintain_Plan_Version
25 (
26 p_project_id IN Pa_Projects_All.Project_Id%TYPE,
27 p_ci_id IN NUMBER,
28 p_fp_pref_code IN VARCHAR2,
29 p_fin_plan_type_id IN NUMBER,
30 p_est_proj_raw_cost IN NUMBER,
31 p_est_proj_bd_cost IN NUMBER,
32 p_est_proj_revenue IN NUMBER,
33 p_est_qty IN NUMBER,
34 p_est_equip_qty IN NUMBER, -- FP.M
35 p_project_currency_Code IN VARCHAR2,
36 p_projfunc_currency_code IN VARCHAR2,
37 p_element_type IN VARCHAR2,
38 p_impacted_task_id IN NUMBER,
39 p_agreement_id IN NUMBER DEFAULT NULL,
40 p_agreement_number IN VARCHAR2 DEFAULT NULL,
41 p_baseline_funding_flag IN VARCHAR2 DEFAULT NULL,
42 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
45 x_plan_version_id OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
46
47
48 PROCEDURE delete_ci_plan_versions
49 (
50 p_project_id IN NUMBER,
51 p_ci_id IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT 'N' ,
53 p_commit_flag IN VARCHAR2 DEFAULT 'N',
54 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
57
58 END Pa_Fp_Control_Items_Impact_Pkg;