[Home] [Help]
PACKAGE: APPS.PA_TXN_ACCUMS
Source
1 PACKAGE PA_TXN_ACCUMS AS
2 /* $Header: PATXNACS.pls 120.2 2006/11/10 19:35:03 degupta 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 -- Variable to store the accumulation configuration
15
16 raw_cost_flag VARCHAR2(1);
17 burdened_cost_flag VARCHAR2(1);
18 quantity_flag VARCHAR2(1);
19 labor_hours_flag VARCHAR2(1);
20 billable_raw_cost_flag VARCHAR2(1);
21 billable_burdened_cost_flag VARCHAR2(1);
22 billable_quantity_flag VARCHAR2(1);
23 billable_labor_hours_flag VARCHAR2(1);
24 revenue_flag VARCHAR2(1);
25 cmt_raw_cost_flag VARCHAR2(1);
26 cmt_burdened_cost_flag VARCHAR2(1);
27
28 FUNCTION Initialize RETURN NUMBER;
29 FUNCTION cmt_line_id RETURN NUMBER;
30
31 pragma RESTRICT_REFERENCES (cmt_line_id, WNDS, WNPS );
32
33 PROCEDURE get_accum_configurations
34 ( x_project_id IN NUMBER,
35 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
37
38 PROCEDURE update_resource_flag
39 (x_start_project_id IN NUMBER,
40 x_end_project_id IN NUMBER,
41 x_start_pa_date IN DATE,
42 x_end_pa_date IN DATE,
43 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
45
46 PROCEDURE refresh_txn_accum
47 ( x_start_project_id IN NUMBER,
48 x_end_project_id IN NUMBER,
49 x_start_pa_date IN DATE,
50 x_end_pa_date IN DATE,
51 x_transaction_type IN VARCHAR2 DEFAULT NULL,
52 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
53 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
55
56 PROCEDURE refresh_act_txn_accum
57 ( x_start_project_id IN NUMBER,
58 x_end_project_id IN NUMBER,
59 x_start_pa_date IN DATE,
60 x_end_pa_date IN DATE,
61 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
62 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
64
65 PROCEDURE delete_act_txn_accum_details
66 ( x_start_project_id IN NUMBER,
67 x_end_project_id IN NUMBER,
68 x_start_pa_date IN DATE,
69 x_end_pa_date IN DATE,
70 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
71 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
72 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
73
74 PROCEDURE refresh_rev_txn_accum
75 ( x_start_project_id IN NUMBER,
76 x_end_project_id IN NUMBER,
77 x_start_pa_date IN DATE,
78 x_end_pa_date IN DATE,
79 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
80 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
81
82 PROCEDURE delete_rev_txn_accum_details
83 ( x_start_project_id IN NUMBER,
84 x_end_project_id IN NUMBER,
85 x_start_pa_date IN DATE,
86 x_end_pa_date IN DATE,
87 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
89
90 PROCEDURE refresh_cmt_txn_accum
91 ( x_start_project_id IN NUMBER,
92 x_end_project_id IN NUMBER,
93 x_start_pa_date IN DATE,
94 x_end_pa_date IN DATE,
95 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
96 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
97 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
98
99 PROCEDURE update_act_txn_accum
100 ( x_start_project_id IN NUMBER,
101 x_end_project_id IN NUMBER,
102 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
103 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
104
105 PROCEDURE delete_cmt_txn_accum_details
106 ( x_start_project_id IN NUMBER,
107 x_end_project_id IN NUMBER,
108 x_start_pa_date IN DATE,
109 x_end_pa_date IN DATE,
110 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
111 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
112 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
113
114 PROCEDURE create_txn_accum_details
115 (x_txn_accum_id IN NUMBER,
116 x_line_type IN VARCHAR2,
117 x_expenditure_item_id IN NUMBER DEFAULT NULL,
118 x_line_num IN NUMBER DEFAULT NULL,
119 x_event_num IN NUMBER DEFAULT NULL,
120 x_cmt_line_id IN NUMBER DEFAULT NULL,
121 x_project_id IN NUMBER DEFAULT NULL,
122 x_task_id IN NUMBER DEFAULT NULL,
123 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
124 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
125
126 PROCEDURE create_txn_accum
127 ( x_project_id IN NUMBER,
128 x_task_Id IN NUMBER,
129 x_pa_period IN VARCHAR2,
130 x_gl_period IN VARCHAR2,
131 x_week_ending_date IN DATE,
132 x_month_ending_date IN DATE,
133 x_person_id IN NUMBER DEFAULT NULL,
134 x_job_id IN NUMBER DEFAULT NULL,
135 x_vendor_id IN VARCHAR2 DEFAULT NULL,
136 x_expenditure_type IN VARCHAR2 DEFAULT NULL,
137 x_organization_id IN NUMBER DEFAULT NULL,
138 x_non_labor_resource IN VARCHAR2 DEFAULT NULL,
139 x_non_labor_resource_org_id IN NUMBER DEFAULT NULL,
140 x_expenditure_category IN VARCHAR2 DEFAULT NULL,
141 x_revenue_category IN VARCHAR2 DEFAULT NULL,
142 x_event_type IN VARCHAR2 DEFAULT NULL,
143 x_event_type_classification IN VARCHAR2 DEFAULT NULL,
144 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
145 x_line_type IN VARCHAR2 DEFAULT NULL,
146 x_cost_ind_compiled_set_id IN NUMBER DEFAULT NULL,
147 x_rev_ind_compiled_set_id IN NUMBER DEFAULT NULL,
148 x_inv_ind_compiled_set_id IN NUMBER DEFAULT NULL,
149 x_cmt_ind_compiled_set_id IN NUMBER DEFAULT NULL,
150 x_txn_accum_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
151 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
152 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
153
154 PROCEDURE delete_cmt_txns
155 ( x_start_project_id IN NUMBER,
156 x_end_project_id IN NUMBER,
157 x_start_pa_date IN DATE,
158 x_end_pa_date IN DATE,
159 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
160 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
162
163 PROCEDURE create_cmt_txns
164 ( x_start_project_id IN NUMBER,
165 x_end_project_id IN NUMBER,
166 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
167 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
168 x_err_code IN OUT NOCOPY NUMBER,
169 x_use_tmp_table IN VARCHAR2 DEFAULT 'N'); --File.Sql.39 bug 4440895
170
171 PROCEDURE accum_act_txn
172 ( x_txn_accum_id IN NUMBER,
173 x_tot_raw_cost IN NUMBER,
174 x_tot_burdened_cost IN NUMBER,
175 x_tot_quantity IN NUMBER,
176 x_tot_billable_raw_cost IN NUMBER,
177 x_tot_billable_burdened_cost IN NUMBER,
178 x_tot_billable_quantity IN NUMBER,
179 x_unit_of_measure IN VARCHAR2,
180 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
181 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
182
183 PROCEDURE accum_rev_txn
184 ( x_txn_accum_id IN NUMBER,
185 x_tot_revenue IN NUMBER,
186 x_unit_of_measure IN VARCHAR2,
187 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
188 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
189
190 PROCEDURE accum_cmt_txn
191 ( x_txn_accum_id IN NUMBER,
192 x_tot_cmt_raw_cost IN NUMBER,
193 x_tot_cmt_burdened_cost IN NUMBER,
194 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
196 PROCEDURE accum_cdls
197 ( x_start_project_id IN NUMBER,
198 x_end_project_id IN NUMBER,
199 x_start_pa_date IN DATE,
200 x_end_pa_date IN DATE,
201 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
202 x_mode IN VARCHAR2 DEFAULT 'I',
203 x_cdl_line_type IN VARCHAR2 DEFAULT 'R', -- patchSet L Reburdening
204 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
205 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
206 PROCEDURE accum_rdls
207 ( x_start_project_id IN NUMBER,
208 x_end_project_id IN NUMBER,
209 x_start_pa_date IN DATE,
210 x_end_pa_date IN DATE,
211 x_mode IN VARCHAR2 DEFAULT 'I',
212 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
213 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
214 PROCEDURE accum_erdls
215 ( x_start_project_id IN NUMBER,
216 x_end_project_id IN NUMBER,
217 x_start_pa_date IN DATE,
218 x_end_pa_date IN DATE,
219 x_mode IN VARCHAR2 DEFAULT 'I',
220 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
221 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
222 PROCEDURE accum_revenue
223 ( x_start_project_id IN NUMBER,
224 x_end_project_id IN NUMBER,
225 x_start_pa_date IN DATE,
226 x_end_pa_date IN DATE,
227 x_mode IN VARCHAR2 DEFAULT 'I',
228 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
230
231 PROCEDURE accum_commitments
232 ( x_start_project_id IN NUMBER,
233 x_end_project_id IN NUMBER,
234 x_system_linkage_function IN VARCHAR2 DEFAULT NULL,
235 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
236 x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
237
238 END PA_TXN_ACCUMS;