APPS.HXC_HPH_UPLOAD_PKG SQL Statements

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

Line: 63

SELECT  DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
FROM    hxc_pref_hierarchies;

Line: 71

SELECT	pd.pref_definition_id
FROM	hxc_pref_definitions pd
,	fnd_descr_flex_contexts_vl df
WHERE	df.application_id		 = 809
AND	df.descriptive_flexfield_name	 = 'OTC PREFERENCES'
AND	df.descriptive_flex_context_name = p_pref_def_name
AND	df.descriptive_flex_context_code = pd.code;

Line: 96

SELECT	TO_CHAR(approval_style_id)
FROM	hxc_approval_styles
WHERE	name	= p_attribute;

Line: 101

SELECT	TO_CHAR(alias_definition_id)
FROM	hxc_alias_definitions
WHERE	alias_definition_name	= p_attribute;

Line: 106

SELECT TO_CHAR(rp.recurring_period_id)
FROM   hxc_recurring_periods rp
WHERE  rp.name	= p_attribute;

Line: 111

SELECT	TO_CHAR(aps.application_set_id)
FROM	hxc_application_sets_v aps
WHERE	aps.application_set_name = p_attribute;

Line: 116

SELECT	TO_CHAR(rrg.retrieval_rule_group_id)
FROM	hxc_retrieval_rule_groups_v rrg
WHERE	rrg.retrieval_rule_group_name = p_attribute;

Line: 121

SELECT	TO_CHAR(aps.approval_period_set_id)
FROM	hxc_approval_period_sets aps
WHERE	aps.name = p_attribute;

Line: 126

SELECT	layout_id
FROM	hxc_layouts
WHERE	layout_name		= p_attribute;

Line: 131

SELECT  egc.attribute1
FROM    hxc_entity_group_comps egc
WHERE   egc.attribute2 = p_attribute
AND EXISTS ( SELECT 'x'
             FROM   hxc_entity_groups eg
             WHERE  eg.entity_group_id = egc.entity_group_id
             AND    eg.entity_type     = 'HXC_SS_TC_DATE_FORMATS' );

Line: 140

SELECT  time_entry_rule_group_id
FROM    hxc_time_entry_rule_groups_v
WHERE   time_entry_rule_group_name = p_attribute1;

Line: 312

	hxc_pref_hierarchies_api.update_pref_hierarchies (
				  p_effective_date	=> sysdate
				, p_name		=> p_name
				, p_business_group_id	=> null
				, p_legislation_code	=> p_legislation_code
				, p_pref_hierarchy_id	=> l_pref_hierarchy_id
				, p_parent_pref_hierarchy_id	=> l_parent_pref_hierarchy_id
				, p_type		=> p_type
				, p_edit_allowed	=> p_edit_allowed
				, p_displayed		=> p_displayed
				, p_pref_definition_id	=>  l_pref_definition_id
				, p_attribute_category	   => p_attribute_category
				, p_attribute1		=> l_attribute1
				, p_attribute2		=> l_attribute2
				, p_attribute3		=> l_attribute3
				, p_attribute4		=> l_attribute4
				, p_attribute5		=> l_attribute5
				, p_attribute6		=> l_attribute6
				, p_attribute7		=> p_attribute7
				, p_attribute8		=> p_attribute8
				, p_attribute9		=> p_attribute9
				, p_attribute10		=> p_attribute10
				, p_attribute11		=> p_attribute11
				, p_attribute12		=> p_attribute12
				, p_attribute13		=> p_attribute13
				, p_attribute14		=> p_attribute14
				, p_attribute15		=> p_attribute15
				, p_attribute16		=> p_attribute16
				, p_attribute17		=> p_attribute17
				, p_attribute18		=> p_attribute18
				, p_attribute19		=> p_attribute19
				, p_attribute20		=> p_attribute20
				, p_attribute21		=> p_attribute21
				, p_attribute22		=> p_attribute22
				, p_attribute23		=> p_attribute23
				, p_attribute24		=> p_attribute24
				, p_attribute25		=> p_attribute25
				, p_attribute26		=> p_attribute26
				, p_attribute27		=> p_attribute27
				, p_attribute28		=> p_attribute28
				, p_attribute29		=> p_attribute29
				, p_attribute30		=> p_attribute30
	  			, p_object_version_number  => l_ovn );

Line: 413

SELECT	df.descriptive_flex_context_name
FROM	fnd_descr_flex_contexts_vl df
,	hxc_pref_definitions pd
WHERE	pd.pref_definition_id	= p_pref_definition_id
AND	df.application_id	=809
AND	df.descriptive_flexfield_name  = 'OTC PREFERENCES'
AND	df.descriptive_flex_context_code = pd.code;

Line: 438

SELECT	name
FROM	hxc_approval_styles
WHERE	approval_style_id	= TO_NUMBER(p_attribute);

Line: 443

SELECT	application_set_name
FROM	hxc_application_sets_v
WHERE	application_set_id	= TO_NUMBER(p_attribute);

Line: 448

SELECT	retrieval_rule_group_name
FROM	hxc_retrieval_rule_groups_v
WHERE	retrieval_rule_group_id	= TO_NUMBER(p_attribute);

Line: 453

SELECT	alias_definition_name
FROM	hxc_alias_definitions
WHERE	alias_definition_id	= TO_NUMBER(p_attribute);

Line: 458

SELECT	rp.name
FROM	hxc_recurring_periods rp
WHERE	recurring_period_id = TO_NUMBER(p_attribute);

Line: 463

SELECT	aps.name
FROM	hxc_approval_period_sets aps
WHERE	approval_period_set_id = TO_NUMBER(p_attribute);

Line: 468

SELECT	layout_name
FROM	hxc_layouts
WHERE	layout_id		= TO_NUMBER(p_attribute);

Line: 473

SELECT  egc.attribute2
FROM    hxc_entity_group_comps egc
WHERE   egc.attribute1 = p_attribute
AND EXISTS ( SELECT 'x'
             FROM   hxc_entity_groups eg
             WHERE  eg.entity_group_id = egc.entity_group_id
             AND    eg.entity_type     = 'HXC_SS_TC_DATE_FORMATS' );

Line: 482

SELECT  time_entry_rule_group_name
FROM    hxc_time_entry_rule_groups_v
WHERE   time_entry_rule_group_id = TO_NUMBER(p_attribute);

Line: 579

SELECT	name
,	level
,	rownum cnt
from hxc_pref_hierarchies
start with name = p_top_node
connect by prior pref_hierarchy_id = parent_pref_hierarchy_id;