The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure Update_ScoreCard (
p_api_version IN NUMBER := 2.0,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
:= G_MISS_SCORECARD_REC)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_ScoreCard';
SAVEPOINT UPDATE_SCORECARD_PUB;
'Public API: Calling AS_SALES_LEADS_PVT.Update_sales_lead');
AS_SCORECARD_RULES_PVT.Update_ScoreCard(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_validation_level => p_validation_level
, p_scorecard_rec => p_scorecard_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END Update_ScoreCard;
Procedure Delete_ScoreCard (
p_api_version IN NUMBER := 2.0,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_SCORECARD_ID IN NUMBER)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_ScoreCard';
SAVEPOINT DELETE_SCORECARD_PUB;
'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_SCORECARD');
AS_SCORECARD_RULES_PVT.Delete_ScoreCard(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_validation_level => p_validation_level
, p_scorecard_id => l_scorecard_id
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
END Delete_ScoreCard;
Procedure Update_CardRule_QUAL (
p_api_version IN NUMBER := 2.0,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_CARDRULE_QUAL';
SAVEPOINT UPDATE_CARDRULE_QUAL_PUB;
'Public API: Calling AS_SCORECARD_RULES_PVT.Update_CardRule_Qual');
AS_SCORECARD_RULES_PVT.Update_CardRule_Qual(
p_api_version => p_api_version
, p_init_msg_list => FND_API.G_FALSE
, p_commit => p_commit
, p_validation_level => p_validation_level
, p_cardrule_qual_rec => p_cardrule_qual_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END Update_CardRule_Qual;
Procedure Delete_CardRule_QUAL (
p_api_version IN NUMBER := 2.0,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qual_value_id IN NUMBER)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_CARDRULE_QUAL';
SAVEPOINT DELETE_CARD_RULE_PUB;
'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual');
AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual(
p_api_version => p_api_version
, p_init_msg_list => FND_API.G_FALSE
, p_commit => p_commit
, p_validation_level => p_validation_level
, p_qual_value_id => p_qual_value_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END Delete_CardRule_Qual;