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.BIV_CORE_PKG dependencies on BIV_CORE_PKG

Line 1: package body biv_core_pkg as

1: package body biv_core_pkg as
2: /* $Header: bivcoreb.pls 115.45 2004/04/06 06:20:10 nbhamidi ship $ */
3: function get_lookup_meaning(p_lookup_code varchar2) return varchar2 is
4: l_meaning fnd_lookups.meaning % type;
5: begin

Line 22: l_value_str := biv_core_pkg.get_parameter_value(p_param_str,

18: l_value_count number;
19: l_value_str varchar2(500);
20: i number;
21: begin
22: l_value_str := biv_core_pkg.get_parameter_value(p_param_str,
23: p_param_name,
24: g_param_sep,
25: g_value_sep);
26:

Line 28: biv_core_pkg.biv_debug('Param:'||p_param_str,g_report_id);

24: g_param_sep,
25: g_value_sep);
26:
27: /*
28: biv_core_pkg.biv_debug('Param:'||p_param_str,g_report_id);
29: biv_core_pkg.biv_debug( 'Values String for Param:'||p_param_name ||
30: '---->' || nvl(l_value_str,'NULL'),g_report_id);
31: commit;
32: */

Line 29: biv_core_pkg.biv_debug( 'Values String for Param:'||p_param_name ||

25: g_value_sep);
26:
27: /*
28: biv_core_pkg.biv_debug('Param:'||p_param_str,g_report_id);
29: biv_core_pkg.biv_debug( 'Values String for Param:'||p_param_name ||
30: '---->' || nvl(l_value_str,'NULL'),g_report_id);
31: commit;
32: */
33: if (nvl(l_value_str,'NOT_FOUND') <> 'NOT_FOUND' ) then

Line 37: biv_core_pkg.biv_debug('Total Value for :'||p_param_name ||

33: if (nvl(l_value_str,'NOT_FOUND') <> 'NOT_FOUND' ) then
34: p_total_values := jtfb_dcf.get_multiselect_count(l_value_str,
35: g_multi_value_sep);
36: /***
37: biv_core_pkg.biv_debug('Total Value for :'||p_param_name ||
38: ' : ' ||to_char(p_total_values),g_report_id);
39: ****/
40: if (p_total_values > 100) then
41: --dbms_output.put_line('Two Many Values for :'|| p_param_name);

Line 43: biv_core_pkg.biv_debug('Too many values for :'||p_param_name ||

39: ****/
40: if (p_total_values > 100) then
41: --dbms_output.put_line('Two Many Values for :'|| p_param_name);
42: if (g_debug = 'Y') then
43: biv_core_pkg.biv_debug('Too many values for :'||p_param_name ||
44: ' : ' ||to_char(p_total_values),g_report_id);
45: end if;
46: else
47: for i in 1..p_total_values loop

Line 107: biv_core_pkg.biv_debug ('Parameter value at index:'||

103: p_param_values(i)
104: );
105: */
106: if (l_debug = 'Y') then
107: biv_core_pkg.biv_debug ('Parameter value at index:'||
108: to_char(i) || ' is:'||
109: p_param_values(i), g_report_id
110: );
111: end if;

Line 279: biv_core_pkg.biv_debug('Saturday in nls Lang:' || l_sat, g_report_id);

275: l_sat varchar2(80);
276: begin
277: l_sat := to_char(to_date('01/01/2000','dd/mm/yyyy'),'dy');
278: if (g_debug = 'Y') then
279: biv_core_pkg.biv_debug('Saturday in nls Lang:' || l_sat, g_report_id);
280: end if;
281: x_date := next_day(sysdate,l_sat) - 13;
282: x_start_date := to_date(to_char(x_date,'dd-mon-yyyy') || ' 00:00:00',
283: 'dd-mon-yyyy hh24:mi:ss');

Line 335: biv_core_pkg.get_parameter_values_all(g_cust_id ,

331: g_platform_id_cnt := 0;
332: g_sts_id_cnt := 0;
333: g_debug := fnd_profile.value('BIV:DEBUG');
334: --g_srl_no := 1;
335: biv_core_pkg.get_parameter_values_all(g_cust_id ,
336: g_cust_id_cnt ,
337: p_param_str ,
338: 'P_CUST_ID');
339: biv_core_pkg.get_parameter_values_all(g_cntr_id ,

Line 339: biv_core_pkg.get_parameter_values_all(g_cntr_id ,

335: biv_core_pkg.get_parameter_values_all(g_cust_id ,
336: g_cust_id_cnt ,
337: p_param_str ,
338: 'P_CUST_ID');
339: biv_core_pkg.get_parameter_values_all(g_cntr_id ,
340: g_cntr_id_cnt ,
341: p_param_str ,
342: 'P_CNTR_ID');
343: biv_core_pkg.get_parameter_values_all(g_ogrp ,

Line 343: biv_core_pkg.get_parameter_values_all(g_ogrp ,

339: biv_core_pkg.get_parameter_values_all(g_cntr_id ,
340: g_cntr_id_cnt ,
341: p_param_str ,
342: 'P_CNTR_ID');
343: biv_core_pkg.get_parameter_values_all(g_ogrp ,
344: g_ogrp_cnt ,
345: p_param_str ,
346: 'P_OGRP');
347: biv_core_pkg.get_parameter_values_all(g_agrp ,

Line 347: biv_core_pkg.get_parameter_values_all(g_agrp ,

343: biv_core_pkg.get_parameter_values_all(g_ogrp ,
344: g_ogrp_cnt ,
345: p_param_str ,
346: 'P_OGRP');
347: biv_core_pkg.get_parameter_values_all(g_agrp ,
348: g_agrp_cnt ,
349: p_param_str ,
350: 'P_AGRP');
351: biv_core_pkg.get_parameter_values_all(g_prd_id ,

Line 351: biv_core_pkg.get_parameter_values_all(g_prd_id ,

347: biv_core_pkg.get_parameter_values_all(g_agrp ,
348: g_agrp_cnt ,
349: p_param_str ,
350: 'P_AGRP');
351: biv_core_pkg.get_parameter_values_all(g_prd_id ,
352: g_prd_id_cnt ,
353: p_param_str ,
354: 'P_PRD_ID');
355: biv_core_pkg.get_parameter_values_all(g_sev ,

Line 355: biv_core_pkg.get_parameter_values_all(g_sev ,

351: biv_core_pkg.get_parameter_values_all(g_prd_id ,
352: g_prd_id_cnt ,
353: p_param_str ,
354: 'P_PRD_ID');
355: biv_core_pkg.get_parameter_values_all(g_sev ,
356: g_sev_cnt ,
357: p_param_str ,
358: 'P_SEV');
359: biv_core_pkg.get_parameter_values_all(g_esc_lvl ,

Line 359: biv_core_pkg.get_parameter_values_all(g_esc_lvl ,

355: biv_core_pkg.get_parameter_values_all(g_sev ,
356: g_sev_cnt ,
357: p_param_str ,
358: 'P_SEV');
359: biv_core_pkg.get_parameter_values_all(g_esc_lvl ,
360: g_esc_lvl_cnt ,
361: p_param_str ,
362: 'P_ESC_LVL');
363: biv_core_pkg.get_parameter_values_all(g_prd_ver ,

Line 363: biv_core_pkg.get_parameter_values_all(g_prd_ver ,

359: biv_core_pkg.get_parameter_values_all(g_esc_lvl ,
360: g_esc_lvl_cnt ,
361: p_param_str ,
362: 'P_ESC_LVL');
363: biv_core_pkg.get_parameter_values_all(g_prd_ver ,
364: g_prd_ver_cnt ,
365: p_param_str ,
366: 'P_PRD_VER');
367: biv_core_pkg.get_parameter_values_all(g_comp_id ,

Line 367: biv_core_pkg.get_parameter_values_all(g_comp_id ,

363: biv_core_pkg.get_parameter_values_all(g_prd_ver ,
364: g_prd_ver_cnt ,
365: p_param_str ,
366: 'P_PRD_VER');
367: biv_core_pkg.get_parameter_values_all(g_comp_id ,
368: g_comp_id_cnt ,
369: p_param_str ,
370: 'P_COMP_ID');
371: biv_core_pkg.get_parameter_values_all(g_subcomp_id ,

Line 371: biv_core_pkg.get_parameter_values_all(g_subcomp_id ,

367: biv_core_pkg.get_parameter_values_all(g_comp_id ,
368: g_comp_id_cnt ,
369: p_param_str ,
370: 'P_COMP_ID');
371: biv_core_pkg.get_parameter_values_all(g_subcomp_id ,
372: g_subcomp_id_cnt ,
373: p_param_str ,
374: 'P_SUBCOMP_ID');
375: biv_core_pkg.get_parameter_values_all(g_platform_id ,

Line 375: biv_core_pkg.get_parameter_values_all(g_platform_id ,

371: biv_core_pkg.get_parameter_values_all(g_subcomp_id ,
372: g_subcomp_id_cnt ,
373: p_param_str ,
374: 'P_SUBCOMP_ID');
375: biv_core_pkg.get_parameter_values_all(g_platform_id ,
376: g_platform_id_cnt ,
377: p_param_str ,
378: 'P_PLATFORM_ID');
379: biv_core_pkg.get_parameter_values_all(g_sts_id ,

Line 379: biv_core_pkg.get_parameter_values_all(g_sts_id ,

375: biv_core_pkg.get_parameter_values_all(g_platform_id ,
376: g_platform_id_cnt ,
377: p_param_str ,
378: 'P_PLATFORM_ID');
379: biv_core_pkg.get_parameter_values_all(g_sts_id ,
380: g_sts_id_cnt ,
381: p_param_str ,
382: 'P_STS_ID');
383: biv_core_pkg.get_parameter_values_all(g_mgr_id ,

Line 383: biv_core_pkg.get_parameter_values_all(g_mgr_id ,

379: biv_core_pkg.get_parameter_values_all(g_sts_id ,
380: g_sts_id_cnt ,
381: p_param_str ,
382: 'P_STS_ID');
383: biv_core_pkg.get_parameter_values_all(g_mgr_id ,
384: g_mgr_id_cnt ,
385: p_param_str ,
386: 'P_MGR_ID');
387: biv_core_pkg.get_parameter_values_all(g_site_id ,

Line 387: biv_core_pkg.get_parameter_values_all(g_site_id ,

383: biv_core_pkg.get_parameter_values_all(g_mgr_id ,
384: g_mgr_id_cnt ,
385: p_param_str ,
386: 'P_MGR_ID');
387: biv_core_pkg.get_parameter_values_all(g_site_id ,
388: g_site_id_cnt ,
389: p_param_str ,
390: 'P_SITE_ID');
391:

Line 393: g_rsc := biv_core_pkg.get_parameter_value(p_param_str, 'P_RSC');

389: p_param_str ,
390: 'P_SITE_ID');
391:
392: -- get all parameters which return single value
393: g_rsc := biv_core_pkg.get_parameter_value(p_param_str, 'P_RSC');
394: g_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_BLOG');
395: g_other_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTHER_BLOG');
396: g_chnl := biv_core_pkg.get_parameter_value(p_param_str, 'P_CHNL');
397: -- Change for bug 3093779 starts

Line 394: g_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_BLOG');

390: 'P_SITE_ID');
391:
392: -- get all parameters which return single value
393: g_rsc := biv_core_pkg.get_parameter_value(p_param_str, 'P_RSC');
394: g_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_BLOG');
395: g_other_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTHER_BLOG');
396: g_chnl := biv_core_pkg.get_parameter_value(p_param_str, 'P_CHNL');
397: -- Change for bug 3093779 starts
398: g_ua := biv_core_pkg.get_parameter_value(p_param_str,'P_UA');

Line 395: g_other_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTHER_BLOG');

391:
392: -- get all parameters which return single value
393: g_rsc := biv_core_pkg.get_parameter_value(p_param_str, 'P_RSC');
394: g_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_BLOG');
395: g_other_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTHER_BLOG');
396: g_chnl := biv_core_pkg.get_parameter_value(p_param_str, 'P_CHNL');
397: -- Change for bug 3093779 starts
398: g_ua := biv_core_pkg.get_parameter_value(p_param_str,'P_UA');
399:

Line 396: g_chnl := biv_core_pkg.get_parameter_value(p_param_str, 'P_CHNL');

392: -- get all parameters which return single value
393: g_rsc := biv_core_pkg.get_parameter_value(p_param_str, 'P_RSC');
394: g_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_BLOG');
395: g_other_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTHER_BLOG');
396: g_chnl := biv_core_pkg.get_parameter_value(p_param_str, 'P_CHNL');
397: -- Change for bug 3093779 starts
398: g_ua := biv_core_pkg.get_parameter_value(p_param_str,'P_UA');
399:
400: if (g_ua is null) then

Line 398: g_ua := biv_core_pkg.get_parameter_value(p_param_str,'P_UA');

394: g_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_BLOG');
395: g_other_blog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTHER_BLOG');
396: g_chnl := biv_core_pkg.get_parameter_value(p_param_str, 'P_CHNL');
397: -- Change for bug 3093779 starts
398: g_ua := biv_core_pkg.get_parameter_value(p_param_str,'P_UA');
399:
400: if (g_ua is null) then
401: g_ua := 'Y';
402: end if;

Line 404: g_pr := biv_core_pkg.get_parameter_value(p_param_str,'P_PREVR');

400: if (g_ua is null) then
401: g_ua := 'Y';
402: end if;
403:
404: g_pr := biv_core_pkg.get_parameter_value(p_param_str,'P_PREVR');
405:
406: if(g_pr is null) then
407: g_pr := 'N';
408: end if;

Line 413: g_total := biv_core_pkg.get_parameter_value(p_param_str,'P_TOTAL');

409:
410: -- Change for bug 3093779 ends
411:
412: -- Change for enh 2914005 starts
413: g_total := biv_core_pkg.get_parameter_value(p_param_str,'P_TOTAL');
414:
415: if (g_total is null) then
416: g_total := 'N';
417: end if;

Line 424: g_resl_code := biv_core_pkg.get_parameter_value(p_param_str, 'P_RESL_CODE');

420:
421: if (g_chnl = 'ALL') then
422: g_chnl := null;
423: end if;
424: g_resl_code := biv_core_pkg.get_parameter_value(p_param_str, 'P_RESL_CODE');
425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');
426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');

Line 425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');

421: if (g_chnl = 'ALL') then
422: g_chnl := null;
423: end if;
424: g_resl_code := biv_core_pkg.get_parameter_value(p_param_str, 'P_RESL_CODE');
425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');
426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');

Line 426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');

422: g_chnl := null;
423: end if;
424: g_resl_code := biv_core_pkg.get_parameter_value(p_param_str, 'P_RESL_CODE');
425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');
426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');

Line 427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');

423: end if;
424: g_resl_code := biv_core_pkg.get_parameter_value(p_param_str, 'P_RESL_CODE');
425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');
426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');

Line 428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');

424: g_resl_code := biv_core_pkg.get_parameter_value(p_param_str, 'P_RESL_CODE');
425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');
426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');

Line 429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');

425: g_arvl_tm := biv_core_pkg.get_parameter_value(p_param_str, 'P_ARVL_TM');
426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');

Line 430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');

426: g_close_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_CLOSE_SR');
427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');

Line 431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');

427: g_oblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_OBLOG');
428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');

Line 432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');

428: g_eblog := biv_core_pkg.get_parameter_value(p_param_str, 'P_EBLOG');
429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');

Line 433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');

429: g_reopen := biv_core_pkg.get_parameter_value(p_param_str, 'P_REOPEN');
430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');

Line 434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');

430: g_reclose := biv_core_pkg.get_parameter_value(p_param_str, 'P_RECLOSE');
431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');
438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');

Line 435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');

431: g_new_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_NEW_SR');
432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');
438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');
439: g_st_date := to_date(l_dt,l_dt_fmt);

Line 436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');

432: g_agent_id := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGENT_ID');
433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');
438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');
439: g_st_date := to_date(l_dt,l_dt_fmt);
440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');

Line 437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');

433: g_today_only := biv_core_pkg.get_parameter_value(p_param_str, 'P_TODAY_ONLY');
434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');
438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');
439: g_st_date := to_date(l_dt,l_dt_fmt);
440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');
441: g_end_date := to_date(l_dt,l_dt_fmt);

Line 438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');

434: g_tm_zn := biv_core_pkg.get_parameter_value(p_param_str, 'P_TM_ZN');
435: g_ott := biv_core_pkg.get_parameter_value(p_param_str, 'P_OTT');
436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');
438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');
439: g_st_date := to_date(l_dt,l_dt_fmt);
440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');
441: g_end_date := to_date(l_dt,l_dt_fmt);
442: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_ST');

Line 440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');

436: g_unown := biv_core_pkg.get_parameter_value(p_param_str, 'P_UNOWN');
437: g_esc_sr := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_SR');
438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');
439: g_st_date := to_date(l_dt,l_dt_fmt);
440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');
441: g_end_date := to_date(l_dt,l_dt_fmt);
442: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_ST');
443: g_cr_st := to_date(l_dt,l_dt_fmt);
444: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_END');

Line 442: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_ST');

438: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ST_DATE');
439: g_st_date := to_date(l_dt,l_dt_fmt);
440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');
441: g_end_date := to_date(l_dt,l_dt_fmt);
442: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_ST');
443: g_cr_st := to_date(l_dt,l_dt_fmt);
444: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_END');
445: g_cr_end := to_date(l_dt,l_dt_fmt);
446: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_ST');

Line 444: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_END');

440: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_END_DATE');
441: g_end_date := to_date(l_dt,l_dt_fmt);
442: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_ST');
443: g_cr_st := to_date(l_dt,l_dt_fmt);
444: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_END');
445: g_cr_end := to_date(l_dt,l_dt_fmt);
446: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_ST');
447: g_cl_st := to_date(l_dt,l_dt_fmt);
448: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_END');

Line 446: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_ST');

442: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_ST');
443: g_cr_st := to_date(l_dt,l_dt_fmt);
444: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_END');
445: g_cr_end := to_date(l_dt,l_dt_fmt);
446: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_ST');
447: g_cl_st := to_date(l_dt,l_dt_fmt);
448: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_END');
449: g_cl_end := to_date(l_dt,l_dt_fmt);
450: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_ST');

Line 448: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_END');

444: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CR_END');
445: g_cr_end := to_date(l_dt,l_dt_fmt);
446: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_ST');
447: g_cl_st := to_date(l_dt,l_dt_fmt);
448: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_END');
449: g_cl_end := to_date(l_dt,l_dt_fmt);
450: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_ST');
451: g_esc_st := to_date(l_dt,l_dt_fmt);
452: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_END');

Line 450: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_ST');

446: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_ST');
447: g_cl_st := to_date(l_dt,l_dt_fmt);
448: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_END');
449: g_cl_end := to_date(l_dt,l_dt_fmt);
450: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_ST');
451: g_esc_st := to_date(l_dt,l_dt_fmt);
452: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_END');
453: g_esc_end := to_date(l_dt,l_dt_fmt);
454:

Line 452: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_END');

448: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_CL_END');
449: g_cl_end := to_date(l_dt,l_dt_fmt);
450: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_ST');
451: g_esc_st := to_date(l_dt,l_dt_fmt);
452: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_END');
453: g_esc_end := to_date(l_dt,l_dt_fmt);
454:
455: g_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_LVL');
456: g_agrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGRP_LVL');

Line 455: g_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_LVL');

451: g_esc_st := to_date(l_dt,l_dt_fmt);
452: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_END');
453: g_esc_end := to_date(l_dt,l_dt_fmt);
454:
455: g_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_LVL');
456: g_agrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGRP_LVL');
457: g_ogrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_OGRP_LVL');
458: g_srt_by := biv_core_pkg.get_parameter_value(p_param_str,'P_SRT_BY');
459: if (g_srt_by is null) then

Line 456: g_agrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGRP_LVL');

452: l_dt := biv_core_pkg.get_parameter_value(p_param_str, 'P_ESC_END');
453: g_esc_end := to_date(l_dt,l_dt_fmt);
454:
455: g_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_LVL');
456: g_agrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGRP_LVL');
457: g_ogrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_OGRP_LVL');
458: g_srt_by := biv_core_pkg.get_parameter_value(p_param_str,'P_SRT_BY');
459: if (g_srt_by is null) then
460: g_srt_by := '2';

Line 457: g_ogrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_OGRP_LVL');

453: g_esc_end := to_date(l_dt,l_dt_fmt);
454:
455: g_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_LVL');
456: g_agrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGRP_LVL');
457: g_ogrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_OGRP_LVL');
458: g_srt_by := biv_core_pkg.get_parameter_value(p_param_str,'P_SRT_BY');
459: if (g_srt_by is null) then
460: g_srt_by := '2';
461: end if;

Line 458: g_srt_by := biv_core_pkg.get_parameter_value(p_param_str,'P_SRT_BY');

454:
455: g_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_LVL');
456: g_agrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_AGRP_LVL');
457: g_ogrp_lvl := biv_core_pkg.get_parameter_value(p_param_str, 'P_OGRP_LVL');
458: g_srt_by := biv_core_pkg.get_parameter_value(p_param_str,'P_SRT_BY');
459: if (g_srt_by is null) then
460: g_srt_by := '2';
461: end if;
462: g_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');

Line 462: g_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');

458: g_srt_by := biv_core_pkg.get_parameter_value(p_param_str,'P_SRT_BY');
459: if (g_srt_by is null) then
460: g_srt_by := '2';
461: end if;
462: g_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');
463: if (g_view_by is null ) then
464: if (g_report_id in ('BIV_RT_MANAGER_REPORT',
465: 'BIV_RT_BACKLOG_BY_STATUS','BIV_HS_SR_ACTIVITY',
466: 'BIV_RT_ESC_SR',

Line 471: biv_core_pkg.biv_debug('No default view by for the report '||

467: 'BIV_HS_SR_ESCALATION', 'BIV_RT_TASK_ACTIVITY')
468: )then
469: g_view_by := 'MGR';
470: elsif (g_debug = 'Y') then
471: biv_core_pkg.biv_debug('No default view by for the report '||
472: g_report_id, g_report_id);
473: end if;
474: end if;
475: if (g_debug = 'Y') then

Line 476: biv_core_pkg.biv_debug('Report Id:'||g_report_id,g_report_id);

472: g_report_id, g_report_id);
473: end if;
474: end if;
475: if (g_debug = 'Y') then
476: biv_core_pkg.biv_debug('Report Id:'||g_report_id,g_report_id);
477: end if;
478: g_disp := biv_core_pkg.get_parameter_value(p_param_str,'P_DISP');
479: if (g_disp is null) then
480: g_disp := 10;

Line 478: g_disp := biv_core_pkg.get_parameter_value(p_param_str,'P_DISP');

474: end if;
475: if (g_debug = 'Y') then
476: biv_core_pkg.biv_debug('Report Id:'||g_report_id,g_report_id);
477: end if;
478: g_disp := biv_core_pkg.get_parameter_value(p_param_str,'P_DISP');
479: if (g_disp is null) then
480: g_disp := 10;
481: elsif (upper(g_disp) = 'ALL') then
482: g_disp := '5000';

Line 488: g_time_frame := biv_core_pkg.get_parameter_value(p_param_str,'P_TIME_FRAME');

484: else
485: g_display := substr(g_display,2);
486: ***/
487: end if;
488: g_time_frame := biv_core_pkg.get_parameter_value(p_param_str,'P_TIME_FRAME');
489: g_cr_tm_prd :=
490: biv_core_pkg.get_parameter_value(p_param_str,'P_CR_TM_PRD');
491: g_cl_tm_prd :=
492: biv_core_pkg.get_parameter_value(p_param_str,'P_CL_TM_PRD');

Line 490: biv_core_pkg.get_parameter_value(p_param_str,'P_CR_TM_PRD');

486: ***/
487: end if;
488: g_time_frame := biv_core_pkg.get_parameter_value(p_param_str,'P_TIME_FRAME');
489: g_cr_tm_prd :=
490: biv_core_pkg.get_parameter_value(p_param_str,'P_CR_TM_PRD');
491: g_cl_tm_prd :=
492: biv_core_pkg.get_parameter_value(p_param_str,'P_CL_TM_PRD');
493: g_esc_tm_prd :=
494: biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_TM_PRD');

Line 492: biv_core_pkg.get_parameter_value(p_param_str,'P_CL_TM_PRD');

488: g_time_frame := biv_core_pkg.get_parameter_value(p_param_str,'P_TIME_FRAME');
489: g_cr_tm_prd :=
490: biv_core_pkg.get_parameter_value(p_param_str,'P_CR_TM_PRD');
491: g_cl_tm_prd :=
492: biv_core_pkg.get_parameter_value(p_param_str,'P_CL_TM_PRD');
493: g_esc_tm_prd :=
494: biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_TM_PRD');
495:
496: -- get base column for query

Line 494: biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_TM_PRD');

490: biv_core_pkg.get_parameter_value(p_param_str,'P_CR_TM_PRD');
491: g_cl_tm_prd :=
492: biv_core_pkg.get_parameter_value(p_param_str,'P_CL_TM_PRD');
493: g_esc_tm_prd :=
494: biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_TM_PRD');
495:
496: -- get base column for query
497: if ( g_view_by ='AGRP') then
498: g_base_column := 'adnorm.parent_group_id';

Line 524: biv_core_pkg.get_dates(g_time_frame, g_st_date, g_end_date);

520:
521: -- set start and end dates based on time frame
522: if (g_time_frame is not null and
523: (g_st_date is null or g_end_date is null)) then
524: biv_core_pkg.get_dates(g_time_frame, g_st_date, g_end_date);
525: end if;
526: if (g_cr_tm_prd is not null and
527: (g_cr_st is null or g_cr_end is null) ) then
528: biv_core_pkg.get_dates(g_cr_tm_prd,

Line 528: biv_core_pkg.get_dates(g_cr_tm_prd,

524: biv_core_pkg.get_dates(g_time_frame, g_st_date, g_end_date);
525: end if;
526: if (g_cr_tm_prd is not null and
527: (g_cr_st is null or g_cr_end is null) ) then
528: biv_core_pkg.get_dates(g_cr_tm_prd,
529: g_cr_st, g_cr_end);
530: end if;
531: if (g_cl_tm_prd is not null and
532: (g_cl_st is null or g_cl_end is null)) then

Line 533: biv_core_pkg.get_dates(g_cl_tm_prd,

529: g_cr_st, g_cr_end);
530: end if;
531: if (g_cl_tm_prd is not null and
532: (g_cl_st is null or g_cl_end is null)) then
533: biv_core_pkg.get_dates(g_cl_tm_prd,
534: g_cl_st, g_cl_end);
535: end if;
536: if (g_esc_tm_prd is not null and
537: (g_esc_st is null or g_esc_end is null)) then

Line 538: biv_core_pkg.get_dates(g_esc_tm_prd, g_esc_st, g_esc_end);

534: g_cl_st, g_cl_end);
535: end if;
536: if (g_esc_tm_prd is not null and
537: (g_esc_st is null or g_esc_end is null)) then
538: biv_core_pkg.get_dates(g_esc_tm_prd, g_esc_st, g_esc_end);
539: g_esc_st := trunc(g_esc_st );
540: g_esc_end := trunc(g_esc_end);
541: end if;
542: exception

Line 550: p_param_array biv_core_pkg.g_parameter_array,

546: end if;
547: end;
548: ------------------------------------------------------------
549: procedure add_a_bind(p_cursor number,
550: p_param_array biv_core_pkg.g_parameter_array,
551: p_param_array_size number,
552: p_prefix varchar2,
553: p_column_name varchar2) is
554: l_bind_var_name varchar2(80);

Line 563: if (p_param_array(1) <> biv_core_pkg.g_null) then

559: ',Count:'||to_char(p_param_array_size));
560: ***********************************************/
561: l_bind_var_name := ':'||p_prefix||'_'||p_column_name;
562: if (p_param_array_size = 1) then
563: if (p_param_array(1) <> biv_core_pkg.g_null) then
564: dbms_sql.bind_variable(p_cursor,l_bind_var_name,p_param_array(l_indx));
565: end if;
566: else
567: loop

Line 663: if (nvl(g_resl_code,biv_core_pkg.g_null) <> biv_core_pkg.g_null) then

659: end if;
660: if (g_chnl is not null) then
661: dbms_sql.bind_variable(p_cursor,':sr_creation_channel',g_chnl);
662: end if;
663: if (nvl(g_resl_code,biv_core_pkg.g_null) <> biv_core_pkg.g_null) then
664: dbms_sql.bind_variable(p_cursor,':resolution_code',g_resl_code);
665: end if;
666: if (g_arvl_tm is not null) then
667: dbms_sql.bind_variable(p_cursor,':arrival_time',g_arvl_tm);

Line 724: procedure add_a_condition(p_param_array biv_core_pkg.g_parameter_array,

720: dbms_sql.bind_variable(p_cursor,':g_lvl',g_lvl);
721: end if;
722: end;
723: ------------------------------------------------------------
724: procedure add_a_condition(p_param_array biv_core_pkg.g_parameter_array,
725: p_param_array_size number,
726: p_prefix varchar2,
727: p_column_name varchar2,
728: p_table varchar2,

Line 740: if (p_param_array(1) = biv_core_pkg.g_null) then

736: else
737: l_outer_suffx := ' ';
738: end if;
739: if (p_param_array_size = 1) then
740: if (p_param_array(1) = biv_core_pkg.g_null) then
741: p_where_clause := p_where_clause || '
742: and ' || p_prefix || '.' || p_column_name || l_outer_suffx ||
743: ' is null ';
744: else

Line 927: if (g_resl_code = biv_core_pkg.g_null) then

923: p_where_clause := p_where_clause || '
924: and upper(sr.sr_creation_channel) = :sr_creation_channel';
925: end if;
926: if (g_resl_code is not null) then
927: if (g_resl_code = biv_core_pkg.g_null) then
928: p_where_clause := p_where_clause || '
929: and sr.resolution_code is null';
930: else
931: p_where_clause := p_where_clause || '

Line 1321: l_session_id := biv_core_pkg.get_session_id;

1317: l_err varchar2(250);
1318: l_session_id biv_tmp_rt2.session_id % type;
1319: l_null_desc fnd_lookups.meaning % type;
1320: begin
1321: l_session_id := biv_core_pkg.get_session_id;
1322: l_tbl := nvl(p_tbl_name,'jtfb_temp_report');
1323: l_sql := null;
1324: if (g_view_by = 'AGRP' or g_view_by='OGRP') then
1325: l_sql := 'update ' || l_tbl || ' rep

Line 1367: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql, g_report_id);

1363: set col2 = col1
1364: where session_id = :session_id' ;
1365: end if;
1366: if (g_debug = 'Y') then
1367: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql, g_report_id);
1368: end if;
1369: commit;
1370: if (l_sql is null) then
1371: if (g_debug = 'Y') then

Line 1372: biv_core_pkg.biv_debug('Invalid Value for P_VIEW parameter:'||g_view_by,

1368: end if;
1369: commit;
1370: if (l_sql is null) then
1371: if (g_debug = 'Y') then
1372: biv_core_pkg.biv_debug('Invalid Value for P_VIEW parameter:'||g_view_by,
1373: g_report_id);
1374: end if;
1375: else
1376: execute immediate l_sql using l_session_id;

Line 1384: biv_core_pkg.biv_debug('SQL for NULLL Description:'||l_sql, g_report_id);

1380: set col2 = :null_desc
1381: where col2 is null
1382: and session_id = :session_id';
1383: if (g_debug = 'Y') then
1384: biv_core_pkg.biv_debug('SQL for NULLL Description:'||l_sql, g_report_id);
1385: end if;
1386: execute immediate l_sql using l_null_desc, l_session_id;
1387:
1388: exception

Line 1392: biv_core_pkg.biv_debug(l_err,g_report_id);

1388: exception
1389: when others then
1390: if (g_debug = 'Y') then
1391: l_err := 'Err in update_base_col:' ||substr(sqlerrm,1,200);
1392: biv_core_pkg.biv_debug(l_err,g_report_id);
1393: biv_core_pkg.biv_debug(l_sql,g_report_id);
1394: end if;
1395: end;
1396: procedure update_description(p_id_type varchar2,

Line 1393: biv_core_pkg.biv_debug(l_sql,g_report_id);

1389: when others then
1390: if (g_debug = 'Y') then
1391: l_err := 'Err in update_base_col:' ||substr(sqlerrm,1,200);
1392: biv_core_pkg.biv_debug(l_err,g_report_id);
1393: biv_core_pkg.biv_debug(l_sql,g_report_id);
1394: end if;
1395: end;
1396: procedure update_description(p_id_type varchar2,
1397: p_id_col varchar2,

Line 1454: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql_sttmnt,

1450: where session_id = :session_id';
1451: end if;
1452:
1453: if (g_debug = 'Y') then
1454: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql_sttmnt,
1455: g_report_id);
1456: end if;
1457: execute immediate l_sql_sttmnt using biv_core_pkg.get_session_id;
1458:

Line 1457: execute immediate l_sql_sttmnt using biv_core_pkg.get_session_id;

1453: if (g_debug = 'Y') then
1454: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql_sttmnt,
1455: g_report_id);
1456: end if;
1457: execute immediate l_sql_sttmnt using biv_core_pkg.get_session_id;
1458:
1459: if (upper(p_desc_col) = 'COL2') then
1460: l_null_desc := get_lookup_meaning('NA');
1461: l_sql_sttmnt := 'update ' || l_tbl || '

Line 1465: biv_core_pkg.biv_debug('SQL for updating NULL Description:'||

1461: l_sql_sttmnt := 'update ' || l_tbl || '
1462: set col2 = :nul_desc
1463: where col2 is null and session_id = :session_id';
1464: if (g_debug = 'Y') then
1465: biv_core_pkg.biv_debug('SQL for updating NULL Description:'||
1466: l_sql_sttmnt, g_report_id);
1467: end if;
1468: execute immediate l_sql_sttmnt using l_null_desc,
1469: biv_core_pkg.get_session_id;

Line 1469: biv_core_pkg.get_session_id;

1465: biv_core_pkg.biv_debug('SQL for updating NULL Description:'||
1466: l_sql_sttmnt, g_report_id);
1467: end if;
1468: execute immediate l_sql_sttmnt using l_null_desc,
1469: biv_core_pkg.get_session_id;
1470: end if;
1471: exception
1472: when others then
1473: if (g_debug = 'Y') then

Line 1475: biv_core_pkg.biv_debug(l_err,g_report_id);

1471: exception
1472: when others then
1473: if (g_debug = 'Y') then
1474: l_err := 'Err in update_description:' ||substr(sqlerrm,1,200);
1475: biv_core_pkg.biv_debug(l_err,g_report_id);
1476: biv_core_pkg.biv_debug(l_sql_sttmnt,g_report_id);
1477: end if;
1478: end;
1479: function are_all_parameters_null return number is

Line 1476: biv_core_pkg.biv_debug(l_sql_sttmnt,g_report_id);

1472: when others then
1473: if (g_debug = 'Y') then
1474: l_err := 'Err in update_description:' ||substr(sqlerrm,1,200);
1475: biv_core_pkg.biv_debug(l_err,g_report_id);
1476: biv_core_pkg.biv_debug(l_sql_sttmnt,g_report_id);
1477: end if;
1478: end;
1479: function are_all_parameters_null return number is
1480: begin

Line 1675: l_session_id := biv_core_pkg.get_session_id;

1671: l_session_id NUMBER;
1672: l_code varchar2(50);
1673: begin
1674: l_code := upper(p_code);
1675: l_session_id := biv_core_pkg.get_session_id;
1676: if l_code = 'BIV_TMP_BIN' then
1677: execute immediate 'delete from BIV_TMP_BIN where
1678: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1679: elsif (l_code = 'BIV_TMP_RT1') then

Line 1710: biv_core_pkg.g_srl_no := 0;

1706: g_debug := fnd_profile.value('BIV:DEBUG');
1707: if (g_debug = 'Y') then
1708: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1709: end if;
1710: biv_core_pkg.g_srl_no := 0;
1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);

Line 1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);

1708: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1709: end if;
1710: biv_core_pkg.g_srl_no := 0;
1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);
1716: commit;

Line 1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);

1710: biv_core_pkg.g_srl_no := 0;
1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);
1716: commit;
1717: exception when others then
1718: rollback;

Line 1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);

1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);
1716: commit;
1717: exception when others then
1718: rollback;
1719: if (g_debug = 'Y') then

Line 1720: biv_core_pkg.biv_debug('Error:'||substr(sqlerrm,1,200),

1716: commit;
1717: exception when others then
1718: rollback;
1719: if (g_debug = 'Y') then
1720: biv_core_pkg.biv_debug('Error:'||substr(sqlerrm,1,200),
1721: biv_core_pkg.g_report_id);
1722: end if;
1723:
1724: end clean_dcf_table;

Line 1721: biv_core_pkg.g_report_id);

1717: exception when others then
1718: rollback;
1719: if (g_debug = 'Y') then
1720: biv_core_pkg.biv_debug('Error:'||substr(sqlerrm,1,200),
1721: biv_core_pkg.g_report_id);
1722: end if;
1723:
1724: end clean_dcf_table;
1725:

Line 1729: l_session_id := biv_core_pkg.get_session_id;

1725:
1726: procedure clean_region_table(p_region varchar2) is
1727: l_session_id NUMBER;
1728: begin
1729: l_session_id := biv_core_pkg.get_session_id;
1730: if p_region IN ('BIV_BIN_SR',
1731: 'BIV_BIN_SR_ESCALATION',
1732: 'BIV_BIN_RESOURCE') then
1733: execute immediate 'delete from BIV_TMP_BIN where

Line 1785: biv_core_pkg.biv_debug('AA' ||p_param_str,biv_core_pkg.g_report_id);

1781: l_view_by varchar2(80);
1782: l_meaning varchar2(80);
1783: begin
1784: if (g_debug = 'Y') then
1785: biv_core_pkg.biv_debug('AA' ||p_param_str,biv_core_pkg.g_report_id);
1786: commit;
1787: end if;
1788: l_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');
1789: if (g_debug = 'Y') then

Line 1788: l_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');

1784: if (g_debug = 'Y') then
1785: biv_core_pkg.biv_debug('AA' ||p_param_str,biv_core_pkg.g_report_id);
1786: commit;
1787: end if;
1788: l_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');
1789: if (g_debug = 'Y') then
1790: biv_core_pkg.biv_debug('Param:'||p_param_str,'g_report_id');
1791: commit;
1792: end if;

Line 1790: biv_core_pkg.biv_debug('Param:'||p_param_str,'g_report_id');

1786: commit;
1787: end if;
1788: l_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');
1789: if (g_debug = 'Y') then
1790: biv_core_pkg.biv_debug('Param:'||p_param_str,'g_report_id');
1791: commit;
1792: end if;
1793: select meaning into l_meaning
1794: from fnd_lookups