657: l_rowid VARCHAR2(30);
658:
659: BEGIN
660:
661: -- Standard Start of API savepoint
662: SAVEPOINT CREATE_SECTION_ITEM_PVT;
663:
664: -- Standard call to check for call compatibility.
665: IF NOT FND_API.Compatible_API_Call(l_api_version,
660:
661: -- Standard Start of API savepoint
662: SAVEPOINT CREATE_SECTION_ITEM_PVT;
663:
664: -- Standard call to check for call compatibility.
665: IF NOT FND_API.Compatible_API_Call(l_api_version,
666: p_api_version,
667: l_api_name,
668: G_PKG_NAME)
756:
757: --
758: -- End of main API body.
759:
760: -- Standard check of p_commit.
761: IF (FND_API.To_Boolean(p_commit)) THEN
762: COMMIT WORK;
763: END IF;
764:
761: IF (FND_API.To_Boolean(p_commit)) THEN
762: COMMIT WORK;
763: END IF;
764:
765: -- Standard call to get message count and if count is 1, get message info.
766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => 'F');
769:
827: l_return_status VARCHAR2(1);
828:
829: BEGIN
830:
831: -- Standard Start of API savepoint
832: SAVEPOINT UPDATE_SECTION_ITEM_PVT;
833:
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call(l_api_version,
830:
831: -- Standard Start of API savepoint
832: SAVEPOINT UPDATE_SECTION_ITEM_PVT;
833:
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call(l_api_version,
836: p_api_version,
837: l_api_name,
838: G_PKG_NAME)
957:
958: --
959: -- End of main API body.
960:
961: -- Standard check of p_commit.
962: IF (FND_API.To_Boolean(p_commit)) THEN
963: COMMIT WORK;
964: END IF;
965:
962: IF (FND_API.To_Boolean(p_commit)) THEN
963: COMMIT WORK;
964: END IF;
965:
966: -- Standard call to get message count and if count is 1, get message info.
967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
968: p_data => x_msg_data,
969: p_encoded => 'F');
970:
1035: BEGIN
1036:
1037: -- Call savepoint only when not called from trigger
1038: IF (p_call_from_trigger = FALSE) THEN
1039: -- Standard Start of API savepoint
1040: SAVEPOINT DELETE_SECTION_ITEM_PVT;
1041: END IF;
1042:
1043: -- Standard call to check for call compatibility.
1039: -- Standard Start of API savepoint
1040: SAVEPOINT DELETE_SECTION_ITEM_PVT;
1041: END IF;
1042:
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.Compatible_API_Call(l_api_version,
1045: p_api_version,
1046: l_api_name,
1047: G_PKG_NAME)
1276: l_return_status VARCHAR2(1);
1277:
1278: BEGIN
1279:
1280: -- Standard Start of API savepoint
1281: SAVEPOINT UPDATE_DELETE_SCT_ITMS_PVT;
1282:
1283: -- Standard call to check for call compatibility.
1284: IF NOT FND_API.Compatible_API_Call(l_api_version,
1279:
1280: -- Standard Start of API savepoint
1281: SAVEPOINT UPDATE_DELETE_SCT_ITMS_PVT;
1282:
1283: -- Standard call to check for call compatibility.
1284: IF NOT FND_API.Compatible_API_Call(l_api_version,
1285: p_api_version,
1286: l_api_name,
1287: G_PKG_NAME)
1361:
1362: --
1363: -- End of main API body.
1364:
1365: -- Standard check of p_commit.
1366: IF (FND_API.To_Boolean(p_commit)) THEN
1367: COMMIT WORK;
1368: END IF;
1369:
1366: IF (FND_API.To_Boolean(p_commit)) THEN
1367: COMMIT WORK;
1368: END IF;
1369:
1370: -- Standard call to get message count and if count is 1, get message info.
1371: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1372: p_data => x_msg_data,
1373: p_encoded => 'F');
1374: