APPS.IGW_SPONSOR_ACTION_TBH dependencies on IGW_PROP_COMMENTS

Line 16: FROM igw_prop_comments

12: CURSOR cur_latest_action IS
13: SELECT sponsor_action_code,
14: sponsor_action_date,
15: comments
16: FROM igw_prop_comments
17: WHERE proposal_id = p_proposal_id
18: AND sponsor_action_code IS NOT NULL
19: ORDER BY sponsor_action_date desc, creation_date desc;
20:

Line 65: FROM igw_prop_comments

61: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
62:
63: CURSOR c IS
64: SELECT rowid
65: FROM igw_prop_comments
66: WHERE proposal_id = p_proposal_id AND
67: trunc(last_update_date) = trunc(SYSDATE);
68:
69: BEGIN

Line 85: INSERT INTO igw_prop_comments

81: App_Exception.Raise_Exception;
82:
83: END IF;
84:
85: INSERT INTO igw_prop_comments
86: (
87: proposal_id,
88: comment_id,
89: comments,

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

98: )
99: VALUES
100: (
101: p_proposal_id, /* proposal_id */
102: igw_prop_comments_s.nextval, /* comment_id */
103: p_comments, /* comments */
104: p_sponsor_action_code,
105: p_sponsor_action_date,
106: 1, /* record_version_number */

Line 182: UPDATE igw_prop_comments

178: App_Exception.Raise_Exception;
179:
180: END IF;
181:
182: UPDATE igw_prop_comments
183: SET sponsor_action_code = p_sponsor_action_code,
184: sponsor_action_date = p_sponsor_action_date,
185: comments = p_comments,
186: record_version_number = record_version_number + 1,

Line 236: DELETE igw_prop_comments

232: BEGIN
233:
234: x_return_status := Fnd_Api.G_Ret_Sts_Success;
235:
236: DELETE igw_prop_comments
237: WHERE rowid = p_rowid
238: AND record_version_number = p_record_version_number;
239:
240: IF SQL%NotFound THEN