APPS.FLM_KANBAN dependencies on FLM_UTIL

Line 517: flm_util.init_bind;

513: BEGIN
514:
515: o_error_num := 0;
516:
517: flm_util.init_bind;
518: --
519: -- Find out all relevant items
520: --
521: l_cnt := 0;

Line 633: l_return := flm_util.Item_Where_Clause(

629:
630: -- construct the 'where' clause
631: IF i_item_from IS NOT NULL AND i_item_to IS NOT NULL
632: THEN
633: l_return := flm_util.Item_Where_Clause(
634: i_item_from,
635: i_item_to,
636: 'msi',
637: l_item_where_clause,

Line 645: l_return := flm_util.Category_Where_Clause(

641:
642: IF (i_cat_from IS NOT NULL OR i_cat_to IS NOT NULL) AND
643: i_category_set_id IS NOT NULL
644: THEN
645: l_return := flm_util.Category_Where_Clause(
646: i_cat_from,
647: i_cat_to,
648: 'cat',
649: i_category_structure_id,

Line 667: flm_util.add_bind(':org_id', i_org_id);

663: ' where mic.organization_id = :org_id' ||
664: ' AND mic.category_set_id = :category_set_id' || ')';
665: END IF;
666:
667: flm_util.add_bind(':org_id', i_org_id);
668: flm_util.add_bind(':category_set_id', i_category_set_id);
669:
670: -- DBMS_OUTPUT.PUT_LINE('Category where clause: '||l_cat_where_clause);
671:

Line 668: flm_util.add_bind(':category_set_id', i_category_set_id);

664: ' AND mic.category_set_id = :category_set_id' || ')';
665: END IF;
666:
667: flm_util.add_bind(':org_id', i_org_id);
668: flm_util.add_bind(':category_set_id', i_category_set_id);
669:
670: -- DBMS_OUTPUT.PUT_LINE('Category where clause: '||l_cat_where_clause);
671:
672:

Line 685: flm_util.add_bind(':org_id', i_org_id);

681: l_sql_stmt := 'SELECT DISTINCT inventory_item_id ' ||
682: 'FROM mtl_system_items msi ' ||
683: 'WHERE organization_id = :org_id' || ' ';
684:
685: flm_util.add_bind(':org_id', i_org_id);
686:
687: IF l_id_where_clause IS NOT NULL
688: THEN
689: l_sql_stmt := l_sql_stmt || ' AND ' || l_id_where_clause;

Line 710: flm_util.do_binds(l_cursor);

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);
713: WHILE DBMS_SQL.FETCH_ROWS(l_cursor)>0 LOOP
714: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_item_id);