APPS.FII_PROJECT_M_C SQL Statements

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

Line: 19

  l_rows_inserted            Number:=0;

Line: 119

  l_rows_inserted    NUMBER := 0;

Line: 130

  Insert Into EDW_PROJ_TASK_LSTG
  (
    TASK_PK,
    TOP_TASK_FK,
    NAME,
    TASK,
    TASK_NUMBER,
    TASK_START_DATE,
    TASK_END_DATE,
    LABOR_COST_MULT,
    SERVICE_TYPE_CODE,
    DENORM_TASK_ORG_FK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    DELETION_DATE,
    OPERATION_CODE,
    COLLECTION_STATUS,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    EDW_RECORD_TYPE
  )
  select
    TASK_PK,
    NVL(TOP_TASK_FK, 'NA_EDW'),
    NAME,
    TASK,
    TASK_NUMBER,
    TASK_START_DATE,
    TASK_END_DATE,
    LABOR_COST_MULT,
    SERVICE_TYPE_CODE,
    NVL(DENORM_TASK_ORG_FK,'NA_EDW'),
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    to_date(NULL),
    NULL,
    'READY',
    SYSDATE,
    SYSDATE,
    'ORACLE'
  from
    FII_PROJ_TASK_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 183

  l_rows_inserted := sql%rowcount;

Line: 184

  g_row_count     := g_row_count + l_rows_inserted ;

Line: 209

  l_rows_inserted     NUMBER := 0;

Line: 220

  Insert Into EDW_PROJ_TOP_TASK_LSTG
  (
    TOP_TASK_PK,
    PROJECT_FK,
    NAME,
    TOP_TASK,
    TASK_NUMBER,
    TASK_START_DATE,
    TASK_END_DATE,
    LABOR_COST_MULT,
    SERVICE_TYPE_CODE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    DELETION_DATE,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    TOP_TASK_PK,
    NVL(PROJECT_FK, 'NA_EDW'),
    NAME,
    TOP_TASK,
    TASK_NUMBER,
    TASK_START_DATE,
    TASK_END_DATE,
    LABOR_COST_MULT,
    SERVICE_TYPE_CODE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    to_date(NULL),
    NULL,
    'READY'
  from
    FII_PROJ_TOP_TASK_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 265

  l_rows_inserted := sql%rowcount;

Line: 291

  l_rows_inserted    NUMBER := 0;

Line: 302

  Insert Into EDW_PROJ_PROJECT_LSTG
  (
    PROJECT_PK,
    PRJ_TYP_FK,
    PROJ_CLS1_FK,
    PROJ_CLS2_FK,
    PROJ_CLS3_FK,
    PROJ_CLS4_FK,
    PROJ_CLS5_FK,
    PROJ_CLS6_FK,
    PROJ_CLS7_FK,
    NAME,
    PROJECT,
    PROJECT_NUMBER,
    PROJECT_MANAGER,
    DISTRIBUTION_RULE,
    PROJECT_STATUS_CODE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    DELETION_DATE,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    PROJECT_PK,
    NVL(PRJ_TYP_FK, 'NA_EDW'),
    NVL(PROJ_CLS1_FK, 'NA_EDW'),
    NVL(PROJ_CLS2_FK, 'NA_EDW'),
    NVL(PROJ_CLS3_FK, 'NA_EDW'),
    NVL(PROJ_CLS4_FK, 'NA_EDW'),
    NVL(PROJ_CLS5_FK, 'NA_EDW'),
    NVL(PROJ_CLS6_FK, 'NA_EDW'),
    NVL(PROJ_CLS7_FK, 'NA_EDW'),
    NAME,
    PROJECT,
    PROJECT_NUMBER,
    PROJECT_MANAGER,
    DISTRIBUTION_RULE,
    PROJECT_STATUS_CODE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    to_date(NULL),
    NULL,
    'READY'
  from
    FII_PROJ_PROJECT_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 359

  l_rows_inserted := sql%rowcount;

Line: 385

  l_rows_inserted            NUMBER :=0;

Line: 398

  Insert Into EDW_PROJ_PRJ_TYP_LSTG
  (
    PRJ_TYP_PK,
    ALL_FK,
    NAME,
    PROJECT_TYPE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    DELETION_DATE,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    PRJ_TYP_PK,
    NVL(ALL_FK, 'NA_EDW'),
    NAME,
    PROJECT_TYPE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    INSTANCE,
    to_date(NULL),
    NULL,
    'READY'
  from
    FII_PROJ_PRJ_TYP_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 433

    l_rows_inserted := sql%rowcount;

Line: 455

      Insert Into EDW_PROJ_PRJ_TYP_LSTG
      (
        PRJ_TYP_PK,
        ALL_FK,
        NAME,
        PROJECT_TYPE,
        USER_ATTRIBUTE1,
        USER_ATTRIBUTE2,
        USER_ATTRIBUTE3,
        USER_ATTRIBUTE4,
        USER_ATTRIBUTE5,
        INSTANCE,
        DELETION_DATE,
        OPERATION_CODE,
        COLLECTION_STATUS
      )
      values
      (
        'FII_PJM_SEIBAN_PROJECT_TYPE-' || l_instance,
        'ALL',
        l_seiban_project_type || ', ' || l_instance,
        l_seiban_project_type,
        null,
        null,
        null,
        null,
        null,
        l_instance,
        to_date( null ),
        null,
        'READY'
      );

Line: 488

    l_rows_inserted := l_rows_inserted + 1;

Line: 517

  l_rows_inserted        NUMBER :=0;

Line: 528

  Insert Into EDW_PROJ_CLS1_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS1,
    PROJ_CATEG1_FK,
    PROJ_CLS1_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS1,
    NVL(PROJ_CATEG1_FK, 'NA_EDW'),
    PROJ_CLS1_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CLS1_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 563

  l_rows_inserted := sql%rowcount;

Line: 589

  l_rows_inserted      NUMBER :=0;

Line: 600

  Insert Into EDW_PROJ_CLS2_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS2,
    PROJ_CATEG2_FK,
    PROJ_CLS2_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS2,
    NVL(PROJ_CATEG2_FK, 'NA_EDW'),
    PROJ_CLS2_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CLS2_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 634

  l_rows_inserted := sql%rowcount;

Line: 660

  l_rows_inserted   NUMBER :=0;

Line: 671

  Insert Into EDW_PROJ_CLS3_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS3,
    PROJ_CATEG3_FK,
    PROJ_CLS3_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS3,
    NVL(PROJ_CATEG3_FK, 'NA_EDW'),
    PROJ_CLS3_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CLS3_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 706

  l_rows_inserted := sql%rowcount;

Line: 732

  l_rows_inserted      NUMBER :=0;

Line: 743

  Insert Into EDW_PROJ_CLS4_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS4,
    PROJ_CATEG4_FK,
    PROJ_CLS4_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS4,
    NVL(PROJ_CATEG4_FK, 'NA_EDW'),
    PROJ_CLS4_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CLS4_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 778

  l_rows_inserted := sql%rowcount;

Line: 804

  l_rows_inserted          NUMBER :=0;

Line: 815

  Insert Into EDW_PROJ_CLS5_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS5,
    PROJ_CATEG5_FK,
    PROJ_CLS5_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS5,
    NVL(PROJ_CATEG5_FK, 'NA_EDW'),
    PROJ_CLS5_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CLS5_LCV
   where
    last_update_date between l_date1 and l_date2;

Line: 850

  l_rows_inserted := sql%rowcount;

Line: 876

  l_rows_inserted    NUMBER :=0;

Line: 887

  Insert Into EDW_PROJ_CLS6_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS6,
    PROJ_CATEG6_FK,
    PROJ_CLS6_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS6,
    NVL(PROJ_CATEG6_FK, 'NA_EDW'),
    PROJ_CLS6_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CLS6_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 922

  l_rows_inserted := sql%rowcount;

Line: 948

  l_rows_inserted     NUMBER :=0;

Line: 959

  Insert Into EDW_PROJ_CLS7_LSTG
  (
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CLASS7,
    PROJ_CATEG7_FK,
    PROJ_CLS7_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CLASS7,
    NVL(PROJ_CATEG7_FK, 'NA_EDW'),
    PROJ_CLS7_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
  from
    FII_PROJ_CLS7_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 994

  l_rows_inserted := sql%rowcount;

Line: 1020

  l_rows_inserted      NUMBER :=0;

Line: 1031

  Insert Into EDW_PROJ_CATEG1_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY1,
    PROJ_CATEG1_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL), -- DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY1,
    PROJ_CATEG1_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG1_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1066

  l_rows_inserted := sql%rowcount;

Line: 1092

    l_rows_inserted     NUMBER :=0;

Line: 1103

  Insert Into EDW_PROJ_CATEG2_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY2,
    PROJ_CATEG2_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CATEGORY2,
    PROJ_CATEG2_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG2_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1138

  l_rows_inserted := sql%rowcount;

Line: 1163

  l_rows_inserted      NUMBER :=0;

Line: 1174

  Insert Into EDW_PROJ_CATEG3_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY3,
    PROJ_CATEG3_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CATEGORY3,
    PROJ_CATEG3_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG3_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1209

  l_rows_inserted := sql%rowcount;

Line: 1235

  l_rows_inserted     NUMBER :=0;

Line: 1246

  Insert Into EDW_PROJ_CATEG4_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY4,
    PROJ_CATEG4_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CATEGORY4,
    PROJ_CATEG4_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG4_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1281

  l_rows_inserted := sql%rowcount;

Line: 1307

  l_rows_inserted      NUMBER :=0;

Line: 1318

  Insert Into EDW_PROJ_CATEG5_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY5,
    PROJ_CATEG5_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CATEGORY5,
    PROJ_CATEG5_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG5_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1353

  l_rows_inserted := sql%rowcount;

Line: 1379

  l_rows_inserted       NUMBER :=0;

Line: 1390

  Insert Into EDW_PROJ_CATEG6_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY6,
    PROJ_CATEG6_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CATEGORY6,
    PROJ_CATEG6_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG6_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1425

  l_rows_inserted := sql%rowcount;

Line: 1451

  l_rows_inserted        NUMBER :=0;

Line: 1462

  Insert Into EDW_PROJ_CATEG7_LSTG
  (
    ALL_FK,
    DELETION_DATE,
    INSTANCE,
    NAME,
    PROJECT_CATEGORY7,
    PROJ_CATEG7_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS
  )
  select
    NVL(ALL_FK, 'NA_EDW'),
    to_date(NULL),
    INSTANCE,
    NAME,
    PROJECT_CATEGORY7,
    PROJ_CATEG7_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    NULL,
    'READY'
  from
    FII_PROJ_CATEG7_LCV
  where
    last_update_date between l_date1 and l_date2;

Line: 1497

  l_rows_inserted := sql%rowcount;