[Home] [Help]
PACKAGE: APPS.HZ_MIXNM_REGISTRY_PUB
Source
1 PACKAGE HZ_MIXNM_REGISTRY_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHXREGS.pls 120.1 2005/06/16 21:16:45 jhuang noship $ */
3
4 --------------------------------------
5 -- declaration of record type
6 --------------------------------------
7
8 TYPE entity_attribute_rec_type IS RECORD (
9 entity_name VARCHAR2(30),
10 attribute_name VARCHAR2(30),
11 created_by_module VARCHAR2(150),
12 application_id NUMBER
13 );
14
15 TYPE DATA_SOURCE_TBL IS TABLE OF VARCHAR2(30);
16
17 --------------------------------------
18 -- declaration of public procedures and functions
19 --------------------------------------
20
21 /**
22 * PROCEDURE Add_EntityAttribute
23 *
24 * DESCRIPTION
25 * Add the new entity and / or attribute into the dictionary.
26 *
27 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
28 *
29 * ARGUMENTS
30 * IN:
31 * p_init_msg_list Initialize message stack if it is set to
32 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
33 * p_entity_attribute_rec Entity Attribute record.
34 * p_data_source_tbl PL/SQL Table for Data Source Setup.
35 * IN/OUT:
36 * OUT:
37 * x_entity_attr_id Dictionary ID.
38 * x_return_status Return status after the call. The status can
39 * be FND_API.G_RET_STS_SUCCESS (success),
40 * FND_API.G_RET_STS_ERROR (error),
41 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
42 * x_msg_count Number of messages in message stack.
43 * x_msg_data Message text if x_msg_count is 1.
44 *
45 * NOTES
46 *
47 * MODIFICATION HISTORY
48 *
49 * 02-12-2002 Jianying Huang o Created.
50 */
51
52 PROCEDURE Add_EntityAttribute (
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_entity_attribute_rec IN ENTITY_ATTRIBUTE_REC_TYPE,
55 p_data_source_tab IN DATA_SOURCE_TBL,
56 x_entity_attr_id OUT NOCOPY NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 /**
63 * PROCEDURE Get_EntityAttribute
64 *
65 * DESCRIPTION
66 * Get the entity / attribute from the dictionary.
67 *
68 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
69 *
70 * ARGUMENTS
71 * IN:
72 * p_init_msg_list Initialize message stack if it is set to
73 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
74 * p_entity_name Entity Name
75 * p_attribute_name Attribute Name
76 * IN/OUT:
77 * OUT:
78 * x_data_source_tbl PL/SQL Table for Data Source Setup.
79 * x_return_status Return status after the call. The status can
80 * be FND_API.G_RET_STS_SUCCESS (success),
81 * FND_API.G_RET_STS_ERROR (error),
82 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
83 * x_msg_count Number of messages in message stack.
84 * x_msg_data Message text if x_msg_count is 1.
85 *
86 * NOTES
87 *
88 * MODIFICATION HISTORY
89 *
90 * 02-12-2002 Jianying Huang o Created.
91 */
92
93 PROCEDURE Get_EntityAttribute (
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_entity_name IN VARCHAR2,
96 p_attribute_name IN VARCHAR2,
97 x_data_source_tbl OUT NOCOPY DATA_SOURCE_TBL,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 /**
104 * PROCEDURE Remove_EntityAttribute
105 *
106 * DESCRIPTION
107 * Remove the entity / attribute from the dictionary.
108 *
109 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
110 *
111 * ARGUMENTS
112 * IN:
113 * p_init_msg_list Initialize message stack if it is set to
114 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
115 * p_entity_name Entity Name
116 * p_attribute_name Attribute Name
117 * IN/OUT:
118 * OUT:
119 * x_return_status Return status after the call. The status can
120 * be FND_API.G_RET_STS_SUCCESS (success),
121 * FND_API.G_RET_STS_ERROR (error),
122 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
123 * x_msg_count Number of messages in message stack.
124 * x_msg_data Message text if x_msg_count is 1.
125 *
126 * NOTES
127 *
128 * MODIFICATION HISTORY
129 *
130 * 02-12-2002 Jianying Huang o Created.
131 */
132
133 PROCEDURE Remove_EntityAttribute (
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135 p_entity_name IN VARCHAR2,
136 p_attribute_name IN VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 /**
143 * PROCEDURE Remove_EntityAttrDataSource
144 *
145 * DESCRIPTION
146 * Remove the entity / attribute's data sources from the dictionary.
147 * The data sources must be un-selected.
148 *
149 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
150 *
151 * ARGUMENTS
152 * IN:
153 * p_init_msg_list Initialize message stack if it is set to
154 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
155 * p_entity_name Entity Name
156 * p_attribute_name Attribute Name
157 * IN/OUT:
158 * OUT:
159 * x_return_status Return status after the call. The status can
160 * be FND_API.G_RET_STS_SUCCESS (success),
161 * FND_API.G_RET_STS_ERROR (error),
162 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
163 * x_msg_count Number of messages in message stack.
164 * x_msg_data Message text if x_msg_count is 1.
165 *
166 * NOTES
167 *
168 * MODIFICATION HISTORY
169 *
170 * 02-12-2002 Jianying Huang o Created.
171 */
172
173 PROCEDURE Remove_EntityAttrDataSource (
174 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175 p_entity_name IN VARCHAR2,
176 p_attribute_name IN VARCHAR2,
177 p_data_source_tbl IN DATA_SOURCE_TBL,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2
181 );
182
183 END HZ_MIXNM_REGISTRY_PUB;