The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT retrieval_process_id
FROM hxc_retrieval_processes
WHERE NAME = v_retrieval_process_name;
SELECT has.approval_style_id
FROM hxc_approval_styles has
WHERE has.NAME = p_name;
l_resubmit := hxc_timecard.c_delete;
hxc_timecard_summary_pkg.update_summary_row
(p_timecard_id => p_timecard_id,
p_approval_item_type => 'HXCEMP',
p_approval_process_name => 'HXC_APPROVAL',
p_approval_item_key => l_item_key
);
hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');
hxc_retrieve_absences.insert_absence_summary_row;
hxc_block_attribute_update.set_process_flags
(p_blocks => p_blocks,
p_attributes => p_attributes
);
hxc_timecard_attribute_utils.remove_deleted_attributes
(p_attributes => p_attributes);
hr_utility.trace('SVG: Rollingback to savepoint TC_SAVE_SAVEPOINT for any Projects related updates');
l_resubmit := hxc_timecard.c_delete;
hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');
hxc_retrieve_absences.insert_absence_summary_row;
hxc_block_attribute_update.denormalize_time (p_blocks => p_blocks,
p_mode => 'ADD'
);
hxc_block_attribute_update.set_process_flags
(p_blocks => p_blocks,
p_attributes => p_attributes
);
hxc_timecard_attribute_utils.remove_deleted_attributes
(p_attributes => p_attributes);
hxc_block_attribute_update.denormalize_time (p_blocks => p_blocks,
p_mode => 'REMOVE'
);
hr_utility.trace('SVG: Rollingback to savepoint TC_SUB_SAVEPOINT for any Projects related updates');
hxc_timecard_summary_pkg.update_summary_row
(p_timecard_id => p_timecard_id,
p_approval_item_type => p_item_type,
p_approval_process_name => p_approval_prc,
p_approval_item_key => l_item_key
);
PROCEDURE update_value (
p_attributes IN OUT NOCOPY hxc_attribute_table_type,
p_index IN NUMBER,
p_segment IN hxc_mapping_components.SEGMENT%TYPE,
p_value IN hxc_time_attributes.attribute1%TYPE
)
IS
BEGIN
IF (p_segment = 'ATTRIBUTE1')
THEN
p_attributes (p_index).attribute1 := p_value;
END update_value;
select 'Y' into l_dummy
from fnd_descr_flex_contexts
where application_id = 809
and descriptive_flexfield_name = 'OTC Information Types'
and enabled_flag = 'Y'
and descriptive_flex_context_code like p_context_prefix||'%GLOBAL%';
SELECT d.default_context_field_name
FROM fnd_descriptive_flexs d, fnd_application a, fnd_product_installations z
WHERE d.application_id = a.application_id
AND z.application_id = a.application_id
AND a.application_short_name = 'PA'
AND z.status = 'I'
AND d.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX';
p_app_attributes (l_index).updated := 'Y';
IF (NVL (p_app_attributes (l_index).updated, 'N') = 'N')
THEN
create_new_attribute (p_attributes => p_attributes,
p_app_attributes => p_app_attributes,
p_app_index => l_index
);
p_app_attributes (l_index).updated := 'Y';
SELECT tbb.time_building_block_id,
MAX (tbb.object_version_number)
FROM hxc_time_building_blocks tbb, hxc_time_building_blocks parent_tbb
WHERE tbb.SCOPE = v_scope
AND tbb.resource_type = v_resource_type
AND tbb.resource_id = v_resource_id
AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time
AND tbb.date_to = hr_general.end_of_time
AND parent_tbb.time_building_block_id = tbb.parent_building_block_id
AND parent_tbb.object_version_number = tbb.parent_building_block_ovn
AND parent_tbb.date_to = hr_general.end_of_time
AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope
GROUP BY tbb.time_building_block_id;
SELECT time_attribute_id, attribute_category, 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,
MAX (object_version_number)
FROM hxc_time_attributes
WHERE time_attribute_id = p_attr_id
GROUP BY time_attribute_id,
attribute_category,
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;
SELECT time_building_block_id, MAX (object_version_number)
FROM hxc_time_building_blocks
WHERE SCOPE = hxc_timecard.c_timecard_scope
AND date_to = hr_general.end_of_time
CONNECT BY PRIOR parent_building_block_id = time_building_block_id
AND PRIOR parent_building_block_ovn = object_version_number
START WITH time_building_block_id = v_tc_id
GROUP BY time_building_block_id
ORDER BY time_building_block_id;
SELECT deposit_process_id
FROM hxc_deposit_processes
WHERE NAME = v_deposit_process_name;
SELECT time_building_block_id, MAX (object_version_number)
FROM hxc_time_building_blocks
WHERE SCOPE = DECODE (v_scope, 'DAY', 'TIMECARD', 'DETAIL', 'DAY')
AND v_start_time >= start_time
AND v_stop_time <= stop_time
AND v_resource_id = resource_id
AND v_resource_type = resource_type
AND date_to = hr_general.end_of_time
GROUP BY time_building_block_id;
SELECT bbit.bld_blk_info_type, mc.SEGMENT
FROM hxc_mapping_components mc,
hxc_mapping_comp_usages mcu,
hxc_mappings m,
hxc_deposit_processes dp,
hxc_bld_blk_info_types bbit,
hxc_bld_blk_info_type_usages bbui
WHERE dp.mapping_id = m.mapping_id
AND m.mapping_id = mcu.mapping_id
AND mcu.mapping_component_id = mc.mapping_component_id
AND mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
AND bbit.bld_blk_info_type_id = bbui.bld_blk_info_type_id
AND mc.field_name = v_field_name
AND dp.deposit_process_id = v_deposit_process_id;
p_app_blocks.DELETE;
p_app_attributes.DELETE;
p_messages.DELETE;
|| RPAD (p_app_attributes (j).updated, 2)
|| ' '
|| RPAD (p_app_attributes (j).changed, 2)
|| ' '
);
SELECT MAX (htbb.resource_id)
INTO l_resource_id
FROM hxc_time_building_blocks htbb
WHERE htbb.time_building_block_id = p_building_block_id
AND resource_type = 'PERSON';