219: ---------------------------------------------------------------------------
220:
221: PROCEDURE Create_Award_Installment
222: (
223: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
224: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
225: p_commit IN VARCHAR2 := Fnd_Api.G_False,
226: p_select_option IN VARCHAR2,
227: p_proposal_id IN NUMBER,
220:
221: PROCEDURE Create_Award_Installment
222: (
223: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
224: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
225: p_commit IN VARCHAR2 := Fnd_Api.G_False,
226: p_select_option IN VARCHAR2,
227: p_proposal_id IN NUMBER,
228: p_award_template_number IN VARCHAR2,
221: PROCEDURE Create_Award_Installment
222: (
223: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
224: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
225: p_commit IN VARCHAR2 := Fnd_Api.G_False,
226: p_select_option IN VARCHAR2,
227: p_proposal_id IN NUMBER,
228: p_award_template_number IN VARCHAR2,
229: p_award_number1 IN VARCHAR2,
248: ---------------------------------------------------------------------------
249:
250: PROCEDURE Create_Award
251: (
252: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
253: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
254: p_commit IN VARCHAR2 := Fnd_Api.G_False,
255: x_rowid OUT NOCOPY VARCHAR2,
256: x_proposal_award_id OUT NOCOPY NUMBER,
249:
250: PROCEDURE Create_Award
251: (
252: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
253: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
254: p_commit IN VARCHAR2 := Fnd_Api.G_False,
255: x_rowid OUT NOCOPY VARCHAR2,
256: x_proposal_award_id OUT NOCOPY NUMBER,
257: p_proposal_id IN NUMBER,
250: PROCEDURE Create_Award
251: (
252: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
253: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
254: p_commit IN VARCHAR2 := Fnd_Api.G_False,
255: x_rowid OUT NOCOPY VARCHAR2,
256: x_proposal_award_id OUT NOCOPY NUMBER,
257: p_proposal_id IN NUMBER,
258: p_award_template_id IN NUMBER,
337: ---------------------------------------------------------------------------
338:
339: PROCEDURE Update_Award
340: (
341: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
342: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
343: p_commit IN VARCHAR2 := Fnd_Api.G_False,
344: p_rowid IN VARCHAR2,
345: p_proposal_award_id IN NUMBER,
338:
339: PROCEDURE Update_Award
340: (
341: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
342: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
343: p_commit IN VARCHAR2 := Fnd_Api.G_False,
344: p_rowid IN VARCHAR2,
345: p_proposal_award_id IN NUMBER,
346: p_record_version_number IN NUMBER,
339: PROCEDURE Update_Award
340: (
341: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
342: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
343: p_commit IN VARCHAR2 := Fnd_Api.G_False,
344: p_rowid IN VARCHAR2,
345: p_proposal_award_id IN NUMBER,
346: p_record_version_number IN NUMBER,
347: p_proposal_id IN NUMBER,
433: ---------------------------------------------------------------------------
434:
435: PROCEDURE Delete_Award
436: (
437: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
438: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
439: p_commit IN VARCHAR2 := Fnd_Api.G_False,
440: p_proposal_award_id IN NUMBER,
441: x_return_status OUT NOCOPY VARCHAR2,
434:
435: PROCEDURE Delete_Award
436: (
437: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
438: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
439: p_commit IN VARCHAR2 := Fnd_Api.G_False,
440: p_proposal_award_id IN NUMBER,
441: x_return_status OUT NOCOPY VARCHAR2,
442: x_msg_count OUT NOCOPY NUMBER,
435: PROCEDURE Delete_Award
436: (
437: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
438: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
439: p_commit IN VARCHAR2 := Fnd_Api.G_False,
440: p_proposal_award_id IN NUMBER,
441: x_return_status OUT NOCOPY VARCHAR2,
442: x_msg_count OUT NOCOPY NUMBER,
443: x_msg_data OUT NOCOPY VARCHAR2
452: ---------------------------------------------------------------------------
453:
454: PROCEDURE Transfer_Award_Installment
455: (
456: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
457: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
458: p_commit IN VARCHAR2 := Fnd_Api.G_False,
459: p_proposal_award_id IN NUMBER,
460: p_proposal_installment_id IN NUMBER,
453:
454: PROCEDURE Transfer_Award_Installment
455: (
456: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
457: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
458: p_commit IN VARCHAR2 := Fnd_Api.G_False,
459: p_proposal_award_id IN NUMBER,
460: p_proposal_installment_id IN NUMBER,
461: x_award_id OUT NOCOPY NUMBER,
454: PROCEDURE Transfer_Award_Installment
455: (
456: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
457: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
458: p_commit IN VARCHAR2 := Fnd_Api.G_False,
459: p_proposal_award_id IN NUMBER,
460: p_proposal_installment_id IN NUMBER,
461: x_award_id OUT NOCOPY NUMBER,
462: x_return_status OUT NOCOPY VARCHAR2,