APPS.GL_CRM_UTILITIES_PKG dependencies on GL_CROSS_RATE_RULE_DTLS

Line 274: FROM gl_cross_rate_rule_dtls

270: WHERE conversion_type = p_conversion_type;
271:
272: SELECT DISTINCT from_currency
273: BULK COLLECT INTO existed_curr_rec.r_from_curr
274: FROM gl_cross_rate_rule_dtls
275: WHERE conversion_type = p_conversion_type;
276:
277: --IF (existed_curr_rec.r_from_curr.COUNT = 0) THEN
278: -- modify this, always insert the dummy rows, we can use those rows in VO.

Line 279: INSERT INTO gl_cross_rate_rule_dtls

275: WHERE conversion_type = p_conversion_type;
276:
277: --IF (existed_curr_rec.r_from_curr.COUNT = 0) THEN
278: -- modify this, always insert the dummy rows, we can use those rows in VO.
279: INSERT INTO gl_cross_rate_rule_dtls
280: (conversion_type, from_currency, to_currency,
281: enabled_flag, last_update_date, last_updated_by,
282: creation_date, created_by, last_update_login)
283: VALUES (p_conversion_type, p_contra_currency, p_contra_currency,

Line 290: INSERT INTO gl_cross_rate_rule_dtls

286:
287: IF (existed_curr_rec.r_from_curr.COUNT > 0) THEN
288: /* at least one contra currency is existed */
289: FORALL i IN 1 .. existed_curr_rec.r_from_curr.COUNT
290: INSERT INTO gl_cross_rate_rule_dtls
291: (conversion_type, from_currency,
292: to_currency, enabled_flag, last_update_date,
293: last_updated_by, creation_date, created_by,
294: last_update_login)

Line 300: INSERT INTO gl_cross_rate_rule_dtls

296: existed_curr_rec.r_from_curr(i), 'Y', SYSDATE,
297: p_login_user, SYSDATE, p_login_user,
298: p_login_user);
299: FORALL i IN 1 .. existed_curr_rec.r_from_curr.COUNT
300: INSERT INTO gl_cross_rate_rule_dtls
301: (conversion_type, from_currency,
302: to_currency, enabled_flag, last_update_date,
303: last_updated_by, creation_date, created_by,
304: last_update_login)

Line 325: UPDATE gl_cross_rate_rule_dtls

321: INTO x_pivot_currency
322: FROM gl_cross_rate_rules
323: WHERE conversion_type = p_conversion_type;
324:
325: UPDATE gl_cross_rate_rule_dtls
326: SET from_currency = p_new_contra_currency,
327: last_update_date = SYSDATE,
328: last_updated_by = p_login_user,
329: last_update_login = p_login_user

Line 333: UPDATE gl_cross_rate_rule_dtls

329: last_update_login = p_login_user
330: WHERE conversion_type = p_conversion_type
331: AND from_currency = p_old_contra_currency;
332:
333: UPDATE gl_cross_rate_rule_dtls
334: SET to_currency = p_new_contra_currency,
335: last_update_date = SYSDATE,
336: last_updated_by = p_login_user,
337: last_update_login = p_login_user

Line 347: DELETE FROM gl_cross_rate_rule_dtls

343: PROCEDURE delete_cross_rate_set(
344: p_conversion_type IN VARCHAR2,
345: p_contra_currency IN VARCHAR2) IS
346: BEGIN
347: DELETE FROM gl_cross_rate_rule_dtls
348: WHERE conversion_type = p_conversion_type
349: AND ( from_currency = p_contra_currency
350: OR to_currency = p_contra_currency);
351: END delete_cross_rate_set;

Line 1266: gl_cross_rate_rule_dtls glcrsd

1262: gldri.used_for_ab_translation
1263: FROM gl_daily_rates_interface gldri,
1264: gl_daily_conversion_types gldct,
1265: gl_cross_rate_rules glcrs,
1266: gl_cross_rate_rule_dtls glcrsd
1267: WHERE gldri.mode_flag IN('I', 'D', 'T', 'N')
1268: AND gldri.user_conversion_type = gldct.user_conversion_type
1269: AND gldct.conversion_type = glcrs.conversion_type
1270: AND ( ( (gldri.from_currency = glcrs.pivot_currency)

Line 1273: FROM gl_cross_rate_rule_dtls glcrsd2

1269: AND gldct.conversion_type = glcrs.conversion_type
1270: AND ( ( (gldri.from_currency = glcrs.pivot_currency)
1271: AND (gldri.to_currency IN(
1272: SELECT DISTINCT from_currency
1273: FROM gl_cross_rate_rule_dtls glcrsd2
1274: WHERE glcrs.conversion_type =
1275: glcrsd2.conversion_type
1276: --AND glcrs.pivot_currency = glcrsd2.pivot_currency
1277: AND glcrsd2.enabled_flag = 'Y')))

Line 1281: FROM gl_cross_rate_rule_dtls glcrsd3

1277: AND glcrsd2.enabled_flag = 'Y')))
1278: OR ( (gldri.to_currency = glcrs.pivot_currency)
1279: AND (gldri.from_currency IN(
1280: SELECT DISTINCT from_currency
1281: FROM gl_cross_rate_rule_dtls glcrsd3
1282: WHERE glcrs.conversion_type =
1283: glcrsd3.conversion_type
1284: --AND glcrs.pivot_currency = glcrsd3.pivot_currency
1285: AND glcrsd3.enabled_flag = 'Y'))))