1 PACKAGE gms_budget_core AUTHID CURRENT_USER AS
2 -- $Header: gmsbubcs.pls 115.6 2002/11/28 08:06:03 srkotwal ship $
3
4 g_project_start_date date;
5
6 procedure baseline (x_draft_version_id in number,
7 x_mark_as_original in varchar2,
8 x_verify_budget_rules in varchar2 default 'Y',
9 x_err_code in out NOCOPY number,
10 x_err_stage in out NOCOPY varchar2,
11 x_err_stack in out NOCOPY varchar2);
12
13 procedure copy (x_src_version_id in number,
14 x_amount_change_pct in number,
15 x_rounding_precision in number,
16 x_shift_days in number,
17 x_dest_project_id in number,
18 x_dest_award_id in number,
19 x_dest_budget_type_code in varchar2,
20 x_err_code in out NOCOPY number,
21 x_err_stage in out NOCOPY varchar2,
22 x_err_stack in out NOCOPY varchar2);
23
24 procedure verify (x_budget_version_id in number,
25 x_err_code in out NOCOPY number,
26 x_err_stage in out NOCOPY varchar2,
27 x_err_stack in out NOCOPY varchar2);
28
29 procedure copy_lines (x_src_version_id in number,
30 x_amount_change_pct in number,
31 x_rounding_precision in number,
32 x_shift_days in number,
33 x_dest_version_id in number,
34 x_err_code in out NOCOPY number,
35 x_err_stage in out NOCOPY varchar2,
36 x_err_stack in out NOCOPY varchar2,
37 x_pm_flag in varchar2 default 'N') ;
38 PROCEDURE start_end_period (
39 x_project_id IN NUMBER,
40 x_award_id IN NUMBER,
41 x_version_id IN NUMBER,
42 x_current_budget_version_id IN NUMBER,
43 x_budget_entry_method_code IN VARCHAR2,
44 x_time_phase_type_code IN VARCHAR2,
45 x_resource_list_id IN NUMBER,
46 x_resource_list_name IN VARCHAR2,
47 x_start_period_name OUT NOCOPY VARCHAR2,
48 x_start_date IN OUT NOCOPY DATE,
49 x_end_period_name OUT NOCOPY VARCHAR2,
50 x_end_date IN OUT NOCOPY DATE,
51 x_err_code IN OUT NOCOPY NUMBER,
52 x_err_stage IN OUT NOCOPY VARCHAR2,
53 x_err_stack IN OUT NOCOPY VARCHAR2
54 );
55
56 procedure copy_actual (x_project_id in number,
57 x_award_id in number,
58 x_version_id in number,
59 x_budget_entry_method_code in varchar2,
60 x_resource_list_id in number,
61 x_start_period in varchar2,
62 x_end_period in varchar2,
63 x_err_code in out NOCOPY number,
64 x_err_stage in out NOCOPY varchar2,
65 x_err_stack in out NOCOPY varchar2,
66 x_funding_status out NOCOPY number); -- Bug 1831151
67 PROCEDURE get_proj_txn_accum (
68 x_project_id IN NUMBER,
69 x_task_id IN NUMBER DEFAULT NULL,
70 x_current_budget_version_id IN NUMBER,
71 x_period_type IN VARCHAR2 DEFAULT 'P',
72 x_from_period_name IN VARCHAR2 DEFAULT NULL,
73 x_prd_start_date IN DATE DEFAULT NULL,
74 x_prd_end_date IN DATE DEFAULT NULL,
75 x_burdened_cost IN OUT NOCOPY NUMBER,
76 x_billable_burdened_cost IN OUT NOCOPY NUMBER,
77 x_unit_of_measure IN OUT NOCOPY VARCHAR2,
78 x_err_stage IN OUT NOCOPY VARCHAR2,
79 x_err_code IN OUT NOCOPY NUMBER
80 );
81
82 PROCEDURE get_proj_res_accum (
83 x_project_id IN NUMBER,
84 x_task_id IN NUMBER DEFAULT NULL,
85 x_current_budget_version_id IN NUMBER,
86 x_resource_list_member_id IN NUMBER DEFAULT NULL,
87 x_period_type IN VARCHAR2 DEFAULT 'P',
88 x_from_period_name IN VARCHAR2 DEFAULT NULL,
89 x_prd_start_date IN DATE DEFAULT NULL,
90 x_prd_end_date IN DATE DEFAULT NULL,
91 x_burdened_cost IN OUT NOCOPY NUMBER,
92 x_billable_burdened_cost IN OUT NOCOPY NUMBER,
93 x_unit_of_measure IN OUT NOCOPY VARCHAR2,
94 x_err_stage IN OUT NOCOPY VARCHAR2,
95 x_err_code IN OUT NOCOPY NUMBER
96 );
97
98 PROCEDURE get_proj_accum_actuals (
99 x_project_id IN NUMBER,
100 x_task_id IN NUMBER DEFAULT NULL,
101 x_current_budget_version_id IN NUMBER,
102 x_resource_list_member_id IN NUMBER DEFAULT NULL,
103 x_period_type IN VARCHAR2 DEFAULT 'P',
104 x_from_period_name IN VARCHAR2 DEFAULT NULL,
105 x_prd_start_date IN DATE DEFAULT NULL,
106 x_prd_end_date IN DATE DEFAULT NULL,
107 x_burdened_cost IN OUT NOCOPY NUMBER,
108 x_billable_burdened_cost IN OUT NOCOPY NUMBER,
109 x_unit_of_measure IN OUT NOCOPY VARCHAR2,
110 x_err_stage IN OUT NOCOPY VARCHAR2,
111 x_err_code IN OUT NOCOPY NUMBER
112 );
113
114
115 procedure copy_draft_lines (x_src_version_id in number,
116 x_time_phased_type_code in varchar2,
117 x_entry_level_code in varchar2,
118 x_dest_version_id in number,
119 x_err_code in out NOCOPY number,
120 x_err_stage in out NOCOPY varchar2,
121 x_err_stack in out NOCOPY varchar2,
122 x_pm_flag in varchar2 );
123
124
125 END gms_budget_core;