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_curr1_flag    IN VARCHAR2,  /* Added for Bug 8708651 */
        p_global_curr2_flag    IN VARCHAR2,
        p_txn_curr_flag        IN VARCHAR2, -- Added for bug 4167173
        p_time_phase_flag      IN VARCHAR2,  /* Added for Bug 8708651 */
        p_per_analysis_flag    IN VARCHAR2,  /* Added for Bug 8708651 */
        p_up_process_flag      IN VARCHAR2,  /* Added for Bug 8708651 */
		p_psi_ppr_flag         IN VARCHAR2,  /* Added for Bug 13889383 */
        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_CURR1_FLAG,     /* Added for Bug 8708651 */
        GLOBAL_CURR2_FLAG,
        TXN_CURR_FLAG,
        TIME_PHASE_FLAG,      /* Added for Bug 8708651 */
        PER_ANALYSIS_FLAG,    /* Added for Bug 8708651 */
        UP_PROCESS_FLAG,      /* Added for Bug 8708651 */
		PSI_PPR_FLAG,       /* Added for Bug 13889383 */
        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_curr1_flag,  /* Added for Bug 8708651 */
        p_global_curr2_flag,
        p_txn_curr_flag,
        p_time_phase_flag,     /* Added for Bug 8708651 */
        p_per_analysis_flag,   /* Added for Bug 8708651 */
        p_up_process_flag,     /* Added for Bug 8708651 */
		p_psi_ppr_flag,        /* Added for Bug 13889383 */
        sysdate ,
        fnd_global.user_id ,
        sysdate ,
        fnd_global.user_id ,
        fnd_global.login_id
           ) ;

Line: 78

  END insert_row;

Line: 80

  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_curr1_flag    IN VARCHAR2,  /* Added for Bug 8708651 */
        p_global_curr2_flag    IN VARCHAR2,
        p_txn_curr_flag        IN VARCHAR2, -- Added for bug 4167173
        p_time_phase_flag      IN VARCHAR2,  /* Added for Bug 8708651 */
        p_per_analysis_flag    IN VARCHAR2,  /* Added for Bug 8708651 */
        p_up_process_flag      IN VARCHAR2,  /* Added for Bug 8708651 */
		p_psi_ppr_flag         IN VARCHAR2,  /* Added for Bug 13889383 */
        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: 107

  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_CURR1_FLAG = p_global_curr1_flag,  /* Added for Bug 8708651 */
        GLOBAL_CURR2_FLAG = p_global_curr2_flag,
        TXN_CURR_FLAG     = p_txn_curr_flag,
        TIME_PHASE_FLAG   = p_time_phase_flag,    /* Added for Bug 8708651 */
        PER_ANALYSIS_FLAG = p_per_analysis_flag,  /* Added for Bug 8708651 */
        UP_PROCESS_FLAG = p_up_process_flag,      /* Added for Bug 8708651 */
		PSI_PPR_FLAG    = p_psi_ppr_flag,         /* Added for Bug 13889383 */
        LAST_UPDATE_DATE = sysdate,
        LAST_UPDATED_BY = fnd_global.user_id,
        LAST_UPDATE_LOGIN = fnd_global.login_id;

Line: 128

    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_curr1_flag,  /* Added for Bug 8708651 */
        p_global_curr2_flag,
        p_txn_curr_flag,
        p_time_phase_flag,    /* Added for Bug 8708651 */
        p_per_analysis_flag,  /* Added for Bug 8708651 */
        p_up_process_flag,    /* Added for Bug 8708651 */
		p_psi_ppr_flag,       /* Added for Bug 13889383 */
        l_return_status,
        l_msg_count,
        l_msg_data
              );

Line: 152

  END update_row;

Line: 154

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

  END delete_row;