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.FND_CURRENCIES_PKG dependencies on FND_CURRENCIES

Line 1: package body FND_CURRENCIES_PKG as

1: package body FND_CURRENCIES_PKG as
2: /* $Header: AFNLDCXB.pls 120.6 2007/08/27 22:59:59 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 65: cursor C is select ROWID from FND_CURRENCIES

61: X_LAST_UPDATE_DATE in DATE,
62: X_LAST_UPDATED_BY in NUMBER,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: cursor C is select ROWID from FND_CURRENCIES
66: where CURRENCY_CODE = X_CURRENCY_CODE
67: ;
68: begin
69: insert into FND_CURRENCIES (

Line 69: insert into FND_CURRENCIES (

65: cursor C is select ROWID from FND_CURRENCIES
66: where CURRENCY_CODE = X_CURRENCY_CODE
67: ;
68: begin
69: insert into FND_CURRENCIES (
70: DERIVE_EFFECTIVE,
71: DERIVE_TYPE,
72: GLOBAL_ATTRIBUTE7,
73: GLOBAL_ATTRIBUTE8,

Line 185: insert into FND_CURRENCIES_TL (

181: X_LAST_UPDATED_BY,
182: X_LAST_UPDATE_LOGIN
183: );
184:
185: insert into FND_CURRENCIES_TL (
186: CURRENCY_CODE,
187: NAME,
188: DESCRIPTION,
189: CREATED_BY,

Line 211: from FND_CURRENCIES_TL T

207: from FND_LANGUAGES L
208: where L.INSTALLED_FLAG in ('I', 'B')
209: and not exists
210: (select NULL
211: from FND_CURRENCIES_TL T
212: where T.CURRENCY_CODE = X_CURRENCY_CODE
213: and T.LANGUAGE = L.LANGUAGE_CODE);
214:
215: open c;

Line 330: from FND_CURRENCIES

326: GLOBAL_ATTRIBUTE3,
327: GLOBAL_ATTRIBUTE4,
328: GLOBAL_ATTRIBUTE5,
329: GLOBAL_ATTRIBUTE6
330: from FND_CURRENCIES
331: where CURRENCY_CODE = X_CURRENCY_CODE
332: for update of CURRENCY_CODE nowait;
333: recinfo c%rowtype;
334:

Line 338: from FND_CURRENCIES_TL

334:
335: cursor c1 is select
336: NAME,
337: DESCRIPTION
338: from FND_CURRENCIES_TL
339: where CURRENCY_CODE = X_CURRENCY_CODE
340: and LANGUAGE = userenv('LANG')
341: for update of CURRENCY_CODE nowait;
342: tlinfo c1%rowtype;

Line 537: update FND_CURRENCIES set

533: X_LAST_UPDATE_LOGIN in NUMBER
534: ) is
535: begin
536:
537: update FND_CURRENCIES set
538: DERIVE_EFFECTIVE = X_DERIVE_EFFECTIVE,
539: DERIVE_TYPE = X_DERIVE_TYPE,
540: GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
541: GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,

Line 597: update FND_CURRENCIES_TL set

593: if (sql%notfound) then
594: raise no_data_found;
595: end if;
596:
597: update FND_CURRENCIES_TL set
598: NAME = X_NAME,
599: DESCRIPTION = X_DESCRIPTION,
600: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
601: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 616: delete from FND_CURRENCIES

612: procedure DELETE_ROW (
613: X_CURRENCY_CODE in VARCHAR2
614: ) is
615: begin
616: delete from FND_CURRENCIES
617: where CURRENCY_CODE = X_CURRENCY_CODE;
618:
619: if (sql%notfound) then
620: raise no_data_found;

Line 623: delete from FND_CURRENCIES_TL

619: if (sql%notfound) then
620: raise no_data_found;
621: end if;
622:
623: delete from FND_CURRENCIES_TL
624: where CURRENCY_CODE = X_CURRENCY_CODE;
625:
626: if (sql%notfound) then
627: raise no_data_found;

Line 641: delete from FND_CURRENCIES_TL T

637: /* as a quick workaround to fix the time-consuming table handler issue */
638: /* Eventually we'll need to turn them into a separate fix_language procedure */
639: /*
640:
641: delete from FND_CURRENCIES_TL T
642: where not exists
643: (select NULL
644: from FND_CURRENCIES B
645: where B.CURRENCY_CODE = T.CURRENCY_CODE

Line 644: from FND_CURRENCIES B

640:
641: delete from FND_CURRENCIES_TL T
642: where not exists
643: (select NULL
644: from FND_CURRENCIES B
645: where B.CURRENCY_CODE = T.CURRENCY_CODE
646: );
647:
648: update FND_CURRENCIES_TL T set (

Line 648: update FND_CURRENCIES_TL T set (

644: from FND_CURRENCIES B
645: where B.CURRENCY_CODE = T.CURRENCY_CODE
646: );
647:
648: update FND_CURRENCIES_TL T set (
649: NAME,
650: DESCRIPTION
651: ) = (select
652: B.NAME,

Line 654: from FND_CURRENCIES_TL B

650: DESCRIPTION
651: ) = (select
652: B.NAME,
653: B.DESCRIPTION
654: from FND_CURRENCIES_TL B
655: where B.CURRENCY_CODE = T.CURRENCY_CODE
656: and B.LANGUAGE = T.SOURCE_LANG)
657: where (
658: T.CURRENCY_CODE,

Line 663: from FND_CURRENCIES_TL SUBB, FND_CURRENCIES_TL SUBT

659: T.LANGUAGE
660: ) in (select
661: SUBT.CURRENCY_CODE,
662: SUBT.LANGUAGE
663: from FND_CURRENCIES_TL SUBB, FND_CURRENCIES_TL SUBT
664: where SUBB.CURRENCY_CODE = SUBT.CURRENCY_CODE
665: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
666: and (SUBB.NAME <> SUBT.NAME
667: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 673: insert into FND_CURRENCIES_TL (

669: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
670: ));
671: */
672:
673: insert into FND_CURRENCIES_TL (
674: CURRENCY_CODE,
675: NAME,
676: DESCRIPTION,
677: CREATED_BY,

Line 695: from FND_CURRENCIES_TL B, FND_LANGUAGES L

691: B.LAST_UPDATE_DATE,
692: B.LAST_UPDATE_LOGIN,
693: L.LANGUAGE_CODE,
694: B.SOURCE_LANG
695: from FND_CURRENCIES_TL B, FND_LANGUAGES L
696: where L.INSTALLED_FLAG in ('I', 'B')
697: and B.LANGUAGE = userenv('LANG')
698: and not exists
699: (select NULL

Line 700: from FND_CURRENCIES_TL T

696: where L.INSTALLED_FLAG in ('I', 'B')
697: and B.LANGUAGE = userenv('LANG')
698: and not exists
699: (select NULL
700: from FND_CURRENCIES_TL T
701: where T.CURRENCY_CODE = B.CURRENCY_CODE
702: and T.LANGUAGE = L.LANGUAGE_CODE);
703: end ADD_LANGUAGE;
704:

Line 861: from FND_CURRENCIES_TL

857: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
858:
859: select last_updated_by, last_update_date
860: into db_luby, db_ludate
861: from FND_CURRENCIES_TL
862: where CURRENCY_CODE = X_CURRENCY_CODE
863: and language = userenv('LANG');
864:
865: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 867: update fnd_currencies_tl set

863: and language = userenv('LANG');
864:
865: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
866: db_ludate, X_CUSTOM_MODE)) then
867: update fnd_currencies_tl set
868: NAME= X_NAME,
869: DESCRIPTION= X_DESCRIPTION,
870: LAST_UPDATE_DATE = f_ludate,
871: LAST_UPDATED_BY = f_luby,

Line 1008: from FND_CURRENCIES

1004: begin
1005:
1006: select last_updated_by, last_update_date
1007: into db_luby, db_ludate
1008: from FND_CURRENCIES
1009: where CURRENCY_CODE = X_CURRENCY_CODE;
1010:
1011:
1012: -- Bug4493112 Moved decode select statement from update_row to load_row.

Line 1017: decode(x_issuing_territory_code, fnd_currencies_pkg.null_char, null,

1013: -- Bug4648984 Moved code inside of exception block so no data found is
1014: -- handled.
1015:
1016: select
1017: decode(x_issuing_territory_code, fnd_currencies_pkg.null_char, null,
1018: null, u.issuing_territory_code,
1019: x_issuing_territory_code),
1020: decode(x_precision, fnd_currencies_pkg.null_number, null,
1021: null, u.precision,

Line 1020: decode(x_precision, fnd_currencies_pkg.null_number, null,

1016: select
1017: decode(x_issuing_territory_code, fnd_currencies_pkg.null_char, null,
1018: null, u.issuing_territory_code,
1019: x_issuing_territory_code),
1020: decode(x_precision, fnd_currencies_pkg.null_number, null,
1021: null, u.precision,
1022: x_precision),
1023: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1024: null, u.extended_precision,

Line 1023: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,

1019: x_issuing_territory_code),
1020: decode(x_precision, fnd_currencies_pkg.null_number, null,
1021: null, u.precision,
1022: x_precision),
1023: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1024: null, u.extended_precision,
1025: x_extended_precision),
1026: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1027: null, u.symbol,

Line 1026: decode(x_symbol, fnd_currencies_pkg.null_char, null,

1022: x_precision),
1023: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1024: null, u.extended_precision,
1025: x_extended_precision),
1026: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1027: null, u.symbol,
1028: x_symbol),
1029: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1030: null, u.start_date_active,

Line 1029: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,

1025: x_extended_precision),
1026: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1027: null, u.symbol,
1028: x_symbol),
1029: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1030: null, u.start_date_active,
1031: x_start_date_active),
1032: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1033: null, u.end_date_active,

Line 1032: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,

1028: x_symbol),
1029: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1030: null, u.start_date_active,
1031: x_start_date_active),
1032: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1033: null, u.end_date_active,
1034: x_end_date_active),
1035: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1036: null,

Line 1035: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,

1031: x_start_date_active),
1032: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1033: null, u.end_date_active,
1034: x_end_date_active),
1035: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1036: null,
1037: null, u.minimum_accountable_unit,
1038: x_minimum_accountable_unit),
1039: decode(x_context, fnd_currencies_pkg.null_char, null,

Line 1039: decode(x_context, fnd_currencies_pkg.null_char, null,

1035: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1036: null,
1037: null, u.minimum_accountable_unit,
1038: x_minimum_accountable_unit),
1039: decode(x_context, fnd_currencies_pkg.null_char, null,
1040: null, u.context,
1041: x_context),
1042: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1043: null, u.attribute1,

Line 1042: decode(x_attribute1, fnd_currencies_pkg.null_char, null,

1038: x_minimum_accountable_unit),
1039: decode(x_context, fnd_currencies_pkg.null_char, null,
1040: null, u.context,
1041: x_context),
1042: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1043: null, u.attribute1,
1044: x_attribute1),
1045: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1046: null, u.attribute2,

Line 1045: decode(x_attribute2, fnd_currencies_pkg.null_char, null,

1041: x_context),
1042: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1043: null, u.attribute1,
1044: x_attribute1),
1045: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1046: null, u.attribute2,
1047: x_attribute2),
1048: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1049: null, u.attribute3,

Line 1048: decode(x_attribute3, fnd_currencies_pkg.null_char, null,

1044: x_attribute1),
1045: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1046: null, u.attribute2,
1047: x_attribute2),
1048: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1049: null, u.attribute3,
1050: x_attribute3),
1051: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1052: null, u.attribute4,

Line 1051: decode(x_attribute4, fnd_currencies_pkg.null_char, null,

1047: x_attribute2),
1048: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1049: null, u.attribute3,
1050: x_attribute3),
1051: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1052: null, u.attribute4,
1053: x_attribute4),
1054: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1055: null, u.attribute5,

Line 1054: decode(x_attribute5, fnd_currencies_pkg.null_char, null,

1050: x_attribute3),
1051: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1052: null, u.attribute4,
1053: x_attribute4),
1054: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1055: null, u.attribute5,
1056: x_attribute5),
1057: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1058: null, u.attribute6,

Line 1057: decode(x_attribute6, fnd_currencies_pkg.null_char, null,

1053: x_attribute4),
1054: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1055: null, u.attribute5,
1056: x_attribute5),
1057: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1058: null, u.attribute6,
1059: x_attribute6),
1060: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1061: null, u.attribute7,

Line 1060: decode(x_attribute7, fnd_currencies_pkg.null_char, null,

1056: x_attribute5),
1057: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1058: null, u.attribute6,
1059: x_attribute6),
1060: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1061: null, u.attribute7,
1062: x_attribute7),
1063: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1064: null, u.attribute8,

Line 1063: decode(x_attribute8, fnd_currencies_pkg.null_char, null,

1059: x_attribute6),
1060: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1061: null, u.attribute7,
1062: x_attribute7),
1063: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1064: null, u.attribute8,
1065: x_attribute8),
1066: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1067: null, u.attribute9,

Line 1066: decode(x_attribute9, fnd_currencies_pkg.null_char, null,

1062: x_attribute7),
1063: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1064: null, u.attribute8,
1065: x_attribute8),
1066: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1067: null, u.attribute9,
1068: x_attribute9),
1069: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1070: null, u.attribute10,

Line 1069: decode(x_attribute10, fnd_currencies_pkg.null_char, null,

1065: x_attribute8),
1066: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1067: null, u.attribute9,
1068: x_attribute9),
1069: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1070: null, u.attribute10,
1071: x_attribute10),
1072: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1073: null, u.attribute11,

Line 1072: decode(x_attribute11, fnd_currencies_pkg.null_char, null,

1068: x_attribute9),
1069: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1070: null, u.attribute10,
1071: x_attribute10),
1072: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1073: null, u.attribute11,
1074: x_attribute11),
1075: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1076: null, u.attribute12,

Line 1075: decode(x_attribute12, fnd_currencies_pkg.null_char, null,

1071: x_attribute10),
1072: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1073: null, u.attribute11,
1074: x_attribute11),
1075: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1076: null, u.attribute12,
1077: x_attribute12),
1078: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1079: null, u.attribute13,

Line 1078: decode(x_attribute13, fnd_currencies_pkg.null_char, null,

1074: x_attribute11),
1075: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1076: null, u.attribute12,
1077: x_attribute12),
1078: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1079: null, u.attribute13,
1080: x_attribute13),
1081: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1082: null, u.attribute14,

Line 1081: decode(x_attribute14, fnd_currencies_pkg.null_char, null,

1077: x_attribute12),
1078: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1079: null, u.attribute13,
1080: x_attribute13),
1081: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1082: null, u.attribute14,
1083: x_attribute14),
1084: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1085: null, u.attribute15,

Line 1084: decode(x_attribute15, fnd_currencies_pkg.null_char, null,

1080: x_attribute13),
1081: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1082: null, u.attribute14,
1083: x_attribute14),
1084: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1085: null, u.attribute15,
1086: x_attribute15),
1087: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1088: null,

Line 1087: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,

1083: x_attribute14),
1084: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1085: null, u.attribute15,
1086: x_attribute15),
1087: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1088: null,
1089: null, u.global_attribute_category,
1090: x_global_attribute_category),
1091: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,

Line 1091: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,

1087: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1088: null,
1089: null, u.global_attribute_category,
1090: x_global_attribute_category),
1091: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,
1092: null, u.global_attribute1,
1093: x_global_attribute1),
1094: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1095: null, u.global_attribute2,

Line 1094: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,

1090: x_global_attribute_category),
1091: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,
1092: null, u.global_attribute1,
1093: x_global_attribute1),
1094: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1095: null, u.global_attribute2,
1096: x_global_attribute2),
1097: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1098: null, u.global_attribute3,

Line 1097: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,

1093: x_global_attribute1),
1094: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1095: null, u.global_attribute2,
1096: x_global_attribute2),
1097: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1098: null, u.global_attribute3,
1099: x_global_attribute3),
1100: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1101: null, u.global_attribute4,

Line 1100: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,

1096: x_global_attribute2),
1097: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1098: null, u.global_attribute3,
1099: x_global_attribute3),
1100: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1101: null, u.global_attribute4,
1102: x_global_attribute4),
1103: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1104: null, u.global_attribute5,

Line 1103: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,

1099: x_global_attribute3),
1100: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1101: null, u.global_attribute4,
1102: x_global_attribute4),
1103: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1104: null, u.global_attribute5,
1105: x_global_attribute5),
1106: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1107: null, u.global_attribute6,

Line 1106: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,

1102: x_global_attribute4),
1103: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1104: null, u.global_attribute5,
1105: x_global_attribute5),
1106: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1107: null, u.global_attribute6,
1108: x_global_attribute6),
1109: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1110: null, u.global_attribute7,

Line 1109: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,

1105: x_global_attribute5),
1106: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1107: null, u.global_attribute6,
1108: x_global_attribute6),
1109: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1110: null, u.global_attribute7,
1111: x_global_attribute7),
1112: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1113: null, u.global_attribute8,

Line 1112: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,

1108: x_global_attribute6),
1109: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1110: null, u.global_attribute7,
1111: x_global_attribute7),
1112: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1113: null, u.global_attribute8,
1114: x_global_attribute8),
1115: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1116: null, u.global_attribute9,

Line 1115: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,

1111: x_global_attribute7),
1112: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1113: null, u.global_attribute8,
1114: x_global_attribute8),
1115: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1116: null, u.global_attribute9,
1117: x_global_attribute9),
1118: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1119: null, u.global_attribute10,

Line 1118: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,

1114: x_global_attribute8),
1115: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1116: null, u.global_attribute9,
1117: x_global_attribute9),
1118: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1119: null, u.global_attribute10,
1120: x_global_attribute10),
1121: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1122: null, u.global_attribute11,

Line 1121: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,

1117: x_global_attribute9),
1118: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1119: null, u.global_attribute10,
1120: x_global_attribute10),
1121: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1122: null, u.global_attribute11,
1123: x_global_attribute11),
1124: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1125: null, u.global_attribute12,

Line 1124: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,

1120: x_global_attribute10),
1121: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1122: null, u.global_attribute11,
1123: x_global_attribute11),
1124: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1125: null, u.global_attribute12,
1126: x_global_attribute12),
1127: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1128: null, u.global_attribute13,

Line 1127: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,

1123: x_global_attribute11),
1124: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1125: null, u.global_attribute12,
1126: x_global_attribute12),
1127: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1128: null, u.global_attribute13,
1129: x_global_attribute13),
1130: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1131: null, u.global_attribute14,

Line 1130: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,

1126: x_global_attribute12),
1127: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1128: null, u.global_attribute13,
1129: x_global_attribute13),
1130: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1131: null, u.global_attribute14,
1132: x_global_attribute14),
1133: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1134: null, u.global_attribute15,

Line 1133: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,

1129: x_global_attribute13),
1130: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1131: null, u.global_attribute14,
1132: x_global_attribute14),
1133: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1134: null, u.global_attribute15,
1135: x_global_attribute15),
1136: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1137: null, u.global_attribute16,

Line 1136: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,

1132: x_global_attribute14),
1133: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1134: null, u.global_attribute15,
1135: x_global_attribute15),
1136: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1137: null, u.global_attribute16,
1138: x_global_attribute16),
1139: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1140: null, u.global_attribute17,

Line 1139: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,

1135: x_global_attribute15),
1136: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1137: null, u.global_attribute16,
1138: x_global_attribute16),
1139: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1140: null, u.global_attribute17,
1141: x_global_attribute17),
1142: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1143: null, u.global_attribute18,

Line 1142: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,

1138: x_global_attribute16),
1139: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1140: null, u.global_attribute17,
1141: x_global_attribute17),
1142: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1143: null, u.global_attribute18,
1144: x_global_attribute18),
1145: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1146: null, u.global_attribute19,

Line 1145: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,

1141: x_global_attribute17),
1142: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1143: null, u.global_attribute18,
1144: x_global_attribute18),
1145: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1146: null, u.global_attribute19,
1147: x_global_attribute19),
1148: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1149: null, u.global_attribute20,

Line 1148: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,

1144: x_global_attribute18),
1145: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1146: null, u.global_attribute19,
1147: x_global_attribute19),
1148: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1149: null, u.global_attribute20,
1150: x_global_attribute20),
1151: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1152: null, u.DERIVE_EFFECTIVE,

Line 1151: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,

1147: x_global_attribute19),
1148: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1149: null, u.global_attribute20,
1150: x_global_attribute20),
1151: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1152: null, u.DERIVE_EFFECTIVE,
1153: X_DERIVE_EFFECTIVE),
1154: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1155: null, u.derive_type,

Line 1154: decode(x_derive_type, fnd_currencies_pkg.null_char, null,

1150: x_global_attribute20),
1151: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1152: null, u.DERIVE_EFFECTIVE,
1153: X_DERIVE_EFFECTIVE),
1154: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1155: null, u.derive_type,
1156: x_derive_type),
1157: decode(x_derive_factor, fnd_currencies_pkg.null_number, null,
1158: null, u.derive_factor,

Line 1157: decode(x_derive_factor, fnd_currencies_pkg.null_number, null,

1153: X_DERIVE_EFFECTIVE),
1154: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1155: null, u.derive_type,
1156: x_derive_type),
1157: decode(x_derive_factor, fnd_currencies_pkg.null_number, null,
1158: null, u.derive_factor,
1159: x_derive_factor)
1160: into L_ISSUING_TERRITORY_CODE, L_PRECISION, L_EXTENDED_PRECISION,
1161: L_SYMBOL, L_START_DATE_ACTIVE, L_END_DATE_ACTIVE,

Line 1176: from FND_CURRENCIES U

1172: L_GLOBAL_ATTRIBUTE13,L_GLOBAL_ATTRIBUTE14, L_GLOBAL_ATTRIBUTE15,
1173: L_GLOBAL_ATTRIBUTE16,L_GLOBAL_ATTRIBUTE17, L_GLOBAL_ATTRIBUTE18,
1174: L_GLOBAL_ATTRIBUTE19,L_GLOBAL_ATTRIBUTE20,
1175: L_DERIVE_EFFECTIVE, L_DERIVE_TYPE, L_DERIVE_FACTOR
1176: from FND_CURRENCIES U
1177: where CURRENCY_CODE = X_CURRENCY_CODE;
1178:
1179: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1180: db_ludate, X_CUSTOM_MODE)) then

Line 1185: FND_CURRENCIES_PKG.UPDATE_ROW(

1181:
1182: -- Bug4493112 Modified calls to UPDATE_ROW AND INSERT_ROW to use local
1183: -- variables.
1184:
1185: FND_CURRENCIES_PKG.UPDATE_ROW(
1186: X_CURRENCY_CODE,
1187: L_DERIVE_EFFECTIVE,
1188: L_DERIVE_TYPE,
1189: L_GLOBAL_ATTRIBUTE7,

Line 1247: FND_CURRENCIES_PKG.INSERT_ROW(

1243:
1244: EXCEPTION
1245: WHEN no_data_found then
1246:
1247: FND_CURRENCIES_PKG.INSERT_ROW(
1248: X_ROWID,
1249: X_CURRENCY_CODE,
1250: X_DERIVE_EFFECTIVE, --bug6317914 removed to_date
1251: X_DERIVE_TYPE,

Line 1310: end FND_CURRENCIES_PKG;

1306: 0);
1307: end;
1308: end LOAD_ROW;
1309:
1310: end FND_CURRENCIES_PKG;