APPS.POA_DBI_IAP_PKG dependencies on FND_GLOBAL

Line 466: l_query := get_trend_sel_clause || ' from '|| fnd_global.newline ||

462: l_where_clause := l_where_clause ||
463: ' and nvl(fact.base_uom ,''-1'') = ''' || l_uom || '''' ;
464:
465:
466: l_query := get_trend_sel_clause || ' from '|| fnd_global.newline ||
467: poa_dbi_template_pkg.trend_sql(
468: p_xtd => l_xtd,
469: p_comparison_type => l_comparison_type,
470: p_fact_name => l_mv,

Line 713: || fnd_global.newline;

709: || l_col_calc_tbl(i).calc_end
710: || ' '
711: || l_col_calc_tbl(i).alias_begin
712: || l_col_calc_tbl(i).alias_end
713: || fnd_global.newline;
714: END LOOP;
715:
716:
717: -- 0 (0 0 0) = neither XTD or XED

Line 795: || fnd_global.newline

791: if( bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx) then
792: l_join_tables := ', fii_time_structures cal '|| l_in_join_tables;
793: l_full_where_clause := ' where fact.time_id = cal.time_id '
794: || 'and fact.period_type_id = cal.period_type_id '
795: || fnd_global.newline
796: || p_where_clause
797: || fnd_global.newline
798: || 'and cal.report_date in '
799: || l_inlist

Line 797: || fnd_global.newline

793: l_full_where_clause := ' where fact.time_id = cal.time_id '
794: || 'and fact.period_type_id = cal.period_type_id '
795: || fnd_global.newline
796: || p_where_clause
797: || fnd_global.newline
798: || 'and cal.report_date in '
799: || l_inlist
800: -- &RLX_NESTED_PATTERN should be replaced with some
801: -- &BIS bind substitution when available from fii/bis team.

Line 802: || fnd_global.newline

798: || 'and cal.report_date in '
799: || l_inlist
800: -- &RLX_NESTED_PATTERN should be replaced with some
801: -- &BIS bind substitution when available from fii/bis team.
802: || fnd_global.newline
803: || 'and bitand(cal.record_type_id, &RLX_NESTED_PATTERN) = '
804: || '&RLX_NESTED_PATTERN ';
805: elsif( bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal) then
806: l_join_tables := '';

Line 817: || fnd_global.newline

813: l_full_where_clause := ' where ' || p_where_clause;
814: end if;
815: else
816: l_join_tables := ', fii_time_rpt_struct_v cal'
817: || fnd_global.newline
818: || l_in_join_tables;
819: l_full_where_clause :=' where fact.time_id = cal.time_id '
820: || p_where_clause
821: || fnd_global.newline

Line 821: || fnd_global.newline

817: || fnd_global.newline
818: || l_in_join_tables;
819: l_full_where_clause :=' where fact.time_id = cal.time_id '
820: || p_where_clause
821: || fnd_global.newline
822: || ' and cal.report_date in '
823: || l_inlist
824: || fnd_global.newline
825: || ' and bitand(cal.record_type_id, '

Line 824: || fnd_global.newline

820: || p_where_clause
821: || fnd_global.newline
822: || ' and cal.report_date in '
823: || l_inlist
824: || fnd_global.newline
825: || ' and bitand(cal.record_type_id, '
826: || CASE -- if one or more columns = YTD then use nested pattern
827: WHEN BITAND (l_inlist_bmap, poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd
828: THEN '&YTD_NESTED_PATTERN'

Line 846: || fnd_global.newline||' from '

842: l_query := '(select '
843: || l_add_sel_col
844: || l_group_and_sel_clause
845: || l_col_names
846: || fnd_global.newline||' from '
847: || p_fact_name
848: || ' fact'
849: || l_join_tables
850: || l_full_where_clause

Line 853: || fnd_global.newline

849: || l_join_tables
850: || l_full_where_clause
851: || ' and nvl(fact.base_uom ,''-1'') = ''' || p_uom_code || ''''
852: || l_grpid_clause
853: || fnd_global.newline
854: || l_group_by
855: || l_group_and_sel_clause
856: || l_paren_str;
857:

Line 866: ',' || fnd_global.newline;

862: l_viewby_rank_where :='';
863:
864: if(p_use_windowing <> 'P') then
865: l_viewby_rank_where := l_viewby_rank_where ||
866: ',' || fnd_global.newline;
867: end if;
868:
869: l_join_tbl := p_join_tables ;
870: