1 PACKAGE IGW_PROP_PROGRAM_ADDRESSES_PVT AUTHID CURRENT_USER AS
2 --$Header: igwvpads.pls 115.4 2002/11/15 00:43:39 ashkumar ship $
3
4 PROCEDURE CREATE_MAILING_INFO
5 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6 , p_commit IN VARCHAR2 := FND_API.G_FALSE
7 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
8 , p_proposal_id IN NUMBER
9 , p_proposal_number IN VARCHAR2
10 , p_address_id IN NUMBER
11 , p_address IN VARCHAR2
12 , p_mail_description IN VARCHAR2
13 , p_number_of_copies IN VARCHAR2
14 , x_rowid OUT NOCOPY ROWID
15 , x_return_status OUT NOCOPY VARCHAR2
16 , x_msg_count OUT NOCOPY NUMBER
17 , x_msg_data OUT NOCOPY VARCHAR2) ;
18
19
20 PROCEDURE UPDATE_MAILING_INFO
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_address_id IN NUMBER
27 , p_address IN VARCHAR2
28 , p_mail_description IN VARCHAR2
29 , p_number_of_copies IN VARCHAR2
30 , p_record_version_number IN NUMBER
31 , p_rowid IN ROWID
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_msg_count OUT NOCOPY NUMBER
34 , x_msg_data OUT NOCOPY VARCHAR2);
35
36
37 PROCEDURE DELETE_MAILING_INFO
38 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
39 , p_commit IN VARCHAR2 := FND_API.G_FALSE
40 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
41 , p_proposal_id IN NUMBER
42 , p_proposal_number IN VARCHAR2
43 , p_address_id IN NUMBER
44 , p_record_version_number IN NUMBER
45 , p_rowid IN ROWID
46 , x_return_status OUT NOCOPY VARCHAR2
47 , x_msg_count OUT NOCOPY NUMBER
48 , x_msg_data OUT NOCOPY VARCHAR2);
49
50
51 END IGW_PROP_PROGRAM_ADDRESSES_PVT;