2: /* $Header: PSBVEAPS.pls 120.2 2005/07/13 11:24:36 shtripat ship $ */
3:
4: procedure INSERT_ROW (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
3:
4: procedure INSERT_ROW (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,
4: procedure INSERT_ROW (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,
12: --
25: );
26:
27: procedure LOCK_ROW (
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_return_status OUT NOCOPY VARCHAR2,
33: p_msg_count OUT NOCOPY NUMBER,
26:
27: procedure LOCK_ROW (
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_return_status OUT NOCOPY VARCHAR2,
33: p_msg_count OUT NOCOPY NUMBER,
34: p_msg_data OUT NOCOPY VARCHAR2,
27: procedure LOCK_ROW (
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_return_status OUT NOCOPY VARCHAR2,
33: p_msg_count OUT NOCOPY NUMBER,
34: p_msg_data OUT NOCOPY VARCHAR2,
35: p_lock_row OUT NOCOPY VARCHAR2,
43: );
44:
45: procedure UPDATE_ROW (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
44:
45: procedure UPDATE_ROW (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
45: procedure UPDATE_ROW (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
53: --
63: );
64:
65: procedure DELETE_ROW (
66: p_api_version IN NUMBER,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_return_status OUT NOCOPY VARCHAR2,
71: p_msg_count OUT NOCOPY NUMBER,
64:
65: procedure DELETE_ROW (
66: p_api_version IN NUMBER,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_return_status OUT NOCOPY VARCHAR2,
71: p_msg_count OUT NOCOPY NUMBER,
72: p_msg_data OUT NOCOPY VARCHAR2,
65: procedure DELETE_ROW (
66: p_api_version IN NUMBER,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68: p_commit IN VARCHAR2 := FND_API.G_FALSE,
69: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: p_return_status OUT NOCOPY VARCHAR2,
71: p_msg_count OUT NOCOPY NUMBER,
72: p_msg_data OUT NOCOPY VARCHAR2,
73: --