APPS.OKC_ARTICLES_IMPORT_GRP dependencies on DBMS_LOB

Line 2168: DBMS_LOB.CREATETEMPORARY(g_temp_clob_tbl(i), TRUE);

2164: g_temp_clob_tbl.extend(p_fetchsize);
2165: FOR i in 1..p_fetchsize LOOP
2166: -- Create Temporary Clob. Clob is created not in session level to prevent
2167: -- from running ouf of session memory
2168: DBMS_LOB.CREATETEMPORARY(g_temp_clob_tbl(i), TRUE);
2169: END LOOP;
2170:
2171: -------------------------------------------------------------------------
2172: --------------- the outermost loop of this procedure --------------------

Line 2816: DBMS_LOB.TRIM(g_temp_clob_tbl(i), 0);

2812: -- Copying the clob in interface into temporary clob
2813: --
2814: --
2815:
2816: DBMS_LOB.TRIM(g_temp_clob_tbl(i), 0);
2817:
2818: OKC_ARTICLES_GRP.parse_n_replace_text(
2819: p_api_version => l_api_version,
2820: p_init_msg_list => l_init_msg_list,

Line 3083: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

3079: -- Freeing temporary clobs
3080: --
3081: j := g_temp_clob_tbl.FIRST;
3082: LOOP
3083: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3084: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3085: j := g_temp_clob_tbl.NEXT(j);
3086: END LOOP;
3087: g_temp_clob_tbl.DELETE;

Line 3137: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

3133: -- Freeing temporary clobs
3134: --
3135: j := g_temp_clob_tbl.FIRST;
3136: LOOP
3137: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3138: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3139: j := g_temp_clob_tbl.NEXT(j);
3140: END LOOP;
3141: g_temp_clob_tbl.DELETE;

Line 3220: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

3216: -- Freeing temporary clobs
3217: --
3218: j := g_temp_clob_tbl.FIRST;
3219: LOOP
3220: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3221: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3222: j := g_temp_clob_tbl.NEXT(j);
3223: END LOOP;
3224: g_temp_clob_tbl.DELETE;

Line 3255: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

3251: -- Freeing temporary clobs
3252: --
3253: j := g_temp_clob_tbl.FIRST;
3254: LOOP
3255: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3256: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3257: j := g_temp_clob_tbl.NEXT(j);
3258: END LOOP;
3259: g_temp_clob_tbl.DELETE;

Line 4061: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

4057: --
4058:
4059: j := g_temp_clob_tbl.FIRST;
4060: LOOP
4061: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4062: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4063: j := g_temp_clob_tbl.NEXT(j);
4064: END LOOP;
4065: g_temp_clob_tbl.DELETE;

Line 4187: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

4183:
4184: IF g_temp_clob_tbl.COUNT > 0 THEN
4185: j := g_temp_clob_tbl.FIRST;
4186: LOOP
4187: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4188: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4189: j := g_temp_clob_tbl.NEXT(j);
4190: END LOOP;
4191: g_temp_clob_tbl.DELETE;

Line 4233: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

4229:
4230: IF g_temp_clob_tbl.COUNT > 0 THEN
4231: j := g_temp_clob_tbl.FIRST;
4232: LOOP
4233: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4234: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4235: j := g_temp_clob_tbl.NEXT(j);
4236: END LOOP;
4237: g_temp_clob_tbl.DELETE;

Line 4288: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));

4284: --
4285: IF g_temp_clob_tbl.COUNT > 0 THEN
4286: j := g_temp_clob_tbl.FIRST;
4287: LOOP
4288: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4289: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4290: j := g_temp_clob_tbl.NEXT(j);
4291: END LOOP;
4292: g_temp_clob_tbl.DELETE;