DBA Data[Home] [Help]

APPS.IEM_TEXT_PVT dependencies on JTF_VARCHAR2_TABLE_2000

Line 181: x_qtokens OUT NOCOPY jtf_varchar2_Table_2000,

177: p_type in number, -- 1 for theme 2 for token
178: p_lang in varchar2,
179: p_qtext in varchar2,
180: p_rtext in varchar2,
181: x_qtokens OUT NOCOPY jtf_varchar2_Table_2000,
182: x_rtokens OUT NOCOPY jtf_varchar2_Table_2000,
183: x_status OUT NOCOPY varchar2)
184: is
185: l_kw_tbl iem_text_pvt.keyword_Rec_tbl;

Line 182: x_rtokens OUT NOCOPY jtf_varchar2_Table_2000,

178: p_lang in varchar2,
179: p_qtext in varchar2,
180: p_rtext in varchar2,
181: x_qtokens OUT NOCOPY jtf_varchar2_Table_2000,
182: x_rtokens OUT NOCOPY jtf_varchar2_Table_2000,
183: x_status OUT NOCOPY varchar2)
184: is
185: l_kw_tbl iem_text_pvt.keyword_Rec_tbl;
186: l_theme_enabled varchar2(1);

Line 198: x_qtokens:=jtf_varchar2_Table_2000();

194: l_flag number;
195: begin
196: select decode(p_type,1,'Y','N') into l_theme_enabled from dual;
197: l_kw_tbl.delete;
198: x_qtokens:=jtf_varchar2_Table_2000();
199: x_rtokens:=jtf_varchar2_Table_2000();
200: IF p_qtext is not null then
201: iem_text_pvt.get_tokens(p_type,p_lang,p_qtext,l_kw_tbl);
202: IF l_kw_tbl.count>0 then

Line 199: x_rtokens:=jtf_varchar2_Table_2000();

195: begin
196: select decode(p_type,1,'Y','N') into l_theme_enabled from dual;
197: l_kw_tbl.delete;
198: x_qtokens:=jtf_varchar2_Table_2000();
199: x_rtokens:=jtf_varchar2_Table_2000();
200: IF p_qtext is not null then
201: iem_text_pvt.get_tokens(p_type,p_lang,p_qtext,l_kw_tbl);
202: IF l_kw_tbl.count>0 then
203: for i in l_kw_tbl.first..l_kw_tbl.last LOOP