2: /* $Header: PSBVPAVS.pls 120.2 2005/07/13 11:27:50 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: --
57: );
58:
59: procedure LOCK_ROW (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_msg_count OUT NOCOPY NUMBER,
58:
59: procedure LOCK_ROW (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_msg_count OUT NOCOPY NUMBER,
66: p_msg_data OUT NOCOPY VARCHAR2,
59: procedure LOCK_ROW (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_msg_count OUT NOCOPY NUMBER,
66: p_msg_data OUT NOCOPY VARCHAR2,
67: --
108: );
109:
110: procedure UPDATE_ROW (
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_return_status OUT NOCOPY VARCHAR2,
116: p_msg_count OUT NOCOPY NUMBER,
109:
110: procedure UPDATE_ROW (
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_return_status OUT NOCOPY VARCHAR2,
116: p_msg_count OUT NOCOPY NUMBER,
117: p_msg_data OUT NOCOPY VARCHAR2,
110: procedure UPDATE_ROW (
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_return_status OUT NOCOPY VARCHAR2,
116: p_msg_count OUT NOCOPY NUMBER,
117: p_msg_data OUT NOCOPY VARCHAR2,
118: --
160:
161:
162: procedure DELETE_ROW (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
161:
162: procedure DELETE_ROW (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
169: p_msg_data OUT NOCOPY VARCHAR2,
162: procedure DELETE_ROW (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
169: p_msg_data OUT NOCOPY VARCHAR2,
170: --
174:
175: PROCEDURE Check_References
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_return_status OUT NOCOPY VARCHAR2,
182: p_msg_count OUT NOCOPY NUMBER,
175: PROCEDURE Check_References
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_return_status OUT NOCOPY VARCHAR2,
182: p_msg_count OUT NOCOPY NUMBER,
183: p_msg_data OUT NOCOPY VARCHAR2,
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_return_status OUT NOCOPY VARCHAR2,
182: p_msg_count OUT NOCOPY NUMBER,
183: p_msg_data OUT NOCOPY VARCHAR2,
184: --