[Home] [Help]
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7:
8: Function get_otm_app_attributes
9: (p_attributes in hxc_attribute_table_type,
10: p_messages in out nocopy hxc_message_table_type)
11: return hxc_self_service_time_deposit.app_attributes_info is
12:
13: cursor c_deposit_process is
14: select deposit_process_id
197:
198: End set_attributes;
199:
200: Procedure update_messages
201: (p_messages in out nocopy hxc_message_table_type,
202: p_retrieval_process_id in number) is
203:
204: l_messages hxc_self_service_time_deposit.message_table;
205: Begin
217: (p_recipients in recipient_application_table,
218: p_blocks in hxc_block_table_type,
219: p_attributes in out nocopy hxc_attribute_table_type,
220: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
221: p_messages in out nocopy hxc_message_table_type,
222: p_deposit_mode in varchar2,
223: p_projects_tr_id in number,
224: p_validate_on_save in varchar2
225: ) is
284: (p_recipients in recipient_application_table,
285: p_blocks in hxc_block_table_type,
286: p_attributes in out nocopy hxc_attribute_table_type,
287: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
288: p_messages in out nocopy hxc_message_table_type,
289: p_deposit_mode in varchar2,
290: p_elp_terg_id in number,
291: p_projects_tr_id in number,
292: p_validate_on_save in varchar2
436:
437: Procedure template_validation
438: (p_blocks in out nocopy hxc_block_table_type,
439: p_attributes in out nocopy hxc_attribute_table_type,
440: p_messages in out nocopy hxc_message_table_type,
441: p_can_deposit out nocopy boolean
442: ) is
443:
444: l_template_index number;
494: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
495: p_props in hxc_timecard_prop_table_type,
496: p_eval_start_date in date,
497: p_eval_end_date in date,
498: p_messages in out nocopy hxc_message_table_type
499: ) is
500:
501: l_cla_terg_id number;
502: l_old_messages hxc_self_service_time_deposit.message_table;
538: p_props in hxc_timecard_prop_table_type,
539: p_eval_date in date,
540: p_deposit_mode in varchar2,
541: p_resubmit in varchar2,
542: p_messages in out nocopy hxc_message_table_type
543: ) is
544:
545: cursor c_pa_tr_id is
546: select time_recipient_id
835:
836: Procedure recipients_update_validation
837: (p_blocks in out nocopy hxc_block_table_type,
838: p_attributes in out nocopy hxc_attribute_table_type,
839: p_messages in out nocopy hxc_message_table_type,
840: p_props in hxc_timecard_prop_table_type,
841: p_deposit_mode in varchar2,
842: p_resubmit in varchar2
843: ) is
866: End recipients_update_validation;
867:
868: Procedure data_set_validation
869: (p_blocks in out nocopy hxc_block_table_type,
870: p_messages in out nocopy hxc_message_table_type
871: ) is
872:
873: cursor c_data_set( p_stop_time date) is
874: select 1
911:
912: Procedure timecard_validation
913: (p_blocks in out nocopy hxc_block_table_type,
914: p_attributes in out nocopy hxc_attribute_table_type,
915: p_messages in out nocopy hxc_message_table_type,
916: p_props in hxc_timecard_prop_table_type,
917: p_deposit_mode in varchar2,
918: p_resubmit in varchar2
919: ) is
965:
966: procedure deposit_validation
967: (p_blocks in out nocopy hxc_block_table_type,
968: p_attributes in out nocopy hxc_attribute_table_type,
969: p_messages in out nocopy hxc_message_table_type,
970: p_props in hxc_timecard_prop_table_type,
971: p_deposit_mode in varchar2,
972: p_template in varchar2,
973: p_resubmit in varchar2,