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

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

1014: l_str10 := '';
1015: l_str11 := '';
1016:
1017:
1018: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1019: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1020:
1021: current_index := 0;
1022:

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

1015: l_str11 := '';
1016:
1017:
1018: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1019: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1020:
1021: current_index := 0;
1022:
1023: IF xml_tab.count > 0 THEN

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

1021: current_index := 0;
1022:
1023: IF xml_tab.count > 0 THEN
1024:
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1026:
1027:
1028: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
1029:

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

1033: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS','END_ORG_DETAILS','END_EMP_DETAILS'
1034: ) THEN
1035:
1036: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS') THEN
1037: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1040: ELSE
1041: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

1034: ) THEN
1035:
1036: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS') THEN
1037: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1040: ELSE
1041: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1035:
1036: IF l_str9 IN ('ORG_DETAILS','EMP_DETAILS') THEN
1037: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1040: ELSE
1041: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

1037: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1040: ELSE
1041: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1044: END IF;
1045:

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

1038: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1040: ELSE
1041: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1044: END IF;
1045:
1046: ELSE

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

1039: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1040: ELSE
1041: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1042: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1043: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1044: END IF;
1045:
1046: ELSE
1047:

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

1046: ELSE
1047:
1048: if l_str9 is not null then
1049:
1050: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

1047:
1048: if l_str9 is not null then
1049:
1050: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1048: if l_str9 is not null then
1049:
1050: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1051: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1052: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1053: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1054: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

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

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

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

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

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

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

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

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

1055: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1057: else
1058:
1059: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1056: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1057: else
1058:
1059: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

1057: else
1058:
1059: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1065:

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

1058:
1059: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1065:
1066: end if;

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

1059: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1065:
1066: end if;
1067:

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

1060: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1061: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1062: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1063: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1064: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1065:
1066: end if;
1067:
1068: END IF;

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

1068: END IF;
1069:
1070: END LOOP;
1071:
1072: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1073:
1074: ELSE
1075: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1076: END IF;

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

1071:
1072: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1073:
1074: ELSE
1075: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1076: END IF;
1077:
1078: p_xfdf_clob := l_xfdf_string;
1079: