1 PACKAGE EGO_METADATA_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOPMDPS.pls 120.0.12010000.1 2010/04/15 12:28:38 kjonnala noship $ */
3
4 ------------------------------------------------------------------------------------
5 -- Declaration of collection records and table types used for AG metadata import --
6 ------------------------------------------------------------------------------------
7
8 /* Associated Table type for Attribute Groups Interface table */
9 TYPE ego_attr_groups_tbl
10 IS TABLE OF ego_attr_groups_interface%ROWTYPE INDEX BY BINARY_INTEGER;
11
12 /* Associated Table type for Attribute Group Data Levels Interface table*/
13 TYPE ego_attr_groups_dl_tbl
14 IS TABLE OF ego_attr_groups_dl_interface%ROWTYPE INDEX BY BINARY_INTEGER;
15
16 /* Associated Table type for Attribute Groups Columns (i.e.) Attributes Interface table*/
17 TYPE ego_attr_group_cols_tbl
18 IS TABLE OF ego_attr_group_cols_intf%ROWTYPE INDEX BY BINARY_INTEGER;
19
20
21 ------------------------------------------------------------------------------------
22 -- Declaration of collection records and table types used for VS metadata import --
23 ------------------------------------------------------------------------------------
24
25 /* Associated Table type for Value Sets Interface table*/
26 TYPE Value_Set_Tbl
27 IS TABLE OF EGO_FLEX_VALUE_SET_INTF%ROWTYPE INDEX BY BINARY_INTEGER;
28
29 /* Associated Table type for Values Interface table*/
30 TYPE Value_Set_Value_Tbl
31 IS TABLE OF EGO_FLEX_VALUE_INTF%ROWTYPE INDEX BY BINARY_INTEGER;
32
33 /* Associated Table type for Translatable Values Interface table*/
34 TYPE Value_Set_Value_Tl_Tbl
35 IS TABLE OF EGO_FLEX_VALUE_Tl_INTF%ROWTYPE INDEX BY BINARY_INTEGER;
36
37
38 ------------------------------------------------------------------------------------
39 -- Declaration of collection records and table types used for ICC metadata import --
40 ------------------------------------------------------------------------------------
41 /* Associated Record type for ICC Interface table*/
42 SUBTYPE ego_icc_rec_type
43 IS MTL_ITEM_CAT_GRPS_INTERFACE%ROWTYPE;
44
45 /* Associated Record type for AG associations (to ICC ) Interface table*/
46 SUBTYPE ego_ag_assoc_rec_type
47 IS EGO_ATTR_GRPS_ASSOC_INTERFACE%ROWTYPE;
48
49 /* Associated Record type for function parameter mappings ( to ICC ) Interface table*/
50 SUBTYPE ego_func_param_map_rec_type
51 IS EGO_FUNC_PARAMS_MAP_INTERFACE%ROWTYPE;
52
53 /* Associated Record type for ICC versions Interface table*/
54 SUBTYPE ego_icc_vers_rec_type
55 IS EGO_ICC_VERS_INTERFACE%ROWTYPE;
56
57
58 /* Associated Table type for ICC Interface table*/
59 TYPE ego_icc_tbl_type
60 IS TABLE OF MTL_ITEM_CAT_GRPS_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;
61
62 /* Associated Table type for AG associations (to ICC ) Interface table*/
63 TYPE ego_ag_assoc_tbl_type
64 IS TABLE OF EGO_ATTR_GRPS_ASSOC_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;
65
66 /* Associated Table type for function parameter mappings ( to ICC ) Interface table*/
67 TYPE ego_func_param_map_tbl_type
68 IS TABLE OF EGO_FUNC_PARAMS_MAP_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;
69
70 /* Associated Table type for ICC versions Interface table*/
71 TYPE ego_icc_vers_tbl_type
72 IS TABLE OF EGO_ICC_VERS_INTERFACE%ROWTYPE INDEX BY BINARY_INTEGER;
73
74 /* Associated Table type for Functions Interface table*/
75 TYPE ego_function_tbl_type
76 IS TABLE OF ego_functions_interface%ROWTYPE INDEX BY BINARY_INTEGER;
77
78 /* Associated Table type for Function Parameters Interface table*/
79 TYPE ego_func_param_tbl_type
80 IS TABLE OF ego_func_params_interface%ROWTYPE INDEX BY BINARY_INTEGER;
81
82 /* Associated Table type for Transaction Attributes Interface table*/
83 TYPE TA_Intf_Tbl
84 IS TABLE OF ego_trans_attrs_vers_intf%ROWTYPE INDEX BY BINARY_INTEGER;
85
86 /* Associated Table type for Pages Interface table*/
87 TYPE ego_pg_tbl
88 IS TABLE OF ego_pages_interface%ROWTYPE INDEX BY BINARY_INTEGER;
89
90 /* Associated Table type for Page Entries Interface table*/
91 TYPE ego_ent_tbl
92 IS TABLE OF ego_page_entries_interface%ROWTYPE INDEX BY BINARY_INTEGER;
93
94 /* Currently, we are NOT supporting Public bulkload APIs for Metadata.
95 Hence commenting the below procedures.
96 For single record public APIs for metadata, please refer to EGO_EXT_FWK_PUB and EGO_ITEM_CATALOG_PUB packages.
97 */
98 /*Public Procedures
99 -- Main procedure for API processing. Takes care of AGs and its associated DL Called by Public API.
100 PROCEDURE process_attribute_group(
101 p_ag_tbl IN OUT NOCOPY ego_attr_groups_tbl,
102 p_agdl_tbl IN OUT NOCOPY ego_attr_groups_dl_tbl,
103 p_commit IN BOOLEAN DEFAULT false,
104 x_return_status OUT VARCHAR2,
105 x_return_msg OUT VARCHAR2);
106
107 --Main procedure for Attributes processing through API
108 PROCEDURE process_attribute(
109 p_attr_tbl IN OUT NOCOPY ego_attr_group_cols_tbl,
110 p_commit IN BOOLEAN DEFAULT false,
111 x_return_status OUT VARCHAR2,
112 x_return_msg OUT VARCHAR2);
113
114 --Main procedure for API processing. Takes care of Pages and is called by Public API.
115 PROCEDURE process_pages(
116 p_pg_tbl IN OUT NOCOPY ego_pg_tbl,
117 p_commit IN BOOLEAN DEFAULT false,
118 x_return_status OUT VARCHAR2,
119 x_return_msg OUT VARCHAR2);
120
121 --Main procedure for Page Entries processing through API
122 PROCEDURE process_pg_entries(
123 p_ent_tbl IN OUT NOCOPY ego_ent_tbl,
124 p_commit IN BOOLEAN DEFAULT false,
125 x_return_status OUT VARCHAR2,
126 x_return_msg OUT VARCHAR2);
127
128 */
129 END EGO_METADATA_PUB;