1 PACKAGE PA_CC_TP_CLIENT_EXTN AUTHID CURRENT_USER AS
2 /* $Header: PAPTPRCS.pls 120.4 2006/07/25 06:35:27 lveerubh noship $ */
3 /*#
4 * The extension determine_transfer_price specifies a transfer price for the transaction being processed.
5 * If this extension returns a valid value for the transfer price, Oracle Projects uses that value as the transfer
6 * price instead of computing the transfer price. The Distribute Borrowed and Lent Amounts and the Generate
7 * Intercompany Invoice processes call this extension, before calling the standard transfer price determination routine.
8 * @rep:scope public
9 * @rep:product PA
10 * @rep:lifecycle active
11 * @rep:displayname Transfer Price Override Extension
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY PA_PROJECT
14 * @rep:category BUSINESS_ENTITY PA_IC_TRANSACTION
15 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
16 */
17 -------------------------------------------------------------------------------
18 -- Pre-client extension
19 /*#
20 * This extension specifies a transfer price for the transaction being processed.
21 * If this extension returns a valid value for the transfer price,
22 * Oracle Projects uses that value as the transfer
23 * price instead of computing the transfer price.
24 * @param p_transaction_type Transaction type
25 * @rep:paraminfo {@rep:required}
26 * @param p_prvdr_org_id Identifier of the provider operating unit
27 * @rep:paraminfo {@rep:required}
28 * @param p_prvdr_organization_id Identifier of the provider organization
29 * @rep:paraminfo {@rep:required}
30 * @param p_recvr_org_id Identifier of the receiver operating unit
31 * @rep:paraminfo {@rep:required}
32 * @param p_recvr_organization_id Identifier of the receiver organization
33 * @rep:paraminfo {@rep:required}
34 * @param p_expnd_organization_id Idnetifier of the expenditure organization
35 * @rep:paraminfo {@rep:required}
36 * @param p_expenditure_item_id Identifier of the expenditure item
37 * @rep:paraminfo {@rep:required}
38 * @param p_expenditure_item_type Expenditure type
39 * @rep:paraminfo {@rep:required}
40 * @param p_expenditure_type_class Expenditure type class
41 * @rep:paraminfo {@rep:required}
42 * @param p_task_id Identifier of the task
43 * @rep:paraminfo {@rep:required}
44 * @param p_project_id Identifier of the project
45 * @rep:paraminfo {@rep:required}
46 * @param p_quantity Number of units of work performed
47 * @rep:paraminfo {@rep:required}
48 * @param p_incurred_by_person_id Identifier of the person who incurred the expenditure
49 * @rep:paraminfo {@rep:required}
50 * @param x_denom_tp_curr_code Transaction currency code in which transfer price is calculated
51 * @rep:paraminfo {@rep:required}
52 * @param x_denom_transfer_price Transfer price amount in transaction currency
53 * @rep:paraminfo {@rep:required}
54 * @param x_tp_bill_rate Bill rate applied to calculate the transfer price
55 * @rep:paraminfo {@rep:required}
56 * @param x_tp_bill_markup_percentage Percentage used to derive the transfer
57 * price if the transfer price was based on a markup
58 * @rep:paraminfo {@rep:required}
59 * @param x_error_message Error message text
60 * @rep:paraminfo {@rep:required}
61 * @param x_status Status indicating whether an error
62 * occurred. Valid values are:=0 Success, <0 Oracle Error
63 * >0 Application Error.
64 * @rep:paraminfo {@rep:required}
65 * @rep:scope public
66 * @rep:lifecycle active
67 * @rep:displayname Determine Transfer Price
68 * @rep:compatibility S
69 */
70
71 PROCEDURE Determine_Transfer_Price(
72 p_transaction_type IN Varchar2 DEFAULT 'ACTUAL', /** Added for Org Forecasting **/
73 p_prvdr_org_id IN Number,
74 p_prvdr_organization_id IN Number,
75 p_recvr_org_id IN Number,
76 p_recvr_organization_id IN Number,
77 p_expnd_organization_id IN Number,
78 p_expenditure_item_id IN Number,
79 p_expenditure_item_type IN Varchar2,
80 p_expenditure_type_class IN Varchar2,
81 p_task_id IN Number,
82 p_project_id IN Number,
83 p_quantity IN Number,
84 p_incurred_by_person_id IN Number,
85 x_denom_tp_curr_code OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
86 x_denom_transfer_price OUT NOCOPY Number, --File.Sql.39 bug 4440895
87 x_tp_bill_rate OUT NOCOPY Number, --File.Sql.39 bug 4440895
88 x_tp_bill_markup_percentage OUT NOCOPY Number, --File.Sql.39 bug 4440895
89 x_error_message OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
90 x_status OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
91 );
92
93 --------------------------------------------------------------------------------
94 -- Post-client extension
95 /*#
96 * This API is used to override the transfer price for a transaction.
97 * @param p_transaction_type Transaction type
98 * @rep:paraminfo {@rep:required}
99 * @param p_prvdr_org_id Identifier of the provider operating unit
100 * @rep:paraminfo {@rep:required}
101 * @param p_prvdr_organization_id Identifier of the provider organization
102 * @rep:paraminfo {@rep:required}
103 * @param p_recvr_org_id Idnetifier of the receiver organization
104 * @rep:paraminfo {@rep:required}
105 * @param p_recvr_organization_id Identifier of the receiver organization
106 * @rep:paraminfo {@rep:required}
107 * @param p_expnd_organization_id Identifier of the expenditure organization
108 * @rep:paraminfo {@rep:required}
109 * @param p_expenditure_item_id Identifier of the expenditure item
110 * @rep:paraminfo {@rep:required}
111 * @param p_expenditure_item_type Expenditure item type
112 * @rep:paraminfo {@rep:required}
113 * @param p_expenditure_type_class Expenditure type class
114 * @rep:paraminfo {@rep:required}
115 * @param p_task_id Identifier of the task
116 * @rep:paraminfo {@rep:required}
117 * @param p_project_id Identifier of the project
118 * @rep:paraminfo {@rep:required}
119 * @param p_quantity Number of units of work performed
120 * @rep:paraminfo {@rep:required}
121 * @param p_incurred_by_person_id Identifier of the person who incurred the expenditure
122 * @rep:paraminfo {@rep:required}
123 * @param p_base_curr_code Transaction currency code of the base
124 * @rep:paraminfo {@rep:required}
125 * @param p_base_amount Base amount used to derive the
126 * transfer price. It could be either a raw cost, burdened cost, or raw revenue in
127 * the transaction currencies
128 * @rep:paraminfo {@rep:required}
129 * @param p_denom_tp_curr_code Transaction currency code in which
130 * transfer price is calculated
131 * @rep:paraminfo {@rep:required}
132 * @param p_denom_transfer_price Transfer price amount as calculated in
133 * the transaction currency
134 * @rep:paraminfo {@rep:required}
135 * @param x_denom_tp_curr_code Transaction currency code in which transfer price is calculated
136 * @rep:paraminfo {@rep:required}
137 * @param x_denom_transfer_price Transfer price as calculated in the
138 * transaction currency
139 * @rep:paraminfo {@rep:required}
140 * @param x_tp_bill_rate Bill rate applied to calculate the transfer price
141 * @rep:paraminfo {@rep:required}
142 * @param x_tp_bill_markup_percentage Percentage used to derive the transfer
143 * price if the transfer price was based on a markup
144 * @rep:paraminfo {@rep:required}
145 * @param x_error_message Error message text
146 * @rep:paraminfo {@rep:required}
147 * @param x_status Status indicating whether an error
148 * occurred. Valid values are:=0 Success, <0 Oracle Error
149 * >0 Application Error.
150 * @rep:paraminfo {@rep:required}
151 * @rep:scope public
152 * @rep:lifecycle active
153 * @rep:displayname Override Transfer Price
154 * @rep:compatibility S
155 */
156
157 PROCEDURE Override_Transfer_Price(
158 p_transaction_type IN Varchar2 DEFAULT 'ACTUAL', /** Added for Org Forecasting **/
159 p_prvdr_org_id IN Number,
160 p_prvdr_organization_id IN Number,
161 p_recvr_org_id IN Number,
162 p_recvr_organization_id IN Number,
163 p_expnd_organization_id IN Number,
164 p_expenditure_item_id IN Number,
165 p_expenditure_item_type IN Varchar2,
166 p_expenditure_type_class IN Varchar2,
167 p_task_id IN Number,
168 p_project_id IN Number,
169 p_quantity IN Number,
170 p_incurred_by_person_id IN Number,
171 p_base_curr_code IN Varchar2,
172 p_base_amount IN Number,
173 p_denom_tp_curr_code IN Varchar2,
174 p_denom_transfer_price IN Number,
175 x_denom_tp_curr_code OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
176 x_denom_transfer_price OUT NOCOPY Number, --File.Sql.39 bug 4440895
177 x_tp_bill_rate OUT NOCOPY Number, --File.Sql.39 bug 4440895
178 x_tp_bill_markup_percentage OUT NOCOPY Number, --File.Sql.39 bug 4440895
179 x_error_message OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
180 x_status OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
181 );
182
183 --------------------------------------------------------------------------------
184
185 END PA_CC_TP_CLIENT_EXTN;