1: PACKAGE BODY Igw_Prop_Comments_Pvt AS
2: --$Header: igwvcomb.pls 115.5 2002/11/15 00:36:12 ashkumar ship $
3:
4: ---------------------------------------------------------------------------
5:
2: --$Header: igwvcomb.pls 115.5 2002/11/15 00:36:12 ashkumar ship $
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_COMMENTS_PVT';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Check_Comment_Update_Rights
18: BEGIN
19:
20: SELECT last_updated_by
21: INTO l_last_updated_by
22: FROM igw_prop_comments
23: WHERE rowid = p_rowid;
24:
25: IF l_last_updated_by <> Fnd_Global.User_Id THEN
26:
61: IF p_rowid IS NOT NULL AND p_record_version_number IS NOT NULL THEN
62:
63: SELECT 'N'
64: INTO l_locked
65: FROM igw_prop_comments
66: WHERE rowid = p_rowid
67: AND record_version_number = p_record_version_number;
68:
69: END IF;
185: /*
186: ** Invoke Table Handler to insert data
187: */
188:
189: Igw_Prop_Comments_Tbh.Insert_Row
190: (
191: x_rowid => x_rowid,
192: p_proposal_id => l_proposal_id,
193: p_comments => p_comments,
416: /*
417: ** Invoke Table Handler to Update data
418: */
419:
420: Igw_Prop_Comments_Tbh.Update_Row
421: (
422: p_rowid => p_rowid,
423: p_proposal_id => l_proposal_id,
424: p_comment_id => p_comment_id,
602: /*
603: ** Invoke Table Handler to Delete data
604: */
605:
606: Igw_Prop_Comments_Tbh.Delete_Row
607: (
608: p_rowid => p_rowid,
609: p_record_version_number => p_record_version_number,
610: x_return_status => x_return_status
669: END Delete_Prop_Comment;
670:
671: ---------------------------------------------------------------------------
672:
673: END Igw_Prop_Comments_Pvt;