APPS.OKC_QA_CHECK_PVT dependencies on DBMS_SQL

Line 289: l_cursor_id := DBMS_SQL.OPEN_CURSOR; --Bug2934909

285: OPEN l_qlp_csr;
286: LOOP
287: FETCH l_qlp_csr INTO l_qlp_rec;
288: EXIT WHEN l_qlp_csr%NOTFOUND;
289: l_cursor_id := DBMS_SQL.OPEN_CURSOR; --Bug2934909
290: plsql_block := 'BEGIN ' ||
291: l_qlp_rec.package_name || '.' ||
292: l_qlp_rec.procedure_name || '( ' ||
293: 'x_return_status => :l_return_status ' ||

Line 323: DBMS_SQL.PARSE(l_cursor_id,plsql_block , 2);

319: -- End Bug 2934909
320:
321: plsql_block := plsql_block || ') ; END;';
322: -- Bug 2934909
323: DBMS_SQL.PARSE(l_cursor_id,plsql_block , 2);
324: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':l_return_status',l_return_status);
325: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_chr_id',p_chr_id);
326:
327: If l_parameter_tbl.count > 0 then

Line 324: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':l_return_status',l_return_status);

320:
321: plsql_block := plsql_block || ') ; END;';
322: -- Bug 2934909
323: DBMS_SQL.PARSE(l_cursor_id,plsql_block , 2);
324: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':l_return_status',l_return_status);
325: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_chr_id',p_chr_id);
326:
327: If l_parameter_tbl.count > 0 then
328: FOR j in l_parameter_tbl.FIRST..l_parameter_tbl.LAST LOOP

Line 325: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_chr_id',p_chr_id);

321: plsql_block := plsql_block || ') ; END;';
322: -- Bug 2934909
323: DBMS_SQL.PARSE(l_cursor_id,plsql_block , 2);
324: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':l_return_status',l_return_status);
325: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_chr_id',p_chr_id);
326:
327: If l_parameter_tbl.count > 0 then
328: FOR j in l_parameter_tbl.FIRST..l_parameter_tbl.LAST LOOP
329: DBMS_SQL.BIND_VARIABLE(l_cursor_id, to_char(j),l_parameter_tbl(j).param_value);

Line 329: DBMS_SQL.BIND_VARIABLE(l_cursor_id, to_char(j),l_parameter_tbl(j).param_value);

325: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_chr_id',p_chr_id);
326:
327: If l_parameter_tbl.count > 0 then
328: FOR j in l_parameter_tbl.FIRST..l_parameter_tbl.LAST LOOP
329: DBMS_SQL.BIND_VARIABLE(l_cursor_id, to_char(j),l_parameter_tbl(j).param_value);
330: END LOOP;
331: end if;
332:
333: -- End Bug 2934909

Line 337: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

333: -- End Bug 2934909
334: -- clean up the message list
335: fnd_msg_pub.initialize;
336:
337: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
338: dbms_Sql.variable_Value(l_cursor_id, ':l_return_status', l_return_status);
339:
340: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug 3385459
341:

Line 338: dbms_Sql.variable_Value(l_cursor_id, ':l_return_status', l_return_status);

334: -- clean up the message list
335: fnd_msg_pub.initialize;
336:
337: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
338: dbms_Sql.variable_Value(l_cursor_id, ':l_return_status', l_return_status);
339:
340: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug 3385459
341:
342: /* Bug2934909

Line 340: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug 3385459

336:
337: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
338: dbms_Sql.variable_Value(l_cursor_id, ':l_return_status', l_return_status);
339:
340: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug 3385459
341:
342: /* Bug2934909
343: BEGIN
344: EXECUTE IMMEDIATE plsql_block

Line 565: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

561: okc_context.restore_contexts;
562:
563: --Bug 3300707
564: if (l_cursor_id is not null) then
565: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
566: end if;
567: IF l_qlp_csr%ISOPEN THEN
568: CLOSE l_qlp_csr;
569: END IF;

Line 589: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug2934909

585: okc_context.restore_contexts;
586:
587: -- close cursor
588: if (l_cursor_id is not null) then --Bug 3378989
589: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug2934909
590: end if;
591: -- store SQL error message on message stack
592: OKC_API.SET_MESSAGE(
593: p_app_name => G_APP_NAME,