APPS.IGW_PROP_COMMENTS_TBH dependencies on IGW_PROP_COMMENTS

Line 1: PACKAGE BODY Igw_Prop_Comments_Tbh AS

1: PACKAGE BODY Igw_Prop_Comments_Tbh AS
2: /* $Header: igwtcomb.pls 115.5 2002/11/15 00:36:42 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:

Line 6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_COMMENTS_TBH';

2: /* $Header: igwtcomb.pls 115.5 2002/11/15 00:36:42 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_COMMENTS_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 27: FROM igw_prop_comments

23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
24:
25: CURSOR c IS
26: SELECT rowid
27: FROM igw_prop_comments
28: WHERE proposal_id = p_proposal_id AND
29: comments = p_comments AND
30: trunc(last_update_date) = trunc(SYSDATE);
31:

Line 48: INSERT INTO igw_prop_comments

44: App_Exception.Raise_Exception;
45:
46: END IF;
47:
48: INSERT INTO igw_prop_comments
49: (
50: proposal_id,
51: comment_id,
52: comments,

Line 63: igw_prop_comments_s.nextval, /* comment_id */

59: )
60: VALUES
61: (
62: p_proposal_id, /* proposal_id */
63: igw_prop_comments_s.nextval, /* comment_id */
64: p_comments, /* comments */
65: 1, /* record_version_number */
66: l_last_update_date, /* creation_date */
67: l_last_updated_by, /* created_by */

Line 137: UPDATE igw_prop_comments

133: App_Exception.Raise_Exception;
134:
135: END IF;
136:
137: UPDATE igw_prop_comments
138: SET comments = p_comments,
139: record_version_number = record_version_number + 1,
140: last_update_date = l_last_update_date,
141: last_updated_by = l_last_updated_by,

Line 186: DELETE igw_prop_comments

182: BEGIN
183:
184: x_return_status := Fnd_Api.G_Ret_Sts_Success;
185:
186: DELETE igw_prop_comments
187: WHERE rowid = p_rowid
188: AND record_version_number = p_record_version_number;
189:
190: IF SQL%NotFound THEN

Line 216: END Igw_Prop_Comments_Tbh;

212: END Delete_Row;
213:
214: ---------------------------------------------------------------------------
215:
216: END Igw_Prop_Comments_Tbh;