APPS.CSF_LOCUS_PUB dependencies on DBMS_LOB

Line 684: dbms_lob.OPEN(l_route, dbms_lob.lob_readwrite);

680:
681: l_geometry_tbl := get_geometry_tbl(p_segment_id_tbl);
682:
683: -- Open the CLOB
684: dbms_lob.OPEN(l_route, dbms_lob.lob_readwrite);
685:
686: -- Read from Geometry Table and write to the CLOB
687: i := l_geometry_tbl.FIRST;
688: WHILE i IS NOT NULL LOOP

Line 689: dbms_lob.writeappend(l_route, LENGTH(l_geometry_tbl(i)) + 1, l_geometry_tbl(i) || ',');

685:
686: -- Read from Geometry Table and write to the CLOB
687: i := l_geometry_tbl.FIRST;
688: WHILE i IS NOT NULL LOOP
689: dbms_lob.writeappend(l_route, LENGTH(l_geometry_tbl(i)) + 1, l_geometry_tbl(i) || ',');
690: i := l_geometry_tbl.NEXT(i);
691: END LOOP;
692:
693: i := 1;

Line 694: IF dbms_lob.getlength(l_route) > 0 THEN

690: i := l_geometry_tbl.NEXT(i);
691: END LOOP;
692:
693: i := 1;
694: IF dbms_lob.getlength(l_route) > 0 THEN
695: dbms_lob.erase(l_route, i, dbms_lob.getlength(l_route));
696: END IF;
697:
698: -- Close the CLOB

Line 695: dbms_lob.erase(l_route, i, dbms_lob.getlength(l_route));

691: END LOOP;
692:
693: i := 1;
694: IF dbms_lob.getlength(l_route) > 0 THEN
695: dbms_lob.erase(l_route, i, dbms_lob.getlength(l_route));
696: END IF;
697:
698: -- Close the CLOB
699: dbms_lob.CLOSE(l_route);

Line 699: dbms_lob.CLOSE(l_route);

695: dbms_lob.erase(l_route, i, dbms_lob.getlength(l_route));
696: END IF;
697:
698: -- Close the CLOB
699: dbms_lob.CLOSE(l_route);
700:
701: IF fnd_api.to_boolean(p_commit) THEN
702: COMMIT;
703: END IF;