APPS.PJI_CURR_REP_PERIODS_UTIL SQL Statements

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

Line: 11

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;

Line: 30

	   Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);

Line: 35

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;

Line: 45

	-- 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
		);

Line: 63

	-- 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);

Line: 74

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';

Line: 83

	INSERT
	INTO	pji_system_parameters
		(
		 name,
		 value
		)
	VALUES
		(
		 'PJI_PJP_ENT_CURR_REP_PERIOD',
		 p_ent_curr_rep_period
		);

Line: 96

	UPDATE 	pji_system_parameters
	SET 	value = p_ent_curr_rep_period
	WHERE 	name = 'PJI_PJP_ENT_CURR_REP_PERIOD';

Line: 110

	   Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: finishing', TRUE , g_proc);

Line: 114

END update_curr_rep_periods;