DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER1 dependencies on FND_ID_FLEX_SEGMENTS

Line 31: (segname fnd_id_flex_segments.segment_name%TYPE,

27: start_valid DATE,
28: end_valid DATE);
29:
30: TYPE SegmentInfo IS RECORD
31: (segname fnd_id_flex_segments.segment_name%TYPE,
32: colname fnd_id_flex_segments.application_column_name%TYPE,
33: coltype fnd_columns.column_type%TYPE,
34: collen fnd_columns.width%TYPE,
35: required fnd_id_flex_segments.required_flag%TYPE,

Line 32: colname fnd_id_flex_segments.application_column_name%TYPE,

28: end_valid DATE);
29:
30: TYPE SegmentInfo IS RECORD
31: (segname fnd_id_flex_segments.segment_name%TYPE,
32: colname fnd_id_flex_segments.application_column_name%TYPE,
33: coltype fnd_columns.column_type%TYPE,
34: collen fnd_columns.width%TYPE,
35: required fnd_id_flex_segments.required_flag%TYPE,
36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,

Line 35: required fnd_id_flex_segments.required_flag%TYPE,

31: (segname fnd_id_flex_segments.segment_name%TYPE,
32: colname fnd_id_flex_segments.application_column_name%TYPE,
33: coltype fnd_columns.column_type%TYPE,
34: collen fnd_columns.width%TYPE,
35: required fnd_id_flex_segments.required_flag%TYPE,
36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,
37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,

Line 36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,

32: colname fnd_id_flex_segments.application_column_name%TYPE,
33: coltype fnd_columns.column_type%TYPE,
34: collen fnd_columns.width%TYPE,
35: required fnd_id_flex_segments.required_flag%TYPE,
36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,
37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,

Line 37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,

33: coltype fnd_columns.column_type%TYPE,
34: collen fnd_columns.width%TYPE,
35: required fnd_id_flex_segments.required_flag%TYPE,
36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,
37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,
41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,

Line 38: dflt_type fnd_id_flex_segments.default_type%TYPE,

34: collen fnd_columns.width%TYPE,
35: required fnd_id_flex_segments.required_flag%TYPE,
36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,
37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,
41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);

Line 39: dflt_val fnd_id_flex_segments.default_value%TYPE,

35: required fnd_id_flex_segments.required_flag%TYPE,
36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,
37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,
41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);
43:

Line 40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,

36: segsecure fnd_id_flex_segments.security_enabled_flag%TYPE,
37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,
41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);
43:
44: TYPE ValueSetInfo IS RECORD

Line 41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,

37: catdesclen fnd_id_flex_segments.concatenation_description_len%TYPE,
38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,
41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);
43:
44: TYPE ValueSetInfo IS RECORD
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,

Line 42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);

38: dflt_type fnd_id_flex_segments.default_type%TYPE,
39: dflt_val fnd_id_flex_segments.default_value%TYPE,
40: vsid fnd_id_flex_segments.flex_value_set_id%TYPE,
41: runtime_property_function fnd_id_flex_segments.runtime_property_function%TYPE,
42: additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE);
43:
44: TYPE ValueSetInfo IS RECORD
45: (vsid fnd_flex_value_sets.flex_value_set_id%TYPE,
46: parent_vsid fnd_flex_value_sets.parent_flex_value_set_id%TYPE,

Line 632: FROM fnd_id_flex_segments

628: l_return_code NUMBER;
629:
630: CURSOR KeySegC(keystruct in FlexStructId) IS
631: SELECT segment_name, flex_value_set_id, security_enabled_flag
632: FROM fnd_id_flex_segments
633: WHERE application_id = keystruct.application_id
634: AND id_flex_code = keystruct.id_flex_code
635: AND id_flex_num = keystruct.id_flex_num
636: AND enabled_flag = 'Y'

Line 933: FROM fnd_id_flex_segments g, fnd_columns c

929: g.concatenation_description_len,
930: g.default_type, g.default_value, g.flex_value_set_id,
931: g.runtime_property_function,
932: g.additional_where_clause
933: FROM fnd_id_flex_segments g, fnd_columns c
934: WHERE g.application_id = keystruct.application_id
935: AND g.id_flex_code = keystruct.id_flex_code
936: AND g.id_flex_num = keystruct.id_flex_num
937: AND g.enabled_flag = 'Y'