18: ---------------------------------------------------------------------------------------
19:
20:
21: PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
22: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
23: , p_commit IN VARCHAR2 := FND_API.G_FALSE
24: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
25: , p_proposal_id IN NUMBER
26: , p_proposal_number IN VARCHAR2
19:
20:
21: PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
22: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
23: , p_commit IN VARCHAR2 := FND_API.G_FALSE
24: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
25: , p_proposal_id IN NUMBER
26: , p_proposal_number IN VARCHAR2
27: , p_proposal_title IN VARCHAR2
20:
21: PROCEDURE UPDATE_PROPOSAL_BASIC_INFO
22: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
23: , p_commit IN VARCHAR2 := FND_API.G_FALSE
24: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
25: , p_proposal_id IN NUMBER
26: , p_proposal_number IN VARCHAR2
27: , p_proposal_title IN VARCHAR2
28: , p_proposal_start_date IN DATE
112:
113:
114: -------------------------------------------------------------------------------------------
115: PROCEDURE UPDATE_PROPOSAL_PROGRAM
116: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: , p_commit IN VARCHAR2 := FND_API.G_FALSE
118: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: , p_proposal_id IN NUMBER
120: , p_proposal_number IN VARCHAR2
113:
114: -------------------------------------------------------------------------------------------
115: PROCEDURE UPDATE_PROPOSAL_PROGRAM
116: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: , p_commit IN VARCHAR2 := FND_API.G_FALSE
118: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: , p_proposal_id IN NUMBER
120: , p_proposal_number IN VARCHAR2
121: , p_notice_opportunity_code IN VARCHAR2
114: -------------------------------------------------------------------------------------------
115: PROCEDURE UPDATE_PROPOSAL_PROGRAM
116: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
117: , p_commit IN VARCHAR2 := FND_API.G_FALSE
118: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
119: , p_proposal_id IN NUMBER
120: , p_proposal_number IN VARCHAR2
121: , p_notice_opportunity_code IN VARCHAR2
122: , p_notice_opportunity IN VARCHAR2
150:
151:
152:
153: PROCEDURE DELETE_PROPOSAL
154: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
155: , p_commit IN VARCHAR2 := FND_API.G_FALSE
156: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
157: , p_rowid IN ROWID
158: , p_proposal_id IN NUMBER
151:
152:
153: PROCEDURE DELETE_PROPOSAL
154: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
155: , p_commit IN VARCHAR2 := FND_API.G_FALSE
156: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
157: , p_rowid IN ROWID
158: , p_proposal_id IN NUMBER
159: , x_return_status OUT NOCOPY VARCHAR2
152:
153: PROCEDURE DELETE_PROPOSAL
154: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
155: , p_commit IN VARCHAR2 := FND_API.G_FALSE
156: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
157: , p_rowid IN ROWID
158: , p_proposal_id IN NUMBER
159: , x_return_status OUT NOCOPY VARCHAR2
160: , x_msg_count OUT NOCOPY NUMBER
175: END Delete_Proposal;
176:
177:
178: PROCEDURE UPDATE_SPONSOR_ACTION
179: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
180: , p_commit IN VARCHAR2 := FND_API.G_FALSE
181: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
182: , p_proposal_id IN NUMBER
183: , p_sponsor_action_date IN DATE
176:
177:
178: PROCEDURE UPDATE_SPONSOR_ACTION
179: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
180: , p_commit IN VARCHAR2 := FND_API.G_FALSE
181: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
182: , p_proposal_id IN NUMBER
183: , p_sponsor_action_date IN DATE
184: , p_sponsor_action_code IN VARCHAR2
177:
178: PROCEDURE UPDATE_SPONSOR_ACTION
179: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
180: , p_commit IN VARCHAR2 := FND_API.G_FALSE
181: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
182: , p_proposal_id IN NUMBER
183: , p_sponsor_action_date IN DATE
184: , p_sponsor_action_code IN VARCHAR2
185: , p_award_number IN VARCHAR2