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.FND_FLEX_KEYVAL dependencies on FND_FLEX_SERVER

Line 28: value_vals FND_FLEX_SERVER1.ValueArray;

24: -- PRIVATE GLOBAL VARIABLES
25: --
26:
27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;

Line 29: value_svals FND_FLEX_SERVER1.ValueArray;

25: --
26:
27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;

Line 30: value_ids FND_FLEX_SERVER1.ValueIdArray;

26:
27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;

Line 31: value_descs FND_FLEX_SERVER1.ValueDescArray;

27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;

Line 32: value_desclens FND_FLEX_SERVER1.NumberArray;

28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

Line 33: cc_cols FND_FLEX_SERVER1.TabColArray;

29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;

Line 34: cc_coltypes FND_FLEX_SERVER1.CharArray;

30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;

Line 35: segtypes FND_FLEX_SERVER1.SegFormats;

31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;

Line 36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;

Line 37: derv FND_FLEX_SERVER1.DerivedVals;

33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;

Line 38: tbl_derv FND_FLEX_SERVER1.DerivedVals;

34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;

Line 39: drv_quals FND_FLEX_SERVER1.Qualifiers;

35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;
43: ccid NUMBER;

Line 40: tbl_quals FND_FLEX_SERVER1.Qualifiers;

36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;
43: ccid NUMBER;
44: delim VARCHAR2(1);

Line 42: xcol_vals FND_FLEX_SERVER1.StringArray;

38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;
43: ccid NUMBER;
44: delim VARCHAR2(1);
45: err_segn NUMBER;
46: err_msg VARCHAR2(2000);

Line 162: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,

158: FND_MESSAGE.set_token('FUNCTNAME', operation);
159: goto cleanup_and_return;
160: end if;
161:
162: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,
163: appl_short_name, key_flex_code,
164: select_comb_from_view, structure_number,
165: validation_date, vrule, data_set, invoking_mode,
166: validate_mode, dins_flag, 'Y', required_flag, nulls_ok,

Line 178: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);

174:
175: -- Set status flags. Secured also set if any segment is secured and there
176: -- is some other error.
177: --
178: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

Line 179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or

175: -- Set status flags. Secured also set if any segment is secured and there
176: -- is some other error.
177: --
178: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
183: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

Line 180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

176: -- is some other error.
177: --
178: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
183: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
184:

Line 181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);

177: --
178: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
183: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
184:
185: -- Get message if not valid.

Line 182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

178: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
183: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
184:
185: -- Get message if not valid.
186: -- Erase only the combination_id, and table columns if just checking

Line 183: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

179: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
180: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
181: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
182: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
183: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
184:
185: -- Get message if not valid.
186: -- Erase only the combination_id, and table columns if just checking
187: -- segments, otherwise erase everything but the status and error message.

Line 255: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,

251: FND_MESSAGE.set_name('FND', 'FLEX-BAD SECURITY');
252: goto cleanup_and_return;
253: end if;
254:
255: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,
256: appl_short_name, key_flex_code,
257: select_comb_from_view, structure_number,
258: NULL, vrule, data_set, 'L', 'FULL', 'N', q_security, 'N', 'N',
259: displayable, NULL, 'V', NULL, NULL, NULL, get_columns,

Line 269: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or

265:
266: -- Set validation status flags.
267: -- Also valid if secured, but not enforcing it.
268: --
269: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
270: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
271: (q_security <> 'Y')));
272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

Line 270: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and

266: -- Set validation status flags.
267: -- Also valid if secured, but not enforcing it.
268: --
269: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
270: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
271: (q_security <> 'Y')));
272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);

Line 272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or

268: --
269: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
270: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
271: (q_security <> 'Y')));
272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
275: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
276: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

Line 273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

269: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
270: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
271: (q_security <> 'Y')));
272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
275: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
276: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
277:

Line 274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);

270: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
271: (q_security <> 'Y')));
272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
275: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
276: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
277:
278: -- Get message and erase all but error if not valid

Line 275: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

271: (q_security <> 'Y')));
272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
275: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
276: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
277:
278: -- Get message and erase all but error if not valid
279: --

Line 276: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

272: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
273: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
274: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
275: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
276: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
277:
278: -- Get message and erase all but error if not valid
279: --
280: <>

Line 362: return(FND_FLEX_SERVER.concatenate_values(nvalidated, value_vals,

358:
359: FUNCTION concatenated_values RETURN VARCHAR2 IS
360: BEGIN
361: IF (sta_valid) THEN
362: return(FND_FLEX_SERVER.concatenate_values(nvalidated, value_vals,
363: disp_segs, delim));
364: ELSE
365: raise_application_error
366: (-20001, ('Developer Error: KVL.concatenated_values should not ' ||

Line 375: return(FND_FLEX_SERVER.concatenate_ids(nvalidated, value_ids, delim));

371:
372: FUNCTION concatenated_ids RETURN VARCHAR2 IS
373: BEGIN
374: IF (sta_valid) THEN
375: return(FND_FLEX_SERVER.concatenate_ids(nvalidated, value_ids, delim));
376: ELSE
377: raise_application_error
378: (-20001, ('Developer Error: KVL.concatenated_ids should not ' ||
379: 'be called if validation fails.'));

Line 387: return(FND_FLEX_SERVER.concatenate_descriptions(nvalidated,

383:
384: FUNCTION concatenated_descriptions RETURN VARCHAR2 IS
385: BEGIN
386: IF (sta_valid) THEN
387: return(FND_FLEX_SERVER.concatenate_descriptions(nvalidated,
388: value_descs, disp_segs, value_desclens, delim));
389: ELSE
390: raise_application_error
391: (-20001, ('Developer Error: KVL.concatenated_descriptions should not '||

Line 477: return(SUBSTR(segcodes, segnum, 1) = FND_FLEX_SERVER1.FF_VVALID);

473:
474: FUNCTION segment_valid(segnum IN NUMBER) RETURN BOOLEAN IS
475: BEGIN
476: if((segcodes is not null) and (segnum between 1 and LENGTH(segcodes))) then
477: return(SUBSTR(segcodes, segnum, 1) = FND_FLEX_SERVER1.FF_VVALID);
478: end if;
479: return(FALSE);
480: END segment_valid;
481:

Line 573: if(FND_FLEX_SERVER1.init_globals = FALSE) then

569: BEGIN
570: --
571: -- Initialize messages, debugging, and number of sql strings
572: --
573: if(FND_FLEX_SERVER1.init_globals = FALSE) then
574: return(FALSE);
575: end if;
576:
577: --