1 package pa_expenditure_items_pkg as
2 /* $Header: PAXTITMS.pls 120.2 2005/08/17 12:57:00 ramurthy noship $ */
3
4 procedure insert_row (x_rowid in out nocopy VARCHAR2,
5 x_expenditure_item_id in out nocopy NUMBER,
6 x_last_update_date in DATE,
7 x_last_updated_by in NUMBER,
8 x_creation_date in DATE,
9 x_created_by in NUMBER,
10 x_expenditure_id in NUMBER,
11 x_task_id in NUMBER,
12 x_expenditure_item_date in DATE,
13 x_expenditure_type in VARCHAR2,
14 x_cost_distributed_flag in VARCHAR2,
15 x_revenue_distributed_flag in VARCHAR2,
16 x_billable_flag in VARCHAR2,
17 x_bill_hold_flag in VARCHAR2,
18 x_quantity in NUMBER,
19 x_non_labor_resource in VARCHAR2,
20 x_organization_id in NUMBER,
21 x_override_to_organization_id in NUMBER,
22 x_raw_cost in NUMBER,
23 x_raw_cost_rate in NUMBER,
24 x_burden_cost in NUMBER,
25 x_burden_cost_rate in NUMBER,
26 x_cost_dist_rejection_code in VARCHAR2,
27 x_labor_cost_multiplier_name in VARCHAR2,
28 x_raw_revenue in NUMBER,
29 x_bill_rate in NUMBER,
30 x_accrued_revenue in NUMBER,
31 x_accrual_rate in NUMBER,
32 x_adjusted_revenue in NUMBER,
33 x_adjusted_rate in NUMBER,
34 x_bill_amount in NUMBER,
35 x_forecast_revenue in NUMBER,
36 x_bill_rate_multiplier in NUMBER,
37 x_rev_dist_rejection_code in VARCHAR2,
38 x_event_num in NUMBER,
39 x_event_task_id in NUMBER,
40 x_bill_job_id in NUMBER,
41 x_bill_job_billing_title in VARCHAR2,
42 x_bill_employee_billing_title in VARCHAR2,
43 x_adjusted_expenditure_item_id in NUMBER,
44 x_net_zero_adjustment_flag in VARCHAR2,
45 x_transferred_from_exp_item_id in NUMBER,
46 x_converted_flag in VARCHAR2,
47 x_last_update_login in NUMBER,
48 x_attribute_category in VARCHAR2,
49 x_attribute1 in VARCHAR2,
50 x_attribute2 in VARCHAR2,
51 x_attribute3 in VARCHAR2,
52 x_attribute4 in VARCHAR2,
53 x_attribute5 in VARCHAR2,
54 x_attribute6 in VARCHAR2,
55 x_attribute7 in VARCHAR2,
56 x_attribute8 in VARCHAR2,
57 x_attribute9 in VARCHAR2,
58 x_attribute10 in VARCHAR2,
59 x_cost_ind_compiled_set_id in NUMBER,
60 x_rev_ind_compiled_set_id in NUMBER,
61 x_inv_ind_compiled_set_id in NUMBER,
62 x_cost_burden_distributed_flag in VARCHAR2,
63 x_ind_cost_dist_rejection_code in VARCHAR2,
64 x_orig_transaction_reference in VARCHAR2,
65 x_transaction_source in VARCHAR2,
66 x_project_id in NUMBER,
67 x_source_expenditure_item_id in NUMBER,
68 x_job_id in NUMBER,
69 x_expenditure_comment in VARCHAR2,
70 x_system_linkage_function in VARCHAR2,
71 x_receipt_currency_amount in NUMBER,
72 x_receipt_currency_code in VARCHAR2,
73 x_receipt_exchange_rate in NUMBER,
74 x_denom_currency_code in VARCHAR2,
75 x_denom_raw_cost in NUMBER,
76 x_denom_burdened_cost in NUMBER,
77 x_acct_exchange_rounding_limit in NUMBER,
78 x_acct_currency_code in VARCHAR2,
79 x_acct_rate_date in DATE,
80 x_acct_rate_type in VARCHAR2,
81 x_acct_exchange_rate in NUMBER,
82 x_acct_raw_cost in NUMBER,
83 x_acct_burdened_cost in NUMBER,
84 x_project_currency_code in VARCHAR2,
85 x_project_rate_date in DATE,
86 x_project_rate_type in VARCHAR2,
87 x_project_exchange_rate in NUMBER,
88 x_recvr_org_id in NUMBER,
89 p_assignment_id IN NUMBER default null,
90 p_work_type_id IN NUMBER default null,
91 p_projfunc_currency_code IN varchar2 default null,
92 p_projfunc_cost_rate_date IN date default null,
93 p_projfunc_cost_rate_type IN varchar2 default null,
94 p_projfunc_cost_exchange_rate IN number default null,
95 p_project_raw_cost IN number default null,
96 p_project_burdened_cost IN number default null,
97 p_tp_amt_type_code IN varchar2 default null ,
98 p_prvdr_accrual_date IN date default null,
99 p_recvr_accrual_date IN date default null,
100 p_capital_event_id IN number default null,
101 p_wip_resource_id IN number default null,
102 p_inventory_item_id IN number default null,
103 p_unit_of_measure IN varchar2 default null,
104 P_Org_Id IN NUMBER default NULL); -- 12i MOAC changes
105
106
107 procedure update_row (x_rowid in VARCHAR2,
108 x_expenditure_item_id in NUMBER,
109 x_last_update_date in DATE,
110 x_last_updated_by in NUMBER,
111 x_expenditure_id in NUMBER,
112 x_task_id in NUMBER,
113 x_expenditure_item_date in DATE,
114 x_expenditure_type in VARCHAR2,
115 x_cost_distributed_flag in VARCHAR2,
116 x_revenue_distributed_flag in VARCHAR2,
117 x_billable_flag in VARCHAR2,
118 x_bill_hold_flag in VARCHAR2,
119 x_quantity in NUMBER,
120 x_non_labor_resource in VARCHAR2,
121 x_organization_id in NUMBER,
122 x_override_to_organization_id in NUMBER,
123 x_raw_cost in NUMBER,
124 x_raw_cost_rate in NUMBER,
125 x_burden_cost in NUMBER,
126 x_burden_cost_rate in NUMBER,
127 x_cost_dist_rejection_code in VARCHAR2,
128 x_labor_cost_multiplier_name in VARCHAR2,
129 x_raw_revenue in NUMBER,
130 x_bill_rate in NUMBER,
131 x_accrued_revenue in NUMBER,
132 x_accrual_rate in NUMBER,
133 x_adjusted_revenue in NUMBER,
134 x_adjusted_rate in NUMBER,
135 x_bill_amount in NUMBER,
136 x_forecast_revenue in NUMBER,
137 x_bill_rate_multiplier in NUMBER,
138 x_rev_dist_rejection_code in VARCHAR2,
139 x_event_num in NUMBER,
140 x_event_task_id in NUMBER,
141 x_bill_job_id in NUMBER,
142 x_bill_job_billing_title in VARCHAR2,
143 x_bill_employee_billing_title in VARCHAR2,
144 x_adjusted_expenditure_item_id in NUMBER,
145 x_net_zero_adjustment_flag in VARCHAR2,
146 x_transferred_from_exp_item_id in NUMBER,
147 x_converted_flag in VARCHAR2,
148 x_last_update_login in NUMBER,
149 x_attribute_category in VARCHAR2,
150 x_attribute1 in VARCHAR2,
151 x_attribute2 in VARCHAR2,
152 x_attribute3 in VARCHAR2,
153 x_attribute4 in VARCHAR2,
154 x_attribute5 in VARCHAR2,
155 x_attribute6 in VARCHAR2,
156 x_attribute7 in VARCHAR2,
157 x_attribute8 in VARCHAR2,
158 x_attribute9 in VARCHAR2,
159 x_attribute10 in VARCHAR2,
160 x_cost_ind_compiled_set_id in NUMBER,
161 x_rev_ind_compiled_set_id in NUMBER,
162 x_inv_ind_compiled_set_id in NUMBER,
163 x_cost_burden_distributed_flag in VARCHAR2,
164 x_ind_cost_dist_rejection_code in VARCHAR2,
165 x_orig_transaction_reference in VARCHAR2,
166 x_transaction_source in VARCHAR2,
167 x_project_id in NUMBER,
171 x_system_linkage_function in VARCHAR2,
168 x_source_expenditure_item_id in NUMBER,
169 x_job_id in NUMBER,
170 x_expenditure_comment in VARCHAR2,
172 x_receipt_currency_amount in NUMBER,
173 x_receipt_currency_code in VARCHAR2,
174 x_receipt_exchange_rate in NUMBER,
175 x_denom_currency_code in VARCHAR2,
176 x_denom_raw_cost in NUMBER,
177 x_denom_burdened_cost in NUMBER,
178 x_acct_exchange_rounding_limit in NUMBER,
179 x_acct_currency_code in VARCHAR2,
180 x_acct_rate_date in DATE,
181 x_acct_rate_type in VARCHAR2,
182 x_acct_exchange_rate in NUMBER,
183 x_acct_raw_cost in NUMBER,
184 x_acct_burdened_cost in NUMBER,
185 x_project_currency_code in VARCHAR2,
186 x_project_rate_date in DATE,
187 x_project_rate_type in VARCHAR2,
188 x_project_exchange_rate in NUMBER,
189 x_recvr_org_id in NUMBER,
190 p_assignment_id IN NUMBER default null,
194 p_projfunc_cost_rate_type IN varchar2 default null,
191 p_work_type_id IN NUMBER default null,
192 p_projfunc_currency_code IN varchar2 default null,
193 p_projfunc_cost_rate_date IN date default null,
195 p_projfunc_cost_exchange_rate IN number default null,
196 p_project_raw_cost IN number default null,
197 p_project_burdened_cost IN number default null,
198 p_tp_amt_type_code IN varchar2 default null,
199 p_prvdr_accrual_date IN date default null,
200 p_recvr_accrual_date IN date default null,
201 p_capital_event_id IN number default null);
202
203 -- overload delete_row to tkae both rowid or exp_id as arguments
204 procedure delete_row (x_expenditure_item_id in NUMBER);
205 procedure delete_row (x_rowid in VARCHAR2);
206
207 procedure lock_row (x_rowid in VARCHAR2);
208
209 END pa_expenditure_items_pkg;