[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_user_list_sql := 'SELECT distinct hta.'
|| p_flex_segment
|| ' FROM hxc_time_building_blocks htbb_detail, '
|| 'hxc_time_attribute_usages htau, '
|| 'hxc_time_attributes hta'
|| ' WHERE htbb_detail.resource_id = '
|| ':p_resource_id'
|| ' AND htbb_detail.date_to = hr_general.end_of_time'
|| ' AND htau.time_building_block_id = htbb_detail.time_building_block_id'
|| ' AND htau.time_building_block_ovn = htbb_detail.object_version_number'
|| ' AND htau.time_attribute_id = hta.time_attribute_id'
|| ' AND hta.attribute_category = '
|| ':p_flex_context';
l_select_st varchar2(10000);
l_complete_select_st VARCHAR2(32767) := '';
fnd_flex_val_api.get_table_vset_select(
p_value_set_id => l_vset.vsid,
p_check_enabled_flag => 'N',
p_check_validation_date => 'N',
p_inc_addtl_where_clause => 'N',
x_select => l_select_st,
x_mapping_code => l_mapping_code,
x_success =>l_flag
);
IF (l_select_st is not null)
THEN
-- Append where clause for meaning
l_meaning_column := l_vset.table_info.meaning_column_name;
l_complete_select_st :=
l_select_st;
l_complete_select_st :=
l_complete_select_st ||
' and (' ||
l_value_column ||
' ' ||
p_operator ||
'''' ||
l_like ||
p_flex_search_value ||
l_like ||
'''' ||
' OR ' ||
l_meaning_column ||
' ' ||
p_operator ||
'''' ||
l_like ||
p_flex_search_value ||
l_like ||
''')';
l_complete_select_st :=
l_complete_select_st ||
' and (' ||
l_value_column ||
' ' ||
p_operator ||
'''' ||
l_like ||
p_flex_search_value ||
l_like ||
''')';
l_complete_select_st :=
l_complete_select_st ||
' AND ' ||
l_id_column ||
' IN (' ||
l_user_value_list ||
')';
l_complete_select_st :=
l_complete_select_st ||
' AND ' ||
l_value_column ||
' IN (' ||
l_user_value_list ||
')';
OPEN l_valcursor FOR l_complete_select_st;
OPEN l_valcursor FOR l_complete_select_st;
OPEN l_valcursor FOR l_complete_select_st;
open l_valcursor for l_complete_select_st;
select hr_general.decode_lookup('HXC_APPROVAL_STATUS',l_status_code) into l_status_meaning
from dual;
SELECT 'Yes'
FROM DUAL
WHERE EXISTS ( SELECT '1'
FROM hxc_time_building_blocks days,
hxc_time_building_blocks details,
hxc_time_attribute_usages tau,
hxc_time_attributes ta
WHERE tau.time_building_block_id =
details.time_building_block_id
AND tau.time_building_block_ovn =
details.object_version_number
AND tau.time_attribute_id = ta.time_attribute_id
AND ta.attribute_category = 'REASON'
AND details.scope = 'DETAIL'
-- AND details.date_to = hr_general.end_of_time
AND details.parent_building_block_id =
days.time_building_block_id
-- AND details.parent_building_block_ovn =
-- days.object_version_number
AND days.scope = 'DAY'
-- AND days.date_to = hr_general.end_of_time
AND days.parent_building_block_id = p_timecard_id
AND days.parent_building_block_ovn = p_timecard_ovn);
select approval_status
from hxc_timecard_summary
where timecard_id = p_timecard_id
and timecard_ovn = p_timecard_ovn;
select approval_status
from hxc_timecard_summary
where timecard_id = p_timecard_id;
select approval_status
from hxc_time_building_blocks tbb1
where tbb1.time_building_block_id = p_timecard_id
and tbb1.object_version_number =
(select max(tbb2.object_version_number)
from hxc_time_building_blocks tbb2
where tbb2.time_building_block_Id = tbb1.time_building_block_id
);
* a timecard status for a deleted timecard. The view will ultimately
* filter out the timecard, so we can simply return the last status
* when the timecard was deleted without fear.
*/
open c_last_timecard_status(bb_id);
select
hap.approval_status
,hap.start_time
,hap.stop_time
from
hxc_time_building_blocks hap
where
hap.scope = 'APPLICATION_PERIOD'
and hap.type = 'RANGE'
and hap.date_to = hr_general.end_of_time
and hap.resource_type = 'PERSON'
and hap.start_time <= p_tc_stop_time
and hap.stop_time >= p_tc_start_time
and hap.resource_id = p_resource_id
and hap.creation_date >= p_approval_after;
select max(details.creation_date)
from hxc_time_building_blocks details
,hxc_time_building_blocks days
where days.parent_building_block_id = p_timecard_id
and days.parent_building_block_ovn = p_timecard_ovn
and days.scope = 'DAY'
and days.date_to = hr_general.end_of_time
and details.parent_building_block_id = days.time_building_block_id
and details.parent_building_block_ovn = days.object_version_number
and details.date_to = hr_general.end_of_time
and details.scope = 'DETAIL';
select max(creation_date)
from hxc_time_building_blocks
where parent_building_block_id = p_timecard_id
and parent_building_block_ovn = p_timecard_ovn
and scope = 'DAY'
and date_to = hr_general.end_of_time;
select approval_status, start_time, stop_time, resource_id into l_tcstatus, l_start_time, l_stop_time, l_resource_id
from hxc_time_building_blocks
where time_building_block_id = bb_id
and object_version_number = bb_ovn;
l_alias_sql := 'SELECT attribute1'
|| ' FROM hxc_alias_values_v'
||' WHERE alias_definition_id = :p_alias_definition_id'
|| ' AND alias_value_name '
|| p_search_operator
|| ':l_like_string||:p_search_value||:l_like_string';
SELECT timecard_field
FROM hxc_alias_definitions
WHERE alias_definition_id = p_alias_definition_id;
l_sql_select VARCHAR2(1000);
SELECT context, segment, bld_blk_info_type_id
FROM hxc_mapping_attributes_v
WHERE map = 'OTL Deposit Process Mapping'
AND upper(field_name) = upper(p_field_name);
l_sql_select := 'SELECT distinct hrt.timecard_id'
|| ' ,hrt.timecard_ovn'
|| ' ,hxc_timecard_search_pkg.get_timecard_status_code('
|| ' hrt.timecard_id, '
|| ' hrt.timecard_ovn'
|| ' ) as status_code'
|| ' ,hxc_timecard_search_pkg.get_timecard_status_meaning('
|| ' hrt.timecard_id, '
|| ' hrt.timecard_ovn'
|| ' ) as status_name'
|| ' ,hrt.period_starts'
|| ' ,hrt.period_ends'
|| ' ,hrt.hours_worked'
|| ' ,hrt.submission_date';
l_complete_sql := l_sql_select
|| ' '
|| l_sql_from
|| ' '
|| l_sql_where;
l_sql_select VARCHAR2(1000);
SELECT context, segment, bld_blk_info_type_id
FROM hxc_mapping_attributes_v
WHERE map = 'OTL Deposit Process Mapping'
AND upper(field_name) = upper(p_field_name);