1 PACKAGE ICX_CAT_POPULATE_MI_GRP AUTHID CURRENT_USER AS
2 /* $Header: ICXGPPMS.pls 120.1 2005/11/09 10:40:12 sbgeorge noship $*/
3
4 -- Start of comments
5 -- API name : populateItemChange
6 -- * Type : Group
7 -- * Pre-reqs : None.
8 -- * Function : Takes care of creating, updating and deleting the inventory
9 -- item in ip datamodel. This procedure is called by Inventory on
10 -- item creation, updation, deletion, item assignment to an
11 -- inventory org and item translation updation in mtl_system_items_b
12 -- and mtl_system_items_tl from forms, html interface.
13 -- * Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- p_dml_type IN VARCHAR2 Required
22 -- Corresponds to the dml action done to the
23 -- item. The allowed values are
24 -- "CREATE/UPDATE/DELETE"
25 -- p_inventory_item_id IN NUMBER Required
26 -- Corresponds to the column INVENTORY_ITEM_ID in
27 -- the table MTL_SYSTEM_ITEMS, and identifies the
28 -- record to be inserted, updated or deleted.
29 -- p_item_number IN VARCHAR2 Required
30 -- Corresponds to the column CONCATENATED_SEGMENTS in
31 -- the table MTL_SYSTEM_ITEMS_KFV.
32 -- p_organization_id IN NUMBER Required
33 -- Item organization id. Part of the unique key
34 -- that uniquely identifies an item record.
35 -- p_organization_code IN VARCHAR2 Required
36 -- Item organization code.
37 -- p_master_org_flag IN VARCHAR2 Required
38 -- Flag value: Y/N, and identifies if the organization
39 -- is the master org. If Y then the processing is also
40 -- for all the child orgs.
41 -- p_item_description IN VARCHAR2 Required
42 -- Corresponds to the column DESCRIPTION in
43 -- the table MTL_SYSTEM_ITEMS_TL.
44 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
45 -- * Version : Current version 1.0
46 -- Previous version 1.0
47 -- Initial version 1.0
48 --
49 -- Notes : None.
50 --
51 -- End of comments
52 PROCEDURE populateItemChange
53 ( p_api_version IN NUMBER ,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
56 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
57 x_return_status OUT NOCOPY VARCHAR2 ,
58 p_dml_type IN VARCHAR2 ,
59 p_inventory_item_id IN NUMBER ,
60 p_item_number IN VARCHAR2 ,
61 p_organization_id IN NUMBER ,
62 p_organization_code IN VARCHAR2 ,
63 p_master_org_flag IN VARCHAR2 ,
64 p_item_description IN VARCHAR2
65 );
66
67 -- Start of comments
68 -- API name : populateBulkItemChange
69 -- * Type : Group
70 -- * Pre-reqs : None.
71 -- * Function : Takes care of creating and updating the inventory
72 -- item in ip datamodel. This procedure is called by Inventory on
73 -- item creation, updation, item assignment to an
74 -- inventory org and item translation updation in mtl_system_items_b
75 -- and mtl_system_items_tl from Item open interface (IOI). The
76 -- procedure is also called when an items category assignment is
77 -- created, updated or deleted from IOI.
78 -- * Parameters :
79 -- IN : p_api_version IN NUMBER Required
80 -- p_init_msg_list IN VARCHAR2 Optional
81 -- Default = FND_API.G_FALSE
82 -- p_commit IN VARCHAR2 Optional
83 -- Default = FND_API.G_FALSE
84 -- p_validation_level IN NUMBER Optional
85 -- Default = FND_API.G_VALID_LEVEL_FULL
86 -- p_request_id IN NUMBER Required
87 -- Corresponds to the column REQUEST_ID in
88 -- the table MTL_ITEM_BULKLOAD_RECS, and identifies the
89 -- set of items that are inserted, updated or deleted
90 -- in the current IOI job.
91 -- p_entity_type IN VARCHAR2 Required
92 -- Corresponds to the entity changed
93 -- The allowed values are "ITEM/ITEM_CATEGORY"
94 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
95 -- * Version : Current version 1.0
96 -- Previous version 1.0
97 -- Initial version 1.0
98 --
99 -- Notes : None.
100 --
101 -- End of comments
102 PROCEDURE populateBulkItemChange
103 ( p_api_version IN NUMBER ,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
106 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
107 x_return_status OUT NOCOPY VARCHAR2 ,
108 p_request_id IN NUMBER ,
109 p_entity_type IN VARCHAR2
110 );
111
112 -- Start of comments
113 -- API name : populateItemCategoryChange
114 -- * Type : Group
115 -- * Pre-reqs : None.
116 -- * Function : Takes care of creating, updating and deleting the inventory
117 -- item category assignment in ip datamodel if the category belong
118 -- to the purchasing category set. This procedure is called by
119 -- Inventory when category assignment of an item is created,
120 -- updated or deleted in MTL_ITEM_CATEGORIES from forms,
121 -- and html interface.
122 -- * Parameters :
123 -- IN : p_api_version IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Optional
125 -- Default = FND_API.G_FALSE
126 -- p_commit IN VARCHAR2 Optional
127 -- Default = FND_API.G_FALSE
128 -- p_validation_level IN NUMBER Optional
129 -- Default = FND_API.G_VALID_LEVEL_FULL
130 -- p_dml_type IN VARCHAR2 Required
131 -- Corresponds to the dml action done to the
132 -- item's category. The allowed values are
133 -- "CREATE/UPDATE/DELETE"
134 -- p_inventory_item_id IN NUMBER Required
135 -- Corresponds to the column INVENTORY_ITEM_ID in
136 -- the table MTL_SYSTEM_ITEMS, and identifies the
137 -- item whose category assignment change is done.
138 -- p_item_number IN VARCHAR2 Required
139 -- Corresponds to the column CONCATENATED_SEGMENTS in
140 -- the table MTL_SYSTEM_ITEMS_KFV.
141 -- p_organization_id IN NUMBER Required
142 -- Item organization id. Part of the unique key
143 -- that uniquely identifies an item record.
144 -- p_master_org_flag IN VARCHAR2 Required
145 -- Flag value: Y/N, and identifies if the organization
146 -- is the master org. If Y then the processing is also
147 -- for all the child orgs.
148 -- p_category_set_id IN NUMBER Required
149 -- Corresponds to the column CATEGORY_SET_ID in
150 -- the table MTL_ITEM_CATEGORIES. Part of the unique
151 -- key that uniquely identifies a record.
152 -- p_category_id IN NUMBER Required
153 -- Corresponds to the column CATEGORY_ID in
154 -- the table MTL_ITEM_CATEGORIES. Part of the unique
155 -- key that uniquely identifies a record.
156 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
157 -- * Version : Current version 1.0
158 -- Previous version 1.0
159 -- Initial version 1.0
160 --
161 -- Notes : None.
162 --
163 -- End of comments
164 PROCEDURE populateItemCategoryChange
165 ( p_api_version IN NUMBER ,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
167 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
168 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
169 x_return_status OUT NOCOPY VARCHAR2 ,
170 p_dml_type IN VARCHAR2 ,
171 p_inventory_item_id IN NUMBER ,
172 p_item_number IN VARCHAR2 ,
173 p_organization_id IN NUMBER ,
174 p_master_org_flag IN VARCHAR2 ,
175 p_category_set_id IN NUMBER ,
176 p_category_id IN NUMBER
177 );
178
179 END ICX_CAT_POPULATE_MI_GRP;