APPS.JTF_TERR_JSP_LOV_RECS_PUB dependencies on WF_NOTIFICATION

Line 17: -- 05/18/2004 ACHANDA Bug # 3610389 : Make call to WF_NOTIFICATION.SubstituteSpecialChars

13: --
14: -- HISTORY
15: -- 04/30/2001 EIHSU Created
16: -- 11/20/2001 EIHSU Additional data groups
17: -- 05/18/2004 ACHANDA Bug # 3610389 : Make call to WF_NOTIFICATION.SubstituteSpecialChars
18: -- before rendering the data in jsp
19: -- 06/03/2004 ACHANDA Bug # 3664794
20: -- 28/07/2008 GMARWAH Bug 7237992. modified jtf_qual_usg to
21: -- jtf_qual_usg_all.

Line 176: l_jsp_lov_sql := 'select WF_NOTIFICATION.SubstituteSpecialChars(Meaning) col1_value, lookup_code col2_value from ar_lookups where lookup_type = ''HZ_PARTY_CERT_LEVEL'' ';

172: --// QUALIFIER VALUES CONDITION
173: --////////////////////////////////////
174:
175: if l_in_filter_lov_rec.column1 = '-9001' then
176: l_jsp_lov_sql := 'select WF_NOTIFICATION.SubstituteSpecialChars(Meaning) col1_value, lookup_code col2_value from ar_lookups where lookup_type = ''HZ_PARTY_CERT_LEVEL'' ';
177: else
178: select distinct jsp_lov_sql into l_jsp_lov_sql
179: from jtf_qual_usgs_all
180: where qual_usg_id = l_in_filter_lov_rec.column1;

Line 294: x_result_tbl(l_row_count).column1 := WF_NOTIFICATION.SubstituteSpecialChars(jtty_list1(l_row_count));

290: exit when jtty_list1.last is null;
291: exit when jtty_list1.last = l_row_count;
292: l_row_count := l_row_count + 1;
293: if l_out_cols >= 1 then
294: x_result_tbl(l_row_count).column1 := WF_NOTIFICATION.SubstituteSpecialChars(jtty_list1(l_row_count));
295: end if;
296: if l_out_cols >= 2 then
297: x_result_tbl(l_row_count).column2 := jtty_list2(l_row_count);
298: end if;

Line 330: Select WF_NOTIFICATION.SubstituteSpecialChars(meaning), source_id, null, null, null,

326: from jtf_sources
327: where UPPER(meaning) like NVL(l_column1, '%');
328:
329: OPEN lov_output_cur FOR
330: Select WF_NOTIFICATION.SubstituteSpecialChars(meaning), source_id, null, null, null,
331: null, null, null, null, null,
332: null, null, null, null, null,
333: null, null, null, null, null
334: from jtf_sources

Line 356: Select distinct WF_NOTIFICATION.SubstituteSpecialChars(jsquv.seeded_qual_name) sqname, jsquv.qual_usg_id, jsquv.qual_type_id,

352: -- and source_id = l_column2
353: and enabled_flag = 'Y';
354:
355: OPEN lov_output_cur FOR
356: Select distinct WF_NOTIFICATION.SubstituteSpecialChars(jsquv.seeded_qual_name) sqname, jsquv.qual_usg_id, jsquv.qual_type_id,
357: jsquv.source_id, jsquv.qual_col1_alias,
358: null, null, null, null, null,
359: null, null, null, null, null,
360: null, null, null, null, null

Line 385: Select distinct WF_NOTIFICATION.SubstituteSpecialChars(resource_name), resource_id,

381: -- ARPATEL09/08/2003 bug#2966686 fix
382: or l_column1 = '%';
383:
384: OPEN lov_output_cur FOR
385: Select distinct WF_NOTIFICATION.SubstituteSpecialChars(resource_name), resource_id,
386: resource_type, null, null,
387: null, null, null, null, null,
388: null, null, null, null, null,
389: null, null, null, null, null

Line 415: /* select WF_NOTIFICATION.SubstituteSpecialChars(seeded_qual_name), qual_usg_id, Decode(jsp_lov_sql, null, 'N', 'Y'),

411: l_total_count := 1; -- because this will always be used to get all rows
412:
413: OPEN lov_output_cur FOR
414:
415: /* select WF_NOTIFICATION.SubstituteSpecialChars(seeded_qual_name), qual_usg_id, Decode(jsp_lov_sql, null, 'N', 'Y'),
416: qual_col1_alias, display_type,
417: seeded_qual_id, null, null, null, null,
418: null, null, null, null, null,
419: null, null, null, null, null

Line 429: SELECT distinct WF_NOTIFICATION.SubstituteSpecialChars(jsq.name), jqu.qual_usg_id, Decode(jqu.jsp_lov_sql, null, 'N', 'Y'),

425: and qual_col1_alias is not null
426: order by display_sequence;*/ --commented for bug 7237992.
427:
428: -- replaced the above query with following query
429: SELECT distinct WF_NOTIFICATION.SubstituteSpecialChars(jsq.name), jqu.qual_usg_id, Decode(jqu.jsp_lov_sql, null, 'N', 'Y'),
430: jqu.qual_col1_alias, jqu.display_type,
431: jsq.seeded_qual_id, null, null, null, null,
432: null, null, null, null, null,
433: null, null, null, null, null