DBA Data[Home] [Help]

APPS.OTA_CLASSIC_UPGRADE dependencies on FND_DESCR_FLEX_CONTEXTS

Line 2738: l_context_code FND_DESCR_FLEX_CONTEXTS.descriptive_flex_context_code%Type;

2734: l_err_msg varchar2(2000);
2735:
2736: l_context_exists Varchar2(1) := 'N' ;
2737:
2738: l_context_code FND_DESCR_FLEX_CONTEXTS.descriptive_flex_context_code%Type;
2739: l_segment_exists Varchar2(1) := 'N' ;
2740:
2741: Cursor Csr_DFF_contexts is Select * from FND_DESCR_FLEX_CONTEXTS_vl
2742: Where Application_id = 810

Line 2741: Cursor Csr_DFF_contexts is Select * from FND_DESCR_FLEX_CONTEXTS_vl

2737:
2738: l_context_code FND_DESCR_FLEX_CONTEXTS.descriptive_flex_context_code%Type;
2739: l_segment_exists Varchar2(1) := 'N' ;
2740:
2741: Cursor Csr_DFF_contexts is Select * from FND_DESCR_FLEX_CONTEXTS_vl
2742: Where Application_id = 810
2743: and Descriptive_FLexfield_Name = 'OTA_ACTIVITY_DEFINITIONS'
2744: and Enabled_Flag = 'Y';
2745:

Line 2761: From FND_DESCR_FLEX_CONTEXTS_vl

2757: Loop
2758: begin
2759: l_context_exists := NULL ;
2760: Select Max('Y') into l_context_exists
2761: From FND_DESCR_FLEX_CONTEXTS_vl
2762: Where Descriptive_Flexfield_name = 'OTA_CATEGORY_USAGES'
2763: and Descriptive_Flex_COntext_Code = dff_context.Descriptive_Flex_Context_code ;
2764: -- If there is a definition already existis and it is a Global context
2765: -- then NO context will be created but the strucre will be added to the existing one.