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.JTFB_PICASSO_DEMO dependencies on JTFB_TEMP_REPORT

Line 212: jtfb_temp_report_pkg.insert_row(

208: l_object := jtfb_dcf.get_parameter_value(p_context,'JTFB_P_OBJECTS');
209:
210: if (l_object = 'CAMPAIGNS')
211: then
212: jtfb_temp_report_pkg.insert_row(
213: x_rowid => l_rowid
214: , x_report_code => l_report_code
215: , x_col1 => 'TOTAL'
216: , x_col2 => 'Total'

Line 224: jtfb_temp_report_pkg.insert_row(

220: , x_col10 => '500'
221: , x_col12 => '30.37'
222: );
223:
224: jtfb_temp_report_pkg.insert_row(
225: x_rowid => l_rowid
226: , x_report_code => l_report_code
227: , x_col1 => '10'
228: , x_col2 => 'Think Customer'

Line 236: jtfb_temp_report_pkg.insert_row(

232: , x_col10 => '250'
233: , x_col12 => '35.97'
234: );
235:
236: jtfb_temp_report_pkg.insert_row(
237: x_rowid => l_rowid
238: , x_report_code => l_report_code
239: , x_col1 => '20'
240: , x_col2 => 'CRM in 90 Days'

Line 248: jtfb_temp_report_pkg.insert_row(

244: , x_col10 => '150'
245: , x_col12 => '27.77'
246: );
247:
248: jtfb_temp_report_pkg.insert_row(
249: x_rowid => l_rowid
250: , x_report_code => l_report_code
251: , x_col1 => '30'
252: , x_col2 => 'Interaction Center Push'

Line 262: insert into jtfb_temp_report(report_code, col1, col2

258: );
259:
260: elsif (l_object = 'LEADS')
261: then
262: insert into jtfb_temp_report(report_code, col1, col2
263: , col4, col6, col8, col10, col12)
264: values(l_report_code, 'TOTAL', 'Total'
265: , '466', '44','574','33','1117');
266: insert into jtfb_temp_report(report_code, col1, col2

Line 266: insert into jtfb_temp_report(report_code, col1, col2

262: insert into jtfb_temp_report(report_code, col1, col2
263: , col4, col6, col8, col10, col12)
264: values(l_report_code, 'TOTAL', 'Total'
265: , '466', '44','574','33','1117');
266: insert into jtfb_temp_report(report_code, col1, col2
267: , col4, col6, col8, col10, col12)
268: values(l_report_code, '10', 'France'
269: , '116','11','123','4','254');
270: insert into jtfb_temp_report(report_code, col1, col2

Line 270: insert into jtfb_temp_report(report_code, col1, col2

266: insert into jtfb_temp_report(report_code, col1, col2
267: , col4, col6, col8, col10, col12)
268: values(l_report_code, '10', 'France'
269: , '116','11','123','4','254');
270: insert into jtfb_temp_report(report_code, col1, col2
271: , col4, col6, col8, col10, col12)
272: values(l_report_code, '20', 'Canada'
273: , '120','10','151','6','287');
274: insert into jtfb_temp_report(report_code, col1, col2

Line 274: insert into jtfb_temp_report(report_code, col1, col2

270: insert into jtfb_temp_report(report_code, col1, col2
271: , col4, col6, col8, col10, col12)
272: values(l_report_code, '20', 'Canada'
273: , '120','10','151','6','287');
274: insert into jtfb_temp_report(report_code, col1, col2
275: , col4, col6, col8, col10, col12)
276: values(l_report_code, '30', 'UK'
277: , '90','8','140','8','246');
278: insert into jtfb_temp_report(report_code, col1, col2

Line 278: insert into jtfb_temp_report(report_code, col1, col2

274: insert into jtfb_temp_report(report_code, col1, col2
275: , col4, col6, col8, col10, col12)
276: values(l_report_code, '30', 'UK'
277: , '90','8','140','8','246');
278: insert into jtfb_temp_report(report_code, col1, col2
279: , col4, col6, col8, col10, col12)
280: values(l_report_code, '40', 'US'
281: , '140','15','160','15','330');
282:

Line 285: insert into jtfb_temp_report(report_code, col1, col2

281: , '140','15','160','15','330');
282:
283: elsif (l_object = 'OPPORTUNITIES')
284: then
285: insert into jtfb_temp_report(report_code, col1, col2
286: , col4, col6, col8, col10, col12)
287: values(l_report_code, 'TOTAL', 'Total', '20'
288: , '21','49','59','149');
289: insert into jtfb_temp_report(report_code, col1, col2

Line 289: insert into jtfb_temp_report(report_code, col1, col2

285: insert into jtfb_temp_report(report_code, col1, col2
286: , col4, col6, col8, col10, col12)
287: values(l_report_code, 'TOTAL', 'Total', '20'
288: , '21','49','59','149');
289: insert into jtfb_temp_report(report_code, col1, col2
290: , col4, col6, col8, col10, col12)
291: values(l_report_code, '10', 'US Defense'
292: , '9','10','22','24','65');
293: insert into jtfb_temp_report(report_code, col1, col2

Line 293: insert into jtfb_temp_report(report_code, col1, col2

289: insert into jtfb_temp_report(report_code, col1, col2
290: , col4, col6, col8, col10, col12)
291: values(l_report_code, '10', 'US Defense'
292: , '9','10','22','24','65');
293: insert into jtfb_temp_report(report_code, col1, col2
294: , col4, col6, col8, col10, col12)
295: values(l_report_code, '20', 'Drainage Canal'
296: , '5','3','12','14','34');
297: insert into jtfb_temp_report(report_code, col1, col2

Line 297: insert into jtfb_temp_report(report_code, col1, col2

293: insert into jtfb_temp_report(report_code, col1, col2
294: , col4, col6, col8, col10, col12)
295: values(l_report_code, '20', 'Drainage Canal'
296: , '5','3','12','14','34');
297: insert into jtfb_temp_report(report_code, col1, col2
298: , col4, col6, col8, col10, col12)
299: values(l_report_code, '30', 'Water and Sanitary'
300: , '6','8','15','21','50');
301:

Line 304: insert into jtfb_temp_report(report_code, col1, col2

300: , '6','8','15','21','50');
301:
302: elsif (l_object = 'QUOTES')
303: then
304: insert into jtfb_temp_report(report_code, col1, col2
305: , col4, col6, col8, col10, col12)
306: values(l_report_code, 'TOTAL', 'Total'
307: , '42', '72','107','121','343');
308: insert into jtfb_temp_report(report_code, col1, col2

Line 308: insert into jtfb_temp_report(report_code, col1, col2

304: insert into jtfb_temp_report(report_code, col1, col2
305: , col4, col6, col8, col10, col12)
306: values(l_report_code, 'TOTAL', 'Total'
307: , '42', '72','107','121','343');
308: insert into jtfb_temp_report(report_code, col1, col2
309: , col4, col6, col8, col10, col12)
310: values(l_report_code, '10', 'Oracle Australia'
311: , '15','20','40','43','118');
312: insert into jtfb_temp_report(report_code, col1, col2

Line 312: insert into jtfb_temp_report(report_code, col1, col2

308: insert into jtfb_temp_report(report_code, col1, col2
309: , col4, col6, col8, col10, col12)
310: values(l_report_code, '10', 'Oracle Australia'
311: , '15','20','40','43','118');
312: insert into jtfb_temp_report(report_code, col1, col2
313: , col4, col6, col8, col10, col12)
314: values(l_report_code, '20', 'Oracle Argentina'
315: , '5','10','12','16','43');
316: insert into jtfb_temp_report(report_code, col1, col2

Line 316: insert into jtfb_temp_report(report_code, col1, col2

312: insert into jtfb_temp_report(report_code, col1, col2
313: , col4, col6, col8, col10, col12)
314: values(l_report_code, '20', 'Oracle Argentina'
315: , '5','10','12','16','43');
316: insert into jtfb_temp_report(report_code, col1, col2
317: , col4, col6, col8, col10, col12)
318: values(l_report_code, '30', 'Oracle Canada'
319: , '22','42','55','62','182');
320:

Line 323: insert into jtfb_temp_report(report_code, col1, col2

319: , '22','42','55','62','182');
320:
321: elsif (l_object = 'CUSTOMERS')
322: then
323: insert into jtfb_temp_report(report_code, col1, col2
324: , col4, col6, col8, col10, col12)
325: values(l_report_code, 'TOTAL', 'Total'
326: , '448', '520','200','363','30.37');
327: insert into jtfb_temp_report(report_code, col1, col2

Line 327: insert into jtfb_temp_report(report_code, col1, col2

323: insert into jtfb_temp_report(report_code, col1, col2
324: , col4, col6, col8, col10, col12)
325: values(l_report_code, 'TOTAL', 'Total'
326: , '448', '520','200','363','30.37');
327: insert into jtfb_temp_report(report_code, col1, col2
328: , col4, col6, col8, col10, col12)
329: values(l_report_code, '10', 'Compaq'
330: ,'50', '60','110','150','370');
331: insert into jtfb_temp_report(report_code, col1, col2

Line 331: insert into jtfb_temp_report(report_code, col1, col2

327: insert into jtfb_temp_report(report_code, col1, col2
328: , col4, col6, col8, col10, col12)
329: values(l_report_code, '10', 'Compaq'
330: ,'50', '60','110','150','370');
331: insert into jtfb_temp_report(report_code, col1, col2
332: , col4, col6, col8, col10, col12)
333: values(l_report_code, '20', 'Xerox'
334: ,'70', '50','130','150','400');
335: insert into jtfb_temp_report(report_code, col1, col2

Line 335: insert into jtfb_temp_report(report_code, col1, col2

331: insert into jtfb_temp_report(report_code, col1, col2
332: , col4, col6, col8, col10, col12)
333: values(l_report_code, '20', 'Xerox'
334: ,'70', '50','130','150','400');
335: insert into jtfb_temp_report(report_code, col1, col2
336: , col4, col6, col8, col10, col12)
337: values(l_report_code, '30', 'GE Medical'
338: ,'45', '80','140','240','505');
339: insert into jtfb_temp_report(report_code, col1, col2

Line 339: insert into jtfb_temp_report(report_code, col1, col2

335: insert into jtfb_temp_report(report_code, col1, col2
336: , col4, col6, col8, col10, col12)
337: values(l_report_code, '30', 'GE Medical'
338: ,'45', '80','140','240','505');
339: insert into jtfb_temp_report(report_code, col1, col2
340: , col4, col6, col8, col10, col12)
341: values(l_report_code, '30', 'HP'
342: ,'45', '80','140','140','405');
343: insert into jtfb_temp_report(report_code, col1, col2

Line 343: insert into jtfb_temp_report(report_code, col1, col2

339: insert into jtfb_temp_report(report_code, col1, col2
340: , col4, col6, col8, col10, col12)
341: values(l_report_code, '30', 'HP'
342: ,'45', '80','140','140','405');
343: insert into jtfb_temp_report(report_code, col1, col2
344: , col4, col6, col8, col10, col12)
345: values(l_report_code, '30', 'Papa Jones'
346: ,'70', '80','140','280','570');
347:

Line 349: insert into jtfb_temp_report(report_code, col1, col2

345: values(l_report_code, '30', 'Papa Jones'
346: ,'70', '80','140','280','570');
347:
348: else
349: insert into jtfb_temp_report(report_code, col1, col2
350: , col4, col6, col8, col10, col12)
351: values(l_report_code, 'TOTAL', 'Total'
352: , '514', '648','484','500','30.37');
353: insert into jtfb_temp_report(report_code, col1, col2

Line 353: insert into jtfb_temp_report(report_code, col1, col2

349: insert into jtfb_temp_report(report_code, col1, col2
350: , col4, col6, col8, col10, col12)
351: values(l_report_code, 'TOTAL', 'Total'
352: , '514', '648','484','500','30.37');
353: insert into jtfb_temp_report(report_code, col1, col2
354: , col4, col6, col8, col10, col12)
355: values(l_report_code, '10', 'Think Customer'
356: , '200','327','168','250','35.97');
357: insert into jtfb_temp_report(report_code, col1, col2

Line 357: insert into jtfb_temp_report(report_code, col1, col2

353: insert into jtfb_temp_report(report_code, col1, col2
354: , col4, col6, col8, col10, col12)
355: values(l_report_code, '10', 'Think Customer'
356: , '200','327','168','250','35.97');
357: insert into jtfb_temp_report(report_code, col1, col2
358: , col4, col6, col8, col10, col12)
359: values(l_report_code, '20', 'CRM in 90 Days'
360: , '150','260','130','150','27.77');
361: insert into jtfb_temp_report(report_code, col1, col2

Line 361: insert into jtfb_temp_report(report_code, col1, col2

357: insert into jtfb_temp_report(report_code, col1, col2
358: , col4, col6, col8, col10, col12)
359: values(l_report_code, '20', 'CRM in 90 Days'
360: , '150','260','130','150','27.77');
361: insert into jtfb_temp_report(report_code, col1, col2
362: , col4, col6, col8, col10, col12)
363: values(l_report_code, '30', 'Interaction Center Push'
364: , '400','345','140','365','41.24');
365: end if;