APPS.CS_KNOWLEDGE_PVT dependencies on DBMS_SQL

Line 432: l_csr_num := dbms_sql.open_cursor;

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

Line 435: dbms_sql.parse(l_csr_num,

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

Line 437: dbms_sql.NATIVE);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 462: dbms_sql.close_cursor(l_csr_num);

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