7:
8: TYPE FlexfieldAttributeTabType IS TABLE OF VARCHAR2(150) index by binary_integer;
9: /* unique identifier of a dflexfield: */
10: /*TYPE dflex_r IS RECORD (application_id fnd_application.application_id%TYPE,
11: flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE);
12: */
13: /* public */
14: /*This has been copied from fnd_dflex.dflex_dr, added the context_required field*/
15: TYPE dflex_dr IS RECORD (title fnd_descriptive_flexs_vl.title%TYPE,
11: flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE);
12: */
13: /* public */
14: /*This has been copied from fnd_dflex.dflex_dr, added the context_required field*/
15: TYPE dflex_dr IS RECORD (title fnd_descriptive_flexs_vl.title%TYPE,
16: table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
17: table_app fnd_application.application_short_name%TYPE,
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
12: */
13: /* public */
14: /*This has been copied from fnd_dflex.dflex_dr, added the context_required field*/
15: TYPE dflex_dr IS RECORD (title fnd_descriptive_flexs_vl.title%TYPE,
16: table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
17: table_app fnd_application.application_short_name%TYPE,
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
14: /*This has been copied from fnd_dflex.dflex_dr, added the context_required field*/
15: TYPE dflex_dr IS RECORD (title fnd_descriptive_flexs_vl.title%TYPE,
16: table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
17: table_app fnd_application.application_short_name%TYPE,
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
15: TYPE dflex_dr IS RECORD (title fnd_descriptive_flexs_vl.title%TYPE,
16: table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
17: table_app fnd_application.application_short_name%TYPE,
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
16: table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
17: table_app fnd_application.application_short_name%TYPE,
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
24: context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE,
17: table_app fnd_application.application_short_name%TYPE,
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
24: context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE,
25: context_required fnd_descriptive_flexs_vl.context_required_flag%TYPE);
18: description fnd_descriptive_flexs_vl.description%TYPE,
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
24: context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE,
25: context_required fnd_descriptive_flexs_vl.context_required_flag%TYPE);
26:
19: segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
24: context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE,
25: context_required fnd_descriptive_flexs_vl.context_required_flag%TYPE);
26:
27: /*Function Cache_DFF_Segments
20: default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
24: context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE,
25: context_required fnd_descriptive_flexs_vl.context_required_flag%TYPE);
26:
27: /*Function Cache_DFF_Segments
28: Function Cache_DFF_Segments retrieves
21: default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
22: protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
23: form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
24: context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE,
25: context_required fnd_descriptive_flexs_vl.context_required_flag%TYPE);
26:
27: /*Function Cache_DFF_Segments
28: Function Cache_DFF_Segments retrieves
29: and caches the given flexfield segments.
89:
90: /* returns information about the flexfield */
91: /***Comment out for now
92: PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
93: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
94: flexfield OUT fnd_dflex.dflex_r,
95: flexinfo OUT wsh_flexfield_utils.dflex_dr);
96: */
97: END WSH_FLEXFIELD_UTILS;