32: WHERE proposal_funding_id = x_proposal_funding_id;
33:
34: BEGIN
35:
36: x_return_status := Fnd_Api.G_Ret_Sts_Success;
37:
38: IF p_mode = 'I' THEN
39:
40: l_last_updated_by := 1;
97: EXCEPTION
98:
99: WHEN others THEN
100:
101: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
102:
103: Fnd_Msg_Pub.Add_Exc_Msg
104: (
105: p_pkg_name => G_PKG_NAME,
105: p_pkg_name => G_PKG_NAME,
106: p_procedure_name => l_api_name
107: );
108:
109: RAISE Fnd_Api.G_Exc_Unexpected_Error;
110:
111: END Insert_Row;
112:
113: ---------------------------------------------------------------------------
132: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
133:
134: BEGIN
135:
136: x_return_status := Fnd_Api.G_Ret_Sts_Success;
137:
138: IF p_mode = 'I' THEN
139:
140: l_last_updated_by := 1;
171: EXCEPTION
172:
173: WHEN others THEN
174:
175: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
176:
177: Fnd_Msg_Pub.Add_Exc_Msg
178: (
179: p_pkg_name => G_PKG_NAME,
179: p_pkg_name => G_PKG_NAME,
180: p_procedure_name => l_api_name
181: );
182:
183: RAISE Fnd_Api.G_Exc_Unexpected_Error;
184:
185: END Update_Row;
186:
187: ---------------------------------------------------------------------------
195: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
196:
197: BEGIN
198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Success;
200:
201: DELETE igw_project_fundings
202: WHERE rowid = p_rowid;
203:
212: EXCEPTION
213:
214: WHEN others THEN
215:
216: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
217:
218: Fnd_Msg_Pub.Add_Exc_Msg
219: (
220: p_pkg_name => G_PKG_NAME,
220: p_pkg_name => G_PKG_NAME,
221: p_procedure_name => l_api_name
222: );
223:
224: RAISE Fnd_Api.G_Exc_Unexpected_Error;
225:
226: END Delete_Row;
227:
228: ---------------------------------------------------------------------------