1 PACKAGE WMS_CONFIG_UI AUTHID CURRENT_USER AS
2 /* $Header: WMSCFGUIS.pls 115.1 2004/01/22 21:39:32 kkandiku noship $ */
3
4
5 TYPE t_fields_list IS REF CURSOR;
6 TYPE t_page_level_props IS REF CURSOR;
7
8 /**
9 * This procedure returns the fields' metadata + config values for
10 * the given page, template as a ref cursor.
11 * If the given tenplate is null or does not exist, the
12 * fields' metadata + config values for the default template are returned.
13 * If the default tenplate does not exist, the fields' metadata + config values
14 * for the default template are returned.
15
16 * @param p_page_id The page for which the fields are required
17 * @param p_template_name The template name for which the fields are required
18 * @param p_organization_id Organization ID
19 * @param x_page_template_fields Cursor containg the fields list
20 **/
21 PROCEDURE get_fields(
22 p_page_id IN NUMBER DEFAULT NULL,
23 p_template_name IN VARCHAR2 DEFAULT NULL,
24 p_organization_id IN NUMBER DEFAULT NULL,
25 p_get_page_level_props IN VARCHAR2 DEFAULT 'N',
26 x_page_template_fields OUT NOCOPY t_fields_list, -- Page Template fields. Does not contain page level properties
27 x_page_level_props OUT NOCOPY t_page_level_props, -- Page level properties
28 x_return_template OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2);
32
33 /**
34 * This procedure returns the template id for the the given page, template name
35 * and organization
36 * If the given tenplate is null or does not exist, the default template id is returned
37 * If the default tenplate does not exist, -1 is returned
38
39 * @param p_page_id The page for which the fields are required
40 * @param p_template_name The template name for which the fields are required
41 * @param p_organization_id Organization ID
42 * @param x_template_id Template ID
43 **/
44 PROCEDURE get_template(
45 p_page_id IN NUMBER DEFAULT NULL,
46 p_template_name IN VARCHAR2 DEFAULT NULL,
47 p_organization_id IN NUMBER DEFAULT NULL,
48 x_template_id OUT NOCOPY NUMBER,
49 x_return_template OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54
55 /**
56 * This procedure returns the fields' metadata + config values for
57 * the given page, template as a ref cursor.
58 * If the given tenplate is null or does not exist, the
59 * fields' metadata + config values for the default template are returned.
60 * If the default tenplate does not exist, the fields' metadata + config values
61 * for the default template are returned.
62
63 * @param p_page_id The page for which the fields are required
64 * @param p_template_name The template name for which the fields are required
65 * @param p_organization_id Organization ID
66 * @param x_page_template_fields Cursor containg the fields list
67 **/
68 PROCEDURE get_field_properties(
69 p_page_id IN NUMBER DEFAULT NULL,
70 p_template_name IN VARCHAR2 DEFAULT NULL,
71 p_organization_id IN NUMBER DEFAULT NULL,
72 p_field_name IN VARCHAR2 DEFAULT NULL,
73 x_field_properties OUT NOCOPY t_fields_list, -- Does not contain page level properties
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 END WMS_CONFIG_UI;