APPS.HXC_MAPPING_UTILITIES dependencies on FND_GLOBAL

Line 2538: l_field_value:= l_field_value||fnd_global.newline||

2534:
2535:
2536:
2537:
2538: l_field_value:= l_field_value||fnd_global.newline||
2539: ' AND (tbb.time_building_block_id,tbb.object_version_number)in (
2540: select /*+ UNNEST
2541: LEADING(ta1)
2542: USE_NL(ta1 tau1)

Line 2552: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||fnd_global.newline||

2548: hxc_time_attributes ta1
2549: where tau1.time_building_block_id = tbb.time_building_block_id
2550: AND tau1.time_building_block_ovn = tbb.object_version_number
2551: AND tau1.time_attribute_id = ta1.time_attribute_id
2552: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||fnd_global.newline||
2553: ' AND ta1.'||l_segment_outer||' = '''|| l_field_value_outer||'''' ;
2554:
2555: -- Copy the column used as segment.
2556: IF UPPER(l_segment_outer) = 'ATTRIBUTE_CATEGORY'

Line 2567: l_field_value:= l_field_value||fnd_global.newline||' AND (tbb.time_building_block_id,tbb.object_version_number)in (

2563:
2564: else
2565:
2566:
2567: l_field_value:= l_field_value||fnd_global.newline||' AND (tbb.time_building_block_id,tbb.object_version_number)in (
2568: select /*+ UNNEST
2569: LEADING(ta1)
2570: USE_NL(ta1 tau1)
2571: INDEX(ta1 HTA_HINT)

Line 2580: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||fnd_global.newline||

2576: hxc_time_attributes ta1
2577: where tau1.time_building_block_id = tbb.time_building_block_id
2578: AND tau1.time_building_block_ovn = tbb.object_version_number
2579: AND tau1.time_attribute_id = ta1.time_attribute_id
2580: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||fnd_global.newline||
2581: ' AND ta1.'||l_segment_outer||' is null ';
2582:
2583: IF upper(l_segment_outer) = 'ATTRIBUTE_CATEGORY'
2584: THEN

Line 2608: l_field_value:=l_field_value||fnd_global.newline||

2604: l_segment_inner:=t_consolidated_info(l_index_inner).segment;
2605:
2606: if(l_field_value_inner is not null) then
2607:
2608: l_field_value:=l_field_value||fnd_global.newline||
2609: ' AND ta1.'||l_segment_inner||' = '''||l_field_value_inner||'''' ;
2610:
2611: else
2612:

Line 2613: l_field_value:=l_field_value||fnd_global.newline||

2609: ' AND ta1.'||l_segment_inner||' = '''||l_field_value_inner||'''' ;
2610:
2611: else
2612:
2613: l_field_value:=l_field_value||fnd_global.newline||
2614: ' AND ta1.'||l_segment_inner||' is null ';
2615:
2616: end if;
2617: