eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_LOOKUP_PUB dependencies on WF_NOTIFICATION

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

29: -- 10/25/01 EIHSU Get_Addn_Params added. This Procedure will serve
30: -- to fetch any additional information before assignment request made
31: -- 01/08/01 EIHSU bug 2170096
32: -- 03/11/04 SHLI added certification level and sort into cursor get_data
33: -- 05/18/2004 ACHANDA Bug # 3610389 : Make call to WF_NOTIFICATION.SubstituteSpecialChars
34: -- before rendering the data in jsp
35: -- 28/07/2008 GMARWAH Added code for Bug #7237992
36:
37: -- End of Comments

Line 249: WF_NOTIFICATION.SubstituteSpecialChars(party.party_name) party_name,

245: party.party_id party_id,
246: loc.location_id location_id,
247: site.party_site_id party_site_id,
248: 0000 party_site_use_id,
249: WF_NOTIFICATION.SubstituteSpecialChars(party.party_name) party_name,
250: --'NO_CODE' category_code,
251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||
252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||

Line 251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||

247: site.party_site_id party_site_id,
248: 0000 party_site_use_id,
249: WF_NOTIFICATION.SubstituteSpecialChars(party.party_name) party_name,
250: --'NO_CODE' category_code,
251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||
252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,

Line 252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||

248: 0000 party_site_use_id,
249: WF_NOTIFICATION.SubstituteSpecialChars(party.party_name) party_name,
250: --'NO_CODE' category_code,
251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||
252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,

Line 253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||

249: WF_NOTIFICATION.SubstituteSpecialChars(party.party_name) party_name,
250: --'NO_CODE' category_code,
251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||
252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,

Line 254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,

250: --'NO_CODE' category_code,
251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||
252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,

Line 255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,

251: WF_NOTIFICATION.SubstituteSpecialChars(loc.address1) || ' '||
252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,
259: '' area_code, --NEW

Line 256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,

252: WF_NOTIFICATION.SubstituteSpecialChars(loc.address2) || ' '||
253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,
259: '' area_code, --NEW
260: WF_NOTIFICATION.SubstituteSpecialChars(loc.county) county,

Line 257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,

253: WF_NOTIFICATION.SubstituteSpecialChars(loc.address3) || ' '||
254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,
259: '' area_code, --NEW
260: WF_NOTIFICATION.SubstituteSpecialChars(loc.county) county,
261: WF_NOTIFICATION.SubstituteSpecialChars(loc.country) country,

Line 258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,

254: WF_NOTIFICATION.SubstituteSpecialChars(loc.address4) address,
255: WF_NOTIFICATION.SubstituteSpecialChars(loc.city) city,
256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,
259: '' area_code, --NEW
260: WF_NOTIFICATION.SubstituteSpecialChars(loc.county) county,
261: WF_NOTIFICATION.SubstituteSpecialChars(loc.country) country,
262: party.employees_total employees_total, --NEW

Line 260: WF_NOTIFICATION.SubstituteSpecialChars(loc.county) county,

256: WF_NOTIFICATION.SubstituteSpecialChars(loc.state) state,
257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,
259: '' area_code, --NEW
260: WF_NOTIFICATION.SubstituteSpecialChars(loc.county) county,
261: WF_NOTIFICATION.SubstituteSpecialChars(loc.country) country,
262: party.employees_total employees_total, --NEW
263: party.category_code category_code, --NEW
264: party.sic_code sic_code, --NEW

Line 261: WF_NOTIFICATION.SubstituteSpecialChars(loc.country) country,

257: WF_NOTIFICATION.SubstituteSpecialChars(loc.province) province,
258: WF_NOTIFICATION.SubstituteSpecialChars(loc.postal_code) postal_code,
259: '' area_code, --NEW
260: WF_NOTIFICATION.SubstituteSpecialChars(loc.county) county,
261: WF_NOTIFICATION.SubstituteSpecialChars(loc.country) country,
262: party.employees_total employees_total, --NEW
263: party.category_code category_code, --NEW
264: party.sic_code sic_code, --NEW
265: 'X' primary_flag, --NEEDED??

Line 268: WF_NOTIFICATION.SubstituteSpecialChars(arlu.meaning) property1,

264: party.sic_code sic_code, --NEW
265: 'X' primary_flag, --NEEDED??
266: 'X' status, --NEEDED??
267: 'No_type' address_type, --NEEDED??
268: WF_NOTIFICATION.SubstituteSpecialChars(arlu.meaning) property1,
269: '' property2,
270: '' property3,
271: '' property4,
272: '' property5

Line 897: x_winners_tbl(i).resource_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_name(i));

893: x_winners_tbl(i).group_id := lx_winners_rec.group_id(i);
894: x_winners_tbl(i).role := lx_winners_rec.role(i);
895: x_winners_tbl(i).full_access_flag := lx_winners_rec.full_access_flag(i);
896: x_winners_tbl(i).primary_contact_flag := lx_winners_rec.primary_contact_flag(i);
897: x_winners_tbl(i).resource_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_name(i));
898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));
899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));

Line 898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));

894: x_winners_tbl(i).role := lx_winners_rec.role(i);
895: x_winners_tbl(i).full_access_flag := lx_winners_rec.full_access_flag(i);
896: x_winners_tbl(i).primary_contact_flag := lx_winners_rec.primary_contact_flag(i);
897: x_winners_tbl(i).resource_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_name(i));
898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));
899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));

Line 899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));

895: x_winners_tbl(i).full_access_flag := lx_winners_rec.full_access_flag(i);
896: x_winners_tbl(i).primary_contact_flag := lx_winners_rec.primary_contact_flag(i);
897: x_winners_tbl(i).resource_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_name(i));
898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));
899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));

Line 900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));

896: x_winners_tbl(i).primary_contact_flag := lx_winners_rec.primary_contact_flag(i);
897: x_winners_tbl(i).resource_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_name(i));
898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));
899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);

Line 901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));

897: x_winners_tbl(i).resource_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_name(i));
898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));
899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);
905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));

Line 902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));

898: x_winners_tbl(i).resource_job_title := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_job_title(i));
899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);
905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));
906: x_winners_tbl(i).property2 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property2(i));

Line 903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));

899: x_winners_tbl(i).resource_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_phone(i));
900: x_winners_tbl(i).resource_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_email(i));
901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);
905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));
906: x_winners_tbl(i).property2 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property2(i));
907: x_winners_tbl(i).property3 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property3(i));

Line 905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));

901: x_winners_tbl(i).resource_mgr_name := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_name(i));
902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);
905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));
906: x_winners_tbl(i).property2 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property2(i));
907: x_winners_tbl(i).property3 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property3(i));
908: x_winners_tbl(i).property4 := lx_winners_rec.property4(i);
909: x_winners_tbl(i).property5 := lx_winners_rec.property5(i);

Line 906: x_winners_tbl(i).property2 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property2(i));

902: x_winners_tbl(i).resource_mgr_phone := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_phone(i));
903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);
905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));
906: x_winners_tbl(i).property2 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property2(i));
907: x_winners_tbl(i).property3 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property3(i));
908: x_winners_tbl(i).property4 := lx_winners_rec.property4(i);
909: x_winners_tbl(i).property5 := lx_winners_rec.property5(i);
910: x_winners_tbl(i).property6 := lx_winners_rec.property6(i);

Line 907: x_winners_tbl(i).property3 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property3(i));

903: x_winners_tbl(i).resource_mgr_email := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.resource_mgr_email(i));
904: x_winners_tbl(i).terr_id := lx_winners_rec.terr_id(i);
905: x_winners_tbl(i).property1 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property1(i));
906: x_winners_tbl(i).property2 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property2(i));
907: x_winners_tbl(i).property3 := WF_NOTIFICATION.SubstituteSpecialChars(lx_winners_rec.property3(i));
908: x_winners_tbl(i).property4 := lx_winners_rec.property4(i);
909: x_winners_tbl(i).property5 := lx_winners_rec.property5(i);
910: x_winners_tbl(i).property6 := lx_winners_rec.property6(i);
911: x_winners_tbl(i).property7 := lx_winners_rec.property7(i);