1 PACKAGE PA_ADW_COLLECT_FACTS AS
2 /* $Header: PAADWCFS.pls 120.1 2005/08/19 16:15:27 mwasowic noship $ */
3
4 -- Standard who
5 x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6 x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7 x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8 x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9 x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10 x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11 x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12
13
14 FUNCTION Initialize RETURN NUMBER;
15
16 PROCEDURE get_fact_act_cmts
17 (x_project_num_from IN VARCHAR2,
18 x_project_num_to IN VARCHAR2,
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_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
22
23 PROCEDURE update_tasks_act_cmt
24 (x_task_id IN NUMBER,
25 x_pa_period_key IN VARCHAR2,
26 x_expense_organization_id IN NUMBER,
27 x_owner_organization_id IN NUMBER,
28 x_resource_list_member_id IN NUMBER,
29 x_service_type_code IN VARCHAR2,
30 x_expenditure_type IN VARCHAR2,
31 x_user_col1 IN VARCHAR2,
32 x_user_col2 IN VARCHAR2,
33 x_user_col3 IN VARCHAR2,
34 x_user_col4 IN VARCHAR2,
35 x_user_col5 IN VARCHAR2,
36 x_user_col6 IN VARCHAR2,
37 x_user_col7 IN VARCHAR2,
38 x_user_col8 IN VARCHAR2,
39 x_user_col9 IN VARCHAR2,
40 x_user_col10 IN VARCHAR2,
41 x_accume_revenue IN NUMBER,
42 x_accume_raw_cost IN NUMBER,
43 x_accume_burdened_cost IN NUMBER,
44 x_accume_quantity IN NUMBER,
45 x_accume_labor_hours IN NUMBER,
46 x_accume_billable_raw_cost IN NUMBER,
47 x_acc_billable_burdened_cost IN NUMBER,
48 x_accume_billable_quantity IN NUMBER,
49 x_accume_billable_labor_hours IN NUMBER,
50 x_accume_cmt_raw_cost IN NUMBER,
51 x_accume_cmt_burdened_cost IN NUMBER,
52 x_accume_cmt_quantity IN NUMBER,
53 x_unit_of_measure IN VARCHAR2,
54 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
57
58 PROCEDURE update_prj_act_cmt
59 (x_project_id IN NUMBER,
60 x_pa_period_key IN VARCHAR2,
61 x_expense_organization_id IN NUMBER,
62 x_owner_organization_id IN NUMBER,
63 x_resource_list_member_id IN NUMBER,
64 x_service_type_code IN VARCHAR2,
65 x_expenditure_type IN VARCHAR2,
66 x_user_col1 IN VARCHAR2,
67 x_user_col2 IN VARCHAR2,
68 x_user_col3 IN VARCHAR2,
69 x_user_col4 IN VARCHAR2,
70 x_user_col5 IN VARCHAR2,
71 x_user_col6 IN VARCHAR2,
72 x_user_col7 IN VARCHAR2,
73 x_user_col8 IN VARCHAR2,
74 x_user_col9 IN VARCHAR2,
75 x_user_col10 IN VARCHAR2,
76 x_accume_revenue IN NUMBER,
77 x_accume_raw_cost IN NUMBER,
78 x_accume_burdened_cost IN NUMBER,
79 x_accume_quantity IN NUMBER,
80 x_accume_labor_hours IN NUMBER,
81 x_accume_billable_raw_cost IN NUMBER,
82 x_acc_billable_burdened_cost IN NUMBER,
83 x_accume_billable_quantity IN NUMBER,
84 x_accume_billable_labor_hours IN NUMBER,
85 x_accume_cmt_raw_cost IN NUMBER,
86 x_accume_cmt_burdened_cost IN NUMBER,
87 x_accume_cmt_quantity IN NUMBER,
88 x_unit_of_measure IN VARCHAR2,
89 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
91 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
92
93 PROCEDURE get_fact_budgets
94 (x_project_num_from IN VARCHAR2,
95 x_project_num_to IN VARCHAR2,
96 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
97 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
98 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
99
100 PROCEDURE update_tasks_budgets
101 (x_task_id IN NUMBER,
102 x_pa_period_key IN VARCHAR2,
103 x_budget_type_code IN VARCHAR2,
104 x_resource_list_member_id IN NUMBER,
105 x_service_type_code IN VARCHAR2,
106 x_owner_organization_id IN NUMBER,
107 x_expenditure_type IN VARCHAR2,
108 x_user_col1 IN VARCHAR2,
109 x_user_col2 IN VARCHAR2,
110 x_user_col3 IN VARCHAR2,
111 x_user_col4 IN VARCHAR2,
112 x_user_col5 IN VARCHAR2,
113 x_user_col6 IN VARCHAR2,
114 x_user_col7 IN VARCHAR2,
115 x_user_col8 IN VARCHAR2,
116 x_user_col9 IN VARCHAR2,
117 x_user_col10 IN VARCHAR2,
118 x_bgt_revenue IN NUMBER,
119 x_bgt_raw_cost IN NUMBER,
120 x_bgt_burdened_cost IN NUMBER,
121 x_bgt_quantity IN NUMBER,
122 x_bgt_labor_quantity IN NUMBER,
123 x_bgt_unit_of_measure IN VARCHAR2,
124 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
125 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
126 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
127
128 PROCEDURE update_prj_budgets
129 (x_project_id IN NUMBER,
130 x_pa_period_key IN VARCHAR2,
131 x_budget_type_code IN VARCHAR2,
132 x_resource_list_member_id IN NUMBER,
133 x_service_type_code IN VARCHAR2,
134 x_owner_organization_id IN NUMBER,
135 x_expenditure_type IN VARCHAR2,
136 x_user_col1 IN VARCHAR2,
137 x_user_col2 IN VARCHAR2,
138 x_user_col3 IN VARCHAR2,
139 x_user_col4 IN VARCHAR2,
140 x_user_col5 IN VARCHAR2,
141 x_user_col6 IN VARCHAR2,
142 x_user_col7 IN VARCHAR2,
143 x_user_col8 IN VARCHAR2,
144 x_user_col9 IN VARCHAR2,
145 x_user_col10 IN VARCHAR2,
146 x_bgt_revenue IN NUMBER,
147 x_bgt_raw_cost IN NUMBER,
148 x_bgt_burdened_cost IN NUMBER,
149 x_bgt_quantity IN NUMBER,
150 x_bgt_labor_quantity IN NUMBER,
151 x_bgt_unit_of_measure IN VARCHAR2,
152 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
153 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
154 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
155
156 END PA_ADW_COLLECT_FACTS;