1 package PA_NON_LABOR_BILL_CLT_EXTN as
2 /* $Header: PAXINCTS.pls 120.4 2006/07/25 06:37:51 lveerubh noship $ */
3 /*#
4 * This extension contains a function to calculate bill amounts for individual non-labor transactions.Some examples of non-labor billing extensions are : tiered pricing method, external system rate derivation .
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Non-Labor Billing Extensions
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_REVENUE
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14 /*#
15 * This procedure calculates the bill amount.
16 * @param X_TRANSACTION_TYPE Identifier of the transaction type.The default value is ACTUAL
17 * @rep:paraminfo {@rep:required}
18 * @param X_EXPENDITURE_ITEM_ID Identifier of the expenditure item.
19 * @rep:paraminfo {@rep:required}
20 * @param X_SYS_LINKAGE_FUNCTION The expenditure type class
21 * @rep:paraminfo {@rep:required}
22 * @param X_AMOUNT The bill amount
23 * @rep:paraminfo {@rep:required}
24 * @param X_EXPENDITURE_TYPE The expenditure type
25 * @rep:paraminfo {@rep:required}
26 * @param X_NON_LABOR_RESOURCE Identifier of the non-labor resource
27 * @rep:paraminfo {@rep:required}
28 * @param X_NON_LABOR_RES_ORG Identifier of the non-labor resource organization
29 * @rep:paraminfo {@rep:required}
30 * @param X_BILL_RATE_FLAG Flag indicating if the bill rate should be used
31 * @rep:paraminfo {@rep:required}
32 * @param X_STATUS The status of the procedure
33 * @rep:paraminfo {@rep:required}
34 * @param X_BILL_TRANS_CURRENCY_CODE The transaction currency used for calculation
35 * @rep:paraminfo {@rep:required}
36 * @param X_BILL_TXN_BILL_RATE The rate used for calculating the bill amount
37 * @rep:paraminfo {@rep:required}
38 * @param X_MARKUP_PERCENTAGE The markup percentage used for calculating the bill amount
39 * @rep:paraminfo {@rep:required}
40 * @param X_RATE_SOURCE_ID Identifier of the source of bill rate or markup
41 * @rep:paraminfo {@rep:required}
42 * @rep:scope public
43 * @rep:lifecycle active
44 * @rep:displayname Calculate Bill Amount
45 * @rep:compatibility S
46 */
47 PROCEDURE Calc_Bill_Amount
48 (
49 x_transaction_type in varchar2 default 'ACTUAL',
50 x_expenditure_item_id IN NUMBER,
51 x_sys_linkage_function IN VARCHAR2,
52 x_amount IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53 x_expenditure_type IN VARCHAR2,
54 x_non_labor_resource IN VARCHAR2,
55 x_non_labor_res_org IN NUMBER,
56 x_bill_rate_flag IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57 x_status IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
58 x_bill_trans_currency_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
59 x_bill_txn_bill_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60 x_markup_percentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61 x_rate_source_id OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
62
63
64 end PA_NON_LABOR_BILL_CLT_EXTN;