eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_UTIL_PUB dependencies on FND_DFLEX

Line 10: FLEXFIELD FND_DFLEX.DFLEX_R;

6: P_SEG IN VARCHAR2 ,
7: X_VSID OUT NOCOPY NUMBER,
8: X_FORMAT_TYPE OUT NOCOPY VARCHAR2,
9: X_VALIDATION_TYPE OUT NOCOPY VARCHAR2)IS
10: FLEXFIELD FND_DFLEX.DFLEX_R;
11: FLEXINFO FND_DFLEX.DFLEX_DR;
12: TEST_REC FND_VSET.VALUESET_R;
13: X_VALUESETID NUMBER;
14: TEST_FREC FND_VSET.VALUESET_DR;

Line 11: FLEXINFO FND_DFLEX.DFLEX_DR;

7: X_VSID OUT NOCOPY NUMBER,
8: X_FORMAT_TYPE OUT NOCOPY VARCHAR2,
9: X_VALIDATION_TYPE OUT NOCOPY VARCHAR2)IS
10: FLEXFIELD FND_DFLEX.DFLEX_R;
11: FLEXINFO FND_DFLEX.DFLEX_DR;
12: TEST_REC FND_VSET.VALUESET_R;
13: X_VALUESETID NUMBER;
14: TEST_FREC FND_VSET.VALUESET_DR;
15: CONTEXTS FND_DFLEX.CONTEXTS_DR;

Line 15: CONTEXTS FND_DFLEX.CONTEXTS_DR;

11: FLEXINFO FND_DFLEX.DFLEX_DR;
12: TEST_REC FND_VSET.VALUESET_R;
13: X_VALUESETID NUMBER;
14: TEST_FREC FND_VSET.VALUESET_DR;
15: CONTEXTS FND_DFLEX.CONTEXTS_DR;
16: I BINARY_INTEGER;
17: J BINARY_INTEGER;
18: SEGMENTS FND_DFLEX.SEGMENTS_DR;
19: BEGIN

Line 18: SEGMENTS FND_DFLEX.SEGMENTS_DR;

14: TEST_FREC FND_VSET.VALUESET_DR;
15: CONTEXTS FND_DFLEX.CONTEXTS_DR;
16: I BINARY_INTEGER;
17: J BINARY_INTEGER;
18: SEGMENTS FND_DFLEX.SEGMENTS_DR;
19: BEGIN
20: FND_DFLEX.GET_FLEXFIELD('QP',P_FLEXFIELD_NAME,FLEXFIELD,FLEXINFO);
21: FND_DFLEX.GET_CONTEXTS(FLEXFIELD,CONTEXTS);
22: FND_DFLEX.GET_SEGMENTS(FND_DFLEX.MAKE_CONTEXT(FLEXFIELD,P_CONTEXT),SEGMENTS,TRUE);

Line 20: FND_DFLEX.GET_FLEXFIELD('QP',P_FLEXFIELD_NAME,FLEXFIELD,FLEXINFO);

16: I BINARY_INTEGER;
17: J BINARY_INTEGER;
18: SEGMENTS FND_DFLEX.SEGMENTS_DR;
19: BEGIN
20: FND_DFLEX.GET_FLEXFIELD('QP',P_FLEXFIELD_NAME,FLEXFIELD,FLEXINFO);
21: FND_DFLEX.GET_CONTEXTS(FLEXFIELD,CONTEXTS);
22: FND_DFLEX.GET_SEGMENTS(FND_DFLEX.MAKE_CONTEXT(FLEXFIELD,P_CONTEXT),SEGMENTS,TRUE);
23: FOR J IN 1..SEGMENTS.NSEGMENTS LOOP
24: IF SEGMENTS.SEGMENT_NAME(J) = P_SEG THEN

Line 21: FND_DFLEX.GET_CONTEXTS(FLEXFIELD,CONTEXTS);

17: J BINARY_INTEGER;
18: SEGMENTS FND_DFLEX.SEGMENTS_DR;
19: BEGIN
20: FND_DFLEX.GET_FLEXFIELD('QP',P_FLEXFIELD_NAME,FLEXFIELD,FLEXINFO);
21: FND_DFLEX.GET_CONTEXTS(FLEXFIELD,CONTEXTS);
22: FND_DFLEX.GET_SEGMENTS(FND_DFLEX.MAKE_CONTEXT(FLEXFIELD,P_CONTEXT),SEGMENTS,TRUE);
23: FOR J IN 1..SEGMENTS.NSEGMENTS LOOP
24: IF SEGMENTS.SEGMENT_NAME(J) = P_SEG THEN
25: X_VALUESETID := SEGMENTS.VALUE_SET(J);

Line 22: FND_DFLEX.GET_SEGMENTS(FND_DFLEX.MAKE_CONTEXT(FLEXFIELD,P_CONTEXT),SEGMENTS,TRUE);

18: SEGMENTS FND_DFLEX.SEGMENTS_DR;
19: BEGIN
20: FND_DFLEX.GET_FLEXFIELD('QP',P_FLEXFIELD_NAME,FLEXFIELD,FLEXINFO);
21: FND_DFLEX.GET_CONTEXTS(FLEXFIELD,CONTEXTS);
22: FND_DFLEX.GET_SEGMENTS(FND_DFLEX.MAKE_CONTEXT(FLEXFIELD,P_CONTEXT),SEGMENTS,TRUE);
23: FOR J IN 1..SEGMENTS.NSEGMENTS LOOP
24: IF SEGMENTS.SEGMENT_NAME(J) = P_SEG THEN
25: X_VALUESETID := SEGMENTS.VALUE_SET(J);
26: END IF;

Line 42: p_context_dr fnd_dflex.contexts_dr,

38: END IF;
39: END GET_VALUESET_ID;
40:
41: FUNCTION context_exists(p_context VARCHAR2,
42: p_context_dr fnd_dflex.contexts_dr,
43: p_context_r OUT NOCOPY fnd_dflex.context_r ) RETURN BOOLEAN IS
44: BEGIN
45: IF (p_context_dr.ncontexts > 0) THEN
46: FOR i IN 1..p_context_dr.ncontexts LOOP

Line 43: p_context_r OUT NOCOPY fnd_dflex.context_r ) RETURN BOOLEAN IS

39: END GET_VALUESET_ID;
40:
41: FUNCTION context_exists(p_context VARCHAR2,
42: p_context_dr fnd_dflex.contexts_dr,
43: p_context_r OUT NOCOPY fnd_dflex.context_r ) RETURN BOOLEAN IS
44: BEGIN
45: IF (p_context_dr.ncontexts > 0) THEN
46: FOR i IN 1..p_context_dr.ncontexts LOOP
47: IF (p_context = p_context_dr.context_code(i)

Line 60: p_segments_dr IN fnd_dflex.segments_dr,

56: END IF;
57: END Context_exists;
58:
59: FUNCTION segment_exists(p_segment_name IN VARCHAR2,
60: p_segments_dr IN fnd_dflex.segments_dr,
61: p_check_enabled IN BOOLEAN := TRUE,
62: p_value_set_id OUT NOCOPY NUMBER,
63: p_precedence OUT NOCOPY NUMBER) RETURN BOOLEAN IS
64: BEGIN

Line 175: v_context_dr fnd_dflex.contexts_dr;

171: SELECT application_id
172: FROM fnd_application
173: WHERE application_short_name = app_short_name;
174:
175: v_context_dr fnd_dflex.contexts_dr;
176: v_dflex_r fnd_dflex.dflex_r;
177: v_context_r fnd_dflex.context_r;
178: v_segments_dr fnd_dflex.segments_dr;
179: v_value_set_id NUMBER;

Line 176: v_dflex_r fnd_dflex.dflex_r;

172: FROM fnd_application
173: WHERE application_short_name = app_short_name;
174:
175: v_context_dr fnd_dflex.contexts_dr;
176: v_dflex_r fnd_dflex.dflex_r;
177: v_context_r fnd_dflex.context_r;
178: v_segments_dr fnd_dflex.segments_dr;
179: v_value_set_id NUMBER;
180: v_precedence NUMBER;

Line 177: v_context_r fnd_dflex.context_r;

173: WHERE application_short_name = app_short_name;
174:
175: v_context_dr fnd_dflex.contexts_dr;
176: v_dflex_r fnd_dflex.dflex_r;
177: v_context_r fnd_dflex.context_r;
178: v_segments_dr fnd_dflex.segments_dr;
179: v_value_set_id NUMBER;
180: v_precedence NUMBER;
181: v_valueset_r fnd_vset.valueset_r;

Line 178: v_segments_dr fnd_dflex.segments_dr;

174:
175: v_context_dr fnd_dflex.contexts_dr;
176: v_dflex_r fnd_dflex.dflex_r;
177: v_context_r fnd_dflex.context_r;
178: v_segments_dr fnd_dflex.segments_dr;
179: v_value_set_id NUMBER;
180: v_precedence NUMBER;
181: v_valueset_r fnd_vset.valueset_r;
182: v_format_dr fnd_vset.valueset_dr;

Line 184: v_dflex_dr fnd_dflex.dflex_dr;

180: v_precedence NUMBER;
181: v_valueset_r fnd_vset.valueset_r;
182: v_format_dr fnd_vset.valueset_dr;
183: v_valueset_dr fnd_vset.valueset_dr;
184: v_dflex_dr fnd_dflex.dflex_dr;
185: v_flexfield_val_ind NUMBER DEFAULT 0;
186: l_value VARCHAR2(150);
187: l_id VARCHAR2(150);
188: BEGIN

Line 227: fnd_dflex.get_flexfield(application_short_name,flexfield_name,v_dflex_r,v_dflex_dr);

223: CLOSE Cur_get_application_id;
224:
225: -- check if flexfield name passed is a valid one or not.
226: v_flexfield_val_ind:= 1;
227: fnd_dflex.get_flexfield(application_short_name,flexfield_name,v_dflex_r,v_dflex_dr);
228:
229: -- Get the context listing for the flexfield
230: fnd_dflex.get_contexts(v_dflex_r,v_context_dr);
231:

Line 230: fnd_dflex.get_contexts(v_dflex_r,v_context_dr);

226: v_flexfield_val_ind:= 1;
227: fnd_dflex.get_flexfield(application_short_name,flexfield_name,v_dflex_r,v_dflex_dr);
228:
229: -- Get the context listing for the flexfield
230: fnd_dflex.get_contexts(v_dflex_r,v_context_dr);
231:
232: IF (context_exists(context,v_context_dr,v_context_r) = TRUE) THEN
233: context_flag := 'Y';
234: ELSE

Line 244: --fnd_dflex.get_segments(v_context_r,v_segments_dr,TRUE);

240: v_context_r.flexfield := v_dflex_r;
241:
242: -- Get the enabled segments for the context selected.
243:
244: --fnd_dflex.get_segments(v_context_r,v_segments_dr,TRUE);
245: fnd_dflex.get_segments(v_context_r,v_segments_dr,FALSE);
246:
247: IF (segment_exists(attribute,v_segments_dr,check_enabled,v_value_set_id,v_precedence) = TRUE) THEN
248: IF (v_precedence IS NOT NULL) THEN

Line 245: fnd_dflex.get_segments(v_context_r,v_segments_dr,FALSE);

241:
242: -- Get the enabled segments for the context selected.
243:
244: --fnd_dflex.get_segments(v_context_r,v_segments_dr,TRUE);
245: fnd_dflex.get_segments(v_context_r,v_segments_dr,FALSE);
246:
247: IF (segment_exists(attribute,v_segments_dr,check_enabled,v_value_set_id,v_precedence) = TRUE) THEN
248: IF (v_precedence IS NOT NULL) THEN
249: precedence := v_precedence;