APPS.ARP_TRANS_FLEX dependencies on FND_DESCR_FLEX_CONTEXTS

Line 6: fnd_descr_flex_contexts.descriptive_flex_context_code%type

2: /* $Header: ARTUFLXB.pls 115.7 2002/11/18 22:56:06 anukumar ship $ */
3:
4:
5: TYPE flex_context_type IS TABLE OF
6: fnd_descr_flex_contexts.descriptive_flex_context_code%type
7: INDEX by binary_integer;
8:
9: TYPE flex_num_type IS TABLE OF number INDEX by binary_integer;
10:

Line 79: from fnd_descr_flex_contexts ctx,

75: pc_desc_flex in varchar2) is
76: select ctx.descriptive_flex_context_code context_code,
77: substr(seg.application_column_name,
78: length('INTERFACE_LINE_ATTRIBUTE')+1) segment_num
79: from fnd_descr_flex_contexts ctx,
80: fnd_descr_flex_column_usages seg
81: where ctx.application_id = pc_appl_id
82: and ctx.descriptive_flexfield_name = pc_desc_flex
83: and ctx.application_id = seg.application_id(+)

Line 91: l_prior_context fnd_descr_flex_contexts.descriptive_flex_context_code%type;

87: seg.descriptive_flex_context_code(+)
88: and seg.enabled_flag (+) = 'Y'
89: order by ctx.descriptive_flex_context_code, seg.column_seq_num;
90:
91: l_prior_context fnd_descr_flex_contexts.descriptive_flex_context_code%type;
92: l_ctx_count number;
93: l_seg_count number;
94: l_total_seg_count number;
95: l_seg_number number;