DBA Data[Home] [Help]

PACKAGE: APPS.XLA_TAB_PKG

Source


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;