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 DBMS_SQL

Line 564: dbms_sql.bind_variable(p_cursor,l_bind_var_name,p_param_array(l_indx));

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
568: if (l_indx > nvl(p_param_array_size,0)) then exit; end if;

Line 569: dbms_sql.bind_variable(p_cursor,l_bind_var_name||to_char(l_indx),

565: end if;
566: else
567: loop
568: if (l_indx > nvl(p_param_array_size,0)) then exit; end if;
569: dbms_sql.bind_variable(p_cursor,l_bind_var_name||to_char(l_indx),
570: p_param_array(l_indx));
571: l_indx := l_indx + 1;
572: end loop;
573: end if;

Line 658: dbms_sql.bind_variable(p_cursor,':incident_owner_id',g_agent_id);

654: g_site_id_cnt ,
655: 'sr' ,
656: 'site_id');
657: if (nvl(g_agent_id,g_null) <> g_null) then
658: dbms_sql.bind_variable(p_cursor,':incident_owner_id',g_agent_id);
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;

Line 661: dbms_sql.bind_variable(p_cursor,':sr_creation_channel',g_chnl);

657: if (nvl(g_agent_id,g_null) <> g_null) then
658: dbms_sql.bind_variable(p_cursor,':incident_owner_id',g_agent_id);
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;

Line 664: dbms_sql.bind_variable(p_cursor,':resolution_code',g_resl_code);

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);
668: end if;

Line 667: dbms_sql.bind_variable(p_cursor,':arrival_time',g_arvl_tm);

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);
668: end if;
669:
670: -- date parameter binding
671: if (g_st_date is not null and

Line 674: dbms_sql.bind_variable(p_cursor,':start_date',g_st_date);

670: -- date parameter binding
671: if (g_st_date is not null and
672: (nvl(g_reopen,'N') = 'Y' or nvl(g_reclose,'N') = 'Y' or
673: nvl(g_oblog,'N') = 'Y')) then
674: dbms_sql.bind_variable(p_cursor,':start_date',g_st_date);
675: end if;
676: if (g_end_date is not null and
677: (nvl(g_reopen,'N') = 'Y' or nvl(g_reclose,'N') = 'Y' or
678: nvl(g_eblog,'N') = 'Y')) then

Line 679: dbms_sql.bind_variable(p_cursor,':end_date',g_end_date);

675: end if;
676: if (g_end_date is not null and
677: (nvl(g_reopen,'N') = 'Y' or nvl(g_reclose,'N') = 'Y' or
678: nvl(g_eblog,'N') = 'Y')) then
679: dbms_sql.bind_variable(p_cursor,':end_date',g_end_date);
680: end if;
681:
682: /**************
683: if (nvl(g_reopen,'N') = 'Y') then

Line 684: dbms_sql.bind_variable(p_cursor,':reopen_st' ,g_st_date );

680: end if;
681:
682: /**************
683: if (nvl(g_reopen,'N') = 'Y') then
684: dbms_sql.bind_variable(p_cursor,':reopen_st' ,g_st_date );
685: dbms_sql.bind_variable(p_cursor,':reopen_end',g_end_date);
686: end if;
687: **********************/
688: if (g_cr_st is not null) then

Line 685: dbms_sql.bind_variable(p_cursor,':reopen_end',g_end_date);

681:
682: /**************
683: if (nvl(g_reopen,'N') = 'Y') then
684: dbms_sql.bind_variable(p_cursor,':reopen_st' ,g_st_date );
685: dbms_sql.bind_variable(p_cursor,':reopen_end',g_end_date);
686: end if;
687: **********************/
688: if (g_cr_st is not null) then
689: dbms_sql.bind_variable(p_cursor,':created_start_date',g_cr_st);

Line 689: dbms_sql.bind_variable(p_cursor,':created_start_date',g_cr_st);

685: dbms_sql.bind_variable(p_cursor,':reopen_end',g_end_date);
686: end if;
687: **********************/
688: if (g_cr_st is not null) then
689: dbms_sql.bind_variable(p_cursor,':created_start_date',g_cr_st);
690: end if;
691: if (g_cr_end is not null) then
692: dbms_sql.bind_variable(p_cursor,':created_end_date',g_cr_end);
693: end if;

Line 692: dbms_sql.bind_variable(p_cursor,':created_end_date',g_cr_end);

688: if (g_cr_st is not null) then
689: dbms_sql.bind_variable(p_cursor,':created_start_date',g_cr_st);
690: end if;
691: if (g_cr_end is not null) then
692: dbms_sql.bind_variable(p_cursor,':created_end_date',g_cr_end);
693: end if;
694:
695: if (g_cl_st is not null) then
696: dbms_sql.bind_variable(p_cursor,':closed_start_date',g_cl_st);

Line 696: dbms_sql.bind_variable(p_cursor,':closed_start_date',g_cl_st);

692: dbms_sql.bind_variable(p_cursor,':created_end_date',g_cr_end);
693: end if;
694:
695: if (g_cl_st is not null) then
696: dbms_sql.bind_variable(p_cursor,':closed_start_date',g_cl_st);
697: end if;
698: if (g_cl_end is not null) then
699: dbms_sql.bind_variable(p_cursor,':closed_end_date',g_cl_end);
700: end if;

Line 699: dbms_sql.bind_variable(p_cursor,':closed_end_date',g_cl_end);

695: if (g_cl_st is not null) then
696: dbms_sql.bind_variable(p_cursor,':closed_start_date',g_cl_st);
697: end if;
698: if (g_cl_end is not null) then
699: dbms_sql.bind_variable(p_cursor,':closed_end_date',g_cl_end);
700: end if;
701: if (g_esc_st is not null) then
702: dbms_sql.bind_variable(p_cursor,':esc_st',g_esc_st);
703: end if;

Line 702: dbms_sql.bind_variable(p_cursor,':esc_st',g_esc_st);

698: if (g_cl_end is not null) then
699: dbms_sql.bind_variable(p_cursor,':closed_end_date',g_cl_end);
700: end if;
701: if (g_esc_st is not null) then
702: dbms_sql.bind_variable(p_cursor,':esc_st',g_esc_st);
703: end if;
704: if (g_esc_end is not null) then
705: dbms_sql.bind_variable(p_cursor,':esc_end',g_esc_end);
706: end if;

Line 705: dbms_sql.bind_variable(p_cursor,':esc_end',g_esc_end);

701: if (g_esc_st is not null) then
702: dbms_sql.bind_variable(p_cursor,':esc_st',g_esc_st);
703: end if;
704: if (g_esc_end is not null) then
705: dbms_sql.bind_variable(p_cursor,':esc_end',g_esc_end);
706: end if;
707:
708: if (nvl(g_other_blog,'N')='Y') then
709: l_stat := fnd_profile.value('BIV:INC_STATUS_1');

Line 710: dbms_sql.bind_variable(p_cursor,':stat1',l_stat);

706: end if;
707:
708: if (nvl(g_other_blog,'N')='Y') then
709: l_stat := fnd_profile.value('BIV:INC_STATUS_1');
710: dbms_sql.bind_variable(p_cursor,':stat1',l_stat);
711:
712: l_stat := fnd_profile.value('BIV:INC_STATUS_2');
713: dbms_sql.bind_variable(p_cursor,':stat2',l_stat);
714:

Line 713: dbms_sql.bind_variable(p_cursor,':stat2',l_stat);

709: l_stat := fnd_profile.value('BIV:INC_STATUS_1');
710: dbms_sql.bind_variable(p_cursor,':stat1',l_stat);
711:
712: l_stat := fnd_profile.value('BIV:INC_STATUS_2');
713: dbms_sql.bind_variable(p_cursor,':stat2',l_stat);
714:
715: l_stat := fnd_profile.value('BIV:INC_STATUS_3');
716: dbms_sql.bind_variable(p_cursor,':stat3',l_stat);
717: end if;

Line 716: dbms_sql.bind_variable(p_cursor,':stat3',l_stat);

712: l_stat := fnd_profile.value('BIV:INC_STATUS_2');
713: dbms_sql.bind_variable(p_cursor,':stat2',l_stat);
714:
715: l_stat := fnd_profile.value('BIV:INC_STATUS_3');
716: dbms_sql.bind_variable(p_cursor,':stat3',l_stat);
717: end if;
718: if (g_view_by in ('AGRP', 'OGRP') or g_agrp_lvl is not null or
719: g_ogrp_lvl is not null) then
720: dbms_sql.bind_variable(p_cursor,':g_lvl',g_lvl);

Line 720: dbms_sql.bind_variable(p_cursor,':g_lvl',g_lvl);

716: dbms_sql.bind_variable(p_cursor,':stat3',l_stat);
717: end if;
718: if (g_view_by in ('AGRP', 'OGRP') or g_agrp_lvl is not null or
719: g_ogrp_lvl is not null) then
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,