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 FND_PROFILE

Line 94: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

90: ************************************/
91: procedure prt_parameter_values(p_param_values in out nocopy g_parameter_array,
92: p_total_values in out nocopy number) as
93: i number;
94: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
95: begin
96: i := 0;
97: loop
98: i := i + 1;

Line 318: l_dt_fmt varchar2(30) := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

314: -- This procedure extracts all possible parameters from parameter string
315: -- and sets global varibale for respective parameter.
316: procedure get_report_parameters(p_param_str varchar2) as
317: l_dt varchar2(30);
318: l_dt_fmt varchar2(30) := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
319: begin
320: g_debug := fnd_profile.value('BIV:DEBUG');
321: g_cust_id_cnt := 0;
322: g_cntr_id_cnt := 0;

Line 320: g_debug := fnd_profile.value('BIV:DEBUG');

316: procedure get_report_parameters(p_param_str varchar2) as
317: l_dt varchar2(30);
318: l_dt_fmt varchar2(30) := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
319: begin
320: g_debug := fnd_profile.value('BIV:DEBUG');
321: g_cust_id_cnt := 0;
322: g_cntr_id_cnt := 0;
323: g_ogrp_cnt := 0;
324: g_agrp_cnt := 0;

Line 333: g_debug := fnd_profile.value('BIV:DEBUG');

329: g_comp_id_cnt := 0;
330: g_subcomp_id_cnt := 0;
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 ,

Line 507: g_prd_org := fnd_profile.value('CS_INV_VALIDATION_ORG');

503: elsif (g_view_by = 'CUST') then
504: g_base_column := 'sr.customer_id';
505: elsif (g_view_by = 'PRD') then
506: g_base_column := 'sr.inventory_item_id ';
507: g_prd_org := fnd_profile.value('CS_INV_VALIDATION_ORG');
508: --ASO_PRODUCT_ORGANIZATION_ID');
509: elsif (g_view_by = 'CNTRCT') then
510: g_base_column := 'sr.contract_number';
511: elsif (g_view_by = 'ESCONR') then

Line 709: l_stat := fnd_profile.value('BIV:INC_STATUS_1');

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');
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);

Line 712: l_stat := fnd_profile.value('BIV:INC_STATUS_2');

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:
715: l_stat := fnd_profile.value('BIV:INC_STATUS_3');
716: dbms_sql.bind_variable(p_cursor,':stat3',l_stat);

Line 715: l_stat := fnd_profile.value('BIV:INC_STATUS_3');

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;
718: if (g_view_by in ('AGRP', 'OGRP') or g_agrp_lvl is not null or
719: g_ogrp_lvl is not null) then

Line 1526: l_dt_fmt varchar2(30) := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

1522: end;
1523: procedure concatenate_date_param (p_param_value date,
1524: p_param_name varchar2,
1525: p_param_str in out nocopy varchar2) is
1526: l_dt_fmt varchar2(30) := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
1527: begin
1528: if (p_param_value is not null) then
1529: p_param_str := p_param_str || p_param_name || g_value_sep ||
1530: to_char( p_param_value,l_dt_fmt) ||g_param_sep;

Line 1706: g_debug := fnd_profile.value('BIV:DEBUG');

1702: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1703: execute immediate 'delete from BIV_TMP_SR_ARRVL where
1704: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1705: end if;
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;