2: /* $Header: PSBVESPS.pls 120.5 2005/03/16 05:32:46 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: --
44: );
45:
46: procedure LOCK_ROW (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_return_status OUT NOCOPY VARCHAR2,
52: p_msg_count OUT NOCOPY NUMBER,
45:
46: procedure LOCK_ROW (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_return_status OUT NOCOPY VARCHAR2,
52: p_msg_count OUT NOCOPY NUMBER,
53: p_msg_data OUT NOCOPY VARCHAR2,
46: procedure LOCK_ROW (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: p_return_status OUT NOCOPY VARCHAR2,
52: p_msg_count OUT NOCOPY NUMBER,
53: p_msg_data OUT NOCOPY VARCHAR2,
54: p_lock_row OUT NOCOPY VARCHAR2,
81: );
82:
83: procedure UPDATE_ROW (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_return_status OUT NOCOPY VARCHAR2,
89: p_msg_count OUT NOCOPY NUMBER,
82:
83: procedure UPDATE_ROW (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_return_status OUT NOCOPY VARCHAR2,
89: p_msg_count OUT NOCOPY NUMBER,
90: p_msg_data OUT NOCOPY VARCHAR2,
83: procedure UPDATE_ROW (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_return_status OUT NOCOPY VARCHAR2,
89: p_msg_count OUT NOCOPY NUMBER,
90: p_msg_data OUT NOCOPY VARCHAR2,
91: --
120: );
121:
122: procedure DELETE_ROW (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_return_status OUT NOCOPY VARCHAR2,
128: p_msg_count OUT NOCOPY NUMBER,
121:
122: procedure DELETE_ROW (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_return_status OUT NOCOPY VARCHAR2,
128: p_msg_count OUT NOCOPY NUMBER,
129: p_msg_data OUT NOCOPY VARCHAR2,
122: procedure DELETE_ROW (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_return_status OUT NOCOPY VARCHAR2,
128: p_msg_count OUT NOCOPY NUMBER,
129: p_msg_data OUT NOCOPY VARCHAR2,
130: --
132: );
133:
134: PROCEDURE Copy_Entity_Set
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_return_status OUT NOCOPY VARCHAR2,
140: p_msg_count OUT NOCOPY NUMBER,
133:
134: PROCEDURE Copy_Entity_Set
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_return_status OUT NOCOPY VARCHAR2,
140: p_msg_count OUT NOCOPY NUMBER,
141: p_msg_data OUT NOCOPY VARCHAR2,
134: PROCEDURE Copy_Entity_Set
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_return_status OUT NOCOPY VARCHAR2,
140: p_msg_count OUT NOCOPY NUMBER,
141: p_msg_data OUT NOCOPY VARCHAR2,
142: p_source_entity_set_id IN NUMBER,