APPS.PJI_PROCESS_UTIL SQL Statements

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

Line: 43

                             select PJI_RM_SUM_MAIN.g_process
                             into   :l_stage2_pji_process
                             from   DUAL;

Line: 75

        select VALUE
        into   l_permanent_param
        from   PJI_SYSTEM_PARAMETERS
        where  NAME like 'LAST_PJP_EXTR_DATE%' and
               ROWNUM = 1;

Line: 89

        select VALUE
        into   l_running_param
        from   PJI_SYSTEM_PARAMETERS
        where  NAME like PJI_PJP_SUM_MAIN.g_process || '%PROCESS_RUNNING' and
               ROWNUM = 1;

Line: 144

    select count(*)
    into   l_count
    from   PJI_SYSTEM_PRC_STATUS
    where  PROCESS_NAME = p_process and
           STEP_NAME    = p_step;

Line: 154

    select STEP_STATUS,
           STEP_SEQ
    into   l_status,
           l_seq
    from   PJI_SYSTEM_PRC_STATUS
    where  PROCESS_NAME = p_process and
           STEP_NAME    = p_step;

Line: 166

      update PJI_SYSTEM_PRC_STATUS
      set    START_DATE = sysdate
      where  PROCESS_NAME = p_process and
             STEP_NAME    = p_step and
             START_DATE   is null;

Line: 201

    update PJI_SYSTEM_PRC_STATUS
    set    STEP_STATUS = 'C',
           END_DATE = sysdate
    where  PROCESS_NAME = p_process and
           STEP_NAME    = p_step;

Line: 245

    delete
    from   PJI_SYSTEM_PRC_STATUS
    where  PROCESS_NAME = p_process;

Line: 249

    delete
    from   PJI_SYSTEM_PARAMETERS
    where  NAME like p_process || '$%';

Line: 324

    insert into PJI_SYSTEM_PRC_STATUS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_STATUS,
      STEP_SEQ
    )
    select
      p_process,
      STEP_NAME,
      null,
      STEP_SEQ
    from
      PJI_MT_PRC_STEPS
    where
      PROCESS_NAME = p_step_process                                       and
      ((CONFIG_PROJ_PERF_FLAG = 'Y' and l_params_proj_perf_flag = 'Y') or
       (CONFIG_COST_FLAG      = 'Y' and l_params_cost_flag      = 'Y') or
       (CONFIG_PROFIT_FLAG    = 'Y' and l_params_profit_flag    = 'Y') or
       (CONFIG_UTIL_FLAG      = 'Y' and l_params_util_flag      = 'Y') or
       p_step_process = 'PJI_PJP_FPM_UPGRADE')   and
      bitand(to_number(STEP_TYPE), l_extraction_type) = l_extraction_type and
      (STEP_NAME,
       STEP_SEQ) not in (select STEP_NAME,
                                STEP_SEQ
                         from   PJI_SYSTEM_PRC_STATUS
                         where  PROCESS_NAME = p_process);

Line: 369

    select count(*)
    into   l_count
    from   PJI_SYSTEM_PRC_STATUS
    where  PROCESS_NAME = p_process;

Line: 485

        select count(*)
        into   l_worker_count
        from   PJI_SYSTEM_PRC_STATUS
        where  PROCESS_NAME like p_process || '%' and
               STEP_NAME = p_step;

Line: 503

      select count(*)
      into   l_worker_count
      from   PJI_SYSTEM_PRC_STATUS
      where  PROCESS_NAME like p_process || '%' and
             STEP_NAME = p_step and
             STEP_STATUS is null;

Line: 513

                             select PJI_RM_SUM_MAIN.g_process
                             into   :l_stage2_pji_process
                             from   DUAL;

Line: 579

    delete
    from   PJI_HELPER_BATCH_MAP
    where  STATUS = 'P';

Line: 660

                                         l_dev_status = 'DELETED' or
                                         l_dev_status = 'TERMINATED'))) then
        return false;

Line: 677

          select
            ORACLE_PROCESS_ID,
            ORACLE_SESSION_ID
          into
            l_process_id,
            l_session_id
          from
            FND_CONCURRENT_REQUESTS
          where
            REQUEST_ID = l_request_id;

Line: 688

          select
            count(*)
          into
            l_count
          from
            V$PROCESS
          where
            SPID = l_process_id and
            ROWNUM = 1;

Line: 780

    select count(*)
    into   l_count
    from   PJI_MT_PRC_STEPS
    where  ROWNUM = 1;

Line: 790

    delete from PJI_MT_PRC_STEPS;

Line: 798

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_MAIN.INIT_PROCESS;',

Line: 823

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_MAIN.RUN_PROCESS;',

Line: 848

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_MAIN.WRAPUP_PROCESS;',

Line: 873

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);',

Line: 898

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);',

Line: 923

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_DREV_PRE(p_worker_id);',

Line: 949

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR_HELPER',
      'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);',

Line: 974

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_DREV_POST(p_worker_id);',

Line: 999

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);',

Line: 1024

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);',

Line: 1050

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR_HELPER',
      'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);',

Line: 1075

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);',

Line: 1100

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);',

Line: 1125

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);',

Line: 1150

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);',

Line: 1175

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);',

Line: 1200

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);',

Line: 1225

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);',

Line: 1250

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_FND(p_worker_id);',

Line: 1275

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_PRE(p_worker_id);',

Line: 1301

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR_HELPER',
      'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);',

Line: 1326

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_POST(p_worker_id);',

Line: 1351

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);',

Line: 1376

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);',

Line: 1401

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);',

Line: 1426

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);',

Line: 1451

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);',

Line: 1477

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR_HELPER',
      'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);',

Line: 1502

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);',

Line: 1527

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_ACT.BASE_SUMMARY(p_worker_id);',

Line: 1552

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);',

Line: 1577

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR_HELPER',
      'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);',

Line: 1602

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);',

Line: 1627

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);',

Line: 1652

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);',

Line: 1677

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);',

Line: 1702

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);',

Line: 1727

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);',

Line: 1752

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);',

Line: 1777

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);',

Line: 1802

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);',

Line: 1827

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);',

Line: 1852

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);',

Line: 1877

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);',

Line: 1902

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);',

Line: 1927

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);',

Line: 1952

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);',

Line: 1977

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);',

Line: 2002

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);',

Line: 2027

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);',

Line: 2052

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);',

Line: 2077

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);',

Line: 2102

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);',

Line: 2127

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);',

Line: 2152

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);',

Line: 2177

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);',

Line: 2202

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);',

Line: 2227

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);',

Line: 2252

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);',

Line: 2277

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);',

Line: 2302

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_EXTR',
      'PJI_FM_SUM_EXTR.CLEANUP_WORKER(p_worker_id);',

Line: 2331

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_MAIN.INIT_PROCESS;',

Line: 2356

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);',

Line: 2381

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_PJI_EXTRACTION_UTILS.UPDATE_RESOURCE_DATA(p_process);',

Line: 2406

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_MAIN.RUN_PROCESS;',

Line: 2431

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_MAIN.WRAPUP_PROCESS;',

Line: 2456

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);',

Line: 2481

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);',

Line: 2506

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);',

Line: 2531

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);',

Line: 2556

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);',

Line: 2581

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);',

Line: 2606

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);',

Line: 2631

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);',

Line: 2656

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);',

Line: 2681

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);',

Line: 2706

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);',

Line: 2731

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);',

Line: 2756

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);',

Line: 2781

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);',

Line: 2806

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);',

Line: 2832

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI_HELPER',
      'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);',

Line: 2857

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);',

Line: 2882

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);',

Line: 2907

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);',

Line: 2932

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.PROCESS_DANGLING_ROWS(p_worker_id);',

Line: 2957

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.PURGE_DANGLING_ROWS(p_worker_id);',

Line: 2982

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);',

Line: 3007

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID_ROWIDS(p_worker_id);',

Line: 3032

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS_PRE(p_worker_id);',

Line: 3058

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI_HELPER',
      'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS(p_worker_id);',

Line: 3083

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS_POST(p_worker_id);',

Line: 3108

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.RES_ROWID_TABLE(p_worker_id);',

Line: 3133

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID_FULL(p_worker_id);',

Line: 3158

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID(p_worker_id);',

Line: 3183

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.MOVE_DANGLING_ROWS(p_worker_id);',

Line: 3208

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.PURGE_RES_DATA(p_worker_id);',

Line: 3233

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.GET_JOB_ID_LOOKUPS(p_worker_id);',

Line: 3258

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.PROCESS_JOB_ID(p_worker_id);',

Line: 3283

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_id);',

Line: 3308

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);',

Line: 3334

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI_HELPER',
      'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);',

Line: 3359

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);',

Line: 3384

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);',

Line: 3409

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);',

Line: 3434

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);',

Line: 3459

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.FIN_ROWID_TABLE(p_worker_id);',

Line: 3484

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_WT_SLICES(p_worker_id);',

Line: 3509

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.PURGE_FIN_DATA(p_worker_id);',

Line: 3534

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);',

Line: 3559

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);',

Line: 3584

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);',

Line: 3609

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);',

Line: 3634

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);',

Line: 3659

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);',

Line: 3684

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);',

Line: 3709

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);',

Line: 3734

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);',

Line: 3759

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);',

Line: 3784

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);',

Line: 3809

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);',

Line: 3834

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);',

Line: 3859

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);',

Line: 3884

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);',

Line: 3909

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);',

Line: 3934

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);',

Line: 3959

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);',

Line: 3984

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);',

Line: 4009

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);',

Line: 4034

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);',

Line: 4059

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_EN(p_worker_id);',

Line: 4084

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_PA(p_worker_id);',

Line: 4109

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_GL(p_worker_id);',

Line: 4134

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);',

Line: 4159

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_EN(p_worker_id, ''N'');',

Line: 4184

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, ''N'');',

Line: 4209

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, ''N'');',

Line: 4234

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, ''N'');',

Line: 4259

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);',

Line: 4284

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);',

Line: 4309

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);',

Line: 4334

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);',

Line: 4359

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);',

Line: 4385

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI_HELPER',
      'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);',

Line: 4410

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);',

Line: 4435

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);',

Line: 4460

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);',

Line: 4485

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);',

Line: 4510

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);',

Line: 4535

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);',

Line: 4560

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.MERGE_ACT_INTO_ACP(p_worker_id, ''N'');',

Line: 4585

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);',

Line: 4610

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);',

Line: 4636

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI_HELPER',
      'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);',

Line: 4661

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_EN(p_worker_id, ''Y'');',

Line: 4686

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, ''Y'');',

Line: 4711

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, ''Y'');',

Line: 4736

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, ''Y'');',

Line: 4761

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.MERGE_ACT_INTO_ACP(p_worker_id, ''Y'');',

Line: 4786

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);',

Line: 4811

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);',

Line: 4836

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);',

Line: 4861

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);',

Line: 4886

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);',

Line: 4911

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);',

Line: 4936

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);',

Line: 4961

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);',

Line: 4986

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);',

Line: 5011

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);',

Line: 5036

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);',

Line: 5061

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);',

Line: 5086

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);',

Line: 5111

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEC(p_worker_id);',

Line: 5136

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPO(p_worker_id);',

Line: 5161

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPC(p_worker_id);',

Line: 5186

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACO(p_worker_id);',

Line: 5211

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACC(p_worker_id);',

Line: 5236

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJI',
      'PJI_RM_SUM_EXTR.CLEANUP_WORKER(p_worker_id);',

Line: 5265

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);',

Line: 5290

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);',

Line: 5315

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);',

Line: 5340

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);',

Line: 5365

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);',

Line: 5390

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);',

Line: 5415

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);',

Line: 5440

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id);',

Line: 5465

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);',

Line: 5490

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);',

Line: 5515

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);',

Line: 5540

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);',

Line: 5565

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);',

Line: 5590

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);',

Line: 5615

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id);',

Line: 5640

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);',

Line: 5665

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);',

Line: 5690

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);',

Line: 5715

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);',

Line: 5740

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);',

Line: 5765

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);',

Line: 5790

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);',

Line: 5815

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);',

Line: 5840

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);',

Line: 5865

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);',

Line: 5890

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);',

Line: 5915

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);',

Line: 5940

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);',

Line: 5965

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);',

Line: 5990

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);',

Line: 6015

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);',

Line: 6040

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);',

Line: 6065

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);',

Line: 6090

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);',

Line: 6115

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);',

Line: 6140

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);',

Line: 6165

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);',

Line: 6190

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);',

Line: 6215

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);',

Line: 6240

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);',

Line: 6265

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);',

Line: 6290

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);',

Line: 6315

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);',

Line: 6340

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);',

Line: 6365

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);',

Line: 6390

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);',

Line: 6415

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);',

Line: 6440

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);',

Line: 6465

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);',

Line: 6491

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACT(p_worker_id);',

Line: 6514

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);',

Line: 6539

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);',

Line: 6564

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);',

Line: 6589

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);',

Line: 6614

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);',

Line: 6639

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);',

Line: 6664

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);',

Line: 6689

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);',

Line: 6714

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);',

Line: 6739

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);',

Line: 6764

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);',

Line: 6789

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);',

Line: 6814

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);',

Line: 6839

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);',

Line: 6864

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);',

Line: 6889

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);',

Line: 6914

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);',

Line: 6939

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);',

Line: 6964

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);',

Line: 6989

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP',
      'PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);',

Line: 7018

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(p_worker_id);',

Line: 7043

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id);',

Line: 7068

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);',

Line: 7093

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);',

Line: 7118

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id);',

Line: 7143

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);',

Line: 7168

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.EXTRACT_FIN_PLAN_VERS_BULK(p_worker_id);',

Line: 7193

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.POPULATE_WBS_HDR(p_worker_id);',

Line: 7218

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_HDR(p_worker_id);',

Line: 7243

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.RETRIEVE_OVERRIDDEN_WP_ETC(p_worker_id);',

Line: 7268

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_ETC_PRIRBS(p_worker_id);',

Line: 7293

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_AMOUNTS_PRIRBS(p_worker_id);',

Line: 7318

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);',

Line: 7343

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_T_SLICE(p_worker_id);',

Line: 7368

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);',

Line: 7393

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.CREATE_FP_PA_PRI_ROLLUP(p_worker_id);',

Line: 7418

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.CREATE_FP_GL_PRI_ROLLUP(p_worker_id);',

Line: 7443

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.CREATE_FP_ALL_PRI_ROLLUP(p_worker_id);',

Line: 7468

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(p_worker_id);',

Line: 7493

    insert into PJI_MT_PRC_STEPS
    (
      PROCESS_NAME,
      STEP_NAME,
      STEP_SEQ,
      STEP_TYPE,
      CONFIG_PROJ_PERF_FLAG,
      CONFIG_COST_FLAG,
      CONFIG_PROFIT_FLAG,
      CONFIG_UTIL_FLAG
    )
    values
    (
      'PJI_PJP_FPM_UPGRADE',
      'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PLANS(p_worker_id);',