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_JSP_REPORTS dependencies on WF_NOTIFICATION

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

16: -- 11/20/2001 EIHSU removed dbms output messages
17: -- added active_on date conditions into def, chg reports
18: -- 05/06/2002 ARPATEL Added support for p_rpt_type = 'LOOKUP_TERR' in
19: -- definition_rpt proc - enh# 2109535
20: -- 05/18/2004 ACHANDA Bug # 3610389 : Make call to WF_NOTIFICATION.SubstituteSpecialChars
21: -- before rendering the data in jsp
22: -- 28/07/2008 GMARWAH Modified for Bug 7237992
23: -- 18/08/2008 GMARWAH Modified for bug 731589 to display operating unit
24: -- End of Comments

Line 103: select qual_type_usg_id, WF_NOTIFICATION.SubstituteSpecialChars(qualifier_type_name) qualifier_type_name,

99: );
100: */
101: -- qualifier types
102: CURSOR c_get_qual_types(ci_terr_id NUMBER) IS
103: select qual_type_usg_id, WF_NOTIFICATION.SubstituteSpecialChars(qualifier_type_name) qualifier_type_name,
104: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_type_description) qualifier_type_description
105: from jtf_terr_transactions_v
106: where terr_id = ci_terr_id;
107:

Line 104: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_type_description) qualifier_type_description

100: */
101: -- qualifier types
102: CURSOR c_get_qual_types(ci_terr_id NUMBER) IS
103: select qual_type_usg_id, WF_NOTIFICATION.SubstituteSpecialChars(qualifier_type_name) qualifier_type_name,
104: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_type_description) qualifier_type_description
105: from jtf_terr_transactions_v
106: where terr_id = ci_terr_id;
107:
108:

Line 115: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name

111: /* SELECT TERR_QUAL_ID,
112: TERR_ID,
113: QUAL_USG_ID,
114: ORG_ID,
115: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name
116: FROM jtf_terr_qualifiers_v
117: WHERE qualifier_type_name <> 'RESOURCE'
118: and terr_id = ci_terr_id
119: and terr_qual_id is not null -- added becuse we have some real bad data in jtadom

Line 128: WF_NOTIFICATION.SUBSTITUTESPECIALCHARS(JSQ.NAME) QUALIFIER_NAME

124: JTQ.TERR_QUAL_ID,
125: JTQ.TERR_ID,
126: JTQ.QUAL_USG_ID,
127: JTQ.ORG_ID,
128: WF_NOTIFICATION.SUBSTITUTESPECIALCHARS(JSQ.NAME) QUALIFIER_NAME
129: FROM
130: JTF_TERR_QUAL_ALL JTQ ,
131: JTF_QUAL_USGS_ALL JQU ,
132: JTF_SEEDED_QUAL_ALL_TL JSQ ,

Line 152: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name

148: SELECT TERR_QUAL_ID,
149: TERR_ID,
150: QUAL_USG_ID,
151: ORG_ID,
152: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name
153: FROM jtf_terr_qualifiers_v
154: WHERE qualifier_type_name = 'RESOURCE'
155: and terr_id = ci_terr_id;
156:

Line 163: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC

159: /*
160: CURSOR c_get_terr_values (ci_terr_qual_id NUMBER) IS
161: SELECT j1.TERR_VALUE_ID
162: , j1.COMPARISON_OPERATOR
163: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
164: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
165: , j1.LOW_VALUE_NUMBER
166: , j1.HIGH_VALUE_NUMBER
167: , j1.INTEREST_TYPE

Line 164: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC

160: CURSOR c_get_terr_values (ci_terr_qual_id NUMBER) IS
161: SELECT j1.TERR_VALUE_ID
162: , j1.COMPARISON_OPERATOR
163: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
164: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
165: , j1.LOW_VALUE_NUMBER
166: , j1.HIGH_VALUE_NUMBER
167: , j1.INTEREST_TYPE
168: , j1.PRIMARY_INTEREST_CODE

Line 172: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME

168: , j1.PRIMARY_INTEREST_CODE
169: , j1.SECONDARY_INTEREST_CODE
170: , j1.CURRENCY_DESC
171: , j1.LOW_VALUE_CHAR_ID
172: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
173: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
174: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
176: , j1.LOW_VALUE_DATE

Line 173: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC

169: , j1.SECONDARY_INTEREST_CODE
170: , j1.CURRENCY_DESC
171: , j1.LOW_VALUE_CHAR_ID
172: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
173: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
174: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
176: , j1.LOW_VALUE_DATE
177: , j1.HIGH_VALUE_DATE

Line 174: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC

170: , j1.CURRENCY_DESC
171: , j1.LOW_VALUE_CHAR_ID
172: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
173: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
174: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
176: , j1.LOW_VALUE_DATE
177: , j1.HIGH_VALUE_DATE
178: , DISPLAY_TYPE

Line 175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC

171: , j1.LOW_VALUE_CHAR_ID
172: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
173: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
174: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
176: , j1.LOW_VALUE_DATE
177: , j1.HIGH_VALUE_DATE
178: , DISPLAY_TYPE
179: , CONVERT_TO_ID_FLAG

Line 188: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC

184: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;*/--COmmented for bug 7237992
185: /*
186: SELECT distinct j1.TERR_VALUE_ID
187: , j1.COMPARISON_OPERATOR
188: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
189: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
190: , j1.LOW_VALUE_NUMBER
191: , j1.HIGH_VALUE_NUMBER
192: , j1.INTEREST_TYPE_ID INTEREST_TYPE

Line 189: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC

185: /*
186: SELECT distinct j1.TERR_VALUE_ID
187: , j1.COMPARISON_OPERATOR
188: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
189: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
190: , j1.LOW_VALUE_NUMBER
191: , j1.HIGH_VALUE_NUMBER
192: , j1.INTEREST_TYPE_ID INTEREST_TYPE
193: , j1.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE

Line 197: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME

193: , j1.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE
194: , j1.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE
195: , j1.CURRENCY_CODE CURRENCY_DESC
196: , j1.LOW_VALUE_CHAR_ID
197: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
198: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
201: , null LOW_VALUE_DATE

Line 198: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC

194: , j1.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE
195: , j1.CURRENCY_CODE CURRENCY_DESC
196: , j1.LOW_VALUE_CHAR_ID
197: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
198: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
201: , null LOW_VALUE_DATE
202: , null HIGH_VALUE_DATE

Line 199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC

195: , j1.CURRENCY_CODE CURRENCY_DESC
196: , j1.LOW_VALUE_CHAR_ID
197: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
198: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
201: , null LOW_VALUE_DATE
202: , null HIGH_VALUE_DATE
203: , DISPLAY_TYPE

Line 200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC

196: , j1.LOW_VALUE_CHAR_ID
197: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
198: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
201: , null LOW_VALUE_DATE
202: , null HIGH_VALUE_DATE
203: , DISPLAY_TYPE
204: , CONVERT_TO_ID_FLAG

Line 216: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC

212:
213: CURSOR c_get_terr_values (ci_terr_qual_id NUMBER) IS
214: SELECT distinct j1.TERR_VALUE_ID
215: , j1.COMPARISON_OPERATOR
216: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
217: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
218: , j1.LOW_VALUE_NUMBER
219: , j1.HIGH_VALUE_NUMBER
220: -- , j1.INTEREST_TYPE_ID INTEREST_TYPE

Line 217: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC

213: CURSOR c_get_terr_values (ci_terr_qual_id NUMBER) IS
214: SELECT distinct j1.TERR_VALUE_ID
215: , j1.COMPARISON_OPERATOR
216: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
217: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
218: , j1.LOW_VALUE_NUMBER
219: , j1.HIGH_VALUE_NUMBER
220: -- , j1.INTEREST_TYPE_ID INTEREST_TYPE
221: -- , j1.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE

Line 229: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME

225: , decode(j2.display_type, 'INTEREST_TYPE', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql3, j1.secondary_interest_code_id, NULL), NULL) SECONDARY_INTEREST_CODE
226:
227: , j1.CURRENCY_CODE CURRENCY_DESC
228: , j1.LOW_VALUE_CHAR_ID
229: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
230: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, j1.value2_id),
231: 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), 'DEP_2FIELDS',
232: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
233: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), NULL)) VALUE1_DESC

Line 230: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, j1.value2_id),

226:
227: , j1.CURRENCY_CODE CURRENCY_DESC
228: , j1.LOW_VALUE_CHAR_ID
229: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
230: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, j1.value2_id),
231: 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), 'DEP_2FIELDS',
232: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
233: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), NULL)) VALUE1_DESC
234: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2,

Line 234: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2,

230: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, j1.value2_id),
231: 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), 'DEP_2FIELDS',
232: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
233: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), NULL)) VALUE1_DESC
234: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2,
235: j1.value2_id, j1.value3_id), 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.value2_id, -9999),
236: 'DEP_3FIELDS_CHAR_3IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.value2_id, -9999), NULL)) VALUE2_DESC
237: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql3, j1.value3_id, NULL),
238: 'DEP_3FIELDS_CHAR_3IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql3, j1.value3_id, j1.value4_id), NULL)) VALUE3_DESC

Line 237: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql3, j1.value3_id, NULL),

233: jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.value1_id, -9999), NULL)) VALUE1_DESC
234: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_2FIELDS_CHAR_2IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2,
235: j1.value2_id, j1.value3_id), 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.value2_id, -9999),
236: 'DEP_3FIELDS_CHAR_3IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.value2_id, -9999), NULL)) VALUE2_DESC
237: , WF_NOTIFICATION.SubstituteSpecialChars(decode(j2.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql3, j1.value3_id, NULL),
238: 'DEP_3FIELDS_CHAR_3IDS', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql3, j1.value3_id, j1.value4_id), NULL)) VALUE3_DESC
239: , null LOW_VALUE_DATE
240: , null HIGH_VALUE_DATE
241: , DISPLAY_TYPE

Line 251: /* select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(resource_name) resource_name, resource_type, terr_rsc_id

247: AND j1.terr_value_id is not null
248: ORDER BY j1.COMPARISON_OPERATOR;
249: -- resources
250: CURSOR c_get_resource(ci_terr_id NUMBER) IS
251: /* select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(resource_name) resource_name, resource_type, terr_rsc_id
252: from jtf_terr_resources_v jtrv
253: where jtrv.terr_id = ci_terr_id
254: order by resource_name;
255: */

Line 256: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(

252: from jtf_terr_resources_v jtrv
253: where jtrv.terr_id = ci_terr_id
254: order by resource_name;
255: */
256: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(
257: RESOURCE_ID , DECODE( RESOURCE_TYPE , 'RS_SUPPLIER', 'RS_SUPPLIER_CONTACT' ,
258: RESOURCE_TYPE ) )) resource_name, resource_type, terr_rsc_id
259: from JTF_TERR_RSC
260: where terr_id = ci_terr_id

Line 265: select terr_rsc_access_id, access_type, WF_NOTIFICATION.SubstituteSpecialChars(meaning) meaning

261: order by resource_name;
262:
263: -- resource accesses
264: CURSOR c_get_rsc_access(ci_terr_rsc_id NUMBER) IS
265: select terr_rsc_access_id, access_type, WF_NOTIFICATION.SubstituteSpecialChars(meaning) meaning
266: from jtf_terr_rsc_access_v
267: where terr_rsc_id = ci_terr_rsc_id;
268:
269: lp_sysdate DATE := SYSDATE;

Line 296: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,

292:
293: /* arpatel 05/06/02 enh# 2109535 */
294: if p_rpt_type = 'LOOKUP_TERR' and p_param5 IS NOT NULL then
295: open terr_name_cur for
296: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
297: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
298: from jtf_terr_all j
299: where j.terr_id = p_param5;
300:

Line 297: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description

293: /* arpatel 05/06/02 enh# 2109535 */
294: if p_rpt_type = 'LOOKUP_TERR' and p_param5 IS NOT NULL then
295: open terr_name_cur for
296: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
297: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
298: from jtf_terr_all j
299: where j.terr_id = p_param5;
300:
301:

Line 324: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,

320: /* ARPATEL: 10/16, END OF bug#2832442 */
321:
322: --dbms_output.put_line('get territory by property');
323: open terr_name_cur for
324: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
325: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
326: from jtf_terr j
327: WHERE ( TRUNC(j.end_date_active) >= NVL(p_param4, lp_sysdate)
328: AND

Line 325: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description

321:
322: --dbms_output.put_line('get territory by property');
323: open terr_name_cur for
324: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
325: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
326: from jtf_terr j
327: WHERE ( TRUNC(j.end_date_active) >= NVL(p_param4, lp_sysdate)
328: AND
329: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)

Line 354: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,

350: START WITH jt.terr_id = j.terr_id ) ;
351: else
352: --dbms_output.put_line('get territory by_id mode ');
353: open terr_name_cur for
354: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
355: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
356: from jtf_terr j
357: where j.terr_id = p_param5;
358:

Line 355: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description

351: else
352: --dbms_output.put_line('get territory by_id mode ');
353: open terr_name_cur for
354: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
355: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
356: from jtf_terr j
357: where j.terr_id = p_param5;
358:
359: end if;

Line 363: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,

359: end if;
360: elsif p_rpt_type = 'CHANGES' then
361: --dbms_output.put_line('creating changes cursor ');
362: open terr_name_cur for
363: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
364: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
365: from jtf_terr j, jtf_terr_usgs jtu
366: where 1=1
367: --and j.terr_id = '19027'

Line 364: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description

360: elsif p_rpt_type = 'CHANGES' then
361: --dbms_output.put_line('creating changes cursor ');
362: open terr_name_cur for
363: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
364: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
365: from jtf_terr j, jtf_terr_usgs jtu
366: where 1=1
367: --and j.terr_id = '19027'
368: AND j.terr_id = jtu.terr_id