eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_CRM_UTILITIES_PKG dependencies on GL_DAILY_RATES_INTERFACE

Line 454: FROM gl_daily_rates_interface dri,

450: dct.conversion_type,
451: dri.conversion_rate,
452: NVL(dri.inverse_conversion_rate, 1/conversion_rate) inverse_conversion_rate,
453: dri.mode_flag
454: FROM gl_daily_rates_interface dri,
455: gl_daily_conversion_types dct
456: WHERE mode_flag IN ('I', 'D', 'T', 'N')
457: AND dct.user_conversion_type = dri.user_conversion_type;
458:

Line 478: UPDATE gl_daily_rates_interface ri

474: gl_message.func_ent('Daily Rates Import');
475:
476: -- GL_CRM_UTILITIES_PKG.DEBUG_MODE := TRUE;
477:
478: UPDATE gl_daily_rates_interface ri
479: SET ERROR_CODE =
480: (SELECT DECODE
481: (ct.ROWID,
482: NULL, 'NONEXISTANT_CONVERSION_TYPE',

Line 587: FROM gl_daily_rates_interface ri2,

583: 1),
584: -1, 'EMU_TO_CURRENCY',
585: 0, 'EMU_TO_CURRENCY',
586: ''))))))))))))))))))
587: FROM gl_daily_rates_interface ri2,
588: gl_daily_conversion_types ct,
589: fnd_currencies from_curr,
590: fnd_currencies to_curr
591: WHERE ri2.ROWID = ri.ROWID

Line 602: UPDATE gl_daily_rates_interface

598: -- N - no override GL rates
599: -- T - Treasury Insert (override existing GL rates).
600: /*
601: -- Update mode flag to 'X' for each erroneous row
602: UPDATE gl_daily_rates_interface
603: SET mode_flag = 'X'
604: WHERE mode_flag IN('I', 'D') AND ERROR_CODE IS NOT NULL;
605:
606: -- Update mode flag to 'X' for each erroneous row from Treasury

Line 607: UPDATE gl_daily_rates_interface

603: SET mode_flag = 'X'
604: WHERE mode_flag IN('I', 'D') AND ERROR_CODE IS NOT NULL;
605:
606: -- Update mode flag to 'X' for each erroneous row from Treasury
607: UPDATE gl_daily_rates_interface
608: SET mode_flag = 'F'
609: WHERE mode_flag IN('T', 'N') AND ERROR_CODE IS NOT NULL;
610: */
611:

Line 612: UPDATE GL_DAILY_RATES_INTERFACE T1

608: SET mode_flag = 'F'
609: WHERE mode_flag IN('T', 'N') AND ERROR_CODE IS NOT NULL;
610: */
611:
612: UPDATE GL_DAILY_RATES_INTERFACE T1
613: SET T1.error_code = 'DUPLICATE_ROWS'
614: WHERE
615: (T1.USER_CONVERSION_TYPE,
616: T1.FROM_CONVERSION_DATE, T1.TO_CONVERSION_DATE)

Line 620: FROM GL_DAILY_RATES_INTERFACE T2

616: T1.FROM_CONVERSION_DATE, T1.TO_CONVERSION_DATE)
617: IN
618: (SELECT T2.USER_CONVERSION_TYPE,
619: T2.FROM_CONVERSION_DATE, T2.TO_CONVERSION_DATE
620: FROM GL_DAILY_RATES_INTERFACE T2
621: WHERE (T2.FROM_CURRENCY = T1.FROM_CURRENCY
622: OR T2.FROM_CURRENCY = T1.TO_CURRENCY)
623: AND (T2.TO_CURRENCY = T1.TO_CURRENCY
624: OR T2.TO_CURRENCY = T1.FROM_CURRENCY)

Line 631: UPDATE gl_daily_rates_interface ri

627: HAVING count(*) > 1)
628: AND mode_flag IN ('I', 'D', 'T', 'N');
629:
630: -- Update mode flag to X/F for each erroneous row
631: UPDATE gl_daily_rates_interface ri
632: SET mode_flag =
633: Decode(mode_flag,'T','F','N','F','I','X','D','X',mode_flag)
634: WHERE (mode_flag IN('T', 'N','I','D') AND ERROR_CODE IS NOT NULL)
635: OR (mode_flag = 'N'

Line 658: UPDATE gl_daily_rates_interface

654: fnd_file.put_line(fnd_file.LOG,
655: SQL%ROWCOUNT || ' Error records');
656: END IF;
657:
658: UPDATE gl_daily_rates_interface
659: SET inverse_conversion_rate = 1 / conversion_rate
660: WHERE inverse_conversion_rate IS NULL AND conversion_rate > 0;
661:
662: IF DEBUG_MODE THEN

Line 665: 'Finish Validation on GL_DAILY_RATES_INTERFACE table.');

661:
662: IF DEBUG_MODE THEN
663: fnd_file.put_line
664: (fnd_file.LOG,
665: 'Finish Validation on GL_DAILY_RATES_INTERFACE table.');
666: END IF;
667:
668: SELECT from_currency,
669: to_currency,

Line 700: FROM gl_daily_rates_interface

696: daily_rate_validation_failure.r_type,
697: daily_rate_validation_failure.r_rate,
698: daily_rate_validation_failure.r_inverse_rate,
699: daily_rate_validation_failure.r_error_code
700: FROM gl_daily_rates_interface
701: WHERE mode_flag IN('X', 'F');
702:
703: FOR i IN 1 .. daily_rate_validation_failure.r_from_curr.COUNT LOOP
704: IF page_line_count = 1 THEN

Line 787: gl_daily_rates_interface ri

783: FROM gl_daily_rates dr,
784: gl_daily_conversion_types gldct,
785: gl_row_multipliers rm,
786: gl_daily_conversion_types ct,
787: gl_daily_rates_interface ri
788: WHERE ri.mode_flag = 'D'
789: AND ct.user_conversion_type = ri.user_conversion_type || ''
790: AND rm.multiplier BETWEEN 1 AND (TRUNC(ri.to_conversion_date)
791: - TRUNC(ri.from_conversion_date)

Line 869: gl_daily_rates_interface ri

865: FROM gl_daily_rates dr,
866: gl_daily_conversion_types gldct,
867: gl_row_multipliers rm,
868: gl_daily_conversion_types ct,
869: gl_daily_rates_interface ri
870: WHERE ct.user_conversion_type = ri.user_conversion_type || ''
871: AND rm.multiplier BETWEEN 1 AND (TRUNC(ri.to_conversion_date)
872: - TRUNC(ri.from_conversion_date)
873: + 1)

Line 928: UPDATE gl_daily_rates_interface ri

924:
925: -- Update used_for_ab_translation = 'Y' if the currency and
926: -- conversion type is used in average translation in the system
927: -- R12 Change in the following update
928: UPDATE gl_daily_rates_interface ri
929: SET used_for_ab_translation =
930: ( SELECT nvl(max('Y'), 'N')
931: FROM gl_daily_conversion_types ct,
932: gl_ledgers led,

Line 952: FROM gl_daily_rates_interface

948: BEGIN
949:
950: SELECT 'Y'
951: INTO l_launch_rate_change
952: FROM gl_daily_rates_interface
953: WHERE used_for_ab_translation = 'Y'
954: AND ROWNUM < 2;
955:
956: EXCEPTION

Line 986: gl_daily_rates_interface ri

982: TRUNC(ri.from_conversion_date) + rm.multiplier
983: - 1
984: FROM gl_row_multipliers rm,
985: gl_daily_conversion_types ct,
986: gl_daily_rates_interface ri
987: WHERE ri.mode_flag = 'D'
988: AND ri.used_for_ab_translation = 'Y'
989: AND ct.user_conversion_type =
990: ri.user_conversion_type || ''

Line 1004: gl_daily_rates_interface ri

1000: TRUNC(ri.from_conversion_date) + rm.multiplier
1001: - 1
1002: FROM gl_row_multipliers rm,
1003: gl_daily_conversion_types ct,
1004: gl_daily_rates_interface ri
1005: WHERE ri.mode_flag = 'D'
1006: AND ri.used_for_ab_translation = 'Y'
1007: AND ct.user_conversion_type =
1008: ri.user_conversion_type || ''

Line 1041: gl_daily_rates_interface ri

1037: TRUNC(ri.from_conversion_date)
1038: + rm.multiplier - 1
1039: FROM gl_row_multipliers rm,
1040: gl_daily_conversion_types ct,
1041: gl_daily_rates_interface ri
1042: WHERE ( ri.mode_flag IN('I', 'T')
1043: OR ( ri.mode_flag = 'D'
1044: AND ri.used_for_ab_translation <> 'Y'))
1045: AND ct.user_conversion_type =

Line 1060: gl_daily_rates_interface ri

1056: TRUNC(ri.from_conversion_date)
1057: + rm.multiplier - 1
1058: FROM gl_row_multipliers rm,
1059: gl_daily_conversion_types ct,
1060: gl_daily_rates_interface ri
1061: WHERE ( ri.mode_flag IN('I', 'T')
1062: OR ( ri.mode_flag = 'D'
1063: AND ri.used_for_ab_translation <> 'Y'))
1064: AND ct.user_conversion_type =

Line 1109: gl_daily_rates_interface ri

1105: ri.attribute14, ri.attribute15,
1106: DECODE(ri.mode_flag, 'T', 'TREASURY', 'N', 'TREASURY', 'USER')
1107: FROM gl_row_multipliers rm,
1108: gl_daily_conversion_types ct,
1109: gl_daily_rates_interface ri
1110: WHERE ri.mode_flag IN('I', 'T', 'N')
1111: AND ct.user_conversion_type = ri.user_conversion_type || ''
1112: AND rm.multiplier BETWEEN 1
1113: AND TRUNC(ri.to_conversion_date)

Line 1141: gl_daily_rates_interface ri

1137: ri.attribute14, ri.attribute15,
1138: DECODE(ri.mode_flag, 'T', 'TREASURY', 'N', 'TREASURY', 'USER')
1139: FROM gl_row_multipliers rm,
1140: gl_daily_conversion_types ct,
1141: gl_daily_rates_interface ri
1142: WHERE ri.mode_flag IN('I', 'T', 'N')
1143: AND ct.user_conversion_type = ri.user_conversion_type || ''
1144: AND rm.multiplier BETWEEN 1
1145: AND TRUNC(ri.to_conversion_date)

Line 1195: FROM gl_daily_rates_interface

1191:
1192: --- Cross Rates Calculation ---
1193: SELECT COUNT(*)
1194: INTO rows_need_calculation
1195: FROM gl_daily_rates_interface
1196: WHERE mode_flag IN('I', 'D', 'T', 'N')
1197: AND user_conversion_type IN(
1198: SELECT user_conversion_type
1199: FROM gl_daily_conversion_types gct,

Line 1215: -- Delete all valid rows in GL_DAILY_RATES_INTERFACE and do not need

1211: END IF;
1212: END IF;
1213:
1214: IF rows_need_calculation > 0 THEN
1215: -- Delete all valid rows in GL_DAILY_RATES_INTERFACE and do not need
1216: -- crossing rates calculation
1217: DELETE FROM gl_daily_rates_interface
1218: WHERE mode_flag IN('I', 'D', 'T', 'N')
1219: AND user_conversion_type NOT IN(

Line 1217: DELETE FROM gl_daily_rates_interface

1213:
1214: IF rows_need_calculation > 0 THEN
1215: -- Delete all valid rows in GL_DAILY_RATES_INTERFACE and do not need
1216: -- crossing rates calculation
1217: DELETE FROM gl_daily_rates_interface
1218: WHERE mode_flag IN('I', 'D', 'T', 'N')
1219: AND user_conversion_type NOT IN(
1220: SELECT user_conversion_type
1221: FROM gl_daily_conversion_types gct,

Line 1263: FROM gl_daily_rates_interface gldri,

1259: glcrs.pivot_currency, gldri.inverse_conversion_rate,
1260: gldri.conversion_rate),
1261: DECODE(gldri.mode_flag, 'D', 'D', 'I'),
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')

Line 1506: -- GL_DAILY_RATES_INTERFACE where mode = 'D',

1502: 'Mark D for Cross Rates');
1503: END IF;
1504:
1505: -- For each row with conversion rate in
1506: -- GL_DAILY_RATES_INTERFACE where mode = 'D',
1507: -- set status_code to 'D' in the corresponding row in GL_DAILY_RATES.
1508: UPDATE gl_daily_rates gldr
1509: SET status_code = 'D'
1510: WHERE ( (gldr.rate_source_code IS NOT NULL

Line 1778: DELETE FROM gl_daily_rates_interface

1774: END IF;
1775:
1776: ---- End Calculation
1777:
1778: DELETE FROM gl_daily_rates_interface
1779: WHERE mode_flag IN('I', 'D', 'T', 'N');
1780:
1781: -- Launch the Rate Change Program if needed
1782: IF (l_launch_rate_change = 'Y') THEN

Line 1816: DELETE FROM gl_daily_rates_interface

1812: ('WARNING',
1813: 'Exceptions occurs, please check the output for details.');
1814: END IF;
1815:
1816: DELETE FROM gl_daily_rates_interface
1817: WHERE mode_flag IN('I', 'D', 'T', 'N');
1818: END daily_rates_import;
1819:
1820: -------------------------------------------------------------------