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_SAL_STATISTICS_ARCHIVE dependencies on DBMS_LOB

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

1001: l_str10 := '';
1002: l_str11 := '';
1003:
1004:
1005: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1006: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1007:
1008: current_index := 0;
1009:

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

1002: l_str11 := '';
1003:
1004:
1005: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1006: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1007:
1008: current_index := 0;
1009:
1010: IF xml_tab.count > 0 THEN

Line 1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

1008: current_index := 0;
1009:
1010: IF xml_tab.count > 0 THEN
1011:
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1013:
1014:
1015: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
1016:

Line 1030: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1026:
1027: IF l_str9 IN ('STATEMENT_PROVIDER','LOCAL_UNIT','EMPLOYEE_DETAILS',
1028: 'EMPLOYEE', 'EMPLOYEE_SALARY','LOCAL_UNIT_END','FILLER',
1029: 'STATEMENT_PROVIDER_END') THEN
1030: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1031: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1033: ELSE
1034: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 1031: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1027: IF l_str9 IN ('STATEMENT_PROVIDER','LOCAL_UNIT','EMPLOYEE_DETAILS',
1028: 'EMPLOYEE', 'EMPLOYEE_SALARY','LOCAL_UNIT_END','FILLER',
1029: 'STATEMENT_PROVIDER_END') THEN
1030: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1031: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1033: ELSE
1034: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1035: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1028: 'EMPLOYEE', 'EMPLOYEE_SALARY','LOCAL_UNIT_END','FILLER',
1029: 'STATEMENT_PROVIDER_END') THEN
1030: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1031: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1033: ELSE
1034: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1035: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1036: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

1030: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1031: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1033: ELSE
1034: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1035: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1036: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1037: END IF;
1038:

Line 1035: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1031: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1033: ELSE
1034: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1035: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1036: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1037: END IF;
1038:
1039: ELSE

Line 1036: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1032: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1033: ELSE
1034: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1035: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1036: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1037: END IF;
1038:
1039: ELSE
1040:

Line 1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1039: ELSE
1040:
1041: if l_str9 is not null then
1042:
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1040:
1041: if l_str9 is not null then
1042:
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1041: if l_str9 is not null then
1042:
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);

1042:
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050: else

Line 1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050: else
1051:

Line 1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1044: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050: else
1051:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

Line 1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1045: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1046: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1047: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050: else
1051:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1048: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050: else
1051:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1049: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1050: else
1051:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1050: else
1051:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058:

Line 1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1051:
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058:
1059: end if;

Line 1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058:
1059: end if;
1060:

Line 1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1057: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1058:
1059: end if;
1060:
1061: END IF;

Line 1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );

1061: END IF;
1062:
1063: END LOOP;
1064:
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1066:
1067: ELSE
1068: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1069: END IF;

Line 1068: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );

1064:
1065: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1066:
1067: ELSE
1068: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1069: END IF;
1070:
1071: p_xfdf_clob := l_xfdf_string;
1072: