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

Line 35: p_ct_id IN ra_customer_trx.customer_trx_id%type,

31: +===========================================================================*/
32: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
33:
34: FUNCTION get_commitment_adjustments(
35: p_ct_id IN ra_customer_trx.customer_trx_id%type,
36: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type) RETURN number
37: IS
38: l_amount number;
39: BEGIN

Line 36: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type) RETURN number

32: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
33:
34: FUNCTION get_commitment_adjustments(
35: p_ct_id IN ra_customer_trx.customer_trx_id%type,
36: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type) RETURN number
37: IS
38: l_amount number;
39: BEGIN
40: IF PG_DEBUG in ('Y', 'C') THEN

Line 48: ra_customer_trx commit_trx

44: SELECT sum(amount)
45: INTO l_amount
46: FROM ar_adjustments adj,
47: ra_cust_trx_types commit_ctt,
48: ra_customer_trx commit_trx
49: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
50: AND commit_trx.customer_trx_id = p_commit_ct_id
51: AND commit_ctt.type = 'DEP'
52: AND adj.customer_trx_id = p_ct_id

Line 105: p_ct_id IN ra_customer_trx.customer_trx_id%type,

101: | (line, tax, and freight)
102: +===========================================================================*/
103:
104: PROCEDURE get_commitment_adj_detail(
105: p_ct_id IN ra_customer_trx.customer_trx_id%type,
106: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
107: p_amount IN OUT NOCOPY number,
108: p_line_amount IN OUT NOCOPY number,
109: p_tax_amount IN OUT NOCOPY number,

Line 106: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,

102: +===========================================================================*/
103:
104: PROCEDURE get_commitment_adj_detail(
105: p_ct_id IN ra_customer_trx.customer_trx_id%type,
106: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
107: p_amount IN OUT NOCOPY number,
108: p_line_amount IN OUT NOCOPY number,
109: p_tax_amount IN OUT NOCOPY number,
110: p_freight_amount IN OUT NOCOPY number)

Line 125: ra_customer_trx commit_trx

121: p_tax_amount,
122: p_freight_amount
123: FROM ar_adjustments adj,
124: ra_cust_trx_types commit_ctt,
125: ra_customer_trx commit_trx
126: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
127: AND commit_trx.customer_trx_id = p_commit_ct_id
128: AND commit_ctt.type = 'DEP'
129: AND adj.customer_trx_id = p_ct_id

Line 189: p_ct_id IN ra_customer_trx.customer_trx_id%type,

185: | |
186: +===========================================================================*/
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,

Line 190: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,

186: +===========================================================================*/
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,

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 364: p_ct_id IN ra_customer_trx.customer_trx_id%type,

360: | 12-JUL-95 Subash Chadalavada Created |
361: | |
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,

Line 365: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,

361: | |
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,

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 466: p_ct_id IN ra_customer_trx.customer_trx_id%type,

462: | |
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,

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;

Line 719: ra_customer_trx.trx_date%type,

715: +===========================================================================*/
716:
717: FUNCTION check_payment_method(
718: p_trx_date IN
719: ra_customer_trx.trx_date%type,
720: p_customer_id IN
721: ra_customer_trx.customer_trx_id%type,
722: p_site_use_id IN
723: hz_cust_site_uses.site_use_id%type,

Line 721: ra_customer_trx.customer_trx_id%type,

717: FUNCTION check_payment_method(
718: p_trx_date IN
719: ra_customer_trx.trx_date%type,
720: p_customer_id IN
721: ra_customer_trx.customer_trx_id%type,
722: p_site_use_id IN
723: hz_cust_site_uses.site_use_id%type,
724: p_parent_customer_id IN
725: hz_cust_accounts.cust_account_id%type,

Line 881: ra_customer_trx.trx_date%type,

877: +===========================================================================*/
878:
879: FUNCTION check_bank_account(
880: p_trx_date IN
881: ra_customer_trx.trx_date%type,
882: p_currency_code IN
883: fnd_currencies.currency_code%type,
884: p_bill_to_customer_id IN
885: hz_cust_accounts.cust_account_id%type,

Line 997: ra_customer_trx.trx_date%type,

993: +===========================================================================*/
994:
995: PROCEDURE get_cm_header_defaults(
996: p_trx_date IN
997: ra_customer_trx.trx_date%type,
998: p_crtrx_ct_id IN
999: ra_customer_trx.customer_trx_id%type,
1000: p_ct_id IN
1001: ra_customer_trx.customer_trx_id%type,

Line 999: ra_customer_trx.customer_trx_id%type,

995: PROCEDURE get_cm_header_defaults(
996: p_trx_date IN
997: ra_customer_trx.trx_date%type,
998: p_crtrx_ct_id IN
999: ra_customer_trx.customer_trx_id%type,
1000: p_ct_id IN
1001: ra_customer_trx.customer_trx_id%type,
1002: p_bs_id IN
1003: ra_batch_sources.batch_source_id%type,

Line 1001: ra_customer_trx.customer_trx_id%type,

997: ra_customer_trx.trx_date%type,
998: p_crtrx_ct_id IN
999: ra_customer_trx.customer_trx_id%type,
1000: p_ct_id IN
1001: ra_customer_trx.customer_trx_id%type,
1002: p_bs_id IN
1003: ra_batch_sources.batch_source_id%type,
1004: p_gl_date IN
1005: ra_cust_trx_line_gl_dist.gl_date%type,

Line 1033: ra_customer_trx.ship_via%type,

1029: hz_cust_accounts.cust_account_id%type,
1030: p_paying_site_use_id IN
1031: hz_cust_site_uses.site_use_id%type,
1032: p_ship_via IN
1033: ra_customer_trx.ship_via%type,
1034: p_fob_point IN
1035: ra_customer_trx.fob_point%type,
1036: p_invoicing_rule_id IN
1037: ra_customer_trx.invoicing_rule_id%type,

Line 1035: ra_customer_trx.fob_point%type,

1031: hz_cust_site_uses.site_use_id%type,
1032: p_ship_via IN
1033: ra_customer_trx.ship_via%type,
1034: p_fob_point IN
1035: ra_customer_trx.fob_point%type,
1036: p_invoicing_rule_id IN
1037: ra_customer_trx.invoicing_rule_id%type,
1038: p_rev_recog_run_flag IN
1039: varchar2,

Line 1037: ra_customer_trx.invoicing_rule_id%type,

1033: ra_customer_trx.ship_via%type,
1034: p_fob_point IN
1035: ra_customer_trx.fob_point%type,
1036: p_invoicing_rule_id IN
1037: ra_customer_trx.invoicing_rule_id%type,
1038: p_rev_recog_run_flag IN
1039: varchar2,
1040: p_complete_flag IN
1041: ra_customer_trx.complete_flag%type,

Line 1041: ra_customer_trx.complete_flag%type,

1037: ra_customer_trx.invoicing_rule_id%type,
1038: p_rev_recog_run_flag IN
1039: varchar2,
1040: p_complete_flag IN
1041: ra_customer_trx.complete_flag%type,
1042: p_salesrep_required_flag IN
1043: ar_system_parameters.salesrep_required_flag%type,
1044: --
1045: p_crtrx_bs_id IN

Line 1084: ra_customer_trx.ship_via%type,

1080: ar_receipt_methods.receipt_method_id%type,
1081: p_crtrx_cust_bank_account_id IN
1082: ce_bank_accounts.bank_account_id%type,
1083: p_crtrx_ship_via IN
1084: ra_customer_trx.ship_via%type,
1085: p_crtrx_ship_date_actual IN
1086: ra_customer_trx.ship_date_actual%type,
1087: p_crtrx_waybill_number IN
1088: ra_customer_trx.waybill_number%type,

Line 1086: ra_customer_trx.ship_date_actual%type,

1082: ce_bank_accounts.bank_account_id%type,
1083: p_crtrx_ship_via IN
1084: ra_customer_trx.ship_via%type,
1085: p_crtrx_ship_date_actual IN
1086: ra_customer_trx.ship_date_actual%type,
1087: p_crtrx_waybill_number IN
1088: ra_customer_trx.waybill_number%type,
1089: p_crtrx_fob_point IN
1090: ra_customer_trx.fob_point%type,

Line 1088: ra_customer_trx.waybill_number%type,

1084: ra_customer_trx.ship_via%type,
1085: p_crtrx_ship_date_actual IN
1086: ra_customer_trx.ship_date_actual%type,
1087: p_crtrx_waybill_number IN
1088: ra_customer_trx.waybill_number%type,
1089: p_crtrx_fob_point IN
1090: ra_customer_trx.fob_point%type,
1091: --
1092: p_default_bs_id OUT NOCOPY

Line 1090: ra_customer_trx.fob_point%type,

1086: ra_customer_trx.ship_date_actual%type,
1087: p_crtrx_waybill_number IN
1088: ra_customer_trx.waybill_number%type,
1089: p_crtrx_fob_point IN
1090: ra_customer_trx.fob_point%type,
1091: --
1092: p_default_bs_id OUT NOCOPY
1093: ra_batch_sources.batch_source_id%type,
1094: p_default_bs_name OUT NOCOPY

Line 1123: ra_customer_trx.printing_option%type,

1119: ra_cust_trx_types.natural_application_only_flag%type,
1120: p_tax_calculation_flag OUT NOCOPY
1121: ra_cust_trx_types.tax_calculation_flag%type,
1122: p_default_printing_option OUT NOCOPY
1123: ra_customer_trx.printing_option%type,
1124: --
1125: p_default_gl_date OUT NOCOPY
1126: ra_cust_trx_line_gl_dist.gl_date%type,
1127: p_default_ship_to_customer_id OUT NOCOPY

Line 1150: ra_customer_trx.ship_via%type,

1146: hz_cust_accounts.cust_account_id%type,
1147: p_default_paying_site_use_id OUT NOCOPY
1148: hz_cust_site_uses.site_use_id%type,
1149: p_default_ship_via OUT NOCOPY
1150: ra_customer_trx.ship_via%type,
1151: p_default_ship_date_actual OUT NOCOPY
1152: ra_customer_trx.ship_date_actual%type,
1153: p_default_waybill_number OUT NOCOPY
1154: ra_customer_trx.waybill_number%type,

Line 1152: ra_customer_trx.ship_date_actual%type,

1148: hz_cust_site_uses.site_use_id%type,
1149: p_default_ship_via OUT NOCOPY
1150: ra_customer_trx.ship_via%type,
1151: p_default_ship_date_actual OUT NOCOPY
1152: ra_customer_trx.ship_date_actual%type,
1153: p_default_waybill_number OUT NOCOPY
1154: ra_customer_trx.waybill_number%type,
1155: p_default_fob_point OUT NOCOPY
1156: ra_customer_trx.fob_point%type

Line 1154: ra_customer_trx.waybill_number%type,

1150: ra_customer_trx.ship_via%type,
1151: p_default_ship_date_actual OUT NOCOPY
1152: ra_customer_trx.ship_date_actual%type,
1153: p_default_waybill_number OUT NOCOPY
1154: ra_customer_trx.waybill_number%type,
1155: p_default_fob_point OUT NOCOPY
1156: ra_customer_trx.fob_point%type
1157: )
1158: IS

Line 1156: ra_customer_trx.fob_point%type

1152: ra_customer_trx.ship_date_actual%type,
1153: p_default_waybill_number OUT NOCOPY
1154: ra_customer_trx.waybill_number%type,
1155: p_default_fob_point OUT NOCOPY
1156: ra_customer_trx.fob_point%type
1157: )
1158: IS
1159: l_bs_id ra_batch_sources.batch_source_id%type;
1160: l_default_bs_name ra_batch_sources.name%type;