DBA Data[Home] [Help]

APPS.XDP_PARAM_CACHE SQL Statements

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

Line: 46

	pv_wi_param_list.delete;
Line: 54

	pv_fa_param_list.delete;
Line: 122

			p_update_db in varchar2 default 'Y')

 is
  l_index number;
Line: 136

	-- If so the cache is updated
	-- Else the Parameter Configuratio is added
	l_index := get_param_index(g_WIParam, p_param_name);
Line: 140

		-- Parameter already found. Update required
-- dbms_output.put_line(' -- Need to Update the cache:(WI) ' || p_param_name);
Line: 204

			p_update_db in varchar2 default 'Y')

 is
  l_index number;
Line: 217

	-- If so the cache is updated
	-- Else the Parameter Configuratio is added
	l_index := get_param_index(g_FAParam, p_param_name);
Line: 221

		-- Paramter already exists in the Cache. Needs an update
		-- dbms_output.put_line(' -- Need to Update the cache: (FA) ' || p_param_name);
Line: 351

	-- get the index to be deleted
	l_index := get_param_index(p_param_type, p_param_name);
Line: 356

		-- delete the entry from the cache
		if p_param_type = g_WIParam then
			-- dbms_output.put_line('removing.. ' || l_index);
Line: 359

			pv_wi_param_list.delete(l_index);
Line: 361

			pv_fa_param_list.delete(l_index);
Line: 524

				p_update_db => 'N');
Line: 546

					p_update_db => 'N');
Line: 563

				p_update_db => 'N');