1 package hxc_app_attribute_utils AUTHID CURRENT_USER as
2 /* $Header: hxcappattut.pkh 120.1 2006/03/31 19:48:41 arundell noship $ */
3
4 Type mapping_component is Record
5 (segment fnd_descr_flex_column_usages.application_column_name%type
6 ,field_name hxc_mapping_components.field_name%type
7 ,category hxc_bld_blk_info_type_usages.building_block_category%type
8 ,info_type hxc_bld_blk_info_types.bld_blk_info_type%type
9 ,retrieval_process_id hxc_retrieval_processes.retrieval_process_id%type
10 ,deposit_process_id hxc_deposit_processes.deposit_process_id%type
11 ,mapping_component_id hxc_mapping_components.mapping_component_id%type
12 );
13
14 Type mappings is table of mapping_component index by binary_integer;
15
16 Type mapping_idxs is Record
17 (start_index number
18 ,stop_index number
19 );
20
21 Type mapping_info is table of mapping_idxs index by binary_integer;
22
23 type appset_recipient is record
24 (recipient1 number
25 ,recipient2 number
26 ,recipient3 number
27 ,recipient4 number
28 ,recipient5 number
29 ,recipient6 number
30 ,recipient7 number
31 ,recipient8 number
32 ,recipient9 number
33 ,recipient10 number
34 ,recipient11 number
35 ,recipient12 number
36 ,recipient13 number
37 ,recipient14 number
38 ,recipient15 number
39 );
40
41 type appset_recipient_table is table of appset_recipient index by binary_integer;
42
43 Procedure cache_mappings;
44
45 Procedure clear_mapping_cache;
46
47 Function findSegmentFromFieldName
48 (p_field_name in hxc_mapping_components.field_name%type
49 ) return varchar2;
50
51 Function create_app_attributes
52 (p_attributes in hxc_attribute_table_type
53 ,p_retrieval_process_id in hxc_retrieval_processes.retrieval_process_id%type
54 ,p_deposit_process_id in hxc_deposit_processes.deposit_process_id%type
55 ) return hxc_self_service_time_deposit.app_attributes_info;
56
57 Function create_app_attributes
58 (p_blocks in hxc_block_table_type
59 ,p_attributes in hxc_attribute_table_type
60 ,p_retrieval_process_id in hxc_retrieval_processes.retrieval_process_id%type
61 ,p_deposit_process_id in hxc_deposit_processes.deposit_process_id%type
62 ,p_recipients in hxc_timecard_validation.recipient_application_table
63 ) return hxc_self_service_time_deposit.app_attributes_info;
64
65 Procedure update_attributes
66 (p_attributes in out nocopy hxc_attribute_table_type
67 ,p_app_attributes in out nocopy hxc_self_service_time_deposit.app_attributes_info
68 );
69
70 end hxc_app_attribute_utils;
[Home] [Help]