[Home] [Help]
3128: begin
3129: select payroll_action_id,
3130: action_sequence,
3131: assignment_id,
3132: pay_assignment_actions_s.nextval
3133: into pact,
3134: actseq,
3135: asgid,
3136: newseq
3446: --
3447: --
3448: -- Now, update with new action_sequence.
3449: update pay_assignment_actions act
3450: set act.action_sequence = pay_assignment_actions_s.nextval
3451: where act.rowid = my_rowid;
3452: --
3453: update pay_run_balances
3454: set action_sequence = pay_assignment_actions_s.currval
3450: set act.action_sequence = pay_assignment_actions_s.nextval
3451: where act.rowid = my_rowid;
3452: --
3453: update pay_run_balances
3454: set action_sequence = pay_assignment_actions_s.currval
3455: where assignment_action_id = upd_aa_id;
3456: --
3457: end loop;
3458: --
3492: --
3493: resequence_children(chdrec.assignment_action_id);
3494: --
3495: update pay_assignment_actions
3496: set action_sequence = pay_assignment_actions_s.nextval
3497: where assignment_action_id = chdrec.assignment_action_id;
3498: --
3499: end loop;
3500: --
3664:
3665: --
3666: my_rowid rowid;
3667: upd_aa_id pay_assignment_actions.assignment_action_id%type;
3668: src_aa_id pay_assignment_actions.source_action_id%type;
3669: obj_type pay_assignment_actions.object_type%type;
3670: --
3671: begin
3672: --
3705: --
3706: --
3707: -- Now, update with new action_sequence.
3708: update pay_assignment_actions act
3709: set act.action_sequence = pay_assignment_actions_s.nextval
3710: where act.rowid = my_rowid;
3711: --
3712: update pay_run_balances
3713: set action_sequence = pay_assignment_actions_s.currval
3709: set act.action_sequence = pay_assignment_actions_s.nextval
3710: where act.rowid = my_rowid;
3711: --
3712: update pay_run_balances
3713: set action_sequence = pay_assignment_actions_s.currval
3714: where assignment_action_id = upd_aa_id;
3715: --
3716: /* If it's an assignment action thats created due to a
3717: POG then we need to up the POGs action sequence
3720: and obj_type = 'POG'
3721: and src_aa_id is not null) then
3722: --
3723: update pay_assignment_actions act
3724: set act.action_sequence = pay_assignment_actions_s.nextval
3725: where act.assignment_action_id = src_aa_id;
3726: --
3727: end if;
3728: --
4557: --
4558: --
4559: -- Now, update with new action_sequence.
4560: update pay_assignment_actions act
4561: set act.action_sequence = pay_assignment_actions_s.nextval
4562: where act.rowid = my_rowid;
4563: --
4564: update pay_run_balances
4565: set action_sequence = pay_assignment_actions_s.currval
4561: set act.action_sequence = pay_assignment_actions_s.nextval
4562: where act.rowid = my_rowid;
4563: --
4564: update pay_run_balances
4565: set action_sequence = pay_assignment_actions_s.currval
4566: where assignment_action_id = upd_aa_id;
4567: end loop;
4568: --
4569: --
4583: --
4584: -- Start by grabbing the type of the action we are dealing with.
4585: select pac.action_type,
4586: pac.business_group_id,
4587: pay_assignment_actions_s.nextval
4588: into actyp,
4589: bgid,
4590: aa_id
4591: from pay_payroll_actions pac
4808: asgid,
4809: pactid,
4810: 'C',
4811: 1,
4812: PAY_ASSIGNMENT_ACTIONS_S.nextval,
4813: p_pre_payment_id,
4814: p_serial_number,
4815: 1
4816: from sys.dual
4964: inassact(p_payroll_action_id, p_assignment_id, null, null, null);
4965: --
4966: -- Get the assignment_action_id
4967: -- that has just been inserted
4968: select pay_assignment_actions_s.currval
4969: into assactid
4970: from sys.dual;
4971: --
4972: -- Return information.
5023: --
5024: if g_debug then
5025: hr_utility.set_location('hrassact.qpppassact',30);
5026: end if;
5027: select pay_assignment_actions_s.currval,
5028: act.assignment_action_id
5029: into l_locking_action_id,
5030: l_locked_action_id
5031: from pay_payroll_actions pac,
5773: l_consolidation_set_id number;
5774: --
5775: cursor C_CON1 is
5776: select pay_payroll_actions_s.nextval,
5777: pay_assignment_actions_s.nextval,
5778: pa.CONSOLIDATION_SET_ID,
5779: pa.BUSINESS_GROUP_ID
5780: from PAY_ASSIGNMENT_ACTIONS paa,
5781: PAY_PAYROLL_ACTIONS pa