[Home] [Help]
1: PACKAGE BODY pay_gb_p11d_car_extract AS
2: /* $Header: pygb11ce.pkb 120.8 2011/08/24 12:55:38 krreddy ship $ */
3:
4: -- Declare global variables:
5: g_veh_rcd_id NUMBER;
38: --
39: BEGIN
40: BEGIN
41: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
42: 'PAY GB P11D Car Extract',
43: 'Parameter Value',
44: 'Extract Start Date (DD-MON-YYYY)',
45: ben_ext_person.g_effective_date ));
46: EXCEPTION
68: --
69: BEGIN
70: BEGIN
71: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
72: 'PAY GB P11D Car Extract',
73: 'Parameter Value',
74: 'Extract End Date (DD-MON-YYYY)',
75: ben_ext_person.g_effective_date ));
76: EXCEPTION
108: -- Get user Table Value
109: BEGIN
110: -- Get Payroll Name Parameter Value
111: l_payroll_name := hruserdt.get_table_value(p_bus_group_id,
112: 'PAY GB P11D Car Extract',
113: 'Parameter Value',
114: 'Payroll Name',
115: ben_ext_person.g_effective_date );
116: --
149: BEGIN
150: BEGIN
151: -- Get Employee Number Parameter Value
152: l_employee_number := hruserdt.get_table_value(p_bus_group_id,
153: 'PAY GB P11D Car Extract',
154: 'Parameter Value',
155: 'Employee Number',
156: ben_ext_person.g_effective_date );
157: --
182: BEGIN
183: BEGIN
184: -- Get Tax District Reference Parameter Value
185: l_tax_dist := hruserdt.get_table_value(p_bus_group_id,
186: 'PAY GB P11D Car Extract',
187: 'Parameter Value',
188: 'Tax DIstrict Reference',
189: ben_ext_person.g_effective_date );
190: --
216: BEGIN
217: BEGIN
218: -- Get Consolidation Set Parameter Value
219: l_consolidation_set := hruserdt.get_table_value(p_bus_group_id,
220: 'PAY GB P11D Car Extract',
221: 'Parameter Value',
222: 'Consolidation Set',
223: ben_ext_person.g_effective_date );
224: --
256: BEGIN
257: BEGIN
258: -- Get Assignment Set Parameter Value
259: l_assignment_set := hruserdt.get_table_value(p_bus_group_id,
260: 'PAY GB P11D Car Extract',
261: 'Parameter Value',
262: 'Assignment Set',
263: ben_ext_person.g_effective_date );
264: --
1557: WHERE rslt.ext_rslt_id = p_ext_rslt_id
1558: AND rslt.ext_dfn_id = dfn.ext_dfn_id
1559: AND dfn.ext_file_id = rif.ext_file_id
1560: AND rif.ext_rcd_id = rcd.ext_rcd_id
1561: AND rcd.name like '%PAY GB P11D Car Extract 2003 - Assignment Details Record';
1562: --
1563: l_asg_rcd_id NUMBER;
1564: --
1565: CURSOR get_veh_rcd_id IS
1571: WHERE rslt.ext_rslt_id = p_ext_rslt_id
1572: AND rslt.ext_dfn_id = dfn.ext_dfn_id
1573: AND dfn.ext_file_id = rif.ext_file_id
1574: AND rif.ext_rcd_id = rcd.ext_rcd_id
1575: AND rcd.name like '%PAY GB P11D Car Extract 2003 - Vehicle Details Record';
1576: --
1577: --
1578: CURSOR get_ext_asg IS
1579: SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
3194: WHERE rslt.ext_rslt_id = p_ext_rslt_id
3195: AND rslt.ext_dfn_id = dfn.ext_dfn_id
3196: AND dfn.ext_file_id = rif.ext_file_id
3197: AND rif.ext_rcd_id = rcd.ext_rcd_id
3198: AND rcd.name like '%PAY GB P11D Car Extract - Assignment Details Record';
3199: --
3200: l_asg_rcd_id NUMBER;
3201: --
3202: CURSOR get_veh_rcd_id IS
3208: WHERE rslt.ext_rslt_id = p_ext_rslt_id
3209: AND rslt.ext_dfn_id = dfn.ext_dfn_id
3210: AND dfn.ext_file_id = rif.ext_file_id
3211: AND rif.ext_rcd_id = rcd.ext_rcd_id
3212: AND rcd.name like '%PAY GB P11D Car Extract - Vehicle Details Record';
3213: --
3214: --
3215: CURSOR get_ext_asg IS
3216: SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
3294: --
3295: END post_process_rule_04;
3296: ---------------------------------------------------------------------------
3297: /* End of code that has been added as part of PllD Car Extract 2004 */
3298: END pay_gb_p11d_car_extract;