[Home] [Help]
PACKAGE: APPS.XLA_CMP_ANALYTIC_CRITERIA_PKG
Source
1 PACKAGE xla_cmp_analytic_criteria_pkg AS
2 /* $Header: xlacpanc.pkh 120.5 2005/07/12 22:25:17 awan 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_analytic_criteria_pkg |
10 | |
11 | DESCRIPTION |
12 | This is a XLA private package, which contains all the logic required |
13 | to generate anlytical criteria from AMB specifcations |
14 | |
15 | |
16 | HISTORY |
17 | 10-JAN-2003 K.Boussema Created |
18 | 14-JAN-2003 K.Boussema Added 'dbdrv' command |
19 | 01-APR-2003 K.Boussema Included amb_context_code |
20 | update according to the new datamodel |
21 | 22-APR-2003 K.Boussema Included Error messages |
22 | 17-JUL-2003 K.Boussema Reviewd the code |
23 | 07-Mar-2005 K.Boussema Changed for ADR-enhancements. |
24 | 11-Jul-2005 A.Wan Changed for MPA bug 4262811 |
25 +===========================================================================*/
26
27 /*---------------------------------------------------------------------------+
28 | |
29 | |
30 | Public Function |
31 | |
32 | GetAnalyticalCriteriaSources |
33 | |
34 | Returns the list of sources defined the AMB header analytical criteria. |
35 | |
36 +---------------------------------------------------------------------------*/
37
38 PROCEDURE GetAnalyticalCriteriaSources (
39 p_entity IN VARCHAR2
40 , p_event_class IN VARCHAR2
41 , p_event_type IN VARCHAR2
42 , p_application_id IN NUMBER
43 , p_product_rule_code IN VARCHAR2
44 , p_product_rule_type_code IN VARCHAR2
45 , p_amb_context_code IN VARCHAR2
46 , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
47 , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
48 )
49 ;
50
51 /*---------------------------------------------------------------------------+
52 | |
53 | |
54 | Public Function |
55 | |
56 | GenerateHdrAnalyticCriteria |
57 | |
58 | Translates the AMB header analytical criteria into PL/SQL code. |
59 | |
60 +---------------------------------------------------------------------------*/
61
62
63 FUNCTION GenerateHdrAnalyticCriteria(
64 p_application_id IN NUMBER
65 , p_product_rule_code IN VARCHAR2
66 , p_product_rule_type_code IN VARCHAR2
67 , p_amb_context_code IN VARCHAR2
68 , p_entity IN VARCHAR2
69 , p_event_class IN VARCHAR2
70 , p_event_type IN VARCHAR2
71 , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
72 )
73 RETURN CLOB
74 ;
75
76 /*---------------------------------------------------------------------------+
77 | |
78 | |
79 | Public Procedure |
80 | |
81 | GenerateMpaHeaderAC - 4262811 |
82 | |
83 | |
84 +---------------------------------------------------------------------------*/
85
86 FUNCTION GenerateMpaHeaderAC(
87 p_application_id IN NUMBER
88 , p_amb_context_code IN VARCHAR2
89 , p_event_class IN VARCHAR2
90 , p_event_type IN VARCHAR2
91 , p_line_definition_owner_code IN VARCHAR2
92 , p_line_definition_code IN VARCHAR2
93 , p_accrual_jlt_owner_code IN VARCHAR2
94 , p_accrual_jlt_code IN VARCHAR2
95 , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
96 , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
97 )
98 RETURN CLOB
99 ;
100
101
102 /*---------------------------------------------------------------------------+
103 | |
104 | |
105 | Public Procedure |
106 | |
107 | GenerateMpaLineAC - 4262811 |
108 | |
109 | |
110 +---------------------------------------------------------------------------*/
111
112 FUNCTION GenerateMpaLineAC(
113 p_application_id IN NUMBER
114 , p_amb_context_code IN VARCHAR2
115 , p_event_class IN VARCHAR2
116 , p_event_type IN VARCHAR2
117 , p_line_definition_owner_code IN VARCHAR2
118 , p_line_definition_code IN VARCHAR2
119 , p_accrual_jlt_owner_code IN VARCHAR2
120 , p_accrual_jlt_code IN VARCHAR2
121 , p_mpa_jlt_owner_code IN VARCHAR2
122 , p_mpa_jlt_code IN VARCHAR2
123 , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
124 , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
125 )
126 RETURN CLOB
127 ;
128 /*---------------------------------------------------------------------------+
129 | |
130 | |
131 | Public Procedure |
132 | |
133 | GenerateLineAnalyticCriteria |
134 | |
135 | Translates the AMB line analytical criteria into PL/SQL code. |
136 | |
137 +---------------------------------------------------------------------------*/
138
139 FUNCTION GenerateLineAnalyticCriteria(
140 p_application_id IN NUMBER
141 , p_amb_context_code IN VARCHAR2
142 , p_event_class IN VARCHAR2
143 , p_event_type IN VARCHAR2
144 , p_line_definition_owner_code IN VARCHAR2
145 , p_line_definition_code IN VARCHAR2
146 , p_accounting_line_type_code IN VARCHAR2
147 , p_accounting_line_code IN VARCHAR2
148 , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
149 , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
150 )
151 RETURN CLOB
152 ;
153 --
154 END xla_cmp_analytic_criteria_pkg; -- end of package spec