APPS.FLM_KANBAN dependencies on DBMS_SQL

Line 706: l_cursor := DBMS_SQL.OPEN_CURSOR;

702: END IF;
703: -- DBMS_OUTPUT.PUT_LINE('SQL STATEMENT GENERATED:');
704: -- DBMS_OUTPUT.PUT_LINE(substr(l_sql_stmt, 1, 250));
705:
706: l_cursor := DBMS_SQL.OPEN_CURSOR;
707: DBMS_SQL.PARSE(l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
708: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_item_id);
709:
710: flm_util.do_binds(l_cursor);

Line 707: DBMS_SQL.PARSE(l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);

703: -- DBMS_OUTPUT.PUT_LINE('SQL STATEMENT GENERATED:');
704: -- DBMS_OUTPUT.PUT_LINE(substr(l_sql_stmt, 1, 250));
705:
706: l_cursor := DBMS_SQL.OPEN_CURSOR;
707: DBMS_SQL.PARSE(l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
708: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_item_id);
709:
710: flm_util.do_binds(l_cursor);
711:

Line 708: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_item_id);

704: -- DBMS_OUTPUT.PUT_LINE(substr(l_sql_stmt, 1, 250));
705:
706: l_cursor := DBMS_SQL.OPEN_CURSOR;
707: DBMS_SQL.PARSE(l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
708: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_item_id);
709:
710: flm_util.do_binds(l_cursor);
711:
712: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

Line 712: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

708: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_item_id);
709:
710: flm_util.do_binds(l_cursor);
711:
712: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
713: WHILE DBMS_SQL.FETCH_ROWS(l_cursor)>0 LOOP
714: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_item_id);
715: l_result(l_item_id) := l_item_id;
716: --l_cnt := l_cnt+1;

Line 713: WHILE DBMS_SQL.FETCH_ROWS(l_cursor)>0 LOOP

709:
710: flm_util.do_binds(l_cursor);
711:
712: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
713: WHILE DBMS_SQL.FETCH_ROWS(l_cursor)>0 LOOP
714: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_item_id);
715: l_result(l_item_id) := l_item_id;
716: --l_cnt := l_cnt+1;
717: END LOOP;

Line 714: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_item_id);

710: flm_util.do_binds(l_cursor);
711:
712: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
713: WHILE DBMS_SQL.FETCH_ROWS(l_cursor)>0 LOOP
714: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_item_id);
715: l_result(l_item_id) := l_item_id;
716: --l_cnt := l_cnt+1;
717: END LOOP;
718: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 718: DBMS_SQL.CLOSE_CURSOR(l_cursor);

714: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_item_id);
715: l_result(l_item_id) := l_item_id;
716: --l_cnt := l_cnt+1;
717: END LOOP;
718: DBMS_SQL.CLOSE_CURSOR(l_cursor);
719:
720: l_cnt := 0;
721:
722: /***