[Home] [Help]
PACKAGE: APPS.XLA_DATAFIXES_PUB
Source
1 PACKAGE xla_datafixes_pub AUTHID CURRENT_USER AS
2 /* $Header: xlajedfp.pkh 120.1.12020000.2 2012/07/23 13:33:46 vgopiset ship $ */
3
4 ------------------------------------------------------------------------------
5 -- Global variable
6 ------------------------------------------------------------------------------
7 g_msg_mode VARCHAR2(1) := 'S'; -- message mode, S or X
8 global_error_index PLS_INTEGER := 0; --added bug 10226301
9 global_accounting_errors xla_accounting_err_pkg.t_array_error; --added global array to read undo accounting errors bug 10226301
10
11 -------------------------------------------------------------------------------
12 -- Public API
13 -------------------------------------------------------------------------------
14 PROCEDURE reset_global; --added bug 10226301 to clean global array
15
16 PROCEDURE delete_journal_entries
17 (p_api_version IN NUMBER
18 ,p_init_msg_list IN VARCHAR2
19 ,p_application_id IN INTEGER
20 ,p_event_id IN INTEGER
21 ,x_return_status OUT NOCOPY VARCHAR2
22 ,x_msg_count OUT NOCOPY NUMBER
23 ,x_msg_data OUT NOCOPY VARCHAR2
24 );
25
26
27 PROCEDURE reverse_journal_entries
28 (p_api_version IN NUMBER
29 ,p_init_msg_list IN VARCHAR2
30 ,p_application_id IN INTEGER
31 ,p_event_id IN INTEGER
32 ,p_reversal_method IN VARCHAR2
33 ,p_gl_date IN DATE
34 ,p_post_to_gl_flag IN VARCHAR2
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,x_rev_ae_header_id OUT NOCOPY INTEGER
39 ,x_rev_event_id OUT NOCOPY INTEGER
40 ,x_rev_entity_id OUT NOCOPY INTEGER
41 ,x_new_event_id OUT NOCOPY INTEGER
42 ,x_new_entity_id OUT NOCOPY INTEGER
43 );
44
45
46
47 PROCEDURE redo_accounting
48 (p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2
50 ,p_application_id IN INTEGER
51 ,p_event_id IN INTEGER
52 ,p_gl_posting_flag IN VARCHAR2
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58
59
60 PROCEDURE do_not_transfer_je
61 (p_api_version IN NUMBER
62 ,p_init_msg_list IN VARCHAR2
63 ,p_application_id IN INTEGER
64 ,p_ae_header_id IN INTEGER
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_count OUT NOCOPY NUMBER
67 ,x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70
71 PROCEDURE validate_journal_entry
72 (p_api_version IN NUMBER
73 ,p_init_msg_list IN VARCHAR2
74 ,p_application_id IN INTEGER
75 ,p_ae_header_id IN INTEGER
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 );
80
81
82 PROCEDURE audit_datafix
83 (p_application_id IN INTEGER
84 ,p_ae_header_id IN INTEGER DEFAULT NULL
85 ,p_ae_line_num IN INTEGER DEFAULT NULL
86 ,p_event_id IN INTEGER DEFAULT NULL
87 ,p_audit_all IN VARCHAR2 DEFAULT 'N'
88 );
89
90
91 PROCEDURE log_error
92 (p_module IN VARCHAR2 DEFAULT NULL
93 ,p_error_msg IN VARCHAR2 DEFAULT NULL
94 ,p_error_name IN VARCHAR2 DEFAULT NULL
95 );
96
97 FUNCTION get_transaction_details ( p_application_id IN INTEGER,
98 p_entity_id IN INTEGER,
99 p_trans_details_flag IN VARCHAR2 DEFAULT 'N',
100 p_entity_code IN VARCHAR2 DEFAULT NULL
101 )
102 RETURN VARCHAR2;
103
104 END xla_datafixes_pub;