1799: FROM wf_role_lov_vl
1800: where status <> 'INACTIVE'
1801: and (UPPER(display_name) LIKE UPPER(p_display_value)||'%');
1802:
1803: wf_lov.g_define_rec.total_rows := l_total_rows;
1804:
1805: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('WFITD_INTERNAL_NAME');
1806:
1807: open c_user_lov (p_display_value);
1801: and (UPPER(display_name) LIKE UPPER(p_display_value)||'%');
1802:
1803: wf_lov.g_define_rec.total_rows := l_total_rows;
1804:
1805: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('WFITD_INTERNAL_NAME');
1806:
1807: open c_user_lov (p_display_value);
1808:
1809: LOOP
1817: IF (ii >= p_start_row) THEN
1818:
1819: nn := nn + 1;
1820:
1821: wf_lov.g_value_tbl(nn).hidden_key := l_name;
1822: wf_lov.g_value_tbl(nn).display_value := l_display_name;
1823: wf_lov.g_value_tbl(nn).add_attr1_value := l_name;
1824:
1825: END IF;
1818:
1819: nn := nn + 1;
1820:
1821: wf_lov.g_value_tbl(nn).hidden_key := l_name;
1822: wf_lov.g_value_tbl(nn).display_value := l_display_name;
1823: wf_lov.g_value_tbl(nn).add_attr1_value := l_name;
1824:
1825: END IF;
1826:
1819: nn := nn + 1;
1820:
1821: wf_lov.g_value_tbl(nn).hidden_key := l_name;
1822: wf_lov.g_value_tbl(nn).display_value := l_display_name;
1823: wf_lov.g_value_tbl(nn).add_attr1_value := l_name;
1824:
1825: END IF;
1826:
1827: END LOOP;