594: l_rowid VARCHAR2(30);
595:
596: BEGIN
597:
598: -- Standard Start of API savepoint
599: SAVEPOINT CREATE_MSITE_SCT_ITEM_PVT;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call(l_api_version,
597:
598: -- Standard Start of API savepoint
599: SAVEPOINT CREATE_MSITE_SCT_ITEM_PVT;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call(l_api_version,
603: p_api_version,
604: l_api_name,
605: G_PKG_NAME)
684:
685: --
686: -- End of main API body.
687:
688: -- Standard check of p_commit.
689: IF (FND_API.To_Boolean(p_commit)) THEN
690: COMMIT WORK;
691: END IF;
692:
689: IF (FND_API.To_Boolean(p_commit)) THEN
690: COMMIT WORK;
691: END IF;
692:
693: -- Standard call to get message count and if count is 1, get message info.
694: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => 'F');
697:
765: l_return_status VARCHAR2(1);
766:
767: BEGIN
768:
769: -- Standard Start of API savepoint
770: SAVEPOINT UPDATE_MSITE_SCT_ITEM_PVT;
771:
772: -- Standard call to check for call compatibility.
773: IF NOT FND_API.Compatible_API_Call(l_api_version,
768:
769: -- Standard Start of API savepoint
770: SAVEPOINT UPDATE_MSITE_SCT_ITEM_PVT;
771:
772: -- Standard call to check for call compatibility.
773: IF NOT FND_API.Compatible_API_Call(l_api_version,
774: p_api_version,
775: l_api_name,
776: G_PKG_NAME)
897:
898: --
899: -- End of main API body.
900:
901: -- Standard check of p_commit.
902: IF (FND_API.To_Boolean(p_commit)) THEN
903: COMMIT WORK;
904: END IF;
905:
902: IF (FND_API.To_Boolean(p_commit)) THEN
903: COMMIT WORK;
904: END IF;
905:
906: -- Standard call to get message count and if count is 1, get message info.
907: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
908: p_data => x_msg_data,
909: p_encoded => 'F');
910:
968: l_msite_sct_item_id NUMBER;
969: BEGIN
970:
971: IF (p_call_from_trigger = FALSE) THEN
972: -- Standard Start of API savepoint
973: SAVEPOINT DELETE_MSITE_SCT_ITEM_PVT;
974: END IF;
975:
976: -- Standard call to check for call compatibility.
972: -- Standard Start of API savepoint
973: SAVEPOINT DELETE_MSITE_SCT_ITEM_PVT;
974: END IF;
975:
976: -- Standard call to check for call compatibility.
977: IF NOT FND_API.Compatible_API_Call(l_api_version,
978: p_api_version,
979: l_api_name,
980: G_PKG_NAME)