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_VSET

Line 12: TEST_REC FND_VSET.VALUESET_R;

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;
16: I BINARY_INTEGER;

Line 14: TEST_FREC FND_VSET.VALUESET_DR;

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;
16: I BINARY_INTEGER;
17: J BINARY_INTEGER;
18: SEGMENTS FND_DFLEX.SEGMENTS_DR;

Line 29: FND_VSET.GET_VALUESET(X_VALUESETID,TEST_REC,TEST_FREC);

25: X_VALUESETID := SEGMENTS.VALUE_SET(J);
26: END IF;
27: END LOOP;
28: IF X_VALUESETID IS NOT NULL THEN
29: FND_VSET.GET_VALUESET(X_VALUESETID,TEST_REC,TEST_FREC);
30: X_VSID :=X_VALUESETID;
31: X_FORMAT_TYPE :=TEST_FREC.FORMAT_TYPE;
32: X_VALIDATION_TYPE :=TEST_REC.VALIDATION_TYPE;
33: ELSE

Line 101: v_vset fnd_vset.valueset_r;

97: -- =======================================================================
98:
99:
100: FUNCTION value_exists(p_vsid IN NUMBER,p_value IN VARCHAR2) RETURN BOOLEAN IS
101: v_vset fnd_vset.valueset_r;
102: v_fmt fnd_vset.valueset_dr;
103: v_found BOOLEAN;
104: v_row NUMBER;
105: v_value fnd_vset.value_dr;

Line 102: v_fmt fnd_vset.valueset_dr;

98:
99:
100: FUNCTION value_exists(p_vsid IN NUMBER,p_value IN VARCHAR2) RETURN BOOLEAN IS
101: v_vset fnd_vset.valueset_r;
102: v_fmt fnd_vset.valueset_dr;
103: v_found BOOLEAN;
104: v_row NUMBER;
105: v_value fnd_vset.value_dr;
106: BEGIN

Line 105: v_value fnd_vset.value_dr;

101: v_vset fnd_vset.valueset_r;
102: v_fmt fnd_vset.valueset_dr;
103: v_found BOOLEAN;
104: v_row NUMBER;
105: v_value fnd_vset.value_dr;
106: BEGIN
107: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
108: fnd_vset.get_value_init(v_vset, TRUE);
109: fnd_vset.get_value(v_vset, v_row, v_found, v_value);

Line 107: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);

103: v_found BOOLEAN;
104: v_row NUMBER;
105: v_value fnd_vset.value_dr;
106: BEGIN
107: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
108: fnd_vset.get_value_init(v_vset, TRUE);
109: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
110:
111: WHILE(v_found) LOOP

Line 108: fnd_vset.get_value_init(v_vset, TRUE);

104: v_row NUMBER;
105: v_value fnd_vset.value_dr;
106: BEGIN
107: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
108: fnd_vset.get_value_init(v_vset, TRUE);
109: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
110:
111: WHILE(v_found) LOOP
112: IF (v_value.value = p_value) THEN

Line 109: fnd_vset.get_value(v_vset, v_row, v_found, v_value);

105: v_value fnd_vset.value_dr;
106: BEGIN
107: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
108: fnd_vset.get_value_init(v_vset, TRUE);
109: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
110:
111: WHILE(v_found) LOOP
112: IF (v_value.value = p_value) THEN
113: fnd_vset.get_value_end(v_vset);

Line 113: fnd_vset.get_value_end(v_vset);

109: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
110:
111: WHILE(v_found) LOOP
112: IF (v_value.value = p_value) THEN
113: fnd_vset.get_value_end(v_vset);
114: RETURN TRUE;
115: END IF;
116: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
117: END LOOP;

Line 116: fnd_vset.get_value(v_vset, v_row, v_found, v_value);

112: IF (v_value.value = p_value) THEN
113: fnd_vset.get_value_end(v_vset);
114: RETURN TRUE;
115: END IF;
116: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
117: END LOOP;
118: fnd_vset.get_value_end(v_vset);
119: RETURN FALSE;
120: END value_exists;

Line 118: fnd_vset.get_value_end(v_vset);

114: RETURN TRUE;
115: END IF;
116: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
117: END LOOP;
118: fnd_vset.get_value_end(v_vset);
119: RETURN FALSE;
120: END value_exists;
121:
122:

Line 181: v_valueset_r fnd_vset.valueset_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;
183: v_valueset_dr fnd_vset.valueset_dr;
184: v_dflex_dr fnd_dflex.dflex_dr;
185: v_flexfield_val_ind NUMBER DEFAULT 0;

Line 182: v_format_dr fnd_vset.valueset_dr;

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;
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);

Line 183: v_valueset_dr fnd_vset.valueset_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;
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);

Line 265: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);

261: RETURN;
262: END IF;
263:
264: -- Get value set information and validate the value passed.
265: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);
266:
267: datatype := v_valueset_dr.format_type;
268:
269: -- check if there is any value set attached to the segment

Line 353: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,

349:
350: END GET_PROD_FLEX_PROPERTIES;
351:
352:
353: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
354: p_value VARCHAR2,
355: x_id OUT NOCOPY VARCHAR2,
356: x_value OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
357: