DBA Data[Home] [Help]

APPS.BIV_HS_PROB_AVOID_REPORT_PKG dependencies on FND_LOOKUPS

Line 58: l_ttl_meaning fnd_lookups.meaning % type :=

54: l_start_date DATE;
55: l_end_date DATE;
56: l_ttl_recs number;
57: l_session_id number := biv_core_pkg.get_session_id;
58: l_ttl_meaning fnd_lookups.meaning % type :=
59: biv_core_pkg.get_lookup_meaning('TOTAL');
60: l_param_for_drill varchar2(600);
61: BEGIN
62: g_debug_flag := nvl(fnd_profile.value('BIV:DEBUG'),'N');

Line 183: l_na_desc fnd_lookups.meaning%type :=

179:
180: -- get select
181: FUNCTION get_prob_avoid_rpt_select RETURN VARCHAR2 IS
182: l_select_stmt varchar2(1000);
183: l_na_desc fnd_lookups.meaning%type :=
184: biv_core_pkg.get_lookup_meaning('NA');
185: BEGIN
186: l_select_stmt := 'INSERT INTO biv_tmp_hs1 (report_code, session_id,col2, ';
187: l_select_stmt := l_select_stmt || 'col4,col6,col8,col10,col12,col5,col7) ';