DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on UTL_RAW

Line 27: raw_data:=utl_raw.cast_to_raw(p_text);

23: raw_data RAW(32767);
24: temp_blob BLOB;
25: BEGIN
26:
27: raw_data:=utl_raw.cast_to_raw(p_text);
28: text_size:=utl_raw.length(raw_data);
29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);

Line 28: text_size:=utl_raw.length(raw_data);

24: temp_blob BLOB;
25: BEGIN
26:
27: raw_data:=utl_raw.cast_to_raw(p_text);
28: text_size:=utl_raw.length(raw_data);
29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
32:

Line 1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);

1273: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1275: hr_utility.trace('OPENED l_xml_blob ' );
1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1278: text_size:=utl_raw.length(raw_data);
1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:

Line 1278: text_size:=utl_raw.length(raw_data);

1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1275: hr_utility.trace('OPENED l_xml_blob ' );
1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1278: text_size:=utl_raw.length(raw_data);
1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:
1282: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );

Line 1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);

1897:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:

Line 1902: text_size:=utl_raw.length(raw_data);

1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,

Line 1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),

1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)
1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);
1911: dbms_lob.append(l_final_xml,l_temp_blob);

Line 1908: utl_raw.cast_to_raw(l_final_xml_string)

1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)
1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);
1911: dbms_lob.append(l_final_xml,l_temp_blob);
1912:

Line 1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);

1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);
1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1920: text_size:=utl_raw.length(raw_data);
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:

Line 1920: text_size:=utl_raw.length(raw_data);

1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);
1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1920: text_size:=utl_raw.length(raw_data);
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,

Line 1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),

1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1926: utl_raw.cast_to_raw(l_last_xml_string)
1927: );*/
1928:
1929:

Line 1926: utl_raw.cast_to_raw(l_last_xml_string)

1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1926: utl_raw.cast_to_raw(l_last_xml_string)
1927: );*/
1928:
1929:
1930: l_temp_blob := append_to_lob(l_last_xml_string);