1 PACKAGE arp_acct_event_pkg AS
2 /* $Header: ARXLUTS.pls 120.4 2006/08/09 18:35:59 hyu noship $ */
3
4 PROCEDURE update_dates_for_trx_event
5 (p_source_id_int_1 IN NUMBER,
6 p_trx_number IN VARCHAR2,
7 p_legal_entity_id IN NUMBER,
8 p_ledger_id IN NUMBER,
9 p_org_id IN NUMBER,
10 p_event_id IN NUMBER,
11 p_valuation_method IN VARCHAR2,
12 p_entity_type_code IN VARCHAR2,
13 p_event_type_code IN VARCHAR2,
14 p_curr_event_date IN DATE,
15 p_event_date IN DATE,
16 p_status IN VARCHAR2,
17 p_action IN VARCHAR2,
18 p_curr_trx_date IN DATE,
19 p_transaction_date IN DATE,
20 x_event_id OUT NOCOPY NUMBER);
21
22 --{
23 PROCEDURE get_ar_trx_event_info
24 (p_entity_code IN VARCHAR2,
25 p_source_int_id IN NUMBER);
26
27 PROCEDURE get_xla_event_info
28 (p_entity_code IN VARCHAR2,
29 p_source_int_id IN NUMBER);
30
31 PROCEDURE ar_event_existence
32 (p_entity_code IN VARCHAR2,
33 p_source_int_id IN NUMBER,
34 x_result OUT NOCOPY VARCHAR2);
35
36 /*------------------------------------------------------------------------------+
37 | Input arguments |
38 | --------------- |
39 | * p_init_msg_list in |
40 | FND_API.G_FALSE --> do not initial the message stack |
41 | FND_API.G_TUR --> initial the message stack |
42 | * p_entity_code in |
43 | 'TRANSACTIONS' |
44 | 'RECEIPTS' |
45 | 'ADJUSTMENTS' |
46 | 'BILLS_RECEIVABLE' |
47 | * p_source_int_id the primary key of each AR entity is |
48 | For entity TRANSACTIONS --> customer_trx_id |
49 | For entity RECEIPTS --> cash_receipt_id |
50 | For entity ADJUSTMENTS --> adjustment_id |
51 | For entity BILLS_RECEIVABLE --> customer_trx_id |
52 | Output arguments |
53 | ---------------- |
54 | * x_upgrade_status : |
55 | Y if the entire document has been upgraded or is R12 |
56 | N if the document has been partialy upgraded or not upgraded |
57 | * x_return_status : fnd api status codification to indicate success or |
58 | error |
59 | * x_msg_count : number of messages generated in the stack |
60 | * x_msg_data : the error message if only one message is stacked |
61 | |
62 +------------------------------------------------------------------------------*/
63 PROCEDURE upgrade_status_per_doc
64 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65 p_entity_code IN VARCHAR2,
66 p_source_int_id IN NUMBER,
67 x_upgrade_status OUT NOCOPY VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2);
71 --}
72
73 --{
74 PROCEDURE r12_adj_in_xla
75 (p_start_date IN DATE,
76 p_end_date IN DATE,
77 p_org_id IN NUMBER DEFAULT NULL,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2);
81
82 PROCEDURE r12_trx_in_xla
83 (p_start_date IN DATE,
84 p_end_date IN DATE,
85 p_type IN VARCHAR2,
86 p_org_id IN NUMBER DEFAULT NULL,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90
91 PROCEDURE r12_crh_in_xla
92 (p_start_date IN DATE,
93 p_end_date IN DATE,
94 p_org_id IN NUMBER DEFAULT NULL,
95 p_type IN VARCHAR2 DEFAULT 'ALL',
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100 PROCEDURE r12_app_in_xla
101 (p_start_date IN DATE,
102 p_end_date IN DATE,
103 p_org_id IN NUMBER DEFAULT NULL,
104 p_type IN VARCHAR2 DEFAULT 'ALL',
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2);
108
109 PROCEDURE r12_th_in_xla
110 (p_start_date IN DATE,
111 p_end_date IN DATE,
112 p_org_id IN NUMBER DEFAULT NULL,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2);
116
117 /*------------------------------------------------------------------------------+
118 | Input arguments |
119 | --------------- |
120 | p_start_date start gl_date |
121 | p_end_date end gl_date |
122 | p_xla_post_status do you want to check for posted data or unposted data |
123 | p_inv_flag 'Y' if you want to check for INV DEP GUAR otherwise 'N' |
124 | p_dm_flag 'Y' if you want to check for DM otherwise 'N' |
125 | p_cb_flag 'Y' if you want to check for CB otherwise 'N' |
126 | p_cm_flag 'Y' if you want to check for CM otherwise 'N' |
127 | p_cmapp_flag 'Y' if you want to check for CMAPP otherwise 'N' |
128 | p_adj_flag 'Y' if you want to check for ADJ otherwise 'N' |
129 | p_recp_flag 'Y' if you want to check for CR of type CASH otherwise 'N'|
130 | p_misc_flag 'Y' if you want to check for CR of type MISC otherwise 'N'|
131 | p_bill_flag 'Y' if you want to check for BILL otherwise 'N' |
132 | p_org_id org_id can be left to NULL for multi org |
133 | Output arguments |
134 | ---------------- |
135 | * x_return_status |
136 | 1) fnd_api.g_ret_sts_success |
137 | if all AR unposted distributions have a distribution in XLA |
138 | if all AR distribution are posted |
139 | 2) fnd_api.g_ret_sts_error |
140 | if at least one unposted AR distribution does not have a |
141 | distribution in XLA |
142 | 3) fnd_api.G_RET_STS_UNEXP_ERROR |
143 | if unexpected error are found |
144 | * x_msg_count : number of messages generated in the stack |
145 | * x_msg_data : return all messages in the stack |
146 | |
147 +------------------------------------------------------------------------------*/
148 PROCEDURE r12_dist_in_xla
149 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
150 p_start_date IN DATE,
151 p_end_date IN DATE,
152 p_xla_post_status IN VARCHAR2 DEFAULT 'Y',
153 p_inv_flag IN VARCHAR2 DEFAULT 'Y',
154 p_dm_flag IN VARCHAR2 DEFAULT 'Y',
155 p_cb_flag IN VARCHAR2 DEFAULT 'Y',
156 p_cm_flag IN VARCHAR2 DEFAULT 'Y',
157 p_cmapp_flag IN VARCHAR2 DEFAULT 'Y',
158 p_adj_flag IN VARCHAR2 DEFAULT 'Y',
159 p_recp_flag IN VARCHAR2 DEFAULT 'Y',
160 p_misc_flag IN VARCHAR2 DEFAULT 'Y',
161 p_bill_flag IN VARCHAR2 DEFAULT 'Y',
162 p_org_id IN NUMBER DEFAULT NULL,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2);
166 --}
167
168 --{BUG#4353362
169 PROCEDURE update_cr_dist
170 ( p_ledger_id IN NUMBER
171 ,p_source_id_int_1 IN NUMBER
172 ,p_third_party_merge_date IN DATE
173 ,p_original_third_party_id IN NUMBER
174 ,p_original_site_id IN NUMBER
175 ,p_new_third_party_id IN NUMBER
176 ,p_new_site_id IN NUMBER
177 ,p_create_update IN VARCHAR2 DEFAULT 'U'
178 ,p_entity_code IN VARCHAR2 DEFAULT 'RECEIPTS'
179 ,p_type_of_third_party_merge IN VARCHAR2 DEFAULT 'PARTIAL'
180 ,p_mapping_flag IN VARCHAR2 DEFAULT 'N'
181 ,p_execution_mode IN VARCHAR2 DEFAULT 'SYNC'
182 ,p_accounting_mode IN VARCHAR2 DEFAULT 'F'
183 ,p_transfer_to_gl_flag IN VARCHAR2 DEFAULT 'Y'
184 ,p_post_in_gl_flag IN VARCHAR2 DEFAULT 'Y'
185 ,p_third_party_type IN VARCHAR2 DEFAULT 'C'
186 ,x_errbuf OUT NOCOPY VARCHAR2
187 ,x_retcode OUT NOCOPY VARCHAR2
188 ,x_event_ids OUT NOCOPY xla_third_party_merge_pub.t_event_ids
189 ,x_request_id OUT NOCOPY NUMBER);
190 --}
191
192 PROCEDURE check_period_open
193 (p_entity_id IN NUMBER,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2);
197
198
199 END;