1 PACKAGE xla_datafixes_pub AS
2 /* $Header: xlajedfp.pkh 120.0 2006/04/11 02:26:47 awan ship $ */
3
4 ------------------------------------------------------------------------------
5 -- Global variable
6 ------------------------------------------------------------------------------
7 g_msg_mode VARCHAR2(1) := 'S'; -- message mode, S or X
8
9 -------------------------------------------------------------------------------
10 -- Public API
11 -------------------------------------------------------------------------------
12
13
14 PROCEDURE delete_journal_entries
15 (p_api_version IN NUMBER
16 ,p_init_msg_list IN VARCHAR2
17 ,p_application_id IN INTEGER
18 ,p_event_id IN INTEGER
19 ,x_return_status OUT NOCOPY VARCHAR2
20 ,x_msg_count OUT NOCOPY NUMBER
21 ,x_msg_data OUT NOCOPY VARCHAR2
22 );
23
24
25 PROCEDURE reverse_journal_entries
26 (p_api_version IN NUMBER
27 ,p_init_msg_list IN VARCHAR2
28 ,p_application_id IN INTEGER
29 ,p_event_id IN INTEGER
30 ,p_reversal_method IN VARCHAR2
31 ,p_gl_date IN DATE
32 ,p_post_to_gl_flag IN VARCHAR2
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,x_rev_ae_header_id OUT NOCOPY INTEGER
37 ,x_rev_event_id OUT NOCOPY INTEGER
38 ,x_rev_entity_id OUT NOCOPY INTEGER
39 ,x_new_event_id OUT NOCOPY INTEGER
40 ,x_new_entity_id OUT NOCOPY INTEGER
41 );
42
43
44
45 PROCEDURE redo_accounting
46 (p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2
48 ,p_application_id IN INTEGER
49 ,p_event_id IN INTEGER
50 ,p_gl_posting_flag IN VARCHAR2
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56
57
58 PROCEDURE do_not_transfer_je
59 (p_api_version IN NUMBER
60 ,p_init_msg_list IN VARCHAR2
61 ,p_application_id IN INTEGER
62 ,p_ae_header_id IN INTEGER
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68
69 PROCEDURE validate_journal_entry
70 (p_api_version IN NUMBER
71 ,p_init_msg_list IN VARCHAR2
72 ,p_application_id IN INTEGER
73 ,p_ae_header_id IN INTEGER
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79
80 PROCEDURE audit_datafix
81 (p_application_id IN INTEGER
82 ,p_ae_header_id IN INTEGER DEFAULT NULL
83 ,p_ae_line_num IN INTEGER DEFAULT NULL
84 ,p_event_id IN INTEGER DEFAULT NULL
85 ,p_audit_all IN VARCHAR2 DEFAULT 'N'
86 );
87
88
89 PROCEDURE log_error
90 (p_module IN VARCHAR2 DEFAULT NULL
91 ,p_error_msg IN VARCHAR2 DEFAULT NULL
92 ,p_error_name IN VARCHAR2 DEFAULT NULL
93 );
94
95 END xla_datafixes_pub;