[Home] [Help]
PACKAGE: APPS.FUN_TRX_PUB
Source
1 PACKAGE FUN_TRX_PUB AS
2 /* $Header: funtrxvalinss.pls 120.10 2006/10/05 09:43:26 bsilveir noship $ */
3 /*#
4 * This API validates the intercompany transactions and inserts the validated batch into the FUN transaction tables.
5 * @rep:scope public
6 * @rep:product FUN
7 * @rep:lifecycle active
8 * @rep:displayname Intercompany Batch Creation API
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH
11 * @rep:businessevent oracle.apps.fun.manualtrx.batch.send
12 */
13
14 TYPE Full_Batch_Rec_Type IS RECORD
15 ( batch_id NUMBER(15),
16 batch_number VARCHAR2(15),
17 initiator_id NUMBER(15),
18 from_le_id NUMBER(15),
19 from_ledger_id NUMBER(15),
20 control_total NUMBER,
21 running_total_cr NUMBER,
22 running_total_dr NUMBER,
23 currency_code VARCHAR2(15),
24 exchange_rate_type VARCHAR2(30),
25 status VARCHAR2(30),-- changed
26 description VARCHAR2(240),
27 note VARCHAR2(240),
28 trx_type_id NUMBER(15),
29 trx_type_code VARCHAR2(15),
30 gl_date DATE,
31 batch_date DATE,
32 reject_allow_flag VARCHAR2(1), -- changed
33 original_batch_id NUMBER(15),
34 reversed_batch_id NUMBER(15),
35 from_recurring_batch_id NUMBER(15),
36 attribute1 VARCHAR2(150),
37 attribute2 VARCHAR2(150),
38 attribute3 VARCHAR2(150),
39 attribute4 VARCHAR2(150),
40 attribute5 VARCHAR2(150),
41 attribute6 VARCHAR2(150),
42 attribute7 VARCHAR2(150),
43 attribute8 VARCHAR2(150),
44 attribute9 VARCHAR2(150),
45 attribute10 VARCHAR2(150),
46 attribute11 VARCHAR2(150),
47 attribute12 VARCHAR2(150),
48 attribute13 VARCHAR2(150),
49 attribute14 VARCHAR2(150),
50 attribute15 VARCHAR2(150),
51 attribute_category VARCHAR2(150)
52 );
53
54
55 TYPE Full_Trx_Rec_Type IS RECORD
56 ( trx_id NUMBER(15),
57 trx_number VARCHAR2(15),
58 initiator_id NUMBER(15),
59 recipient_id NUMBER(15),
60 to_le_id NUMBER(15),
61 to_ledger_id NUMBER(15),
62 batch_id NUMBER(15),
63 status VARCHAR2(30), -- changed
64 init_amount_cr NUMBER,
65 init_amount_dr NUMBER,
66 reci_amount_cr NUMBER,
67 reci_amount_dr NUMBER,
68 ar_invoice_number VARCHAR2(50),
69 invoice_flag VARCHAR2(1), -- changed
70 approver_id NUMBER(15),
71 approval_date DATE,
72 original_trx_id NUMBER(15),
73 reversed_trx_id NUMBER(15),
74 from_recurring_trx_id NUMBER(15),
75 initiator_instance_flag VARCHAR2(1), -- changed
76 recipient_instance_flag VARCHAR2(1), -- changed
77 reject_reason VARCHAR2(240),
78 description VARCHAR2(240),
79 init_wf_key VARCHAR2(240),
80 reci_wf_key VARCHAR2(240),
81 attribute1 VARCHAR2(150),
82 attribute2 VARCHAR2(150),
83 attribute3 VARCHAR2(150),
84 attribute4 VARCHAR2(150),
85 attribute5 VARCHAR2(150),
86 attribute6 VARCHAR2(150),
87 attribute7 VARCHAR2(150),
88 attribute8 VARCHAR2(150),
89 attribute9 VARCHAR2(150),
90 attribute10 VARCHAR2(150),
91 attribute11 VARCHAR2(150),
92 attribute12 VARCHAR2(150),
93 attribute13 VARCHAR2(150),
94 attribute14 VARCHAR2(150),
95 attribute15 VARCHAR2(150),
96 attribute_category VARCHAR2(150)
97 );
98
99
100 TYPE Full_Init_Dist_Rec_Type IS RECORD
101 ( batch_dist_id NUMBER(15),
102 line_number NUMBER(15),
103 batch_id NUMBER(15),
104 ccid NUMBER(15),
105 amount_cr NUMBER,
106 amount_dr NUMBER,
107 description VARCHAR2(240),
108 attribute1 VARCHAR2(150),
109 attribute2 VARCHAR2(150),
110 attribute3 VARCHAR2(150),
111 attribute4 VARCHAR2(150),
112 attribute5 VARCHAR2(150),
113 attribute6 VARCHAR2(150),
114 attribute7 VARCHAR2(150),
115 attribute8 VARCHAR2(150),
116 attribute9 VARCHAR2(150),
117 attribute10 VARCHAR2(150),
118 attribute11 VARCHAR2(150),
119 attribute12 VARCHAR2(150),
120 attribute13 VARCHAR2(150),
121 attribute14 VARCHAR2(150),
122 attribute15 VARCHAR2(150),
123 attribute_category VARCHAR2(150)
124 );
125
126
127 TYPE Full_Dist_Line_Rec_Type IS RECORD
128 ( trx_id NUMBER(15),
129 dist_id NUMBER(15),
130 line_id NUMBER(15),
131 dist_number NUMBER(15),
132 party_id NUMBER(15),
133 party_type_flag VARCHAR2(1), -- changed
134 dist_type_flag VARCHAR2(1), -- changed
135 batch_dist_id NUMBER(15),
136 amount_cr NUMBER,
137 amount_dr NUMBER,
138 ccid NUMBER(15),
139 description VARCHAR2(250),
140 auto_generate_flag VARCHAR2(1),
141 attribute1 VARCHAR2(150),
142 attribute2 VARCHAR2(150),
143 attribute3 VARCHAR2(150),
144 attribute4 VARCHAR2(150),
145 attribute5 VARCHAR2(150),
146 attribute6 VARCHAR2(150),
147 attribute7 VARCHAR2(150),
148 attribute8 VARCHAR2(150),
149 attribute9 VARCHAR2(150),
150 attribute10 VARCHAR2(150),
151 attribute11 VARCHAR2(150),
152 attribute12 VARCHAR2(150),
153 attribute13 VARCHAR2(150),
154 attribute14 VARCHAR2(150),
155 attribute15 VARCHAR2(150),
156 attribute_category VARCHAR2(150)
157 );
158
159
160 TYPE Full_Trx_Tbl_Type IS TABLE OF Full_Trx_Rec_Type INDEX BY BINARY_INTEGER;
161
162 TYPE Full_Init_Dist_Tbl_Type IS TABLE OF Full_Init_Dist_Rec_Type INDEX BY BINARY_INTEGER;
163
164 TYPE Full_Dist_Line_Tbl_Type IS TABLE OF Full_Dist_Line_Rec_Type INDEX BY BINARY_INTEGER;
165
166
167
168
169 /***********************************************
170 * Procedure CREATE_BATCH: *
171 * This Procedure Validates Intercompany Transactions and then *
172 * Inserts Validated Batch into FUN Transaction Tables *
173 * @param p_api_version API Version
174 * @rep:paraminfo {@rep:required}
175 * @param p_init_msg_list TRUE should be passed if the Message List is to be
176 * initialized
177 * @param p_commit If it is set to TRUE it commits work
178 * @param p_validation_level To determine which validation steps should be executed
179 * and which steps should be skipped. Defaults to FULL Validation
180 * @param p_sent Sent flag, Workflow event is raised if p_sent='Y'
181 * @rep:paraminfo {@rep:required}
182 * @param p_calling_sequence Initializes the Stack of the Validation API's when calling_sequence is Intercompany Import Programs
183 * @rep:paraminfo {@rep:required}
184 * @param p_insert Insertion flag, Inserts in transaction batch table if set to TRUE or null.
185 * @param p_batch_rec Transaction batch record
186 * @rep:paraminfo {@rep:required}
187 * @param p_trx_tbl Transaction header table
188 * @rep:paraminfo {@rep:required}
189 * @param p_init_dist_tbl Initiator side distributions table
190 * @rep:paraminfo {@rep:required}
191 * @param p_dist_lines_tbl Distribution lines table
192 * @rep:paraminfo {@rep:required}
193 * @return x_return_status Reports the API overall return status as Success, Error or
194 * Unexpected
195 * @return x_msg_count Number of messages in the API message list
196 * @return x_msg_data The message in an encoded format
197 * @rep:scope public
198 * @rep:product FUN
199 * @rep:lifecycle active
200 * @rep:displayname Intercompany Batch Creation Procedure
201 * @rep:businessevent oracle.apps.fun.manualtrx.batch.send
202 * @rep:compatability S
203 *
204 ***************************************************/
205
206
210 p_commit IN VARCHAR2 default null,
207 Procedure CREATE_BATCH(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 default null,
211 p_validation_level IN NUMBER default null,
212 p_debug IN VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_sent IN VARCHAR2,
217 p_calling_sequence IN VARCHAR2,
218 p_insert IN VARCHAR2 default null,
219 p_batch_rec IN OUT NOCOPY FULL_BATCH_REC_TYPE,
220 p_trx_tbl IN OUT NOCOPY FULL_TRX_TBL_TYPE,
221 p_init_dist_tbl IN OUT NOCOPY FULL_INIT_DIST_TBL_TYPE,
222 p_dist_lines_tbl IN OUT NOCOPY FULL_DIST_LINE_TBL_TYPE
223 );
224
225
226
227
228 END FUN_TRX_PUB;