The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
) ;
END insert_row;
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);
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;
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
);
END update_row;
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;
END delete_row;