APPS.CSC_CORE_UTILS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

FUNCTION G_UPDATE RETURN VARCHAR2 IS
BEGIN
   RETURN L_UPDATE;

Line: 198

	  -- 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 );

Line: 242

      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');

Line: 436

        select 1 into l_temp_id from fnd_application
	where application_id=p_application_id;

Line: 475

  select name
  from cs_counters
  where counter_id = p_counter_id;

Line: 517

    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));

Line: 574

   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));

Line: 613

   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));

Line: 764

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');

Line: 934

( 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);

Line: 951

   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;

Line: 960

     l_sql_stmnt := 'SELECT '||p_select_clause||' FROM '||p_from_clause;