1 PACKAGE WSH_FLEXFIELD_UTILS AUTHID CURRENT_USER as
2 /* $Header: WSHFFUTS.pls 120.0 2005/05/26 17:12:26 appldev noship $ */
3
4 /* Type FlexfieldAttributeTabType is a table of
5 Varchar2(150).
6 */
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,
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,
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.
30 Currently accepts as input only wsh_new_deliveries.
31 Will be extended to add wsh_trips and wsh_trip_stops.
32 */
33
34 FUNCTION Cache_DFF_Segments(p_table_name IN VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2) RETURN BINARY_INTEGER;
36
37
38
39 /* Procedure Get_DFF_Defaults retrieves
40 the default context and segment values for
41 the given flexfield.
42 Currently accepts as input only wsh_new_deliveries.
43 Will be extended to add wsh_trips and wsh_trip_stops.
44 */
45
46 Procedure Get_DFF_Defaults
47 (p_flexfield_name IN VARCHAR2,
48 p_default_values OUT NOCOPY FlexfieldAttributeTabType,
49 p_default_context OUT NOCOPY VARCHAR2,
50 p_update_flag OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2);
52
53 /*
54 Procedure Write_DFF_Attributes
55 populates the relevant table with the default context
56 and attributes values for the flex field.
57 Currently accepts as input only wsh_new_deliveries.
58 Will be extended to add wsh_trips and wsh_trip_stops.
59 */
60
61 PROCEDURE Write_DFF_Attributes(p_table_name IN VARCHAR2,
62 p_primary_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65
66 /*
67 Procedure Read_Table_Attributes
68 Gets the attribute values from the relevant table.
69 Currently accepts as input only wsh_new_deliveries.
70 Will be extended to add wsh_trips and wsh_trip_stops.
71 */
72 PROCEDURE Read_Table_Attributes(p_table_name IN VARCHAR2,
73 p_primary_id IN NUMBER,
74 p_attributes OUT NOCOPY FlexfieldAttributeTabType,
75 p_context OUT NOCOPY VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 /*
79 Procedure Validate_DFF
80 Checks whether the requied segments for the
81 DFF is populated in the relevant table.
82 Currently accepts as input only wsh_new_deliveries.
83 Will be extended to add wsh_trips and wsh_trip_stops.
84 */
85 PROCEDURE Validate_DFF(
86 p_table_name IN VARCHAR2,
87 p_primary_id IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2);
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;