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 2930: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

2926: l_str10 := '';
2927: l_str11 := '';
2928:
2929:
2930: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2931: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2932:
2933: current_index := 0;
2934:

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

2927: l_str11 := '';
2928:
2929:
2930: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2931: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2932:
2933: current_index := 0;
2934:
2935: IF xml_tab.count > 0 THEN

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

2933: current_index := 0;
2934:
2935: IF xml_tab.count > 0 THEN
2936:
2937: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2938:
2939:
2940: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
2941:

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

2945: IF l_str9 IN ('FILE_HEADER_FOOTER_START', 'FILE_HEADER_FOOTER_END','COMPANY_HEADER_FOOTER_START' ,'COMPANY_HEADER_FOOTER_END'
2946: ,'PERSON_RECO_START','PERSON_RECO_END','SALARY_RECO_START','SALARY_RECO_END') THEN
2947:
2948: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'COMPANY_HEADER_FOOTER_START' , 'PERSON_RECO_START','SALARY_RECO_START') THEN
2949: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2950: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2951: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2952: ELSE
2953: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

2946: ,'PERSON_RECO_START','PERSON_RECO_END','SALARY_RECO_START','SALARY_RECO_END') THEN
2947:
2948: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'COMPANY_HEADER_FOOTER_START' , 'PERSON_RECO_START','SALARY_RECO_START') THEN
2949: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2950: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2951: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2952: ELSE
2953: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2954: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2947:
2948: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'COMPANY_HEADER_FOOTER_START' , 'PERSON_RECO_START','SALARY_RECO_START') THEN
2949: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2950: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2951: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2952: ELSE
2953: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2954: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2955: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

2949: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2950: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2951: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2952: ELSE
2953: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2954: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2955: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2956: END IF;
2957:

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

2950: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2951: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2952: ELSE
2953: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2954: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2955: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2956: END IF;
2957:
2958: ELSE

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

2951: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2952: ELSE
2953: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2954: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2955: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2956: END IF;
2957:
2958: ELSE
2959:

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

2958: ELSE
2959:
2960: if l_str9 is not null then
2961: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2962: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2963: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

2959:
2960: if l_str9 is not null then
2961: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2962: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2963: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2960: if l_str9 is not null then
2961: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2962: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2963: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

2961: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
2962: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2963: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2969: else

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

2962: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2963: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2969: else
2970:

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

2963: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2969: else
2970:
2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

2964: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2965: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
2966: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2969: else
2970:
2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2967: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2969: else
2970:
2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2973: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2974: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2975: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

2968: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2969: else
2970:
2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2973: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2974: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2975: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2976: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

2969: else
2970:
2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2973: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2974: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2975: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2976: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2977:

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

2970:
2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2973: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2974: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2975: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2976: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2977:
2978: end if;

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

2971: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2973: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2974: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2975: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2976: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2977:
2978: end if;
2979:

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

2972: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2973: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
2974: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
2975: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
2976: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
2977:
2978: end if;
2979:
2980: END IF;

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

2980: END IF;
2981:
2982: END LOOP;
2983:
2984: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
2985:
2986: ELSE
2987: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
2988: END IF;

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

2983:
2984: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
2985:
2986: ELSE
2987: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
2988: END IF;
2989:
2990: p_xfdf_clob := l_xfdf_string;
2991: