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