4: ---------------------------------------------------------------------------
5:
6: PROCEDURE Create_Award_Installment
7: (
8: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
9: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
10: p_commit IN VARCHAR2 := Fnd_Api.G_False,
11: p_select_option IN VARCHAR2,
12: p_proposal_id IN NUMBER,
5:
6: PROCEDURE Create_Award_Installment
7: (
8: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
9: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
10: p_commit IN VARCHAR2 := Fnd_Api.G_False,
11: p_select_option IN VARCHAR2,
12: p_proposal_id IN NUMBER,
13: p_award_template_number IN VARCHAR2,
6: PROCEDURE Create_Award_Installment
7: (
8: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
9: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
10: p_commit IN VARCHAR2 := Fnd_Api.G_False,
11: p_select_option IN VARCHAR2,
12: p_proposal_id IN NUMBER,
13: p_award_template_number IN VARCHAR2,
14: p_award_number1 IN VARCHAR2,
23: ---------------------------------------------------------------------------
24:
25: PROCEDURE Create_Award
26: (
27: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
28: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
29: p_commit IN VARCHAR2 := Fnd_Api.G_False,
30: x_rowid OUT NOCOPY VARCHAR2,
31: x_proposal_award_id OUT NOCOPY NUMBER,
24:
25: PROCEDURE Create_Award
26: (
27: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
28: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
29: p_commit IN VARCHAR2 := Fnd_Api.G_False,
30: x_rowid OUT NOCOPY VARCHAR2,
31: x_proposal_award_id OUT NOCOPY NUMBER,
32: p_proposal_id IN NUMBER,
25: PROCEDURE Create_Award
26: (
27: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
28: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
29: p_commit IN VARCHAR2 := Fnd_Api.G_False,
30: x_rowid OUT NOCOPY VARCHAR2,
31: x_proposal_award_id OUT NOCOPY NUMBER,
32: p_proposal_id IN NUMBER,
33: p_award_template_id IN NUMBER,
94: ---------------------------------------------------------------------------
95:
96: PROCEDURE Update_Award
97: (
98: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
99: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
100: p_commit IN VARCHAR2 := Fnd_Api.G_False,
101: p_rowid IN VARCHAR2,
102: p_proposal_award_id IN NUMBER,
95:
96: PROCEDURE Update_Award
97: (
98: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
99: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
100: p_commit IN VARCHAR2 := Fnd_Api.G_False,
101: p_rowid IN VARCHAR2,
102: p_proposal_award_id IN NUMBER,
103: p_record_version_number IN NUMBER,
96: PROCEDURE Update_Award
97: (
98: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
99: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
100: p_commit IN VARCHAR2 := Fnd_Api.G_False,
101: p_rowid IN VARCHAR2,
102: p_proposal_award_id IN NUMBER,
103: p_record_version_number IN NUMBER,
104: p_proposal_id IN NUMBER,
166: ---------------------------------------------------------------------------
167:
168: PROCEDURE Delete_Award
169: (
170: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
171: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
172: p_commit IN VARCHAR2 := Fnd_Api.G_False,
173: p_proposal_award_id IN NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2,
167:
168: PROCEDURE Delete_Award
169: (
170: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
171: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
172: p_commit IN VARCHAR2 := Fnd_Api.G_False,
173: p_proposal_award_id IN NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
168: PROCEDURE Delete_Award
169: (
170: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
171: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
172: p_commit IN VARCHAR2 := Fnd_Api.G_False,
173: p_proposal_award_id IN NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2
179: ---------------------------------------------------------------------------
180:
181: PROCEDURE Transfer_Award_Installment
182: (
183: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
184: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
185: p_commit IN VARCHAR2 := Fnd_Api.G_False,
186: p_proposal_award_id IN NUMBER,
187: p_proposal_installment_id IN NUMBER,
180:
181: PROCEDURE Transfer_Award_Installment
182: (
183: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
184: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
185: p_commit IN VARCHAR2 := Fnd_Api.G_False,
186: p_proposal_award_id IN NUMBER,
187: p_proposal_installment_id IN NUMBER,
188: x_award_id OUT NOCOPY NUMBER,
181: PROCEDURE Transfer_Award_Installment
182: (
183: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
184: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
185: p_commit IN VARCHAR2 := Fnd_Api.G_False,
186: p_proposal_award_id IN NUMBER,
187: p_proposal_installment_id IN NUMBER,
188: x_award_id OUT NOCOPY NUMBER,
189: x_return_status OUT NOCOPY VARCHAR2,