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: -- Commented for bug 8365663
166: ,decode(j2.display_type, 'CHAR'
167: ,decode(j1.id_used_flag, 'Y', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char_id, NULL)

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: -- Commented for bug 8365663
166: ,decode(j2.display_type, 'CHAR'
167: ,decode(j1.id_used_flag, 'Y', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char_id, NULL)
168: ,'N', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char, NULL), NULL)

Line 170: ,WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR)) low_value_char_desc

166: ,decode(j2.display_type, 'CHAR'
167: ,decode(j1.id_used_flag, 'Y', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char_id, NULL)
168: ,'N', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char, NULL), NULL)
169: ,'DEP_2FIELDS_1CHAR_1ID', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char, NULL)
170: ,WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR)) low_value_char_desc
171:
172: ,decode(j2.display_type, 'CHAR'
173: ,jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.high_value_char, NULL)
174: ,'DEP_2FIELDS_1CHAR_1ID', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.low_value_char_id, NULL)

Line 175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR)) high_value_char_desc

171:
172: ,decode(j2.display_type, 'CHAR'
173: ,jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.high_value_char, NULL)
174: ,'DEP_2FIELDS_1CHAR_1ID', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.low_value_char_id, NULL)
175: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR)) high_value_char_desc
176: , j1.LOW_VALUE_NUMBER
177: , j1.HIGH_VALUE_NUMBER
178: , j1.INTEREST_TYPE
179: , j1.PRIMARY_INTEREST_CODE

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

179: , j1.PRIMARY_INTEREST_CODE
180: , j1.SECONDARY_INTEREST_CODE
181: , j1.CURRENCY_DESC
182: , j1.LOW_VALUE_CHAR_ID
183: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
184: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
185: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
186: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
187: , j1.LOW_VALUE_DATE

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

180: , j1.SECONDARY_INTEREST_CODE
181: , j1.CURRENCY_DESC
182: , j1.LOW_VALUE_CHAR_ID
183: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
184: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
185: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
186: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
187: , j1.LOW_VALUE_DATE
188: , j1.HIGH_VALUE_DATE

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

181: , j1.CURRENCY_DESC
182: , j1.LOW_VALUE_CHAR_ID
183: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
184: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
185: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
186: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
187: , j1.LOW_VALUE_DATE
188: , j1.HIGH_VALUE_DATE
189: , DISPLAY_TYPE

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

182: , j1.LOW_VALUE_CHAR_ID
183: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
184: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_DESC) VALUE1_DESC
185: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_DESC) VALUE2_DESC
186: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_DESC) VALUE3_DESC
187: , j1.LOW_VALUE_DATE
188: , j1.HIGH_VALUE_DATE
189: , DISPLAY_TYPE
190: , CONVERT_TO_ID_FLAG

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

195: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;*/--COmmented for bug 7237992
196: /*
197: SELECT distinct j1.TERR_VALUE_ID
198: , j1.COMPARISON_OPERATOR
199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
201: , j1.LOW_VALUE_NUMBER
202: , j1.HIGH_VALUE_NUMBER
203: , j1.INTEREST_TYPE_ID INTEREST_TYPE

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

196: /*
197: SELECT distinct j1.TERR_VALUE_ID
198: , j1.COMPARISON_OPERATOR
199: , WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
200: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
201: , j1.LOW_VALUE_NUMBER
202: , j1.HIGH_VALUE_NUMBER
203: , j1.INTEREST_TYPE_ID INTEREST_TYPE
204: , j1.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE

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

204: , j1.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE
205: , j1.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE
206: , j1.CURRENCY_CODE CURRENCY_DESC
207: , j1.LOW_VALUE_CHAR_ID
208: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
209: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
210: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
211: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
212: , null LOW_VALUE_DATE

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

205: , j1.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE
206: , j1.CURRENCY_CODE CURRENCY_DESC
207: , j1.LOW_VALUE_CHAR_ID
208: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
209: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
210: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
211: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
212: , null LOW_VALUE_DATE
213: , null HIGH_VALUE_DATE

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

206: , j1.CURRENCY_CODE CURRENCY_DESC
207: , j1.LOW_VALUE_CHAR_ID
208: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
209: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
210: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
211: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
212: , null LOW_VALUE_DATE
213: , null HIGH_VALUE_DATE
214: , DISPLAY_TYPE

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

207: , j1.LOW_VALUE_CHAR_ID
208: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
209: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE1_ID) VALUE1_DESC
210: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE2_ID) VALUE2_DESC
211: , WF_NOTIFICATION.SubstituteSpecialChars(j1.VALUE3_ID) VALUE3_DESC
212: , null LOW_VALUE_DATE
213: , null HIGH_VALUE_DATE
214: , DISPLAY_TYPE
215: , CONVERT_TO_ID_FLAG

Line 227: --, WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC

223:
224: CURSOR c_get_terr_values (ci_terr_qual_id NUMBER) IS
225: SELECT distinct j1.TERR_VALUE_ID
226: , j1.COMPARISON_OPERATOR
227: --, WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
228: --, WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
229: -- Commented for bug 8365663
230: ,decode(j2.display_type, 'CHAR'
231: ,decode(j1.id_used_flag, 'Y', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char_id, NULL)

Line 228: --, WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC

224: CURSOR c_get_terr_values (ci_terr_qual_id NUMBER) IS
225: SELECT distinct j1.TERR_VALUE_ID
226: , j1.COMPARISON_OPERATOR
227: --, WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR) LOW_VALUE_CHAR_DESC
228: --, WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR_DESC
229: -- Commented for bug 8365663
230: ,decode(j2.display_type, 'CHAR'
231: ,decode(j1.id_used_flag, 'Y', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char_id, NULL)
232: ,'N', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char, NULL), NULL)

Line 234: ,WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR))

230: ,decode(j2.display_type, 'CHAR'
231: ,decode(j1.id_used_flag, 'Y', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char_id, NULL)
232: ,'N', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char, NULL), NULL)
233: ,'DEP_2FIELDS_1CHAR_1ID', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.low_value_char, NULL)
234: ,WF_NOTIFICATION.SubstituteSpecialChars(j1.LOW_VALUE_CHAR))
235: low_value_char_desc
236:
237: ,decode(j2.display_type, 'CHAR'
238: ,jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.high_value_char, NULL)

Line 240: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR))

236:
237: ,decode(j2.display_type, 'CHAR'
238: ,jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql1, j1.high_value_char, NULL)
239: ,'DEP_2FIELDS_1CHAR_1ID', jtf_territory_pvt.get_terr_value_desc(j2.convert_to_id_flag, j2.display_type, j2.column_count, j2.display_sql2, j1.low_value_char_id, NULL)
240: , WF_NOTIFICATION.SubstituteSpecialChars(j1.HIGH_VALUE_CHAR))
241: high_value_char_desc
242: , j1.LOW_VALUE_NUMBER
243: , j1.HIGH_VALUE_NUMBER
244: -- , j1.INTEREST_TYPE_ID INTEREST_TYPE

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

249: , 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
250:
251: , j1.CURRENCY_CODE CURRENCY_DESC
252: , j1.LOW_VALUE_CHAR_ID
253: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
254: , 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),
255: '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',
256: 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',
257: 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 254: , 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),

250:
251: , j1.CURRENCY_CODE CURRENCY_DESC
252: , j1.LOW_VALUE_CHAR_ID
253: , WF_NOTIFICATION.SubstituteSpecialChars(j1.CNR_GROUP_ID) CNR_GROUP_NAME
254: , 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),
255: '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',
256: 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',
257: 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
258: , 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 258: , 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,

254: , 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),
255: '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',
256: 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',
257: 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
258: , 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,
259: 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),
260: '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
261: , 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),
262: '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 261: , 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),

257: 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
258: , 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,
259: 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),
260: '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
261: , 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),
262: '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
263: , null LOW_VALUE_DATE
264: , null HIGH_VALUE_DATE
265: , DISPLAY_TYPE

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

271: AND j1.terr_value_id is not null
272: ORDER BY j1.COMPARISON_OPERATOR;
273: -- resources
274: CURSOR c_get_resource(ci_terr_id NUMBER) IS
275: /* select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(resource_name) resource_name, resource_type, terr_rsc_id
276: from jtf_terr_resources_v jtrv
277: where jtrv.terr_id = ci_terr_id
278: order by resource_name;
279: */

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

276: from jtf_terr_resources_v jtrv
277: where jtrv.terr_id = ci_terr_id
278: order by resource_name;
279: */
280: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(
281: RESOURCE_ID , DECODE( RESOURCE_TYPE , 'RS_SUPPLIER', 'RS_SUPPLIER_CONTACT' ,
282: RESOURCE_TYPE ) )) resource_name, resource_type, terr_rsc_id
283: from JTF_TERR_RSC
284: where terr_id = ci_terr_id

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

285: order by resource_name;
286:
287: -- resource accesses
288: CURSOR c_get_rsc_access(ci_terr_rsc_id NUMBER) IS
289: select terr_rsc_access_id, access_type, WF_NOTIFICATION.SubstituteSpecialChars(meaning) meaning
290: from jtf_terr_rsc_access_v
291: where terr_rsc_id = ci_terr_rsc_id;
292:
293: lp_sysdate DATE := SYSDATE;

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

316:
317: /* arpatel 05/06/02 enh# 2109535 */
318: if p_rpt_type = 'LOOKUP_TERR' and p_param5 IS NOT NULL then
319: open terr_name_cur for
320: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
321: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
322: from jtf_terr_all j
323: where j.terr_id = p_param5;
324:

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

317: /* arpatel 05/06/02 enh# 2109535 */
318: if p_rpt_type = 'LOOKUP_TERR' and p_param5 IS NOT NULL then
319: open terr_name_cur for
320: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
321: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
322: from jtf_terr_all j
323: where j.terr_id = p_param5;
324:
325:

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

344: /* ARPATEL: 10/16, END OF bug#2832442 */
345:
346: --dbms_output.put_line('get territory by property');
347: open terr_name_cur for
348: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
349: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
350: from jtf_terr j
351: WHERE ( TRUNC(j.end_date_active) >= NVL(p_param4, lp_sysdate)
352: AND

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

345:
346: --dbms_output.put_line('get territory by property');
347: open terr_name_cur for
348: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
349: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
350: from jtf_terr j
351: WHERE ( TRUNC(j.end_date_active) >= NVL(p_param4, lp_sysdate)
352: AND
353: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)

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

374: START WITH jt.terr_id = j.terr_id ) ;
375: else
376: --dbms_output.put_line('get territory by_id mode ');
377: open terr_name_cur for
378: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
379: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
380: from jtf_terr j
381: where j.terr_id = p_param5;
382:

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

375: else
376: --dbms_output.put_line('get territory by_id mode ');
377: open terr_name_cur for
378: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
379: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
380: from jtf_terr j
381: where j.terr_id = p_param5;
382:
383: end if;

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

383: end if;
384: elsif p_rpt_type = 'CHANGES' then
385: --dbms_output.put_line('creating changes cursor ');
386: open terr_name_cur for
387: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
388: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
389: from jtf_terr j, jtf_terr_usgs jtu
390: where 1=1
391: --and j.terr_id = '19027'

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

384: elsif p_rpt_type = 'CHANGES' then
385: --dbms_output.put_line('creating changes cursor ');
386: open terr_name_cur for
387: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
388: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
389: from jtf_terr j, jtf_terr_usgs jtu
390: where 1=1
391: --and j.terr_id = '19027'
392: AND j.terr_id = jtu.terr_id