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

APPS.PAY_NO_ABS_STATISTICS_REPORT dependencies on DBMS_LOB

Line 873: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

869: l_str7 := ' ';
870: l_str10 := '';
871: l_str11 := '';
872: l_str12 := 'QUARTER_VAL';
873: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
874: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
875: current_index := 0;
876: IF gplsqltable.COUNT > 0 THEN
877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

Line 874: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

870: l_str10 := '';
871: l_str11 := '';
872: l_str12 := 'QUARTER_VAL';
873: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
874: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
875: current_index := 0;
876: IF gplsqltable.COUNT > 0 THEN
877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
878: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST

Line 877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

873: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
874: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
875: current_index := 0;
876: IF gplsqltable.COUNT > 0 THEN
877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
878: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST
879: LOOP
880: l_str8 := gplsqltable (table_counter).tagname;
881: l_str9 := gplsqltable (table_counter).tagvalue;

Line 886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

882: hr_utility.set_location(' l_quater : '||l_quater,10);
883: hr_utility.set_location(' l_str8 : '||l_str8,20);
884: hr_utility.set_location(' l_str9 : '||l_str9,30);
885: IF l_quater <> gplsqltable (table_counter).tagvalue and l_str8 = 'QUARTER' and l_quater is not null THEN
886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
887: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
889: l_quater := gplsqltable (table_counter).tagvalue;
890: l_quater_flag:='Y';

Line 887: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

883: hr_utility.set_location(' l_str8 : '||l_str8,20);
884: hr_utility.set_location(' l_str9 : '||l_str9,30);
885: IF l_quater <> gplsqltable (table_counter).tagvalue and l_str8 = 'QUARTER' and l_quater is not null THEN
886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
887: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
889: l_quater := gplsqltable (table_counter).tagvalue;
890: l_quater_flag:='Y';
891: END IF;

Line 888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

884: hr_utility.set_location(' l_str9 : '||l_str9,30);
885: IF l_quater <> gplsqltable (table_counter).tagvalue and l_str8 = 'QUARTER' and l_quater is not null THEN
886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
887: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
889: l_quater := gplsqltable (table_counter).tagvalue;
890: l_quater_flag:='Y';
891: END IF;
892: IF l_str8 = 'QUARTER' and l_quater_flag = 'Y' then

Line 895: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

891: END IF;
892: IF l_str8 = 'QUARTER' and l_quater_flag = 'Y' then
893: l_quater:=gplsqltable (table_counter).tagvalue;
894: IF l_str9 IS NOT NULL THEN
895: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

Line 896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

892: IF l_str8 = 'QUARTER' and l_quater_flag = 'Y' then
893: l_quater:=gplsqltable (table_counter).tagvalue;
894: IF l_str9 IS NOT NULL THEN
895: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

Line 897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

893: l_quater:=gplsqltable (table_counter).tagvalue;
894: IF l_str9 IS NOT NULL THEN
895: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

Line 898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

894: IF l_str9 IS NOT NULL THEN
895: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

895: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

Line 900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

897: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
905:

Line 902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

898: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
905:
906: Else

Line 903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

899: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
905:
906: Else
907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

Line 904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

900: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
901: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
905:
906: Else
907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

903: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
905:
906: Else
907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

Line 908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
905:
906: Else
907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

Line 909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

905:
906: Else
907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

906: Else
907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

Line 911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

907: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
915: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

908: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
915: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
916:

Line 913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

909: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
915: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
916:
917: End if;

Line 914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

910: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
915: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
916:
917: End if;
918: l_quater_flag:='N';

Line 915: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

911: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
912: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
913: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
914: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
915: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
916:
917: End if;
918: l_quater_flag:='N';
919: End if;

Line 923: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str11),l_str11);

919: End if;
920: IF l_str8 <> 'QUARTER' THEN
921:
922: /* IF l_str9 = 'END' THEN
923: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str11),l_str11);
924: ELSIF l_str9 = 'START' THEN
925: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str10),l_str10);*/
926:
927: IF l_str9 IS NOT NULL THEN

Line 925: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str10),l_str10);*/

921:
922: /* IF l_str9 = 'END' THEN
923: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str11),l_str11);
924: ELSIF l_str9 = 'START' THEN
925: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str10),l_str10);*/
926:
927: IF l_str9 IS NOT NULL THEN
928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

924: ELSIF l_str9 = 'START' THEN
925: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str10),l_str10);*/
926:
927: IF l_str9 IS NOT NULL THEN
928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

925: DBMS_LOB.writeappend (l_xfdf_string,LENGTH (l_str10),l_str10);*/
926:
927: IF l_str9 IS NOT NULL THEN
928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

926:
927: IF l_str9 IS NOT NULL THEN
928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

927: IF l_str9 IS NOT NULL THEN
928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE

Line 932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

928: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

Line 933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

929: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

930: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
931: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

Line 936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

932: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

933: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

934: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
942: END IF;

Line 939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

935: ELSE
936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
942: END IF;
943: END IF;

Line 940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

936: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
942: END IF;
943: END IF;
944: IF table_counter = gplsqltable.LAST THEN

Line 941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

937: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
938: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
939: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
940: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
942: END IF;
943: END IF;
944: IF table_counter = gplsqltable.LAST THEN
945: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 945: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

941: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
942: END IF;
943: END IF;
944: IF table_counter = gplsqltable.LAST THEN
945: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('QUARTER'), 'QUARTER');
947: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
948: END IF;
949: END LOOP;

Line 946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('QUARTER'), 'QUARTER');

942: END IF;
943: END IF;
944: IF table_counter = gplsqltable.LAST THEN
945: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('QUARTER'), 'QUARTER');
947: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
948: END IF;
949: END LOOP;
950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

Line 947: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

943: END IF;
944: IF table_counter = gplsqltable.LAST THEN
945: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('QUARTER'), 'QUARTER');
947: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
948: END IF;
949: END LOOP;
950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
951: ELSE

Line 950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

946: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('QUARTER'), 'QUARTER');
947: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
948: END IF;
949: END LOOP;
950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
951: ELSE
952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
953: END IF;
954: p_xfdf_clob := l_xfdf_string;

Line 952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

948: END IF;
949: END LOOP;
950: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
951: ELSE
952: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
953: END IF;
954: p_xfdf_clob := l_xfdf_string;
955:
956: EXCEPTION