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
13: from hxc_deposit_processes
13: from hxc_deposit_processes
14: where name = 'OTL Deposit Process';
15:
16: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
17: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
18:
19: begin
20:
21: open c_deposit_process;
128:
129: Procedure update_attributes
130: (p_attributes in out nocopy hxc_attribute_table_type) is
131:
132: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
133:
134: Begin
135:
136: l_app_attributes := hxc_self_service_time_deposit.get_app_attributes;
132: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
133:
134: Begin
135:
136: l_app_attributes := hxc_self_service_time_deposit.get_app_attributes;
137:
138: hxc_app_attribute_utils.update_attributes
139: (p_attributes => p_attributes,
140: p_app_attributes => l_app_attributes
144:
145: Procedure set_attributes
146: (p_blocks in hxc_block_table_type,
147: p_attributes in hxc_attribute_table_type,
148: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
149: p_retrieval_process_id in number,
150: p_recipients in recipient_application_table,
151: p_elp_enabled in boolean
152: ) is
150: p_recipients in recipient_application_table,
151: p_elp_enabled in boolean
152: ) is
153:
154: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
155: l_messages hxc_self_service_time_deposit.message_table;
156:
157: Begin
158:
151: p_elp_enabled in boolean
152: ) is
153:
154: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
155: l_messages hxc_self_service_time_deposit.message_table;
156:
157: Begin
158:
159: if(p_elp_enabled) then
176: p_retrieval_process_id => p_retrieval_process_id
177: );
178: end if;
179:
180: hxc_self_service_time_deposit.initialize_globals;
181: hxc_self_service_time_deposit.set_update_phase(true);
182:
183:
184: hxc_self_service_time_deposit.set_app_hook_params
177: );
178: end if;
179:
180: hxc_self_service_time_deposit.initialize_globals;
181: hxc_self_service_time_deposit.set_update_phase(true);
182:
183:
184: hxc_self_service_time_deposit.set_app_hook_params
185: (p_building_blocks
180: hxc_self_service_time_deposit.initialize_globals;
181: hxc_self_service_time_deposit.set_update_phase(true);
182:
183:
184: hxc_self_service_time_deposit.set_app_hook_params
185: (p_building_blocks
186: => hxc_timecard_block_utils.convert_to_dpwr_blocks(p_blocks),
187: p_app_attributes => l_app_attributes,
188: p_messages => l_messages
188: p_messages => l_messages
189: );
190:
191:
192: hxc_self_service_time_deposit.set_g_attributes
193: (p_attributes => p_old_style_attrs );
194:
195:
196: End set_attributes;
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
204:
205: l_messages := hxc_self_service_time_deposit.get_messages;
206: hxc_timecard_message_utils.append_old_messages
201:
202: l_messages hxc_self_service_time_deposit.message_table;
203: Begin
204:
205: l_messages := hxc_self_service_time_deposit.get_messages;
206: hxc_timecard_message_utils.append_old_messages
207: (p_messages => p_messages,
208: p_old_messages => l_messages,
209: p_retrieval_process_id => p_retrieval_process_id
214: procedure update_phase
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
281: Procedure validate_phase
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,
487:
488: End template_validation;
489:
490: Procedure change_late_audit_validation
491: (p_old_style_blks in hxc_self_service_time_deposit.timecard_info,
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,
488: End template_validation;
489:
490: Procedure change_late_audit_validation
491: (p_old_style_blks in hxc_self_service_time_deposit.timecard_info,
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
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;
501:
502: Begin
503:
504: l_cla_terg_id := to_number(
530:
531: Procedure recipients_update_validation
532: (p_blocks in out nocopy hxc_block_table_type,
533: p_attributes in out nocopy hxc_attribute_table_type,
534: p_old_style_blks in hxc_self_service_time_deposit.timecard_info,
535: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
536: p_props in hxc_timecard_prop_table_type,
537: p_eval_date in date,
538: p_deposit_mode in varchar2,
531: Procedure recipients_update_validation
532: (p_blocks in out nocopy hxc_block_table_type,
533: p_attributes in out nocopy hxc_attribute_table_type,
534: p_old_style_blks in hxc_self_service_time_deposit.timecard_info,
535: p_old_style_attrs in hxc_self_service_time_deposit.building_block_attribute_info,
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,
548: l_application_set_id number;
549: l_elp_terg_id number;
550: l_eval_date date;
551: l_appl_recipients recipient_application_table;
552: l_old_messages hxc_self_service_time_deposit.message_table;
553: l_otm_attributes hxc_self_service_time_deposit.app_attributes_info;
554: l_timecard_start_time date;
555: l_timecard_stop_time date;
556: l_projects_tr_id number;
549: l_elp_terg_id number;
550: l_eval_date date;
551: l_appl_recipients recipient_application_table;
552: l_old_messages hxc_self_service_time_deposit.message_table;
553: l_otm_attributes hxc_self_service_time_deposit.app_attributes_info;
554: l_timecard_start_time date;
555: l_timecard_stop_time date;
556: l_projects_tr_id number;
557: l_validate_on_save hxc_pref_hierarchies.attribute1%type;
554: l_timecard_start_time date;
555: l_timecard_stop_time date;
556: l_projects_tr_id number;
557: l_validate_on_save hxc_pref_hierarchies.attribute1%type;
558: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
559: l_messages hxc_self_service_time_deposit.message_table;
560:
561: Begin
562:
555: l_timecard_stop_time date;
556: l_projects_tr_id number;
557: l_validate_on_save hxc_pref_hierarchies.attribute1%type;
558: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
559: l_messages hxc_self_service_time_deposit.message_table;
560:
561: Begin
562:
563: open c_pa_tr_id;
684: -- added calls to set_update_phase and set_g_attributes
685: -- otherwise g_attributes and g_timecard are not available to
686: -- TER when no recipient validation is called
687:
688: hxc_self_service_time_deposit.set_update_phase(true);
689:
690: hxc_self_service_time_deposit.set_app_hook_params
691: (p_building_blocks => p_old_style_blks
692: ,p_app_attributes => l_app_attributes
686: -- TER when no recipient validation is called
687:
688: hxc_self_service_time_deposit.set_update_phase(true);
689:
690: hxc_self_service_time_deposit.set_app_hook_params
691: (p_building_blocks => p_old_style_blks
692: ,p_app_attributes => l_app_attributes
693: ,p_messages => l_messages );
694:
691: (p_building_blocks => p_old_style_blks
692: ,p_app_attributes => l_app_attributes
693: ,p_messages => l_messages );
694:
695: hxc_self_service_time_deposit.set_update_phase(false);
696:
697: hxc_self_service_time_deposit.set_g_attributes
698: ( p_attributes => p_old_style_attrs );
699:
693: ,p_messages => l_messages );
694:
695: hxc_self_service_time_deposit.set_update_phase(false);
696:
697: hxc_self_service_time_deposit.set_g_attributes
698: ( p_attributes => p_old_style_attrs );
699:
700: -- GPM v115.26 end
701:
762: p_resubmit in varchar2
763: ) is
764:
765: l_eval_date date;
766: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
767: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
768:
769: Begin
770: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks(p_blocks);
763: ) is
764:
765: l_eval_date date;
766: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
767: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
768:
769: Begin
770: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks(p_blocks);
771: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes(p_attributes);
839: ) is
840:
841: l_tc_start_date date;
842: l_tc_end_date date;
843: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
844: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
845:
846: Begin
847: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
840:
841: l_tc_start_date date;
842: l_tc_end_date date;
843: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
844: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
845:
846: Begin
847: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
848: (p_blocks);