DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 166: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;

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: --

Line 205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

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;

Line 206: l_er_base_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;

Line 207: l_cy_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;

Line 208: l_cy_er_retro_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;

Line 209: l_py_retro_element_type_id pay_template_core_objects.core_object_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;

Line 210: l_py_er_retro_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;
214: l_proc_name VARCHAR2(80)

Line 211: l_xtr_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)
215: := g_proc_name || 'create_user_template';