155: p_cust_trx_line_gl_dist_id IN
156: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
157: p_exchange_rate IN ra_customer_trx.exchange_rate%type
158: DEFAULT 1,
159: p_currency_code IN fnd_currencies.currency_code%type
160: DEFAULT null,
161: p_precision IN fnd_currencies.precision%type
162: DEFAULT null,
163: p_mau IN
157: p_exchange_rate IN ra_customer_trx.exchange_rate%type
158: DEFAULT 1,
159: p_currency_code IN fnd_currencies.currency_code%type
160: DEFAULT null,
161: p_precision IN fnd_currencies.precision%type
162: DEFAULT null,
163: p_mau IN
164: fnd_currencies.minimum_accountable_unit%type
165: DEFAULT null);
160: DEFAULT null,
161: p_precision IN fnd_currencies.precision%type
162: DEFAULT null,
163: p_mau IN
164: fnd_currencies.minimum_accountable_unit%type
165: DEFAULT null);
166:
167: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
168: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
171: p_account_class
172: IN ra_cust_trx_line_gl_dist.account_class%type,
173: p_exchange_rate IN ra_customer_trx.exchange_rate%type
174: DEFAULT 1,
175: p_currency_code IN fnd_currencies.currency_code%type
176: DEFAULT null,
177: p_precision IN fnd_currencies.precision%type
178: DEFAULT null,
179: p_mau IN
173: p_exchange_rate IN ra_customer_trx.exchange_rate%type
174: DEFAULT 1,
175: p_currency_code IN fnd_currencies.currency_code%type
176: DEFAULT null,
177: p_precision IN fnd_currencies.precision%type
178: DEFAULT null,
179: p_mau IN
180: fnd_currencies.minimum_accountable_unit%type
181: DEFAULT null);
176: DEFAULT null,
177: p_precision IN fnd_currencies.precision%type
178: DEFAULT null,
179: p_mau IN
180: fnd_currencies.minimum_accountable_unit%type
181: DEFAULT null);
182:
183: PROCEDURE update_f_ctl_id(
184: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
189: p_account_class
190: IN ra_cust_trx_line_gl_dist.account_class%type,
191: p_exchange_rate IN ra_customer_trx.exchange_rate%type
192: DEFAULT 1,
193: p_currency_code IN fnd_currencies.currency_code%type
194: DEFAULT null,
195: p_precision IN fnd_currencies.precision%type
196: DEFAULT null,
197: p_mau IN
191: p_exchange_rate IN ra_customer_trx.exchange_rate%type
192: DEFAULT 1,
193: p_currency_code IN fnd_currencies.currency_code%type
194: DEFAULT null,
195: p_precision IN fnd_currencies.precision%type
196: DEFAULT null,
197: p_mau IN
198: fnd_currencies.minimum_accountable_unit%type
199: DEFAULT null);
194: DEFAULT null,
195: p_precision IN fnd_currencies.precision%type
196: DEFAULT null,
197: p_mau IN
198: fnd_currencies.minimum_accountable_unit%type
199: DEFAULT null);
200:
201: PROCEDURE update_f_ctls_id(
202: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
207: p_account_class
208: IN ra_cust_trx_line_gl_dist.account_class%type,
209: p_exchange_rate IN ra_customer_trx.exchange_rate%type
210: DEFAULT 1,
211: p_currency_code IN fnd_currencies.currency_code%type
212: DEFAULT null,
213: p_precision IN fnd_currencies.precision%type
214: DEFAULT null,
215: p_mau IN
209: p_exchange_rate IN ra_customer_trx.exchange_rate%type
210: DEFAULT 1,
211: p_currency_code IN fnd_currencies.currency_code%type
212: DEFAULT null,
213: p_precision IN fnd_currencies.precision%type
214: DEFAULT null,
215: p_mau IN
216: fnd_currencies.minimum_accountable_unit%type
217: DEFAULT null);
212: DEFAULT null,
213: p_precision IN fnd_currencies.precision%type
214: DEFAULT null,
215: p_mau IN
216: fnd_currencies.minimum_accountable_unit%type
217: DEFAULT null);
218:
219: PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
220: p_base_curr_code IN
217: DEFAULT null);
218:
219: PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
220: p_base_curr_code IN
221: fnd_currencies.currency_code%type,
222: p_exchange_rate IN
223: ra_customer_trx.exchange_rate%type,
224: p_base_precision IN
225: fnd_currencies.precision%type
221: fnd_currencies.currency_code%type,
222: p_exchange_rate IN
223: ra_customer_trx.exchange_rate%type,
224: p_base_precision IN
225: fnd_currencies.precision%type
226: default null,
227: p_base_min_acc_unit IN
228: fnd_currencies.minimum_accountable_unit%type
229: default null);
224: p_base_precision IN
225: fnd_currencies.precision%type
226: default null,
227: p_base_min_acc_unit IN
228: fnd_currencies.minimum_accountable_unit%type
229: default null);
230:
231: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
232: ra_customer_trx_lines.customer_trx_line_id%type,
232: ra_customer_trx_lines.customer_trx_line_id%type,
233: p_line_amount IN
234: ra_customer_trx_lines.extended_amount%type,
235: p_foreign_currency_code IN
236: fnd_currencies.currency_code%type,
237: p_base_curr_code IN
238: fnd_currencies.currency_code%type,
239: p_exchange_rate IN
240: ra_customer_trx.exchange_rate%type,
234: ra_customer_trx_lines.extended_amount%type,
235: p_foreign_currency_code IN
236: fnd_currencies.currency_code%type,
237: p_base_curr_code IN
238: fnd_currencies.currency_code%type,
239: p_exchange_rate IN
240: ra_customer_trx.exchange_rate%type,
241: p_base_precision IN
242: fnd_currencies.precision%type
238: fnd_currencies.currency_code%type,
239: p_exchange_rate IN
240: ra_customer_trx.exchange_rate%type,
241: p_base_precision IN
242: fnd_currencies.precision%type
243: default null,
244: p_base_min_acc_unit IN
245: fnd_currencies.minimum_accountable_unit%type
246: default null);
241: p_base_precision IN
242: fnd_currencies.precision%type
243: default null,
244: p_base_min_acc_unit IN
245: fnd_currencies.minimum_accountable_unit%type
246: default null);
247:
248: PROCEDURE insert_p(
249: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
250: p_cust_trx_line_gl_dist_id
251: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
252: p_exchange_rate IN ra_customer_trx.exchange_rate%type
253: DEFAULT 1,
254: p_currency_code IN fnd_currencies.currency_code%type
255: DEFAULT null,
256: p_precision IN fnd_currencies.precision%type
257: DEFAULT null,
258: p_mau IN fnd_currencies.minimum_accountable_unit%type
252: p_exchange_rate IN ra_customer_trx.exchange_rate%type
253: DEFAULT 1,
254: p_currency_code IN fnd_currencies.currency_code%type
255: DEFAULT null,
256: p_precision IN fnd_currencies.precision%type
257: DEFAULT null,
258: p_mau IN fnd_currencies.minimum_accountable_unit%type
259: DEFAULT null
260: );
254: p_currency_code IN fnd_currencies.currency_code%type
255: DEFAULT null,
256: p_precision IN fnd_currencies.precision%type
257: DEFAULT null,
258: p_mau IN fnd_currencies.minimum_accountable_unit%type
259: DEFAULT null
260: );
261:
262: PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype);