[Home] [Help]
PACKAGE: APPS.EGO_PUBLICATION_PKG
Source
1 PACKAGE EGO_PUBLICATION_PKG AS
2 /* $Header: EGOPBLCS.pls 120.7 2007/10/11 12:53:28 bramnan noship $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_PUBLICATION_PKG' ;
6
7 -- Global Constants for data levels
8
9 G_ITM_DATA_LVL CONSTANT VARCHAR2(20) := 'ITEM_LEVEL';
10 G_ITM_ORG_DATA_LVL CONSTANT VARCHAR2(20) := 'ITEM_ORG';
11 G_ITM_SUP_DATA_LVL CONSTANT VARCHAR2(20) := 'ITEM_SUP';
12 G_ITM_SUP_SITE_DATA_LVL CONSTANT VARCHAR2(20) := 'ITEM_SUP_SITE';
13 G_ITM_SUP_SITE_ORG_DATA_LVL CONSTANT VARCHAR2(20) := 'ITEM_SUP_SITE_ORG';
14
15 PROCEDURE getUDAAttributes
16 (
17 extension_id IN NUMBER,
18 p_language IN VARCHAR2,
19 x_doc OUT NOCOPY xmltype,
20 x_error_message OUT NOCOPY VARCHAR2
21 );
22
23 PROCEDURE getItemIdentification
24 (
25 inventory_item_id IN NUMBER,
26 organization_id IN NUMBER,
27 x_doc OUT NOCOPY xmltype,
28 x_error_message OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE getItemBase
32 (
33 inventory_item_id IN NUMBER,
34 organization_id IN NUMBER,
35 p_language IN VARCHAR2,
36 x_doc OUT NOCOPY xmltype,
37 x_error_message OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE getItemAttributes
41 (
42 inventory_item_id IN NUMBER,
43 organization_id IN NUMBER,
44 extension_id IN NUMBER,
45 p_language IN VARCHAR2,
46 x_doc OUT NOCOPY xmltype,
47 x_error_message OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE getCategoryAttributes
51 (
52 category_id IN NUMBER,
53 GetFlexAttributesFlag IN CHAR,
54 x_doc OUT NOCOPY xmltype,
55 x_error_message OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE getCatalogAttributes
59 (
60 catalogId IN NUMBER,
61 parentCategoryId IN NUMBER,
62 categoryId IN NUMBER,
63 p_language IN VARCHAR2,
64 x_doc OUT NOCOPY xmltype,
65 x_error_message OUT NOCOPY VARCHAR2
66 );
67
68 --------------------------------------
69 -- getDataLevelId
70 --------------------------------------
71 FUNCTION getDataLevelId
72 (p_data_level_internal_name IN VARCHAR2)
73 RETURN NUMBER;
74
75 --------------------------------------
76 -- getSupplierAttributes
77 --------------------------------------
78 PROCEDURE getSupplierAttributes
79 (
80 p_api_version IN NUMBER,
81 p_supplier_id IN NUMBER,
82 p_language IN VARCHAR2, -- If none is passed all languages are returned back
83 x_doc OUT NOCOPY XMLTYPE,
84 x_error_message OUT NOCOPY VARCHAR2
85 );
86
87 ---------------------------------------
88 -- Get Supplier Site Attributes
89 ---------------------------------------
90 PROCEDURE getSupplierSiteAttributes(
91 p_api_version IN NUMBER,
92 p_supplier_id IN NUMBER,
93 p_supplier_site_id IN NUMBER,
94 p_language IN VARCHAR2, -- If none is passed all languages are returned back
95 x_doc OUT NOCOPY XMLTYPE,
96 x_error_message OUT NOCOPY VARCHAR2
97 );
98
99 ---------------------------------------
100 -- getItemSupplierAttributes
101 ---------------------------------------
102 PROCEDURE getItemSupplierAttributes
103 (
104 p_api_version IN NUMBER := 1.0,
105 p_inventory_item_id IN NUMBER, -- Item Identifier1
106 p_organization_id IN NUMBER, -- Item Identifier2
107 p_supplierId IN NUMBER, -- Supplier Identifier
108 p_extension_id IN NUMBER, -- pk for identifying the row in ext values table
109 p_language IN VARCHAR2,
110 x_doc OUT NOCOPY XMLTYPE,
111 x_error_message OUT NOCOPY VARCHAR2
112 );
113
114 ---------------------------------------
115 -- getItemSupplierSiteAttributes
116 ---------------------------------------
117 PROCEDURE getItemSupplierSiteAttributes
118 (
119 p_api_version IN NUMBER,
120 p_inventory_item_id IN NUMBER,
121 p_organization_id IN NUMBER,
122 p_supplierId IN NUMBER,
123 p_site_id IN NUMBER,
124 p_extension_id IN NUMBER,
125 p_language IN VARCHAR2, -- If none is passed all languages are returned back
126 x_doc OUT NOCOPY xmltype,
127 x_error_message OUT NOCOPY varchar2
128 );
129
130 ------------------------------------------------------
131 -- getStructureAttributes
132 ------------------------------------------------------
133 PROCEDURE getStructureAttributes
134 (
135 p_api_version IN NUMBER,
136 p_structure_id IN NUMBER,
137 p_component_id IN NUMBER,
138 p_language IN VARCHAR2, -- If none is passed all languages are returned back
139 p_get_first_level_comps IN VARCHAR2,
140 x_doc OUT NOCOPY XMLTYPE,
141 x_error_message OUT NOCOPY VARCHAR2
142 );
143
144 ----------------------------------------------
145 -- getItemCategoryAttributes
146 ----------------------------------------------
147 PROCEDURE getItemCategoryAttributes
148 (
149 p_api_version IN NUMBER,
150 p_inventory_item_id IN NUMBER,
151 p_organization_id IN NUMBER,
152 p_catalog_id IN NUMBER,
153 p_category_id IN NUMBER,
154 p_language IN VARCHAR2, -- If none is passed all languages are returned back
155 x_doc OUT NOCOPY xmltype,
156 x_error_message OUT NOCOPY varchar2
157 );
158
159 PROCEDURE getEventPayload
160 (
161 p_sequence_id IN NUMBER,
162 p_event OUT NOCOPY WF_EVENT_T,
163 x_error_message OUT NOCOPY varchar2
164 );
165
166 FUNCTION getItemIdentification
167 (
168 p_inventory_item_id IN NUMBER,
169 p_organization_id IN NUMBER
170 )
171 RETURN XMLTYPE;
172
173
174
175 END EGO_PUBLICATION_PKG;