4: type rollback_rec is record
5: (
6: -- Payroll Action Level Details.
7: pact_id pay_payroll_actions.payroll_action_id%type,
8: action_name hr_lookups.meaning%type,
9: action_type pay_payroll_actions.action_type%type,
10: action_status pay_payroll_actions.action_status%type,
11: sequenced_flag boolean,
12: action_date date,
1097: p_info.sub_ledger_acc
1098: from pay_payroll_actions pac,
1099: pay_all_payrolls_f pay,
1100: per_business_groups_perf grp,
1101: hr_lookups hrl
1102: where pac.payroll_action_id = p_info.pact_id
1103: and hrl.lookup_code = pac.action_type
1104: and hrl.lookup_type = 'ACTION_TYPE'
1105: and grp.business_group_id = pac.business_group_id + 0
1176: l_line_sequence number;
1177: l_payroll_id number;
1178: l_source_id number;
1179: l_source_type pay_message_lines.source_type%type;
1180: l_action_name hr_lookups.meaning%type;
1181: begin
1182: g_debug := hr_utility.debug_enabled;
1183: if g_debug then
1184: c_indent := 'py_rollback_pkg.ins_rollback_message';