102: l_qual_id NUMBER;
103: l_qualification_ind NUMBER;
104:
105:
106: Flexfield FND_DFLEX.dflex_r;
107: Flexinfo FND_DFLEX.dflex_dr;
108: Contexts FND_DFLEX.contexts_dr;
109: segments FND_DFLEX.segments_dr;
110: l_sequence_num NUMBER;
103: l_qualification_ind NUMBER;
104:
105:
106: Flexfield FND_DFLEX.dflex_r;
107: Flexinfo FND_DFLEX.dflex_dr;
108: Contexts FND_DFLEX.contexts_dr;
109: segments FND_DFLEX.segments_dr;
110: l_sequence_num NUMBER;
111: l_price_rounding VARCHAR2(50) :='';
104:
105:
106: Flexfield FND_DFLEX.dflex_r;
107: Flexinfo FND_DFLEX.dflex_dr;
108: Contexts FND_DFLEX.contexts_dr;
109: segments FND_DFLEX.segments_dr;
110: l_sequence_num NUMBER;
111: l_price_rounding VARCHAR2(50) :='';
112:
105:
106: Flexfield FND_DFLEX.dflex_r;
107: Flexinfo FND_DFLEX.dflex_dr;
108: Contexts FND_DFLEX.contexts_dr;
109: segments FND_DFLEX.segments_dr;
110: l_sequence_num NUMBER;
111: l_price_rounding VARCHAR2(50) :='';
112:
113:
164:
165: ELSE
166: -- Added by dhgupta for bug 2113793
167:
168: FND_DFLEX.get_flexfield('QP','QP_ATTR_DEFNS_PRICING',Flexfield,Flexinfo);
169: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,'ITEM'),
170: segments,TRUE);
171: For i in 1..segments.nsegments LOOP
172: IF segments.application_column_name(i) = 'PRICING_ATTRIBUTE1' THEN
165: ELSE
166: -- Added by dhgupta for bug 2113793
167:
168: FND_DFLEX.get_flexfield('QP','QP_ATTR_DEFNS_PRICING',Flexfield,Flexinfo);
169: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,'ITEM'),
170: segments,TRUE);
171: For i in 1..segments.nsegments LOOP
172: IF segments.application_column_name(i) = 'PRICING_ATTRIBUTE1' THEN
173: l_sequence_num := segments.sequence(i);