[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select deposit_process_id
from hxc_deposit_processes
where name = 'OTL Deposit Process';
l_sql := 'select retrieval_process_id
from hxc_retrieval_processes
where time_recipient_id = '|| p_time_recipient_id
||' and name = '||p_retrieval_function;
select tr.time_recipient_id,
tr.name,
tr.application_retrieval_function,
tr.application_update_process,
tr.appl_validation_process
from hxc_time_recipients tr,
hxc_application_set_comps_v asc1
where p_application_set_id = asc1.application_set_id
and asc1.time_recipient_id = tr.time_recipient_id
and tr.application_retrieval_function is not null;
l_appl_recipients(l_index).application_update_process
:= recip_rec.application_update_process;
Procedure update_attributes
(p_attributes in out nocopy hxc_attribute_table_type) is
l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
hxc_app_attribute_utils.update_attributes
(p_attributes => p_attributes,
p_app_attributes => l_app_attributes
);
End update_attributes;
hxc_self_service_time_deposit.set_update_phase(true);
Procedure update_messages
(p_messages in out nocopy hxc_message_table_type,
p_retrieval_process_id in number) is
l_messages hxc_self_service_time_deposit.message_table;
End update_messages;
procedure update_phase
(p_recipients in recipient_application_table,
p_blocks in hxc_block_table_type,
p_attributes in out nocopy hxc_attribute_table_type,
p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
p_messages in out nocopy hxc_message_table_type,
p_deposit_mode in varchar2,
p_projects_tr_id in number,
p_validate_on_save in varchar2
) is
l_elp_blocks hxc_block_table_type;
if((p_recipients(l_index).application_update_process is not null)
AND
(p_recipients(l_index).appl_retrieval_process_id is not null)) then
if((p_deposit_mode <> hxc_timecard.c_save)
OR(
(p_deposit_mode = hxc_timecard.c_save)
AND
(p_recipients(l_index).time_recipient_id = p_projects_tr_id)
)
OR(
(p_deposit_mode = hxc_timecard.c_save)
AND
(p_validate_on_save = hxc_timecard.c_yes)
)) then
set_attributes
(p_blocks,
p_attributes,
p_old_style_attrs,
p_recipients(l_index).appl_retrieval_process_id,
p_recipients,
false
);
||p_recipients(l_index).application_update_process ||fnd_global.newline
||'(p_operation => :1);'||fnd_global.newline
update_attributes(p_attributes);
update_messages
(p_messages,
p_recipients(l_index).appl_retrieval_process_id
);
End update_phase;
update_messages
(p_messages,
p_recipients(l_index).appl_retrieval_process_id
);
select 'Y'
from hr_lookups
where lookup_type = 'HXC_DYNAMIC_TEMPLATES'
and meaning = p_name_to_check;
select 'Y'
from hxc_template_summary
where template_type = 'PRIVATE'
and template_id <> p_time_building_block_id
and template_name = p_name_to_check
and resource_id = p_resource_id;
select 'Y'
from hxc_template_summary
where template_type = 'PUBLIC'
and template_id <> p_time_building_block_id
and template_name = p_name_to_check
and business_group_id =p_business_group_id ;
Procedure recipients_update_validation
(p_blocks in out nocopy hxc_block_table_type,
p_attributes in out nocopy hxc_attribute_table_type,
p_old_style_blks in hxc_self_service_time_deposit.timecard_info,
p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
p_props in hxc_timecard_prop_table_type,
p_eval_date in date,
p_deposit_mode in varchar2,
p_resubmit in varchar2,
p_messages in out nocopy hxc_message_table_type
) is
cursor c_pa_tr_id is
select time_recipient_id
from hxc_time_recipients
where upper(name) = 'PROJECTS';
update_phase
(l_appl_recipients,
p_blocks,
p_attributes,
p_old_style_attrs,
p_messages,
p_deposit_mode,
l_projects_tr_id,
l_validate_on_save
);
l_old_messages.delete;
hxc_self_service_time_deposit.set_update_phase(true);
hxc_self_service_time_deposit.set_update_phase(false);
l_old_messages.delete;
End recipients_update_validation;
Procedure recipients_update_validation
(p_blocks in out nocopy hxc_block_table_type,
p_attributes in out nocopy hxc_attribute_table_type,
p_messages in out nocopy hxc_message_table_type,
p_props in hxc_timecard_prop_table_type,
p_deposit_mode in varchar2,
p_resubmit in varchar2
) is
l_eval_date date;
recipients_update_validation
(p_blocks => p_blocks,
p_attributes => p_attributes,
p_old_style_blks => l_old_style_blks,
p_old_style_attrs => l_old_style_attrs,
p_props => p_props,
p_eval_date => l_eval_date,
p_deposit_mode => p_deposit_mode,
p_resubmit => p_resubmit,
p_messages => p_messages
);
End recipients_update_validation;
select 1
from hxc_data_sets d
where p_stop_time between d.start_date and d.end_date
and status in ('OFF_LINE','BACKUP_IN_PROGRESS','RESTORE_IN_PROGRESS');
recipients_update_validation
(p_blocks => p_blocks,
p_attributes => p_attributes,
p_old_style_blks => l_old_style_blks,
p_old_style_attrs => l_old_style_attrs,
p_props => p_props,
p_eval_date => l_tc_start_date,
p_deposit_mode => p_deposit_mode,
p_resubmit => p_resubmit,
p_messages => p_messages
);
if(p_deposit_mode <> hxc_timecard.c_delete) then
template_validation
(p_blocks => p_blocks,
p_attributes => p_attributes,
p_messages => p_messages,
p_can_deposit=> p_can_deposit
);