1 PACKAGE PA_MULTI_CURR_CLIENT_EXTN AUTHID CURRENT_USER AS
2 /* $Header: PAPMCECS.pls 120.5 2006/07/29 11:40:17 skannoji noship $ */
3 /*#
4 * This extension is used to override the default attributes used to convert the transfer price from the transaction
5 * currency to the functional currency.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Transfer Price Currency Conversion Override Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_PROJ_COST
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15 -------------------------------------------------------------------------------
16 -- Client extension to override Currency Conversion attributes
17 /**
18 * This procedure is used to override the currency conversion attributes when converting transfer price.
19 * @param p_project_id The Identifier of the project
20 * @rep:paraminfo {@rep:required}
21 * @param p_task_id Task identifier
22 * @rep:paraminfo {@rep:required}
23 * @param p_transcation_class The hard coded value "Transfer Price"
24 * @rep:paraminfo {@rep:required}
25 * @param p_expenditure_item_id Expenditure item identifier
26 * @rep:paraminfo {@rep:required}
27 * @param p_expenditure_type_class The type class of the expenditure
28 * @rep:paraminfo {@rep:required}
29 * @param p_expenditure_type Expenditure type
30 * @rep:paraminfo {@rep:required}
31 * @param p_expenditure_category Expenditure category
32 * @rep:paraminfo {@rep:required}
33 * @param p_from_currency_code Currency to convert from
34 * @rep:paraminfo {@rep:required}
35 * @param p_to_currency_code Currency to convert to
36 * @rep:paraminfo {@rep:required}
37 * @param p_conversion_type Default exchange rate type to be used for conversion
38 * @rep:paraminfo {@rep:required}
39 * @param p_conversion_date Default exchange rate date to be used for conversion
40 * @rep:paraminfo {@rep:required}
41 * @param x_rate_type Override exchange rate type.If user rate type is being used, pass User
42 * @rep:paraminfo {@rep:required}
43 * @param x_rate_date Override exchange rate date
44 * @rep:paraminfo {@rep:required}
45 * @param x_exchange_rate Override exchange rate to be used for rate type of User only
46 * @rep:paraminfo {@rep:required}
47 * @param x_error_message Error message text
48 * @rep:paraminfo {@rep:required}
49 * @param X_Status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
50 * @rep:paraminfo {@rep:required}
51 * @rep:scope public
52 * @rep:product PA
53 * @rep:lifecycle active
54 * @rep:displayname Override Currency Conversion Attributes
55 * @rep:compatibility S
56 */
57 PROCEDURE Override_Curr_Conv_Attributes(
58 p_project_id IN Number,
59 p_task_id IN Number,
60 p_transaction_class IN Varchar2,
61 p_expenditure_item_id IN Number,
62 p_expenditure_type_class IN Varchar2,
63 p_expenditure_type IN Varchar2,
64 p_expenditure_category IN Varchar2,
65 p_from_currency_code IN Varchar2,
66 p_to_currency_code IN Varchar2,
67 p_conversion_type IN Varchar2,
68 p_conversion_date IN Date,
69 x_rate_type OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
70 x_rate_date OUT NOCOPY Date, --File.Sql.39 bug 4440895
71 x_exchange_rate OUT NOCOPY Number, --File.Sql.39 bug 4440895
72 x_error_message OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
73 x_status OUT NOCOPY Number --File.Sql.39 bug 4440895
74 );
75
76 --------------------------------------------------------------------------------
77
78 END PA_MULTI_CURR_CLIENT_EXTN ;