The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION G_UPDATE RETURN VARCHAR2 IS
BEGIN
RETURN L_UPDATE;
-- Insert the 'sqlerrm' into the message stack.
FND_MSG_PUB.BUILD_EXC_MSG (
p_pkg_name => p_pkg_name,
p_procedure_name => p_api_name );
if ( P_Validation_Mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
if ( p_start_date < sysdate ) then
FND_MESSAGE.SET_NAME (G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
select 1 into l_temp_id from fnd_application
where application_id=p_application_id;
select name
from cs_counters
where counter_id = p_counter_id;
select null
from fnd_currencies
where currency_code = p_currency_code
and trunc(p_effective_date) between trunc(nvl(start_date_active, p_effective_date))
and trunc(nvl(end_date_active, p_effective_date));
select null
from fnd_lookups
where lookup_code = p_lookup_code
and lookup_type = p_lookup_type
and enabled_flag = 'Y'
and trunc(p_effective_date) between
trunc(nvl(start_date_active, p_effective_date))
and trunc(nvl(end_date_active, p_effective_date));
select null
from CSC_LOOKUPS
where lookup_code = p_lookup_code
and lookup_type = p_lookup_type
and enabled_flag = 'Y'
and trunc(p_effective_date) between
trunc(nvl(start_date_active, p_effective_date))
and trunc(nvl(end_date_active, p_effective_date));
PROCEDURE Cannot_Update_Param_Msg
( p_api_name VARCHAR2,
p_argument VARCHAR2,
p_argument_value VARCHAR2
)
IS
BEGIN
IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
--** check the message name
FND_MESSAGE.Set_Name('CS', 'CS_API_CHG_CANT_UPD_PARAM');
( p_select_clause IN VARCHAR2,
p_from_clause IN VARCHAR2,
p_where_clause IN VARCHAR2,
p_other_clause IN VARCHAR2,
x_sql_Stmnt OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2 )
IS
l_sql_stmnt VARCHAR2(2000);
IF ((( p_Select_Clause IS NULL ) and
( p_Select_Clause = FND_API.G_MISS_CHAR ))
and (( p_from_Clause IS NULL ) and
( p_from_Clause = FND_API.G_MISS_CHAR )))
THEN
-- invalid arguments exception
x_return_status := FND_API.G_RET_STS_ERROR;
l_sql_stmnt := 'SELECT '||p_select_clause||' FROM '||p_from_clause;