2: /* $Header: PSBWHRCS.pls 120.9 2005/11/07 05:55:43 masethur ship $ */
3:
4: PROCEDURE Perform_Data_Extract
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 Perform_Data_Extract
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 Perform_Data_Extract
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: p_data_extract_id IN NUMBER
13: );
14:
15: PROCEDURE Interface_Purge
16: (p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: /* Start bug #4386374 */
21: p_data_extract_id IN NUMBER := null, -- Fixed for bug#4683895
14:
15: PROCEDURE Interface_Purge
16: (p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: /* Start bug #4386374 */
21: p_data_extract_id IN NUMBER := null, -- Fixed for bug#4683895
22: p_populate_interface_flag IN VARCHAR2 := null,-- Fixed for bug#4683895
15: PROCEDURE Interface_Purge
16: (p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: /* Start bug #4386374 */
21: p_data_extract_id IN NUMBER := null, -- Fixed for bug#4683895
22: p_populate_interface_flag IN VARCHAR2 := null,-- Fixed for bug#4683895
23: /* End bug #4386374 */
244:
245: PROCEDURE Insert_Organizations
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_data_extract_id IN NUMBER,
252: p_as_of_date IN DATE,
245: PROCEDURE Insert_Organizations
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_data_extract_id IN NUMBER,
252: p_as_of_date IN DATE,
253: p_business_group_id IN NUMBER,
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: p_data_extract_id IN NUMBER,
252: p_as_of_date IN DATE,
253: p_business_group_id IN NUMBER,
254: p_return_status OUT NOCOPY VARCHAR2,
258:
259: PROCEDURE Submit_Data_Extract
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_return_status OUT NOCOPY VARCHAR2,
266: p_msg_count OUT NOCOPY NUMBER,
259: PROCEDURE Submit_Data_Extract
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_return_status OUT NOCOPY VARCHAR2,
266: p_msg_count OUT NOCOPY NUMBER,
267: p_msg_data OUT NOCOPY VARCHAR2,
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_return_status OUT NOCOPY VARCHAR2,
266: p_msg_count OUT NOCOPY NUMBER,
267: p_msg_data OUT NOCOPY VARCHAR2,
268: p_data_extract_id IN NUMBER,
287: PROCEDURE Create_Default_Rule_Set
288: ( x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: x_msg_init_list IN VARCHAR2 := FND_API.G_TRUE,
292: p_commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_api_version IN NUMBER,
294: p_data_extract_id IN NUMBER,
295: p_rule_set_name IN VARCHAR2
288: ( x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: x_msg_init_list IN VARCHAR2 := FND_API.G_TRUE,
292: p_commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_api_version IN NUMBER,
294: p_data_extract_id IN NUMBER,
295: p_rule_set_name IN VARCHAR2
296: );