1 package body PA_NON_LABOR_BILL_CLT_EXTN as
2 /* $Header: PAXINCTB.pls 120.1 2005/08/19 17:14:22 mwasowic noship $ */
3
4 PROCEDURE Calc_Bill_Amount
5 (
6 x_transaction_type in varchar2 default 'ACTUAL',
7 x_expenditure_item_id IN NUMBER,
8 x_sys_linkage_function IN VARCHAR2,
9 x_amount IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10 x_expenditure_type IN VARCHAR2,
11 x_non_labor_resource IN VARCHAR2,
12 x_non_labor_res_org IN NUMBER,
13 x_bill_rate_flag IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14 x_status IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15 x_bill_trans_currency_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16 x_bill_txn_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17 x_markup_percentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_rate_source_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
19 is
20 begin
21 -- Reset the output parameters.
22 x_amount := NULL;
23 x_bill_rate_flag := NULL;
24 x_status := 0;
25 -- Add your calculation of bill amount here.
26 -- Assign the result of bill amount to x_amount
27 -- If you want a bill rate populated by Project Accounting, set
28 -- x_bill_rate_flag to 'B' return rate in the x_bill_txn_bill_rate and if you are using markup, return
29 -- markup percentage in the x_markup_percentage and populate the x_rate_source_id with unique identifier
30 -- of the source that was used to derive the bill rate or markup. If x_bill_rate_flag's null or
31 -- set to 'N', x_amount will be treated as a markup, and bill rate will not be populated.
32 -- Do not add 'commit' or 'rollback' in your code, since Oracle
33 -- Project Accounting controls the transaction for you.
34
35 exception
36 when others then
37 -- Add your exception handler here.
38 -- To raise an application error, assign a positive number to x_status.
39 -- To raise an ORACLE error, assign SQLCODE to x_status.
40 null;
41
42 end Calc_Bill_Amount;
43
44
45 end PA_NON_LABOR_BILL_CLT_EXTN;