[Home] [Help]
PACKAGE: APPS.XLA_ACCOUNTING_ENGINE_PKG
Source
1 PACKAGE xla_accounting_engine_pkg AS
2 /* $Header: xlajeaex.pkh 120.11 2005/08/02 02:32:27 wychan ship $ */
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_accounting_engine_pkg |
10 | |
11 | DESCRIPTION |
12 | |
13 | |
14 | HISTORY |
15 | 20-NOV-2002 K.Boussema Created |
16 | 10-JAN-2003 K.Boussema Added 'dbdrv' command |
17 | 20-FEB-2003 K.Boussema Made changes for the new bulk approach of the|
18 | accounting engine |
19 | 19-APR-2003 K.Boussema Included Error messages |
20 | 22-JUL-2003 K.Boussema Added the update of journal entries |
21 | 01-DEC-2003 K.Boussema Added CacheExtractErrors to cache the extract|
22 | errors |
23 | 03-FEB-2004 K.Boussema Added CacheExtractObject proc. and changed |
24 | CacheExtractErrors procedure |
25 | 26-Jul-2004 W. Shen Add a new parameter to CacheExtractErrors |
26 | if it is called from transaction reversal |
27 | The line count is 0 or null is not treated |
28 | as an error. |
29 | bug 3786968. |
30 | 06-Oct-2004 K.Boussema Made changes for the Accounting Event Extract|
31 | Diagnostics feature. |
32 | 11-Jul-2005 A.Wan Changd for MPA. 4262811 |
33 +===========================================================================*/
34 --
35 --
36 /*======================================================================+
37 | |
38 | Global Variables |
39 | |
40 | |
41 +======================================================================*/
42 --
43 --
44 -- cache the events in error
45 --
46 g_array_event_ids xla_ae_journal_entry_pkg.t_array_Num;
47 g_array_event_status xla_ae_journal_entry_pkg.t_array_V1L;
48 --
49 g_diagnostics_mode VARCHAR2(1);
50 --
51 /*======================================================================+
52 | |
53 | PUBLIC Procedure |
54 | |
55 | CacheExtractErrors |
56 | |
57 +======================================================================*/
58 --
59 PROCEDURE CacheExtractErrors(
60 p_hdr_rowcount IN NUMBER DEFAULT NULL
61 ,p_line_rowcount IN NUMBER DEFAULT NULL
62 ,p_trx_reversal_flag IN VARCHAR2 DEFAULT NULL
63 )
64 ;
65 --
66 /*======================================================================+
67 | |
68 | PUBLIC Procedure |
69 | |
70 | CacheExtractObjects |
71 | |
72 +======================================================================*/
73 --
74 PROCEDURE CacheExtractObject(
75 p_object_name IN VARCHAR2
76 , p_object_level IN VARCHAR2
77 , p_event_class IN VARCHAR2
78 , p_entity_id IN NUMBER
79 , p_event_id IN NUMBER
80 , p_ledger_id IN NUMBER
81 )
82 ;
83 --
84 /*======================================================================+
85 | |
86 | Public Function |
87 | AccountingEngine |
88 | |
89 | PARAMETERS |
90 | 1 IN p_application_id NUMBER application id |
91 | 2 IN p_ledger_id NUMBER ledger id |
92 | 3 IN p_accounting_mode NUMBER accounting mode |
93 | 4 IN p_accounting_batch_id NUMBER accounting batch id |
94 | |
95 | RETURN NUMBER |
96 | 0 - if journal entries created and valid |
97 | 1 - if journal entries created and invalid |
98 | 2 - if no journal entries are created |
99 +======================================================================*/
100 FUNCTION AccountingEngine (
101 p_application_id IN NUMBER
102 , p_ledger_id IN NUMBER
103 , p_end_date IN DATE -- 4262811
104 , p_accounting_mode IN VARCHAR2
105 , p_accounting_batch_id IN NUMBER
106 , p_budgetary_control_mode IN VARCHAR2 -- 4458381
107 )
108 RETURN NUMBER;
109 --
110 --
111 END xla_accounting_engine_pkg; -- end of package spec