1 PACKAGE IGW_STUDY_TITLES_PVT AUTHID CURRENT_USER AS
2 --$Header: igwvstts.pls 115.5 2002/11/15 00:49:51 ashkumar ship $
3
4
5 PROCEDURE CREATE_STUDY_TITLE
6 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
7 , p_commit IN VARCHAR2 := FND_API.G_FALSE
8 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
9 , p_proposal_id IN NUMBER
10 , p_proposal_number IN VARCHAR2
11 , x_study_title_id OUT NOCOPY NUMBER
12 , p_study_title IN VARCHAR2
13 , p_enrollment_status IN VARCHAR2
14 , p_protocol_number IN VARCHAR2
15 , x_rowid OUT NOCOPY ROWID
16 , x_return_status OUT NOCOPY VARCHAR2
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2);
19
20 PROCEDURE UPDATE_STUDY_TITLE
21 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
22 , p_commit IN VARCHAR2 := FND_API.G_FALSE
23 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
24 , p_proposal_id IN NUMBER
25 , p_proposal_number IN VARCHAR2
26 , p_study_title_id IN NUMBER
27 , p_study_title IN VARCHAR2
28 , p_enrollment_status IN VARCHAR2
29 , p_protocol_number IN VARCHAR2
30 , p_rowid IN ROWID
31 , p_record_version_number IN NUMBER
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_msg_count OUT NOCOPY NUMBER
34 , x_msg_data OUT NOCOPY VARCHAR2);
35
36 PROCEDURE DELETE_STUDY_TITLE (
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
38 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
39 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
40 ,p_study_title_id IN NUMBER
41 ,p_record_version_number IN NUMBER
42 ,x_rowid IN VARCHAR2
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2);
46
47 PROCEDURE CHECK_LOCK
48 (x_rowid IN VARCHAR2
49 ,p_record_version_number IN NUMBER
50 ,x_return_status OUT NOCOPY VARCHAR2);
51
52 END IGW_STUDY_TITLES_PVT;