DBA Data[Home] [Help]

APPS.PJI_SYSTEM_SETTINGS_PKG SQL Statements

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

Line: 3

  PROCEDURE insert_row (
        p_setting_id           IN NUMBER,
        p_pa_period_flag       IN VARCHAR2,
        p_gl_period_flag       IN VARCHAR2,
        p_planamt_alloc_method IN VARCHAR2,
        p_prj_curr_flag        IN VARCHAR2,
        p_projfunc_curr_flag   IN VARCHAR2,
        p_curr_rep_pa_period   IN VARCHAR2,
        p_curr_rep_gl_period   IN VARCHAR2,
        p_curr_rep_ent_period  IN VARCHAR2,
        p_plan_amt_conv_date   IN VARCHAR2,
        p_global_curr2_flag    IN VARCHAR2,
        p_txn_curr_flag        IN VARCHAR2, -- Added for bug 4167173
        x_return_status  OUT NOCOPY VARCHAR2,
        x_msg_count      OUT NOCOPY NUMBER,
        x_msg_data       OUT NOCOPY VARCHAR2
  ) IS
  BEGIN

  INSERT INTO pji_system_settings (
        SETTING_ID ,
        PA_PERIOD_FLAG ,
        GL_PERIOD_FLAG ,
        PLANAMT_ALLOC_METHOD ,
        PRJ_CURR_FLAG ,
        PROJFUNC_CURR_FLAG ,
        CURR_REP_PA_PERIOD ,
        CURR_REP_GL_PERIOD ,
        CURR_REP_ENT_PERIOD ,
        PLANAMT_CONV_DATE,
        GLOBAL_CURR2_FLAG,
        TXN_CURR_FLAG,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN
  ) VALUES (
        p_SETTING_ID ,
        p_PA_PERIOD_FLAG ,
        p_GL_PERIOD_FLAG ,
        p_PLANAMT_ALLOC_METHOD ,
        p_PRJ_CURR_FLAG ,
        p_PROJFUNC_CURR_FLAG ,
        p_CURR_REP_PA_PERIOD  ,
        p_CURR_REP_GL_PERIOD  ,
        p_CURR_REP_ENT_PERIOD  ,
        p_PLAN_AMT_CONV_DATE ,
        p_global_curr2_flag,
        p_txn_curr_flag,
        sysdate ,
        fnd_global.user_id ,
        sysdate ,
        fnd_global.user_id ,
        fnd_global.login_id
           ) ;
Line: 63

  END insert_row;
Line: 65

  PROCEDURE update_row (
        p_setting_id           IN NUMBER,
        p_pa_period_flag       IN VARCHAR2,
        p_gl_period_flag       IN VARCHAR2,
        p_planamt_alloc_method IN VARCHAR2,
        p_prj_curr_flag        IN VARCHAR2,
        p_projfunc_curr_flag   IN VARCHAR2,
        p_curr_rep_pa_period   IN VARCHAR2,
        p_curr_rep_gl_period   IN VARCHAR2,
        p_curr_rep_ent_period  IN VARCHAR2,
        p_plan_amt_conv_date   IN VARCHAR2,
        p_global_curr2_flag    IN VARCHAR2,
        p_txn_curr_flag        IN VARCHAR2, -- Added for bug 4167173
        x_return_status  OUT NOCOPY VARCHAR2,
        x_msg_count      OUT NOCOPY NUMBER,
        x_msg_data       OUT NOCOPY VARCHAR2
  ) IS
        l_return_status  VARCHAR2(15);
Line: 87

  UPDATE pji_system_settings SET
        PA_PERIOD_FLAG = p_PA_PERIOD_FLAG,
        GL_PERIOD_FLAG = p_GL_PERIOD_FLAG,
        PLANAMT_ALLOC_METHOD = p_PLANAMT_ALLOC_METHOD,
        PRJ_CURR_FLAG = p_PRJ_CURR_FLAG,
        PROJFUNC_CURR_FLAG = p_PROJFUNC_CURR_FLAG,
        CURR_REP_PA_PERIOD = p_CURR_REP_PA_PERIOD,
        CURR_REP_GL_PERIOD = p_CURR_REP_GL_PERIOD,
        CURR_REP_ENT_PERIOD = p_CURR_REP_ENT_PERIOD,
        PLANAMT_CONV_DATE = p_PLAN_AMT_CONV_DATE,
        GLOBAL_CURR2_FLAG = p_global_curr2_flag,
        TXN_CURR_FLAG     = p_txn_curr_flag,
        LAST_UPDATE_DATE = sysdate,
        LAST_UPDATED_BY = fnd_global.user_id,
        LAST_UPDATE_LOGIN = fnd_global.login_id;
Line: 103

    insert_row(
        p_SETTING_ID , --setting_id would be coming from page as 1
        p_PA_PERIOD_FLAG ,
        p_GL_PERIOD_FLAG ,
        p_PLANAMT_ALLOC_METHOD ,
        p_PRJ_CURR_FLAG ,
        p_PROJFUNC_CURR_FLAG ,
        p_CURR_REP_PA_PERIOD  ,
        p_CURR_REP_GL_PERIOD  ,
        p_CURR_REP_ENT_PERIOD  ,
        p_PLAN_AMT_CONV_DATE,
        p_global_curr2_flag,
        p_txn_curr_flag,
        l_return_status,
        l_msg_count,
        l_msg_data
              );
Line: 122

  END update_row;
Line: 124

  PROCEDURE delete_row (
        p_setting_id   IN NUMBER,
        x_return_status  OUT NOCOPY VARCHAR2,
        x_msg_count      OUT NOCOPY NUMBER,
        x_msg_data       OUT NOCOPY VARCHAR2
  ) IS
  BEGIN


  delete from PJI_SYSTEM_SETTINGS where SETTING_ID = p_SETTING_ID;
Line: 135

  END delete_row;