APPS.AR_CMGT_AGING dependencies on GL_CURRENCY_API

Line 139: SELECT sum( gl_currency_api.convert_amount(

135: CURSOR c_buckets1 IS
136: select sum(adr), sum(bucket0), sum(bucket1), sum(bucket2),
137: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)
138: from(
139: SELECT sum( gl_currency_api.convert_amount(
140: ps.invoice_currency_code,
141: p_currency_code,
142: sysdate,
143: p_exchange_rate_type,

Line 148: * gl_currency_api.convert_amount(

144: ps.amount_due_remaining)) adr,
145: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
146: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
147: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
148: * gl_currency_api.convert_amount(
149: ps.invoice_currency_code,
150: p_currency_code,
151: sysdate,
152: p_exchange_rate_type,

Line 157: * gl_currency_api.convert_amount(

153: ps.amount_due_remaining)) bucket0 ,
154: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
155: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
156: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
157: * gl_currency_api.convert_amount(
158: ps.invoice_currency_code,
159: p_currency_code,
160: sysdate,
161: p_exchange_rate_type,

Line 166: * gl_currency_api.convert_amount(

162: ps.amount_due_remaining)) bucket1 ,
163: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
164: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
165: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
166: * gl_currency_api.convert_amount(
167: ps.invoice_currency_code,
168: p_currency_code,
169: sysdate,
170: p_exchange_rate_type,

Line 175: * gl_currency_api.convert_amount(

171: ps.amount_due_remaining)) bucket2 ,
172: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
173: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
174: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
175: * gl_currency_api.convert_amount(
176: ps.invoice_currency_code,
177: p_currency_code,
178: sysdate,
179: p_exchange_rate_type,

Line 184: * gl_currency_api.convert_amount(

180: ps.amount_due_remaining)) bucket3 ,
181: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
182: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
183: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
184: * gl_currency_api.convert_amount(
185: ps.invoice_currency_code,
186: p_currency_code,
187: sysdate,
188: p_exchange_rate_type,

Line 193: * gl_currency_api.convert_amount(

189: ps.amount_due_remaining)) bucket4 ,
190: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
191: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
192: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
193: * gl_currency_api.convert_amount(
194: ps.invoice_currency_code,
195: p_currency_code,
196: sysdate,
197: p_exchange_rate_type,

Line 202: * gl_currency_api.convert_amount(

198: ps.amount_due_remaining)) bucket5 ,
199: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
200: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
201: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
202: * gl_currency_api.convert_amount(
203: ps.invoice_currency_code,
204: p_currency_code,
205: sysdate,
206: p_exchange_rate_type,

Line 260: sum( gl_currency_api.convert_amount(

256: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)
257: from(
258: -----All the receipt and CM applications after the as of date ---------
259: SELECT
260: sum( gl_currency_api.convert_amount(
261: ps.invoice_currency_code,
262: p_currency_code,
263: sysdate,
264: p_exchange_rate_type,

Line 271: * gl_currency_api.convert_amount(

267: + NVL(ra.unearned_discount_taken,0) ))) adr,
268: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
269: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
270: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
271: * gl_currency_api.convert_amount(
272: ps.invoice_currency_code,
273: p_currency_code,
274: sysdate,
275: p_exchange_rate_type,

Line 282: * gl_currency_api.convert_amount(

278: + NVL(ra.unearned_discount_taken,0) ))) bucket0 ,
279: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
280: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
281: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
282: * gl_currency_api.convert_amount(
283: ps.invoice_currency_code,
284: p_currency_code,
285: sysdate,
286: p_exchange_rate_type,

Line 293: * gl_currency_api.convert_amount(

289: + NVL(ra.unearned_discount_taken,0) ))) bucket1 ,
290: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
291: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
292: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
293: * gl_currency_api.convert_amount(
294: ps.invoice_currency_code,
295: p_currency_code,
296: sysdate,
297: p_exchange_rate_type,

Line 304: * gl_currency_api.convert_amount(

300: + NVL(ra.unearned_discount_taken,0) ))) bucket2 ,
301: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
302: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
303: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
304: * gl_currency_api.convert_amount(
305: ps.invoice_currency_code,
306: p_currency_code,
307: sysdate,
308: p_exchange_rate_type,

Line 315: * gl_currency_api.convert_amount(

311: + NVL(ra.unearned_discount_taken,0) ))) bucket3 ,
312: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
313: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
314: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
315: * gl_currency_api.convert_amount(
316: ps.invoice_currency_code,
317: p_currency_code,
318: sysdate,
319: p_exchange_rate_type,

Line 326: * gl_currency_api.convert_amount(

322: + NVL(ra.unearned_discount_taken,0) ))) bucket4 ,
323: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
324: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
325: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
326: * gl_currency_api.convert_amount(
327: ps.invoice_currency_code,
328: p_currency_code,
329: sysdate,
330: p_exchange_rate_type,

Line 337: * gl_currency_api.convert_amount(

333: + NVL(ra.unearned_discount_taken,0) ))) bucket5 ,
334: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
335: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
336: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
337: * gl_currency_api.convert_amount(
338: ps.invoice_currency_code,
339: p_currency_code,
340: sysdate,
341: p_exchange_rate_type,

Line 403: -sum(gl_currency_api.convert_amount(

399: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)
400: from(
401: ------------All the adjustments after the as of date---------------
402: SELECT
403: -sum(gl_currency_api.convert_amount(
404: ps.invoice_currency_code,
405: p_currency_code,
406: sysdate,
407: p_exchange_rate_type,

Line 412: * gl_currency_api.convert_amount(

408: adj.amount)) adr,
409: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
410: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
411: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
412: * gl_currency_api.convert_amount(
413: ps.invoice_currency_code,
414: p_currency_code,
415: sysdate,
416: p_exchange_rate_type,

Line 421: * gl_currency_api.convert_amount(

417: adj.amount)) bucket0 ,
418: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
419: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
420: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
421: * gl_currency_api.convert_amount(
422: ps.invoice_currency_code,
423: p_currency_code,
424: sysdate,
425: p_exchange_rate_type,

Line 430: * gl_currency_api.convert_amount(

426: adj.amount)) bucket1 ,
427: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
428: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
429: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
430: * gl_currency_api.convert_amount(
431: ps.invoice_currency_code,
432: p_currency_code,
433: sysdate,
434: p_exchange_rate_type,

Line 439: * gl_currency_api.convert_amount(

435: adj.amount)) bucket2 ,
436: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
437: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
438: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
439: * gl_currency_api.convert_amount(
440: ps.invoice_currency_code,
441: p_currency_code,
442: sysdate,
443: p_exchange_rate_type,

Line 448: * gl_currency_api.convert_amount(

444: adj.amount)) bucket3 ,
445: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
446: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
447: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
448: * gl_currency_api.convert_amount(
449: ps.invoice_currency_code,
450: p_currency_code,
451: sysdate,
452: p_exchange_rate_type,

Line 457: * gl_currency_api.convert_amount(

453: adj.amount)) bucket4 ,
454: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
455: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
456: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
457: * gl_currency_api.convert_amount(
458: ps.invoice_currency_code,
459: p_currency_code,
460: sysdate,
461: p_exchange_rate_type,

Line 466: * gl_currency_api.convert_amount(

462: adj.amount)) bucket5 ,
463: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
464: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
465: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
466: * gl_currency_api.convert_amount(
467: ps.invoice_currency_code,
468: p_currency_code,
469: sysdate,
470: p_exchange_rate_type,

Line 526: SELECT sum(gl_currency_api.convert_amount(

522: select sum(adr), sum(bucket0), sum(bucket1), sum(bucket2),
523: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)
524: from(
525: ---------all the CM applications after the as of date -----------
526: SELECT sum(gl_currency_api.convert_amount(
527: ps.invoice_currency_code,
528: p_currency_code,
529: sysdate,
530: p_exchange_rate_type,

Line 537: * gl_currency_api.convert_amount(

533: + NVL(ra.unearned_discount_taken,0) ))) adr,
534: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
535: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
536: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
537: * gl_currency_api.convert_amount(
538: ps.invoice_currency_code,
539: p_currency_code,
540: sysdate,
541: p_exchange_rate_type,

Line 548: * gl_currency_api.convert_amount(

544: + NVL(ra.unearned_discount_taken,0) ))) bucket0 ,
545: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
546: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
547: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
548: * gl_currency_api.convert_amount(
549: ps.invoice_currency_code,
550: p_currency_code,
551: sysdate,
552: p_exchange_rate_type,

Line 559: * gl_currency_api.convert_amount(

555: + NVL(ra.unearned_discount_taken,0) ))) bucket1 ,
556: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
557: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
558: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
559: * gl_currency_api.convert_amount(
560: ps.invoice_currency_code,
561: p_currency_code,
562: sysdate,
563: p_exchange_rate_type,

Line 570: * gl_currency_api.convert_amount(

566: + NVL(ra.unearned_discount_taken,0) ))) bucket2 ,
567: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
568: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
569: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
570: * gl_currency_api.convert_amount(
571: ps.invoice_currency_code,
572: p_currency_code,
573: sysdate,
574: p_exchange_rate_type,

Line 581: * gl_currency_api.convert_amount(

577: + NVL(ra.unearned_discount_taken,0) ))) bucket3 ,
578: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
579: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
580: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
581: * gl_currency_api.convert_amount(
582: ps.invoice_currency_code,
583: p_currency_code,
584: sysdate,
585: p_exchange_rate_type,

Line 592: * gl_currency_api.convert_amount(

588: + NVL(ra.unearned_discount_taken,0) ))) bucket4 ,
589: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
590: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
591: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
592: * gl_currency_api.convert_amount(
593: ps.invoice_currency_code,
594: p_currency_code,
595: sysdate,
596: p_exchange_rate_type,

Line 603: * gl_currency_api.convert_amount(

599: + NVL(ra.unearned_discount_taken,0) ))) bucket5 ,
600: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
601: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
602: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
603: * gl_currency_api.convert_amount(
604: ps.invoice_currency_code,
605: p_currency_code,
606: sysdate,
607: p_exchange_rate_type,