APPS.BIS_VG_DESC_FLEX dependencies on FND_DFLEX

Line 50: PROCEDURE get_contexts(flexfield IN FND_DFLEX.DFLEX_R,

46: -- ========================================
47: -- Procedure Name: Get_contexts
48: -- returns the contexts in a flexfield ordered by the creation_date
49: -- ========================================
50: PROCEDURE get_contexts(flexfield IN FND_DFLEX.DFLEX_R,
51: contexts OUT FND_DFLEX.CONTEXTS_DR)
52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,

Line 51: contexts OUT FND_DFLEX.CONTEXTS_DR)

47: -- Procedure Name: Get_contexts
48: -- returns the contexts in a flexfield ordered by the creation_date
49: -- ========================================
50: PROCEDURE get_contexts(flexfield IN FND_DFLEX.DFLEX_R,
51: contexts OUT FND_DFLEX.CONTEXTS_DR)
52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
55: description, global_flag, enabled_flag

Line 82: rv FND_DFLEX.CONTEXTS_DR;

78: AND descriptive_flexfield_name = flexfield.flexfield_name
79: ORDER BY creation_date, descriptive_flex_context_code ;
80:
81: i BINARY_INTEGER := 0;
82: rv FND_DFLEX.CONTEXTS_DR;
83:
84: BEGIN
85: rv.global_context := 0;
86: -- Bug 6819715

Line 697: , p_Flexfield IN FND_DFLEX.DFLEX_R

693: -- ---
694: -- ============================================================================
695: PROCEDURE add_desc_flexfield_segments
696: ( p_nContexts_flag IN BOOLEAN
697: , p_Flexfield IN FND_DFLEX.DFLEX_R
698: , p_Flexinfo IN FND_DFLEX.DFLEX_DR
699: , p_Context_Code IN
700: FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
701: , p_Context_Num IN NUMBER

Line 698: , p_Flexinfo IN FND_DFLEX.DFLEX_DR

694: -- ============================================================================
695: PROCEDURE add_desc_flexfield_segments
696: ( p_nContexts_flag IN BOOLEAN
697: , p_Flexfield IN FND_DFLEX.DFLEX_R
698: , p_Flexinfo IN FND_DFLEX.DFLEX_DR
699: , p_Context_Code IN
700: FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
701: , p_Context_Num IN NUMBER
702: , p_Prefix IN VARCHAR2

Line 718: l_segments FND_DFLEX.SEGMENTS_DR;

714: , p_schema IN VARCHAR2 --schema name
715: )
716: IS
717: --
718: l_segments FND_DFLEX.SEGMENTS_DR;
719: --
720: l_prefix VARCHAR(100);
721: l_count NUMBER;
722: l_context_code VARCHAR2(100) := NULL;

Line 742: FND_DFLEX.GET_SEGMENTS

738: -- l_context_code := '^' || p_Context_Code;
739: l_context_code := '^' || TO_CHAR(p_Context_Num);
740: END IF;
741: --
742: FND_DFLEX.GET_SEGMENTS
743: ( context => FND_DFLEX.MAKE_CONTEXT
744: ( flexfield => p_flexfield
745: , context_code => p_Context_Code
746: )

Line 743: ( context => FND_DFLEX.MAKE_CONTEXT

739: l_context_code := '^' || TO_CHAR(p_Context_Num);
740: END IF;
741: --
742: FND_DFLEX.GET_SEGMENTS
743: ( context => FND_DFLEX.MAKE_CONTEXT
744: ( flexfield => p_flexfield
745: , context_code => p_Context_Code
746: )
747: , segments => l_segments

Line 933: l_flexfield FND_DFLEX.DFLEX_R;

929: )
930: IS
931: --
932: i NUMBER;
933: l_flexfield FND_DFLEX.DFLEX_R;
934: l_flexinfo FND_DFLEX.DFLEX_DR;
935: l_contexts FND_DFLEX.CONTEXTS_DR;
936: l_segments FND_DFLEX.SEGMENTS_DR;
937: --

Line 934: l_flexinfo FND_DFLEX.DFLEX_DR;

930: IS
931: --
932: i NUMBER;
933: l_flexfield FND_DFLEX.DFLEX_R;
934: l_flexinfo FND_DFLEX.DFLEX_DR;
935: l_contexts FND_DFLEX.CONTEXTS_DR;
936: l_segments FND_DFLEX.SEGMENTS_DR;
937: --
938: l_ATT_CATEGORY_flag BOOLEAN := TRUE;

Line 935: l_contexts FND_DFLEX.CONTEXTS_DR;

931: --
932: i NUMBER;
933: l_flexfield FND_DFLEX.DFLEX_R;
934: l_flexinfo FND_DFLEX.DFLEX_DR;
935: l_contexts FND_DFLEX.CONTEXTS_DR;
936: l_segments FND_DFLEX.SEGMENTS_DR;
937: --
938: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
939: l_nContexts_flag BOOLEAN;

Line 936: l_segments FND_DFLEX.SEGMENTS_DR;

932: i NUMBER;
933: l_flexfield FND_DFLEX.DFLEX_R;
934: l_flexinfo FND_DFLEX.DFLEX_DR;
935: l_contexts FND_DFLEX.CONTEXTS_DR;
936: l_segments FND_DFLEX.SEGMENTS_DR;
937: --
938: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
939: l_nContexts_flag BOOLEAN;
940: l_count NUMBER := 0;

Line 961: FND_DFLEX.GET_FLEXFIELD( appl_short_name => p_Application_Name

957: bis_debug_pub.Add('FND_INSTALLATION.GET_APP_INFO returned with error');
958: end if;
959:
960: x_return_status := FND_API.G_RET_STS_SUCCESS;
961: FND_DFLEX.GET_FLEXFIELD( appl_short_name => p_Application_Name
962: , flexfield_name => p_Desc_Flex_Name
963: , flexfield => l_flexfield
964: , flexinfo => l_flexinfo
965: );