eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PATCX

Source


1 PACKAGE PATCX AUTHID CURRENT_USER AS
2 /* $Header: PAXTTCXS.pls 120.4 2006/07/29 11:39:50 skannoji noship $ */
3 /*#
4  * Oracle Projects provides a template package that contains a procedure that you can modify to implement
5  * transaction control extensions. The name of the package is patcx. The name of the procedure is tc_extension.
6  * @rep:scope public
7  * @rep:product PA
8  * @rep:lifecycle active
9  * @rep:displayname Transaction Control Extension
10  * @rep:compatibility S
11  * @rep:category BUSINESS_ENTITY PA_PROJECT
12  * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14 
15 
16 /*#
17 * Procedure that can be modified to implement transaction control extensions
18 * @param X_project_id The identifier of the project
19 * @rep:paraminfo {@rep:required}
20 * @param X_task_id The identifier of the task
21 * @rep:paraminfo {@rep:required}
22 * @param X_expenditure_item_date The date of the expenditure item
23 * @rep:paraminfo {@rep:required}
24 * @param X_expenditure_type The type of expenditure
25 * @rep:paraminfo {@rep:required}
26 * @param X_non_labor_resource The nonlabor resource; for usage items only
27 * @rep:paraminfo {@rep:required}
28 * @param X_incurred_by_person_id The identifier of the person incurring the transaction
29 * @rep:paraminfo {@rep:required}
30 * @param X_quantity   The quantity of the transaction
31 * @rep:paraminfo {@rep:required}
32 * @param X_denom_currency_code The transaction currency code
33 * @rep:paraminfo {@rep:required}
34 * @param X_acct_currency_code The functional currency code
35 * @rep:paraminfo {@rep:required}
36 * @param X_denom_raw_cost   The transaction currency raw cost
37 * @rep:paraminfo {@rep:required}
38 * @param X_acct_raw_cost    The functional currency raw cost
39 * @rep:paraminfo {@rep:required}
40 * @param X_acct_rate_type The functional currency exchange rate type
41 * @rep:paraminfo {@rep:required}
42 * @param X_acct_rate_date The functional currency exchange rate date
43 * @rep:paraminfo {@rep:required}
44 * @param X_acct_exchange_rate The functional currency exchange rate
45 * @rep:paraminfo {@rep:required}
46 * @param X_transferred_from_id The identifier of the original expenditure item for which a new item is interfacing to a new project
47 * @rep:paraminfo {@rep:required}
48 * @param X_incurred_by_org_id The organization incurring the transaction
49 * @rep:paraminfo {@rep:required}
50 * @param X_nl_resource_org_id The identifier of the non labor resource organization; for usages only
51 * @rep:paraminfo {@rep:required}
52 * @param X_transaction_source The transaction source of items imported using Transaction Import
53 * @rep:paraminfo {@rep:required}
54 * @param X_calling_module   The module calling the extension
55 * @rep:paraminfo {@rep:required}
56 * @param X_vendor_id The identifier for the supplier transaction attribute
57 * @rep:paraminfo {@rep:required}
58 * @param X_entered_by_user_id The identifier of the user that entered the transaction
59 * @rep:paraminfo {@rep:required}
60 * @param X_attribute_category  Descriptive flexfield category
61 * @rep:paraminfo {@rep:required}
62 * @param X_attribute1 Descriptive flexfield segment
63 * @rep:paraminfo {@rep:required}
64 * @param X_attribute2 Descriptive flexfield segment
65 * @rep:paraminfo {@rep:required}
66 * @param X_attribute3 Descriptive flexfield segment
67 * @rep:paraminfo {@rep:required}
68 * @param X_attribute4 Descriptive flexfield segment
69 * @rep:paraminfo {@rep:required}
70 * @param X_attribute5 Descriptive flexfield segment
71 * @rep:paraminfo {@rep:required}
72 * @param X_attribute6 Descriptive flexfield segment
73 * @rep:paraminfo {@rep:required}
74 * @param X_attribute7 Descriptive flexfield segment
75 * @rep:paraminfo {@rep:required}
76 * @param X_attribute8 Descriptive flexfield segment
77 * @rep:paraminfo {@rep:required}
78 * @param X_attribute9 Descriptive flexfield segment
79 * @rep:paraminfo {@rep:required}
80 * @param X_attribute10 Descriptive flexfield segment
81 * @rep:paraminfo {@rep:required}
82 * @param X_attribute11 Descriptive flexfield segment
83 * @rep:paraminfo {@rep:required}
84 * @param X_attribute12 Descriptive flexfield segment
85 * @rep:paraminfo {@rep:required}
86 * @param X_attribute13 Descriptive flexfield segment
87 * @rep:paraminfo {@rep:required}
88 * @param X_attribute14 Descriptive flexfield segment
89 * @rep:paraminfo {@rep:required}
90 * @param X_attribute15 Descriptive flexfield segment
91 * @rep:paraminfo {@rep:required}
92 * @param X_msg_application The application short name for the custom application providing customized messages
93 * @rep:paraminfo {@rep:required}
94 * @param X_billable_flag Flag indicating whether or not a transaction is billable or capitalizable
95 * @rep:paraminfo {@rep:required}
96 * @param X_msg_type  Message type: W = warning message, E = error message
97 * @rep:paraminfo {@rep:required}
98 * @param X_msg_token1 Message tokens used in warning messages
99 * @rep:paraminfo {@rep:required}
100 * @param X_msg_token2 Message tokens used in warning messages
101 * @rep:paraminfo {@rep:required}
102 * @param X_msg_token3 Message tokens used in warning messages
103 * @rep:paraminfo {@rep:required}
104 * @param X_msg_count Total number of messages populated by the API
105 * @rep:paraminfo {@rep:required}
106 * @param X_outcome The outcome of the procedure
107 * @rep:paraminfo {@rep:required}
108 * @param p_projfunc_currency_code Identifier of the functional currency of the project-owning operating unit
109 * @rep:paraminfo {@rep:required}
110 * @param p_projfunc_cost_rate_type Identifier of the exchange rate type used to convert the
111 * transaction cost amounts to the project functional currency
112 * @rep:paraminfo {@rep:required}
113 * @param p_projfunc_cost_rate_date Identifier of the exchange rate date used to convert the
114 * transaction cost amounts to the project functional currency
115 * @rep:paraminfo {@rep:required}
116 * @param p_projfunc_cost_exchg_rate Identifier of the exchange rate used to convert the transaction
117 * cost amounts to the project functional currency
118 * @rep:paraminfo {@rep:required}
119 * @param x_assignment_id Identifier of the Project Resource Management assignment associated with the transaction
120 * @rep:paraminfo {@rep:required}
121 * @param p_work_type_id  Identifier of the work type assigned to the transaction
122 * @rep:paraminfo {@rep:required}
123 * @param p_sys_link_function Expenditure type class of the transaction
124 * @rep:paraminfo {@rep:required}
125 * @param p_po_header_id Purchase order header identifier for imported contingent worker labor transactions
126 * @rep:paraminfo {@rep:required}
127 * @param p_po_line_id Purchase order line identifier for imported contingent worker labor transactions
128 * @rep:paraminfo {@rep:required}
129 * @param p_person_type Person type identifier
130 * @rep:paraminfo {@rep:required}
131 * @param p_po_price_type Purchase order line price type for contingent worker labor transactions
132 * @rep:paraminfo {@rep:required}
133 * @param p_document_type The supplier cost document type
134 * @rep:paraminfo {@rep:required}
135 * @param p_document_line_type The supplier cost document line type
136 * @rep:paraminfo {@rep:required}
137 * @param p_document_dist_type The supplier cost document distribution type
138 * @rep:paraminfo {@rep:required}
139 * @param p_pa_ref_num1 For future use
140 * @rep:paraminfo {@rep:required}
141 * @param p_pa_ref_num2 For future use
142 * @rep:paraminfo {@rep:required}
143 * @param p_pa_ref_num3 For future use
144 * @rep:paraminfo {@rep:required}
145 * @param p_pa_ref_num4 For future use
146 * @rep:paraminfo {@rep:required}
147 * @param p_pa_ref_num5 For future use
148 * @rep:paraminfo {@rep:required}
149 * @param p_pa_ref_num6 For future use
150 * @rep:paraminfo {@rep:required}
151 * @param p_pa_ref_num7 For future use
152 * @rep:paraminfo {@rep:required}
153 * @param p_pa_ref_num8 For future use
154 * @rep:paraminfo {@rep:required}
155 * @param p_pa_ref_num9 For future use
156 * @rep:paraminfo {@rep:required}
157 * @param p_pa_ref_num10 For future use
158 * @rep:paraminfo {@rep:required}
159 * @param p_pa_ref_var1 For future use
160 * @rep:paraminfo {@rep:required}
161 * @param p_pa_ref_var2 For future use
162 * @rep:paraminfo {@rep:required}
163 * @param p_pa_ref_var3 For future use
164 * @rep:paraminfo {@rep:required}
165 * @param p_pa_ref_var4 For future use
166 * @rep:paraminfo {@rep:required}
167 * @param p_pa_ref_var5 For future use
168 * @rep:paraminfo {@rep:required}
169 * @param p_pa_ref_var6 For future use
170 * @rep:paraminfo {@rep:required}
171 * @param p_pa_ref_var7 For future use
172 * @rep:paraminfo {@rep:required}
173 * @param p_pa_ref_var8 For future use
174 * @rep:paraminfo {@rep:required}
175 * @param p_pa_ref_var9 For future use
176 * @rep:paraminfo {@rep:required}
177 * @param p_pa_ref_var10 For future use
178 * @rep:paraminfo {@rep:required}
179 * @rep:scope public
180 * @rep:lifecycle active
181 * @rep:displayname Transaction Control Extension
182 * @rep:compatibility S
183 */
184   PROCEDURE  tc_extension (
185               X_project_id               IN NUMBER
186             , X_task_id                  IN NUMBER
187             , X_expenditure_item_date    IN DATE
188             , X_expenditure_type         IN VARCHAR2
189             , X_non_labor_resource       IN VARCHAR2
190             , X_incurred_by_person_id    IN NUMBER
191             , X_quantity                 IN NUMBER   DEFAULT NULL
192             , X_denom_currency_code      IN VARCHAR2 DEFAULT NULL
193             , X_acct_currency_code       IN VARCHAR2 DEFAULT NULL
194             , X_denom_raw_cost           IN NUMBER   DEFAULT NULL
195             , X_acct_raw_cost            IN NUMBER   DEFAULT NULL
196             , X_acct_rate_type           IN VARCHAR2 DEFAULT NULL
197             , X_acct_rate_date           IN DATE     DEFAULT NULL
198             , X_acct_exchange_rate       IN NUMBER   DEFAULT NULL
199             , X_transferred_from_id      IN NUMBER   DEFAULT NULL
200             , X_incurred_by_org_id       IN NUMBER   DEFAULT NULL
201             , X_nl_resource_org_id       IN NUMBER   DEFAULT NULL
202             , X_transaction_source       IN VARCHAR2 DEFAULT NULL
203             , X_calling_module           IN VARCHAR2 DEFAULT NULL
204 	    , X_vendor_id	         IN NUMBER   DEFAULT NULL
205             , X_entered_by_user_id       IN NUMBER   DEFAULT NULL
206             , X_attribute_category       IN VARCHAR2 DEFAULT NULL
207             , X_attribute1               IN VARCHAR2 DEFAULT NULL
208             , X_attribute2               IN VARCHAR2 DEFAULT NULL
209             , X_attribute3               IN VARCHAR2 DEFAULT NULL
210             , X_attribute4               IN VARCHAR2 DEFAULT NULL
211             , X_attribute5               IN VARCHAR2 DEFAULT NULL
212             , X_attribute6               IN VARCHAR2 DEFAULT NULL
213             , X_attribute7               IN VARCHAR2 DEFAULT NULL
214             , X_attribute8               IN VARCHAR2 DEFAULT NULL
215             , X_attribute9               IN VARCHAR2 DEFAULT NULL
216             , X_attribute10              IN VARCHAR2 DEFAULT NULL
217 	    , X_attribute11              IN VARCHAR2 DEFAULT NULL
218             , X_attribute12              IN VARCHAR2 DEFAULT NULL
219             , X_attribute13              IN VARCHAR2 DEFAULT NULL
220             , X_attribute14              IN VARCHAR2 DEFAULT NULL
221             , X_attribute15              IN VARCHAR2 DEFAULT NULL
222             , X_msg_application      IN OUT NOCOPY VARCHAR2
223             , X_billable_flag        IN  OUT NOCOPY VARCHAR2
224             , X_msg_type                 OUT NOCOPY VARCHAR2
225             , X_msg_token1               OUT NOCOPY VARCHAR2
226             , X_msg_token2               OUT NOCOPY VARCHAR2
227             , X_msg_token3               OUT NOCOPY VARCHAR2
228             , X_msg_count                OUT NOCOPY NUMBER
229             , X_outcome                  OUT NOCOPY VARCHAR2
230             , P_projfunc_currency_code   IN VARCHAR2 default null
231             , P_projfunc_cost_rate_type  IN VARCHAR2 default null
232             , P_projfunc_cost_rate_date  IN DATE     default null
233             , P_projfunc_cost_exchg_rate IN NUMBER   default null
234             , X_assignment_id        IN  OUT NOCOPY NUMBER
235             , P_work_type_id             IN NUMBER   default null
236 	    , P_sys_link_function        IN VARCHAR2 default null
237             , P_Po_Header_Id             IN NUMBER   default null
238 	    , P_Po_Line_Id               IN NUMBER   default null
239 	    , P_Person_Type              IN VARCHAR2 default null
240 	    , P_Po_Price_Type            IN VARCHAR2 default null
241 		     , P_Document_Type           IN  VARCHAR2   default null -- Added these for R12
242 		     , P_Document_Line_Type      IN  VARCHAR2   default null
243 		     , P_Document_Dist_Type      IN  VARCHAR2   default null
244 		     , P_pa_ref_num1             IN  NUMBER     default null
245 		     , P_pa_ref_num2             IN  NUMBER     default null
246 		     , P_pa_ref_num3             IN  NUMBER     default null
247 		     , P_pa_ref_num4             IN  NUMBER     default null
248 		     , P_pa_ref_num5             IN  NUMBER     default null
249 		     , P_pa_ref_num6             IN  NUMBER     default null
250 		     , P_pa_ref_num7             IN  NUMBER     default null
251 		     , P_pa_ref_num8             IN  NUMBER     default null
252 		     , P_pa_ref_num9             IN  NUMBER     default null
253 		     , P_pa_ref_num10            IN  NUMBER     default null
254 		     , P_pa_ref_var1             IN  VARCHAR2   default null
255 		     , P_pa_ref_var2             IN  VARCHAR2   default null
256 		     , P_pa_ref_var3             IN  VARCHAR2   default null
257 		     , P_pa_ref_var4             IN  VARCHAR2   default null
258 		     , P_pa_ref_var5             IN  VARCHAR2   default null
259 		     , P_pa_ref_var6             IN  VARCHAR2   default null
260 		     , P_pa_ref_var7             IN  VARCHAR2   default null
261 		     , P_pa_ref_var8             IN  VARCHAR2   default null
262 		     , P_pa_ref_var9             IN  VARCHAR2   default null
263 		     , P_pa_ref_var10            IN  VARCHAR2   default null)  ;
264 
265 
266 END  PATCX;