DBA Data[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on DBMS_LOB

Line 4049: DBMS_LOB.CREATETEMPORARY(l_lob_loc, TRUE);

4045: l_exportfinished BOOLEAN;
4046:
4047: BEGIN
4048:
4049: DBMS_LOB.CREATETEMPORARY(l_lob_loc, TRUE);
4050: DBMS_LOB.OPEN(l_lob_loc, DBMS_LOB.LOB_READWRITE);
4051:
4052: l_buffer := jdr_utils.ExportDocument(p_document => p_doc_full_name,
4053: p_exportfinished => l_exportfinished);

Line 4050: DBMS_LOB.OPEN(l_lob_loc, DBMS_LOB.LOB_READWRITE);

4046:
4047: BEGIN
4048:
4049: DBMS_LOB.CREATETEMPORARY(l_lob_loc, TRUE);
4050: DBMS_LOB.OPEN(l_lob_loc, DBMS_LOB.LOB_READWRITE);
4051:
4052: l_buffer := jdr_utils.ExportDocument(p_document => p_doc_full_name,
4053: p_exportfinished => l_exportfinished);
4054:

Line 4061: DBMS_LOB.WRITE(l_lob_loc, l_amount, l_position, l_buffer);

4057: END IF;
4058:
4059: l_amount := LENGTH(l_buffer);
4060:
4061: DBMS_LOB.WRITE(l_lob_loc, l_amount, l_position, l_buffer);
4062: l_position := l_position + l_amount;
4063:
4064: IF l_exportfinished=FALSE THEN
4065: LOOP

Line 4075: DBMS_LOB.WRITE(l_lob_loc, l_amount, l_position, l_buffer);

4071: END IF;
4072:
4073: l_amount := LENGTH(l_buffer);
4074:
4075: DBMS_LOB.WRITE(l_lob_loc, l_amount, l_position, l_buffer);
4076: l_position := l_position + l_amount;
4077:
4078: IF l_buffer IS NULL OR l_exportfinished THEN
4079: EXIT;

Line 4089: DBMS_LOB.CLOSE(l_lob_loc);

4085: xmlparser.parseCLOB(g_PARSER, l_lob_loc);
4086:
4087: l_xmldoc := xmlparser.getDocument(g_PARSER);
4088:
4089: DBMS_LOB.CLOSE(l_lob_loc);
4090: DBMS_LOB.FREETEMPORARY(l_lob_loc);
4091:
4092: RETURN l_xmldoc;
4093:

Line 4090: DBMS_LOB.FREETEMPORARY(l_lob_loc);

4086:
4087: l_xmldoc := xmlparser.getDocument(g_PARSER);
4088:
4089: DBMS_LOB.CLOSE(l_lob_loc);
4090: DBMS_LOB.FREETEMPORARY(l_lob_loc);
4091:
4092: RETURN l_xmldoc;
4093:
4094: EXCEPTION