DBA Data[Home] [Help]

PACKAGE: APPS.GMF_XLA_PKG

Source


1 PACKAGE GMF_XLA_PKG AS
2 /* $Header: GMFXLAPS.pls 120.3.12010000.1 2008/07/30 05:36:16 appldev ship $ */
3 
4   FUNCTION create_event
5   (
6       p_reference_no       IN           NUMBER
7     , p_legal_entity_id    IN           NUMBER
8     , p_ledger_id          IN           NUMBER
9     , x_errbuf             OUT NOCOPY   VARCHAR2
10   )
11     RETURN NUMBER
12   ;
13 
14   PROCEDURE update_extract_lines_table;
15   PROCEDURE update_extract_headers_table;
16   /* Bug 5668308: Added entity code as parameter to insert_into_xla_events_gt fn and
17    * update_extract_gt procedures
18    */
19   FUNCTION insert_into_xla_events_gt (p_entity_code IN VARCHAR2) RETURN NUMBER;
20   PROCEDURE update_extract_gt (
21     p_what_to_update  IN VARCHAR2,
22     p_entity_code     IN VARCHAR2
23   );
24   PROCEDURE merge_into_gtv;
25 
26 
27   PROCEDURE preaccounting
28    ( p_application_id       IN           NUMBER
29    , p_ledger_id            IN           NUMBER
30    , p_process_category     IN           VARCHAR2
31    , p_end_date             IN           DATE
32    , p_accounting_mode      IN           VARCHAR2
33    , p_valuation_method     IN           VARCHAR2
34    , p_security_id_int_1    IN           NUMBER
35    , p_security_id_int_2    IN           NUMBER
36    , p_security_id_int_3    IN           NUMBER
37    , p_security_id_char_1   IN           VARCHAR2
38    , p_security_id_char_2   IN           VARCHAR2
39    , p_security_id_char_3   IN           VARCHAR2
40    , p_report_request_id    IN           NUMBER
41    );
42 
43 
44   PROCEDURE extract
45    ( p_application_id       IN           NUMBER
46    , p_accounting_mode      IN           VARCHAR2
47    );
48 
49 
50   PROCEDURE postaccounting
51    ( p_application_id       IN           NUMBER
52    , p_ledger_id            IN           NUMBER
53    , p_process_category     IN           VARCHAR2
54    , p_end_date             IN           DATE
55    , p_accounting_mode      IN           VARCHAR2
56    , p_valuation_method     IN           VARCHAR2
57    , p_security_id_int_1    IN           NUMBER
58    , p_security_id_int_2    IN           NUMBER
59    , p_security_id_int_3    IN           NUMBER
60    , p_security_id_char_1   IN           VARCHAR2
61    , p_security_id_char_2   IN           VARCHAR2
62    , p_security_id_char_3   IN           VARCHAR2
63    , p_report_request_id    IN           NUMBER
64    );
65 
66 
67   PROCEDURE postprocessing
68    ( p_application_id       IN           NUMBER
69    , p_accounting_mode      IN           VARCHAR2
70    );
71 
72  PROCEDURE process_inv_txns(p_event VARCHAR2);  -- Inventory Txns
73  PROCEDURE process_pur_txns(p_event VARCHAR2);  -- Purchasing Txns
74  PROCEDURE process_pm_txns(p_event VARCHAR2);   -- Product Mgt Txns
75  PROCEDURE process_om_txns(p_event VARCHAR2);   -- Order Mgt Txns
76  PROCEDURE process_rval_txns(p_event VARCHAR2); -- Cost Reval Txns
77 
78  PROCEDURE DRILLDOWN
79  (
80    p_application_id      IN            INTEGER
81  , p_ledger_id           IN            INTEGER
82  , p_legal_entity_id     IN            INTEGER DEFAULT NULL
83  , p_entity_code         IN            VARCHAR2
84  , p_event_class_code    IN            VARCHAR2
85  , p_event_type_code     IN            VARCHAR2
86  , p_source_id_int_1     IN            INTEGER DEFAULT NULL
87  , p_source_id_int_2     IN            INTEGER DEFAULT NULL
88  , p_source_id_int_3     IN            INTEGER DEFAULT NULL
89  , p_source_id_int_4     IN            INTEGER DEFAULT NULL
90  , p_source_id_char_1    IN            VARCHAR2 DEFAULT NULL
91  , p_source_id_char_2    IN            VARCHAR2 DEFAULT NULL
92  , p_source_id_char_3    IN            VARCHAR2 DEFAULT NULL
93  , p_source_id_char_4    IN            VARCHAR2 DEFAULT NULL
94  , p_security_id_int_1   IN            INTEGER DEFAULT NULL
95  , p_security_id_int_2   IN            INTEGER DEFAULT NULL
96  , p_security_id_int_3   IN            INTEGER DEFAULT NULL
97  , p_security_id_char_1  IN            VARCHAR2 DEFAULT NULL
98  , p_security_id_char_2  IN            VARCHAR2 DEFAULT NULL
99  , p_security_id_char_3  IN            VARCHAR2 DEFAULT NULL
100  , p_valuation_method    IN            VARCHAR2 DEFAULT NULL
101  , p_user_interface_type IN OUT NOCOPY VARCHAR2
102  , p_function_name       IN OUT NOCOPY VARCHAR2
103  , p_parameters          IN OUT NOCOPY VARCHAR2
104  );
105 
106 END GMF_XLA_PKG;