APPS.GL_EBI_PUB dependencies on GL_DAILY_RATES_INTERFACE

Line 40: FROM GL_DAILY_RATES_INTERFACE

36: FOR i IN p_daily_rates_tbl.FIRST..p_daily_rates_tbl.LAST LOOP
37: l_count := 0;
38:
39: SELECT count(1) INTO l_count
40: FROM GL_DAILY_RATES_INTERFACE
41: WHERE FROM_CURRENCY = p_daily_rates_tbl(i).TO_CURRENCY
42: AND TO_CURRENCY = p_daily_rates_tbl(i).FROM_CURRENCY
43: AND FROM_CONVERSION_DATE = p_daily_rates_tbl(i).FROM_CONVERSION_DATE
44: AND TO_CONVERSION_DATE = p_daily_rates_tbl(i).TO_CONVERSION_DATE

Line 49: UPDATE GL_DAILY_RATES_INTERFACE

45: AND USER_CONVERSION_TYPE = p_daily_rates_tbl(i).USER_CONVERSION_TYPE
46: AND BATCH_NUMBER = p_integration_id;
47:
48: IF (l_count > 0) THEN
49: UPDATE GL_DAILY_RATES_INTERFACE
50: SET INVERSE_CONVERSION_RATE = p_daily_rates_tbl(i).CONVERSION_RATE
51: WHERE FROM_CURRENCY = p_daily_rates_tbl(i).TO_CURRENCY
52: AND TO_CURRENCY = p_daily_rates_tbl(i).FROM_CURRENCY
53: AND FROM_CONVERSION_DATE = p_daily_rates_tbl(i).FROM_CONVERSION_DATE

Line 59: INSERT INTO GL_DAILY_RATES_INTERFACE(

55: AND USER_CONVERSION_TYPE = p_daily_rates_tbl(i).USER_CONVERSION_TYPE
56: AND BATCH_NUMBER = p_integration_id;
57:
58: ELSE
59: INSERT INTO GL_DAILY_RATES_INTERFACE(
60: FROM_CURRENCY,
61: TO_CURRENCY,
62: FROM_CONVERSION_DATE,
63: TO_CONVERSION_DATE,

Line 155: FROM GL_DAILY_RATES_INTERFACE

151: ATTRIBUTE14,
152: USED_FOR_AB_TRANSLATION,
153: ATTRIBUTE15)
154: BULK COLLECT INTO l_sorted_table
155: FROM GL_DAILY_RATES_INTERFACE
156: WHERE BATCH_NUMBER = p_integration_id
157: ORDER BY FROM_CURRENCY,TO_CURRENCY,USER_CONVERSION_TYPE,FROM_CONVERSION_DATE;
158:
159: IF l_sorted_table IS NOT NULL AND l_sorted_table.COUNT >0 THEN

Line 165: UPDATE GL_DAILY_RATES_INTERFACE

161: IF (i <>l_sorted_table.LAST) AND (l_sorted_table(i).FROM_CURRENCY = l_sorted_table(i+1).FROM_CURRENCY
162: AND l_sorted_table(i).TO_CURRENCY = l_sorted_table(i+1).TO_CURRENCY
163: AND l_sorted_table(i).USER_CONVERSION_TYPE = l_sorted_table(i+1).USER_CONVERSION_TYPE) THEN
164:
165: UPDATE GL_DAILY_RATES_INTERFACE
166: SET TO_CONVERSION_DATE = l_sorted_table(i+1).FROM_CONVERSION_DATE-1
167: WHERE FROM_CURRENCY = l_sorted_table(i).FROM_CURRENCY
168: AND TO_CURRENCY = l_sorted_table(i).TO_CURRENCY
169: AND FROM_CONVERSION_DATE = l_sorted_table(i).FROM_CONVERSION_DATE

Line 252: FROM GL_DAILY_RATES_INTERFACE

248: ATTRIBUTE13,
249: ATTRIBUTE14,
250: USED_FOR_AB_TRANSLATION,
251: ATTRIBUTE15)
252: FROM GL_DAILY_RATES_INTERFACE
253: WHERE
254: BATCH_NUMBER = p_integration_id;
255:
256: l_err_msg VARCHAR2(32000);

Line 281: DELETE FROM gl_daily_rates_interface WHERE batch_number = p_integration_id;

277: END IF;
278:
279: END LOOP;
280:
281: DELETE FROM gl_daily_rates_interface WHERE batch_number = p_integration_id;
282:
283: END IF;
284:
285: IF p_commit = FND_API.g_true THEN