103: l_qual_id NUMBER;
104: l_qualification_ind NUMBER;
105:
106:
107: Flexfield FND_DFLEX.dflex_r;
108: Flexinfo FND_DFLEX.dflex_dr;
109: Contexts FND_DFLEX.contexts_dr;
110: segments FND_DFLEX.segments_dr;
111: l_sequence_num NUMBER;
104: l_qualification_ind NUMBER;
105:
106:
107: Flexfield FND_DFLEX.dflex_r;
108: Flexinfo FND_DFLEX.dflex_dr;
109: Contexts FND_DFLEX.contexts_dr;
110: segments FND_DFLEX.segments_dr;
111: l_sequence_num NUMBER;
112: l_price_rounding VARCHAR2(50) :='';
105:
106:
107: Flexfield FND_DFLEX.dflex_r;
108: Flexinfo FND_DFLEX.dflex_dr;
109: Contexts FND_DFLEX.contexts_dr;
110: segments FND_DFLEX.segments_dr;
111: l_sequence_num NUMBER;
112: l_price_rounding VARCHAR2(50) :='';
113: /* 7388596*/
106:
107: Flexfield FND_DFLEX.dflex_r;
108: Flexinfo FND_DFLEX.dflex_dr;
109: Contexts FND_DFLEX.contexts_dr;
110: segments FND_DFLEX.segments_dr;
111: l_sequence_num NUMBER;
112: l_price_rounding VARCHAR2(50) :='';
113: /* 7388596*/
114: v_result_code number;
185:
186: ELSE
187: -- Added by dhgupta for bug 2113793
188:
189: FND_DFLEX.get_flexfield('QP','QP_ATTR_DEFNS_PRICING',Flexfield,Flexinfo);
190: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,'ITEM'),
191: segments,TRUE);
192: For i in 1..segments.nsegments LOOP
193: IF segments.application_column_name(i) = 'PRICING_ATTRIBUTE1' THEN
186: ELSE
187: -- Added by dhgupta for bug 2113793
188:
189: FND_DFLEX.get_flexfield('QP','QP_ATTR_DEFNS_PRICING',Flexfield,Flexinfo);
190: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,'ITEM'),
191: segments,TRUE);
192: For i in 1..segments.nsegments LOOP
193: IF segments.application_column_name(i) = 'PRICING_ATTRIBUTE1' THEN
194: l_sequence_num := segments.sequence(i);