APPS.GL_CURRENCY_API dependencies on GL_FIXED_CONV_RATES

Line 69: -- This routine hits the GL_FIXED_CONV_RATES.

65: --
66: -- Purpose
67: -- Returns Fixed conversion rate between two currencies
68: -- where both currencies are not the EURO, or EMU currencies.
69: -- This routine hits the GL_FIXED_CONV_RATES.
70: --
71: -- History
72: -- 01-Mar-2005 Srini Pala Created
73: --

Line 106: FROM GL_FIXED_CONV_RATES

102: l_eff_date DATE) IS
103: SELECT old_currency,
104: replacement_currency,
105: fixed_conversion_rate
106: FROM GL_FIXED_CONV_RATES
107: WHERE old_currency IN (l_from_curr,l_to_curr)
108: AND effective_start_date <= trunc(l_eff_date)
109: ORDER BY DECODE(old_currency, l_from_curr,0,1);
110: BEGIN

Line 123: GL_FIXED_CONV_RATES table.

119:
120: /*-----------------------------------------------------------------------+
121: This routine should check whether there is a fixed rate relationship
122: exist between the from currency and the to_currency in the
123: GL_FIXED_CONV_RATES table.
124: Some EUROPEAN countries are getting rid of ending zero's
125: from their currency. In this case those countries define
126: a fixed rate relationship between the old currency and the new
127: replacement currency starting from an effective date.

Line 133: OLD Turky Currency -> New Turky Currency in GL_FIXED_CONV_RATES

129: and effective from 01-01-2005.
130: If we want to find a conversion between old Turky currency and
131: USD, then we need to follow the following rule after 01-01-2005.
132: First find rate between
133: OLD Turky Currency -> New Turky Currency in GL_FIXED_CONV_RATES
134: Then
135: New Turky Currency -> USD in GL_DAILY_RATES table.
136: The following code added to do this job.
137: +-----------------------------------------------------------------------*/

Line 144: | Old Currency -> New Currency from the GL_FIXED_CONV_RATES table |

140: | A few possible different scenarios |
141: | The rate may be calculated between two currencies as follows |
142: | |
143: | 1) Old Currency to French Franks |
144: | Old Currency -> New Currency from the GL_FIXED_CONV_RATES table |
145: | New Currency -> EURO from the GL_DAILY_RATES |
146: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |
147: | |
148: | 2) USD to New Currency |

Line 154: | from GL Fixed Conv Rates |

150: | |
151: | 3) USD to Old Currency |
152: | USD -> New CURRENCY from the GL Daily Rates Table. |
153: | New curency -> Old Currency fixed rate |
154: | from GL Fixed Conv Rates |
155: | |
156: | 4) Old Currency to CAD |
157: | Old Currency -> New Currency from |
158: | the GL_FIXED_CONV_RATES table |

Line 158: | the GL_FIXED_CONV_RATES table |

154: | from GL Fixed Conv Rates |
155: | |
156: | 4) Old Currency to CAD |
157: | Old Currency -> New Currency from |
158: | the GL_FIXED_CONV_RATES table |
159: | New Currency -> CAD from the GL_DAILY_RATES |
160: | |
161: +######################################################################*/
162: -- Check the passed currencies have any fixed relationships exist or not.

Line 219: | Then Old1-> NEW1 from GL_FIXED_CONV_RATES, |

215: /*---------------------------------------------------------------------+
216: | This part handles when we are trying to find a rate from |
217: | one coutries old currency to another coutries old currency. |
218: | For example Find a rate between Old1->Old2 |
219: | Then Old1-> NEW1 from GL_FIXED_CONV_RATES, |
220: | New1->New2 from GL_DAILY_RATE |
221: | New2->Old2 from GL_FIXED_CONV_RATES The following code |
222: | handles this calculation. |
223: +---------------------------------------------------------------------*/

Line 221: | New2->Old2 from GL_FIXED_CONV_RATES The following code |

217: | one coutries old currency to another coutries old currency. |
218: | For example Find a rate between Old1->Old2 |
219: | Then Old1-> NEW1 from GL_FIXED_CONV_RATES, |
220: | New1->New2 from GL_DAILY_RATE |
221: | New2->Old2 from GL_FIXED_CONV_RATES The following code |
222: | handles this calculation. |
223: +---------------------------------------------------------------------*/
224: -- Fetch the second row if there exists one.
225:

Line 462: FROM GL_FIXED_CONV_RATES

458: CURSOR is_there_fix_rate(l_from_curr VARCHAR2,
459: l_to_curr VARCHAR2,
460: l_eff_date DATE) IS
461: SELECT 'EXIST'
462: FROM GL_FIXED_CONV_RATES
463: WHERE old_currency IN (l_from_curr,l_to_curr)
464: AND ((old_currency = l_from_curr
465: AND replacement_currency = l_to_curr)
466: OR (replacement_currency = l_from_curr

Line 555: FROM GL_FIXED_CONV_RATES

551: CURSOR is_there_fix_relation(l_from_curr VARCHAR2,
552: l_to_curr VARCHAR2,
553: l_eff_date DATE) IS
554: SELECT 'EXIST'
555: FROM GL_FIXED_CONV_RATES
556: WHERE old_currency IN (l_from_curr,l_to_curr)
557: AND ((old_currency = l_from_curr
558: AND replacement_currency = l_to_curr)
559: OR (replacement_currency = l_from_curr