[Home] [Help]
4: type retrieval_ref_cursor IS ref cursor;
5:
6: Function get_otm_app_attributes
7: (p_attributes in hxc_attribute_table_type,
8: p_messages in out nocopy hxc_message_table_type)
9: return hxc_self_service_time_deposit.app_attributes_info is
10:
11: cursor c_deposit_process is
12: select deposit_process_id
195:
196: End set_attributes;
197:
198: Procedure update_messages
199: (p_messages in out nocopy hxc_message_table_type,
200: p_retrieval_process_id in number) is
201:
202: l_messages hxc_self_service_time_deposit.message_table;
203: Begin
215: (p_recipients in recipient_application_table,
216: p_blocks in hxc_block_table_type,
217: p_attributes in out nocopy hxc_attribute_table_type,
218: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
219: p_messages in out nocopy hxc_message_table_type,
220: p_deposit_mode in varchar2,
221: p_projects_tr_id in number,
222: p_validate_on_save in varchar2
223: ) is
282: (p_recipients in recipient_application_table,
283: p_blocks in hxc_block_table_type,
284: p_attributes in out nocopy hxc_attribute_table_type,
285: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
286: p_messages in out nocopy hxc_message_table_type,
287: p_deposit_mode in varchar2,
288: p_elp_terg_id in number,
289: p_projects_tr_id in number,
290: p_validate_on_save in varchar2
434:
435: Procedure template_validation
436: (p_blocks in out nocopy hxc_block_table_type,
437: p_attributes in out nocopy hxc_attribute_table_type,
438: p_messages in out nocopy hxc_message_table_type,
439: p_can_deposit out nocopy boolean
440: ) is
441:
442: l_template_index number;
492: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
493: p_props in hxc_timecard_prop_table_type,
494: p_eval_start_date in date,
495: p_eval_end_date in date,
496: p_messages in out nocopy hxc_message_table_type
497: ) is
498:
499: l_cla_terg_id number;
500: l_old_messages hxc_self_service_time_deposit.message_table;
536: p_props in hxc_timecard_prop_table_type,
537: p_eval_date in date,
538: p_deposit_mode in varchar2,
539: p_resubmit in varchar2,
540: p_messages in out nocopy hxc_message_table_type
541: ) is
542:
543: cursor c_pa_tr_id is
544: select time_recipient_id
755:
756: Procedure recipients_update_validation
757: (p_blocks in out nocopy hxc_block_table_type,
758: p_attributes in out nocopy hxc_attribute_table_type,
759: p_messages in out nocopy hxc_message_table_type,
760: p_props in hxc_timecard_prop_table_type,
761: p_deposit_mode in varchar2,
762: p_resubmit in varchar2
763: ) is
786: End recipients_update_validation;
787:
788: Procedure data_set_validation
789: (p_blocks in out nocopy hxc_block_table_type,
790: p_messages in out nocopy hxc_message_table_type
791: ) is
792:
793: cursor c_data_set( p_stop_time date) is
794: select 1
831:
832: Procedure timecard_validation
833: (p_blocks in out nocopy hxc_block_table_type,
834: p_attributes in out nocopy hxc_attribute_table_type,
835: p_messages in out nocopy hxc_message_table_type,
836: p_props in hxc_timecard_prop_table_type,
837: p_deposit_mode in varchar2,
838: p_resubmit in varchar2
839: ) is
885:
886: procedure deposit_validation
887: (p_blocks in out nocopy hxc_block_table_type,
888: p_attributes in out nocopy hxc_attribute_table_type,
889: p_messages in out nocopy hxc_message_table_type,
890: p_props in hxc_timecard_prop_table_type,
891: p_deposit_mode in varchar2,
892: p_template in varchar2,
893: p_resubmit in varchar2,