DBA Data[Home] [Help]

APPS.AK_ON_OBJECTS_PVT SQL Statements

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

Line: 229

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  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: 3168

  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: 3193

       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: 3195

       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: 3204

       p_last_updated_by := 1;
Line: 3205

       p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
Line: 3206

       p_last_update_login := 1;
Line: 3212

    	p_last_updated_by := 2;
Line: 3213

    	p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
Line: 3214

    	p_last_update_login := 1;
Line: 3220

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

    p_last_update_date := sysdate;
Line: 3222

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

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: 3300

  l_last_update_date       date;
Line: 3301

  l_last_update_login      number;
Line: 3302

  l_last_updated_by        number;
Line: 3307

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

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

     (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: 3331

     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: 3336

     AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
Line: 3342

       	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: 3348

        l_last_updated_by := p_last_updated_by;
Line: 3349

        l_last_update_login := p_last_update_login;
Line: 3354

     p_last_updated_by := l_last_updated_by;
Line: 3355

     p_last_update_date := l_last_update_date;
Line: 3356

     p_last_update_login := l_last_update_login;
Line: 3358

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

       ((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: 3387

end IS_UPDATEABLE;
Line: 3639

	insert_err  EXCEPTION;
Line: 3644

	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: 3656

	raise insert_err;
Line: 3659

	raise insert_err;
Line: 3665

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

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

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

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