5: G_FILE_NAME CONSTANT VARCHAR2(30) := 'iexpdlss.pls';
6:
7:
8: PROCEDURE Add_rec (p_api_version IN NUMBER ,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
6:
7:
8: PROCEDURE Add_rec (p_api_version IN NUMBER ,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
7:
8: PROCEDURE Add_rec (p_api_version IN NUMBER ,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
15: p_source_module IN VARCHAR2 ,
18: p_object_code IN Varchar2 ,
19: p_object_id IN IEX_DEL_ASSETS.object_id%TYPE );
20:
21: PROCEDURE Add_All_rec(p_api_version IN NUMBER ,
22: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT NOCOPY VARCHAR2 ,
26: x_msg_count OUT NOCOPY NUMBER ,
19: p_object_id IN IEX_DEL_ASSETS.object_id%TYPE );
20:
21: PROCEDURE Add_All_rec(p_api_version IN NUMBER ,
22: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT NOCOPY VARCHAR2 ,
26: x_msg_count OUT NOCOPY NUMBER ,
27: x_msg_data OUT NOCOPY VARCHAR2 ,
20:
21: PROCEDURE Add_All_rec(p_api_version IN NUMBER ,
22: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT NOCOPY VARCHAR2 ,
26: x_msg_count OUT NOCOPY NUMBER ,
27: x_msg_data OUT NOCOPY VARCHAR2 ,
28: p_source_module IN VARCHAR2 ,
30: p_object_code IN Varchar2 ,
31: p_object_id IN Number );
32:
33: PROCEDURE Remove_rec(p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
31: p_object_id IN Number );
32:
33: PROCEDURE Remove_rec(p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
32:
33: PROCEDURE Remove_rec(p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: p_source_module IN VARCHAR2,
42:
43:
44: PROCEDURE Remove_All_rec(
45: p_api_version IN NUMBER ,
46: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2 ,
50: x_msg_count OUT NOCOPY NUMBER ,
43:
44: PROCEDURE Remove_All_rec(
45: p_api_version IN NUMBER ,
46: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2 ,
50: x_msg_count OUT NOCOPY NUMBER ,
51: x_msg_data OUT NOCOPY VARCHAR2 ,
44: PROCEDURE Remove_All_rec(
45: p_api_version IN NUMBER ,
46: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: x_return_status OUT NOCOPY VARCHAR2 ,
50: x_msg_count OUT NOCOPY NUMBER ,
51: x_msg_data OUT NOCOPY VARCHAR2 ,
52: p_source_module IN VARCHAR2 ,
53: p_del_id IN Number ) ;
54:
55: PROCEDURE Start_Workflow(
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
60: x_return_status OUT NOCOPY VARCHAR2 ,
61: x_msg_count OUT NOCOPY NUMBER ,
54:
55: PROCEDURE Start_Workflow(
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
60: x_return_status OUT NOCOPY VARCHAR2 ,
61: x_msg_count OUT NOCOPY NUMBER ,
62: x_msg_data OUT NOCOPY VARCHAR2 ,
55: PROCEDURE Start_Workflow(
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
60: x_return_status OUT NOCOPY VARCHAR2 ,
61: x_msg_count OUT NOCOPY NUMBER ,
62: x_msg_data OUT NOCOPY VARCHAR2 ,
63: p_user_id IN NUMBER ,