eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_VG_KEY_FLEX dependencies on FND_FLEX_KEY_API

Line 576: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE

572: PROCEDURE add_key_flexfield_segments
573: ( p_dummy_flag IN BOOLEAN
574: , p_Structure_Num IN NUMBER
575: , p_suffix IN VARCHAR2
576: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE
577: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE
578: , p_Concat_Seg_Name IN VARCHAR2
579: , p_decode_on_segments IN BOOLEAN
580: , p_Prefix IN VARCHAR2

Line 577: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE

573: ( p_dummy_flag IN BOOLEAN
574: , p_Structure_Num IN NUMBER
575: , p_suffix IN VARCHAR2
576: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE
577: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE
578: , p_Concat_Seg_Name IN VARCHAR2
579: , p_decode_on_segments IN BOOLEAN
580: , p_Prefix IN VARCHAR2
581: , p_Table_Alias IN VARCHAR2

Line 590: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;

586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
587: )
588: IS
589: --
590: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;
591: l_Segment FND_FLEX_KEY_API.SEGMENT_TYPE;
592: --
593: l_nSegments NUMBER;
594: l_Concat_Segment_Flag BOOLEAN; -- mirrors p_Concat_Segment_Flag

Line 591: l_Segment FND_FLEX_KEY_API.SEGMENT_TYPE;

587: )
588: IS
589: --
590: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;
591: l_Segment FND_FLEX_KEY_API.SEGMENT_TYPE;
592: --
593: l_nSegments NUMBER;
594: l_Concat_Segment_Flag BOOLEAN; -- mirrors p_Concat_Segment_Flag
595: -- to circumvent possible PL/SQL bug

Line 606: FND_FLEX_KEY_API.GET_SEGMENTS( flexfield => p_Flexfield

602: bis_debug_pub.Add('> add_key_flexfield_segments');
603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604: l_Concat_Segment_Flag := FALSE;
605: --
606: FND_FLEX_KEY_API.GET_SEGMENTS( flexfield => p_Flexfield
607: , structure => p_Structure
608: , enabled_only => TRUE
609: , nsegments => l_nSegments
610: , segments => l_Segment_List

Line 622: l_Segment := FND_FLEX_KEY_API.FIND_SEGMENT

618: --
619:
620: x_Select_Table(1) := ' ';
621: FOR i IN 1 .. l_nSegments LOOP
622: l_Segment := FND_FLEX_KEY_API.FIND_SEGMENT
623: ( flexfield => p_Flexfield
624: , structure => p_Structure
625: , segment_name => l_Segment_List(i)
626: );

Line 723: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE

719: --- FND_API.G_EXC_ERROR;
720: -- =============================================================================
721: PROCEDURE add_kfx_segments_concat
722: ( p_nStructures IN NUMBER
723: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE
724: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE
725: , p_Table_Alias IN VARCHAR2
726: , p_pad_count IN NUMBER
727: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

Line 724: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE

720: -- =============================================================================
721: PROCEDURE add_kfx_segments_concat
722: ( p_nStructures IN NUMBER
723: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE
724: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE
725: , p_Table_Alias IN VARCHAR2
726: , p_pad_count IN NUMBER
727: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
728: , x_return_status OUT VARCHAR2

Line 733: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;

729: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
730: )
731: IS
732: --
733: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;
734: l_Segment FND_FLEX_KEY_API.SEGMENT_TYPE;
735: --
736: l_nSegments NUMBER;
737: l_prefix VARCHAR2(100) := NULL;

Line 734: l_Segment FND_FLEX_KEY_API.SEGMENT_TYPE;

730: )
731: IS
732: --
733: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;
734: l_Segment FND_FLEX_KEY_API.SEGMENT_TYPE;
735: --
736: l_nSegments NUMBER;
737: l_prefix VARCHAR2(100) := NULL;
738: l_prefix_Len NUMBER := 0;

Line 745: FND_FLEX_KEY_API.GET_SEGMENTS( flexfield => p_Flexfield

741: --
742: BEGIN
743: bis_debug_pub.Add('> add_kfx_segments_concat');
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745: FND_FLEX_KEY_API.GET_SEGMENTS( flexfield => p_Flexfield
746: , structure => p_Structure
747: , enabled_only => TRUE
748: , nsegments => l_nSegments
749: , segments => l_Segment_List

Line 754: l_Segment := FND_FLEX_KEY_API.FIND_SEGMENT

750: );
751: IF( l_nSegments > 0 ) THEN
752: --
753: FOR i IN 1 .. l_nSegments LOOP
754: l_Segment := FND_FLEX_KEY_API.FIND_SEGMENT
755: ( flexfield => p_Flexfield
756: , structure => p_Structure
757: , segment_name => l_Segment_List(i)
758: );

Line 869: l_Flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

865: IS
866: --
867:
868: --
869: l_Flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
870: l_Structure_List FND_FLEX_KEY_API.STRUCTURE_LIST;
871: l_Structure FND_FLEX_KEY_API.STRUCTURE_TYPE;
872: --
873: l_nStructures NUMBER;

Line 870: l_Structure_List FND_FLEX_KEY_API.STRUCTURE_LIST;

866: --
867:
868: --
869: l_Flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
870: l_Structure_List FND_FLEX_KEY_API.STRUCTURE_LIST;
871: l_Structure FND_FLEX_KEY_API.STRUCTURE_TYPE;
872: --
873: l_nStructures NUMBER;
874: l_count NUMBER;

Line 871: l_Structure FND_FLEX_KEY_API.STRUCTURE_TYPE;

867:
868: --
869: l_Flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
870: l_Structure_List FND_FLEX_KEY_API.STRUCTURE_LIST;
871: l_Structure FND_FLEX_KEY_API.STRUCTURE_TYPE;
872: --
873: l_nStructures NUMBER;
874: l_count NUMBER;
875: l_Column_Table bis_vg_types.View_Text_Table_Type;

Line 929: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');

925: ELSIF (p_column_table IS NULL)
926: --- regular BVG behavior (not pruned)
927: THEN
928: bis_debug_pub.Add('regular BVG behavior (not pruned)');
929: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');
930: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
931: ( appl_short_name => p_Application_Name
932: , flex_code => p_Key_Flex_Code
933: );

Line 930: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD

926: --- regular BVG behavior (not pruned)
927: THEN
928: bis_debug_pub.Add('regular BVG behavior (not pruned)');
929: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');
930: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
931: ( appl_short_name => p_Application_Name
932: , flex_code => p_Key_Flex_Code
933: );
934: FND_FLEX_KEY_API.GET_STRUCTURES( flexfield => l_Flexfield

Line 934: FND_FLEX_KEY_API.GET_STRUCTURES( flexfield => l_Flexfield

930: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
931: ( appl_short_name => p_Application_Name
932: , flex_code => p_Key_Flex_Code
933: );
934: FND_FLEX_KEY_API.GET_STRUCTURES( flexfield => l_Flexfield
935: , enabled_only => TRUE
936: , nstructures => l_nStructures
937: , structures => l_Structure_List
938: );

Line 995: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield

991: l_decode_max := l_decode_max - 1;
992: END IF;
993:
994: bis_debug_pub.ADD('before calling fnd');
995: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
996: , structure_number => l_Structure_List(i)
997: );
998: bis_debug_pub.ADD('after calling fnd');
999: bis_debug_pub.Add('l_Structure.structure_name = ' ||l_Structure.structure_name);

Line 1066: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield

1062: bis_debug_pub.ADD('adding columns to the table');
1063:
1064: FOR i IN 1 .. l_nStructures LOOP
1065: bis_debug_pub.ADD('before calling fnd');
1066: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
1067: , structure_number => l_Structure_List(i)
1068: );
1069: bis_debug_pub.ADD('after calling fnd');
1070: bis_debug_pub.Add('l_Structure.structure_name = '||l_Structure.structure_name);

Line 1121: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');

1117: END IF; --- Concat_segment_flag false
1118:
1119: ELSE --- The pruned case - no need for concatenated segments column.
1120: bis_debug_pub.Add('The pruned case');
1121: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');
1122: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
1123: (appl_short_name => p_Application_Name
1124: , flex_code => p_Key_Flex_Code
1125: );

Line 1122: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD

1118:
1119: ELSE --- The pruned case - no need for concatenated segments column.
1120: bis_debug_pub.Add('The pruned case');
1121: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');
1122: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
1123: (appl_short_name => p_Application_Name
1124: , flex_code => p_Key_Flex_Code
1125: );
1126: