1 PACKAGE INV_ITEM_EVENTS_PVT AS
2 /* $Header: INVVEVES.pls 120.4 2005/12/23 02:05:03 swshukla noship $ */
3 -- ----------------------------------------------------------------------
4 -- API Name: Raise Business Event
5 --
6 -- Type: Private
7 --
8 -- Description: Raise Business Event
9 --
10 -- Parameters:
11 -- IN:
12 -- p_commit IN BOOLEAN DEFAULT FALSE
13 -- p_xset_id IN NUMBER DEFAULT -999
14 -- p_request_id IN NUMBER NULL
15 -- p_event_name IN VARCHAR2
16 -- p_dml_type IN VARCHAR2
17 -- {INSERT, UPDATE, DELETE, BULK}
18 -- p_inventory_item_id IN NUMBER DEFAULT NULL
19 -- p_item_number IN VARCHAR2 DEFAULT NULL
20 -- p_organization_id IN NUMBER DEFAULT NULL
21 -- p_organization_code IN VARCHAR2 DEFAULT NULL
22 -- p_revision_id IN NUMBER DEFAULT NULL
23 -- p_item_description IN VARCHAR2 DEFAULT NULL
24 -- p_category_set_id IN NUMBER DEFAULT NULL
25 -- p_category_id IN NUMBER DEFAULT NULL
26 -- p_catalog_id IN NUMBER DEFAULT NULL
27 -- p_attr_group_name IN VARCHAR2 DEFAULT NULL
28 -- p_extension_id IN NUMBER DEFAULT NULL
29 -- p_manufacturer_id IN NUMBER DEFAULT NULL
30 -- p_mfg_part_num IN VARCHAR2 DEFAULT NULL
31 -- p_cross_reference_type IN VARCHAR2 DEFAULT NULL
32 -- p_cross_reference IN VARCHAR2 DEFAULT NULL
33 -- p_customer_item_id IN NUMBER DEFAULT NULL
34 -- p_related_item_id IN NUMBER DEFAULT NULL
35 -- p_relationship_type_id IN NUMBER DEFAULT NULL
36 -- p_role_id IN NUMBER DEFAULT NULL
37 -- p_party_type IN VARCHAR2 DEFAULT NULL
38 -- p_party_id IN NUMBER DEFAULT NULL
39 -- p_start_date IN DATE DEFAULT NULL
40 -- p_category_name IN VARCHAR2 DEFAULT NULL
41
42 --
43 -- OUT:
44 -- Removed the out parameters as we make this call inside
45 -- a nested block and exceptions are not required to be
46 -- handled there
47 -- ----------------------------------------------------------------------
48
49 Procedure Raise_Events (
50 p_commit IN BOOLEAN DEFAULT FALSE
51 ,p_xset_id IN NUMBER DEFAULT -999
52 ,p_request_id IN NUMBER DEFAULT NULL
53 ,p_event_name IN VARCHAR2 DEFAULT NULL
54 ,p_dml_type IN VARCHAR2
55 ,p_inventory_item_id IN NUMBER DEFAULT NULL
56 ,p_item_number IN VARCHAR2 DEFAULT NULL
57 ,p_organization_id IN NUMBER DEFAULT NULL
58 ,p_organization_code IN VARCHAR2 DEFAULT NULL
59 ,p_revision_id IN NUMBER DEFAULT NULL
60 ,p_item_description IN VARCHAR2 DEFAULT NULL
61 ,p_category_set_id IN NUMBER DEFAULT NULL
62 ,p_category_id IN NUMBER DEFAULT NULL
63 ,p_catalog_id IN NUMBER DEFAULT NULL
64 ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
65 ,p_extension_id IN NUMBER DEFAULT NULL
66 ,p_manufacturer_id IN NUMBER DEFAULT NULL
67 ,p_mfg_part_num IN VARCHAR2 DEFAULT NULL
68 ,p_cross_reference_type IN VARCHAR2 DEFAULT NULL
69 ,p_cross_reference IN VARCHAR2 DEFAULT NULL
70 ,p_customer_item_id IN NUMBER DEFAULT NULL
71 ,p_related_item_id IN NUMBER DEFAULT NULL
72 ,p_relationship_type_id IN NUMBER DEFAULT NULL
73 ,p_role_id IN NUMBER DEFAULT NULL
74 ,p_party_type IN VARCHAR2 DEFAULT NULL
75 ,p_party_id IN NUMBER DEFAULT NULL
76 ,p_start_date IN DATE DEFAULT NULL
77 ,p_category_name IN VARCHAR2 DEFAULT NULL);
78
79
80 -- ----------------------------------------------------------------------
81 -- API Name: Call ICX APIs
82 --
83 -- Type: Private
84 --
85 -- Description: Call ICX APIs
86 --
87 -- Parameters:
88 -- IN:
89 -- p_commit IN BOOLEAN DEFAULT FALSE
90 -- p_xset_id IN NUMBER DEFAULT -999
91 -- p_request_id IN NUMBER NULL
92 -- p_entity_type IN VARCHAR2
93 -- {'ITEM','ITEM_CATEGORY'
94 -- 'CATEGORY','VALID_CATEGORY'}
95 -- p_dml_type IN VARCHAR2
96 -- {'CREATE', 'UPDATE',
97 -- 'DELETE', 'BULK'}
98 -- p_inventory_item_id IN NUMBER DEFAULT NULL
99 -- p_item_number IN VARCHAR2 DEFAULT NULL
100 -- p_organization_id IN NUMBER DEFAULT NULL
101 -- p_organization_code IN VARCHAR2 DEFAULT NULL
102 -- p_master_org_flag IN VARCHAR2 DEFAULT NULL
103 -- {'Y', 'N'}
104 -- p_item_description IN VARCHAR2 DEFAULT NULL
105 -- p_category_set_id IN NUMBER DEFAULT NULL
106 -- p_category_id IN NUMBER DEFAULT NULL
107 -- p_old_category_id IN NUMBER DEFAULT NULL
108 -- p_category_name IN VARCHAR2 DEFAULT NULL
109 -- p_structure_id IN NUMBER DEFAULT NULL
110 --
111 -- OUT:
112 -- Removed the out parameters as we make this call inside
113 -- a nested block and exceptions are not required to be
114 -- handled there
115 --
116 -- ----------------------------------------------------------------------
117
118 Procedure Invoke_ICX_APIs (
119 p_commit IN BOOLEAN DEFAULT FALSE
120 ,p_xset_id IN NUMBER DEFAULT -999
121 ,p_request_id IN NUMBER DEFAULT NULL
122 ,p_entity_type IN VARCHAR2 DEFAULT NULL
123 ,p_dml_type IN VARCHAR2
124 ,p_inventory_item_id IN NUMBER DEFAULT NULL
125 ,p_item_number IN VARCHAR2 DEFAULT NULL
126 ,p_organization_id IN NUMBER DEFAULT NULL
127 ,p_organization_code IN VARCHAR2 DEFAULT NULL
128 ,p_master_org_flag IN VARCHAR2 DEFAULT NULL
129 ,p_item_description IN VARCHAR2 DEFAULT NULL
130 ,p_category_set_id IN NUMBER DEFAULT NULL
131 ,p_category_id IN NUMBER DEFAULT NULL
132 ,p_old_category_id IN NUMBER DEFAULT NULL
133 ,p_category_name IN VARCHAR2 DEFAULT NULL
134 ,p_structure_id IN NUMBER DEFAULT NULL);
135
136
137 -- ----------------------------------------------------------------------
138 -- API Name: Call ICX APIs
139 --
140 -- Type: Private
141 --
142 -- Description: Wrapper on Invoke_ICX_APIs. This procedure just
143 -- converts the p_commit INT parameter to boolean
144 -- Added so that p_commit can be passed from java layer
145 -- INTEGER p_commit = 1 >> TRUE = p_commit BOOLEAN
146 --
147 -- Parameters: Same as Invoke_ICX_APIs except p_commit is INTEGER
148
149 Procedure Invoke_ICX_wrapper (
150 p_commit IN INTEGER DEFAULT 1
151 ,p_xset_id IN NUMBER DEFAULT -999
152 ,p_request_id IN NUMBER DEFAULT NULL
153 ,p_entity_type IN VARCHAR2 DEFAULT NULL
154 ,p_dml_type IN VARCHAR2
155 ,p_inventory_item_id IN NUMBER DEFAULT NULL
156 ,p_item_number IN VARCHAR2 DEFAULT NULL
157 ,p_organization_id IN NUMBER DEFAULT NULL
158 ,p_organization_code IN VARCHAR2 DEFAULT NULL
159 ,p_master_org_flag IN VARCHAR2 DEFAULT NULL
160 ,p_item_description IN VARCHAR2 DEFAULT NULL
161 ,p_category_set_id IN NUMBER DEFAULT NULL
162 ,p_category_id IN NUMBER DEFAULT NULL
163 ,p_old_category_id IN NUMBER DEFAULT NULL
164 ,p_category_name IN VARCHAR2 DEFAULT NULL
165 ,p_structure_id IN NUMBER DEFAULT NULL);
166
167
168 -- -------------------------------------------------------------------------
169 -- API Name: Sync IP Intermedia Index
170 --
171 -- Type: Private
172 --
173 -- Description: Calls IProcurement Intermedia index rebuild after
174 -- commiting as it is a DDL.
175 -----------------------------------------------------------------------------
176
177 Procedure Sync_IP_IM_Index;
178
179
180 Procedure Invoke_JAI_API(
181 p_action_type IN VARCHAR2
182 ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
183 ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
184 ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
185 ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
186 ,p_set_process_id IN NUMBER
187 ,p_called_from IN VARCHAR2);
188
189 --Bug: 4880971
190 Procedure Invoke_JG_ZZ_API(
191 p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
192 ,p_country_code OUT NOCOPY VARCHAR2
193 ,p_product_code OUT NOCOPY VARCHAR2);
194
195 END INV_ITEM_EVENTS_PVT;