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 1167: raw_data:=utl_raw.cast_to_raw(l_xml_string);

1163: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1164: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1165: hr_utility.trace('OPENED l_xml_blob ' );
1166:
1167: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1168: text_size:=utl_raw.length(raw_data);
1169:
1170: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1171:

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

1164: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1165: hr_utility.trace('OPENED l_xml_blob ' );
1166:
1167: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1168: text_size:=utl_raw.length(raw_data);
1169:
1170: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1171:
1172: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );

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

1789:
1790: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1791: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1792:
1793: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1794: text_size:=utl_raw.length(raw_data);
1795:
1796: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1797:

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

1790: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1791: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1792:
1793: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1794: text_size:=utl_raw.length(raw_data);
1795:
1796: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1797:
1798: /*dbms_lob.writeappend(l_final_xml,

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

1795:
1796: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1797:
1798: /*dbms_lob.writeappend(l_final_xml,
1799: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1800: utl_raw.cast_to_raw(l_final_xml_string)
1801: );*/
1802: l_temp_blob := append_to_lob(l_final_xml_string);
1803: dbms_lob.append(l_final_xml,l_temp_blob);

Line 1800: utl_raw.cast_to_raw(l_final_xml_string)

1796: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1797:
1798: /*dbms_lob.writeappend(l_final_xml,
1799: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1800: utl_raw.cast_to_raw(l_final_xml_string)
1801: );*/
1802: l_temp_blob := append_to_lob(l_final_xml_string);
1803: dbms_lob.append(l_final_xml,l_temp_blob);
1804:

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

1807: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1808:
1809: dbms_lob.append(l_final_xml,lc_emp_blob);
1810:
1811: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1812: text_size:=utl_raw.length(raw_data);
1813:
1814: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1815:

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

1808:
1809: dbms_lob.append(l_final_xml,lc_emp_blob);
1810:
1811: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1812: text_size:=utl_raw.length(raw_data);
1813:
1814: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1815:
1816: /*dbms_lob.writeappend(l_final_xml,

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

1813:
1814: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1815:
1816: /*dbms_lob.writeappend(l_final_xml,
1817: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1818: utl_raw.cast_to_raw(l_last_xml_string)
1819: );*/
1820:
1821:

Line 1818: utl_raw.cast_to_raw(l_last_xml_string)

1814: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1815:
1816: /*dbms_lob.writeappend(l_final_xml,
1817: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1818: utl_raw.cast_to_raw(l_last_xml_string)
1819: );*/
1820:
1821:
1822: l_temp_blob := append_to_lob(l_last_xml_string);