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
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
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
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
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
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
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
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
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