APPS.CS_KB_ASSOC_PKG dependencies on DBMS_SQL

Line 219: stmt := DBMS_SQL.OPEN_CURSOR;

215: END IF;
216:
217: IF (sqlStatement is not null) THEN
218: length := p_item_id.COUNT;
219: stmt := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(stmt, sqlStatement, DBMS_SQL.V7);
221:
222: -- shared bind variable
223: DBMS_SQL.BIND_VARIABLE(stmt, ':S', p_set_id);

Line 220: DBMS_SQL.PARSE(stmt, sqlStatement, DBMS_SQL.V7);

216:
217: IF (sqlStatement is not null) THEN
218: length := p_item_id.COUNT;
219: stmt := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(stmt, sqlStatement, DBMS_SQL.V7);
221:
222: -- shared bind variable
223: DBMS_SQL.BIND_VARIABLE(stmt, ':S', p_set_id);
224:

Line 223: DBMS_SQL.BIND_VARIABLE(stmt, ':S', p_set_id);

219: stmt := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(stmt, sqlStatement, DBMS_SQL.V7);
221:
222: -- shared bind variable
223: DBMS_SQL.BIND_VARIABLE(stmt, ':S', p_set_id);
224:
225: -- bind variables (used only with creating links)
226: IF (p_task = 1) THEN
227: DBMS_SQL.BIND_VARIABLE(stmt, ':D', sysdate);

Line 227: DBMS_SQL.BIND_VARIABLE(stmt, ':D', sysdate);

223: DBMS_SQL.BIND_VARIABLE(stmt, ':S', p_set_id);
224:
225: -- bind variables (used only with creating links)
226: IF (p_task = 1) THEN
227: DBMS_SQL.BIND_VARIABLE(stmt, ':D', sysdate);
228: DBMS_SQL.BIND_VARIABLE(stmt, ':U', fnd_global.user_id);
229: END IF;
230:
231: FOR counter IN 1..length LOOP

Line 228: DBMS_SQL.BIND_VARIABLE(stmt, ':U', fnd_global.user_id);

224:
225: -- bind variables (used only with creating links)
226: IF (p_task = 1) THEN
227: DBMS_SQL.BIND_VARIABLE(stmt, ':D', sysdate);
228: DBMS_SQL.BIND_VARIABLE(stmt, ':U', fnd_global.user_id);
229: END IF;
230:
231: FOR counter IN 1..length LOOP
232: -- bind variables (temporary)

Line 233: DBMS_SQL.BIND_VARIABLE(stmt, ':P', p_item_id(counter));

229: END IF;
230:
231: FOR counter IN 1..length LOOP
232: -- bind variables (temporary)
233: DBMS_SQL.BIND_VARIABLE(stmt, ':P', p_item_id(counter));
234: DBMS_SQL.BIND_VARIABLE(stmt, ':O', p_org_id(counter));
235: -- execute everytime in loop
236: cursorReturn := DBMS_SQL.EXECUTE(stmt);
237: END LOOP;

Line 234: DBMS_SQL.BIND_VARIABLE(stmt, ':O', p_org_id(counter));

230:
231: FOR counter IN 1..length LOOP
232: -- bind variables (temporary)
233: DBMS_SQL.BIND_VARIABLE(stmt, ':P', p_item_id(counter));
234: DBMS_SQL.BIND_VARIABLE(stmt, ':O', p_org_id(counter));
235: -- execute everytime in loop
236: cursorReturn := DBMS_SQL.EXECUTE(stmt);
237: END LOOP;
238:

Line 236: cursorReturn := DBMS_SQL.EXECUTE(stmt);

232: -- bind variables (temporary)
233: DBMS_SQL.BIND_VARIABLE(stmt, ':P', p_item_id(counter));
234: DBMS_SQL.BIND_VARIABLE(stmt, ':O', p_org_id(counter));
235: -- execute everytime in loop
236: cursorReturn := DBMS_SQL.EXECUTE(stmt);
237: END LOOP;
238:
239: -- Clean up!
240: DBMS_SQL.CLOSE_CURSOR(stmt);

Line 240: DBMS_SQL.CLOSE_CURSOR(stmt);

236: cursorReturn := DBMS_SQL.EXECUTE(stmt);
237: END LOOP;
238:
239: -- Clean up!
240: DBMS_SQL.CLOSE_CURSOR(stmt);
241: --p_result := 1;
242: ELSE
243: p_result := 2;
244: END IF;

Line 247: DBMS_SQL.CLOSE_CURSOR(stmt);

243: p_result := 2;
244: END IF;
245: EXCEPTION
246: WHEN OTHERS THEN
247: DBMS_SQL.CLOSE_CURSOR(stmt);
248: p_result := 0;
249: RAISE;
250: END;
251: