[Home] [Help]
PACKAGE: APPS.XLA_BALANCES_CALC_PKG
Source
1 PACKAGE xla_balances_calc_pkg AUTHID CURRENT_USER as
2 /* $Header: xlabacalc.pkh 120.7 2011/03/08 14:03:59 karamakr noship $ */
3
4 TYPE t_array_varchar IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
5
6 C_IS_CONTROL_ACCOUNT CONSTANT INTEGER := 0;
7 C_NOT_CONTROL_ACCOUNT CONSTANT INTEGER := 1;
8 C_IS_CONTROL_ACCOUNT_OTHER_APP CONSTANT INTEGER := 2;
9 C_ERR_CONTROL_ACCOUNT CONSTANT INTEGER := 3;
10
11 --
12 --
13 FUNCTION calculate_balances ( p_application_id IN INTEGER
14 , p_ledger_id IN INTEGER
15 , p_entity_id IN INTEGER
16 , p_event_id IN INTEGER
17 , p_ae_header_id IN INTEGER
18 , p_ae_line_num IN INTEGER
19 , p_request_id IN INTEGER
20 , p_accounting_batch_id IN INTEGER
21 , p_update_mode IN VARCHAR2
22 , p_execution_mode IN VARCHAR2
23 )
24 RETURN BOOLEAN;
25
26 PROCEDURE open_period_srs (
27 p_errbuf OUT NOCOPY VARCHAR2
28 , p_retcode OUT NOCOPY NUMBER
29 , p_application_id IN NUMBER
30 , p_ledger_id IN NUMBER
31 , p_period_name IN VARCHAR2
32 );
33
34 PROCEDURE massive_update_srs (
35 p_errbuf OUT NOCOPY VARCHAR2,
36 p_retcode OUT NOCOPY NUMBER,
37 p_application_id IN NUMBER,
38 p_ledger_id IN NUMBER,
39 p_accounting_batch_id IN NUMBER,
40 p_update_mode IN VARCHAR2
41 );
42
43 FUNCTION massive_update (
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 )
53 RETURN BOOLEAN;
54
55 FUNCTION single_update
56 (
57 p_application_id IN INTEGER
58 ,p_ae_header_id IN INTEGER
59 ,p_ae_line_num IN INTEGER
60 ,p_update_mode IN VARCHAR2
61 ) RETURN BOOLEAN;
62
63 FUNCTION lock_bal_concurrency_control (
64 p_application_id IN INTEGER
65 , p_ledger_id IN INTEGER
66 , p_entity_id IN INTEGER
67 , p_event_id IN INTEGER
68 , p_ae_header_id IN INTEGER
69 , p_ae_line_num IN INTEGER
70 , p_request_id IN INTEGER
71 , p_accounting_batch_id IN INTEGER
72 , p_execution_mode IN VARCHAR2
73 , p_concurrency_class IN VARCHAR2
74 )
75 RETURN BOOLEAN;
76
77 FUNCTION is_control_account
78 ( p_code_combination_id IN INTEGER
79 ,p_natural_account IN VARCHAR2
80 ,p_ledger_id IN INTEGER
81 ,p_application_id IN INTEGER
82 ) RETURN INTEGER;
83
84 --bug-11666797
85 PROCEDURE sr_bal_unprocessed(p_application_id IN INTEGER
86 ,p_ledger_id IN INTEGER
87 ,p_code_combination_id IN INTEGER
88 ,p_anacri_code IN VARCHAR2
89 ,p_anacri_type_code IN VARCHAR2
90 ,p_amb_context_code IN VARCHAR2
91 ,p_ac1 IN VARCHAR2
92 ,p_ac2 IN VARCHAR2
93 ,p_ac3 IN VARCHAR2
94 ,p_ac4 IN VARCHAR2
95 ,p_ac5 IN VARCHAR2
96 ,p_eff_period_num_from IN INTEGER
97 ,p_eff_period_num_to IN INTEGER
98 ,p_unprocessed_flag OUT NOCOPY VARCHAR2
99 );
100 --
101 --
102 END xla_balances_calc_pkg;