[Home] [Help]
PACKAGE: APPS.XLA_TB_DATA_MANAGER_PVT
Source
1 PACKAGE XLA_TB_DATA_MANAGER_PVT AUTHID CURRENT_USER AS
2 /* $Header: xlatbdmg.pkh 120.7.12010000.3 2009/02/20 12:05:35 nksurana ship $ */
3
4 TYPE r_definition_info IS RECORD
5 (definition_code VARCHAR2(30)
6 ,ledger_id NUMBER(15)
7 ,je_source_name VARCHAR2(30)
8 ,enabled_flag VARCHAR2(1)
9 ,balance_side_code VARCHAR2(30)
10 ,defined_by_code VARCHAR2(30)
11 ,definition_status_code VARCHAR2(30)
12 ,owner_code VARCHAR2(30));
13
14 TYPE r_ledger_info IS RECORD
15 (ledger_id NUMBER(15)
16 ,ledger_name VARCHAR2(30)
17 ,ledger_short_name VARCHAR2(20)
18 ,ledger_category_code VARCHAR2(30)
19 ,currency_code VARCHAR2(15)
20 ,coa_id NUMBER(15)
21 ,object_type_code VARCHAR2(1)
22 ,processes PLS_INTEGER
23 ,processing_unit PLS_INTEGER
24 );
25
26 FUNCTION get_report_definition
27 (p_definition_code IN VARCHAR2)
28 RETURN r_definition_info;
29
30 FUNCTION get_ledger_info
31 (p_ledger_id IN NUMBER)
32 RETURN r_ledger_info;
33
34 PROCEDURE define_segment_ranges
35 (p_definition_code VARCHAR2 );
36
37 --
38 -- p_gl_date_from/to needs to be VARCHAR
39 --
40 PROCEDURE upload
41 (p_errbuf IN OUT NOCOPY VARCHAR2
42 ,p_retcode IN OUT NOCOPY NUMBER
43 ,p_application_id IN NUMBER DEFAULT NULL
44 ,p_ledger_id IN NUMBER
45 ,p_group_id IN NUMBER
46 ,p_definition_code IN VARCHAR2 DEFAULT NULL
47 ,p_process_mode_code IN VARCHAR2
48 ,p_je_source_name IN VARCHAR2 DEFAULT NULL
49 ,p_upg_batch_id IN NUMBER DEFAULT NULL
50 ,p_gl_date_from IN VARCHAR2 DEFAULT NULL
51 ,p_gl_date_to IN VARCHAR2 DEFAULT NULL
52 );
53
54 PROCEDURE worker_process
55 (p_errbuf OUT NOCOPY VARCHAR2
56 ,p_retcode OUT NOCOPY NUMBER
57 ,p_ledger_id IN NUMBER
58 ,p_group_id IN NUMBER
59 ,p_definition_code IN VARCHAR2
60 ,p_parent_request_id IN PLS_INTEGER
61 ,p_je_source_name IN VARCHAR2 --bug#7320079
62 );
63
64 PROCEDURE add_partition (p_definition_code IN VARCHAR2 );
65
66 PROCEDURE drop_partition (p_definition_code IN VARCHAR2);
67
68 PROCEDURE delete_non_ui_rows (p_definition_code IN VARCHAR2);
69
70 PROCEDURE delete_trial_balances
71 (p_definition_code IN VARCHAR2);
72
73 PROCEDURE delete_trial_balances
74 (p_application_id IN NUMBER
75 ,p_ae_header_id IN NUMBER);
76
77 PROCEDURE recreate_trial_balances
78 (p_application_id IN NUMBER
79 ,p_ae_header_id IN NUMBER);
80
81 END XLA_TB_DATA_MANAGER_PVT;