DBA Data[Home] [Help]

APPS.EGO_AG_BULKLOAD_PVT dependencies on EGO_METADATA_PUB

Line 147: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

143: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
144: x_return_status OUT NOCOPY parameter that returns the status
145: x_return_msg OUT NOCOPY parameter that returns the error message*/
146: PROCEDURE value_to_id_ag_tbl(
147: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
148: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
149:
150: /*This procedure is used for value to ID conversion for Attribute group
151: data level plsql tables. Used in the API flow.

Line 156: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

152: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
153: x_return_status OUT NOCOPY parameter that returns the status
154: x_return_msg OUT NOCOPY parameter that returns the error message*/
155: PROCEDURE value_to_id_dl_tbl(
156: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
157: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
158:
159: /*This procedure is used for value to ID conversion for Attributes plsql tables.
160: Used in the API flow.

Line 165: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

161: p_attr_tbl IN OUT NOCOPY Attributes plsql table
162: x_return_status OUT NOCOPY parameter that returns the status
163: x_return_msg OUT NOCOPY parameter that returns the error message*/
164: PROCEDURE value_to_id_attr_tbl(
165: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
166: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
167:
168: /*This procedure is used to bulk validate attribute groups.
169: Used in the interface flow.

Line 188: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

184: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
185: x_return_status OUT NOCOPY parameter that returns the status
186: x_return_msg OUT NOCOPY parameter that returns the error message*/
187: PROCEDURE additional_agdl_validations(
188: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
189: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
190: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
191:
192: /*This procedure is used to do additional validations on attributes.

Line 189: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

185: x_return_status OUT NOCOPY parameter that returns the status
186: x_return_msg OUT NOCOPY parameter that returns the error message*/
187: PROCEDURE additional_agdl_validations(
188: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
189: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
190: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
191:
192: /*This procedure is used to do additional validations on attributes.
193: Used in the API flow.

Line 198: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

194: p_attr_tbl IN OUT NOCOPY Attributes plsql table
195: x_return_status OUT NOCOPY parameter that returns the status
196: x_return_msg OUT NOCOPY parameter that returns the error message*/
197: PROCEDURE additional_attr_validations(
198: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
199: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
200:
201: /*This procedure is used to do Common validations on attribute groups.
202: Used in the Interface and API flow.

Line 207: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

203: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
204: x_return_status OUT NOCOPY parameter that returns the status
205: x_return_msg OUT NOCOPY parameter that returns the error message*/
206: PROCEDURE common_ag_validations(
207: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
208: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
209:
210: /*This procedure is used to do Common validations on attribute group data level.
211: Used in the Interface and API flow.

Line 216: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

212: p_agdl_tbl IN OUT NOCOPY Attribute group plsql table
213: x_return_status OUT NOCOPY parameter that returns the status
214: x_return_msg OUT NOCOPY parameter that returns the error message*/
215: PROCEDURE common_dl_validations(
216: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
217: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
218:
219: /*This procedure is used to do Common validations on attributes.
220: Used in the Interface and API flow.

Line 225: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

221: p_attr_tbl IN OUT NOCOPY Attribute group plsql table
222: x_return_status OUT NOCOPY parameter that returns the status
223: x_return_msg OUT NOCOPY parameter that returns the error message*/
224: PROCEDURE common_attr_validations(
225: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
226: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
227:
228: /*This is the main procedure called to import attribute groups, data level and attributes
229: Used in the Interface flow.

Line 246: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

242: p_commit IN Pass true to commit within the API
243: x_return_status OUT NOCOPY parameter that returns the status
244: x_return_msg OUT NOCOPY parameter that returns the error message*/
245: PROCEDURE process_attr_groups(
246: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
247: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
248: p_commit IN BOOLEAN DEFAULT true,
249: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
250:

Line 247: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

243: x_return_status OUT NOCOPY parameter that returns the status
244: x_return_msg OUT NOCOPY parameter that returns the error message*/
245: PROCEDURE process_attr_groups(
246: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
247: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
248: p_commit IN BOOLEAN DEFAULT true,
249: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
250:
251: /*This is the main procedure called to import attributes.

Line 258: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

254: p_commit IN Pass true to commit within the API
255: x_return_status OUT NOCOPY parameter that returns the status
256: x_return_msg OUT NOCOPY parameter that returns the error message*/
257: PROCEDURE process_attribute(
258: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
259: p_commit IN BOOLEAN DEFAULT true,
260: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
261:
262: /*This procedure is used in the update flow to handle null values for AG

Line 268: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

264: p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
265: x_return_status OUT NOCOPY parameter that returns the status
266: x_return_msg OUT NOCOPY parameter that returns the error message*/
267: PROCEDURE handle_null_ag(
268: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
269: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
270:
271: /*This procedure is used to do final processing of the attribute group data level.
272: Used in the interface and API flow.

Line 277: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

273: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
274: x_return_status OUT NOCOPY parameter that returns the status
275: x_return_msg OUT NOCOPY parameter that returns the error message*/
276: PROCEDURE handle_null_dl(
277: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
278: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
279:
280: /*This procedure is used to do final processing of the attributes.
281: Used in the interface and API flow.

Line 286: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

282: p_attr_tbl IN OUT NOCOPY Attributes plsql table
283: x_return_status OUT NOCOPY parameter that returns the status
284: x_return_msg OUT NOCOPY parameter that returns the error message*/
285: PROCEDURE handle_null_attr(
286: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
287: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
288:
289: /*This procedure is used to do final processing of the attribute groups.
290: Used in the interface and API flow.

Line 295: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

291: p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
292: x_return_status OUT NOCOPY parameter that returns the status
293: x_return_msg OUT NOCOPY parameter that returns the error message*/
294: PROCEDURE process_ag(
295: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
296: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
297:
298: /*This procedure is used to do final processing of the attribute group data level.
299: Used in the interface and API flow.

Line 304: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

300: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
301: x_return_status OUT NOCOPY parameter that returns the status
302: x_return_msg OUT NOCOPY parameter that returns the error message*/
303: PROCEDURE process_dl(
304: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
305: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
306:
307: /*This procedure is used to do final processing of the attributes.
308: Used in the interface and API flow.

Line 313: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

309: p_attr_tbl IN OUT NOCOPY Attributes plsql table
310: x_return_status OUT NOCOPY parameter that returns the status
311: x_return_msg OUT NOCOPY parameter that returns the error message*/
312: PROCEDURE process_attr(
313: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
314: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
315:
316: /*This procedure is used to update the attribute group interface table
317: Used in the interface flow.

Line 322: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

318: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
319: x_return_status OUT NOCOPY parameter that returns the status
320: x_return_msg OUT NOCOPY parameter that returns the error message*/
321: PROCEDURE update_intf_attr_groups(
322: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
323: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
324:
325:
326: /*This procedure is used to update the attribute group data level interface table

Line 332: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

328: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
329: x_return_status OUT NOCOPY parameter that returns the status
330: x_return_msg OUT NOCOPY parameter that returns the error message*/
331: PROCEDURE update_intf_data_level(
332: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
333: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
334:
335: /*This procedure is used to update the attributes interface table
336: Used in the Interface flow.

Line 341: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

337: p_attr_tbl IN OUT NOCOPY Attributes plsql table
338: x_return_status OUT NOCOPY parameter that returns the status
339: x_return_msg OUT NOCOPY parameter that returns the error message*/
340: PROCEDURE update_intf_attribute(
341: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
342: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
343:
344: /*This procedure is used to delete processed records from the attribute group's interface table
345: Used in the interface flow.