[Home] [Help]
83: p_bg_id (N) - Business Group id
84: ----------------------------------------------------------------------*/
85: --
86: l_template_id pay_shadow_element_types.template_id%TYPE;
87: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
88: l_source_template_id pay_element_templates.template_id%TYPE;
89: l_object_version_number pay_element_types_f.object_version_number%TYPE;
90: l_proc_name VARCHAR2(80) :=
91: g_proc_name || 'create_user_template';
184: TYPE t_udt_rows IS TABLE OF r_udt_rows_type
185: INDEX BY BINARY_INTEGER;
186:
187: l_udt_rows t_udt_rows;
188: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
189:
190: -- Extra Information variables
191: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
288: --
289: CURSOR c3 (c_object_name in varchar2) is
290: SELECT ptco.core_object_id
291: FROM pay_shadow_balance_types psbt,
292: pay_template_core_objects ptco
293: WHERE psbt.template_id = l_template_id
294: AND psbt.balance_name = c_object_name
295: AND ptco.template_id = psbt.template_id
296: AND ptco.shadow_object_id = psbt.balance_type_id;
1665: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO' ;
1666:
1667: CURSOR csr_get_ele_type_id (c_template_id number) IS
1668: SELECT element_type_id
1669: FROM pay_template_core_objects pet
1670: ,pay_element_types_f petf
1671: WHERE pet.template_id = c_template_id
1672: AND petf.element_type_id = pet.core_object_id
1673: AND pet.core_object_type = 'ET';
1711: ,c_days_hours VARCHAR2) IS
1712: SELECT 'x'
1713: FROM pay_element_templates pets
1714: ,pay_shadow_element_types pset
1715: ,pay_template_core_objects ptco
1716: ,pay_element_type_extra_info peei
1717: WHERE pets.template_id <> c_te_usrstr_id
1718: -- For the given user structure
1719: AND pets.template_name = c_template_name --'PQP OMP Template'