16: null;
17:
18: EXCEPTION
19: WHEN OTHERS THEN
20: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
21: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'IGW_PROPOSALS_ALL_PVT',
22: p_procedure_name => 'VALIDATE_EXPENDITURE_TYPE',
23: p_error_text => SUBSTRB(SQLERRM,1,240));
24:
109: end;
110:
111: -----------------------------------------------------------------------------------------
112: PROCEDURE create_award_budget
113: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
114: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
116: ,p_proposal_id IN NUMBER
117: ,p_proposal_installment_id IN NUMBER := NULL
110:
111: -----------------------------------------------------------------------------------------
112: PROCEDURE create_award_budget
113: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
114: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
116: ,p_proposal_id IN NUMBER
117: ,p_proposal_installment_id IN NUMBER := NULL
118: ,p_budget_period_id IN NUMBER
111: -----------------------------------------------------------------------------------------
112: PROCEDURE create_award_budget
113: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
114: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
116: ,p_proposal_id IN NUMBER
117: ,p_proposal_installment_id IN NUMBER := NULL
118: ,p_budget_period_id IN NUMBER
119: ,p_expenditure_type_cat IN VARCHAR2
175:
176:
177: ------------------------------------------------------------------------------------------
178: PROCEDURE update_award_budget
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_award_budget_id IN NUMBER
183: ,p_proposal_id IN NUMBER := NULL
176:
177: ------------------------------------------------------------------------------------------
178: PROCEDURE update_award_budget
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_award_budget_id IN NUMBER
183: ,p_proposal_id IN NUMBER := NULL
184: ,p_proposal_installment_id IN NUMBER := NULL
177: ------------------------------------------------------------------------------------------
178: PROCEDURE update_award_budget
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_award_budget_id IN NUMBER
183: ,p_proposal_id IN NUMBER := NULL
184: ,p_proposal_installment_id IN NUMBER := NULL
185: ,p_budget_period_id IN NUMBER := NULL
240:
241: -------------------------------------------------------------------------------------------
242:
243: PROCEDURE delete_award_budget
244: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
245: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
247: ,p_award_budget_id IN NUMBER
248: ,p_record_version_number IN NUMBER
241: -------------------------------------------------------------------------------------------
242:
243: PROCEDURE delete_award_budget
244: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
245: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
247: ,p_award_budget_id IN NUMBER
248: ,p_record_version_number IN NUMBER
249: ,p_rowid IN ROWID
242:
243: PROCEDURE delete_award_budget
244: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
245: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
247: ,p_award_budget_id IN NUMBER
248: ,p_record_version_number IN NUMBER
249: ,p_rowid IN ROWID
250: ,x_return_status OUT NOCOPY VARCHAR2