53: WHERE WF_ATTR_VALUE_ID = l_wf_attr_value_id;
54:
55: BEGIN
56: --
57: -- Standard start of API savepoint
58: --
59: SAVEPOINT Create_WFAttrValue_PVT;
60:
61: --
58: --
59: SAVEPOINT Create_WFAttrValue_PVT;
60:
61: --
62: -- Standard call to check for call compatibility
63: --
64: IF NOT FND_API.Compatible_API_Call( l_api_version
65: , p_api_version
66: , l_api_name
185: --
186: x_record_id := l_wf_attr_value_id;
187:
188: --
189: -- Standard check of p_commit
190: --
191: IF FND_API.To_Boolean(p_commit)
192: THEN
193: COMMIT WORK;
193: COMMIT WORK;
194: END IF;
195:
196: --
197: -- Standard call to get message count and if count is 1, get message info
198: --
199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
200: , p_data => x_msg_data
201: );
279: l_msg_data VARCHAR2(2000);
280:
281: BEGIN
282: --
283: -- Standard start of API savepoint
284: --
285: SAVEPOINT Update_WFAttrValue_PVT;
286:
287: --
284: --
285: SAVEPOINT Update_WFAttrValue_PVT;
286:
287: --
288: -- Standard call to check for call compatibility
289: --
290: IF NOT FND_API.Compatible_API_Call( l_api_version
291: , p_api_version
292: , l_api_name
357: RAISE no_data_found;
358: END IF;
359:
360: --
361: -- Standard check of p_commit
362: --
363: IF FND_API.To_Boolean(p_commit)
364: THEN
365: COMMIT WORK;
365: COMMIT WORK;
366: END IF;
367:
368: --
369: -- Standard call to get message count and if count is 1, get message info
370: --
371: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
372: , p_data => x_msg_data
373: );