1 PACKAGE xla_tab_pkg AS
2 /* $Header: xlatbtab.pkh 120.0 2004/05/28 14:29:43 aquaglia ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_tab_pkg |
10 | |
11 | DESCRIPTION |
12 | Transaction Account Builder Engine hook |
13 | |
14 | HISTORY |
15 | 18-FEB-04 A.Quaglia Created |
16 | |
17 | |
18 | |
19 | |
20 | |
21 | |
22 | |
23 +======================================================================*/
24
25
26 /*======================================================================+
27 | |
28 | Public Procedure |
29 | |
30 | run |
31 | |
32 | This program is called by the public wrapper xla_tab_pub_pkg.run. |
33 | It reads the current AMB Context Code from the profile option |
34 | SLA: Accounting Methods Builder Context. |
35 | It checks whether the specified Transaction Account Definition |
36 | exists and reads the corresponding hash id. |
37 | If Transaction Account Definition is not compiled it tries to |
38 | compile it once. |
39 | It builds the package name corrersponding to the Transaction |
40 | Account Definition specified in the input parameters. |
41 | It invokes, through dynamic SQL, the trans_account_def_online or |
42 | the trans_account_def_batch procedure of the generated Transaction |
43 | Account Definition package. The procedure will then process the |
44 | data loaded into the Transaction Account Builder Interface. |
45 | |
46 | The OUT parameter x_return_status can have the following values: |
47 | FND_API.G_RET_STS_SUCCESS; |
48 | FND_API.G_RET_STS_ERROR; |
49 | FND_API.G_RET_STS_UNEXP_ERROR; |
50 | The other OUT parameters follow the FND API standard. |
51 | |
52 +======================================================================*/
53
54
55 PROCEDURE run
56 (
57 p_api_version IN NUMBER
58 ,p_application_id IN NUMBER
59 ,p_account_definition_type_code IN VARCHAR2
60 ,p_account_definition_code IN VARCHAR2
61 ,p_transaction_coa_id IN NUMBER
62 ,p_mode IN VARCHAR2
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 END xla_tab_pkg;