[Home] [Help]
45: ,dp.deposit_process_id
46: ,mc.mapping_component_id
47: ,bbit.bld_blk_info_type_id
48: ,to_number(nvl(replace(replace(mc.segment,'ATTRIBUTE'),'_CATEGORY'),0))
49: from hxc_mapping_components mc
50: ,hxc_mapping_comp_usages mcu
51: ,hxc_mappings m1
52: ,hxc_mappings m2
53: ,hxc_retrieval_processes rp
283:
284: End cache_appset_recipient;
285:
286: Function findSegmentFromFieldName
287: (p_field_name in hxc_mapping_components.field_name%type
288: ) return varchar2 is
289:
290: cursor c_otl_deposit_process is
291: select deposit_process_id
293: where name = 'OTL Deposit Process';
294:
295: cursor c_prompt_name(p_comp_id in number) is
296: select substr(fcu.form_left_prompt,1,30) prompt
297: from hxc_mapping_components mc
298: ,hxc_bld_blk_info_types bbit
299: ,fnd_descr_flex_col_usage_tl fcu
300: where mc.mapping_component_id = p_comp_id
301: and mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
306: and fcu.language = userenv('LANG');
307:
308: l_index number;
309: l_found boolean := false;
310: l_segment hxc_mapping_components.segment%type;
311: l_field_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
312: l_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
313: l_field_no number;
314: l_field_names hxc_deposit_wrapper_utilities.t_simple_table;
1683:
1684: Procedure update_value
1685: (p_attributes in out nocopy hxc_attribute_table_type
1686: ,p_index in number
1687: ,p_segment in hxc_mapping_components.segment%type
1688: ,p_value in hxc_time_attributes.attribute1%type
1689: ) is
1690:
1691: Begin
1759: End update_value;
1760:
1761: Procedure set_new_attribute_value
1762: (p_attribute in out nocopy hxc_attribute_type
1763: ,p_segment in hxc_mapping_components.segment%type
1764: ,p_value in hxc_time_attributes.attribute1%type
1765: ) is
1766:
1767: Begin