162: l_retro_element_lst t_retro_ele;
163:
164: l_main_eei_info19 t_eei_info;
165: l_retro_eei_info19 t_eei_info;
166: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
167:
168: --
169: -- Extra Information variables
170: --
201: l_dbi_user_name ff_database_items.user_name%TYPE;
202: l_balance_name pay_balance_types.balance_name%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
202: l_balance_name pay_balance_types.balance_name%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
211: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
211: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
212: l_source_template_id pay_element_templates.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
211: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
212: l_source_template_id pay_element_templates.template_id%TYPE;
213: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
211: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
212: l_source_template_id pay_element_templates.template_id%TYPE;
213: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
214: l_proc_name VARCHAR2(80)
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
211: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
212: l_source_template_id pay_element_templates.template_id%TYPE;
213: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
214: l_proc_name VARCHAR2(80)
215: := g_proc_name || 'create_user_template';