12: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
13: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
14: ) is
15:
16: l_old_style_attr HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
17: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
18:
19: l_proc varchar2(80) := g_package||'.alias_translation';
20:
13: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
14: ) is
15:
16: l_old_style_attr HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
17: l_old_style_blks HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
18:
19: l_proc varchar2(80) := g_package||'.alias_translation';
20:
21: Begin
45: select deposit_process_id
46: from hxc_deposit_processes
47: where name = 'OTL Deposit Process';
48:
49: l_old_blocks hxc_self_service_time_deposit.timecard_info;
50: l_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
51: l_old_messages hxc_self_service_time_deposit.message_table;
52: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
53: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
46: from hxc_deposit_processes
47: where name = 'OTL Deposit Process';
48:
49: l_old_blocks hxc_self_service_time_deposit.timecard_info;
50: l_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
51: l_old_messages hxc_self_service_time_deposit.message_table;
52: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
53: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
54:
47: where name = 'OTL Deposit Process';
48:
49: l_old_blocks hxc_self_service_time_deposit.timecard_info;
50: l_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
51: l_old_messages hxc_self_service_time_deposit.message_table;
52: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
53: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
54:
55: Begin
48:
49: l_old_blocks hxc_self_service_time_deposit.timecard_info;
50: l_old_attributes hxc_self_service_time_deposit.building_block_attribute_info;
51: l_old_messages hxc_self_service_time_deposit.message_table;
52: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
53: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
54:
55: Begin
56: