1 PACKAGE PA_ACCUM_API AUTHID CURRENT_USER AS
2 /* $Header: PAAAPIS.pls 120.1 2005/08/19 16:13:22 mwasowic noship $ */
3 -- Actuals accumulation API
4
5 PROCEDURE get_proj_txn_accum
6 (x_project_id IN NUMBER,
7 x_task_id IN NUMBER DEFAULT NULL,
8 x_period_type IN VARCHAR2 DEFAULT 'P',
9 x_from_period_name IN VARCHAR2 DEFAULT NULL,
10 x_prd_start_date IN DATE DEFAULT NULL,
11 x_prd_end_date IN DATE DEFAULT NULL,
12 x_revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
13 x_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
14 x_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15 x_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
16 x_labor_hours IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17 x_billable_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_billable_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
19 x_billable_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
20 x_billable_labor_hours IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21 x_cmt_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 x_cmt_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 x_unit_of_measure IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
25 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
26
27 PROCEDURE get_proj_res_accum
28 (x_project_id IN NUMBER,
29 x_task_id IN NUMBER DEFAULT NULL,
30 x_resource_list_member_id IN NUMBER DEFAULT NULL,
31 x_period_type IN VARCHAR2 DEFAULT 'P',
32 x_from_period_name IN VARCHAR2 DEFAULT NULL,
33 x_prd_start_date IN DATE DEFAULT NULL,
34 x_prd_end_date IN DATE DEFAULT NULL,
35 x_revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
36 x_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 x_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
39 x_labor_hours IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
40 x_billable_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41 x_billable_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
42 x_billable_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
43 x_billable_labor_hours IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 x_cmt_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
45 x_cmt_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
46 x_unit_of_measure IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
49
50 PROCEDURE get_proj_accum_actuals
51 (x_project_id IN NUMBER,
52 x_task_id IN NUMBER DEFAULT NULL,
53 x_resource_list_member_id IN NUMBER DEFAULT NULL,
54 x_period_type IN VARCHAR2 DEFAULT 'P',
55 x_from_period_name IN VARCHAR2 DEFAULT NULL,
56 x_prd_start_date IN DATE DEFAULT NULL,
57 x_prd_end_date IN DATE DEFAULT NULL,
58 x_revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59 x_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60 x_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61 x_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
62 x_labor_hours IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63 x_billable_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
64 x_billable_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
65 x_billable_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
66 x_billable_labor_hours IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
67 x_cmt_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
68 x_cmt_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69 x_unit_of_measure IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
70 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
71 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
72
73 PROCEDURE get_proj_accum_budgets
74 (x_project_id IN NUMBER,
75 x_task_id IN NUMBER DEFAULT NULL,
76 x_resource_list_member_id IN NUMBER DEFAULT NULL,
77 x_period_type IN VARCHAR2 DEFAULT 'P',
78 x_from_period_name IN VARCHAR2 DEFAULT NULL,
79 x_to_period_name IN VARCHAR2 DEFAULT NULL,
80 x_budget_type_code IN VARCHAR2 DEFAULT NULL,
81 x_base_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
82 x_base_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
83 x_base_revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
84 x_base_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
85 x_base_labor_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
86 x_unit_of_measure IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
87 x_orig_raw_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
88 x_orig_burdened_cost IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89 x_orig_revenue IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
90 x_orig_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
91 x_orig_labor_quantity IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
92 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
94
95
96 END PA_ACCUM_API;