1: package body FND_CURRENCIES_PKG as
2: /* $Header: AFNLDCXB.pls 120.6.12010000.2 2009/07/24 16:03:02 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
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 (
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,
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,
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;
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:
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;
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,
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,
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;
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;
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
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 (
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,
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,
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
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,
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
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:
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,
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,
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.
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
1246:
1247: -- bug7292241 - Need to correctly translate the provided NULL value
1248: -- for inserting a new record.
1249:
1250: select decode(x_issuing_territory_code, fnd_currencies_pkg.null_char, null,
1251: null, null, x_issuing_territory_code),
1252: decode(x_precision, fnd_currencies_pkg.null_number, null,
1253: null, null,x_precision),
1254: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1248: -- for inserting a new record.
1249:
1250: select decode(x_issuing_territory_code, fnd_currencies_pkg.null_char, null,
1251: null, null, x_issuing_territory_code),
1252: decode(x_precision, fnd_currencies_pkg.null_number, null,
1253: null, null,x_precision),
1254: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1255: null, null, x_extended_precision),
1256: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1250: select decode(x_issuing_territory_code, fnd_currencies_pkg.null_char, null,
1251: null, null, x_issuing_territory_code),
1252: decode(x_precision, fnd_currencies_pkg.null_number, null,
1253: null, null,x_precision),
1254: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1255: null, null, x_extended_precision),
1256: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1257: null, null, x_symbol),
1258: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1252: decode(x_precision, fnd_currencies_pkg.null_number, null,
1253: null, null,x_precision),
1254: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1255: null, null, x_extended_precision),
1256: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1257: null, null, x_symbol),
1258: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1259: null, null, x_start_date_active),
1260: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1254: decode(x_extended_precision, fnd_currencies_pkg.null_number, null,
1255: null, null, x_extended_precision),
1256: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1257: null, null, x_symbol),
1258: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1259: null, null, x_start_date_active),
1260: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1261: null, null, x_end_date_active),
1262: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1256: decode(x_symbol, fnd_currencies_pkg.null_char, null,
1257: null, null, x_symbol),
1258: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1259: null, null, x_start_date_active),
1260: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1261: null, null, x_end_date_active),
1262: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1263: null, null,x_minimum_accountable_unit),
1264: decode(x_context, fnd_currencies_pkg.null_char, null,
1258: decode(x_start_date_active, fnd_currencies_pkg.null_date, null,
1259: null, null, x_start_date_active),
1260: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1261: null, null, x_end_date_active),
1262: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1263: null, null,x_minimum_accountable_unit),
1264: decode(x_context, fnd_currencies_pkg.null_char, null,
1265: null, null, x_context),
1266: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1260: decode(x_end_date_active, fnd_currencies_pkg.null_date, null,
1261: null, null, x_end_date_active),
1262: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1263: null, null,x_minimum_accountable_unit),
1264: decode(x_context, fnd_currencies_pkg.null_char, null,
1265: null, null, x_context),
1266: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1267: null, null, x_attribute1),
1268: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1262: decode(x_minimum_accountable_unit, fnd_currencies_pkg.null_number,
1263: null, null,x_minimum_accountable_unit),
1264: decode(x_context, fnd_currencies_pkg.null_char, null,
1265: null, null, x_context),
1266: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1267: null, null, x_attribute1),
1268: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1269: null, null, x_attribute2),
1270: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1264: decode(x_context, fnd_currencies_pkg.null_char, null,
1265: null, null, x_context),
1266: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1267: null, null, x_attribute1),
1268: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1269: null, null, x_attribute2),
1270: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1271: null, null, x_attribute3),
1272: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1266: decode(x_attribute1, fnd_currencies_pkg.null_char, null,
1267: null, null, x_attribute1),
1268: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1269: null, null, x_attribute2),
1270: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1271: null, null, x_attribute3),
1272: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1273: null, null, x_attribute4),
1274: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1268: decode(x_attribute2, fnd_currencies_pkg.null_char, null,
1269: null, null, x_attribute2),
1270: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1271: null, null, x_attribute3),
1272: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1273: null, null, x_attribute4),
1274: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1275: null, null, x_attribute5),
1276: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1270: decode(x_attribute3, fnd_currencies_pkg.null_char, null,
1271: null, null, x_attribute3),
1272: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1273: null, null, x_attribute4),
1274: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1275: null, null, x_attribute5),
1276: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1277: null, null, x_attribute6),
1278: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1272: decode(x_attribute4, fnd_currencies_pkg.null_char, null,
1273: null, null, x_attribute4),
1274: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1275: null, null, x_attribute5),
1276: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1277: null, null, x_attribute6),
1278: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1279: null, null, x_attribute7),
1280: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1274: decode(x_attribute5, fnd_currencies_pkg.null_char, null,
1275: null, null, x_attribute5),
1276: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1277: null, null, x_attribute6),
1278: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1279: null, null, x_attribute7),
1280: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1281: null, null, x_attribute8),
1282: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1276: decode(x_attribute6, fnd_currencies_pkg.null_char, null,
1277: null, null, x_attribute6),
1278: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1279: null, null, x_attribute7),
1280: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1281: null, null, x_attribute8),
1282: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1283: null, null, x_attribute9),
1284: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1278: decode(x_attribute7, fnd_currencies_pkg.null_char, null,
1279: null, null, x_attribute7),
1280: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1281: null, null, x_attribute8),
1282: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1283: null, null, x_attribute9),
1284: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1285: null, null, x_attribute10),
1286: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1280: decode(x_attribute8, fnd_currencies_pkg.null_char, null,
1281: null, null, x_attribute8),
1282: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1283: null, null, x_attribute9),
1284: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1285: null, null, x_attribute10),
1286: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1287: null, null, x_attribute11),
1288: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1282: decode(x_attribute9, fnd_currencies_pkg.null_char, null,
1283: null, null, x_attribute9),
1284: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1285: null, null, x_attribute10),
1286: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1287: null, null, x_attribute11),
1288: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1289: null, null, x_attribute12),
1290: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1284: decode(x_attribute10, fnd_currencies_pkg.null_char, null,
1285: null, null, x_attribute10),
1286: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1287: null, null, x_attribute11),
1288: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1289: null, null, x_attribute12),
1290: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1291: null, null, x_attribute13),
1292: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1286: decode(x_attribute11, fnd_currencies_pkg.null_char, null,
1287: null, null, x_attribute11),
1288: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1289: null, null, x_attribute12),
1290: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1291: null, null, x_attribute13),
1292: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1293: null, null, x_attribute14),
1294: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1288: decode(x_attribute12, fnd_currencies_pkg.null_char, null,
1289: null, null, x_attribute12),
1290: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1291: null, null, x_attribute13),
1292: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1293: null, null, x_attribute14),
1294: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1295: null, null, x_attribute15),
1296: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1290: decode(x_attribute13, fnd_currencies_pkg.null_char, null,
1291: null, null, x_attribute13),
1292: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1293: null, null, x_attribute14),
1294: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1295: null, null, x_attribute15),
1296: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1297: null,
1298: null, x_global_attribute_category),
1292: decode(x_attribute14, fnd_currencies_pkg.null_char, null,
1293: null, null, x_attribute14),
1294: decode(x_attribute15, fnd_currencies_pkg.null_char, null,
1295: null, null, x_attribute15),
1296: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1297: null,
1298: null, x_global_attribute_category),
1299: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,
1300: null, null, x_global_attribute1),
1295: null, null, x_attribute15),
1296: decode(x_global_attribute_category, fnd_currencies_pkg.null_char,
1297: null,
1298: null, x_global_attribute_category),
1299: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,
1300: null, null, x_global_attribute1),
1301: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1302: null, null, x_global_attribute2),
1303: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1297: null,
1298: null, x_global_attribute_category),
1299: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,
1300: null, null, x_global_attribute1),
1301: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1302: null, null, x_global_attribute2),
1303: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1304: null, null, x_global_attribute3),
1305: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1299: decode(x_global_attribute1, fnd_currencies_pkg.null_char, null,
1300: null, null, x_global_attribute1),
1301: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1302: null, null, x_global_attribute2),
1303: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1304: null, null, x_global_attribute3),
1305: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1306: null, null, x_global_attribute4),
1307: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1301: decode(x_global_attribute2, fnd_currencies_pkg.null_char, null,
1302: null, null, x_global_attribute2),
1303: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1304: null, null, x_global_attribute3),
1305: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1306: null, null, x_global_attribute4),
1307: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1308: null, null, x_global_attribute5),
1309: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1303: decode(x_global_attribute3, fnd_currencies_pkg.null_char, null,
1304: null, null, x_global_attribute3),
1305: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1306: null, null, x_global_attribute4),
1307: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1308: null, null, x_global_attribute5),
1309: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1310: null, null, x_global_attribute6),
1311: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1305: decode(x_global_attribute4, fnd_currencies_pkg.null_char, null,
1306: null, null, x_global_attribute4),
1307: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1308: null, null, x_global_attribute5),
1309: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1310: null, null, x_global_attribute6),
1311: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1312: null, null, x_global_attribute7),
1313: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1307: decode(x_global_attribute5, fnd_currencies_pkg.null_char, null,
1308: null, null, x_global_attribute5),
1309: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1310: null, null, x_global_attribute6),
1311: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1312: null, null, x_global_attribute7),
1313: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1314: null, null, x_global_attribute8),
1315: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1309: decode(x_global_attribute6, fnd_currencies_pkg.null_char, null,
1310: null, null, x_global_attribute6),
1311: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1312: null, null, x_global_attribute7),
1313: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1314: null, null, x_global_attribute8),
1315: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1316: null, null, x_global_attribute9),
1317: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1311: decode(x_global_attribute7, fnd_currencies_pkg.null_char, null,
1312: null, null, x_global_attribute7),
1313: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1314: null, null, x_global_attribute8),
1315: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1316: null, null, x_global_attribute9),
1317: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1318: null, null, x_global_attribute10),
1319: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1313: decode(x_global_attribute8, fnd_currencies_pkg.null_char, null,
1314: null, null, x_global_attribute8),
1315: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1316: null, null, x_global_attribute9),
1317: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1318: null, null, x_global_attribute10),
1319: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1320: null, null, x_global_attribute11),
1321: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1315: decode(x_global_attribute9, fnd_currencies_pkg.null_char, null,
1316: null, null, x_global_attribute9),
1317: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1318: null, null, x_global_attribute10),
1319: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1320: null, null, x_global_attribute11),
1321: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1322: null, null, x_global_attribute12),
1323: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1317: decode(x_global_attribute10, fnd_currencies_pkg.null_char, null,
1318: null, null, x_global_attribute10),
1319: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1320: null, null, x_global_attribute11),
1321: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1322: null, null, x_global_attribute12),
1323: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1324: null, null, x_global_attribute13),
1325: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1319: decode(x_global_attribute11, fnd_currencies_pkg.null_char, null,
1320: null, null, x_global_attribute11),
1321: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1322: null, null, x_global_attribute12),
1323: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1324: null, null, x_global_attribute13),
1325: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1326: null, null, x_global_attribute14),
1327: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1321: decode(x_global_attribute12, fnd_currencies_pkg.null_char, null,
1322: null, null, x_global_attribute12),
1323: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1324: null, null, x_global_attribute13),
1325: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1326: null, null, x_global_attribute14),
1327: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1328: null, null, x_global_attribute15),
1329: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1323: decode(x_global_attribute13, fnd_currencies_pkg.null_char, null,
1324: null, null, x_global_attribute13),
1325: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1326: null, null, x_global_attribute14),
1327: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1328: null, null, x_global_attribute15),
1329: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1330: null, null, x_global_attribute16),
1331: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1325: decode(x_global_attribute14, fnd_currencies_pkg.null_char, null,
1326: null, null, x_global_attribute14),
1327: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1328: null, null, x_global_attribute15),
1329: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1330: null, null, x_global_attribute16),
1331: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1332: null, null, x_global_attribute17),
1333: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1327: decode(x_global_attribute15, fnd_currencies_pkg.null_char, null,
1328: null, null, x_global_attribute15),
1329: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1330: null, null, x_global_attribute16),
1331: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1332: null, null, x_global_attribute17),
1333: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1334: null, null, x_global_attribute18),
1335: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1329: decode(x_global_attribute16, fnd_currencies_pkg.null_char, null,
1330: null, null, x_global_attribute16),
1331: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1332: null, null, x_global_attribute17),
1333: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1334: null, null, x_global_attribute18),
1335: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1336: null, null, x_global_attribute19),
1337: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1331: decode(x_global_attribute17, fnd_currencies_pkg.null_char, null,
1332: null, null, x_global_attribute17),
1333: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1334: null, null, x_global_attribute18),
1335: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1336: null, null, x_global_attribute19),
1337: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1338: null, null, x_global_attribute20),
1339: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1333: decode(x_global_attribute18, fnd_currencies_pkg.null_char, null,
1334: null, null, x_global_attribute18),
1335: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1336: null, null, x_global_attribute19),
1337: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1338: null, null, x_global_attribute20),
1339: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1340: null, null, x_DERIVE_EFFECTIVE),
1341: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1335: decode(x_global_attribute19, fnd_currencies_pkg.null_char, null,
1336: null, null, x_global_attribute19),
1337: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1338: null, null, x_global_attribute20),
1339: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1340: null, null, x_DERIVE_EFFECTIVE),
1341: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1342: null, null, x_derive_type),
1343: decode(x_derive_factor, fnd_currencies_pkg.null_number, null,
1337: decode(x_global_attribute20, fnd_currencies_pkg.null_char, null,
1338: null, null, x_global_attribute20),
1339: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1340: null, null, x_DERIVE_EFFECTIVE),
1341: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1342: null, null, x_derive_type),
1343: decode(x_derive_factor, fnd_currencies_pkg.null_number, null,
1344: null, null, x_derive_factor)
1345: into L_ISSUING_TERRITORY_CODE, L_PRECISION, L_EXTENDED_PRECISION,
1339: decode(X_DERIVE_EFFECTIVE, fnd_currencies_pkg.null_date, null,
1340: null, null, x_DERIVE_EFFECTIVE),
1341: decode(x_derive_type, fnd_currencies_pkg.null_char, null,
1342: null, null, x_derive_type),
1343: decode(x_derive_factor, fnd_currencies_pkg.null_number, null,
1344: null, null, x_derive_factor)
1345: into L_ISSUING_TERRITORY_CODE, L_PRECISION, L_EXTENDED_PRECISION,
1346: L_SYMBOL, L_START_DATE_ACTIVE, L_END_DATE_ACTIVE,
1347: L_MINIMUM_ACCOUNTABLE_UNIT, L_CONTEXT,
1359: L_GLOBAL_ATTRIBUTE19,L_GLOBAL_ATTRIBUTE20,
1360: L_DERIVE_EFFECTIVE, L_DERIVE_TYPE, L_DERIVE_FACTOR
1361: from DUAL;
1362:
1363: FND_CURRENCIES_PKG.INSERT_ROW(
1364: X_ROWID,
1365: X_CURRENCY_CODE,
1366: L_DERIVE_EFFECTIVE, --bug6317914 removed to_date
1367: L_DERIVE_TYPE,
1422: 0);
1423: end;
1424: end LOAD_ROW;
1425:
1426: end FND_CURRENCIES_PKG;