DBA Data[Home] [Help]

APPS.AHL_MC_RULE_PVT dependencies on STANDARD

Line 59: -- Standard start of API savepoint

55: l_api_name CONSTANT VARCHAR2(30) := 'Load_Rule';
56: l_rule_stmt_id NUMBER;
57: --
58: BEGIN
59: -- Standard start of API savepoint
60: SAVEPOINT Load_Rule_pvt;
61:
62: -- Initialize Procedure return status to success
63: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 64: -- Standard call to check for call compatibility

60: SAVEPOINT Load_Rule_pvt;
61:
62: -- Initialize Procedure return status to success
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
66: G_PKG_NAME) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;

Line 97: -- Standard call to get message count and if count is 1, get message info

93: FOR i IN x_rule_stmt_tbl.FIRST..x_rule_stmt_tbl.LAST LOOP
94: x_rule_stmt_tbl(i).sequence_num := i*10;
95: END LOOP;
96:
97: -- Standard call to get message count and if count is 1, get message info
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count,
100: p_data => x_msg_data,
101: p_encoded => fnd_api.g_false

Line 718: -- Standard start of API savepoint

714: l_row_id VARCHAR2(30);
715: --
716: BEGIN
717:
718: -- Standard start of API savepoint
719: SAVEPOINT Insert_Rule_pvt;
720: -- Initialize Procedure return status to success
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: -- Standard call to check for call compatibility

Line 722: -- Standard call to check for call compatibility

718: -- Standard start of API savepoint
719: SAVEPOINT Insert_Rule_pvt;
720: -- Initialize Procedure return status to success
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: -- Standard call to check for call compatibility
723: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
724: G_PKG_NAME) THEN
725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
726: END IF;

Line 933: -- Standard check of p_commit

929: SET config_status_code = 'DRAFT'
930: WHERE mc_header_id = p_x_rule_rec.mc_header_id;
931: END IF;
932:
933: -- Standard check of p_commit
934: IF FND_API.TO_BOOLEAN(p_commit) THEN
935: COMMIT WORK;
936: END IF;
937:

Line 938: -- Standard call to get message count and if count is 1, get message info

934: IF FND_API.TO_BOOLEAN(p_commit) THEN
935: COMMIT WORK;
936: END IF;
937:
938: -- Standard call to get message count and if count is 1, get message info
939: FND_MSG_PUB.Count_And_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,
942: p_encoded => fnd_api.g_false

Line 1040: -- Standard start of API savepoint

1036: l_rule_stmt_id NUMBER;
1037: l_match_flag BOOLEAN;
1038: --
1039: BEGIN
1040: -- Standard start of API savepoint
1041: SAVEPOINT Update_Rule_pvt;
1042: -- Initialize Procedure return status to success
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: -- Standard call to check for call compatibility

Line 1044: -- Standard call to check for call compatibility

1040: -- Standard start of API savepoint
1041: SAVEPOINT Update_Rule_pvt;
1042: -- Initialize Procedure return status to success
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: -- Standard call to check for call compatibility
1045: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1046: G_PKG_NAME) THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;

Line 1346: -- Standard check of p_commit

1342: SET config_status_code = 'DRAFT'
1343: WHERE mc_header_id = l_rule_rec.mc_header_id;
1344: END IF;
1345:
1346: -- Standard check of p_commit
1347: IF FND_API.TO_BOOLEAN(p_commit) THEN
1348: COMMIT WORK;
1349: END IF;
1350:

Line 1351: -- Standard call to get message count and if count is 1, get message info

1347: IF FND_API.TO_BOOLEAN(p_commit) THEN
1348: COMMIT WORK;
1349: END IF;
1350:
1351: -- Standard call to get message count and if count is 1, get message info
1352: FND_MSG_PUB.Count_And_Get
1353: ( p_count => x_msg_count,
1354: p_data => x_msg_data,
1355: p_encoded => fnd_api.g_false

Line 1426: -- Standard start of API savepoint

1422: l_status_code VARCHAR2(30);
1423: l_status VARCHAR2(80);
1424: --
1425: BEGIN
1426: -- Standard start of API savepoint
1427: SAVEPOINT Delete_Rule_pvt;
1428: -- Initialize Procedure return status to success
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430: -- Standard call to check for call compatibility

Line 1430: -- Standard call to check for call compatibility

1426: -- Standard start of API savepoint
1427: SAVEPOINT Delete_Rule_pvt;
1428: -- Initialize Procedure return status to success
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430: -- Standard call to check for call compatibility
1431: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1432: G_PKG_NAME) THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END IF;

Line 1497: -- Standard check of p_commit

1493: SET config_status_code = 'DRAFT'
1494: WHERE mc_header_id = l_mc_header_id;
1495: END IF;
1496:
1497: -- Standard check of p_commit
1498: IF FND_API.TO_BOOLEAN(p_commit) THEN
1499: COMMIT WORK;
1500: END IF;
1501: -- Standard call to get message count and if count is 1, get message info

Line 1501: -- Standard call to get message count and if count is 1, get message info

1497: -- Standard check of p_commit
1498: IF FND_API.TO_BOOLEAN(p_commit) THEN
1499: COMMIT WORK;
1500: END IF;
1501: -- Standard call to get message count and if count is 1, get message info
1502: FND_MSG_PUB.Count_And_Get
1503: ( p_count => x_msg_count,
1504: p_data => x_msg_data,
1505: p_encoded => fnd_api.g_false

Line 1577: -- Standard start of API savepoint

1573: l_stmt_id NUMBER;
1574: l_new_stmt_id NUMBER;
1575: --
1576: BEGIN
1577: -- Standard start of API savepoint
1578: SAVEPOINT Copy_Rules_For_Mc_pvt;
1579:
1580: -- Initialize Procedure return status to success
1581: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1582: -- Standard call to check for call compatibility

1578: SAVEPOINT Copy_Rules_For_Mc_pvt;
1579:
1580: -- Initialize Procedure return status to success
1581: x_return_status := FND_API.G_RET_STS_SUCCESS;
1582: -- Standard call to check for call compatibility
1583: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1584: G_PKG_NAME) THEN
1585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1586: END IF;

Line 1679: -- Standard check of p_commit

1675: END IF;
1676: END LOOP;
1677: CLOSE get_rule_rec_csr;
1678:
1679: -- Standard check of p_commit
1680: IF FND_API.TO_BOOLEAN(p_commit) THEN
1681: COMMIT WORK;
1682: END IF;
1683: -- Standard call to get message count and if count is 1, get message info

Line 1683: -- Standard call to get message count and if count is 1, get message info

1679: -- Standard check of p_commit
1680: IF FND_API.TO_BOOLEAN(p_commit) THEN
1681: COMMIT WORK;
1682: END IF;
1683: -- Standard call to get message count and if count is 1, get message info
1684: FND_MSG_PUB.Count_And_Get
1685: ( p_count => x_msg_count,
1686: p_data => x_msg_data,
1687: p_encoded => fnd_api.g_false

Line 1747: -- Standard start of API savepoint

1743: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rules_For_Mc';
1744: l_rule_rec RULE_REC_TYPE;
1745: --
1746: BEGIN
1747: -- Standard start of API savepoint
1748: SAVEPOINT Delete_Rules_For_Mc_pvt;
1749:
1750: -- Initialize Procedure return status to success
1751: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1752: -- Standard call to check for call compatibility

1748: SAVEPOINT Delete_Rules_For_Mc_pvt;
1749:
1750: -- Initialize Procedure return status to success
1751: x_return_status := FND_API.G_RET_STS_SUCCESS;
1752: -- Standard call to check for call compatibility
1753: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1754: G_PKG_NAME) THEN
1755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1756: END IF;

Line 1787: -- Standard check of p_commit

1783: END IF;
1784: END LOOP;
1785: CLOSE get_rule_ids_csr;
1786:
1787: -- Standard check of p_commit
1788: IF FND_API.TO_BOOLEAN(p_commit) THEN
1789: COMMIT WORK;
1790: END IF;
1791: -- Standard call to get message count and if count is 1, get message info

Line 1791: -- Standard call to get message count and if count is 1, get message info

1787: -- Standard check of p_commit
1788: IF FND_API.TO_BOOLEAN(p_commit) THEN
1789: COMMIT WORK;
1790: END IF;
1791: -- Standard call to get message count and if count is 1, get message info
1792: FND_MSG_PUB.Count_And_Get
1793: ( p_count => x_msg_count,
1794: p_data => x_msg_data,
1795: p_encoded => fnd_api.g_false

Line 1905: -- Standard start of API savepoint

1901: l_index NUMBER;
1902: l_rule_rec RULE_REC_TYPE;
1903: --
1904: BEGIN
1905: -- Standard start of API savepoint
1906: SAVEPOINT Get_Rules_For_Position_pvt;
1907:
1908: -- Initialize Procedure return status to success
1909: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1910: -- Standard call to check for call compatibility

1906: SAVEPOINT Get_Rules_For_Position_pvt;
1907:
1908: -- Initialize Procedure return status to success
1909: x_return_status := FND_API.G_RET_STS_SUCCESS;
1910: -- Standard call to check for call compatibility
1911: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1912: G_PKG_NAME) THEN
1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1914: END IF;

Line 1962: -- Standard call to get message count and if count is 1, get message info

1958: l_index := l_index +1;
1959: END LOOP;
1960: CLOSE get_rule_vo_csr;
1961:
1962: -- Standard call to get message count and if count is 1, get message info
1963: FND_MSG_PUB.Count_And_Get
1964: ( p_count => x_msg_count,
1965: p_data => x_msg_data,
1966: p_encoded => fnd_api.g_false