APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on FND_DESCR_FLEX_CONTEXTS

Line 41: l_context_code FND_DESCR_FLEX_CONTEXTS.descriptive_flex_context_code%Type;

37: l_date date;
38: l_segrec FND_DESCR_FLEX_COLUMN_USAGES%RowType ;
39: l_err_code varchar2(72);
40: l_err_msg varchar2(2000);
41: l_context_code FND_DESCR_FLEX_CONTEXTS.descriptive_flex_context_code%Type;
42: l_segment_exists Varchar2(1) := 'N' ;
43: l_context_exists Varchar2(1) := 'N' ;
44:
45: Cursor C1 (p_context_code in varchar2 ,p_source_table in varchar2

Line 62: from FND_DESCR_FLEX_CONTEXTS_vl

58: and cat_fcu.end_user_column_name = fcu.end_user_column_name );
59:
60: Cursor Csr_DFF_contexts (p_source_table in varchar2)is
61: Select *
62: from FND_DESCR_FLEX_CONTEXTS_vl
63: Where Application_id = 810
64: and Descriptive_FLexfield_Name = p_source_table
65: and Enabled_Flag = 'Y';
66:

Line 83: From FND_DESCR_FLEX_CONTEXTS_vl

79: Loop
80: begin
81: l_context_exists := NULL ;
82: Select Max('Y') into l_context_exists
83: From FND_DESCR_FLEX_CONTEXTS_vl
84: Where Descriptive_Flexfield_name = p_destination_table
85: and Descriptive_Flex_COntext_Code = dff_context.Descriptive_Flex_Context_code ;
86: -- If there is a definition already existis and it is a Global context
87: -- then NO context will be created but the strucre will be added to the existing one.