77: -- Parameters
78: --
79: -- IN
80: -- p_api_version IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83: --
84: -- OUT
85: -- x_return_status OUT VARCHAR2
78: --
79: -- IN
80: -- p_api_version IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83: --
84: -- OUT
85: -- x_return_status OUT VARCHAR2
86: -- x_msg_count OUT NUMBER
96:
97: PROCEDURE Create_Item_Revision
98: (
99: p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: , p_commit IN VARCHAR2 := FND_API.G_FALSE
102: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103: , p_process_control IN VARCHAR2 := NULL
104: , x_return_status OUT NOCOPY VARCHAR2
97: PROCEDURE Create_Item_Revision
98: (
99: p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: , p_commit IN VARCHAR2 := FND_API.G_FALSE
102: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103: , p_process_control IN VARCHAR2 := NULL
104: , x_return_status OUT NOCOPY VARCHAR2
105: , x_msg_count OUT NOCOPY NUMBER
98: (
99: p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: , p_commit IN VARCHAR2 := FND_API.G_FALSE
102: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103: , p_process_control IN VARCHAR2 := NULL
104: , x_return_status OUT NOCOPY VARCHAR2
105: , x_msg_count OUT NOCOPY NUMBER
106: , x_msg_data OUT NOCOPY VARCHAR2
119: -- Parameters
120: --
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_process_control IN VARCHAR2 := NULL To identify the caller Bug 5525054
126: -- p_Item_Revision_rec IN Item_Revision_rec_type Required
127: --
120: --
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_process_control IN VARCHAR2 := NULL To identify the caller Bug 5525054
126: -- p_Item_Revision_rec IN Item_Revision_rec_type Required
127: --
128: -- OUT
137:
138: PROCEDURE Update_Item_Revision
139: (
140: p_api_version IN NUMBER
141: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
142: , p_commit IN VARCHAR2 := FND_API.g_FALSE
143: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
144: , p_process_control IN VARCHAR2 := NULL
145: , x_return_status OUT NOCOPY VARCHAR2
138: PROCEDURE Update_Item_Revision
139: (
140: p_api_version IN NUMBER
141: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
142: , p_commit IN VARCHAR2 := FND_API.g_FALSE
143: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
144: , p_process_control IN VARCHAR2 := NULL
145: , x_return_status OUT NOCOPY VARCHAR2
146: , x_msg_count OUT NOCOPY NUMBER
139: (
140: p_api_version IN NUMBER
141: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
142: , p_commit IN VARCHAR2 := FND_API.g_FALSE
143: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
144: , p_process_control IN VARCHAR2 := NULL
145: , x_return_status OUT NOCOPY VARCHAR2
146: , x_msg_count OUT NOCOPY NUMBER
147: , x_msg_data OUT NOCOPY VARCHAR2
163: -- Parameters
164: --
165: -- IN
166: -- p_api_version_number IN NUMBER Required
167: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_inventory_item_id IN NUMBER Required
170: -- p_organization_id IN NUMBER Required
171: -- p_revision IN VARCHAR2 Required
164: --
165: -- IN
166: -- p_api_version_number IN NUMBER Required
167: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_inventory_item_id IN NUMBER Required
170: -- p_organization_id IN NUMBER Required
171: -- p_revision IN VARCHAR2 Required
172: -- p_object_version_number IN NUMBER Required
183:
184: PROCEDURE Lock_Item_Revision
185: (
186: p_api_version IN NUMBER
187: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
188: , x_return_status OUT NOCOPY VARCHAR2
189: , x_msg_count OUT NOCOPY NUMBER
190: , x_msg_data OUT NOCOPY VARCHAR2
191: , p_inventory_item_id IN NUMBER
207: -- Parameters
208: --
209: -- IN
210: -- p_api_version_number IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_inventory_item_id IN NUMBER Required
214: -- p_organization_id IN NUMBER Required
215: -- p_revision IN VARCHAR2 Required
208: --
209: -- IN
210: -- p_api_version_number IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_inventory_item_id IN NUMBER Required
214: -- p_organization_id IN NUMBER Required
215: -- p_revision IN VARCHAR2 Required
216: -- p_object_version_number IN NUMBER Required
227:
228: PROCEDURE Delete_Item_Revision
229: (
230: p_api_version IN NUMBER
231: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
232: , p_commit IN VARCHAR2 := FND_API.g_FALSE
233: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
234: , x_return_status OUT NOCOPY VARCHAR2
235: , x_msg_count OUT NOCOPY NUMBER
228: PROCEDURE Delete_Item_Revision
229: (
230: p_api_version IN NUMBER
231: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
232: , p_commit IN VARCHAR2 := FND_API.g_FALSE
233: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
234: , x_return_status OUT NOCOPY VARCHAR2
235: , x_msg_count OUT NOCOPY NUMBER
236: , x_msg_data OUT NOCOPY VARCHAR2
229: (
230: p_api_version IN NUMBER
231: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
232: , p_commit IN VARCHAR2 := FND_API.g_FALSE
233: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
234: , x_return_status OUT NOCOPY VARCHAR2
235: , x_msg_count OUT NOCOPY NUMBER
236: , x_msg_data OUT NOCOPY VARCHAR2
237: , p_inventory_item_id IN NUMBER
276: , p_template_name IN VARCHAR2 := NULL --5208102
277: , p_language_code IN VARCHAR2 := 'US'
278: , p_transaction_type IN VARCHAR2
279: , p_message_API IN VARCHAR2 := 'FND'
280: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
281: , x_Return_Status OUT NOCOPY VARCHAR2
282: , x_msg_count OUT NOCOPY NUMBER
283: , x_msg_data OUT NOCOPY VARCHAR2 /*Added for bug 8634732 to ensure error message is displayed*/
284: , x_revision_id IN OUT NOCOPY NUMBER