[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