APPS.OKC_ARTICLES_IMPORT_GRP dependencies on DBMS_LOB

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

2178: g_temp_clob_tbl.extend(p_fetchsize);
2179: FOR i in 1..p_fetchsize LOOP
2180: -- Create Temporary Clob. Clob is created not in session level to prevent
2181: -- from running ouf of session memory
2182: DBMS_LOB.CREATETEMPORARY(g_temp_clob_tbl(i), TRUE);
2183: END LOOP;
2184:
2185: -------------------------------------------------------------------------
2186: --------------- the outermost loop of this procedure --------------------

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

2863: -- Copying the clob in interface into temporary clob
2864: --
2865: --
2866:
2867: DBMS_LOB.TRIM(g_temp_clob_tbl(i), 0);
2868:
2869: OKC_ARTICLES_GRP.parse_n_replace_text(
2870: p_api_version => l_api_version,
2871: p_init_msg_list => l_init_msg_list,

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

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

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

3184: -- Freeing temporary clobs
3185: --
3186: j := g_temp_clob_tbl.FIRST;
3187: LOOP
3188: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3189: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3190: j := g_temp_clob_tbl.NEXT(j);
3191: END LOOP;
3192: g_temp_clob_tbl.DELETE;

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

3267: -- Freeing temporary clobs
3268: --
3269: j := g_temp_clob_tbl.FIRST;
3270: LOOP
3271: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3272: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3273: j := g_temp_clob_tbl.NEXT(j);
3274: END LOOP;
3275: g_temp_clob_tbl.DELETE;

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

3302: -- Freeing temporary clobs
3303: --
3304: j := g_temp_clob_tbl.FIRST;
3305: LOOP
3306: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
3307: EXIT WHEN (j = g_temp_clob_tbl.LAST);
3308: j := g_temp_clob_tbl.NEXT(j);
3309: END LOOP;
3310: g_temp_clob_tbl.DELETE;

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

4123: --
4124:
4125: j := g_temp_clob_tbl.FIRST;
4126: LOOP
4127: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4128: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4129: j := g_temp_clob_tbl.NEXT(j);
4130: END LOOP;
4131: g_temp_clob_tbl.DELETE;

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

4249:
4250: IF g_temp_clob_tbl.COUNT > 0 THEN
4251: j := g_temp_clob_tbl.FIRST;
4252: LOOP
4253: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4254: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4255: j := g_temp_clob_tbl.NEXT(j);
4256: END LOOP;
4257: g_temp_clob_tbl.DELETE;

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

4295:
4296: IF g_temp_clob_tbl.COUNT > 0 THEN
4297: j := g_temp_clob_tbl.FIRST;
4298: LOOP
4299: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4300: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4301: j := g_temp_clob_tbl.NEXT(j);
4302: END LOOP;
4303: g_temp_clob_tbl.DELETE;

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

4350: --
4351: IF g_temp_clob_tbl.COUNT > 0 THEN
4352: j := g_temp_clob_tbl.FIRST;
4353: LOOP
4354: DBMS_LOB.FREETEMPORARY(g_temp_clob_tbl(j));
4355: EXIT WHEN (j = g_temp_clob_tbl.LAST);
4356: j := g_temp_clob_tbl.NEXT(j);
4357: END LOOP;
4358: g_temp_clob_tbl.DELETE;