170: APPLICATION_ID
171: FROM
172: FND_APPLICATION
173: WHERE APPLICATION_SHORT_NAME = APP_SHORT_NAME;
174: V_DFLEX_R FND_DFLEX.DFLEX_R;
175: V_SEGMENTS_DR FND_DFLEX.SEGMENTS_DR;
176: V_CONTEXT_R FND_DFLEX.CONTEXT_R;
177: BEGIN
178: OPEN CUR_GET_APPLICATION_ID('QP');
171: FROM
172: FND_APPLICATION
173: WHERE APPLICATION_SHORT_NAME = APP_SHORT_NAME;
174: V_DFLEX_R FND_DFLEX.DFLEX_R;
175: V_SEGMENTS_DR FND_DFLEX.SEGMENTS_DR;
176: V_CONTEXT_R FND_DFLEX.CONTEXT_R;
177: BEGIN
178: OPEN CUR_GET_APPLICATION_ID('QP');
179: FETCH CUR_GET_APPLICATION_ID
172: FND_APPLICATION
173: WHERE APPLICATION_SHORT_NAME = APP_SHORT_NAME;
174: V_DFLEX_R FND_DFLEX.DFLEX_R;
175: V_SEGMENTS_DR FND_DFLEX.SEGMENTS_DR;
176: V_CONTEXT_R FND_DFLEX.CONTEXT_R;
177: BEGIN
178: OPEN CUR_GET_APPLICATION_ID('QP');
179: FETCH CUR_GET_APPLICATION_ID
180: INTO V_DFLEX_R.APPLICATION_ID;
181: CLOSE CUR_GET_APPLICATION_ID;
182: V_DFLEX_R.FLEXFIELD_NAME := 'QP_ATTR_DEFNS_QUALIFIER';
183: V_CONTEXT_R.FLEXFIELD := V_DFLEX_R;
184: V_CONTEXT_R.CONTEXT_CODE := QUALIFIER_CONTEXT;
185: FND_DFLEX.GET_SEGMENTS(V_CONTEXT_R
186: ,V_SEGMENTS_DR
187: ,TRUE);
188: IF (V_SEGMENTS_DR.NSEGMENTS > 0) THEN
189: FOR i IN 1 .. V_SEGMENTS_DR.NSEGMENTS LOOP