APPS.BIV_HS_SR_ARRIVAL_PKG dependencies on FND_LOOKUPS

Line 10: execute immediate 'select meaning from fnd_lookups where lookup_type=''BIV_VIEW_BY''

6: l_label varchar2(100);
7: x_viewby varchar2(100);
8: begin
9: x_viewby:=biv_core_pkg.get_parameter_value(p_param_str,'p_viewby');
10: execute immediate 'select meaning from fnd_lookups where lookup_type=''BIV_VIEW_BY''
11: and lookup_code=:x_viewby' into l_label using x_viewby;
12: return l_label;
13: end base_column_label;
14:

Line 59: l_ttl_desc fnd_lookups.meaning % type;

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
62:
63: x_session:=biv_core_pkg.get_session_id;

Line 487: l_ttl_desc fnd_lookups.meaning % type;

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
490: x_session:=biv_core_pkg.get_session_id;
491: biv_core_pkg.clean_dcf_table('BIV_TMP_SR_ARRVL');