eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_CREDIT_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 191: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

187:
188: PROCEDURE get_credited_trx_amounts(
189: p_ct_id IN ra_customer_trx.customer_trx_id%type,
190: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
191: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

188: PROCEDURE get_credited_trx_amounts(
189: p_ct_id IN ra_customer_trx.customer_trx_id%type,
190: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
191: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

189: p_ct_id IN ra_customer_trx.customer_trx_id%type,
190: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
191: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

190: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
191: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
198: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

191: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
198: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
199: p_num_line_lines OUT NOCOPY number,

Line 196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

192: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
198: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
199: p_num_line_lines OUT NOCOPY number,
200: p_num_tax_lines OUT NOCOPY number,

Line 197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

193: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
198: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
199: p_num_line_lines OUT NOCOPY number,
200: p_num_tax_lines OUT NOCOPY number,
201: p_num_frt_lines OUT NOCOPY number,

Line 198: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

194: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
195: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
196: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
197: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
198: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
199: p_num_line_lines OUT NOCOPY number,
200: p_num_tax_lines OUT NOCOPY number,
201: p_num_frt_lines OUT NOCOPY number,
202: p_num_installments OUT NOCOPY number)

Line 208: l_orig_line_amount ra_customer_trx_lines.extended_amount%type;

204: l_commit_adj_amount number;
205: l_commit_line_amount number;
206: l_commit_tax_amount number;
207: l_commit_frt_amount number;
208: l_orig_line_amount ra_customer_trx_lines.extended_amount%type;
209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;
210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;

Line 209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;

205: l_commit_line_amount number;
206: l_commit_tax_amount number;
207: l_commit_frt_amount number;
208: l_orig_line_amount ra_customer_trx_lines.extended_amount%type;
209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;
210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;

Line 210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;

206: l_commit_tax_amount number;
207: l_commit_frt_amount number;
208: l_orig_line_amount ra_customer_trx_lines.extended_amount%type;
209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;
210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;

Line 211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;

207: l_commit_frt_amount number;
208: l_orig_line_amount ra_customer_trx_lines.extended_amount%type;
209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;
210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;

Line 212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;

208: l_orig_line_amount ra_customer_trx_lines.extended_amount%type;
209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;
210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;
216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;

Line 213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;

209: l_orig_tax_amount ra_customer_trx_lines.extended_amount%type;
210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;
216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;
217: l_bal_tot_amount ra_customer_trx_lines.extended_amount%type;

Line 214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;

210: l_orig_frt_amount ra_customer_trx_lines.extended_amount%type;
211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;
216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;
217: l_bal_tot_amount ra_customer_trx_lines.extended_amount%type;
218: l_num_line_lines number;

Line 215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;

211: l_orig_chrg_amount ra_customer_trx_lines.extended_amount%type;
212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;
216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;
217: l_bal_tot_amount ra_customer_trx_lines.extended_amount%type;
218: l_num_line_lines number;
219: l_num_tax_lines number;

Line 216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;

212: l_orig_tot_amount ra_customer_trx_lines.extended_amount%type;
213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;
216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;
217: l_bal_tot_amount ra_customer_trx_lines.extended_amount%type;
218: l_num_line_lines number;
219: l_num_tax_lines number;
220: l_num_frt_lines number;

Line 217: l_bal_tot_amount ra_customer_trx_lines.extended_amount%type;

213: l_bal_line_amount ra_customer_trx_lines.extended_amount%type;
214: l_bal_tax_amount ra_customer_trx_lines.extended_amount%type;
215: l_bal_frt_amount ra_customer_trx_lines.extended_amount%type;
216: l_bal_chrg_amount ra_customer_trx_lines.extended_amount%type;
217: l_bal_tot_amount ra_customer_trx_lines.extended_amount%type;
218: l_num_line_lines number;
219: l_num_tax_lines number;
220: l_num_frt_lines number;
221: l_num_installments number;

Line 251: FROM ra_customer_trx_lines ctl

247: null))
248: INTO l_num_line_lines,
249: l_num_tax_lines,
250: l_num_frt_lines
251: FROM ra_customer_trx_lines ctl
252: WHERE ctl.customer_trx_id = p_ct_id;
253:
254: /*--------------------------------------------------------------------+
255: | get transaction summary balances |

Line 366: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

362: +===========================================================================*/
363: PROCEDURE get_credited_trx_details(
364: p_ct_id IN ra_customer_trx.customer_trx_id%type,
365: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
366: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

363: PROCEDURE get_credited_trx_details(
364: p_ct_id IN ra_customer_trx.customer_trx_id%type,
365: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
366: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

364: p_ct_id IN ra_customer_trx.customer_trx_id%type,
365: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
366: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

365: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
366: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
373: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

366: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
373: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
374: p_num_line_lines OUT NOCOPY number,

Line 371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

367: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
373: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
374: p_num_line_lines OUT NOCOPY number,
375: p_num_tax_lines OUT NOCOPY number,

Line 372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

368: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
373: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
374: p_num_line_lines OUT NOCOPY number,
375: p_num_tax_lines OUT NOCOPY number,
376: p_num_frt_lines OUT NOCOPY number,

Line 373: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

369: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
370: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
371: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
372: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
373: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
374: p_num_line_lines OUT NOCOPY number,
375: p_num_tax_lines OUT NOCOPY number,
376: p_num_frt_lines OUT NOCOPY number,
377: p_num_installments OUT NOCOPY number,

Line 467: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

463: +===========================================================================*/
464:
465: PROCEDURE get_credit_memo_amounts(
466: p_ct_id IN ra_customer_trx.customer_trx_id%type,
467: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
468: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
469: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
470: p_num_line_lines OUT NOCOPY number,
471: p_num_tax_lines OUT NOCOPY number,

Line 468: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

464:
465: PROCEDURE get_credit_memo_amounts(
466: p_ct_id IN ra_customer_trx.customer_trx_id%type,
467: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
468: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
469: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
470: p_num_line_lines OUT NOCOPY number,
471: p_num_tax_lines OUT NOCOPY number,
472: p_num_frt_lines OUT NOCOPY number)

Line 469: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

465: PROCEDURE get_credit_memo_amounts(
466: p_ct_id IN ra_customer_trx.customer_trx_id%type,
467: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
468: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
469: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
470: p_num_line_lines OUT NOCOPY number,
471: p_num_tax_lines OUT NOCOPY number,
472: p_num_frt_lines OUT NOCOPY number)
473: IS

Line 474: l_cm_line_amount ra_customer_trx_lines.extended_amount%type;

470: p_num_line_lines OUT NOCOPY number,
471: p_num_tax_lines OUT NOCOPY number,
472: p_num_frt_lines OUT NOCOPY number)
473: IS
474: l_cm_line_amount ra_customer_trx_lines.extended_amount%type;
475: l_cm_tax_amount ra_customer_trx_lines.extended_amount%type;
476: l_cm_frt_amount ra_customer_trx_lines.extended_amount%type;
477: l_num_line_lines number;
478: l_num_tax_lines number;

Line 475: l_cm_tax_amount ra_customer_trx_lines.extended_amount%type;

471: p_num_tax_lines OUT NOCOPY number,
472: p_num_frt_lines OUT NOCOPY number)
473: IS
474: l_cm_line_amount ra_customer_trx_lines.extended_amount%type;
475: l_cm_tax_amount ra_customer_trx_lines.extended_amount%type;
476: l_cm_frt_amount ra_customer_trx_lines.extended_amount%type;
477: l_num_line_lines number;
478: l_num_tax_lines number;
479: l_num_frt_lines number;

Line 476: l_cm_frt_amount ra_customer_trx_lines.extended_amount%type;

472: p_num_frt_lines OUT NOCOPY number)
473: IS
474: l_cm_line_amount ra_customer_trx_lines.extended_amount%type;
475: l_cm_tax_amount ra_customer_trx_lines.extended_amount%type;
476: l_cm_frt_amount ra_customer_trx_lines.extended_amount%type;
477: l_num_line_lines number;
478: l_num_tax_lines number;
479: l_num_frt_lines number;
480: BEGIN

Line 514: FROM ra_customer_trx_lines ctl

510: l_cm_frt_amount,
511: l_num_line_lines,
512: l_num_tax_lines,
513: l_num_frt_lines
514: FROM ra_customer_trx_lines ctl
515: WHERE ctl.customer_trx_id = p_ct_id;
516:
517: p_cm_line_amount := l_cm_line_amount;
518: p_cm_tax_amount := l_cm_tax_amount;