APPS.BIV_HS_PROB_AVOID_REPORT_PKG dependencies on FND_PROFILE

Line 62: g_debug_flag := nvl(fnd_profile.value('BIV:DEBUG'),'N');

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');
63: g_session_id := biv_core_pkg.get_session_id;
64: biv_core_pkg.g_report_type := 'HS';
65: biv_core_pkg.clean_dcf_table('BIV_TMP_HS1');
66: -- report code

Line 221: and inv1.organization_id (+)= fnd_profile.value(''CS_INV_VALIDATION_ORG'')

217: BEGIN
218: -- put outter join on inv* columns when testing
219: -- there are many null column in inv*
220: l_where_stmt := '
221: and inv1.organization_id (+)= fnd_profile.value(''CS_INV_VALIDATION_ORG'')
222: and sr.inventory_item_id = inv1.inventory_item_id(+) ';
223:
224:
225:

Line 253: g_debug_flag := nvl(fnd_profile.value('BIV:DEBUG'),'N');

249: l_start_date DATE;
250: l_end_date DATE;
251: l_new_param_str varchar2(500);
252: BEGIN
253: g_debug_flag := nvl(fnd_profile.value('BIV:DEBUG'),'N');
254: g_session_id := biv_core_pkg.get_session_id;
255: biv_core_pkg.g_report_type := 'HS';
256: biv_core_pkg.clean_dcf_table('BIV_TMP_HS1');
257: -- report code