DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on GL_CURRENCY_API

Line 1203: , GL_CURRENCY_API.GET_RATE_SQL(

1199: ref.amount_applied_from,
1200: ps.invoice_currency_code,
1201: cr.currency_code
1202: )
1203: , GL_CURRENCY_API.GET_RATE_SQL(
1204: ps.invoice_currency_code,
1205: cr.currency_code,
1206: cr.receipt_date,
1207: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 1450: , GL_CURRENCY_API.GET_RATE_SQL(

1446: ref.amount_applied_from,
1447: ps.invoice_currency_code,
1448: cr.currency_code
1449: )
1450: , GL_CURRENCY_API.GET_RATE_SQL(
1451: ps.invoice_currency_code,
1452: cr.currency_code,
1453: cr.receipt_date,
1454: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 1691: , GL_CURRENCY_API.GET_RATE_SQL(

1687: ref.amount_applied_from,
1688: ps.invoice_currency_code,
1689: cr.currency_code
1690: )
1691: , GL_CURRENCY_API.GET_RATE_SQL(
1692: ps.invoice_currency_code,
1693: cr.currency_code,
1694: cr.receipt_date,
1695: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 1935: , GL_CURRENCY_API.GET_RATE_SQL(

1931: ref.amount_applied_from,
1932: ps.invoice_currency_code,
1933: cr.currency_code
1934: )
1935: , GL_CURRENCY_API.GET_RATE_SQL(
1936: ps.invoice_currency_code,
1937: cr.currency_code,
1938: cr.receipt_date,
1939: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 2182: , GL_CURRENCY_API.GET_RATE_SQL(

2178: ref.amount_applied_from,
2179: ps.invoice_currency_code,
2180: cr.currency_code
2181: )
2182: , GL_CURRENCY_API.GET_RATE_SQL(
2183: ps.invoice_currency_code,
2184: cr.currency_code,
2185: cr.receipt_date,
2186: ar_setup.value(''AR_CROSS_CURRENCY_RATE_TYPE'',null) )

Line 2443: , GL_CURRENCY_API.GET_RATE_SQL(

2439: ref.amount_applied_from,
2440: ps.invoice_currency_code,
2441: cr.currency_code
2442: )
2443: , GL_CURRENCY_API.GET_RATE_SQL(
2444: ps.invoice_currency_code,
2445: cr.currency_code,
2446: cr.receipt_date,
2447: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 2665: , GL_CURRENCY_API.GET_RATE_SQL(

2661: ref.amount_applied_from,
2662: ps.invoice_currency_code,
2663: cr.currency_code
2664: )
2665: , GL_CURRENCY_API.GET_RATE_SQL(
2666: ps.invoice_currency_code,
2667: cr.currency_code,
2668: cr.receipt_date,
2669: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 2910: , GL_CURRENCY_API.GET_RATE_SQL(

2906: ref.amount_applied_from,
2907: ps.invoice_currency_code,
2908: cr.currency_code
2909: )
2910: , GL_CURRENCY_API.GET_RATE_SQL(
2911: ps.invoice_currency_code,
2912: cr.currency_code,
2913: cr.receipt_date,
2914: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

Line 3238: AND GL_CURRENCY_API.IS_FIXED_RATE(ps.invoice_currency_code,

3234: AND l.trans_to_receipt_rate IS NOT NULL)
3235: OR EXISTS (SELECT 'Wrong rate for fixed rate currency'
3236: FROM ar_payment_schedules ps
3237: WHERE l.payment_schedule_id = ps.payment_schedule_id
3238: AND GL_CURRENCY_API.IS_FIXED_RATE(ps.invoice_currency_code,
3239: l.receipt_currency_code,
3240: l.receipt_date) = 'Y'
3241: AND l.trans_to_receipt_rate <> ROUND(GL_CURRENCY_API.GET_RATE_SQL(
3242: ps.invoice_currency_code,

Line 3241: AND l.trans_to_receipt_rate <> ROUND(GL_CURRENCY_API.GET_RATE_SQL(

3237: WHERE l.payment_schedule_id = ps.payment_schedule_id
3238: AND GL_CURRENCY_API.IS_FIXED_RATE(ps.invoice_currency_code,
3239: l.receipt_currency_code,
3240: l.receipt_date) = 'Y'
3241: AND l.trans_to_receipt_rate <> ROUND(GL_CURRENCY_API.GET_RATE_SQL(
3242: ps.invoice_currency_code,
3243: l.receipt_currency_code,
3244: l.receipt_date,
3245: null), 38)))