DBA Data[Home] [Help]

PACKAGE: APPS.XLA_BALANCES_PKG

Source


1 PACKAGE xla_balances_pkg AS
2 /* $Header: xlabacom.pkh 120.15.12010000.4 2008/12/24 17:11:18 svellani ship $ */
3 /*======================================================================+
4 |             Copyright (c) 1995-2002 Oracle Corporation                |
5 |                       Redwood Shores, CA, USA                         |
6 |                         All rights reserved.                          |
7 +=======================================================================+
8 | PACKAGE NAME                                                          |
9 |    xla_balances_pkg                                                   |
10 |                                                                       |
11 | DESCRIPTION                                                           |
12 |    XLA Balance Calculation Package                                    |
13 |                                                                       |
14 | HISTORY                                                               |
15 |    27-AUG-02 A.Quaglia      Created                                   |
16 |    31-OCT-03 A.Quaglia      Bug3202694:                               |
17 |                             massive_update:                           |
18 |                                added p_entity_id                      |
19 |                                old, deprecated API maintained until   |
20 |                                uptake is done.                        |
21 |    26-NOV-03 A.Quaglia      Bug3264347:                               |
22 |                             massive_update_srs:                       |
23 |                                new param p_dummy                      |
24 |    29-JUL-04 A.Quaglia      Bug3202694:                               |
25 |                             massive_update:                           |
26 |                                removed deprecated API                 |
27 |                                                                       |
28 |                                                                       |
29 +======================================================================*/
30 
31 TYPE t_array_varchar   IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;  -- bug 7441310
32 
33 FUNCTION single_update
34   (
35     p_application_id          IN INTEGER
36    ,p_ae_header_id            IN INTEGER
37    ,p_ae_line_num             IN INTEGER
38    ,p_update_mode             IN VARCHAR2
39   ) RETURN BOOLEAN;
40 
41 
42 FUNCTION massive_update
43   (
44     p_application_id          IN INTEGER
45    ,p_ledger_id               IN INTEGER
46    ,p_entity_id               IN INTEGER
47    ,p_event_id                IN INTEGER
48    ,p_request_id              IN INTEGER
49    ,p_accounting_batch_id     IN INTEGER
50    ,p_update_mode             IN VARCHAR2
51    ,p_execution_mode          IN VARCHAR2
52   ) RETURN BOOLEAN;
53 
54 
55 FUNCTION massive_update_for_events(
56    p_application_id           IN INTEGER) RETURN BOOLEAN;
57 
58 PROCEDURE massive_update_srs
59                         ( p_errbuf               OUT NOCOPY VARCHAR2
60                          ,p_retcode              OUT NOCOPY NUMBER
61                          ,p_application_id       IN         NUMBER
62                          ,p_dummy                IN         VARCHAR2
63                          ,p_ledger_id            IN         NUMBER
64                          ,p_accounting_batch_id  IN         NUMBER
65                          ,p_update_mode          IN         VARCHAR2
66                         );
67 
68 
69 
70 
71 
72 FUNCTION recreate
73   ( p_application_id             IN INTEGER
74    ,p_ledger_id                  IN INTEGER
75    ,p_party_type_code            IN VARCHAR2
76    ,p_party_id                   IN INTEGER
77    ,p_party_site_id              IN INTEGER
78    ,p_starting_period_name       IN VARCHAR2
79    ,p_account_segment_value_low  IN VARCHAR2
80    ,p_account_segment_value_high IN VARCHAR2
81   ) RETURN BOOLEAN;
82 
83 PROCEDURE recreate_srs
84                      ( p_errbuf                     OUT NOCOPY VARCHAR2
85                       ,p_retcode                    OUT NOCOPY NUMBER
86                       ,p_application_id             IN         INTEGER
87                       ,p_ledger_id                  IN         INTEGER
88                       ,p_party_type_code            IN         VARCHAR2
89                       ,p_party_id                   IN         INTEGER
90                       ,p_party_site_id              IN         INTEGER
91                       ,p_starting_period_name       IN         VARCHAR2
92                       ,p_account_segment_value_low  IN         VARCHAR2
93                       ,p_account_segment_value_high IN         VARCHAR2
94                      );
95 
96 
97 
98 
99 FUNCTION synchronize
100   ( p_chart_of_accounts_id       IN INTEGER
101    ,p_account_segment_value      IN VARCHAR2
102   ) RETURN BOOLEAN;
103 
104 
105 FUNCTION open_period
106   ( p_ledger_id                  IN INTEGER
107   ) RETURN BOOLEAN;
108 
109 PROCEDURE open_period_srs
110                         ( p_errbuf       OUT NOCOPY VARCHAR2
111                          ,p_retcode      OUT NOCOPY NUMBER
112                          ,p_ledger_id    IN         NUMBER
113                         );
114 
115 
116 FUNCTION initialize
117   ( p_application_id             IN INTEGER
118    ,p_ledger_id                  IN INTEGER
119    ,p_code_combination_id        IN INTEGER
120    ,p_party_type_code            IN VARCHAR2
121    ,p_party_id                   IN INTEGER
122    ,p_party_site_id              IN INTEGER
123    ,p_period_name                IN VARCHAR2
124    ,p_new_beginning_balance_dr   IN NUMBER
125    ,p_new_beginning_balance_cr   IN NUMBER
126   ) RETURN BOOLEAN;
127 
128 
129  FUNCTION open_period_event
130    ( p_subscription_guid IN     raw
131     ,p_event             IN OUT NOCOPY WF_EVENT_T)
132  RETURN VARCHAR2;
133 
134 
135 END xla_balances_pkg;