DBA Data[Home] [Help]

APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 319: l_base_element_type_id pay_template_core_objects.core_object_id%type;

315: )
316: return Number is
317: --
318: l_template_id pay_shadow_element_types.template_id%type;
319: l_base_element_type_id pay_template_core_objects.core_object_id%type;
320: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
321: l_source_template_id pay_element_templates.template_id%type;
322: l_object_version_number pay_element_types_f.object_version_number%type;
323: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';

Line 320: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;

316: return Number is
317: --
318: l_template_id pay_shadow_element_types.template_id%type;
319: l_base_element_type_id pay_template_core_objects.core_object_id%type;
320: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
321: l_source_template_id pay_element_templates.template_id%type;
322: l_object_version_number pay_element_types_f.object_version_number%type;
323: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
324: l_element_type_id Number;

Line 385: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;

381: index by BINARY_INTEGER;
382: l_main_eei_info19 t_eei_info;
383: l_retro_eei_info19 t_eei_info;
384:
385: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
386:
387: -- Extra Information variables
388: l_eei_information11 pay_element_type_extra_info.eei_information9%type;
389: l_eei_information12 pay_element_type_extra_info.eei_information10%type;