DBA Data[Home] [Help]

APPS.AK_ON_OBJECTS_PVT SQL Statements

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

Line: 221

  select application_id
  from   fnd_application_vl
  where  application_short_name = short_name_param;
Line: 256

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

      select userenv('LANG') into l_nls_language
      from dual;
Line: 309

  select value into l_dbname from v$parameter
  where name = 'db_name';
Line: 343

  l_header_tbl(l_index) := '# dbdrv: '||'&'||'fullpath_~PROD_~PATH_~FILE NCUPDATE '||'&'||'env=NLS_LANG';
Line: 474

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 478

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 480

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 551

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 555

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 557

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 649

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 653

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 655

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 709

  l_header_tbl(l_index) := '      BASE LAST_UPDATED_BY NUMBER(15)';
Line: 713

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_DATE DATE';
Line: 715

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 755

  l_header_tbl(l_index) := '      BASE LAST_UPDATED_BY NUMBER(15)';
Line: 759

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_DATE DATE';
Line: 761

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 812

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 816

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 818

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 864

  l_header_tbl(l_index) := '      BASE LAST_UPDATED_BY NUMBER(15)';
Line: 868

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_DATE DATE';
Line: 870

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 922

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 926

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 928

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 982

  l_header_tbl(l_index) := '      BASE LAST_UPDATED_BY NUMBER(15)';
Line: 986

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_DATE DATE';
Line: 988

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1100

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1104

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 1106

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1142

  l_header_tbl(l_index) := '    BASE UPDATE_FLAG VARCHAR2(1)';
Line: 1280

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1284

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1286

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1314

  l_header_tbl(l_index) := '        BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1318

  l_header_tbl(l_index) := '        BASE LAST_UPDATE_DATE DATE';
Line: 1320

  l_header_tbl(l_index) := '        BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1338

  l_header_tbl(l_index) := '        BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1342

  l_header_tbl(l_index) := '        BASE LAST_UPDATE_DATE DATE';
Line: 1344

  l_header_tbl(l_index) := '        BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1364

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1368

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1370

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1388

  l_header_tbl(l_index) := '      BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1392

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_DATE DATE';
Line: 1394

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1447

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1451

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 1453

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1475

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1479

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1481

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1507

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1511

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1513

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1545

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1549

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1551

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1606

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1610

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 1612

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1664

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1668

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1670

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1730

  l_header_tbl(l_index) := '      BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1734

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_DATE DATE';
Line: 1736

  l_header_tbl(l_index) := '      BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1784

  l_header_tbl(l_index) := '        BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1788

  l_header_tbl(l_index) := '        BASE LAST_UPDATE_DATE DATE';
Line: 1790

  l_header_tbl(l_index) := '        BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1850

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1854

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1856

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1881

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1885

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 1887

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1906

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1910

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 1912

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1933

  l_header_tbl(l_index) := '  BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1937

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_DATE DATE';
Line: 1939

  l_header_tbl(l_index) := '  BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 1957

  l_header_tbl(l_index) := '    BASE LAST_UPDATED_BY NUMBER(15)';
Line: 1961

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_DATE DATE';
Line: 1963

  l_header_tbl(l_index) := '    BASE LAST_UPDATE_LOGIN NUMBER(15)';
Line: 2107

    select count(*) into G_UPL_TABLE_NUM
	from AK_LOADER_TEMP;
Line: 2131

  OPEN l_upl_loader_cur	FOR SELECT TBL_INDEX,LINE_CONTENT FROM ak_loader_temp
  where session_id = AK_ON_OBJECTS_PVT.G_SESSION_ID
  order by tbl_index;
Line: 3073

  p_last_updated_by          OUT NOCOPY     NUMBER,
  p_last_update_date         OUT NOCOPY     DATE,
  p_last_update_login        OUT NOCOPY     NUMBER
) is
  l_api_name           CONSTANT varchar2(30) := 'Set_Who';
Line: 3098

       if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
	     AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
Line: 3100

       elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
          if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
             FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
Line: 3109

       p_last_updated_by := 1;
Line: 3110

       p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
Line: 3111

       p_last_update_login := 1;
Line: 3117

    	p_last_updated_by := 2;
Line: 3118

    	p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
Line: 3119

    	p_last_update_login := 1;
Line: 3125

    p_last_updated_by := to_number(nvl(fnd_profile.value('USER_ID'),0));
Line: 3126

    p_last_update_date := sysdate;
Line: 3127

    p_last_update_login := to_number(
	nvl(fnd_profile.value('LOGIN_ID'),0));
Line: 3190

function IS_UPDATEABLE (
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_created_by               IN OUT NOCOPY	NUMBER,
  p_creation_date            IN OUT NOCOPY	DATE,
  p_last_updated_by          IN OUT NOCOPY	NUMBER,
  p_db_last_updated_by	     IN 	NUMBER,
  p_last_update_date         IN OUT NOCOPY 	DATE,
  p_db_last_update_date      IN         DATE,
  p_last_update_login        IN	OUT NOCOPY	NUMBER,
  p_create_or_update	     IN         VARCHAR2)
return boolean is
  l_return_status varchar2(1);
Line: 3205

  l_last_update_date       date;
Line: 3206

  l_last_update_login      number;
Line: 3207

  l_last_updated_by        number;
Line: 3212

  if (AK_UPLOAD_GRP.G_UPDATE_MODE or p_create_or_update = 'FORCE') then
	l_custom_mode := 'FORCE';
Line: 3214

  elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
        l_custom_mode := 'NCUPDATE';
Line: 3221

     (p_create_or_update = 'UPDATE' or p_create_or_update = 'FORCE')) then
  	if FND_LOAD_UTIL.UPLOAD_TEST (
		p_file_id => p_last_updated_by,
		p_file_lud => p_last_update_date,
		p_db_id => p_db_last_updated_by,
	        p_db_lud => p_db_last_update_date,
                p_custom_mode => l_custom_mode)
        then
		return TRUE;
Line: 3236

     if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
        if (p_db_last_updated_by <> 1 and p_db_last_updated_by <> 2) then
           return FALSE;
Line: 3241

     AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
Line: 3247

       	p_last_updated_by => l_last_updated_by,
       	p_last_update_date => l_last_update_date,
       	p_last_update_login => l_last_update_login);
Line: 3253

        l_last_updated_by := p_last_updated_by;
Line: 3254

        l_last_update_login := p_last_update_login;
Line: 3259

     p_last_updated_by := l_last_updated_by;
Line: 3260

     p_last_update_date := l_last_update_date;
Line: 3261

     p_last_update_login := l_last_update_login;
Line: 3263

     if p_create_or_update = 'CREATE' then
  	return TRUE;
Line: 3266

       ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
        (l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
        l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) and
        (p_db_last_updated_by = 1 or p_last_update_date > p_db_last_update_date))  or
        (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
              ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
                l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) and
            p_db_last_updated_by = 1)  or
            AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE)
        THEN
           return TRUE;
Line: 3292

end IS_UPDATEABLE;
Line: 3544

	insert_err  EXCEPTION;
Line: 3549

	INSERT INTO ak_loader_temp (
		tbl_index,
		line_content,
		session_id
		) values (
		G_TBL_INDEX,
		p_buffer,
		AK_ON_OBJECTS_PVT.G_SESSION_ID
		);
Line: 3561

	raise insert_err;
Line: 3564

	raise insert_err;
Line: 3570

	WHEN insert_err THEN
	--	dbms_output.put_line('Exception insert_err ak_loader_temp');
Line: 3581

	--	dbms_output.put_line('Other errors in inserting into ak_loader_temp');
Line: 3617

    select 1
    from  FND_APPLICATION
    where application_id = p_application_id;
Line: 3688

    select 1
    from  AK_LOOKUP_CODES
    where lookup_type = lookup_type_parm
    and   lookup_code = lookup_code_parm;