DBA Data[Home] [Help]

PACKAGE: APPS.XLA_CMP_ACCT_LINE_TYPE_PKG

Source


1 PACKAGE xla_cmp_acct_line_type_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacpalt.pkh 120.14.12000000.1 2007/01/16 21:06:22 appldev ship $   */
3 /*===========================================================================+
4 |             Copyright (c) 2001-2002 Oracle Corporation                     |
5 |                       Redwood Shores, CA, USA                              |
6 |                         All rights reserved.                               |
7 +============================================================================+
8 | PACKAGE NAME                                                               |
9 |     xla_cmp_acct_line_type_pkg                                             |
10 |                                                                            |
11 | DESCRIPTION                                                                |
12 |     This is a XLA private package, which contains all the logic required   |
13 |     to generate Accounting line type procedures from AMB specifcations     |
14 |                                                                            |
15 |                                                                            |
16 | HISTORY                                                                    |
17 |     15-JUN-2002 K.Boussema  Created                                        |
18 |     18-FEB-2003 K.Boussema  Added 'dbdrv' command                          |
19 |     21-FEB-2003 K.Boussela  Changed GenerateAcctLineType function          |
20 |     13-MAR-2003 K.Boussema    Made changes for the new bulk approach of the|
21 |                               accounting engine                            |
22 |     19-MAR-2003 K.Boussema    Added amb_context_code column                |
23 |     22-APR-2003 K.Boussema    Included error messages                      |
24 |     17-JUL-2003 K.Boussema    Reviewd the code                             |
25 |     18-DEC-2003 K.Boussema    Changed to fix bug 3042840,3307761,3268940   |
26 |                               3310291 and 3320689                          |
27 |     07-Mar-2005 K.Boussema    Changed for ADR-enhancements.                |
28 |     11-Jul-2005 A.Wan         Changed for MPA.  4262811                    |
29 |     31-Jan-2006 A.Wan         4655713 - inherit ADR for same entry         |
30 +===========================================================================*/
31 
32 /*------------------------------------------------------------+
33 |                                                             |
34 |  Public Function                                            |
35 |                                                             |
36 |       GetALTOption                                          |
37 |                                                             |
38 |  Bug 4262811 - existing function.  Make it public.          |
39 |                                                             |
40 +------------------------------------------------------------*/
41 FUNCTION GetALTOption   (
42   p_acct_entry_type_code         IN VARCHAR2
43 , p_gain_or_loss_flag            IN VARCHAR2
44 , p_natural_side_code            IN VARCHAR2
45 , p_transfer_mode_code           IN VARCHAR2
46 , p_switch_side_flag             IN VARCHAR2
47 , p_merge_duplicate_code         IN VARCHAR2
48 )
49 RETURN VARCHAR2
50 ;
51 
52 /*------------------------------------------------------------+
53 |                                                             |
54 |  Public Function                                            |
55 |                                                             |
56 |       GetAcctClassCode                                      |
57 |                                                             |
58 |  Bug 4262811 - existing function.  Make it public.          |
59 |                                                             |
60 +------------------------------------------------------------*/
61 FUNCTION GetAcctClassCode   (
62   p_accounting_class_code        IN VARCHAR2
63 )
64 RETURN VARCHAR2
65 ;
66 
67 /*------------------------------------------------------------+
68 |                                                             |
69 |  Public Function                                            |
70 |                                                             |
71 |       GetRoundingClassCode                                  |
72 |                                                             |
73 |  Bug 4262811 - existing function.  Make it public.          |
74 |                                                             |
75 +------------------------------------------------------------*/
76 FUNCTION GetRoundingClassCode   (
77   p_rounding_class_code        IN VARCHAR2
78 )
79 RETURN VARCHAR2
80 ;
81 
82 /*------------------------------------------------------------+
83 |                                                             |
84 |  Public Function                                            |
85 |                                                             |
86 |       GenerateCallDescription                               |
87 |                                                             |
88 |  Bug 4262811 - existing function.  Make it public.          |
89 |                                                             |
90 +------------------------------------------------------------*/
91 FUNCTION GenerateCallDescription  (
92   p_application_id               IN NUMBER
93 , p_description_type_code        IN VARCHAR2
94 , p_description_code             IN VARCHAR2
95 , p_header_line                  IN VARCHAR2
96 , p_array_alt_source_index       IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
97 , p_rec_aad_objects              IN xla_cmp_source_pkg.t_rec_aad_objects
98 , p_rec_sources                  IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
99 )
100 RETURN CLOB
101 ;
102 
103 /*---------------------------------------------------------+
104 |                                                          |
105 |  Public  Function                                        |
106 |                                                          |
107 |  GenerateADRCalls - 4262811                              |
108 |                                                          |
109 |                                                          |
110 +----------------------------------------------------------*/
111 
112 FUNCTION GenerateADRCalls  (
113   p_application_id               IN NUMBER
114 , p_entity_code                  IN VARCHAR2
115 , p_event_class_code             IN VARCHAR2
116 , p_array_adr_type_code          IN xla_cmp_source_pkg.t_array_VL1
117 , p_array_adr_code               IN xla_cmp_source_pkg.t_array_VL30
118 , p_array_adr_segment_code       IN xla_cmp_source_pkg.t_array_VL30
119 , p_array_side_code              IN xla_cmp_source_pkg.t_array_VL30
120 , p_array_adr_appl_id            IN xla_cmp_source_pkg.t_array_NUM
121 , p_array_inherit_adr_flag       IN xla_cmp_source_pkg.t_array_VL1
122 , p_bflow_method_code            IN VARCHAR2  -- 4655713
123 , p_array_accounting_coa_id      IN xla_cmp_source_pkg.t_array_NUM
124 , p_array_transaction_coa_id     IN xla_cmp_source_pkg.t_array_NUM
125 , p_array_alt_source_index       IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
126 , p_rec_aad_objects              IN            xla_cmp_source_pkg.t_rec_aad_objects
127 , p_rec_sources                  IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
128 )
129 RETURN  CLOB
130 ;
131 
132 /*------------------------------------------------------------+
133 |                                                             |
134 |  Public Function                                            |
135 |                                                             |
136 |       GenerateAcctLineType                                  |
137 |                                                             |
138 |  Generates the AcctLineType_XXX() functions from the AMB    |
139 |  Journal line types assigned to the AAD.                    |
140 |  It returns TRUE if generation succeeds, FALSE otherwise    |
141 |                                                             |
142 +------------------------------------------------------------*/
143 
144 FUNCTION GenerateAcctLineType(
145   p_product_rule_code            IN VARCHAR2
146 , p_product_rule_type_code       IN VARCHAR2
147 , p_application_id               IN NUMBER
148 , p_amb_context_code             IN VARCHAR2
149 , p_package_name                 IN VARCHAR2
150 --
151 , p_rec_aad_objects              IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
152 , p_rec_sources                  IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
153 --
154 , p_package_body                 OUT NOCOPY DBMS_SQL.VARCHAR2S
155 )
156 RETURN BOOLEAN
157 ;
158 
159 
160 
161 END xla_cmp_acct_line_type_pkg; -- end of package spec