APPS.HXC_OTL_INFO_TYPE_HELPER dependencies on FND_DESCR_FLEX_CONTEXTS

Line 28: from fnd_descr_flex_contexts_vl

24:
25: cursor get_max_sequence is
26: select max(to_number(substrb(descriptive_flex_context_code,
27: instr(descriptive_flex_context_code,'-')+2)))
28: from fnd_descr_flex_contexts_vl
29: where descriptive_flexfield_name = 'OTC Information Types'
30: and application_id = 809
31: and substrb(descriptive_flex_context_code,0,
32: instr(descriptive_flex_context_code,'-')-2)

Line 37: l_long_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%type;

33: =substrb(descriptive_flex_context_name,0,
34: instr(descriptive_flex_context_name,'-')-2)||'C';
35:
36: l_max_sequence number;
37: l_long_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%type;
38: l_test_long_context fnd_descr_flex_contexts_tl.descriptive_flex_context_name%type;
39:
40: Begin
41:

Line 38: l_test_long_context fnd_descr_flex_contexts_tl.descriptive_flex_context_name%type;

34: instr(descriptive_flex_context_name,'-')-2)||'C';
35:
36: l_max_sequence number;
37: l_long_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%type;
38: l_test_long_context fnd_descr_flex_contexts_tl.descriptive_flex_context_name%type;
39:
40: Begin
41:
42: l_test_long_context := hxc_deposit_wrapper_utilities.get_dupdff_code

Line 122: p_context_code in fnd_descr_flex_contexts.descriptive_flex_context_code%type

118: End get_otl_flex;
119:
120: Function get_otl_context
121: (p_otl_flex in fnd_dflex.dflex_r,
122: p_context_code in fnd_descr_flex_contexts.descriptive_flex_context_code%type
123: )
124: Return fnd_dflex.context_r is
125:
126: Begin

Line 136: p_context_code in fnd_descr_flex_contexts.descriptive_flex_context_code%type)

132:
133: Function otl_context_exists
134: (p_otc_appl_short_name in fnd_application.application_short_name%type,
135: p_otc_flex_name in fnd_descriptive_flexs.descriptive_flexfield_name%type,
136: p_context_code in fnd_descr_flex_contexts.descriptive_flex_context_code%type)
137: Return Boolean is
138: l_exists boolean;
139: Begin
140:

Line 231: l_otl_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%type;

227:
228: l_build boolean;
229: l_reference_segment_list segment_list;
230: l_otl_segment_list segment_list;
231: l_otl_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%type;
232:
233: Begin
234:
235: if(long_context_code