1 package pa_budget_core1 as
2 -- $Header: PAXBUBDS.pls 120.3.12010000.3 2008/09/29 14:21:49 bifernan ship $
3
4 procedure copy_actual (x_project_id in number,
5 x_version_id in number,
6 x_budget_entry_method_code in varchar2,
7 x_resource_list_id in number,
8 x_start_period in varchar2,
9 x_end_period in varchar2,
10 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
11 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
12 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
13
14 procedure copy_draft_lines (x_src_version_id in number,
15 x_time_phased_type_code in varchar2,
16 x_entry_level_code in varchar2,
17 x_dest_version_id in number,
18 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
19 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
20 x_err_stack in out NOCOPY varchar2, --File.Sql.39 bug 4440895
21 x_pm_flag in varchar2 );
22
23 -- added for bug 4390421
24 -- This function is wrapper over pa_accum_utils.get_first_accum_period
25 -- It will be used in the value set to get the first accumulation period
26 -- for a project
27 function get_first_accum_period ( x_project_id in number,
28 x_budget_type_code in varchar2)
29 return date;
30
31 -- Global variables addded to tackle performance issue at the time of
32 -- calling function get_first_accum_period from value set.
33 g_project_id pa_projects_all.project_id%type;
34 g_budget_type_code pa_budget_versions.budget_type_code%type;
35 g_start_period_date pa_periods_all.start_date%type;
36 g_calling_mode varchar2(100) default 'FORM';
37
38 -- Wrapper procedure for copy_actual called from concurrent request
39 procedure copy_actuals1 (errbuf IN OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
40 retcode IN OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
41 x_project_id in number,
42 x_budget_type_code in varchar2,
43 x_start_period in varchar2,
44 x_end_period in varchar2);
45
46 -- added for bug 4390421
47
48 -- Record Type added for Bug 4889056
49 TYPE CopyActualRecord IS RECORD (period_name pa_periods_all.period_name%type,
50 Start_Date DATE,
51 End_Date DATE,
52 task_id NUMBER,
53 resource_list_member_id NUMBER,
54 resource_id NUMBER,
55 track_as_labor_flag pa_resources.track_as_labor_flag%type,
56 Revenue NUMBER,
57 Raw_Cost NUMBER,
58 Burdened_Cost NUMBER,
59 Quantity NUMBER,
60 labor_hours NUMBER,
61 billable_raw_cost NUMBER,
62 billable_burdened_cost NUMBER,
63 billable_quantity NUMBER,
64 billable_labor_hours NUMBER,
65 cmt_raw_cost NUMBER,
66 cmt_burdened_cost NUMBER,
67 unit_of_measure pa_resources.unit_of_measure%type);
68
69
70 TYPE CopyActualTabTyp IS TABLE OF CopyActualRecord INDEX BY BINARY_INTEGER;
71 -- End Record Type added for Bug 4889056
72
73 -- Start for bug 6509313
74 PROCEDURE rollup_amounts_rg(
75 X_Resource_Assignment_Id IN OUT NOCOPY NUMBER,
76 X_Budget_Version_Id NUMBER,
77 X_Project_Id NUMBER,
78 X_Task_Id NUMBER,
79 X_Resource_List_Member_Id IN OUT NOCOPY NUMBER,
80 X_Start_Date DATE,
81 X_End_Date DATE,
82 X_Period_Name VARCHAR2,
83 X_Quantity NUMBER,
84 X_Unit_Of_Measure VARCHAR2,
85 X_Track_As_Labor_Flag VARCHAR2,
86 X_Raw_Cost NUMBER,
87 X_Burdened_Cost NUMBER,
88 X_Revenue NUMBER
89 );
90 -- End for bug 6509313
91
92 end pa_budget_core1 ;