2: --$Header: igwvbass.pls 120.3 2005/10/30 05:50:33 appldev ship $
3:
4: /*
5: PROCEDURE CREATE_PROPOSAL
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_number IN VARCHAR2
10: , p_proposal_title IN VARCHAR2
3:
4: /*
5: PROCEDURE CREATE_PROPOSAL
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_number IN VARCHAR2
10: , p_proposal_title IN VARCHAR2
11: , p_proposal_start_date IN DATE
4: /*
5: PROCEDURE CREATE_PROPOSAL
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_number IN VARCHAR2
10: , p_proposal_title IN VARCHAR2
11: , p_proposal_start_date IN DATE
12: , p_proposal_end_date IN DATE
58:
59: --
60:
61: PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
62: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63: , p_commit IN VARCHAR2 := FND_API.G_FALSE
64: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
65: , p_proposal_id IN NUMBER
66: , p_proposal_number IN VARCHAR2
59: --
60:
61: PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
62: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63: , p_commit IN VARCHAR2 := FND_API.G_FALSE
64: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
65: , p_proposal_id IN NUMBER
66: , p_proposal_number IN VARCHAR2
67: , p_proposal_title IN VARCHAR2
60:
61: PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
62: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63: , p_commit IN VARCHAR2 := FND_API.G_FALSE
64: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
65: , p_proposal_id IN NUMBER
66: , p_proposal_number IN VARCHAR2
67: , p_proposal_title IN VARCHAR2
68: , p_proposal_start_date IN DATE
120:
121:
122:
123: PROCEDURE UPDATE_PROPOSAL_PROGRAM
124: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: , p_commit IN VARCHAR2 := FND_API.G_FALSE
126: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127: , p_proposal_id IN NUMBER
128: , p_proposal_number IN VARCHAR2
121:
122:
123: PROCEDURE UPDATE_PROPOSAL_PROGRAM
124: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: , p_commit IN VARCHAR2 := FND_API.G_FALSE
126: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127: , p_proposal_id IN NUMBER
128: , p_proposal_number IN VARCHAR2
129: , p_notice_opportunity_code IN VARCHAR2
122:
123: PROCEDURE UPDATE_PROPOSAL_PROGRAM
124: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: , p_commit IN VARCHAR2 := FND_API.G_FALSE
126: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127: , p_proposal_id IN NUMBER
128: , p_proposal_number IN VARCHAR2
129: , p_notice_opportunity_code IN VARCHAR2
130: , p_notice_opportunity IN VARCHAR2
141: , x_msg_data OUT NOCOPY VARCHAR2);
142:
143:
144: PROCEDURE DELETE_PROPOSAL
145: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
148: , p_rowid IN ROWID
149: , p_proposal_id IN NUMBER
142:
143:
144: PROCEDURE DELETE_PROPOSAL
145: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
148: , p_rowid IN ROWID
149: , p_proposal_id IN NUMBER
150: , x_return_status OUT NOCOPY VARCHAR2
143:
144: PROCEDURE DELETE_PROPOSAL
145: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
148: , p_rowid IN ROWID
149: , p_proposal_id IN NUMBER
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_msg_count OUT NOCOPY NUMBER
154:
155:
156:
157: PROCEDURE UPDATE_SPONSOR_ACTION
158: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
159: , p_commit IN VARCHAR2 := FND_API.G_FALSE
160: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
161: , p_proposal_id IN NUMBER
162: , p_sponsor_action_date IN DATE
155:
156:
157: PROCEDURE UPDATE_SPONSOR_ACTION
158: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
159: , p_commit IN VARCHAR2 := FND_API.G_FALSE
160: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
161: , p_proposal_id IN NUMBER
162: , p_sponsor_action_date IN DATE
163: , p_sponsor_action_code IN VARCHAR2
156:
157: PROCEDURE UPDATE_SPONSOR_ACTION
158: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
159: , p_commit IN VARCHAR2 := FND_API.G_FALSE
160: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
161: , p_proposal_id IN NUMBER
162: , p_sponsor_action_date IN DATE
163: , p_sponsor_action_code IN VARCHAR2
164: , p_award_number IN VARCHAR2