DBA Data[Home] [Help]

APPS.AK_QUERYOBJ_PVT SQL Statements

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

Line: 37

    select *
    from AK_QUERY_OBJECT_LINES
    where query_code = param_query_code
    order by seq_num;
Line: 104

                FND_LOAD_UTIL.OWNER_NAME(l_queryobj_lines_rec.last_updated_by) || '"';
Line: 106

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(l_queryobj_lines_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
Line: 110

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = ' ||
                nvl(to_char(l_queryobj_lines_rec.last_update_login),'""');
Line: 131

	  l_databuffer_tbl.delete;
Line: 222

    select *
    from AK_QUERY_OBJECTS
    where query_code = p_query_code;
Line: 270

                FND_LOAD_UTIL.OWNER_NAME(l_queryobj_rec.last_updated_by) || '"';
Line: 272

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(l_queryobj_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
Line: 276

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = ' ||
                nvl(to_char(l_queryobj_rec.last_update_login),'""');
Line: 294

  l_databuffer_tbl.delete;
Line: 399

    select query_code
    from AK_QUERY_OBJECTS
    where APPLICATION_ID = appl_id_parm;
Line: 428

        FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
Line: 533

	select *
	from ak_query_object_lines
	where query_code = param_query_code
	and seq_num = param_seq_num;
Line: 581

	select 1
	from ak_query_objects
	where query_code = param_query_code
	and application_id = param_application_id;
Line: 637

	select 1
	from ak_query_object_lines
	where query_code = param_query_code
	and seq_num = param_seq_num;
Line: 710

  p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
	p_loader_timestamp      IN      DATE := FND_API.G_MISS_DATE,
	p_pass					IN		NUMBER := 2
) IS
	l_api_version_number	CONSTANT number := 1.0;
Line: 721

	l_last_update_date        date;
Line: 722

	l_last_update_login       number;
Line: 723

	l_last_updated_by         number;
Line: 762

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 766

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 770

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 780

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;
Line: 793

  insert into AK_QUERY_OBJECTS (
	QUERY_CODE,
	APPLICATION_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
	p_query_code,
	p_application_id,
	l_creation_date,
	l_created_by,
	l_last_update_date,
	l_last_updated_by,
	l_last_update_login);
Line: 897

  p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
	p_loader_timestamp      IN      DATE := FND_API.G_MISS_DATE,
	p_pass					IN		NUMBER := 2
) IS
	l_api_name	constant	varchar2(30) := 'CREATE_QUERY_OBJECT_LINE';
Line: 908

	l_last_update_date        date;
Line: 909

	l_last_update_login       number;
Line: 910

	l_last_updated_by         number;
Line: 949

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 953

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 957

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 967

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;
Line: 980

  insert into AK_QUERY_OBJECT_LINES (
	QUERY_CODE,
	SEQ_NUM,
	QUERY_LINE_TYPE,
	QUERY_LINE,
	LINKED_PARAMETER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
	p_query_code,
	p_seq_num,
	p_query_line_type,
	p_query_line,
	p_linked_parameter,
	l_creation_date,
	l_created_by,
	l_last_update_date,
	l_last_updated_by,
	l_last_update_login);
Line: 1076

PROCEDURE UPDATE_QUERY_OBJECT(
    p_validation_level		IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_api_version_number	IN		NUMBER,
	p_init_msg_tbl			IN      BOOLEAN := FALSE,
    p_msg_count				OUT NOCOPY		NUMBER,
    p_msg_data				OUT NOCOPY		VARCHAR2,
    p_return_status			OUT NOCOPY		VARCHAR2,
    p_query_code			IN		VARCHAR2,
    p_application_id		IN		NUMBER,
  p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
  p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
	p_loader_timestamp      IN      DATE := FND_API.G_MISS_DATE,
	p_pass					IN		NUMBER := 2
) IS
  cursor l_get_query_csr is
    select *
    from  AK_QUERY_OBJECTS
    where QUERY_CODE = p_query_code
    for update of APPLICATION_ID;
Line: 1099

  l_api_name                CONSTANT varchar2(30) := 'Update_Query_Object';
Line: 1103

  l_last_update_date        date;
Line: 1104

  l_last_update_login       number;
Line: 1105

  l_last_updated_by         number;
Line: 1121

  savepoint start_update_queryobj;
Line: 1157

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 1161

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 1165

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 1171

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_queryobj_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_queryobj_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then
     null;
Line: 1184

  update AK_QUERY_OBJECTS set
	application_id = l_queryobj_rec.application_id,
	LAST_UPDATE_DATE = l_last_update_date,
	LAST_UPDATED_BY = l_last_updated_by,
	LAST_UPDATE_LOGIN = l_last_update_login
  where query_code = p_query_code;
Line: 1193

      FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATE_FAILED');
Line: 1203

    FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_UPDATED');
Line: 1221

    rollback to start_update_queryobj;
Line: 1228

      FND_MESSAGE.SET_NAME('AK','AK_QUERYOBJ_NOT_UPDATED');
Line: 1233

    rollback to start_update_queryobj;
Line: 1239

    rollback to start_update_queryobj;
Line: 1250

END UPDATE_QUERY_OBJECT;
Line: 1252

PROCEDURE UPDATE_QUERY_OBJECT_LINE(
    p_validation_level		IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_api_version_number	IN		NUMBER,
	p_init_msg_tbl			IN      BOOLEAN := FALSE,
    p_msg_count				OUT NOCOPY		NUMBER,
    p_msg_data				OUT NOCOPY		VARCHAR2,
    p_return_status			OUT NOCOPY		VARCHAR2,
    p_query_code			IN		VARCHAR2,
    p_seq_num				IN		NUMBER,
	p_query_line_type 		IN		VARCHAR2 := FND_API.G_MISS_CHAR,
	p_query_line			IN		VARCHAR2 := FND_API.G_MISS_CHAR,
	p_linked_parameter		IN		VARCHAR2 := FND_API.G_MISS_CHAR,
  p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
  p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
	p_loader_timestamp      IN      DATE := FND_API.G_MISS_DATE,
	p_pass					IN		NUMBER := 2
) IS

  cursor l_get_query_line_csr is
    select *
    from  AK_QUERY_OBJECT_LINES
    where QUERY_CODE = p_query_code
	and	  seq_num = p_seq_num
    for update of QUERY_LINE;
Line: 1280

  l_api_name                CONSTANT varchar2(30) := 'Update_Query_Object_Line';
Line: 1284

  l_last_update_date        date;
Line: 1285

  l_last_update_login       number;
Line: 1286

  l_last_updated_by         number;
Line: 1302

  savepoint start_update_query_line;
Line: 1341

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 1345

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 1349

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 1355

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_line_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_line_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then
     null;
Line: 1368

  update AK_QUERY_OBJECT_LINES set
	query_line_type = l_line_rec.query_line_type,
	query_line = l_line_rec.query_line,
	linked_parameter = l_line_rec.linked_parameter,
	LAST_UPDATE_DATE = l_last_update_date,
	LAST_UPDATED_BY = l_last_updated_by,
	LAST_UPDATE_LOGIN = l_last_update_login
  where query_code = p_query_code
  and seq_num = p_seq_num;
Line: 1380

      FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATE_FAILED');
Line: 1390

    FND_MESSAGE.SET_NAME('AK','AK_LINE_UPDATED');
Line: 1408

    rollback to start_update_query_line;
Line: 1415

      FND_MESSAGE.SET_NAME('AK','AK_LINE_NOT_UPDATED');
Line: 1420

    rollback to start_update_query_line;
Line: 1426

    rollback to start_update_query_line;
Line: 1437

END UPDATE_QUERY_OBJECT_LINE;
Line: 1527

  l_update1				 DATE;
Line: 1528

  l_update2				 DATE;
Line: 1673

                        (l_token = 'LAST_UPDATED_BY') or
                        (l_token = 'OWNER') or
                        (l_token = 'LAST_UPDATE_DATE') or
                        (l_token = 'LAST_UPDATE_LOGIN') then
        l_column := l_token;
Line: 1735

      elsif (l_column = 'LAST_UPDATED_BY') then
         l_query_rec.last_updated_by := to_number(l_token);
Line: 1739

         l_query_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
Line: 1741

      elsif (l_column = 'LAST_UPDATE_DATE') then
         l_query_rec.last_update_date := to_date(l_token,
                                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
Line: 1745

      elsif (l_column = 'LAST_UPDATE_LOGIN') then
         l_query_rec.last_update_login := to_number(l_token);
Line: 1818

            (l_token = 'LAST_UPDATED_BY') or
            (l_token = 'OWNER') or
            (l_token = 'LAST_UPDATE_DATE') or
            (l_token = 'LAST_UPDATE_LOGIN') then
        l_column := l_token;
Line: 1885

      elsif (l_column = 'LAST_UPDATED_BY') then
         l_line_rec.last_updated_by := to_number(l_token);
Line: 1889

         l_line_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
Line: 1891

      elsif (l_column = 'LAST_UPDATE_DATE') then
         l_line_rec.last_update_date := to_date(l_token,
                                       AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
Line: 1895

      elsif (l_column = 'LAST_UPDATE_LOGIN') then
         l_line_rec.last_update_login := to_number(l_token);
Line: 1990

          if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
            AK_QUERYOBJ_PVT.UPDATE_QUERY_OBJECT (
              p_validation_level => p_validation_level,
              p_api_version_number => 1.0,
              p_msg_count => l_msg_count,
              p_msg_data => l_msg_data,
              p_return_status => l_return_status,
              p_query_code => l_query_tbl(l_index).query_code,
              p_application_id => l_query_tbl(l_index).application_id,
	p_created_by => l_query_tbl(l_index).created_by,
	p_creation_date => l_query_tbl(l_index).creation_date,
	p_last_updated_by => l_query_tbl(l_index).last_updated_by,
	p_last_update_date => l_query_tbl(l_index).last_update_date,
	p_last_update_login => l_query_tbl(l_index).last_update_login,
              p_loader_timestamp => p_loader_timestamp,
		      p_pass => p_pass
            );
Line: 2008

		  elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
			-- do not update customized data
			select aqo.last_updated_by, aqo.last_update_date
			into l_user_id1, l_update1
			from ak_query_objects aqo
			where aqo.query_code = l_query_tbl(l_index).query_code
			and aqo.application_id = l_query_tbl(l_index).application_id;
Line: 2016

                if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
                      p_loader_timestamp => p_loader_timestamp,
                      p_created_by => l_query_tbl(l_index).created_by,
                      p_creation_date => l_query_tbl(l_index).creation_date,
                      p_last_updated_by => l_query_tbl(l_index).last_updated_by,
                      p_db_last_updated_by => l_user_id1,
                      p_last_update_date => l_query_tbl(l_index).last_update_date,
                      p_db_last_update_date => l_update1,
                      p_last_update_login => l_query_tbl(l_index).last_update_login,
                      p_create_or_update => 'UPDATE') then

	            AK_QUERYOBJ_PVT.UPDATE_QUERY_OBJECT (
              p_validation_level => p_validation_level,
              p_api_version_number => 1.0,
              p_msg_count => l_msg_count,
              p_msg_data => l_msg_data,
              p_return_status => l_return_status,
              p_query_code => l_query_tbl(l_index).query_code,
              p_application_id => l_query_tbl(l_index).application_id,
        p_created_by => l_query_tbl(l_index).created_by,
        p_creation_date => l_query_tbl(l_index).creation_date,
        p_last_updated_by => l_query_tbl(l_index).last_updated_by,
        p_last_update_date => l_query_tbl(l_index).last_update_date,
        p_last_update_login => l_query_tbl(l_index).last_update_login,
              p_loader_timestamp => p_loader_timestamp,
		      p_pass => p_pass
	            );
Line: 2044

          end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
Line: 2056

        p_last_updated_by => l_query_tbl(l_index).last_updated_by,
        p_last_update_date => l_query_tbl(l_index).last_update_date,
        p_last_update_login => l_query_tbl(l_index).last_update_login,
            p_loader_timestamp => p_loader_timestamp,
		    p_pass => p_pass
          );
Line: 2099

          if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
            AK_QUERYOBJ_PVT.UPDATE_QUERY_OBJECT_LINE (
              p_validation_level => p_validation_level,
              p_api_version_number => 1.0,
              p_msg_count => l_msg_count,
              p_msg_data => l_msg_data,
              p_return_status => l_return_status,
              p_query_code => l_line_tbl(l_index).query_code,
              p_seq_num =>l_line_tbl(l_index).seq_num,
              p_query_line_type => l_line_tbl(l_index).query_line_type,
              p_query_line => l_line_tbl(l_index).query_line,
              p_linked_parameter => l_line_tbl(l_index).linked_parameter,
	p_created_by => l_line_tbl(l_index).created_by,
	p_creation_date => l_line_tbl(l_index).creation_date,
	p_last_updated_by => l_line_tbl(l_index).last_updated_by,
	p_last_update_date => l_line_tbl(l_index).last_update_date,
	p_last_update_login => l_line_tbl(l_index).last_update_login,
              p_loader_timestamp => p_loader_timestamp,
  		      p_pass => p_pass
            );
Line: 2119

		  -- update non-customized data only
		  elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
			select aqol.last_updated_by, aqol.last_update_date
			into l_user_id1, l_update1
			from ak_query_object_lines aqol
			where aqol.query_code = l_line_tbl(l_index).query_code
			and aqol.seq_num = l_line_tbl(l_index).seq_num;
Line: 2127

                if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
                      p_loader_timestamp => p_loader_timestamp,
                      p_created_by => l_line_tbl(l_index).created_by,
                      p_creation_date => l_line_tbl(l_index).creation_date,
                      p_last_updated_by => l_line_tbl(l_index).last_updated_by,
                      p_db_last_updated_by => l_user_id1,
                      p_last_update_date => l_line_tbl(l_index).last_update_date,
                      p_db_last_update_date => l_update1,
                      p_last_update_login => l_line_tbl(l_index).last_update_login,
                      p_create_or_update => 'UPDATE') then

	            AK_QUERYOBJ_PVT.UPDATE_QUERY_OBJECT_LINE (
	              p_validation_level => p_validation_level,
	              p_api_version_number => 1.0,
	              p_msg_count => l_msg_count,
	              p_msg_data => l_msg_data,
	              p_return_status => l_return_status,
	              p_query_code => l_line_tbl(l_index).query_code,
	              p_seq_num =>l_line_tbl(l_index).seq_num,
	              p_query_line_type => l_line_tbl(l_index).query_line_type,
	              p_query_line => l_line_tbl(l_index).query_line,
	              p_linked_parameter => l_line_tbl(l_index).linked_parameter,
        p_created_by => l_line_tbl(l_index).created_by,
        p_creation_date => l_line_tbl(l_index).creation_date,
        p_last_updated_by => l_line_tbl(l_index).last_updated_by,
        p_last_update_date => l_line_tbl(l_index).last_update_date,
        p_last_update_login => l_line_tbl(l_index).last_update_login,
	              p_loader_timestamp => p_loader_timestamp,
	  		      p_pass => p_pass
	            );
Line: 2158

          end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
Line: 2173

        p_last_updated_by => l_line_tbl(l_index).last_updated_by,
        p_last_update_date => l_line_tbl(l_index).last_update_date,
        p_last_update_login => l_line_tbl(l_index).last_update_login,
            p_loader_timestamp => p_loader_timestamp,
		    p_pass => p_pass
          );