12:
13: PROCEDURE Update_Row
14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_return_status OUT NOCOPY VARCHAR2,
20: p_msg_count OUT NOCOPY NUMBER,
13: PROCEDURE Update_Row
14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_return_status OUT NOCOPY VARCHAR2,
20: p_msg_count OUT NOCOPY NUMBER,
21: p_msg_data OUT NOCOPY VARCHAR2,
14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_return_status OUT NOCOPY VARCHAR2,
20: p_msg_count OUT NOCOPY NUMBER,
21: p_msg_data OUT NOCOPY VARCHAR2,
22: --
211: WHEN OTHERS THEN
212: --
213: ROLLBACK TO Update_Row_Pvt ;
214: --
215: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: --
217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
218: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
219: l_api_name );
235:
236: PROCEDURE Delete_Row
237: (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: p_return_status OUT NOCOPY VARCHAR2,
243: p_msg_count OUT NOCOPY NUMBER,
236: PROCEDURE Delete_Row
237: (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: p_return_status OUT NOCOPY VARCHAR2,
243: p_msg_count OUT NOCOPY NUMBER,
244: p_msg_data OUT NOCOPY VARCHAR2,
237: (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: p_return_status OUT NOCOPY VARCHAR2,
243: p_msg_count OUT NOCOPY NUMBER,
244: p_msg_data OUT NOCOPY VARCHAR2,
245: --
274: WHEN OTHERS THEN
275: --
276: ROLLBACK TO Delete_Row_Pvt ;
277: --
278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: --
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
281: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
282: l_api_name );