APPS.HXC_RTR_UPLOAD_PKG SQL Statements

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

Line: 20

SELECT	retrieval_process_id
FROM 	hxc_retrieval_processes
WHERE	name 	= p_retrieval_process_name;

Line: 38

	SELECT	retrieval_rule_id
	,	object_version_number
	,	DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_retrieval_rule_id
	,	l_ovn
	,	l_owner
	FROM	hxc_retrieval_rules
	WHERE	name	= P_NAME;

Line: 50

		hxc_retrieval_rules_api.update_retrieval_rules (
				  p_effective_date	  => sysdate
			,	  p_retrieval_rule_id	  => l_retrieval_rule_id
			,	  p_retrieval_process_id  => l_retrieval_process_id
			,	  p_name		  => p_name
	  		,	  p_object_version_number => l_ovn );

Line: 89

SELECT	retrieval_rule_id
FROM 	hxc_retrieval_rules
WHERE	name 	= p_retrieval_rule_name;

Line: 108

	SELECT	rtc.retrieval_rule_comp_id
	,	rtc.object_version_number
	,	DECODE( NVL(rtc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
	INTO	l_retrieval_rule_comp_id
	,	l_ovn
	,	l_owner
	FROM	hxc_retrieval_rule_comps rtc
	WHERE	rtc.retrieval_rule_id	= l_retrieval_rule_id
	AND	rtc.time_recipient_id	= l_time_recipient_id
	AND	rtc.status		= p_status;

Line: 122

		hxc_retrieval_rule_comps_api.update_retrieval_rule_comps (
				  p_retrieval_rule_id	=> l_retrieval_rule_id
			,	  p_effective_date      => sysdate
			,	  p_status              => p_status
			,	  p_time_recipient_id   => l_time_recipient_id
			,	  p_retrieval_rule_comp_id => l_retrieval_rule_comp_id
	  		,	  p_object_version_number  => l_ovn );