The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_curr_rep_periods(
p_pa_curr_rep_period VARCHAR2,
p_gl_curr_rep_period VARCHAR2,
p_ent_curr_rep_period VARCHAR2,
p_org_id NUMBER
) AS
-- ----------------------------------------------
-- declare statements --
l_org_id_count NUMBER := 0;
Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);
SELECT COUNT(info.org_id)
INTO l_org_id_count
FROM pji_org_extr_info info
WHERE 1=1
AND info.org_id = p_org_id;
-- insert p_org_id, pa_curr_rep_period and gl_curr_rep_period (everything else is null)
INSERT
INTO pji_org_extr_info
(
org_id,
pa_curr_rep_period,
gl_curr_rep_period
)
VALUES
(
--NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99),
p_org_id,
p_pa_curr_rep_period,
p_gl_curr_rep_period
);
-- update pa_curr_rep_period and gl_curr_rep_period
UPDATE pji_org_extr_info
SET pa_curr_rep_period = p_pa_curr_rep_period,
gl_curr_rep_period = p_gl_curr_rep_period
--WHERE org_id = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99);
SELECT COUNT(params.name)
INTO l_ent_period_count
FROM pji_system_parameters params
WHERE 1=1
AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
INSERT
INTO pji_system_parameters
(
name,
value
)
VALUES
(
'PJI_PJP_ENT_CURR_REP_PERIOD',
p_ent_curr_rep_period
);
UPDATE pji_system_parameters
SET value = p_ent_curr_rep_period
WHERE name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: finishing', TRUE , g_proc);
END update_curr_rep_periods;