APPS.FLM_SEQ_ID2NAME dependencies on FLM_UTIL

Line 286: flm_util.init_bind;

282: x_name := null;
283: return;
284: end if;
285:
286: flm_util.init_bind;
287: flm_util.add_bind(':org_id', p_org_id);
288:
289: l_query := l_query || ' WHERE ID_VALUE=:column_value';
290: flm_util.add_bind(':column_value', p_value);

Line 287: flm_util.add_bind(':org_id', p_org_id);

283: return;
284: end if;
285:
286: flm_util.init_bind;
287: flm_util.add_bind(':org_id', p_org_id);
288:
289: l_query := l_query || ' WHERE ID_VALUE=:column_value';
290: flm_util.add_bind(':column_value', p_value);
291:

Line 290: flm_util.add_bind(':column_value', p_value);

286: flm_util.init_bind;
287: flm_util.add_bind(':org_id', p_org_id);
288:
289: l_query := l_query || ' WHERE ID_VALUE=:column_value';
290: flm_util.add_bind(':column_value', p_value);
291:
292: l_cursor := DBMS_SQL.OPEN_CURSOR;
293: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);

Line 296: flm_util.do_binds(l_cursor);

292: l_cursor := DBMS_SQL.OPEN_CURSOR;
293: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);
295:
296: flm_util.do_binds(l_cursor);
297:
298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
299: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
300: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_name);