APPS.BIV_HS_SR_ARRIVAL_PKG dependencies on FND_PROFILE

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

53: x_session number;
54: l_reached_upto varchar2(100);
55:
56: l_param_str varchar2(2000);
57: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
58: l_ttl_rec number;
59: l_ttl_desc fnd_lookups.meaning % type;
60:
61: begin

Line 153: l_start_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);

149:
150: end loop;
151: dbms_sql.close_cursor(cur);
152: dbms_sql.close_cursor(cur2);
153: l_start_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);
154:
155: if biv_core_pkg.g_tm_zn is not null then
156: l_end_tz:=to_number(nvl(biv_core_pkg.g_tm_zn,0));
157: else

Line 158: l_end_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);

154:
155: if biv_core_pkg.g_tm_zn is not null then
156: l_end_tz:=to_number(nvl(biv_core_pkg.g_tm_zn,0));
157: else
158: l_end_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);
159: end if;
160:
161: CS_TZ_GET_DETAILS_PVT.GET_LEADTIME(1.0,'T',l_start_tz,l_end_tz,l_tz_diff,l_return_status,l_msg_count,l_msg_data);
162:

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

481: l_msg_data varchar2(30);
482: l_num_rows integer;
483: x_session NUMBER;
484: l_new_param_str1 varchar2(200);
485: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
486: l_ttl_rec number;
487: l_ttl_desc fnd_lookups.meaning % type;
488:
489: begin

Line 571: l_start_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);

567:
568:
569: -- array processing logic
570:
571: l_start_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);
572: if biv_core_pkg.g_tm_zn is not null then
573: l_end_tz:=to_number(nvl(biv_core_pkg.g_tm_zn,0));
574: else
575: l_end_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);

Line 575: l_end_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);

571: l_start_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);
572: if biv_core_pkg.g_tm_zn is not null then
573: l_end_tz:=to_number(nvl(biv_core_pkg.g_tm_zn,0));
574: else
575: l_end_tz:=nvl(fnd_profile.value('SERVER_TIMEZONE_ID'),0);
576: end if;
577: CS_TZ_GET_DETAILS_PVT.GET_LEADTIME(1.0,'T',l_start_tz,l_end_tz,l_tz_diff,l_return_status,l_msg_count,l_msg_data);
578: n:=nvl(l_tz_diff,0);
579: if (l_debug = 'Y') then