APPS.ITG_SYNCEXCHINBOUND_PVT dependencies on GL_DAILY_RATES_INTERFACE

Line 246: itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);

242: itg_debug_pub.Add('PER - Processing data.' ,1);
243: END IF;
244:
245: IF (l_Debug_Level <= 1) THEN
246: itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);
247: END IF;
248:
249: /* Set the Enable Trigger flag to TRUE "gl_crm_utilities_pkg.enable_trigger" */
250: gl_crm_utilities_pkg.change_flag(TRUE);

Line 252: INSERT INTO gl_daily_rates_interface(

248:
249: /* Set the Enable Trigger flag to TRUE "gl_crm_utilities_pkg.enable_trigger" */
250: gl_crm_utilities_pkg.change_flag(TRUE);
251:
252: INSERT INTO gl_daily_rates_interface(
253: from_currency, to_currency,
254: from_conversion_date, to_conversion_date,
255: user_conversion_type, conversion_rate, mode_flag
256: ) VALUES (

Line 267: FROM gl_daily_rates_interface

263:
264: DECLARE
265: CURSOR get_error_code IS
266: SELECT error_code
267: FROM gl_daily_rates_interface
268: WHERE from_currency = p_currency_from
269: AND to_currency = p_currency_to
270: AND from_conversion_date = p_effective_date
271: AND to_conversion_date = p_effective_date

Line 275: l_error_code gl_daily_rates_interface.error_code%TYPE;

271: AND to_conversion_date = p_effective_date
272: AND user_conversion_type = 'Corporate'
273: AND mode_flag = 'X';
274:
275: l_error_code gl_daily_rates_interface.error_code%TYPE;
276: l_found BOOLEAN;
277:
278: BEGIN
279: IF (l_Debug_Level <= 1) THEN

Line 280: itg_debug_pub.Add('PER - Check errors in gl_daily_rates_interface' ,1);

276: l_found BOOLEAN;
277:
278: BEGIN
279: IF (l_Debug_Level <= 1) THEN
280: itg_debug_pub.Add('PER - Check errors in gl_daily_rates_interface' ,1);
281: END IF;
282:
283: OPEN get_error_code;
284: FETCH get_error_code INTO l_error_code;