DBA Data[Home] [Help]

APPS.QP_SEG_UTIL dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1085: l_seg_flex_row fnd_descr_flex_column_usages%rowtype;

1081: )
1082: IS
1083: l_prc_context_code varchar2(30);
1084: l_prc_context_type varchar2(30);
1085: l_seg_flex_row fnd_descr_flex_column_usages%rowtype;
1086: BEGIN
1087:
1088: UPDATE QP_SEGMENTS_b
1089: SET ATTRIBUTE1 = p_SEG_rec.attribute1

Line 1154: from fnd_descr_flex_column_usages

1150: --
1151: if l_prc_context_type = 'PRICING_ATTRIBUTE' then
1152: select *
1153: into l_seg_flex_row
1154: from fnd_descr_flex_column_usages
1155: where application_id = 661 and
1156: descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING' and
1157: descriptive_flex_context_code = l_prc_context_code and
1158: application_column_name = p_SEG_rec.segment_mapping_column and

Line 1233: from fnd_descr_flex_column_usages

1229: if l_prc_context_type = 'PRICING_ATTRIBUTE' then
1230: begin
1231: select 's'
1232: into attr_in_ff_exists
1233: from fnd_descr_flex_column_usages
1234: where application_id = 661 and
1235: descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING' and
1236: descriptive_flex_context_code = l_prc_context_code and
1237: end_user_column_name = p_SEG_rec.segment_code and