APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on DBMS_LOB

Line 497: dbms_lob.createtemporary(l_event_data

493: l_text VARCHAR2(32000);
494:
495: BEGIN
496:
497: dbms_lob.createtemporary(l_event_data
498: ,FALSE
499: ,dbms_lob.CALL);
500:
501: IF p_ssn_number IS NOT NULL THEN

Line 499: ,dbms_lob.CALL);

495: BEGIN
496:
497: dbms_lob.createtemporary(l_event_data
498: ,FALSE
499: ,dbms_lob.CALL);
500:
501: IF p_ssn_number IS NOT NULL THEN
502:
503: l_text := '';

Line 504: dbms_lob.writeappend(l_event_data

500:
501: IF p_ssn_number IS NOT NULL THEN
502:
503: l_text := '';
504: dbms_lob.writeappend(l_event_data
505: ,length(l_text)
506: ,l_text);
507:
508: IF p_business_name IS NOT NULL THEN

Line 510: dbms_lob.writeappend(l_event_data

506: ,l_text);
507:
508: IF p_business_name IS NOT NULL THEN
509: l_text := ''||p_business_name||'';
510: dbms_lob.writeappend(l_event_data
511: ,length(l_text)
512: ,l_text);
513: END IF;
514:

Line 517: dbms_lob.writeappend(l_event_data

513: END IF;
514:
515: IF p_ssn_number IS NOT NULL THEN
516: l_text := ''||p_ssn_number||'';
517: dbms_lob.writeappend(l_event_data
518: ,length(l_text)
519: ,l_text);
520: END IF;
521:

Line 523: dbms_lob.writeappend(l_event_data

519: ,l_text);
520: END IF;
521:
522: l_text := '';
523: dbms_lob.writeappend(l_event_data
524: ,length(l_text)
525: ,l_text);
526:
527:

Line 531: dbms_lob.writeappend(l_event_data

527:
528: ELSE
529:
530: l_text := '';
531: dbms_lob.writeappend(l_event_data
532: ,length(l_text)
533: ,l_text);
534:
535: IF p_business_name IS NOT NULL THEN

Line 537: dbms_lob.writeappend(l_event_data

533: ,l_text);
534:
535: IF p_business_name IS NOT NULL THEN
536: l_text := ''||p_business_name||'';
537: dbms_lob.writeappend(l_event_data
538: ,length(l_text)
539: ,l_text);
540: END IF;
541:

Line 544: dbms_lob.writeappend(l_event_data

540: END IF;
541:
542: IF p_duns_number IS NOT NULL THEN
543: l_text := ''||p_duns_number||'';
544: dbms_lob.writeappend(l_event_data
545: ,length(l_text)
546: ,l_text);
547: END IF;
548:

Line 550: dbms_lob.writeappend(l_event_data

546: ,l_text);
547: END IF;
548:
549: l_text := '';
550: dbms_lob.writeappend(l_event_data
551: ,length(l_text)
552: ,l_text);
553:
554:

Line 573: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);

569: l_xpath VARCHAR2(1000);
570:
571: BEGIN
572:
573: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
574:
575: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
576: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
577: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

Line 575: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP

571: BEGIN
572:
573: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
574:
575: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
576: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
577: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
578: v_start := v_start + v_buffer;
579: END LOOP;

Line 576: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));

572:
573: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
574:
575: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
576: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
577: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
578: v_start := v_start + v_buffer;
579: END LOOP;
580:

Line 577: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

573: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
574:
575: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
576: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
577: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
578: v_start := v_start + v_buffer;
579: END LOOP;
580:
581: RETURN v_clob;

Line 595: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);

591: v_lang Pls_Integer := 0;
592: v_warning Pls_Integer := 0;
593: BEGIN
594:
595: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);
596:
597: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
598: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
599:

Line 597: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),

593: BEGIN
594:
595: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);
596:
597: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
598: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
599:
600: return l_art_blob;
601: EXCEPTION WHEN OTHERS THEN

Line 598: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);

594:
595: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);
596:
597: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
598: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
599:
600: return l_art_blob;
601: EXCEPTION WHEN OTHERS THEN
602: NULL;