eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_LOAD_PKG SQL Statements

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

Line: 11


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: 38


SELECT	name
FROM	hxc_retrieval_rules
WHERE	RETRIEVAL_RULE_ID	= TO_NUMBER(p_attribute);

Line: 43


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

Line: 48


SELECT	aps.application_set_name
FROM	(SELECT heg.rowid row_id ,heg.ENTITY_GROUP_ID application_set_id ,heg.NAME application_set_name ,heg.OBJECT_VERSION_NUMBER ,heg.CREATED_BY ,
                heg.CREATION_DATE ,heg.LAST_UPDATED_BY ,heg.LAST_UPDATE_DATE ,heg.LAST_UPDATE_LOGIN
	 FROM hxc_entity_groups heg
	 WHERE heg.entity_type = 'TIME_RECIPIENTS') APS
WHERE	aps.application_set_id	= TO_NUMBER(p_attribute);

Line: 56


SELECT	ret.retrieval_rule_group_name
FROM	(SELECT heg.rowid row_id ,heg.ENTITY_GROUP_ID retrieval_rule_group_id ,heg.NAME retrieval_rule_group_name ,heg.OBJECT_VERSION_NUMBER ,heg.CREATED_BY ,heg.CREATION_DATE ,
                heg.LAST_UPDATED_BY ,heg.LAST_UPDATE_DATE ,heg.LAST_UPDATE_LOGIN
	  FROM hxc_entity_groups heg
	  WHERE heg.entity_type = 'RETRIEVAL_RULES') RET
WHERE	ret.retrieval_rule_group_id	= TO_NUMBER(p_attribute);

Line: 64


select heg.name  FROM hxc_entity_groups heg where
 heg.entity_type = 'PUBLIC_TEMPLATE_GROUP' and
 heg.ENTITY_GROUP_ID= TO_NUMBER(p_attribute);

Line: 69


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

Line: 74


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

Line: 79


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

Line: 84


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

Line: 89


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: 99


SELECT  ter.time_entry_rule_group_name
FROM    (SELECT heg.rowid row_id ,heg.ENTITY_GROUP_ID time_entry_rule_group_id ,heg.NAME time_entry_rule_Group_name ,
                heg.OBJECT_VERSION_NUMBER ,heg.CREATED_BY ,heg.CREATION_DATE ,heg.LAST_UPDATED_BY ,heg.LAST_UPDATE_DATE ,heg.LAST_UPDATE_LOGIN
	 FROM hxc_entity_groups heg
	 WHERE heg.entity_type = 'TIME_ENTRY_RULES') TER
WHERE   ter.time_entry_rule_group_id = TO_NUMBER(p_attribute);

Line: 226


   l_select_clause VARCHAR2(2000);

Line: 253


      select 'SELECT ' ||
          l_valueset_r.table_info.value_column_name ||
          decode(l_valueset_r.table_info.meaning_column_name,null,',NULL ',
                 ','||l_valueset_r.table_info.meaning_column_name)||
          decode(l_valueset_r.table_info.id_column_name,null,',NULL ',
                 ','||l_valueset_r.table_info.id_column_name)||
                 ' FROM ' ||
                 l_valueset_r.table_info.table_name || ' ' ||
                 l_valueset_r.table_info.where_clause
      into l_sql_text
      from dual;

Line: 279


        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                    meaning_column_name||' ';

Line: 282


        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                      value_column_name||' ';

Line: 286


     l_sql_text_id := l_select_clause||l_from_where;

Line: 291


     l_sql_text_id   := l_select_clause||l_from_where ||'WHERE '||l_valueset_r.table_info.id_column_name||' = ';

Line: 295


     l_sql_text_id   := l_select_clause||l_from_where ||'and '||l_valueset_r.table_info.id_column_name||' = ';

Line: 307


         l_sql_text_id := 'SELECT FLEX_VALUE'||
                       ' FROM FND_FLEX_VALUES_VL'||
                       ' WHERE FLEX_VALUE_SET_ID =' || l_value_set_id ||
                       ' AND ENABLED_FLAG = ''Y'''||
                       ' AND '''||P_SESSION_DATE||''' BETWEEN'||
                       ' NVL(START_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND NVL(END_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND FLEX_VALUE = ';

Line: 344


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;

Line: 428


select   pett.element_name Display_Value
from     pay_element_types_f_tl pett
where pett.element_type_id = p_element_type_id
and   pett.language = USERENV('LANG');

Line: 586


       SELECT pref_hierarchy_id,object_version_number
       FROM   hxc_pref_hierarchies
       WHERE  parent_pref_hierarchy_id is null
       AND    name = l_name;

Line: 592


       SELECT pref_hierarchy_id,object_version_number
       FROM   hxc_pref_hierarchies
       WHERE  parent_pref_hierarchy_id = l_parent_pref_hierarchy_id
       AND    name = l_name;

Line: 656


       l_mode                     := 'UPDATE';

Line: 658


       l_mode                     := 'INSERT';

Line: 671


        l_mode := 'INSERT';

Line: 673


        l_mode := 'UPDATE';

Line: 700


select formula_name
from ff_formulas_f
where formula_id=p_formula_id;

Line: 705


select FLEX_VALUE_SET_ID
from fnd_descr_flex_col_usage_vl
where descriptive_flexfield_name = 'OTL Formulas'
and application_id = 809
and descriptive_flex_context_code =p_formula_name
and enabled_flag = 'Y'
and APPLICATION_COLUMN_NAME =p_attribute_name;

Line: 781


   l_select_clause VARCHAR2(2000);

Line: 808


      select 'SELECT ' ||
          l_valueset_r.table_info.value_column_name ||
          decode(l_valueset_r.table_info.meaning_column_name,null,',NULL ',
                 ','||l_valueset_r.table_info.meaning_column_name)||
          decode(l_valueset_r.table_info.id_column_name,null,',NULL ',
                 ','||l_valueset_r.table_info.id_column_name)||
                 ' FROM ' ||
                 l_valueset_r.table_info.table_name || ' ' ||
                 l_valueset_r.table_info.where_clause
      into l_sql_text
      from dual;

Line: 833


        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                    id_column_name||' ';

Line: 838


        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                    meaning_column_name||' ';

Line: 841


        l_select_clause := 'SELECT '||l_valueset_r.table_info.
                                                      value_column_name||' ';

Line: 845


     l_sql_text_id := l_select_clause||l_from_where;

Line: 851


     l_sql_text_id   := l_select_clause||l_from_where ||'WHERE '||l_valueset_r.table_info.value_column_name||' = ';

Line: 855


     l_sql_text_id   := l_select_clause||l_from_where ||'and '||l_valueset_r.table_info.value_column_name||' = ';

Line: 867


         l_sql_text_id := 'SELECT FLEX_VALUE'||
                       ' FROM FND_FLEX_VALUES_VL'||
                       ' WHERE FLEX_VALUE_SET_ID =' || l_value_set_id ||
                       ' AND ENABLED_FLAG = ''Y'''||
                       ' AND '''||P_SESSION_DATE||''' BETWEEN'||
                       ' NVL(START_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND NVL(END_DATE_ACTIVE,'''||
                                     P_SESSION_DATE||''')'||
                       ' AND FLEX_VALUE = ';

Line: 895


select FLEX_VALUE_SET_ID
from fnd_descr_flex_col_usage_vl
where descriptive_flexfield_name = 'OTL Formulas'
and application_id = 809
and descriptive_flex_context_code =p_formula_name
and enabled_flag = 'Y'
and APPLICATION_COLUMN_NAME =p_attribute_name;

Line: 954


SELECT  operator
FROM    hxc_time_categories
WHERE   time_category_id = p_time_category_id;

Line: 960


SELECT
	bbit.bld_blk_info_type context
,	bbit.bld_blk_info_type_id
,	mpc.segment
,	NVL(tcc.value_id, DECODE(tcc.is_null, 'N', '', '')) value_id
,	tcc.ref_time_category_id
,	tcc.flex_value_set_id
,       tcc.equal_to
FROM
        hxc_bld_blk_info_types bbit
,       hxc_mapping_components mpc
,       hxc_time_category_comps tcc
WHERE	tcc.time_category_id = p_time_category_id AND
        tcc.type = 'MC'
AND
        mpc.mapping_component_id (+) = tcc.component_type_id
AND
        bbit.bld_blk_info_type_id (+) = mpc.bld_blk_info_type_id;

Line: 984


l_last_update_date   DATE;

Line: 995


l_sql   LONG := 'select distinct ta.bb_id from hxc_tmp_atts ta where '||p_sql_string;

Line: 1009


INSERT INTO hxc_tmp_atts (
      ta_id
,     bb_id
,     attribute1
,     attribute2
,     attribute3
,     attribute4
,     attribute5
,     attribute6
,     attribute7
,     attribute8
,     attribute9
,     attribute10
,     attribute11
,     attribute12
,     attribute13
,     attribute14
,     attribute15
,     attribute16
,     attribute17
,     attribute18
,     attribute19
,     attribute20
,     attribute21
,     attribute22
,     attribute23
,     attribute24
,     attribute25
,     attribute26
,     attribute27
,     attribute28
,     attribute29
,     attribute30
,     bld_blk_info_type_id
,     attribute_category )
VALUES (
      1
,     2
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     'Dummy'
,     1
,     'Dummy' );

Line: 1113


		t_bb_id.DELETE;

Line: 1507


UPDATE hxc_time_categories
SET    time_sql = l_time_sql
WHERE  time_category_id = p_time_category_id;