1411: l_rowid VARCHAR2(30);
1412:
1413: BEGIN
1414:
1415: -- Standard Start of API savepoint
1416: SAVEPOINT CREATE_SECTION_GRP;
1417:
1418: -- Standard call to check for call compatibility.
1419: IF NOT FND_API.Compatible_API_Call(l_api_version,
1414:
1415: -- Standard Start of API savepoint
1416: SAVEPOINT CREATE_SECTION_GRP;
1417:
1418: -- Standard call to check for call compatibility.
1419: IF NOT FND_API.Compatible_API_Call(l_api_version,
1420: p_api_version,
1421: l_api_name,
1422: G_PKG_NAME)
1547:
1548: --
1549: -- End of main API body.
1550:
1551: -- Standard check of p_commit.
1552: IF (FND_API.To_Boolean(p_commit)) THEN
1553: COMMIT WORK;
1554: END IF;
1555:
1552: IF (FND_API.To_Boolean(p_commit)) THEN
1553: COMMIT WORK;
1554: END IF;
1555:
1556: -- Standard call to get message count and if count is 1, get message info.
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1558: p_data => x_msg_data,
1559: p_encoded => 'F');
1560:
1641: l_return_status VARCHAR2(1);
1642:
1643: BEGIN
1644:
1645: -- Standard Start of API savepoint
1646: SAVEPOINT UPDATE_SECTION_GRP;
1647:
1648: -- Standard call to check for call compatibility.
1649: IF NOT FND_API.Compatible_API_Call(l_api_version,
1644:
1645: -- Standard Start of API savepoint
1646: SAVEPOINT UPDATE_SECTION_GRP;
1647:
1648: -- Standard call to check for call compatibility.
1649: IF NOT FND_API.Compatible_API_Call(l_api_version,
1650: p_api_version,
1651: l_api_name,
1652: G_PKG_NAME)
1805:
1806: --
1807: -- End of main API body.
1808:
1809: -- Standard check of p_commit.
1810: IF (FND_API.To_Boolean(p_commit)) THEN
1811: COMMIT WORK;
1812: END IF;
1813:
1810: IF (FND_API.To_Boolean(p_commit)) THEN
1811: COMMIT WORK;
1812: END IF;
1813:
1814: -- Standard call to get message count and if count is 1, get message info.
1815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1816: p_data => x_msg_data,
1817: p_encoded => 'F');
1818:
1878: SELECT msite_id FROM jtf_msites_b
1879: WHERE msite_root_section_id = l_c_section_id;
1880:
1881: BEGIN
1882: -- Standard Start of API savepoint
1883: SAVEPOINT DELETE_SECTION_GRP;
1884:
1885: -- Standard call to check for call compatibility.
1886: IF NOT FND_API.Compatible_API_Call(l_api_version,
1881: BEGIN
1882: -- Standard Start of API savepoint
1883: SAVEPOINT DELETE_SECTION_GRP;
1884:
1885: -- Standard call to check for call compatibility.
1886: IF NOT FND_API.Compatible_API_Call(l_api_version,
1887: p_api_version,
1888: l_api_name,
1889: G_PKG_NAME)
2066: l_msg_data VARCHAR2(2000);
2067:
2068: BEGIN
2069:
2070: -- Standard Start of API savepoint
2071: SAVEPOINT UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2072:
2073: -- Standard call to check for call compatibility.
2074: IF NOT FND_API.Compatible_API_Call(l_api_version,
2069:
2070: -- Standard Start of API savepoint
2071: SAVEPOINT UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2072:
2073: -- Standard call to check for call compatibility.
2074: IF NOT FND_API.Compatible_API_Call(l_api_version,
2075: p_api_version,
2076: l_api_name,
2077: G_PKG_NAME)
2100:
2101: --
2102: -- End of main API body.
2103:
2104: -- Standard check of p_commit.
2105: IF (FND_API.To_Boolean(p_commit)) THEN
2106: COMMIT WORK;
2107: END IF;
2108:
2105: IF (FND_API.To_Boolean(p_commit)) THEN
2106: COMMIT WORK;
2107: END IF;
2108:
2109: -- Standard call to get message count and if count is 1, get message info.
2110: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2111: p_data => x_msg_data,
2112: p_encoded => 'F');
2113:
2160: l_msg_data VARCHAR2(2000);
2161:
2162: BEGIN
2163:
2164: -- Standard Start of API savepoint
2165: SAVEPOINT UPDATE_DELIVERABLE_TO_NULL_GRP;
2166:
2167: -- Standard call to check for call compatibility.
2168: IF NOT FND_API.Compatible_API_Call(l_api_version,
2163:
2164: -- Standard Start of API savepoint
2165: SAVEPOINT UPDATE_DELIVERABLE_TO_NULL_GRP;
2166:
2167: -- Standard call to check for call compatibility.
2168: IF NOT FND_API.Compatible_API_Call(l_api_version,
2169: p_api_version,
2170: l_api_name,
2171: G_PKG_NAME)
2194:
2195: --
2196: -- End of main API body.
2197:
2198: -- Standard check of p_commit.
2199: IF (FND_API.To_Boolean(p_commit)) THEN
2200: COMMIT WORK;
2201: END IF;
2202:
2199: IF (FND_API.To_Boolean(p_commit)) THEN
2200: COMMIT WORK;
2201: END IF;
2202:
2203: -- Standard call to get message count and if count is 1, get message info.
2204: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2205: p_data => x_msg_data,
2206: p_encoded => 'F');
2207: