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.JTF_JFLEX_PUB dependencies on FND_VSET

Line 29: l_valueset_info FND_VSET.valueset_r;

25: l_segments FND_DFLEX.segments_dr;
26: l_index BINARY_INTEGER;
27: l_segment_index BINARY_INTEGER;
28: l_count BINARY_INTEGER;
29: l_valueset_info FND_VSET.valueset_r;
30: l_valueset_format FND_VSET.valueset_dr;
31: l_valueset_found BOOLEAN;
32: l_setvalue FND_VSET.value_dr;
33: l_rowcount NUMBER;

Line 30: l_valueset_format FND_VSET.valueset_dr;

26: l_index BINARY_INTEGER;
27: l_segment_index BINARY_INTEGER;
28: l_count BINARY_INTEGER;
29: l_valueset_info FND_VSET.valueset_r;
30: l_valueset_format FND_VSET.valueset_dr;
31: l_valueset_found BOOLEAN;
32: l_setvalue FND_VSET.value_dr;
33: l_rowcount NUMBER;
34: l_found BOOLEAN;

Line 32: l_setvalue FND_VSET.value_dr;

28: l_count BINARY_INTEGER;
29: l_valueset_info FND_VSET.valueset_r;
30: l_valueset_format FND_VSET.valueset_dr;
31: l_valueset_found BOOLEAN;
32: l_setvalue FND_VSET.value_dr;
33: l_rowcount NUMBER;
34: l_found BOOLEAN;
35:
36: --l_valueset AS_OFL_FLEXSUPPORT_PKG.valueset_rec;

Line 106: FND_VSET.Get_valueset(l_segments.value_set(l_segment_index), l_valueset_info, l_valueset_format);

102:
103: -- we only deal with valuesets of validation type independent or none
104: -- default for segment is validation type none
105: BEGIN
106: FND_VSET.Get_valueset(l_segments.value_set(l_segment_index), l_valueset_info, l_valueset_format);
107: l_valueset_found := true;
108:
109: If (l_valueset_info.validation_type = 'I') Then
110: FND_VSET.get_value_init(l_valueset_info, TRUE);

Line 110: FND_VSET.get_value_init(l_valueset_info, TRUE);

106: FND_VSET.Get_valueset(l_segments.value_set(l_segment_index), l_valueset_info, l_valueset_format);
107: l_valueset_found := true;
108:
109: If (l_valueset_info.validation_type = 'I') Then
110: FND_VSET.get_value_init(l_valueset_info, TRUE);
111: l_count := 0;
112: LOOP
113: FND_VSET.get_value(l_valueset_info, l_rowcount, l_found, l_setvalue);
114: EXIT WHEN l_found <> TRUE;

Line 113: FND_VSET.get_value(l_valueset_info, l_rowcount, l_found, l_setvalue);

109: If (l_valueset_info.validation_type = 'I') Then
110: FND_VSET.get_value_init(l_valueset_info, TRUE);
111: l_count := 0;
112: LOOP
113: FND_VSET.get_value(l_valueset_info, l_rowcount, l_found, l_setvalue);
114: EXIT WHEN l_found <> TRUE;
115: l_count := l_count +1;
116: END LOOP;
117: FND_VSET.get_value_end(l_valueset_info);

Line 117: FND_VSET.get_value_end(l_valueset_info);

113: FND_VSET.get_value(l_valueset_info, l_rowcount, l_found, l_setvalue);
114: EXIT WHEN l_found <> TRUE;
115: l_count := l_count +1;
116: END LOOP;
117: FND_VSET.get_value_end(l_valueset_info);
118: End If;
119:
120: EXCEPTION
121: WHEN no_data_found THEN

Line 174: l_valueset_info FND_VSET.valueset_r;

170:
171: procedure Get_ValueSet(p_valueset_id IN number,
172: x_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300 ,
173: x_meaning OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300) IS
174: l_valueset_info FND_VSET.valueset_r;
175: l_valueset_format FND_VSET.valueset_dr;
176: l_setvalue FND_VSET.value_dr;
177: l_rowcount NUMBER;
178: l_count NUMBER;

Line 175: l_valueset_format FND_VSET.valueset_dr;

171: procedure Get_ValueSet(p_valueset_id IN number,
172: x_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300 ,
173: x_meaning OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300) IS
174: l_valueset_info FND_VSET.valueset_r;
175: l_valueset_format FND_VSET.valueset_dr;
176: l_setvalue FND_VSET.value_dr;
177: l_rowcount NUMBER;
178: l_count NUMBER;
179: l_found BOOLEAN;

Line 176: l_setvalue FND_VSET.value_dr;

172: x_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300 ,
173: x_meaning OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300) IS
174: l_valueset_info FND_VSET.valueset_r;
175: l_valueset_format FND_VSET.valueset_dr;
176: l_setvalue FND_VSET.value_dr;
177: l_rowcount NUMBER;
178: l_count NUMBER;
179: l_found BOOLEAN;
180: BEGIN

Line 181: FND_VSET.Get_ValueSet(p_valueset_id, l_valueset_info, l_valueset_format);

177: l_rowcount NUMBER;
178: l_count NUMBER;
179: l_found BOOLEAN;
180: BEGIN
181: FND_VSET.Get_ValueSet(p_valueset_id, l_valueset_info, l_valueset_format);
182: -- no exception, valueset information retrieved.
183: FND_VSET.get_value_init(l_valueset_info, TRUE);
184: x_value := jtf_varchar2_table_300();
185: x_meaning := jtf_varchar2_table_300();

Line 183: FND_VSET.get_value_init(l_valueset_info, TRUE);

179: l_found BOOLEAN;
180: BEGIN
181: FND_VSET.Get_ValueSet(p_valueset_id, l_valueset_info, l_valueset_format);
182: -- no exception, valueset information retrieved.
183: FND_VSET.get_value_init(l_valueset_info, TRUE);
184: x_value := jtf_varchar2_table_300();
185: x_meaning := jtf_varchar2_table_300();
186: l_count := 1;
187: LOOP

Line 188: FND_VSET.get_value(l_valueset_info, l_rowcount, l_found, l_setvalue);

184: x_value := jtf_varchar2_table_300();
185: x_meaning := jtf_varchar2_table_300();
186: l_count := 1;
187: LOOP
188: FND_VSET.get_value(l_valueset_info, l_rowcount, l_found, l_setvalue);
189: EXIT WHEN l_found <> TRUE;
190: x_value.extend;
191: x_meaning.extend;
192: x_value(l_count) := l_setvalue.value;

Line 196: FND_VSET.get_value_end(l_valueset_info);

192: x_value(l_count) := l_setvalue.value;
193: x_meaning(l_count) := l_setvalue.meaning;
194: l_count := l_count +1;
195: END LOOP;
196: FND_VSET.get_value_end(l_valueset_info);
197: EXCEPTION
198: WHEN OTHERS THEN
199: --dbms_output.put_line('Exception caught');
200: RETURN;