APPS.BIV_CORE_PKG dependencies on FND_LOOKUPS

Line 4: l_meaning fnd_lookups.meaning % type;

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
6: select meaning into l_meaning from fnd_lookups
7: where lookup_type = 'BIV_LABELS'
8: and lookup_code = p_lookup_code;

Line 6: select meaning into l_meaning from fnd_lookups

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
6: select meaning into l_meaning from fnd_lookups
7: where lookup_type = 'BIV_LABELS'
8: and lookup_code = p_lookup_code;
9: return l_meaning;
10: exception

Line 1319: l_null_desc fnd_lookups.meaning % type;

1315: l_tbl varchar2(30);
1316: l_sql varchar2(500);
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;

Line 1404: l_null_desc fnd_lookups.meaning % type;

1400: l_sql_sttmnt varchar2(2000);
1401: l_id_type varchar2(100);
1402: l_tbl varchar2(50);
1403: l_err varchar2(250);
1404: l_null_desc fnd_lookups.meaning % type;
1405: begin
1406: l_id_type := upper(p_id_type);
1407: l_tbl := nvl(p_tbl_name,'jtfb_temp_report');
1408: if (l_id_type = 'P_AGRP' or l_id_type='P_OGRP') then

Line 1794: from fnd_lookups

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
1795: where lookup_type = 'BIV_VIEW_BY'
1796: and lookup_code = nvl(l_view_by,'MGR');
1797: --dbms_output.put_line(l_meaning);
1798: return(nvl(l_meaning,'Base Column'));