557: l_rowid VARCHAR2(30);
558:
559: BEGIN
560:
561: -- Standard Start of API savepoint
562: SAVEPOINT CREATE_MSITE_SCT_ITEM_PVT;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call(l_api_version,
560:
561: -- Standard Start of API savepoint
562: SAVEPOINT CREATE_MSITE_SCT_ITEM_PVT;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call(l_api_version,
566: p_api_version,
567: l_api_name,
568: G_PKG_NAME)
641:
642: --
643: -- End of main API body.
644:
645: -- Standard check of p_commit.
646: IF (FND_API.To_Boolean(p_commit)) THEN
647: COMMIT WORK;
648: END IF;
649:
646: IF (FND_API.To_Boolean(p_commit)) THEN
647: COMMIT WORK;
648: END IF;
649:
650: -- Standard call to get message count and if count is 1, get message info.
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');
654:
715: l_return_status VARCHAR2(1);
716:
717: BEGIN
718:
719: -- Standard Start of API savepoint
720: SAVEPOINT UPDATE_MSITE_SCT_ITEM_PVT;
721:
722: -- Standard call to check for call compatibility.
723: IF NOT FND_API.Compatible_API_Call(l_api_version,
718:
719: -- Standard Start of API savepoint
720: SAVEPOINT UPDATE_MSITE_SCT_ITEM_PVT;
721:
722: -- Standard call to check for call compatibility.
723: IF NOT FND_API.Compatible_API_Call(l_api_version,
724: p_api_version,
725: l_api_name,
726: G_PKG_NAME)
835:
836: --
837: -- End of main API body.
838:
839: -- Standard check of p_commit.
840: IF (FND_API.To_Boolean(p_commit)) THEN
841: COMMIT WORK;
842: END IF;
843:
840: IF (FND_API.To_Boolean(p_commit)) THEN
841: COMMIT WORK;
842: END IF;
843:
844: -- Standard call to get message count and if count is 1, get message info.
845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
846: p_data => x_msg_data,
847: p_encoded => 'F');
848:
899: l_msite_sct_item_id NUMBER;
900: BEGIN
901:
902: IF (p_call_from_trigger = FALSE) THEN
903: -- Standard Start of API savepoint
904: SAVEPOINT DELETE_MSITE_SCT_ITEM_PVT;
905: END IF;
906:
907: -- Standard call to check for call compatibility.
903: -- Standard Start of API savepoint
904: SAVEPOINT DELETE_MSITE_SCT_ITEM_PVT;
905: END IF;
906:
907: -- Standard call to check for call compatibility.
908: IF NOT FND_API.Compatible_API_Call(l_api_version,
909: p_api_version,
910: l_api_name,
911: G_PKG_NAME)