DBA Data[Home] [Help]

APPS.QP_UPGRADE_UTIL dependencies on FND_DFLEX

Line 108: P_FLEXFIELD FND_DFLEX.DFLEX_R;

104: , P_NEW_PRODUCT IN VARCHAR2
105: , P_FLEXFIELD_NAME IN VARCHAR2
106: , P_NEW_FLEXFIELD_NAME IN VARCHAR2)
107: IS
108: P_FLEXFIELD FND_DFLEX.DFLEX_R;
109: P_FLEXINFO FND_DFLEX.DFLEX_DR;
110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;

Line 109: P_FLEXINFO FND_DFLEX.DFLEX_DR;

105: , P_FLEXFIELD_NAME IN VARCHAR2
106: , P_NEW_FLEXFIELD_NAME IN VARCHAR2)
107: IS
108: P_FLEXFIELD FND_DFLEX.DFLEX_R;
109: P_FLEXINFO FND_DFLEX.DFLEX_DR;
110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;
113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;

Line 110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;

106: , P_NEW_FLEXFIELD_NAME IN VARCHAR2)
107: IS
108: P_FLEXFIELD FND_DFLEX.DFLEX_R;
109: P_FLEXINFO FND_DFLEX.DFLEX_DR;
110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;
113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
114: NEW_GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;

Line 111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;

107: IS
108: P_FLEXFIELD FND_DFLEX.DFLEX_R;
109: P_FLEXINFO FND_DFLEX.DFLEX_DR;
110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;
113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
114: NEW_GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
115: L_REQUIRED VARCHAR2(5);

Line 112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;

108: P_FLEXFIELD FND_DFLEX.DFLEX_R;
109: P_FLEXINFO FND_DFLEX.DFLEX_DR;
110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;
113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
114: NEW_GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
115: L_REQUIRED VARCHAR2(5);
116: L_ENABLED VARCHAR2(5);

Line 113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;

109: P_FLEXINFO FND_DFLEX.DFLEX_DR;
110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;
113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
114: NEW_GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
115: L_REQUIRED VARCHAR2(5);
116: L_ENABLED VARCHAR2(5);
117: L_DISPLAYED VARCHAR2(5);

Line 114: NEW_GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;

110: L_CONTEXTS FND_DFLEX.CONTEXTS_DR;
111: GDE_CONTEXTS FND_DFLEX.CONTEXTS_DR;
112: L_SEGMENTS FND_DFLEX.SEGMENTS_DR;
113: GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
114: NEW_GDE_SEGMENTS FND_DFLEX.SEGMENTS_DR;
115: L_REQUIRED VARCHAR2(5);
116: L_ENABLED VARCHAR2(5);
117: L_DISPLAYED VARCHAR2(5);
118:

Line 147: FND_DFLEX.GET_FLEXFIELD( P_NEW_PRODUCT

143: P_NEW_FLEXFIELD_NAME )) THEN
144: --dbms_output.put_line ('Entered the Processing');
145: IF (P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
146: -- Get the New Global Data Elements Context and Its Segments
147: FND_DFLEX.GET_FLEXFIELD( P_NEW_PRODUCT
148: , P_NEW_FLEXFIELD_NAME
149: , P_FLEXFIELD
150: , P_FLEXINFO );
151:

Line 153: FND_DFLEX.GET_CONTEXTS( P_FLEXFIELD, L_CONTEXTS );

149: , P_FLEXFIELD
150: , P_FLEXINFO );
151:
152: -- Get all contexts for the flexfield
153: FND_DFLEX.GET_CONTEXTS( P_FLEXFIELD, L_CONTEXTS );
154:
155: -- Get the Context Code for New Global Data Elements Context (if any)
156: FOR I IN 1..L_CONTEXTS.NCONTEXTS LOOP
157: --dbms_output.put_line ('Found the Old GDE Context');

Line 159: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , OLD_GDE_CONTEXT_CODE)

155: -- Get the Context Code for New Global Data Elements Context (if any)
156: FOR I IN 1..L_CONTEXTS.NCONTEXTS LOOP
157: --dbms_output.put_line ('Found the Old GDE Context');
158: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE) THEN
159: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , OLD_GDE_CONTEXT_CODE)
160: ,NEW_GDE_SEGMENTS
161: , FALSE ) ;
162: END IF;
163: EXIT;

Line 184: FND_DFLEX.GET_FLEXFIELD(

180: END IF;
181: vivek */
182: --dbms_output.put_line('Starting the actual Migration');
183: -- Now start the migration of contexts and segments
184: FND_DFLEX.GET_FLEXFIELD(
185: P_PRODUCT
186: , P_FLEXFIELD_NAME
187: , P_FLEXFIELD
188: , P_FLEXINFO );

Line 190: FND_DFLEX.GET_CONTEXTS( P_FLEXFIELD, L_CONTEXTS );

186: , P_FLEXFIELD_NAME
187: , P_FLEXFIELD
188: , P_FLEXINFO );
189:
190: FND_DFLEX.GET_CONTEXTS( P_FLEXFIELD, L_CONTEXTS );
191:
192: -- Store all the old contexts
193: GDE_CONTEXTS := L_CONTEXTS;
194:

Line 226: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))

222: , P_NEW_FLEXFIELD_NAME
223: , 'ATTRIBUTE[0-9]+');
224:
225: vivek */
226: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))
227: ,L_SEGMENTS
228: , FALSE ) ;
229:
230:

Line 356: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))

352: , P_NEW_FLEXFIELD_NAME
353: , 'ATTRIBUTE[0-9]+');
354: vivek */
355:
356: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))
357: ,L_SEGMENTS
358: , FALSE ) ;
359:
360: L_SEGMENT_COUNT := L_SEGMENTS.NSEGMENTS;