[Home] [Help]
3145: begin
3146: select payroll_action_id,
3147: action_sequence,
3148: assignment_id,
3149: pay_assignment_actions_s.nextval
3150: into pact,
3151: actseq,
3152: asgid,
3153: newseq
3466: --
3467: --
3468: -- Now, update with new action_sequence.
3469: update pay_assignment_actions act
3470: set act.action_sequence = pay_assignment_actions_s.nextval
3471: where act.rowid = my_rowid;
3472: --
3473: update pay_run_balances
3474: set action_sequence = pay_assignment_actions_s.currval
3470: set act.action_sequence = pay_assignment_actions_s.nextval
3471: where act.rowid = my_rowid;
3472: --
3473: update pay_run_balances
3474: set action_sequence = pay_assignment_actions_s.currval
3475: where assignment_action_id = upd_aa_id;
3476: --
3477: end loop;
3478: --
3512: --
3513: resequence_children(chdrec.assignment_action_id);
3514: --
3515: update pay_assignment_actions
3516: set action_sequence = pay_assignment_actions_s.nextval
3517: where assignment_action_id = chdrec.assignment_action_id;
3518: --
3519: end loop;
3520: --
3684:
3685: --
3686: my_rowid rowid;
3687: upd_aa_id pay_assignment_actions.assignment_action_id%type;
3688: src_aa_id pay_assignment_actions.source_action_id%type;
3689: obj_type pay_assignment_actions.object_type%type;
3690: --
3691: begin
3692: --
3725: --
3726: --
3727: -- Now, update with new action_sequence.
3728: update pay_assignment_actions act
3729: set act.action_sequence = pay_assignment_actions_s.nextval
3730: where act.rowid = my_rowid;
3731: --
3732: update pay_run_balances
3733: set action_sequence = pay_assignment_actions_s.currval
3729: set act.action_sequence = pay_assignment_actions_s.nextval
3730: where act.rowid = my_rowid;
3731: --
3732: update pay_run_balances
3733: set action_sequence = pay_assignment_actions_s.currval
3734: where assignment_action_id = upd_aa_id;
3735: --
3736: /* If it's an assignment action thats created due to a
3737: POG then we need to up the POGs action sequence
3740: and obj_type = 'POG'
3741: and src_aa_id is not null) then
3742: --
3743: update pay_assignment_actions act
3744: set act.action_sequence = pay_assignment_actions_s.nextval
3745: where act.assignment_action_id = src_aa_id;
3746: --
3747: end if;
3748: --
4577: --
4578: --
4579: -- Now, update with new action_sequence.
4580: update pay_assignment_actions act
4581: set act.action_sequence = pay_assignment_actions_s.nextval
4582: where act.rowid = my_rowid;
4583: --
4584: update pay_run_balances
4585: set action_sequence = pay_assignment_actions_s.currval
4581: set act.action_sequence = pay_assignment_actions_s.nextval
4582: where act.rowid = my_rowid;
4583: --
4584: update pay_run_balances
4585: set action_sequence = pay_assignment_actions_s.currval
4586: where assignment_action_id = upd_aa_id;
4587: end loop;
4588: --
4589: --
4603: --
4604: -- Start by grabbing the type of the action we are dealing with.
4605: select pac.action_type,
4606: pac.business_group_id,
4607: pay_assignment_actions_s.nextval
4608: into actyp,
4609: bgid,
4610: aa_id
4611: from pay_payroll_actions pac
5040: asgid,
5041: pactid,
5042: 'C',
5043: 1,
5044: PAY_ASSIGNMENT_ACTIONS_S.nextval,
5045: p_pre_payment_id,
5046: p_serial_number,
5047: 1
5048: from sys.dual
5196: inassact(p_payroll_action_id, p_assignment_id, null, null, null);
5197: --
5198: -- Get the assignment_action_id
5199: -- that has just been inserted
5200: select pay_assignment_actions_s.currval
5201: into assactid
5202: from sys.dual;
5203: --
5204: -- Return information.
5255: --
5256: if g_debug then
5257: hr_utility.set_location('hrassact.qpppassact',30);
5258: end if;
5259: select pay_assignment_actions_s.currval,
5260: act.assignment_action_id
5261: into l_locking_action_id,
5262: l_locked_action_id
5263: from pay_payroll_actions pac,
6037: l_consolidation_set_id number;
6038: --
6039: cursor C_CON1 is
6040: select pay_payroll_actions_s.nextval,
6041: pay_assignment_actions_s.nextval,
6042: pa.CONSOLIDATION_SET_ID,
6043: pa.BUSINESS_GROUP_ID
6044: from PAY_ASSIGNMENT_ACTIONS paa,
6045: PAY_PAYROLL_ACTIONS pa