1 PACKAGE INV_ITEM_EVENTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVVEVES.pls 120.6.12020000.2 2012/11/29 07:38:44 yingyang ship $ */
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_old_category_id IN NUMBER DEFAULT NULL--add by geguo 8351807
64 ,p_catalog_id IN NUMBER DEFAULT NULL
65 ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
66 ,p_extension_id IN NUMBER DEFAULT NULL
67 ,p_manufacturer_id IN NUMBER DEFAULT NULL
68 ,p_mfg_part_num IN VARCHAR2 DEFAULT NULL
69 ,p_cross_reference_type IN VARCHAR2 DEFAULT NULL
70 ,p_cross_reference IN VARCHAR2 DEFAULT NULL
71 ,p_customer_item_id IN NUMBER DEFAULT NULL
72 ,p_related_item_id IN NUMBER DEFAULT NULL
73 ,p_relationship_type_id IN NUMBER DEFAULT NULL
74 ,p_role_id IN NUMBER DEFAULT NULL
75 ,p_party_type IN VARCHAR2 DEFAULT NULL
76 ,p_party_id IN NUMBER DEFAULT NULL
77 ,p_start_date IN DATE DEFAULT NULL
78 ,p_category_name IN VARCHAR2 DEFAULT NULL);
79
80
81 -- ----------------------------------------------------------------------
82 -- API Name: Call ICX APIs
83 --
84 -- Type: Private
85 --
86 -- Description: Call ICX APIs
87 --
88 -- Parameters:
89 -- IN:
90 -- p_commit IN BOOLEAN DEFAULT FALSE
91 -- p_xset_id IN NUMBER DEFAULT -999
92 -- p_request_id IN NUMBER NULL
93 -- p_entity_type IN VARCHAR2
94 -- {'ITEM','ITEM_CATEGORY'
95 -- 'CATEGORY','VALID_CATEGORY'}
96 -- p_dml_type IN VARCHAR2
97 -- {'CREATE', 'UPDATE',
98 -- 'DELETE', 'BULK'}
99 -- p_inventory_item_id IN NUMBER DEFAULT NULL
100 -- p_item_number IN VARCHAR2 DEFAULT NULL
101 -- p_organization_id IN NUMBER DEFAULT NULL
102 -- p_organization_code IN VARCHAR2 DEFAULT NULL
103 -- p_master_org_flag IN VARCHAR2 DEFAULT NULL
104 -- {'Y', 'N'}
105 -- p_item_description IN VARCHAR2 DEFAULT NULL
106 -- p_category_set_id IN NUMBER DEFAULT NULL
107 -- p_category_id IN NUMBER DEFAULT NULL
108 -- p_old_category_id IN NUMBER DEFAULT NULL
109 -- p_category_name IN VARCHAR2 DEFAULT NULL
110 -- p_structure_id IN NUMBER DEFAULT NULL
111 --
112 -- OUT:
113 -- Removed the out parameters as we make this call inside
114 -- a nested block and exceptions are not required to be
115 -- handled there
116 --
117 -- ----------------------------------------------------------------------
118
119 Procedure Invoke_ICX_APIs (
120 p_commit IN BOOLEAN DEFAULT FALSE
121 ,p_xset_id IN NUMBER DEFAULT -999
122 ,p_request_id IN NUMBER DEFAULT NULL
123 ,p_entity_type IN VARCHAR2 DEFAULT NULL
124 ,p_dml_type IN VARCHAR2
125 ,p_inventory_item_id IN NUMBER DEFAULT NULL
126 ,p_item_number IN VARCHAR2 DEFAULT NULL
127 ,p_organization_id IN NUMBER DEFAULT NULL
128 ,p_organization_code IN VARCHAR2 DEFAULT NULL
129 ,p_master_org_flag IN VARCHAR2 DEFAULT NULL
130 ,p_item_description IN VARCHAR2 DEFAULT NULL
131 ,p_category_set_id IN NUMBER DEFAULT NULL
132 ,p_category_id IN NUMBER DEFAULT NULL
133 ,p_old_category_id IN NUMBER DEFAULT NULL
134 ,p_category_name IN VARCHAR2 DEFAULT NULL
135 ,p_structure_id IN NUMBER DEFAULT NULL);
136
137
138 -- ----------------------------------------------------------------------
139 -- API Name: Call ICX APIs
140 --
141 -- Type: Private
142 --
143 -- Description: Wrapper on Invoke_ICX_APIs. This procedure just
144 -- converts the p_commit INT parameter to boolean
145 -- Added so that p_commit can be passed from java layer
146 -- INTEGER p_commit = 1 >> TRUE = p_commit BOOLEAN
147 --
148 -- Parameters: Same as Invoke_ICX_APIs except p_commit is INTEGER
149
150 Procedure Invoke_ICX_wrapper (
151 p_commit IN INTEGER DEFAULT 2
152 ,p_xset_id IN NUMBER DEFAULT -999
153 ,p_request_id IN NUMBER DEFAULT NULL
154 ,p_entity_type IN VARCHAR2 DEFAULT NULL
155 ,p_dml_type IN VARCHAR2
156 ,p_inventory_item_id IN NUMBER DEFAULT NULL
157 ,p_item_number IN VARCHAR2 DEFAULT NULL
158 ,p_organization_id IN NUMBER DEFAULT NULL
159 ,p_organization_code IN VARCHAR2 DEFAULT NULL
160 ,p_master_org_flag IN VARCHAR2 DEFAULT NULL
161 ,p_item_description IN VARCHAR2 DEFAULT NULL
162 ,p_category_set_id IN NUMBER DEFAULT NULL
163 ,p_category_id IN NUMBER DEFAULT NULL
164 ,p_old_category_id IN NUMBER DEFAULT NULL
165 ,p_category_name IN VARCHAR2 DEFAULT NULL
166 ,p_structure_id IN NUMBER DEFAULT NULL);
167
168
169 -- -------------------------------------------------------------------------
170 -- API Name: Sync IP Intermedia Index
171 --
172 -- Type: Private
173 --
174 -- Description: Calls IProcurement Intermedia index rebuild after
175 -- commiting as it is a DDL.
176 -----------------------------------------------------------------------------
177
178 Procedure Sync_IP_IM_Index;
179
180
181 Procedure Invoke_JAI_API(
182 p_action_type IN VARCHAR2
183 ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
184 ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
185 ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
186 ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
187 ,p_set_process_id IN NUMBER
188 ,p_called_from IN VARCHAR2);
189
190 --Bug: 4880971
191 Procedure Invoke_JG_ZZ_API(
192 p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
193 ,p_country_code OUT NOCOPY VARCHAR2
194 ,p_product_code OUT NOCOPY VARCHAR2);
195
196 END INV_ITEM_EVENTS_PVT;
[Home] [Help]