1 PACKAGE xla_journal_entries_pub_pkg AS
2 /* $Header: xlajejep.pkh 120.7 2006/05/30 16:49:38 wychan ship $ */
3 -------------------------------------------------------------------------------
4 -- declaring global constants
5 -------------------------------------------------------------------------------
6
7 C_COMPLETION_OPTION_SAVE CONSTANT VARCHAR2(1) := 'S';
8 C_COMPLETION_OPTION_DRAFT CONSTANT VARCHAR2(1) := 'D';
9 C_COMPLETION_OPTION_FINAL CONSTANT VARCHAR2(1) := 'F';
10 C_COMPLETION_OPTION_TRANSFER CONSTANT VARCHAR2(1) := 'T';
11 C_COMPLETION_OPTION_POST CONSTANT VARCHAR2(1) := 'P';
12
13 C_REVERSAL_CHANGE_SIGN CONSTANT VARCHAR2(30) := 'SIGN';
14 C_REVERSAL_SWITCH_DR_CR CONSTANT VARCHAR2(30) := 'SIDE';
15
16 C_STATUS_INCOMPLETE CONSTANT VARCHAR2(1) := 'N';
17 C_STATUS_INVALID CONSTANT VARCHAR2(1) := 'I';
18 C_STATUS_DRAFT CONSTANT VARCHAR2(1) := 'D';
19 C_STATUS_FINAL CONSTANT VARCHAR2(1) := 'F';
20
21 C_DELETE_NORMAL_MODE CONSTANT VARCHAR2(1) := 'N';
22 C_DELETE_FORCE_MODE CONSTANT VARCHAR2(1) := 'F';
23
24 XLA_BALANCE_CALCULATION_ERROR EXCEPTION;
25
26 -------------------------------------------------------------------------------
27 -- Public API
28 -------------------------------------------------------------------------------
29
30 PROCEDURE create_journal_entry_header
31 (p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2
33 ,p_application_id IN INTEGER
34 ,p_ledger_id IN INTEGER
35 ,p_legal_entity_id IN INTEGER
36 ,p_gl_date IN DATE
37 ,p_description IN VARCHAR2
38 ,p_je_category_name IN VARCHAR2
39 ,p_balance_type_code IN VARCHAR2
40 ,p_budget_version_id IN INTEGER
41 ,p_reference_date IN DATE
42 ,p_budgetary_control_flag IN VARCHAR2
43 ,p_attribute_category IN VARCHAR2
44 ,p_attribute1 IN VARCHAR2
45 ,p_attribute2 IN VARCHAR2
46 ,p_attribute3 IN VARCHAR2
47 ,p_attribute4 IN VARCHAR2
48 ,p_attribute5 IN VARCHAR2
49 ,p_attribute6 IN VARCHAR2
50 ,p_attribute7 IN VARCHAR2
51 ,p_attribute8 IN VARCHAR2
52 ,p_attribute9 IN VARCHAR2
53 ,p_attribute10 IN VARCHAR2
54 ,p_attribute11 IN VARCHAR2
55 ,p_attribute12 IN VARCHAR2
56 ,p_attribute13 IN VARCHAR2
57 ,p_attribute14 IN VARCHAR2
58 ,p_attribute15 IN VARCHAR2
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,x_ae_header_id OUT NOCOPY INTEGER
63 ,x_event_id OUT NOCOPY INTEGER
64 );
65
66 PROCEDURE create_journal_entry_line
67 (p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2
69 ,p_application_id IN INTEGER
70 ,p_ae_header_id IN INTEGER
71 ,p_displayed_line_number IN INTEGER
72 ,p_code_combination_id IN INTEGER
73 ,p_gl_transfer_mode IN VARCHAR2
74 ,p_accounting_class_code IN VARCHAR2
75 ,p_currency_code IN VARCHAR2
76 ,p_entered_dr IN NUMBER
77 ,p_entered_cr IN NUMBER
78 ,p_accounted_dr IN NUMBER
79 ,p_accounted_cr IN NUMBER
80 ,p_conversion_type IN VARCHAR2
81 ,p_conversion_date IN DATE
82 ,p_conversion_rate IN NUMBER
83 ,p_party_type_code IN VARCHAR2
84 ,p_party_id IN INTEGER
85 ,p_party_site_id IN INTEGER
86 ,p_description IN VARCHAR2
87 ,p_statistical_amount IN NUMBER
88 ,p_jgzz_recon_ref IN VARCHAR2
89 ,p_attribute_category IN VARCHAR2
90 ,p_encumbrance_type_id IN INTEGER
91 ,p_attribute1 IN VARCHAR2
92 ,p_attribute2 IN VARCHAR2
93 ,p_attribute3 IN VARCHAR2
94 ,p_attribute4 IN VARCHAR2
95 ,p_attribute5 IN VARCHAR2
96 ,p_attribute6 IN VARCHAR2
97 ,p_attribute7 IN VARCHAR2
98 ,p_attribute8 IN VARCHAR2
99 ,p_attribute9 IN VARCHAR2
100 ,p_attribute10 IN VARCHAR2
101 ,p_attribute11 IN VARCHAR2
102 ,p_attribute12 IN VARCHAR2
103 ,p_attribute13 IN VARCHAR2
104 ,p_attribute14 IN VARCHAR2
105 ,p_attribute15 IN VARCHAR2
106 ,x_return_status OUT NOCOPY VARCHAR2
107 ,x_msg_count OUT NOCOPY NUMBER
108 ,x_msg_data OUT NOCOPY VARCHAR2
109 ,x_ae_line_num OUT NOCOPY INTEGER
110 );
111
112
113 PROCEDURE complete_journal_entry
114 (p_api_version IN NUMBER
115 ,p_init_msg_list IN VARCHAR2
116 ,p_application_id IN INTEGER
117 ,p_ae_header_id IN INTEGER
118 ,p_completion_option IN VARCHAR2
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 ,x_completion_retcode OUT NOCOPY VARCHAR2);
123
124
125 END xla_journal_entries_pub_pkg;