APPS.BSC_MO_DB_PKG SQL Statements

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

Line: 25

TYPE rec_update_tables is record(
table_name varchar2(100),
property varchar2(100));

Line: 28

TYPE tab_update_tables is TABLE of rec_update_tables INDEX BY PLS_INTEGER;

Line: 29

g_update_tables tab_update_tables;

Line: 51

PROCEDURE InsertDDL(pObjectName IN VARCHAR2,
                    pObjectDDL  IN VARCHAR2,
                    pObjectType IN VARCHAR2) IS
l_stmt VARCHAR2 (1000) := 'INSERT INTO '||g_ddl_table_name ||
			' (bucket_id, object_name, object_ddl, object_type) VALUES (:1, :2, :3, :4)';

Line: 73

    BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in InsertDDL:'||l_error);

Line: 90

SELECT value_v, value_n order_index FROM BSC_TMP_BIG_IN_COND
WHERE variable_id=10
  AND session_id=USERENV('SESSIONID')
ORDER BY value_v;

Line: 101

  DELETE BSC_TMP_BIG_IN_COND WHERE variable_id = 10 AND session_id=USERENV('SESSIONID');

Line: 102

  l_ins := 'INSERT INTO BSC_TMP_BIG_IN_COND(variable_id, value_v, value_n, session_id) values (:1, :2, :3, :4)';

Line: 122

SELECT DATA_TYPE, DATA_LENGTH
  FROM USER_TAB_COLUMNS
 WHERE TABLE_NAME = dimTable
   AND COLUMN_NAME = columnName;

Line: 128

SELECT DATA_TYPE, DATA_LENGTH
  FROM ALL_TAB_COLUMNS
 WHERE TABLE_NAME = dimTable
   AND COLUMN_NAME = columnName
   AND OWNER = BSC_METADATA_OPTIMIZER_PKG.gBSCSchema;

Line: 304

    insertDDL(p_object_name, p_ddl, p_object_type);

Line: 385

PROCEDURE add_to_update_tables_list(p_Table_name VARCHAR2, p_property VARCHAR2, p_value VARCHAR2) IS
  l_update_rec rec_update_tables;

Line: 388

  l_update_rec.table_name := p_table_name;

Line: 389

  l_update_rec.property := p_property||BSC_DBGEN_STD_METADATA.BSC_ASSIGNMENT||p_value;

Line: 390

  g_update_tables(g_update_tables.count+1) := l_update_rec;

Line: 392

    BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in add_to_update_tables_list, Table='||p_table_name|| ', property='||
          p_property||', value='||p_value||', error:'||sqlerrm);

Line: 457

      add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_PARTITION,
                                bsc_metadata_optimizer_pkg.g_num_partitions);

Line: 463

    add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE, l_table_name);

Line: 496

      add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE, l_table_name);

Line: 524

SELECT INDEX_NAME FROM ALL_INDEXES
WHERE INDEX_NAME = upper(IndexName)
AND OWNER = pSchema;

Line: 707

    SELECT INDEX_NAME FROM ALL_INDEXES WHERE TABLE_NAME= p_table and table_owner=p_owner;

Line: 717

            l_stmt := 'UPDATE ' || BaseTable.Name||' SET PERIODICITY_ID =:1 ';

Line: 775

        l_stmt := 'UPDATE ' || l_prj_table||' SET PERIODICITY_ID =:1 ';

Line: 855

    SELECT SUBPERIOD_COL_NAME
    FROM BSC_SYS_PERIODICITIES
    WHERE PERIODICITY_ID = Periodicity;

Line: 893

    SELECT PERIOD_COL_NAME
    FROM BSC_SYS_PERIODICITIES
    WHERE PERIODICITY_ID = Periodicity;

Line: 940

    SELECT DATA_LENGTH FROM ALL_TAB_COLUMNS
    WHERE UPPER(TABLE_NAME)= p1
    AND UPPER(COLUMN_NAME) = 'USER_CODE'
    AND UPPER(OWNER) = BSC_METADATA_OPTIMIZER_PKG.gBSCSchema;

Line: 985

    SELECT periodicity_type
    FROM bsc_sys_periodicities
    where calendar_id = pCalendar
    and periodicity_id = pPeriodicity;

Line: 1107

    IF p_table.data(i).changeType='NEW' THEN -- new column, insert into db_tables_cols
      --alter all tables in l_origin_tables as they need this new column, eg, T, B and I tables if p_table is a T table
      bsc_mo_helper_pkg.writeTmp('Measure '||p_table.data(i).fieldName||' needs to be added ', FND_LOG.LEVEL_STATEMENT, false);

Line: 1210

    colCampos.delete;

Line: 1265

    colCampos.delete;

Line: 1365

    select max_processes into g_max_buckets from fnd_concurrent_queues where concurrent_queue_name='STANDARD' and application_id=0;

Line: 1457

  bsc_mo_helper_pkg.writeTmp('updating properties in bsc_db_tables, count='||g_update_tables.count);

Line: 1458

  FOR i IN 1..g_update_tables.count LOOP
    l_varchar_table1(i) := g_update_tables(i).table_name;

Line: 1460

    l_varchar_table2(i) := g_update_tables(i).property;

Line: 1464

  FORALL i IN 1..g_update_tables.count
    UPDATE BSC_DB_TABLES
       SET PROPERTIES=PROPERTIES||l_varchar_table2(i)||BSC_DBGEN_STD_METADATA.BSC_PROPERTY_SEPARATOR
     WHERE table_name = l_varchar_table1(i);

Line: 1490

    l_stmt:='select id,job_id,status,message from '||p_job_status_table;

Line: 1492

    l_stmt:='select id,job_id,status,message from '||p_job_status_table||' where object_name=:1';

Line: 1598

l_stmt VARCHAR2(100) := ' SELECT object_name, object_ddl, object_type FROM '|| g_ddl_table_name||' WHERE bucket_id = :1';

Line: 1625

	    execute immediate 'UPDATE  '||g_ddl_table_name||' set status = :1 where bucket_id = :2 and object_name = :3'
		using 'ERROR', pStripe, l_object_name;

Line: 1640

  l_stmt:='select 1, failures from all_jobs where job=:1';

Line: 1767

select value from v$parameter param
where param.name = pParam;

Line: 1830

        execute immediate 'INSERT INTO '||g_ddl_table_name||'(bucket_id, object_name, object_ddl, object_type)
        VALUES (:1, :2, :3, :4)'
        USING g_ddl_bucket_id(i), g_ddl_object(i), g_ddl_object_ddl(i), g_ddl_object_type(i);