[Home] [Help]
51: l_application_id NUMBER;
52:
53: BEGIN
54: /***************************************************************************
55: ** Standard start of API savepoint
56: ***************************************************************************/
57: SAVEPOINT create_item_pub;
58: /***************************************************************************
59: ** Standard call to check for call compatibility
55: ** Standard start of API savepoint
56: ***************************************************************************/
57: SAVEPOINT create_item_pub;
58: /***************************************************************************
59: ** Standard call to check for call compatibility
60: ***************************************************************************/
61: IF NOT FND_API.Compatible_API_Call( l_api_version
62: , p_api_version
63: , l_api_name
210: , p_itm_rec => l_pvt
211: , x_cal_item_id => x_cal_item_id
212: );
213: /***************************************************************************
214: ** Standard check of p_commit
215: ***************************************************************************/
216: IF FND_API.To_Boolean(p_commit)
217: THEN
218: COMMIT WORK;
217: THEN
218: COMMIT WORK;
219: END IF;
220: /***************************************************************************
221: ** Standard call to get message count and if count is 1, get message info
222: ***************************************************************************/
223: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
224: , p_data => x_msg_data
225: );
301: l_last_update_date DATE;
302:
303: BEGIN
304: /***************************************************************************
305: ** Standard start of API savepoint
306: ***************************************************************************/
307: SAVEPOINT update_item_pub;
308: /***************************************************************************
309: ** Standard call to check for call compatibility
305: ** Standard start of API savepoint
306: ***************************************************************************/
307: SAVEPOINT update_item_pub;
308: /***************************************************************************
309: ** Standard call to check for call compatibility
310: ***************************************************************************/
311: IF NOT FND_API.Compatible_API_Call( l_api_version
312: , p_api_version
313: , l_api_name
417: , p_itm_rec => l_pvt
418: , x_object_version_number => x_object_version_number
419: );
420: /***************************************************************************
421: ** Standard check of p_commit
422: ***************************************************************************/
423: IF FND_API.To_Boolean(p_commit)
424: THEN
425: COMMIT WORK;
424: THEN
425: COMMIT WORK;
426: END IF;
427: /***************************************************************************
428: ** Standard call to get message count and if count is 1, get message info
429: ***************************************************************************/
430: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
431: , p_data => x_msg_data
432: );
507: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
508:
509: BEGIN
510: /***************************************************************************
511: ** Standard start of API savepoint
512: ***************************************************************************/
513: SAVEPOINT delete_item_pub;
514: /***************************************************************************
515: ** Standard call to check for call compatibility
511: ** Standard start of API savepoint
512: ***************************************************************************/
513: SAVEPOINT delete_item_pub;
514: /***************************************************************************
515: ** Standard call to check for call compatibility
516: ***************************************************************************/
517: IF NOT FND_API.Compatible_API_Call( l_api_version
518: , p_api_version
519: , l_api_name
548: , p_cal_item_id => p_cal_item_id
549: , p_object_version_number => p_object_version_number
550: );
551: /***************************************************************************
552: ** Standard check of p_commit
553: ***************************************************************************/
554: IF FND_API.To_Boolean(p_commit)
555: THEN
556: COMMIT WORK;
555: THEN
556: COMMIT WORK;
557: END IF;
558: /***************************************************************************
559: ** Standard call to get message count and if count is 1, get message info
560: ***************************************************************************/
561: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
562: , p_data => x_msg_data
563: );
637: l_object_version_number NUMBER;
638:
639: BEGIN
640: /***************************************************************************
641: ** Standard call to check for call compatibility
642: ***************************************************************************/
643: IF NOT FND_API.Compatible_API_Call( l_api_version
644: , p_api_version
645: , l_api_name
673: , x_object_version_number => l_object_version_number
674: );
675: x_object_version_number := l_object_version_number;
676: /***************************************************************************
677: ** Standard call to get message count and if count is 1, get message info
678: ***************************************************************************/
679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
680: , p_data => x_msg_data
681: );