APPS.GL_CRM_UTILITIES_PKG dependencies on GL_CROSS_RATE_RULE_DTLS

Line 283: FROM gl_cross_rate_rule_dtls

279: WHERE conversion_type = p_conversion_type;
280:
281: SELECT DISTINCT from_currency
282: BULK COLLECT INTO existed_curr_rec.r_from_curr
283: FROM gl_cross_rate_rule_dtls
284: WHERE conversion_type = p_conversion_type;
285:
286: --IF (existed_curr_rec.r_from_curr.COUNT = 0) THEN
287: -- modify this, always insert the dummy rows, we can use those rows in VO.

Line 288: INSERT INTO gl_cross_rate_rule_dtls

284: WHERE conversion_type = p_conversion_type;
285:
286: --IF (existed_curr_rec.r_from_curr.COUNT = 0) THEN
287: -- modify this, always insert the dummy rows, we can use those rows in VO.
288: INSERT INTO gl_cross_rate_rule_dtls
289: (conversion_type, from_currency, to_currency,
290: enabled_flag, last_update_date, last_updated_by,
291: creation_date, created_by, last_update_login)
292: VALUES (p_conversion_type, p_contra_currency, p_contra_currency,

Line 299: INSERT INTO gl_cross_rate_rule_dtls

295:
296: IF (existed_curr_rec.r_from_curr.COUNT > 0) THEN
297: /* at least one contra currency is existed */
298: FORALL i IN 1 .. existed_curr_rec.r_from_curr.COUNT
299: INSERT INTO gl_cross_rate_rule_dtls
300: (conversion_type, from_currency,
301: to_currency, enabled_flag, last_update_date,
302: last_updated_by, creation_date, created_by,
303: last_update_login)

Line 309: INSERT INTO gl_cross_rate_rule_dtls

305: existed_curr_rec.r_from_curr(i), 'Y', SYSDATE,
306: p_login_user, SYSDATE, p_login_user,
307: p_login_user);
308: FORALL i IN 1 .. existed_curr_rec.r_from_curr.COUNT
309: INSERT INTO gl_cross_rate_rule_dtls
310: (conversion_type, from_currency,
311: to_currency, enabled_flag, last_update_date,
312: last_updated_by, creation_date, created_by,
313: last_update_login)

Line 334: UPDATE gl_cross_rate_rule_dtls

330: INTO x_pivot_currency
331: FROM gl_cross_rate_rules
332: WHERE conversion_type = p_conversion_type;
333:
334: UPDATE gl_cross_rate_rule_dtls
335: SET from_currency = p_new_contra_currency,
336: last_update_date = SYSDATE,
337: last_updated_by = p_login_user,
338: last_update_login = p_login_user

Line 342: UPDATE gl_cross_rate_rule_dtls

338: last_update_login = p_login_user
339: WHERE conversion_type = p_conversion_type
340: AND from_currency = p_old_contra_currency;
341:
342: UPDATE gl_cross_rate_rule_dtls
343: SET to_currency = p_new_contra_currency,
344: last_update_date = SYSDATE,
345: last_updated_by = p_login_user,
346: last_update_login = p_login_user

Line 356: DELETE FROM gl_cross_rate_rule_dtls

352: PROCEDURE delete_cross_rate_set(
353: p_conversion_type IN VARCHAR2,
354: p_contra_currency IN VARCHAR2) IS
355: BEGIN
356: DELETE FROM gl_cross_rate_rule_dtls
357: WHERE conversion_type = p_conversion_type
358: AND ( from_currency = p_contra_currency
359: OR to_currency = p_contra_currency);
360: END delete_cross_rate_set;

Line 1473: gl_cross_rate_rule_dtls glcrsd

1469: gldri.used_for_ab_translation
1470: FROM gl_daily_rates_interface gldri,
1471: gl_daily_conversion_types gldct,
1472: gl_cross_rate_rules glcrs,
1473: gl_cross_rate_rule_dtls glcrsd
1474: WHERE gldri.mode_flag IN('I', 'D', 'T', 'N')
1475: AND gldri.user_conversion_type = gldct.user_conversion_type
1476: AND gldct.conversion_type = glcrs.conversion_type
1477: AND ( ( (gldri.from_currency = glcrs.pivot_currency)

Line 1480: FROM gl_cross_rate_rule_dtls glcrsd2

1476: AND gldct.conversion_type = glcrs.conversion_type
1477: AND ( ( (gldri.from_currency = glcrs.pivot_currency)
1478: AND (gldri.to_currency IN(
1479: SELECT DISTINCT from_currency
1480: FROM gl_cross_rate_rule_dtls glcrsd2
1481: WHERE glcrs.conversion_type =
1482: glcrsd2.conversion_type
1483: --AND glcrs.pivot_currency = glcrsd2.pivot_currency
1484: AND glcrsd2.enabled_flag = 'Y')))

Line 1488: FROM gl_cross_rate_rule_dtls glcrsd3

1484: AND glcrsd2.enabled_flag = 'Y')))
1485: OR ( (gldri.to_currency = glcrs.pivot_currency)
1486: AND (gldri.from_currency IN(
1487: SELECT DISTINCT from_currency
1488: FROM gl_cross_rate_rule_dtls glcrsd3
1489: WHERE glcrs.conversion_type =
1490: glcrsd3.conversion_type
1491: --AND glcrs.pivot_currency = glcrsd3.pivot_currency
1492: AND glcrsd3.enabled_flag = 'Y'))))