PACKAGE: APPS.XLA_TB_DATA_MANAGER_PVT

Source

1 PACKAGE XLA_TB_DATA_MANAGER_PVT AS
2 /* $Header: xlatbdmg.pkh 120.7.12010000.2 2008/09/04 12:03:38 rajose 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_ledger_id                IN  NUMBER
44    ,p_group_id                 IN  NUMBER
45    ,p_definition_code          IN  VARCHAR2  DEFAULT NULL
46    ,p_process_mode_code        IN  VARCHAR2
47    ,p_je_source_name           IN  VARCHAR2  DEFAULT NULL
48    ,p_upg_batch_id             IN  NUMBER    DEFAULT NULL
49    ,p_gl_date_from             IN  VARCHAR2  DEFAULT NULL
50    ,p_gl_date_to               IN  VARCHAR2  DEFAULT NULL
51    );
52 
53 PROCEDURE worker_process
54   (p_errbuf            OUT NOCOPY VARCHAR2
55   ,p_retcode           OUT NOCOPY NUMBER
56   ,p_ledger_id         IN  NUMBER
57   ,p_group_id          IN  NUMBER
58   ,p_definition_code   IN  VARCHAR2
59   ,p_parent_request_id IN  PLS_INTEGER
60   ,p_je_source_name    IN VARCHAR2 --bug#7320079
61   );
62 
63 PROCEDURE add_partition (p_definition_code  IN VARCHAR2 );
64 
65 PROCEDURE drop_partition (p_definition_code IN VARCHAR2);
66 
67 PROCEDURE delete_non_ui_rows (p_definition_code IN VARCHAR2);
68 
69 PROCEDURE delete_trial_balances
70   (p_definition_code  IN VARCHAR2);
71 
72 PROCEDURE delete_trial_balances
73   (p_application_id   IN NUMBER
74   ,p_ae_header_id     IN NUMBER);
75 
76 PROCEDURE recreate_trial_balances
77   (p_application_id   IN NUMBER
78   ,p_ae_header_id     IN NUMBER);
79 
80 END XLA_TB_DATA_MANAGER_PVT;