APPS.IGW_PROP_COMMENTS_PKG dependencies on IGW_PROP_COMMENTS

Line 1: PACKAGE BODY IGW_PROP_COMMENTS_PKG as

1: PACKAGE BODY IGW_PROP_COMMENTS_PKG as
2: --$Header: igwprnpb.pls 115.4 2002/03/28 19:13:43 pkm ship $
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
5: X_Proposal_Id NUMBER,

Line 14: CURSOR C IS SELECT rowid FROM IGW_PROP_COMMENTS

10: X_Creation_Date DATE,
11: X_Created_By NUMBER,
12: X_Last_Update_Login NUMBER) IS
13:
14: CURSOR C IS SELECT rowid FROM IGW_PROP_COMMENTS
15: WHERE comment_id = X_comment_ID;
16:
17: BEGIN
18: INSERT INTO IGW_PROP_COMMENTS( PROPOSAL_ID,

Line 18: INSERT INTO IGW_PROP_COMMENTS( PROPOSAL_ID,

14: CURSOR C IS SELECT rowid FROM IGW_PROP_COMMENTS
15: WHERE comment_id = X_comment_ID;
16:
17: BEGIN
18: INSERT INTO IGW_PROP_COMMENTS( PROPOSAL_ID,
19: COMMENT_ID,
20: COMMENTS,
21: LAST_UPDATE_DATE,
22: LAST_UPDATED_BY,

Line 52: cursor c is select * from IGW_prop_comments

48: X_Last_Updated_By NUMBER,
49: X_Creation_Date DATE,
50: X_Created_By NUMBER,
51: X_Last_Update_Login NUMBER) IS
52: cursor c is select * from IGW_prop_comments
53: where rowid = X_rowid
54: for update of comment_id nowait;
55: Recinfo c%rowtype;
56: Begin

Line 92: update igw_prop_comments

88: X_Creation_Date DATE,
89: X_Created_By NUMBER,
90: X_Last_Update_Login NUMBER) IS
91: begin
92: update igw_prop_comments
93: set proposal_id = X_proposal_id,
94: comment_id = X_comment_id,
95: comments = X_comments,
96: last_update_date = X_last_update_date,

Line 109: delete igw_prop_comments

105: End update_row;
106:
107: PROCEDURE Delete_Row(X_Rowid VARCHAR2) is
108: begin
109: delete igw_prop_comments
110: where rowid = X_Rowid;
111: END Delete_row;
112:
113: END IGW_PROP_COMMENTS_PKG;

Line 113: END IGW_PROP_COMMENTS_PKG;

109: delete igw_prop_comments
110: where rowid = X_Rowid;
111: END Delete_row;
112:
113: END IGW_PROP_COMMENTS_PKG;