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.PER_DIF_STMT_REPORT dependencies on DBMS_LOB

Line 992: dbms_lob.createtemporary(l_xfdf_string, FALSE, dbms_lob.call);

988: l_str5 := ' ';
989: l_str6 := '
990:
991: ';
992: dbms_lob.createtemporary(l_xfdf_string, FALSE, dbms_lob.call);
993: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
994: --
995: hr_utility.set_location('Table count: '||to_char(xml_table.count), 60);
996: --

Line 993: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

989: l_str6 := '
990:
991: ';
992: dbms_lob.createtemporary(l_xfdf_string, FALSE, dbms_lob.call);
993: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
994: --
995: hr_utility.set_location('Table count: '||to_char(xml_table.count), 60);
996: --
997: IF xml_table.count > 0 THEN

Line 998: dbms_lob.writeappend( l_xfdf_string, length(l_str1), l_str1 );

994: --
995: hr_utility.set_location('Table count: '||to_char(xml_table.count), 60);
996: --
997: IF xml_table.count > 0 THEN
998: dbms_lob.writeappend( l_xfdf_string, length(l_str1), l_str1 );
999: FOR ctr_table IN xml_table.FIRST .. xml_table.LAST LOOP
1000: hr_utility.set_location('Counter table: '||to_char(ctr_table), 65);
1001: l_str7 := xml_table(ctr_table).tag_name;
1002: l_str8 := nvl(xml_table(ctr_table).tag_value, ' ');

Line 1009: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <

1005: hr_utility.set_location('Tag name is: '||l_str7, 65);
1006: hr_utility.set_location('Tag value is: '||l_str8, 65);
1007: --
1008: IF l_str8 = '1' THEN -- start of the label
1009: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1010: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1011: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1012: --
1013: hr_utility.set_location('xml string', 70);

Line 1010: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name

1006: hr_utility.set_location('Tag value is: '||l_str8, 65);
1007: --
1008: IF l_str8 = '1' THEN -- start of the label
1009: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1010: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1011: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1012: --
1013: hr_utility.set_location('xml string', 70);
1014: --

Line 1011: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->

1007: --
1008: IF l_str8 = '1' THEN -- start of the label
1009: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1010: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1011: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1012: --
1013: hr_utility.set_location('xml string', 70);
1014: --
1015: ELSE -- end of the label

Line 1016: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );----

1012: --
1013: hr_utility.set_location('xml string', 70);
1014: --
1015: ELSE -- end of the label
1016: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );---- 1017: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name
1018: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >
1019: --
1020: hr_utility.set_location('xml string', 80);

Line 1017: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name

1013: hr_utility.set_location('xml string', 70);
1014: --
1015: ELSE -- end of the label
1016: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );---- 1017: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name
1018: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >
1019: --
1020: hr_utility.set_location('xml string', 80);
1021: --

Line 1018: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >

1014: --
1015: ELSE -- end of the label
1016: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );---- 1017: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name
1018: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >
1019: --
1020: hr_utility.set_location('xml string', 80);
1021: --
1022: END IF;

Line 1027: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <

1023: ELSE
1024: --
1025: hr_utility.set_location('xml string: '||l_str7, 90);
1026: --
1027: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1028: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1029: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1030: dbms_lob.writeappend( l_xfdf_string, length(l_str8), l_str8);-----value
1031: --

Line 1028: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name

1024: --
1025: hr_utility.set_location('xml string: '||l_str7, 90);
1026: --
1027: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1028: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1029: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1030: dbms_lob.writeappend( l_xfdf_string, length(l_str8), l_str8);-----value
1031: --
1032: hr_utility.set_location('Appended Value: '||l_str8, 95);

Line 1029: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->

1025: hr_utility.set_location('xml string: '||l_str7, 90);
1026: --
1027: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1028: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1029: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1030: dbms_lob.writeappend( l_xfdf_string, length(l_str8), l_str8);-----value
1031: --
1032: hr_utility.set_location('Appended Value: '||l_str8, 95);
1033: --

Line 1030: dbms_lob.writeappend( l_xfdf_string, length(l_str8), l_str8);-----value

1026: --
1027: dbms_lob.writeappend( l_xfdf_string, length(l_str2), l_str2 );--- <
1028: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);------ name
1029: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );---->
1030: dbms_lob.writeappend( l_xfdf_string, length(l_str8), l_str8);-----value
1031: --
1032: hr_utility.set_location('Appended Value: '||l_str8, 95);
1033: --
1034: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );----

Line 1034: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );----

1030: dbms_lob.writeappend( l_xfdf_string, length(l_str8), l_str8);-----value
1031: --
1032: hr_utility.set_location('Appended Value: '||l_str8, 95);
1033: --
1034: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );---- 1035: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name
1036: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >
1037: END IF;
1038: END LOOP;

Line 1035: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name

1031: --
1032: hr_utility.set_location('Appended Value: '||l_str8, 95);
1033: --
1034: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );---- 1035: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name
1036: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >
1037: END IF;
1038: END LOOP;
1039: --

Line 1036: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >

1032: hr_utility.set_location('Appended Value: '||l_str8, 95);
1033: --
1034: dbms_lob.writeappend( l_xfdf_string, length(l_str4), l_str4 );---- 1035: dbms_lob.writeappend( l_xfdf_string, length(l_str7),l_str7);----- name
1036: dbms_lob.writeappend( l_xfdf_string, length(l_str3), l_str3 );----- >
1037: END IF;
1038: END LOOP;
1039: --
1040: hr_utility.set_location('l_str5 is: '||l_str5, 100);

Line 1042: dbms_lob.writeappend( l_xfdf_string, length(l_str5), l_str5 );

1038: END LOOP;
1039: --
1040: hr_utility.set_location('l_str5 is: '||l_str5, 100);
1041: --
1042: dbms_lob.writeappend( l_xfdf_string, length(l_str5), l_str5 );
1043: --
1044: hr_utility.set_location('xml string', 100);
1045: --
1046: ELSE

Line 1047: dbms_lob.writeappend( l_xfdf_string, length(l_str6), l_str6 );

1043: --
1044: hr_utility.set_location('xml string', 100);
1045: --
1046: ELSE
1047: dbms_lob.writeappend( l_xfdf_string, length(l_str6), l_str6 );
1048: --
1049: hr_utility.set_location('xml string', 110);
1050: --
1051: END IF;

Line 1052: hr_utility.set_location(dbms_lob.getlength(l_xfdf_string), 120);

1048: --
1049: hr_utility.set_location('xml string', 110);
1050: --
1051: END IF;
1052: hr_utility.set_location(dbms_lob.getlength(l_xfdf_string), 120);
1053: --
1054: dbms_lob.createtemporary(p_xfdf_clob,TRUE);
1055: p_xfdf_clob := l_xfdf_string;
1056: --

Line 1054: dbms_lob.createtemporary(p_xfdf_clob,TRUE);

1050: --
1051: END IF;
1052: hr_utility.set_location(dbms_lob.getlength(l_xfdf_string), 120);
1053: --
1054: dbms_lob.createtemporary(p_xfdf_clob,TRUE);
1055: p_xfdf_clob := l_xfdf_string;
1056: --
1057: hr_utility.set_location('After assigning to out LOB'||dbms_lob.getlength(p_xfdf_clob), 130);
1058: --

Line 1057: hr_utility.set_location('After assigning to out LOB'||dbms_lob.getlength(p_xfdf_clob), 130);

1053: --
1054: dbms_lob.createtemporary(p_xfdf_clob,TRUE);
1055: p_xfdf_clob := l_xfdf_string;
1056: --
1057: hr_utility.set_location('After assigning to out LOB'||dbms_lob.getlength(p_xfdf_clob), 130);
1058: --
1059: hr_utility.set_location('After writing to clob', 140);
1060: --
1061: EXCEPTION