2: --$Header: igwvpadb.pls 120.3 2005/09/12 21:06:12 vmedikon ship $
3:
4: ------------------------------------------------------------------------------------
5: PROCEDURE CREATE_MAILING_INFO
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_MAILING_INFO
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: , p_address_id IN NUMBER
4: ------------------------------------------------------------------------------------
5: PROCEDURE CREATE_MAILING_INFO
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: , p_address_id IN NUMBER
12: , p_address IN VARCHAR2
34:
35: ---------------------------------------------------------------------
36:
37: PROCEDURE UPDATE_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
35: ---------------------------------------------------------------------
36:
37: PROCEDURE UPDATE_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
36:
37: PROCEDURE UPDATE_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_address IN VARCHAR2
69: END; --UPDATE MAILING INFO
70: -------------------------------------------------------------------------------------
71:
72: PROCEDURE DELETE_MAILING_INFO
73: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
74: , p_commit IN VARCHAR2 := FND_API.G_FALSE
75: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
76: , p_proposal_id IN NUMBER
77: , p_proposal_number IN VARCHAR2
70: -------------------------------------------------------------------------------------
71:
72: PROCEDURE DELETE_MAILING_INFO
73: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
74: , p_commit IN VARCHAR2 := FND_API.G_FALSE
75: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
76: , p_proposal_id IN NUMBER
77: , p_proposal_number IN VARCHAR2
78: , p_address_id IN NUMBER
71:
72: PROCEDURE DELETE_MAILING_INFO
73: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
74: , p_commit IN VARCHAR2 := FND_API.G_FALSE
75: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
76: , p_proposal_id IN NUMBER
77: , p_proposal_number IN VARCHAR2
78: , p_address_id IN NUMBER
79: , p_record_version_number IN NUMBER