4: ---------------------------------------------------------------------------
5:
6: PROCEDURE Create_Prop_Comment
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: x_rowid OUT NOCOPY VARCHAR2,
12: p_proposal_id IN NUMBER,
5:
6: PROCEDURE Create_Prop_Comment
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: x_rowid OUT NOCOPY VARCHAR2,
12: p_proposal_id IN NUMBER,
13: p_proposal_number IN VARCHAR2,
6: PROCEDURE Create_Prop_Comment
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: x_rowid OUT NOCOPY VARCHAR2,
12: p_proposal_id IN NUMBER,
13: p_proposal_number IN VARCHAR2,
14: p_comments IN VARCHAR2,
20: ---------------------------------------------------------------------------
21:
22: PROCEDURE Update_Prop_Comment
23: (
24: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
25: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
26: p_commit IN VARCHAR2 := Fnd_Api.G_False,
27: p_rowid IN VARCHAR2,
28: p_proposal_id IN NUMBER,
21:
22: PROCEDURE Update_Prop_Comment
23: (
24: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
25: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
26: p_commit IN VARCHAR2 := Fnd_Api.G_False,
27: p_rowid IN VARCHAR2,
28: p_proposal_id IN NUMBER,
29: p_proposal_number IN VARCHAR2,
22: PROCEDURE Update_Prop_Comment
23: (
24: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
25: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
26: p_commit IN VARCHAR2 := Fnd_Api.G_False,
27: p_rowid IN VARCHAR2,
28: p_proposal_id IN NUMBER,
29: p_proposal_number IN VARCHAR2,
30: p_comment_id IN NUMBER,
38: ---------------------------------------------------------------------------
39:
40: PROCEDURE Delete_Prop_Comment
41: (
42: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
43: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
44: p_commit IN VARCHAR2 := Fnd_Api.G_False,
45: p_rowid IN VARCHAR2,
46: p_proposal_id IN NUMBER,
39:
40: PROCEDURE Delete_Prop_Comment
41: (
42: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
43: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
44: p_commit IN VARCHAR2 := Fnd_Api.G_False,
45: p_rowid IN VARCHAR2,
46: p_proposal_id IN NUMBER,
47: p_record_version_number IN NUMBER,
40: PROCEDURE Delete_Prop_Comment
41: (
42: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
43: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
44: p_commit IN VARCHAR2 := Fnd_Api.G_False,
45: p_rowid IN VARCHAR2,
46: p_proposal_id IN NUMBER,
47: p_record_version_number IN NUMBER,
48: x_return_status OUT NOCOPY VARCHAR2,