APPS.CS_KNOWLEDGE_PVT dependencies on DBMS_SQL

Line 430: l_csr_num := dbms_sql.open_cursor;

426: -- convert element_ids into bind vars
427: l_bind_ids := Bind_Var_String(1, p_ele_id_tbl.COUNT);
428:
429: -- open cursor
430: l_csr_num := dbms_sql.open_cursor;
431:
432: -- parse dynamic sql
433: dbms_sql.parse(l_csr_num,
434: l_sqlstr1 || l_bind_ids || l_sqlstr2,

Line 433: dbms_sql.parse(l_csr_num,

429: -- open cursor
430: l_csr_num := dbms_sql.open_cursor;
431:
432: -- parse dynamic sql
433: dbms_sql.parse(l_csr_num,
434: l_sqlstr1 || l_bind_ids || l_sqlstr2,
435: dbms_sql.NATIVE);
436:
437: -- define return columns from dynamic sql cursor select

Line 435: dbms_sql.NATIVE);

431:
432: -- parse dynamic sql
433: dbms_sql.parse(l_csr_num,
434: l_sqlstr1 || l_bind_ids || l_sqlstr2,
435: dbms_sql.NATIVE);
436:
437: -- define return columns from dynamic sql cursor select
438: dbms_sql.define_column(l_csr_num, 1, l_sid);
439: dbms_sql.define_column(l_csr_num, 2, l_count);

Line 438: dbms_sql.define_column(l_csr_num, 1, l_sid);

434: l_sqlstr1 || l_bind_ids || l_sqlstr2,
435: dbms_sql.NATIVE);
436:
437: -- define return columns from dynamic sql cursor select
438: dbms_sql.define_column(l_csr_num, 1, l_sid);
439: dbms_sql.define_column(l_csr_num, 2, l_count);
440:
441: -- Bind element_ids to bind variables in dynamic sql
442: if(p_ele_id_tbl is not null and p_ele_id_tbl.COUNT>0) then

Line 439: dbms_sql.define_column(l_csr_num, 2, l_count);

435: dbms_sql.NATIVE);
436:
437: -- define return columns from dynamic sql cursor select
438: dbms_sql.define_column(l_csr_num, 1, l_sid);
439: dbms_sql.define_column(l_csr_num, 2, l_count);
440:
441: -- Bind element_ids to bind variables in dynamic sql
442: if(p_ele_id_tbl is not null and p_ele_id_tbl.COUNT>0) then
443: for i in 1..p_ele_id_tbl.COUNT loop

Line 444: dbms_sql.bind_variable(l_csr_num, ':a'||to_char(i), p_ele_id_tbl(i));

440:
441: -- Bind element_ids to bind variables in dynamic sql
442: if(p_ele_id_tbl is not null and p_ele_id_tbl.COUNT>0) then
443: for i in 1..p_ele_id_tbl.COUNT loop
444: dbms_sql.bind_variable(l_csr_num, ':a'||to_char(i), p_ele_id_tbl(i));
445: end loop;
446: end if;
447:
448: -- Execute dynamic sql

Line 449: i1 := dbms_sql.execute(l_csr_num);

445: end loop;
446: end if;
447:
448: -- Execute dynamic sql
449: i1 := dbms_sql.execute(l_csr_num);
450:
451: l_total := 0;
452: WHILE( dbms_sql.fetch_rows(l_csr_num)>0)
453: LOOP

Line 452: WHILE( dbms_sql.fetch_rows(l_csr_num)>0)

448: -- Execute dynamic sql
449: i1 := dbms_sql.execute(l_csr_num);
450:
451: l_total := 0;
452: WHILE( dbms_sql.fetch_rows(l_csr_num)>0)
453: LOOP
454: dbms_sql.column_value(l_csr_num, 1, l_sid);
455: dbms_sql.column_value(l_csr_num, 2, l_count);
456: if(l_count >= p_ele_id_tbl.COUNT) then

Line 454: dbms_sql.column_value(l_csr_num, 1, l_sid);

450:
451: l_total := 0;
452: WHILE( dbms_sql.fetch_rows(l_csr_num)>0)
453: LOOP
454: dbms_sql.column_value(l_csr_num, 1, l_sid);
455: dbms_sql.column_value(l_csr_num, 2, l_count);
456: if(l_count >= p_ele_id_tbl.COUNT) then
457: l_total := l_total + 1;
458: end if;

Line 455: dbms_sql.column_value(l_csr_num, 2, l_count);

451: l_total := 0;
452: WHILE( dbms_sql.fetch_rows(l_csr_num)>0)
453: LOOP
454: dbms_sql.column_value(l_csr_num, 1, l_sid);
455: dbms_sql.column_value(l_csr_num, 2, l_count);
456: if(l_count >= p_ele_id_tbl.COUNT) then
457: l_total := l_total + 1;
458: end if;
459: END LOOP;

Line 460: dbms_sql.close_cursor(l_csr_num);

456: if(l_count >= p_ele_id_tbl.COUNT) then
457: l_total := l_total + 1;
458: end if;
459: END LOOP;
460: dbms_sql.close_cursor(l_csr_num);
461:
462:
463: -- OPEN l_csr FOR l_sqlstr1 || l_eids || l_sqlstr2;
464: -- LOOP