APPS.XDP_UTILITIES dependencies on DBMS_LOB

Line 618: dbms_lob.write(lv_lob, length(p_proc_body), 1, p_proc_body);

614: (p_proc_name, p_proc_type, 'N', p_proc_spec, empty_clob(),
615: p_creation_date, p_created_by, p_last_update_date, p_last_updated_by,p_last_update_login)
616: returning proc_body into lv_lob;
617:
618: dbms_lob.write(lv_lob, length(p_proc_body), 1, p_proc_body);
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: return_code := SQLCODE;

Line 655: DBMS_LOB.WRITE(lv_lob,length(p_proc_body),1,p_proc_body);

651: proc_type = p_proc_type
652: and proc_name = p_proc_name
653: returning proc_body into lv_lob;
654:
655: DBMS_LOB.WRITE(lv_lob,length(p_proc_body),1,p_proc_body);
656: commit;
657:
658:
659: EXCEPTION

Line 688: dbms_lob.read(lv_lob,lv_length,1,lv_str);

684: --modified to use CURSOR
685: select proc_body into lv_lob
686: from xdp_proc_body
687: where proc_name = p_proc_name;
688: dbms_lob.read(lv_lob,lv_length,1,lv_str);
689: ***/
690: OPEN l_get_clob_value_csr;
691: FETCH l_get_clob_value_csr INTO lv_lob;
692:

Line 694: dbms_lob.read(lv_lob,lv_length,1,lv_str);

690: OPEN l_get_clob_value_csr;
691: FETCH l_get_clob_value_csr INTO lv_lob;
692:
693: IF l_get_clob_value_csr%FOUND THEN
694: dbms_lob.read(lv_lob,lv_length,1,lv_str);
695: END IF;
696:
697: CLOSE l_get_clob_value_csr;
698: RETURN lv_str;

Line 1901: lv_src_length := dbms_lob.GETLENGTH(lv_lob2);

1897: from xdp_proc_body
1898: where proc_name = lv_rec.proc_name
1899: and proc_type = lv_rec.proc_type;
1900:
1901: lv_src_length := dbms_lob.GETLENGTH(lv_lob2);
1902: IF lv_src_length = 0 THEN
1903: fnd_file.put_line(fnd_file.log, 'Procedure '||
1904: lv_rec.proc_name||
1905: ' does not contain any body text.');

Line 1915: dbms_lob.read(lv_lob2, lv_amount, lv_offset, lv_buffer);

1911:
1912: -- Read the CLOB into a varchar2 buffer!!!
1913: begin
1914: loop
1915: dbms_lob.read(lv_lob2, lv_amount, lv_offset, lv_buffer);
1916: lv_body := lv_body || lv_buffer;
1917:
1918: if lv_offset >= 32767 then
1919: exit;

Line 2215: DBMS_LOB.CREATETEMPORARY(p_dest_clob,TRUE);

2211:
2212: l_amount NUMBER;
2213:
2214: BEGIN
2215: DBMS_LOB.CREATETEMPORARY(p_dest_clob,TRUE);
2216:
2217: DBMS_LOB.OPEN(p_dest_clob,DBMS_LOB.LOB_READWRITE);
2218:
2219:

Line 2217: DBMS_LOB.OPEN(p_dest_clob,DBMS_LOB.LOB_READWRITE);

2213:
2214: BEGIN
2215: DBMS_LOB.CREATETEMPORARY(p_dest_clob,TRUE);
2216:
2217: DBMS_LOB.OPEN(p_dest_clob,DBMS_LOB.LOB_READWRITE);
2218:
2219:
2220: FOR i in 1..p_source_table.COUNT
2221: LOOP

Line 2224: DBMS_LOB.WRITEAPPEND(p_dest_clob,l_amount,p_source_table(i));

2220: FOR i in 1..p_source_table.COUNT
2221: LOOP
2222: l_amount := LENGTH(p_source_table(i));
2223:
2224: DBMS_LOB.WRITEAPPEND(p_dest_clob,l_amount,p_source_table(i));
2225: END LOOP ;
2226:
2227: DBMS_LOB.CLOSE(p_dest_clob);
2228:

Line 2227: DBMS_LOB.CLOSE(p_dest_clob);

2223:
2224: DBMS_LOB.WRITEAPPEND(p_dest_clob,l_amount,p_source_table(i));
2225: END LOOP ;
2226:
2227: DBMS_LOB.CLOSE(p_dest_clob);
2228:
2229:
2230: EXCEPTION
2231: WHEN others THEN

Line 2524: dbms_lob.read(l_clob,l_length,1,p_clob_content);

2520: FROM xdp_fe_cmd_aud_trails
2521: WHERE fa_instance_id = p_FAInstanceID
2522: AND fe_command_seq = p_FECmdSequence;
2523: -- get the content..
2524: dbms_lob.read(l_clob,l_length,1,p_clob_content);
2525: EXCEPTION
2526: WHEN OTHERS THEN
2527: xdpcore.context('XDP_UTILITIES', 'GET_FA_RESPONSE_LOB_CONTENT', 'FA', p_FAInstanceID);
2528: raise;