[Home] [Help]
38: c_parameters to reduce the cost of the cursor query
39: c_actions.Bug 3364759
40: 04-May-2004 irgonzal 115.9 Bug fix 3270485. Added logic to range_cursor
41: procedure to ensure the "header information" gets
42: inserted into pay_us_rpt_totals.
43: 01-Oct-2004 saurgupt 115.10 Bug 3679305: Modified the procedure range_cursor. Changed the sqlstr
44: to improve performance.
45: 05-Oct-2004 saurgupt 115.11 Bug 3679305: Modified the procedure range_cursor. Changed the sqlstr.
46: Added the new variable l_payroll_test to improve performance.
77: 06-Mar-2008 skameswa 115.25 Bug 6799553 : Modified the procedure ARCHIVE_DEINIT to include
78: a new cursor get_printer_details and a call to
79: fnd_request.set_print_options whose parameters were retrieved by
80: the above mentioned cursor
81: 10-Apr-2008 priupadh 115.26 Bug 6670508 Added delete statment for pay_us_rpt_totals table
82: in archive_deinit,deleting for the current run as payroll act id gets
83: stored in column tax_unit_id .
84: 21-Apr-2008 priupadh 115.27 Bug 6670508 Moved delete statment outside if clause , to delete the data
85: in 11i and R12 .
176: ELSE
177: l_payroll_text := null;
178: END IF;
179:
180: insert into pay_us_rpt_totals (tax_unit_id,attribute1,organization_id,
181: attribute2,attribute3,attribute4,attribute5)
182: values (pactid,'GTN',l_ppa_finder,
183: leg_param, l_business_group_id,
184: to_char(l_leg_start_date,'MM/DD/YYYY'),
1148: end if;
1149: --bug 6365474
1150:
1151: --bug 6670508
1152: delete from pay_us_rpt_totals where tax_unit_id = p_payroll_action_id;
1153: --bug 6670508
1154:
1155: end ARCHIVE_DEINIT;
1156: