3:
4: PROCEDURE Insert_Row
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
4: PROCEDURE Insert_Row
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
12: p_msg_data OUT NOCOPY VARCHAR2,
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
12: p_msg_data OUT NOCOPY VARCHAR2,
13: --
74: );
75:
76: procedure LOCK_ROW (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_return_status OUT NOCOPY VARCHAR2,
82: p_msg_count OUT NOCOPY NUMBER,
75:
76: procedure LOCK_ROW (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_return_status OUT NOCOPY VARCHAR2,
82: p_msg_count OUT NOCOPY NUMBER,
83: p_msg_data OUT NOCOPY VARCHAR2,
76: procedure LOCK_ROW (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_return_status OUT NOCOPY VARCHAR2,
82: p_msg_count OUT NOCOPY NUMBER,
83: p_msg_data OUT NOCOPY VARCHAR2,
84: p_lock_row OUT NOCOPY VARCHAR2,
140: );
141:
142: procedure UPDATE_ROW (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
141:
142: procedure UPDATE_ROW (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,
142: procedure UPDATE_ROW (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,
150: --
209:
210:
211: procedure DELETE_ROW (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: p_return_status OUT NOCOPY VARCHAR2,
217: p_msg_count OUT NOCOPY NUMBER,
210:
211: procedure DELETE_ROW (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: p_return_status OUT NOCOPY VARCHAR2,
217: p_msg_count OUT NOCOPY NUMBER,
218: p_msg_data OUT NOCOPY VARCHAR2,
211: procedure DELETE_ROW (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: p_return_status OUT NOCOPY VARCHAR2,
217: p_msg_count OUT NOCOPY NUMBER,
218: p_msg_data OUT NOCOPY VARCHAR2,
219: --