-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathtm_db_install.sql
1201 lines (1100 loc) · 107 KB
/
tm_db_install.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
spool tm_db_install.log
SET DEFINE OFF;
declare
type arr_install_objects is table of varchar2(30) index by pls_integer;
l_inst_seq arr_install_objects;
l_inst_tab arr_install_objects;
l_inst_con arr_install_objects;
l_cnt number;
begin
l_inst_seq(1) := 'TM_BACKUP_MESSAGES_SEQ';
l_inst_seq(2) := 'TM_BACKUP_SEQ';
l_inst_seq(3) := 'TM_DOC_MESSAGES_SEQ';
l_inst_seq(4) := 'TM_PREP_MESSAGES_SEQ';
l_inst_seq(5) := 'TM_LANGUAGES_SEQ';
l_inst_tab(1) := 'TM_PREP_MESSAGES';
l_inst_tab(2) := 'TM_DOC_MESSAGES';
l_inst_tab(3) := 'TM_BACKUP_MESSAGES';
l_inst_tab(4) := 'TM_BACKUP';
l_inst_tab(5) := 'TM_LANGUAGES';
l_inst_con(1) := 'CON_BACKUP_FK_CODE';
l_inst_con(2) := 'CON_BACKUPMESS_FK_CODE';
l_inst_con(3) := 'CON_PREPM_FK_CODE';
for i in l_inst_seq.first..l_inst_seq.last loop
select count(*)
into l_cnt
from user_objects
where object_name = l_inst_seq(i);
if l_cnt = 0 then
execute immediate 'CREATE SEQUENCE ' || l_inst_seq(i);
end if;
end loop;
for i in l_inst_tab.first..l_inst_tab.last loop
select count(*)
into l_cnt
from user_objects
where object_name = l_inst_tab(i);
if l_cnt = 0 and l_inst_tab(i) = 'TM_LANGUAGES' then
execute immediate 'CREATE TABLE TM_LANGUAGES(
ID NUMBER NOT NULL ENABLE,
CODE VARCHAR2(10) NOT NULL ENABLE,
LANGUAGE VARCHAR2(200) NOT NULL ENABLE,
TEXT_DIRECTION VARCHAR2(10),
CREATED_BY VARCHAR2(255),
CREATED_ON DATE,
UPDATED_BY VARCHAR2(255),
UPDATED_ON DATE,
CONSTRAINT TM_LANGUAGE_PK PRIMARY KEY (ID),
CONSTRAINT TM_LANGUAGE_UQ UNIQUE (CODE)
)';
end if;
if l_cnt = 0 and l_inst_tab(i) = 'TM_BACKUP' then
execute immediate 'CREATE TABLE TM_BACKUP(
ID NUMBER NOT NULL ENABLE,
APP_ID VARCHAR2(255) NOT NULL ENABLE,
LANGUAGE_CODE VARCHAR2(50) NOT NULL ENABLE,
BACKUP_TIME DATE,
CREATED_BY VARCHAR2(255),
CREATED_ON DATE,
UPDATED_BY VARCHAR2(255),
UPDATED_ON DATE,
OPERATION VARCHAR2(100),
CONSTRAINT TM_BACKUP_PK PRIMARY KEY (ID)
)';
end if;
if l_cnt = 0 and l_inst_tab(i) = 'TM_BACKUP_MESSAGES' then
execute immediate 'CREATE TABLE TM_BACKUP_MESSAGES(
ID NUMBER NOT NULL ENABLE,
FK_TM_BACKUP NUMBER NOT NULL ENABLE,
TRANSLATABLE_MESSAGE VARCHAR2(255) NOT NULL ENABLE,
MESSAGE_TEXT VARCHAR2(4000) NOT NULL ENABLE,
LANGUAGE_CODE VARCHAR2(50) NOT NULL ENABLE,
CREATED_BY VARCHAR2(255),
CREATED_ON DATE,
UPDATED_BY VARCHAR2(255),
UPDATED_ON DATE,
CONSTRAINT TM_BACKUP_MESSAGE_PK PRIMARY KEY (ID)
)';
execute immediate 'CREATE INDEX IDX_TM_BACKUP_MESSAGES_1 ON TM_BACKUP_MESSAGES (LANGUAGE_CODE)';
end if;
if l_cnt = 0 and l_inst_tab(i) = 'TM_DOC_MESSAGES' then
execute immediate 'CREATE TABLE TM_DOC_MESSAGES(
ID NUMBER NOT NULL ENABLE,
TRANSLATABLE_MESSAGE VARCHAR2(255) NOT NULL ENABLE,
MESSAGE_TEXT VARCHAR2(4000) NOT NULL ENABLE,
INTERNAL_IR VARCHAR2(30) NOT NULL ENABLE,
CREATED_BY VARCHAR2(255),
CREATED_ON DATE,
UPDATED_BY VARCHAR2(255),
UPDATED_ON DATE,
CONSTRAINT TM_DOC_MESSAGES_PK PRIMARY KEY (ID),
CONSTRAINT TM_DOC_MESSAGES_UK1 UNIQUE (TRANSLATABLE_MESSAGE)
)';
end if;
if l_cnt = 0 and l_inst_tab(i) = 'TM_PREP_MESSAGES' then
execute immediate 'CREATE TABLE TM_PREP_MESSAGES(
ID NUMBER NOT NULL ENABLE,
TRANSLATABLE_MESSAGE VARCHAR2(255) NOT NULL ENABLE,
MESSAGE_TEXT VARCHAR2(4000) NOT NULL ENABLE,
LANGUAGE_CODE VARCHAR2(50) NOT NULL ENABLE,
ORIGINAL_TEXT VARCHAR2(4000),
CREATED_BY VARCHAR2(255),
CREATED_ON DATE,
UPDATED_BY VARCHAR2(255),
UPDATED_ON DATE,
CONSTRAINT TM_PREP_MESSAGE_PK PRIMARY KEY (ID),
CONSTRAINT TM_PREP_MESSAGES_UK1 UNIQUE (TRANSLATABLE_MESSAGE, LANGUAGE_CODE)
)';
execute immediate 'CREATE INDEX IDX_PREP_MESSAGES_1 ON TM_PREP_MESSAGES (LANGUAGE_CODE)';
end if;
end loop;
for i in l_inst_con.first..l_inst_con.last loop
select count(*)
into l_cnt
from user_constraints
where constraint_name = l_inst_con(i);
if l_cnt = 0 and l_inst_con(i) = 'CON_BACKUP_FK_CODE' then
execute immediate 'ALTER TABLE TM_BACKUP ADD CONSTRAINT CON_BACKUP_FK_CODE FOREIGN KEY (LANGUAGE_CODE)
REFERENCES TM_LANGUAGES (CODE) ENABLE';
end if;
if l_cnt = 0 and l_inst_con(i) = 'CON_BACKUPMESS_FK_CODE' then
execute immediate 'ALTER TABLE TM_BACKUP_MESSAGES ADD CONSTRAINT CON_BACKUPMESS_FK_CODE FOREIGN KEY (LANGUAGE_CODE)
REFERENCES TM_LANGUAGES (CODE) ENABLE';
end if;
if l_cnt = 0 and l_inst_con(i) = 'CON_PREPM_FK_CODE' then
execute immediate 'ALTER TABLE TM_PREP_MESSAGES ADD CONSTRAINT CON_PREPM_FK_CODE FOREIGN KEY (LANGUAGE_CODE)
REFERENCES TM_LANGUAGES (CODE) ENABLE';
end if;
end loop;
end;
/
CREATE OR REPLACE TRIGGER TRG_BIU_TM_LANGUAGES
before insert or update on TM_LANGUAGES
for each row
begin
if :NEW.ID is null then
select TM_LANGUAGES_SEQ.nextval into :NEW.ID from sys.dual;
end if;
:new.code := lower(:new.code);
if inserting then
:new.CREATED_ON := sysdate;
:new.CREATED_BY := nvl(v('APP_USER'), user);
end if;
if updating then
:new.UPDATED_ON := sysdate;
:new.UPDATED_BY := nvl(v('APP_USER'), user);
end if;
end;
/
CREATE OR REPLACE TRIGGER TRG_BIU_TM_BACKUP
before insert or update on TM_BACKUP
for each row
begin
if :NEW.ID is null then
select TM_BACKUP_SEQ.nextval into :NEW.ID from sys.dual;
end if;
if inserting then
:new.CREATED_ON := sysdate;
:new.CREATED_BY := nvl(v('APP_USER'), user);
end if;
if updating then
:new.UPDATED_ON := sysdate;
:new.UPDATED_BY := nvl(v('APP_USER'), user);
end if;
end;
/
CREATE OR REPLACE TRIGGER TRG_BIU_TM_BACKUP_MESSAGES
before insert or update on TM_BACKUP_MESSAGES
for each row
begin
if :NEW.ID is null then
select TM_BACKUP_MESSAGES_SEQ.nextval into :NEW.ID from sys.dual;
end if;
if inserting then
:new.CREATED_ON := sysdate;
:new.CREATED_BY := nvl(v('APP_USER'), user);
end if;
if updating then
:new.UPDATED_ON := sysdate;
:new.UPDATED_BY := nvl(v('APP_USER'), user);
end if;
end;
/
CREATE OR REPLACE TRIGGER TRG_BIU_TM_DOC_MESSAGES
before insert or update on TM_DOC_MESSAGES
for each row
begin
if :NEW.ID is null then
select TM_DOC_MESSAGES_SEQ.nextval into :NEW.ID from sys.dual;
end if;
if inserting then
:new.CREATED_ON := sysdate;
:new.CREATED_BY := nvl(v('APP_USER'), user);
end if;
if updating then
:new.UPDATED_ON := sysdate;
:new.UPDATED_BY := nvl(v('APP_USER'), user);
end if;
end;
/
create or replace TRIGGER TRG_BIU_TM_PREP_MESSAGE
before insert or update on TM_PREP_MESSAGES
for each row
begin
:new.translatable_message := upper(:new.translatable_message);
:new.language_code := lower(:new.language_code);
if :NEW.ID is null then
select TM_PREP_MESSAGES_SEQ.nextval into :NEW.ID from sys.dual;
end if;
if inserting then
:new.CREATED_ON := sysdate;
:new.CREATED_BY := nvl(v('APP_USER'), user);
if :new.language_code is null and v('APP_PAGE_ID') = 22 then
:new.language_code := lower(v('P20_CODE'));
end if;
end if;
if updating then
:new.UPDATED_ON := sysdate;
:new.UPDATED_BY := nvl(v('APP_USER'), user);
end if;
end;
/
CREATE OR REPLACE PROCEDURE TM_P_PARSE_CSV
IS
--
p_clob clob;
p_blob blob;
p_blob_new blob;
p_delim varchar2(10) default ';';
p_optionally_enclosed varchar2(10) default '"';
p_amount number;
p_offset number;
p_message_code varchar2(4000);
p_translated_text varchar2(4000);
--
l_cr constant char(1) := chr(13);
l_lf constant char(1) := chr(10);
--
l_char nchar(1);
l_lookahead nchar(1);
l_pos number := 0;
l_token varchar2(32767) := null;
l_token_complete boolean := false;
l_line_complete boolean := false;
l_new_token boolean := true;
l_enclosed boolean := false;
--
l_line_no number := 1;
l_column_no number := 1;
--
l_file_size integer := dbms_lob.lobmaxsize;
l_dest_offset integer := 1;
l_src_offset integer := 1;
l_blob_csid number := 871; --dbms_lob.default_csid;
l_lang_context number := dbms_lob.default_lang_ctx;
l_warning integer;
--
l_blob_len number;
l_clob_len number;
--
l_string_arr APEX_APPLICATION_GLOBAL.VC_ARR2;
l_offset NUMBER := 1;
l_amount NUMBER := 15000;
l_buf VARCHAR2(32000);
l_cnt_arr_chunks NUMBER := 0;
l_pos_arr_chunks NUMBER;
l_buf_len NUMBER;
l_buf_pos NUMBER := 0;
--
BEGIN
if upper(v('P12_CHAR_SET')) = 'UTF-8' then
l_blob_csid := 871;
else
select min(NLS_CHARSET_ID(v('P12_CHAR_SET')))
into l_blob_csid
from dual;
end if;
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'TM_PARSE_CSV');
select blob_content
into p_blob
from apex_application_temp_files
where name = v('P12_FILE_NAME');
DBMS_LOB.CREATETEMPORARY(p_blob_new, false);
l_blob_len := dbms_lob.getlength(p_blob);
if DBMS_LOB.substr(p_blob, 4, l_blob_len - 3) = '0D0A0D0A' then
p_amount := l_blob_len - 4;
else
p_amount := l_blob_len;
end if;
--
if DBMS_LOB.SUBSTR(p_blob, 3, 1) = 'EFBBBF' then
p_offset := 3;
else
p_offset := 0;
end if;
DBMS_LOB.COPY (
dest_lob => p_blob_new,
src_lob => p_blob,
amount => p_amount - p_offset + 1,
dest_offset => 1,
src_offset => p_offset + 1);
DBMS_LOB.CREATETEMPORARY(p_clob, false);
dbms_lob.convertToClob(
p_clob,
p_blob_new,
l_file_size,
l_dest_offset,
l_src_offset,
l_blob_csid,
l_lang_context,
l_warning);
l_clob_len := dbms_lob.getLength( p_clob );
if l_clob_len = 0 then
return;
end if;
WHILE l_offset < l_clob_len LOOP
l_cnt_arr_chunks := l_cnt_arr_chunks + 1;
DBMS_LOB.read(p_clob, l_amount, l_offset, l_buf);
l_offset := l_offset + l_amount;
l_string_arr(l_cnt_arr_chunks) := l_buf;
END LOOP;
l_pos_arr_chunks := 1;
l_buf := l_string_arr(l_pos_arr_chunks);
l_buf_len := length(l_buf);
loop
-- increment position index
l_pos := l_pos + 1;
l_buf_pos := l_buf_pos + 1;
--new chunk?
if l_pos_arr_chunks < l_cnt_arr_chunks then
if l_buf_pos+1 >= l_buf_len then
l_pos_arr_chunks := l_pos_arr_chunks + 1;
l_buf := substr(l_string_arr(l_pos_arr_chunks-1), l_buf_pos, l_buf_len - l_buf_pos + 1) || l_string_arr(l_pos_arr_chunks);
l_buf_len := length(l_buf);
l_buf_pos := 1;
end if;
end if;
-- get next character
l_char := substr( l_buf, l_buf_pos, 1);
-- exit when no more characters to process
exit when l_char is null or l_pos > l_clob_len;
-- if first character of new token is optionally enclosed character
-- note that and skip it and get next character
if l_new_token and l_char = p_optionally_enclosed then
l_enclosed := true;
l_pos := l_pos + 1;
l_buf_pos := l_buf_pos + 1;
l_char := substr( l_buf, l_buf_pos, 1);
end if;
l_new_token := false;
-- get look ahead character
l_lookahead := substr( l_buf, l_buf_pos + 1, 1);
-- inspect character (and lookahead) to determine what to do
if l_char = p_optionally_enclosed and l_enclosed then
if l_lookahead = p_optionally_enclosed then
l_pos := l_pos + 1;
l_buf_pos := l_buf_pos + 1;
l_token := l_token || l_lookahead;
elsif l_lookahead = p_delim then
l_pos := l_pos + 1;
l_buf_pos := l_buf_pos + 1;
l_token_complete := true;
else
l_enclosed := false;
end if;
elsif l_char in ( l_cr, l_lf ) and NOT l_enclosed then
l_token_complete := true;
l_line_complete := true;
if l_lookahead in ( l_cr, l_lf ) then
l_pos := l_pos + 1;
l_buf_pos := l_buf_pos + 1;
end if;
elsif l_char = p_delim and not l_enclosed then
l_token_complete := true;
elsif l_pos = l_clob_len then
l_token := l_token || l_char;
l_token_complete := true;
l_line_complete := true;
else
l_token := l_token || l_char;
end if;
-- process a new token
if l_token_complete then
if l_column_no = 1 then
p_message_code := l_token;
elsif l_column_no = 3 then
p_translated_text := l_token;
end if;
l_column_no := l_column_no + 1;
l_token := null;
l_enclosed := false;
l_new_token := true;
l_token_complete := false;
end if;
-- process end-of-line here
if l_line_complete then
if l_line_no > 1 then
APEX_COLLECTION.ADD_MEMBER(
p_collection_name => 'TM_PARSE_CSV',
p_c001 => p_message_code,
p_c002 => p_translated_text);
end if;
p_message_code := '';
p_translated_text := '';
l_line_no := l_line_no + 1;
l_column_no := 1;
l_line_complete := false;
end if;
end loop;
END TM_P_PARSE_CSV;
/
declare
l_cnt number;
begin
select count(*)
into l_cnt
from user_objects
where object_name = 'TM_LANGUAGES_TMP';
if l_cnt > 0 then
execute immediate 'drop table TM_LANGUAGES_TMP';
end if;
end;
/
CREATE TABLE TM_LANGUAGES_TMP (
CODE VARCHAR2(10),
LANGUAGE VARCHAR2(200),
TEXT_DIRECTION VARCHAR2(10)
)
/
insert into tm_languages_tmp (code, language, text_direction) values ('af', 'Afrikaans', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('sq', 'Albanian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-dz', 'Arabic (Algeria)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-bh', 'Arabic (Bahrain)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-eg', 'Arabic (Egypt)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-iq', 'Arabic (Iraq)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-jo', 'Arabic (Jordan)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-kw', 'Arabic (Kuwait)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-lb', 'Arabic (Lebanon)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-ly', 'Arabic (Libya)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-ma', 'Arabic (Morocco)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-om', 'Arabic (Oman)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-qa', 'Arabic (Qatar)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-sa', 'Arabic (Saudi Arabia)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-sy', 'Arabic (Syria)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-tn', 'Arabic (Tunisia)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-ae', 'Arabic (U.A.E.)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar-ye', 'Arabic (Yemen)', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('ar', 'Arabic', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('hy', 'Armenian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('as', 'Assamese', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('eu', 'Basque', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('be', 'Belarusian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('bn', 'Bengali', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('bg', 'Bulgarian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ca', 'Catalan', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('zh-cn', 'Chinese (China)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('zh-hk', 'Chinese (Hong Kong SAR)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('zh-mo', 'Chinese (Macau SAR)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('zh-sg', 'Chinese (Singapore)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('zh-tw', 'Chinese (Taiwan)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('zh', 'Chinese', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('hr', 'Croatian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('cs', 'Czech', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('da', 'Danish', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('nl-be', 'Dutch (Belgium)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('nl', 'Dutch (Netherlands)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-au', 'English (Australia)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-bz', 'English (Belize)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-ca', 'English (Canada)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-ie', 'English (Ireland)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-jm', 'English (Jamaica)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-nz', 'English (New Zealand)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-ph', 'English (Philippines)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-za', 'English (South Africa)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-tt', 'English (Trinidad)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-gb', 'English (United Kingdom)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-us', 'English (United States)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en-zw', 'English (Zimbabwe)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('en', 'English', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('et', 'Estonian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('mk', 'FYRO Macedonian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fo', 'Faeroese', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fa', 'Farsi', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fi', 'Finnish', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fr-be', 'French (Belgium)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fr-ca', 'French (Canada)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fr', 'French (France)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fr-lu', 'French (Luxembourg)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fr-mc', 'French (Monaco)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('fr-ch', 'French (Switzerland)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('gd', 'Gaelic', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('gl', 'Galician', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('de-at', 'German (Austria)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('de', 'German (Germany)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('de-li', 'German (Liechtenstein)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('de-lu', 'German (Luxemgourg)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('de-ch', 'German (Switzerland)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('el', 'Greek', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('gu', 'Gujarati', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('he', 'Hebrew', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('hi', 'Hindi', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('hu', 'Hungarian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('is', 'Icelandic', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('id', 'Indonesian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ga', 'Irish', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('it', 'Italian (Italy)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('it-ch', 'Italian (Switzerland)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ja', 'Japanese', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('kn', 'Kannada', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('kk', 'Kazakh', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('kok', 'Konkani', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ko', 'Korean', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('kz', 'Kyrgyz', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('lv', 'Latvian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('lt', 'Lithuanian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ms', 'Malay (Malaysia)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ml', 'Malayalam', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('mt', 'Maltese', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('mr', 'Marathi', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ne', 'Nepali (India)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('nb-no', 'Norwegian (Bokmal)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('no', 'Norwegian (Bokmal)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('nn-no', 'Norwegian (Nynorsk)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('or', 'Oriya', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('pl', 'Polish', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('pt-br', 'Portuguese (Brazil)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('pt', 'Portuguese (Portugal)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('pa', 'Punjabi', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ro', 'Romanian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ru-md', 'Russian (Moldova)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ru', 'Russian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('sr', 'Serbian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('sk', 'Slovak', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('sl', 'Slovenian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-ar', 'Spanish (Argentina)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-bo', 'Spanish (Bolivia)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-cl', 'Spanish (Chile)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-co', 'Spanish (Columbia)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-cr', 'Spanish (Costa Rica)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-do', 'Spanish (Dominican Republic)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-ec', 'Spanish (Ecudor)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-sv', 'Spanish (El Salvador)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-gt', 'Spanish (Guatemala)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-hn', 'Spanish (Honduras)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-mx', 'Spanish (Mexico)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-ni', 'Spanish (Nicaragua)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-pa', 'Spanish (Panama)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-py', 'Spanish (Paraguay)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-pe', 'Spanish (Peru)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-pr', 'Spanish (Peurto Rico)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es', 'Spanish (Traditional Sort)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-us', 'Spanish (United States)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-uy', 'Spanish (Uruguay)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('es-ve', 'Spanish (Venezuela)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('sv-fi', 'Swedish (Finland)', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('sv', 'Swedish', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ta', 'Tamil', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('te', 'Telugu', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('th', 'Thai', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('tr', 'Turkish', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('uk', 'Ukrainian', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('ur', 'Urdu', 'RTL');
insert into tm_languages_tmp (code, language, text_direction) values ('uz', 'Uzbek', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('vi', 'Vietnamese', 'LTR');
insert into tm_languages_tmp (code, language, text_direction) values ('cy', 'Welsh', 'LTR');
MERGE INTO tm_languages l
USING (SELECT code, language, text_direction
FROM tm_languages_tmp) l_tmp
ON
(upper(l.code) = upper(l_tmp.code))
WHEN MATCHED THEN
UPDATE SET
l.language = l_tmp.language,
l.text_direction = l_tmp.text_direction
WHEN NOT MATCHED THEN
INSERT (code, language, text_direction)
VALUES (l_tmp.code, l_tmp.language, l_tmp.text_direction);
DROP TABLE TM_LANGUAGES_TMP;
TRUNCATE TABLE TM_DOC_MESSAGES;
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EMAIL_NOT_CONFIGURED','Email has not been configured for this application. Please contact your administrator.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_COMPUTE','Computations allow you to add computed columns to your report. These can be mathematical computations (e.g. NBR_HOURS/24) or standard Oracle functions applied to existing columns (some have been displayed for example, others, like TO_DATE, can also be used).
<p/>
<ul><li><b>Computation</b> allows you to select a previously defined computation to edit.</li>
<li><b>Column Heading</b> is the column heading for the new column.</li>
<li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li>
<li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li>
<li><b>Computation</b> is the computation to be performed. Within the computation, columns are referenced using the aliases displayed.</li>
</ul>
<p/>
Below computation, the columns in your query are displayed with their associated alias. Clicking on the column name or alias will write them into the Computation. Next to Columns is a Keypad. These are simply shortcuts of commonly used keys. On the far right are Functions.
<p/>
An example computation to display Total Compensation is:
<p/>
<pre>CASE WHEN A = ''SALES'' THEN B + C ELSE B END</pre>
(where A is ORGANIZATION, B is SALARY and C is COMMISSION)','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_CONTROL_BREAK','Used to create a break group on one or several columns. This pulls the columns out of the Interactive Report and displays them as a master record.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_DETAIL_VIEW','To view the details of a single row at a time, click the single row view icon on the row you want to view. If available, the single row view will always be the first column. Depending on the customization of the Interactive Report, the single row view may be the standard view or a custom page that may allow update.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_DOWNLOAD','Allows the current result set to be downloaded. The download formats will differ depending upon your installation and report definition but may include CSV, XLS, PDF, or RTF.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_FILTER','Used to add or modify the where clause on the query. You first select a column (it does not need to be one that is displayed), select from a list of standard Oracle operators (=, !=, not in, between), and enter an expression to compare against. The expression is case sensitive and you can use % as a wildcard (for example, STATE_NAME like A%).','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_FLASHBACK','Performs a flashback query to allow you to view the data as it existed at a previous point in time. The default amount of time that you can flashback is 3 hours (or 180 minutes) but the actual amount will differ per database.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_FORMAT','<p>Format enable you to customize the display of the report. Format contains the following submenu:</p> <ul><li>Sort</li> <li>Control Break</li> <li>Highlight</li> <li>Compute</li> <li>Aggregate</li> <li>Chart</li> <li>Group By</li> <li>Pivot</li> </ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_GROUP_BY','You can define one Group By view per saved report. Once defined, you can switch between the group by and report views using view icons on the Search bar. To create a Group By view, you select: <p></p><ul> <li>the columns on which to group</li> <li>the columns to aggregate along with the function to be performed (average, sum, count, etc.)</li> </ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_HIGHLIGHT','Highlighting allows you to define a filter. The rows that meet the filter are highlighted using the characteristics associated with the filter.
<p/>
<ul><li><b>Name</b> is used only for display.</li>
<li><b>Sequence</b> identifies the sequence in which the rules will be evaluated.</li>
<li><b>Enabled</b> identifies if the rule is enabled or disabled.</li>
<li><b>Highlight Type</b> identifies whether the Row or Cell should be highlighted. If Cell is selected, the column referenced in the Highlight Condition is highlighted.</li>
<li><b>Background Color</b> is the new color for the background of the highlighted area.</li>
<li><b>Text Color</b> is the new color for the text in the highlighted area.</li>
<li><b>Highlight Condition</b> defines your filter condition.</li></ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_PIVOT','You can define one Pivot view per saved report. Once defined, you can switch between the pivot and report views using view icons on the Search bar. To create a Pivot view, you select: <p></p> <ul> <li>the columns on which to pivot</li> <li>the columns to display as rows</li> <li>the columns to aggregate along with the function to be performed (average, sum, count, etc.)</li> </ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_REPORT_SETTINGS','If you have customized your Interactive Report, the report settings will be displayed below the Search Bar and above the report. If you have saved customized reports, they will be shown as tabs. You can access your alternate views by clicking the tabs. Below the tabs are the report settings for the current report. This area can be collapsed and expanded using the icon on the left.
<p/>
For each report setting, you can:
<ul><li><b>Edit</b> by clicking the name.</li>
<li><b>Disable/Enable</b> by unchecking or checking the Enable/Disable check box. This is used to temporarily turn off and on the setting.</li>
<li><b>Remove</b> by click the Remove icon. This permanently removes the setting.</li></ul>
<p/>
If you have created a chart, you can toggle between the report and chart using the Report View and Chart View links shown on the right. If you are viewing the chart, you can also use the Edit Chart link to edit the chart settings.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_RESET','Resets the report back to the default settings, removing any customizations that you have made.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_ROWS_PER_PAGE','Sets the number of records to display per page.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SAVE_REPORT','Saves the customized report for future use. You provide a name and optional description and can make the report accessible to the public (that is, all users who can access the primary default report). You can save four types of interactive reports:
Primary Default (Developer Only). The Primary Default is the report that initially displays. Primary Default reports cannot be renamed or deleted.
Alternative Report (Developer Only). Enables developers to create multiple report layouts. Only developers can save, rename, or delete an Alternative Report.
Public Report (End user). Can be saved, renamed, or deleted by the end user who created it. Other users can view and save the layout as another report.
Private Report (End user). Only the end user that created the report can view, save, rename or delete the report.
If you save customized reports, a Reports selector displays in the Search bar to the left of the Rows selector (if this feature is enabled).','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR','At the top of each report page is a search region. The region provides the following features:
<p/>
<ul><li><b>Select columns icon</b> allows you to identify which column to search (or all).</li>
<li><b>Text area</b> allows for case insensitive search criteria (no need for wild cards).</li>
<li><b>Rows</b> selects the number of records to display per page.</li>
<li><b>[Go] button</b> executes the search.</li>
<li><b>Actions Menu icon</b> displays the actions menu (discussed next).</li></ul>
<p/>
Please note that all features may not be available for each report.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR_ACTIONS_MENU','<li><b>Actions Menu</b> enables you to customize a report. See the sections that follow.</li>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR_FINDER','<li><b>Select columns icon</b> enables you to identify which column to search (or all).</li>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR_REPORTS','<li><b>Reports</b> displays alternate default and saved private or public reports.</li>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR_ROWS','<li><b>Rows</b> sets the number of records to display per page.</li>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR_TEXTBOX','<li><b>Text area</b> enables you to enter case insensitive search criteria (wild card characters are implied).</li> <li><b>Go button</b> executes the search. Hitting the enter key will also execute the search when the cursor is in the search text area.</li>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SEARCH_BAR_VIEW','<li><b>View Icons</b> switches between the icon, report, detail, chart, group by, and pivot views of the report if they are defined.</li>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SELECT_COLUMNS','Used to modify the columns displayed. The columns on the right are displayed. The columns on the left are hidden. You can reorder the displayed columns using the arrows on the far right. Computed columns are prefixed with <b>**</b>.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SORT','Used to change the column(s) to sort on and whether to sort ascending or descending. You can also specify how to handle nulls (use the default setting, always display them last or always display them first). The resulting sorting is displayed to the right of column headings in the report.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_SUBSCRIPTION','When you add a subscription, you provide an email address (or multiple email addresses, separated by commas), email subject, frequency, and start and end dates. The resulting emails include an HTML version of the interactive report containing the current data using the report setting that were present when the subscription was added.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HIDE_COLUMN','Hide Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HIGHLIGHT','Highlight','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HIGHLIGHT_CONDITION','Highlight Condition','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HIGHLIGHT_TYPE','Highlight Type','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HIGHLIGHT_WHEN','Highlight When','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HIGHLIGHTS','Highlights','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INACTIVE_SETTING','1 inactive setting','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INACTIVE_SETTINGS','%0 inactive settings','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INTERACTIVE_REPORT_HELP','Interactive Report Help','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID','Invalid','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID_COMPUTATION','Invalid computation expression. %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID_END_DATE','The end date must be greater than the start date.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID_FILTER','Invalid filter expression. %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID_FILTER_QUERY','Invalid filter query','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID_SETTING','1 invalid setting','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_INVALID_SETTINGS','%0 invalid settings','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_IS_IN_THE_LAST','%0 is in the last %1','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_IS_IN_THE_NEXT','%0 is in the next %1','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_IS_NOT_IN_THE_LAST','%0 is not in the last %1','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_IS_NOT_IN_THE_NEXT','%0 is not in the next %1','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_KEYPAD','Keypad','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LABEL','Label','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LABEL_AXIS_TITLE','Axis Title for Label','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LABEL_PREFIX','Label Prefix','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_DAY','Last Day','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_HOUR','Last Hour','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_MONTH','Last Month','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_WEEK','Last Week','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_X_DAYS','Last %0 Days','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_X_HOURS','Last %0 Hours','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_X_YEARS','Last %0 Years','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LAST_YEAR','Last Year','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_LINE','Line','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MAX_QUERY_COST','The query is estimated to exceed the maximum allowed resources. Please modify your report settings and try again.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MAX_ROW_CNT','This query returns more then %0 rows, please filter your data to ensure complete results.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MAX_X','Maximum %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MEDIAN_X','Median %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MIN_AGO','%0 minutes ago','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MIN_X','Minimum %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MONTH','Month','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_MONTHLY','Monthly','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EMAIL_REQUIRED','Email Address must be specified.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EMAIL_SEE_ATTACHED','See attached.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EMAIL_SUBJECT','Subject','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EMAIL_SUBJECT_REQUIRED','Email Subject must be specified.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EMAIL_TO','To','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ENABLE','Enable','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ENABLE_DISABLE_ALT','Enable/Disable','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ENABLED','Enabled','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ERROR','Error','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EXAMPLES','Examples','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EXAMPLES_WITH_COLON','Examples:','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EXCLUDE_NULL','Exclude Null Values','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EXPAND_COLLAPSE_ALT','Expand/Collapse','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_EXPRESSION','Expression','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FILTER','Filter','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FILTER_EXPRESSION','Filter Expression','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FILTER_TYPE','Filter Type','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FILTERS','Filters','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FINDER_ALT','Select columns to search.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FLASHBACK','Flashback','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FLASHBACK_DESCRIPTION','A flashback query enables you to view the data as it existed at a previous point in time.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FLASHBACK_ERROR_MSG','Unable to perform flashback request.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FORMAT','Format','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FORMAT_MASK','Format Mask','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FUNCTION','Function','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FUNCTION_N','Function %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FUNCTIONS','Functions','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_FUNCTIONS_OPERATORS','Functions / Operators','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GO','Go','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GREEN','green','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GROUP_BY','Group By','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GROUP_BY_COL_NOT_NULL','Group by column must be specified','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GROUP_BY_COLUMN','Group By Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GROUP_BY_MAX_ROW_CNT','The maximum row count for a Group By query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GROUP_BY_SORT','Group By Sort','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_GROUP_BY_SORT_ORDER','Group By Sort Order','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HCOLUMN','Horizontal Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP','Help','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_01','An Interactive Report displays a predetermined set of columns. The report may be further customized with an initial filter clause, a default sort order, control breaks, highlighting, computations, aggregates and a chart. Each Interactive Report can then be further customized and the results can be viewed, or downloaded, and the report definition can be stored for later use.
<p/>
An Interactive Report can be customized in three ways: the search bar, actions menu and column heading menu.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_ACTIONS_MENU','The actions menu is used to customize the display of your Interactive Report.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_AGGREGATE','Aggregates are mathematical computations performed against a column. Aggregates are displayed after each control break and at the end of the report within the column they are defined.
<p/>
<ul><li><b>Aggregation</b> allows you to select a previously defined aggregation to edit.</li>
<li><b>Function</b> is the function to be performed (e.g. SUM, MIN).</li>
<li><b>Column</b> is used to select the column to apply the mathematical function to. Only numeric columns will be displayed.</li></ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_CHART','You can include one chart per Interactive Report. Once defined, you can switch between the chart and report views using links below the search bar.
<p/>
<ul><li><b>Chart Type</b> identifies the chart type to include. Select from horizontal bar, vertical bar, pie or line.</li>
<li><b>Label</b> allows you to select the column to be used as the label.</li>
<li><b>Axis Title for Label</b> is the title that will display on the axis associated with the column selected for Label. This is not available for pie chart.</li>
<li><b>Value</b> allows you to select the column to be used as the value. If your function is a COUNT, a Value does not need to be selected.</li>
<li><b>Axis Title for Value</b> is the title that will display on the axis associated with the column selected for Value. This is not available for pie chart.</li>
<li><b>Function</b> is an optional function to be performed on the column selected for Value.</li></ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_HELP_COLUMN_HEADING_MENU','Clicking on any column heading exposes a column heading menu.
<p/>
<ul><li><b>Sort Ascending icon</b> sorts the report by the column in ascending order.</li>
<li><b>Sort Descending icon</b> sorts the report by the column in descending order.</li>
<li><b>Hide Column</b> hides the column.</li>
<li><b>Break Column</b> creates a break group on the column. This pulls the column out of the report as a master record.</li>
<li><b>Column Information</b> displays help text about the column, if available.</li>
<li><b>Text Area</b> is used to enter case insensitive search criteria (no need for wild cards). Entering a value will reduce the list of values at the bottom of the menu. You can then select a value from the bottom and the selected value will be created as a filter using ''='' (e.g. column = ''ABC''). Alternatively, you can click the flashlight icon and the entered value will be created as a filter with the ''LIKE'' modifier (e.g. column LIKE ''%ABC%'').<li><b>List of Unique Values</b> contains the first 500 unique values that meet your filters. If the column is a date, a list of date ranges is displayed instead. If you select a value, a filter will be created using ''='' (e.g. column = ''ABC'').</li></ul>','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('RESET','reset pagination','BOTH');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_RENDER_REPORT3.X_Y_OF_Z_2','%0 - %1 of %2','BOTH');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('OUT_OF_RANGE','Invalid set of rows requested, the source data of the report has been modified.','BOTH');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.AUTHENTICATION.LOGIN_THROTTLE.COUNTER','Please wait <span id="apex_login_throttle_sec">%0</span> seconds to login again.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.AUTHENTICATION.LOGIN_THROTTLE.ERROR','The login attempt has been blocked.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATA_HAS_CHANGED','Current version of data in database has changed since user initiated update process. current checksum = "%0" application checksum = "%1".','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATEPICKER.ICON_TEXT','Popup Calendar: %0','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATEPICKER_VALUE_GREATER_MAX_DATE','#LABEL# is greater than specified maximum date %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATEPICKER_VALUE_INVALID','#LABEL# does not match format %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATEPICKER_VALUE_LESS_MIN_DATE','#LABEL# is less than specified minimum date %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATEPICKER_VALUE_NOT_BETWEEN_MIN_MAX','#LABEL# is not between the valid range of %0 and %1.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.DATEPICKER_VALUE_NOT_IN_YEAR_RANGE','#LABEL# is not within valid year range of %0 and %1.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.FILE_BROWSE.DOWNLOAD_LINK_TEXT','Download','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.GO_TO_ERROR','Go to error','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.ITEM_TYPE.SLIDER.VALUE_NOT_BETWEEN_MIN_MAX','#LABEL# is not between the valid range of %0 and %1.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.ITEM_TYPE.SLIDER.VALUE_NOT_MULTIPLE_OF_STEP','#LABEL# is not a multiple of %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.ITEM_TYPE.YES_NO.INVALID_VALUE','#LABEL# must match to the values %0 and %1.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.ITEM_TYPE.YES_NO.NO_LABEL','No','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.ITEM_TYPE.YES_NO.YES_LABEL','Yes','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.NUMBER_FIELD.VALUE_GREATER_MAX_VALUE','#LABEL# is greater than specified maximum %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.NUMBER_FIELD.VALUE_INVALID','#LABEL# must be Numeric.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.NUMBER_FIELD.VALUE_INVALID2','#LABEL# does not match number format %0 (For example, %1).','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.NUMBER_FIELD.VALUE_LESS_MIN_VALUE','#LABEL# is less than specified minimum %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.NUMBER_FIELD.VALUE_NOT_BETWEEN_MIN_MAX','#LABEL# is not between the valid range of %0 and %1.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.PAGE_ITEM_IS_REQUIRED','#LABEL# must have some value.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.POPUP_LOV.ICON_TEXT','Popup List of Values: %0.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.REGION.JQM_LIST_VIEW.SEARCH','Search','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEX.REGION.JQM_LIST_VIEW.LOAD_MORE','Load more','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('FLOW.SINGLE_VALIDATION_ERROR','1 error has occurred.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('FLOW.VALIDATION_ERROR','%0 errors have occurred.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('INVALID_CREDENTIALS','Invalid Login Credentials .','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('PAGINATION.NEXT','Next','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('PAGINATION.NEXT_SET','Next Set','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('PAGINATION.PREVIOUS','Previous','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('PAGINATION.PREVIOUS_SET','Previous Set','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('REPORT_TOTAL','report total','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_DAYS_AGO','%0 days ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_DAYS_FROM_NOW','%0 days from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_HOURS_AGO','%0 hours ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_HOURS_FROM_NOW','%0 hours from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_MINUTES_AGO','%0 minutes ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_MINUTES_FROM_NOW','%0 minutes from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_MONTHS_AGO','%0 months ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_MONTHS_FROM_NOW','%0 months from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_NOW','Now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_SECONDS_AGO','%0 seconds ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_SECONDS_FROM_NOW','%0 seconds from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_WEEKS_AGO','%0 weeks ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_WEEKS_FROM_NOW','%0 weeks from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_YEARS_AGO','%0 years ago','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('SINCE_YEARS_FROM_NOW','%0 years from now','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('TOTAL','Total','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_FLOW_UTILITIES.CAL','Calendar','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_FLOW_UTILITIES.CLOSE','Close','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_FLOW_UTILITIES.OK','Ok','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_RENDER_REPORT3.FOUND_BUT_NOT_DISPLAYED','Minimum row requested: %0, rows found but not displayed: %1','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_RENDER_REPORT3.SORT_BY_THIS_COLUMN','Sort by this column.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_RENDER_REPORT3.UNSAVED_DATA','This form contains unsaved changes. Press Ok to proceed without saving your changes.','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_RENDER_REPORT3.X_Y_OF_MORE_THAN_Z','row(s) %0 - %1 of more than %2','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('WWV_RENDER_REPORT3.X_Y_OF_Z','row(s)%0 - %1 of %2','INTERNAL');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('4150_COLUMN_NUMBER','Column %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_3D','3D','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ACTIONS','Actions','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ACTIONS_MENU','Actions Menu','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ADD','Add','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ADD_FUNCTION','Add Function','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ADD_GROUP_BY_COLUMN','Add Group By Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ADD_PIVOT_COLUMN','Add Pivot Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ADD_ROW_COLUMN','Add Row Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ADD_SUBSCRIPTION','Add Subscription','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_AVG','Average','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_COUNT','Count','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_MAX','Maximum','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_MEDIAN','Median','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_MIN','Minimum','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_MODE','Mode','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGG_SUM','Sum','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGGREGATE','Aggregate','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGGREGATE_DESCRIPTION','Aggregates are displayed after each control break and at the end of the report.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AGGREGATION','Aggregation','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ALL','All','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ALL_COLUMNS','All Columns','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ALL_ROWS','All Rows','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ALTERNATIVE','Alternative','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ALTERNATIVE_DEFAULT_NAME','Alternative Default: %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AND','and','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_APPLY','Apply','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AS_OF','As of %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_ASCENDING','Ascending','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_AVERAGE_X','Average %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_BETWEEN','between','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_BGCOLOR','Background Color','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_BLUE','blue','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_BOTTOM','Bottom','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CALENDAR','Calendar','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CANCEL','Cancel','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CATEGORY','Category','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CELL','Cell','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHART','Chart','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHART_INITIALIZING','Initializing...','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHART_LABEL_NOT_NULL','Chart label must be specified','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHART_MAX_ROW_CNT','The maximum row count for a chart query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHART_TYPE','Chart Type','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHECK_ALL','Check All','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CHOOSE_DOWNLOAD_FORMAT','Choose report download format','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CLEAR','clear','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMN','Column','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMN_FILTER','Filter...','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMN_HEADING','Column Heading','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMN_HEADING_MENU','Column Heading Menu','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMN_INFO','Column Information','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMN_N','Column %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COLUMNS','Columns','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_CONTAINS','contains','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_DOESNOT_CONTAIN','does not contain','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_IN','in','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_IS_IN_LAST','is in the last','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_IS_IN_NEXT','is in the next','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_IS_NOT_NULL','is not null','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_IS_NULL','is null','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_ISNOT_IN_LAST','is not in the last','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_ISNOT_IN_NEXT','is not in the next','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_LIKE','like','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_NOT_IN','not in','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_NOT_LIKE','not like','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPARISON_REGEXP_LIKE','matches regular expression','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTATION','Computation','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTATION_EXPRESSION','Computation Expression','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTATION_FOOTER','Create a computation using column aliases.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTATION_FOOTER_E1','(B+C)*100','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTATION_FOOTER_E2','INITCAP(B)||'', ''||INITCAP(C)','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTATION_FOOTER_E3','CASE WHEN A = 10 THEN B + C ELSE B END','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COMPUTE','Compute','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CONTROL_BREAK','Control Break','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CONTROL_BREAK_COLUMNS','Control Break Columns','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_CONTROL_BREAKS','Control Breaks','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COUNT_DISTINCT','Count Distinct','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COUNT_DISTINCT_X','Count Distinct','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_COUNT_X','Count %0','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DAILY','Daily','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DATA_AS_OF','Report data as of %0 minutes ago.','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DATE','Date','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DAY','Day','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DEFAULT','Default','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DEFAULT_REPORT_TYPE','Default Report Type','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DELETE','Delete','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DELETE_CHECKED','Delete Checked','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DELETE_CONFIRM','Would you like to delete these report settings?','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DELETE_CONFIRM_JS_DIALOG','Would you like to perform this delete action?','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DELETE_DEFAULT_REPORT','Delete Default Report','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DELETE_REPORT','Delete Report','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DESCENDING','Descending','INTERACTIVEREPORT');
Insert into TM_DOC_MESSAGES (TRANSLATABLE_MESSAGE,MESSAGE_TEXT,INTERNAL_IR) values ('APEXIR_DESCRIPTION','Description','INTERACTIVEREPORT');