1: package PSB_PARAMETER_FORMULAS_PVT as
2: /* $Header: PSBVPFPS.pls 120.2 2005/07/13 11:28:27 shtripat ship $ */
3: procedure INSERT_ROW (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_msg_count OUT NOCOPY NUMBER,
2: /* $Header: PSBVPFPS.pls 120.2 2005/07/13 11:28:27 shtripat ship $ */
3: procedure INSERT_ROW (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_msg_count OUT NOCOPY NUMBER,
10: p_msg_data OUT NOCOPY VARCHAR2,
3: procedure INSERT_ROW (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_msg_count OUT NOCOPY NUMBER,
10: p_msg_data OUT NOCOPY VARCHAR2,
11: --
87:
88:
89: procedure LOCK_ROW (
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_return_status OUT NOCOPY VARCHAR2,
95: p_msg_count OUT NOCOPY NUMBER,
88:
89: procedure LOCK_ROW (
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_return_status OUT NOCOPY VARCHAR2,
95: p_msg_count OUT NOCOPY NUMBER,
96: p_msg_data OUT NOCOPY VARCHAR2,
89: procedure LOCK_ROW (
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_return_status OUT NOCOPY VARCHAR2,
95: p_msg_count OUT NOCOPY NUMBER,
96: p_msg_data OUT NOCOPY VARCHAR2,
97: p_lock_row OUT NOCOPY VARCHAR2,
168: );
169:
170: procedure UPDATE_ROW (
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: p_return_status OUT NOCOPY VARCHAR2,
176: p_msg_count OUT NOCOPY NUMBER,
169:
170: procedure UPDATE_ROW (
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: p_return_status OUT NOCOPY VARCHAR2,
176: p_msg_count OUT NOCOPY NUMBER,
177: p_msg_data OUT NOCOPY VARCHAR2,
170: procedure UPDATE_ROW (
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173: p_commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: p_return_status OUT NOCOPY VARCHAR2,
176: p_msg_count OUT NOCOPY NUMBER,
177: p_msg_data OUT NOCOPY VARCHAR2,
178: --
251: );
252:
253: procedure DELETE_ROW (
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_msg_count OUT NOCOPY NUMBER,
252:
253: procedure DELETE_ROW (
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_msg_count OUT NOCOPY NUMBER,
260: p_msg_data OUT NOCOPY VARCHAR2,
253: procedure DELETE_ROW (
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_msg_count OUT NOCOPY NUMBER,
260: p_msg_data OUT NOCOPY VARCHAR2,
261: --