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

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

2106: l_str10 := '';
2107: l_str11 := '';
2108:
2109:
2110: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2111: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2112:
2113: current_index := 0;
2114:

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

2107: l_str11 := '';
2108:
2109:
2110: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2111: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2112:
2113: current_index := 0;
2114:
2115: IF xml_tab.count > 0 THEN

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

2113: current_index := 0;
2114:
2115: IF xml_tab.count > 0 THEN
2116:
2117: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2118:
2119:
2120: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
2121:

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

2125: IF l_str9 IN ('FILE_HEADER_FOOTER_START', 'FILE_HEADER_FOOTER_END','COMPANY_HEADER_FOOTER_START' ,'COMPANY_HEADER_FOOTER_END'
2126: ,'PERSON_RECO_START','PERSON_RECO_END','SALARY_RECO_START','SALARY_RECO_END') THEN
2127:
2128: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'COMPANY_HEADER_FOOTER_START' , 'PERSON_RECO_START','SALARY_RECO_START') THEN
2129: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2130: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2131: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2132: ELSE
2133: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

2126: ,'PERSON_RECO_START','PERSON_RECO_END','SALARY_RECO_START','SALARY_RECO_END') THEN
2127:
2128: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'COMPANY_HEADER_FOOTER_START' , 'PERSON_RECO_START','SALARY_RECO_START') THEN
2129: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2130: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2131: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2132: ELSE
2133: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2134: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2127:
2128: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'COMPANY_HEADER_FOOTER_START' , 'PERSON_RECO_START','SALARY_RECO_START') THEN
2129: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2130: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2131: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2132: ELSE
2133: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2134: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2135: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

2129: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2130: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2131: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2132: ELSE
2133: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2134: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2135: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2136: END IF;
2137:

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

2130: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2131: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2132: ELSE
2133: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2134: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2135: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2136: END IF;
2137:
2138: ELSE

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

2131: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2132: ELSE
2133: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2134: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2135: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2136: END IF;
2137:
2138: ELSE
2139:

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

2138: ELSE
2139:
2140: if l_str9 is not null then
2141: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2142: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2143: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

2139:
2140: if l_str9 is not null then
2141: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2142: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2143: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2140: if l_str9 is not null then
2141: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2142: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2143: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

2141: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2142: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2143: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2149: else

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

2142: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2143: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2149: else
2150:

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

2143: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2149: else
2150:
2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

2144: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2145: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2146: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2149: else
2150:
2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2147: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2149: else
2150:
2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2153: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2154: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2155: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2148: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2149: else
2150:
2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2153: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2154: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2155: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2156: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

2149: else
2150:
2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2153: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2154: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2155: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2156: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2157:

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

2150:
2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2153: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2154: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2155: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2156: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2157:
2158: end if;

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

2151: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2153: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2154: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2155: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2156: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2157:
2158: end if;
2159:

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

2152: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2153: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2154: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2155: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2156: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2157:
2158: end if;
2159:
2160: END IF;

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

2160: END IF;
2161:
2162: END LOOP;
2163:
2164: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
2165:
2166: ELSE
2167: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
2168: END IF;

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

2163:
2164: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
2165:
2166: ELSE
2167: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
2168: END IF;
2169:
2170: p_xfdf_clob := l_xfdf_string;
2171: