[Home] [Help]
429: prepayments.
430: 05-SEP-1997 KKAWOL 40.61 #547578 Period dates fix. Set the
431: date_earned column as
432: appropriate on the
433: pay_payroll_actions table.
434: 19-JUN-1997 ALOGUE 40.60 #507602 Reversals run results: source_id
435: = run_result_id of the run
436: result being reversed.
437: 04-APR-1997 NBRISTOW 40.59 #473685 Segment1 was not being decoded
559: Disabled all uses of the
560: business_group_id index.
561: 05-OCT-1994 DKERR 40.20 Set the OBJECT_VERSION_NUMBER
562: to 1 for inserts into
563: PAY_PAYROLL_ACTIONS and
564: PAY_ASSIGNMENT_ACTIONS for
565: all action types.
566: 28-JUN-1994 DSAXBY 40.19 Added line to decode statement
567: in reversal routine, to
654: assignment_number per_all_assignments_f.assignment_number%type,
655: payroll_id per_all_assignments_f.payroll_id%type);
656: --
657: type pact_details is record
658: (pact_id pay_payroll_actions.payroll_action_id%type,
659: action_name hr_lookups.meaning%type,
660: action_type pay_payroll_actions.action_type%type,
661: sequenced_flag boolean,
662: action_date date,
656: --
657: type pact_details is record
658: (pact_id pay_payroll_actions.payroll_action_id%type,
659: action_name hr_lookups.meaning%type,
660: action_type pay_payroll_actions.action_type%type,
661: sequenced_flag boolean,
662: action_date date,
663: current_date date, -- this is sysdate.
664: payroll_name pay_all_payrolls_f.payroll_name%type,
1019: from dual
1020: where not exists
1021: (select null
1022: from pay_assignment_actions ACT,
1023: pay_payroll_actions PACT,
1024: pay_action_classifications CLASS,
1025: pay_action_classifications CLAS2
1026: where ACT.assignment_id = p_assact_rec.assignment_id
1027: and ACT.action_sequence > l_action_sequence
1040: from dual
1041: where not exists
1042: (select null
1043: from pay_assignment_actions ACT,
1044: pay_payroll_actions PACT,
1045: pay_action_classifications CLASS,
1046: pay_action_classifications CLAS2
1047: where ACT.assignment_id = p_assact_rec.assignment_id
1048: and ACT.action_sequence > l_action_sequence
1066: where not exists
1067: (select null
1068: from pay_action_classifications CLASS,
1069: pay_action_classifications CLAS2,
1070: pay_payroll_actions PACT,
1071: pay_assignment_actions ACT,
1072: per_all_assignments_f ASS,
1073: per_periods_of_service POS
1074: where POS.person_id = l_person_id
1088: where not exists
1089: (select null
1090: from pay_action_classifications CLASS,
1091: pay_action_classifications CLAS2,
1092: pay_payroll_actions PACT,
1093: pay_assignment_actions ACT,
1094: per_all_assignments_f ASS,
1095: per_periods_of_service POS
1096: where POS.person_id = l_person_id
1155: p_pact_rec.action_type,
1156: p_pact_rec.current_date,
1157: p_pact_rec.payroll_name,
1158: p_pact_rec.bg_name
1159: from pay_payroll_actions pac,
1160: pay_all_payrolls_f pay,
1161: per_business_groups_perf grp,
1162: hr_lookups hrl
1163: where pac.payroll_action_id = p_pact_rec.pact_id
2135: hr_utility.set_location(c_indent,90);
2136: end if;
2137: select ppt_tl.payment_type_name
2138: into l_pact_rec.action_name
2139: from pay_payroll_actions pac,
2140: pay_payment_types_tl ppt_tl,
2141: pay_payment_types ppt
2142: where pac.payroll_action_id = l_pact_rec.pact_id
2143: and ppt.payment_type_id = pac.payment_type_id
2184: 'I', -- information.
2185: pac.business_group_id,
2186: 'B',
2187: mesg_text
2188: from pay_payroll_actions pac
2189: where pac.payroll_action_id = l_pact_rec.pact_id;
2190:
2191: end;
2192: --
2192: --
2193: if g_debug then
2194: hr_utility.set_location(c_indent,80);
2195: end if;
2196: delete from pay_payroll_actions
2197: where payroll_action_id = p_payroll_action_id;
2198: --
2199: if not p_all_or_nothing then
2200: if g_debug then
2926: select /*+ ORDERED */ alb.latest_balance_id
2927: from per_periods_of_service pos,
2928: per_all_assignments_f asg,
2929: pay_assignment_actions act,
2930: pay_payroll_actions pac,
2931: pay_assignment_latest_balances alb
2932: where pos.person_id = p_person_id
2933: and asg.period_of_service_id = pos.period_of_service_id
2934: and asg.person_id = p_person_id
2952: pay_balance_feeds_f pbf,
2953: pay_defined_balances pdb,
2954: pay_person_latest_balances plb,
2955: pay_assignment_actions paa,
2956: pay_payroll_actions ppa
2957: where plb.person_id = p_person_id
2958: and piv.element_type_id = p_eletyp_id
2959: and piv.input_value_id = pbf.input_value_id
2960: and plb.defined_balance_id = pdb.defined_balance_id
2971: select
2972: alb.latest_balance_id
2973: from pay_assignment_latest_balances alb,
2974: pay_assignment_actions act,
2975: pay_payroll_actions pac,
2976: pay_defined_balances pdb,
2977: pay_balance_feeds_f pbf,
2978: pay_input_values_f piv
2979: where act.assignment_id = alb.assignment_id
3002: pay_balance_feeds_f pbf,
3003: pay_defined_balances pdb,
3004: pay_latest_balances plb,
3005: pay_assignment_actions paa,
3006: pay_payroll_actions ppa
3007: where plb.person_id = p_person_id
3008: and piv.element_type_id = p_eletyp_id
3009: and piv.input_value_id = pbf.input_value_id
3010: and plb.defined_balance_id = pdb.defined_balance_id
3185: cursor cnkasg is
3186: select ppa.effective_date,
3187: paa.assignment_action_id,
3188: ppa.action_type
3189: from pay_payroll_actions ppa,
3190: pay_assignment_actions paa
3191: where ppa.payroll_action_id = pactid
3192: and paa.payroll_action_id = ppa.payroll_action_id
3193: and paa.source_action_id is null
3231: ac2.assignment_action_id
3232: from pay_action_classifications acl,
3233: pay_assignment_actions ac2,
3234: pay_assignment_actions paa,
3235: pay_payroll_actions ppa,
3236: pay_payroll_actions pa2
3237: where paa.assignment_action_id = aaid
3238: and ppa.payroll_action_id = paa.payroll_action_id
3239: and ac2.assignment_id = paa.assignment_id
3232: from pay_action_classifications acl,
3233: pay_assignment_actions ac2,
3234: pay_assignment_actions paa,
3235: pay_payroll_actions ppa,
3236: pay_payroll_actions pa2
3237: where paa.assignment_action_id = aaid
3238: and ppa.payroll_action_id = paa.payroll_action_id
3239: and ac2.assignment_id = paa.assignment_id
3240: and pa2.payroll_action_id = ac2.payroll_action_id
3254: chldact varchar2
3255: ) is
3256: select /*+ ORDERED USE_NL(ac2, pa2)
3257: INDEX(ac2 PAY_ASSIGNMENT_ACTIONS_N1)
3258: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK) */
3259: ac2.rowid,
3260: ac2.assignment_action_id
3261: from pay_assignment_actions act,
3262: pay_payroll_actions pac,
3258: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK) */
3259: ac2.rowid,
3260: ac2.assignment_action_id
3261: from pay_assignment_actions act,
3262: pay_payroll_actions pac,
3263: per_all_assignments_f asg,
3264: per_all_assignments_f as2,
3265: pay_assignment_actions ac2,
3266: pay_payroll_actions pa2,
3262: pay_payroll_actions pac,
3263: per_all_assignments_f asg,
3264: per_all_assignments_f as2,
3265: pay_assignment_actions ac2,
3266: pay_payroll_actions pa2,
3267: pay_action_classifications acl
3268: where act.assignment_action_id = aaid
3269: and pac.payroll_action_id = act.payroll_action_id
3270: and asg.assignment_id = act.assignment_id
3304: from pay_assignment_actions act,
3305: pay_object_groups pog,
3306: pay_object_groups pog2,
3307: pay_object_groups pog3,
3308: pay_payroll_actions pac,
3309: pay_object_groups pog4,
3310: pay_assignment_actions ac3,
3311: pay_payroll_actions pa3,
3312: pay_action_classifications acl
3307: pay_object_groups pog3,
3308: pay_payroll_actions pac,
3309: pay_object_groups pog4,
3310: pay_assignment_actions ac3,
3311: pay_payroll_actions pa3,
3312: pay_action_classifications acl
3313: where act.assignment_action_id = aaid
3314: and pac.payroll_action_id = act.payroll_action_id
3315: and pog.source_id = act.assignment_id
3330: from pay_assignment_actions act,
3331: pay_object_groups pog,
3332: pay_object_groups pog2,
3333: pay_object_groups pog3,
3334: pay_payroll_actions pac,
3335: pay_assignment_actions ac3,
3336: pay_payroll_actions pa3
3337: where act.assignment_action_id = aaid
3338: and pac.payroll_action_id = act.payroll_action_id
3332: pay_object_groups pog2,
3333: pay_object_groups pog3,
3334: pay_payroll_actions pac,
3335: pay_assignment_actions ac3,
3336: pay_payroll_actions pa3
3337: where act.assignment_action_id = aaid
3338: and pac.payroll_action_id = act.payroll_action_id
3339: and pog.source_id = act.assignment_id
3340: and pog.source_type = 'PAF'
3347: and pa3.payroll_action_id = ac3.payroll_action_id
3348: and pa3.effective_date > pac.effective_date
3349: and pa3.action_type = 'L') V,
3350: pay_assignment_actions ac2,
3351: pay_payroll_actions pa2
3352: where ac2.assignment_action_id = V.assignment_action_id
3353: and pa2.payroll_action_id = ac2.payroll_action_id
3354: and (( chldact = 'N'
3355: and ac2.source_action_id is null)
3372: select distinct ac3.assignment_action_id
3373: from pay_assignment_actions act,
3374: pay_object_groups pog,
3375: pay_object_groups pog2,
3376: pay_payroll_actions pac,
3377: pay_object_groups pog3,
3378: pay_assignment_actions ac3,
3379: pay_payroll_actions pa3,
3380: pay_action_classifications acl
3375: pay_object_groups pog2,
3376: pay_payroll_actions pac,
3377: pay_object_groups pog3,
3378: pay_assignment_actions ac3,
3379: pay_payroll_actions pa3,
3380: pay_action_classifications acl
3381: where act.assignment_action_id = aaid
3382: and pac.payroll_action_id = act.payroll_action_id
3383: and pog.object_group_id = act.object_id
3395: select distinct ac3.assignment_action_id
3396: from pay_assignment_actions act,
3397: pay_object_groups pog,
3398: pay_object_groups pog2,
3399: pay_payroll_actions pac,
3400: pay_assignment_actions ac3,
3401: pay_payroll_actions pa3
3402: where act.assignment_action_id = aaid
3403: and pac.payroll_action_id = act.payroll_action_id
3397: pay_object_groups pog,
3398: pay_object_groups pog2,
3399: pay_payroll_actions pac,
3400: pay_assignment_actions ac3,
3401: pay_payroll_actions pa3
3402: where act.assignment_action_id = aaid
3403: and pac.payroll_action_id = act.payroll_action_id
3404: and pog.object_group_id = act.object_id
3405: and pog.source_type = 'PPF'
3410: and pa3.payroll_action_id = ac3.payroll_action_id
3411: and pa3.effective_date > pac.effective_date
3412: and pa3.action_type = 'L') V,
3413: pay_assignment_actions ac2,
3414: pay_payroll_actions pa2
3415: where ac2.assignment_action_id = V.assignment_action_id
3416: and pa2.payroll_action_id = ac2.payroll_action_id
3417: and (( chldact = 'N'
3418: and ac2.source_action_id is null)
3531: --
3532: cursor seqasg (
3533: asgid number,
3534: actseq number) is
3535: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK) */
3536: ac2.rowid,
3537: ac2.assignment_action_id,
3538: ac2.source_action_id,
3539: ac2.object_type
3538: ac2.source_action_id,
3539: ac2.object_type
3540: from pay_action_classifications acl,
3541: pay_assignment_actions ac2,
3542: pay_payroll_actions pa2
3543: where ac2.assignment_id = asgid
3544: and pa2.payroll_action_id = ac2.payroll_action_id
3545: and acl.classification_name = 'SEQUENCED'
3546: and pa2.action_type = acl.action_type
3558: actseq number,
3559: rmode varchar2) is
3560: select /*+ ORDERED
3561: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N51)
3562: (pa2 PAY_PAYROLL_ACTIONS_PK) */
3563: ac2.rowid,
3564: ac2.assignment_action_id,
3565: ac2.source_action_id,
3566: ac2.object_type
3563: ac2.rowid,
3564: ac2.assignment_action_id,
3565: ac2.source_action_id,
3566: ac2.object_type
3567: from pay_payroll_actions pac,
3568: per_all_assignments_f asg,
3569: per_all_assignments_f as2,
3570: pay_assignment_actions act,
3571: pay_assignment_actions ac2,
3568: per_all_assignments_f asg,
3569: per_all_assignments_f as2,
3570: pay_assignment_actions act,
3571: pay_assignment_actions ac2,
3572: pay_payroll_actions pa2,
3573: pay_action_classifications acl
3574: where pac.payroll_action_id = pactid
3575: and act.payroll_action_id = pac.payroll_action_id
3576: and act.assignment_id = asgid
3605: actseq number,
3606: rmode varchar2) is
3607: select /*+ ORDERED
3608: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_PK)
3609: (pa2 PAY_PAYROLL_ACTIONS_PK) */
3610: ac2.rowid,
3611: ac2.assignment_action_id,
3612: ac2.source_action_id,
3613: ac2.object_type
3614: from
3615: (
3616: select /*+ ORDERED */
3617: distinct ac3.assignment_action_id
3618: from pay_payroll_actions pac,
3619: pay_assignment_actions act,
3620: pay_object_groups pog,
3621: pay_object_groups pog2,
3622: pay_object_groups pog3,
3621: pay_object_groups pog2,
3622: pay_object_groups pog3,
3623: pay_object_groups pog4,
3624: pay_assignment_actions ac3,
3625: pay_payroll_actions pa3,
3626: pay_action_classifications acl
3627: where pac.payroll_action_id = pactid
3628: and act.payroll_action_id = pac.payroll_action_id
3629: and act.assignment_id = asgid
3645: and acl.classification_name = 'SEQUENCED'
3646: union all
3647: select /*+ ORDERED */
3648: distinct ac3.assignment_action_id
3649: from pay_payroll_actions pac,
3650: pay_assignment_actions act,
3651: pay_object_groups pog,
3652: pay_object_groups pog2,
3653: pay_object_groups pog3,
3651: pay_object_groups pog,
3652: pay_object_groups pog2,
3653: pay_object_groups pog3,
3654: pay_assignment_actions ac3,
3655: pay_payroll_actions pa3
3656: where pac.payroll_action_id = pactid
3657: and act.payroll_action_id = pac.payroll_action_id
3658: and act.assignment_id = asgid
3659: and act.source_action_id is null
3670: and ac3.action_sequence > actseq
3671: and pa3.payroll_action_id = ac3.payroll_action_id
3672: and pa3.action_type = 'L') V,
3673: pay_assignment_actions ac2,
3674: pay_payroll_actions pa2
3675: where ac2.assignment_action_id = V.assignment_action_id
3676: and pa2.payroll_action_id = ac2.payroll_action_id
3677: and (ac2.source_action_id is null
3678: or
4107: ) return number
4108: is
4109: rmode pay_legislation_rules.rule_mode%type;
4110: posid per_periods_of_service.period_of_service_id%type;
4111: actyp pay_payroll_actions.action_type%type;
4112: bgid pay_payroll_actions.business_group_id%type;
4113: l_action_population_status pay_payroll_actions.action_population_status%type;
4114: aa_id number;
4115: --
4108: is
4109: rmode pay_legislation_rules.rule_mode%type;
4110: posid per_periods_of_service.period_of_service_id%type;
4111: actyp pay_payroll_actions.action_type%type;
4112: bgid pay_payroll_actions.business_group_id%type;
4113: l_action_population_status pay_payroll_actions.action_population_status%type;
4114: aa_id number;
4115: --
4116: --------------------------- irbaact ------------------------------
4109: rmode pay_legislation_rules.rule_mode%type;
4110: posid per_periods_of_service.period_of_service_id%type;
4111: actyp pay_payroll_actions.action_type%type;
4112: bgid pay_payroll_actions.business_group_id%type;
4113: l_action_population_status pay_payroll_actions.action_population_status%type;
4114: aa_id number;
4115: --
4116: --------------------------- irbaact ------------------------------
4117: /*
4152: ac2.assignment_action_id
4153: from pay_action_classifications acl,
4154: pay_assignment_actions ac2,
4155: pay_assignment_actions act,
4156: pay_payroll_actions pa2,
4157: pay_payroll_actions pac
4158: where pac.payroll_action_id = pactid
4159: and act.payroll_action_id = pac.payroll_action_id
4160: and act.assignment_id = asgid
4153: from pay_action_classifications acl,
4154: pay_assignment_actions ac2,
4155: pay_assignment_actions act,
4156: pay_payroll_actions pa2,
4157: pay_payroll_actions pac
4158: where pac.payroll_action_id = pactid
4159: and act.payroll_action_id = pac.payroll_action_id
4160: and act.assignment_id = asgid
4161: and ac2.assignment_id = act.assignment_id
4180: select /*+
4181: INDEX(ac2 PAY_ASSIGNMENT_ACTIONS_N51) */
4182: ac2.rowid,
4183: ac2.assignment_action_id
4184: from pay_payroll_actions pac,
4185: pay_assignment_actions act,
4186: per_all_assignments_f asg,
4187: per_all_assignments_f as2,
4188: pay_assignment_actions ac2,
4185: pay_assignment_actions act,
4186: per_all_assignments_f asg,
4187: per_all_assignments_f as2,
4188: pay_assignment_actions ac2,
4189: pay_payroll_actions pa2,
4190: pay_action_classifications acl
4191: where pac.payroll_action_id = pactid
4192: and act.payroll_action_id = pac.payroll_action_id
4193: and act.assignment_id = asgid
4225: from
4226: (
4227: select /*+ ORDERED */
4228: distinct ac3.assignment_action_id
4229: from pay_payroll_actions pac,
4230: pay_assignment_actions act,
4231: pay_object_groups pog,
4232: pay_object_groups pog2,
4233: pay_object_groups pog3,
4232: pay_object_groups pog2,
4233: pay_object_groups pog3,
4234: pay_object_groups pog4,
4235: pay_assignment_actions ac3,
4236: pay_payroll_actions pa3,
4237: pay_action_classifications acl
4238: where pac.payroll_action_id = pactid
4239: and act.payroll_action_id = pac.payroll_action_id
4240: and act.assignment_id = asgid
4253: and acl.classification_name = 'SEQUENCED'
4254: union all
4255: select /*+ ORDERED */
4256: distinct ac3.assignment_action_id
4257: from pay_payroll_actions pac,
4258: pay_assignment_actions act,
4259: pay_object_groups pog,
4260: pay_object_groups pog2,
4261: pay_object_groups pog3,
4259: pay_object_groups pog,
4260: pay_object_groups pog2,
4261: pay_object_groups pog3,
4262: pay_assignment_actions ac3,
4263: pay_payroll_actions pa3
4264: where pac.payroll_action_id = pactid
4265: and act.payroll_action_id = pac.payroll_action_id
4266: and act.assignment_id = asgid
4267: and pog.source_id = act.assignment_id
4275: and pa3.payroll_action_id = ac3.payroll_action_id
4276: and pa3.effective_date > pac.effective_date
4277: and pa3.action_type = 'L') V,
4278: pay_assignment_actions ac2,
4279: pay_payroll_actions pa2
4280: where ac2.assignment_action_id = V.assignment_action_id
4281: and pa2.payroll_action_id = ac2.payroll_action_id
4282: order by pa2.effective_date, ac2.action_sequence
4283: for update of ac2.assignment_action_id;
4297: and pog_grp.source_type = 'PAF';
4298: --
4299: my_rowid rowid;
4300: upd_aa_id pay_assignment_actions.assignment_action_id%type;
4301: actype pay_payroll_actions.action_type%type;
4302: effdate date; -- the effective date of the payroll action.
4303: lgcode varchar2(30); -- Used to check if the US legislation.
4304: persid number; -- assignments person_id
4305: taxunt2 number; -- The tax unit id if legislation is US
4333: into effdate, actype, lgcode, persid
4334: from
4335: per_business_groups_perf pbg,
4336: per_all_assignments_f asg,
4337: pay_payroll_actions pac
4338: where pac.payroll_action_id = pactid
4339: and pbg.business_group_id = asg.business_group_id
4340: and asg.assignment_id = asgid
4341: and pac.effective_date between
4417: select 1
4418: into aa_exists
4419: from dual
4420: where exists (
4421: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4422: from pay_action_classifications pay_acl,
4423: pay_payroll_actions pay_pa2,
4424: pay_assignment_actions pay_ac2
4425: where pay_ac2.assignment_id = asgid
4419: from dual
4420: where exists (
4421: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4422: from pay_action_classifications pay_acl,
4423: pay_payroll_actions pay_pa2,
4424: pay_assignment_actions pay_ac2
4425: where pay_ac2.assignment_id = asgid
4426: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
4427: and pay_acl.classification_name = 'SEQUENCED'
4438: select 1
4439: into aa_exists
4440: from sys.dual
4441: where exists (
4442: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4443: from pay_action_classifications pay_acl,
4444: pay_payroll_actions pay_pa2,
4445: pay_assignment_actions pay_ac2
4446: where pay_ac2.assignment_id = dprec.assignment_id
4440: from sys.dual
4441: where exists (
4442: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4443: from pay_action_classifications pay_acl,
4444: pay_payroll_actions pay_pa2,
4445: pay_assignment_actions pay_ac2
4446: where pay_ac2.assignment_id = dprec.assignment_id
4447: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
4448: and pay_acl.classification_name = 'SEQUENCED'
4463: select 1
4464: into aa_exists
4465: from sys.dual
4466: where exists (
4467: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4468: from pay_action_classifications pay_acl,
4469: pay_payroll_actions pay_pa2,
4470: pay_assignment_actions pay_ac2
4471: where pay_ac2.assignment_id = dprec.assignment_id
4465: from sys.dual
4466: where exists (
4467: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4468: from pay_action_classifications pay_acl,
4469: pay_payroll_actions pay_pa2,
4470: pay_assignment_actions pay_ac2
4471: where pay_ac2.assignment_id = dprec.assignment_id
4472: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
4473: and pay_acl.classification_name = 'SEQUENCED'
4517: l_run_type_id
4518: from sys.dual
4519: where not exists (
4520: select null
4521: from pay_payroll_actions pac,
4522: pay_payroll_actions pa2,
4523: pay_assignment_actions act,
4524: pay_assignment_actions ac2
4525: where pac.payroll_action_id = pactid
4518: from sys.dual
4519: where not exists (
4520: select null
4521: from pay_payroll_actions pac,
4522: pay_payroll_actions pa2,
4523: pay_assignment_actions act,
4524: pay_assignment_actions ac2
4525: where pac.payroll_action_id = pactid
4526: and pac.action_type <> 'I'
4607: pay_assignment_actions_s.nextval
4608: into actyp,
4609: bgid,
4610: aa_id
4611: from pay_payroll_actions pac
4612: where pac.payroll_action_id = pactid;
4613: --
4614: -- Most of the action types require that we look for the legislation
4615: -- rule, i.e. time period dependent (i.e. UK) or time period
4632: USE_NL(asg) */
4633: asg.business_group_id,
4634: asg.period_of_service_id
4635: into bgid, posid
4636: from pay_payroll_actions pac,
4637: per_all_assignments_f asg
4638: where pac.payroll_action_id = pactid
4639: and asg.assignment_id = asgid
4640: and pac.effective_date between
4714: from
4715: per_business_groups_perf pbg,
4716: per_all_assignments_f asg,
4717: per_all_assignments_f as2,
4718: pay_payroll_actions pac
4719: where pac.payroll_action_id = pactid
4720: and asg.payroll_id = pac.payroll_id
4721: and asg.assignment_id = asgid
4722: and pac.effective_date between
4726: as2.effective_start_date and as2.effective_end_date
4727: and pbg.business_group_id = pac.business_group_id
4728: and not exists (
4729: select null
4730: from pay_payroll_actions pa2,
4731: pay_assignment_actions ac2,
4732: per_time_periods ptp
4733: where ac2.assignment_id = asg.assignment_id
4734: and pa2.payroll_action_id = ac2.payroll_action_id
4758: from
4759: per_business_groups_perf pbg,
4760: per_all_assignments_f asg,
4761: per_all_assignments_f as2,
4762: pay_payroll_actions pac
4763: where pac.payroll_action_id = pactid
4764: and asg.payroll_id = pac.payroll_id
4765: and asg.assignment_id = asgid
4766: and pac.effective_date between
4771: and pbg.business_group_id = pac.business_group_id
4772: and not exists (
4773: select null
4774: from pay_action_classifications acl,
4775: pay_payroll_actions pa2,
4776: pay_assignment_actions ac2
4777: where ac2.assignment_id = asg.assignment_id
4778: and pa2.payroll_action_id = ac2.payroll_action_id
4779: and acl.classification_name = 'SEQUENCED'
4810: from per_business_groups_perf pbg,
4811: per_all_assignments_f asg,
4812: per_all_assignments_f as2,
4813: pay_object_groups pog,
4814: pay_payroll_actions pac
4815: where pac.payroll_action_id = pactid
4816: and asg.payroll_id = pac.payroll_id
4817: and asg.assignment_id = asgid
4818: and pac.effective_date between
4825: pog.start_date and pog.end_date
4826: and pog.source_type = 'PAF'
4827: and pbg.business_group_id = pac.business_group_id
4828: and not exists (
4829: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4830: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4831: from pay_assignment_actions ac2,
4832: pay_payroll_actions pa2,
4833: pay_object_groups pog2,
4828: and not exists (
4829: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4830: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4831: from pay_assignment_actions ac2,
4832: pay_payroll_actions pa2,
4833: pay_object_groups pog2,
4834: per_time_periods ptp
4835: where pog2.parent_object_group_id = pog.parent_object_group_id
4836: and ac2.assignment_id = pog2.source_id
4861: from per_business_groups_perf pbg,
4862: per_all_assignments_f asg,
4863: per_all_assignments_f as2,
4864: pay_object_groups pog,
4865: pay_payroll_actions pac
4866: where pac.payroll_action_id = pactid
4867: and asg.payroll_id = pac.payroll_id
4868: and asg.assignment_id = asgid
4869: and pac.effective_date between
4876: pog.start_date and pog.end_date
4877: and pog.source_type = 'PAF'
4878: and pbg.business_group_id = pac.business_group_id
4879: and not exists (
4880: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4881: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4882: from pay_action_classifications acl,
4883: pay_assignment_actions ac2,
4884: pay_payroll_actions pa2,
4880: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4881: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4882: from pay_action_classifications acl,
4883: pay_assignment_actions ac2,
4884: pay_payroll_actions pa2,
4885: pay_object_groups pog2
4886: where pog2.parent_object_group_id = pog.parent_object_group_id
4887: and ac2.assignment_id = pog2.source_id
4888: and pa2.payroll_action_id = ac2.payroll_action_id
4921: from per_business_groups_perf pbg,
4922: per_all_assignments_f asg,
4923: per_all_assignments_f as2,
4924: per_periods_of_service pos,
4925: pay_payroll_actions pac
4926: where pac.payroll_action_id = pactid
4927: and asg.payroll_id = pac.payroll_id
4928: and asg.assignment_id = asgid
4929: and pos.period_of_service_id = asg.period_of_service_id
4933: and pac.date_earned between
4934: as2.effective_start_date and as2.effective_end_date
4935: and pbg.business_group_id = pac.business_group_id
4936: and not exists (
4937: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4938: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4939: from pay_assignment_actions ac2,
4940: pay_payroll_actions pa2,
4941: per_all_assignments_f as2,
4936: and not exists (
4937: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4938: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4939: from pay_assignment_actions ac2,
4940: pay_payroll_actions pa2,
4941: per_all_assignments_f as2,
4942: per_time_periods ptp
4943: where as2.period_of_service_id = pos.period_of_service_id
4944: and ac2.assignment_id = as2.assignment_id
4947: and pac.effective_date between ptp.start_date and ptp.end_date
4948: and pa2.effective_date <= ptp.end_date);
4949: else
4950: hr_utility.set_location('hrassact.inassact_main Normal quickpay ',30);
4951: -- Changes for bug 12356133, forced indexes PAY_PAYROLL_ACTIONS_PK and
4952: -- PAY_ASSIGNMENT_ACTIONS_N1 through hints.
4953: insert into pay_assignment_actions (
4954: assignment_action_id,
4955: assignment_id,
4971: from per_business_groups_perf pbg,
4972: per_all_assignments_f asg,
4973: per_all_assignments_f as2,
4974: per_periods_of_service pos,
4975: pay_payroll_actions pac
4976: where pac.payroll_action_id = pactid
4977: and asg.payroll_id = pac.payroll_id
4978: and asg.assignment_id = asgid
4979: and pos.period_of_service_id = asg.period_of_service_id
4983: and pac.date_earned between
4984: as2.effective_start_date and as2.effective_end_date
4985: and pbg.business_group_id = pac.business_group_id
4986: and not exists (
4987: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4988: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4989: from pay_action_classifications acl,
4990: pay_assignment_actions ac2,
4991: pay_payroll_actions pa2,
4987: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4988: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4989: from pay_action_classifications acl,
4990: pay_assignment_actions ac2,
4991: pay_payroll_actions pa2,
4992: per_all_assignments_f as2
4993: where as2.period_of_service_id = pos.period_of_service_id
4994: and ac2.assignment_id = as2.assignment_id
4995: and pa2.payroll_action_id = ac2.payroll_action_id
5053: and not exists
5054: ( select null
5055: from pay_action_interlocks loc1,
5056: pay_assignment_actions actv,
5057: pay_payroll_actions pactv
5058: where loc1.locked_action_id = act.assignment_action_id
5059: and loc1.locking_action_id = actv.assignment_action_id
5060: and pactv.payroll_action_id = actv.payroll_action_id
5061: and pactv.action_type = 'D'
5099: hr_dynsql.get_tax_unit(asg.assignment_id,
5100: pac.effective_date)
5101: from per_business_groups_perf pbg,
5102: pay_assignment_actions act,
5103: pay_payroll_actions pac, -- prepay action.
5104: pay_payroll_actions pa2, -- the QuickPay action.
5105: per_periods_of_service pos,
5106: per_all_assignments_f asg
5107: where pac.payroll_action_id = pactid
5100: pac.effective_date)
5101: from per_business_groups_perf pbg,
5102: pay_assignment_actions act,
5103: pay_payroll_actions pac, -- prepay action.
5104: pay_payroll_actions pa2, -- the QuickPay action.
5105: per_periods_of_service pos,
5106: per_all_assignments_f asg
5107: where pac.payroll_action_id = pactid
5108: and pa2.payroll_action_id = pac.target_payroll_action_id
5115: and pbg.business_group_id = pac.business_group_id
5116: and not exists (
5117: select null
5118: from pay_assignment_actions ac2,
5119: pay_payroll_actions pa3,
5120: pay_action_interlocks int
5121: where int.locked_action_id = act.assignment_action_id
5122: and ac2.assignment_action_id = int.locking_action_id
5123: and pa3.payroll_action_id = ac2.payroll_action_id
5149:
5150: begin
5151: select pac.action_population_status
5152: into l_action_population_status
5153: from pay_payroll_actions pac
5154: where pac.payroll_action_id = pactid;
5155: exception
5156: when others then
5157: l_action_population_status := 'U';
5157: l_action_population_status := 'U';
5158: end;
5159:
5160: if l_action_population_status <> 'C' then
5161: update pay_payroll_actions pac
5162: set pac.action_population_status = 'C'
5163: where pac.payroll_action_id = pactid;
5164: end if;
5165: --
5238: end if;
5239: select act.assignment_id
5240: into l_assignment_id
5241: from pay_assignment_actions act,
5242: pay_payroll_actions pac
5243: where pac.payroll_action_id = p_payroll_action_id
5244: and act.payroll_action_id = pac.target_payroll_action_id
5245: and act.source_action_id is null;
5246: --
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,
5264: pay_assignment_actions act
5265: where pac.payroll_action_id = p_payroll_action_id
5266: and act.payroll_action_id = pac.target_payroll_action_id
5267: and act.source_action_id is null;
5280: -- appropriate date_earned value.
5281: if g_debug then
5282: hr_utility.set_location('hrassact.qpppassact',50);
5283: end if;
5284: update pay_payroll_actions pac
5285: set pac.date_earned = (
5286: select pa2.date_earned
5287: from pay_payroll_actions pa2,
5288: pay_assignment_actions act
5283: end if;
5284: update pay_payroll_actions pac
5285: set pac.date_earned = (
5286: select pa2.date_earned
5287: from pay_payroll_actions pa2,
5288: pay_assignment_actions act
5289: where act.assignment_action_id = l_locked_action_id
5290: and pa2.payroll_action_id = act.payroll_action_id)
5291:
5359: null) organization_id,
5360: ppa.effective_date
5361: from pay_assignment_actions paa,
5362: pay_run_results prr,
5363: pay_payroll_actions ppa
5364: where paa.assignment_action_id = revassactid
5365: and ppa.payroll_action_id = paa.payroll_action_id
5366: and paa.assignment_action_id = prr.assignment_action_id;
5367: --
5368: -- cursor and variables used in reversal of pay_run_balances
5369: --
5370: rev_asgact_id pay_assignment_actions.assignment_action_id%type;
5371: rev_act_seq pay_assignment_actions.action_sequence%type;
5372: rev_eff_date pay_payroll_actions.effective_date%type;
5373: --
5374: asgid number; -- assignment_id.
5375: taxunt number; -- tax unit id if legislation is US
5376: run_type_id number;
5419: pbg.legislation_code
5420: into asgid, taxunt,run_type_id, leg_code
5421: from pay_action_classifications acl,
5422: pay_assignment_actions ac2,
5423: pay_payroll_actions pa2,
5424: per_business_groups_perf pbg,
5425: pay_payroll_actions pac
5426: where pac.payroll_action_id = pactid
5427: and pbg.business_group_id = pac.business_group_id
5421: from pay_action_classifications acl,
5422: pay_assignment_actions ac2,
5423: pay_payroll_actions pa2,
5424: per_business_groups_perf pbg,
5425: pay_payroll_actions pac
5426: where pac.payroll_action_id = pactid
5427: and pbg.business_group_id = pac.business_group_id
5428: and ac2.assignment_action_id = assactid
5429: and pa2.payroll_action_id = ac2.payroll_action_id
5477: from dual
5478: where not exists (
5479: select null
5480: from pay_assignment_actions ac2,
5481: pay_payroll_actions pa2,
5482: pay_action_interlocks pai
5483: where pai.locked_action_id = assactid
5484: and ac2.assignment_action_id = pai.locking_action_id
5485: and pa2.payroll_action_id = ac2.payroll_action_id
5619: hr_utility.set_location('hrassact.reversal',25);
5620: end if;
5621: select 1
5622: into dummy
5623: from pay_payroll_actions pac,
5624: pay_element_types_f pet
5625: where pac.payroll_action_id = pactid
5626: and pet.element_type_id = etypid
5627: and pac.effective_date between
5756: * to_number(rrv.result_value, mask_36_dec_places)
5757: , mask_36_dec_places), '.'),
5758: 'ND' , rtrim(to_char((-1) * to_number(rrv.result_value, mask_36_dec_places), mask_36_dec_places), '.'),
5759: rrv.result_value)
5760: from pay_payroll_actions pac,
5761: pay_run_result_values rrv,
5762: pay_input_values_f piv
5763: where pac.payroll_action_id = pactid
5764: and rrv.run_result_id = oldrrid
5794: --
5795: -- To signal that processing has been successfully
5796: -- completed, update the action_status to (C)omplete.
5797: hr_utility.set_location('hrassact.reversal',40);
5798: update pay_payroll_actions pac
5799: set pac.action_status = 'C'
5800: where pac.payroll_action_id = pactid;
5801: end;
5802: --
5818: into rev_asgact_id
5819: , rev_act_seq
5820: , rev_eff_date
5821: from pay_assignment_actions paa
5822: , pay_payroll_actions ppa
5823: where paa.payroll_action_id = pactid
5824: and paa.payroll_action_id = ppa.payroll_action_id;
5825:
5826: else
5831: into rev_asgact_id
5832: , rev_act_seq
5833: , rev_eff_date
5834: from pay_assignment_actions paa,
5835: pay_payroll_actions ppa
5836: where paa.assignment_action_id = assactid
5837: and ppa.payroll_action_id = paa.payroll_action_id;
5838:
5839: end if;
5926: pet.element_type_id,
5927: act.assignment_action_id,
5928: pee.entry_type,
5929: pee.element_entry_id
5930: from pay_payroll_actions pac,
5931: pay_assignment_actions act,
5932: pay_action_interlocks pai,
5933: pay_assignment_actions act2,
5934: pay_run_results rr2,
5997: result_value)
5998: select pev.input_value_id,
5999: pay_run_results_s.currval,
6000: null
6001: from pay_payroll_actions pac,
6002: pay_assignment_actions act, -- reversal
6003: pay_element_entry_values_f pev
6004: where act.assignment_action_id = c1rec.assignment_action_id --rev
6005: and act.payroll_action_id = pac.payroll_action_id
6036: l_business_group_id number;
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,
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
6046: where paa.ASSIGNMENT_ACTION_ID = p_assignment_action_id
6047: and paa.PAYROLL_ACTION_ID = pa.PAYROLL_ACTION_ID;
6048: --
6049: begin
6063: -- insert the payroll action row
6064: if g_debug then
6065: hr_utility.set_location(c_indent,10);
6066: end if;
6067: insert into PAY_PAYROLL_ACTIONS
6068: (PAYROLL_ACTION_ID,
6069: ACTION_TYPE,
6070: BUSINESS_GROUP_ID,
6071: CONSOLIDATION_SET_ID,
6114: -- the appropriate date earned value.
6115: if g_debug then
6116: hr_utility.set_location(c_indent,40);
6117: end if;
6118: update pay_payroll_actions pac
6119: set pac.date_earned = (
6120: select pa2.date_earned
6121: from pay_payroll_actions pa2,
6122: pay_assignment_actions act
6117: end if;
6118: update pay_payroll_actions pac
6119: set pac.date_earned = (
6120: select pa2.date_earned
6121: from pay_payroll_actions pa2,
6122: pay_assignment_actions act
6123: where act.assignment_action_id = p_assignment_action_id
6124: and pa2.payroll_action_id = act.payroll_action_id
6125: )
6251: pay_id
6252: ,l_action_type
6253: ,l_effective_date
6254: from
6255: pay_payroll_actions pac
6256: ,pay_assignment_actions aa
6257: where
6258: aa.assignment_action_id = p_assact
6259: and pac.payroll_action_id = aa.payroll_action_id;
6712: select /*+ ordered use_nl(pee asg ptp pbg)
6713: index(pee PAY_ELEMENT_ENTRIES_F_PK)
6714: index(asg PER_ASSIGNMENTS_F_PK)
6715: index(ptp PER_TIME_PERIODS_N50) */
6716: pay_payroll_actions_s.nextval,
6717: asg.business_group_id,
6718: pbg.legislation_code,
6719: asg.assignment_id,
6720: asg.payroll_id,
6768: -- insert payroll action row.
6769: if g_debug then
6770: hr_utility.set_location(c_indent,10);
6771: end if;
6772: insert into pay_payroll_actions (
6773: payroll_action_id,
6774: action_type,
6775: business_group_id,
6776: consolidation_set_id,
6793: 'C',
6794: 'C',
6795: effdate,
6796: dtearned,
6797: pay_payroll_actions_s.nextval,
6798: tperiod,
6799: prepay_flag,
6800: creatby,
6801: creatdate,
7126:
7127: bal_dims bal_dims_cache;
7128:
7129: c_indent constant varchar2(30) := 'hrassact.maintain_lat_bal';
7130: pactid pay_payroll_actions.payroll_action_id%TYPE;
7131: asgid per_all_assignments_f.assignment_id%TYPE;
7132: bus_grp_id per_all_assignments_f.business_group_id%TYPE;
7133: l_person_id per_all_assignments_f.person_id%TYPE;
7134: cxt_id number;
7857: ) return date is
7858: l_expiry_date date;
7859: --
7860: c_indent constant varchar2(35) := 'hrassact.get_expiry_date';
7861: l_payroll_action pay_payroll_actions.payroll_action_id%type;
7862: l_effective_date pay_payroll_actions.effective_date%type;
7863: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
7864: l_expiry_chk_str varchar2(2000); -- used with dynamic pl/sql
7865: sql_cursor integer;
7858: l_expiry_date date;
7859: --
7860: c_indent constant varchar2(35) := 'hrassact.get_expiry_date';
7861: l_payroll_action pay_payroll_actions.payroll_action_id%type;
7862: l_effective_date pay_payroll_actions.effective_date%type;
7863: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
7864: l_expiry_chk_str varchar2(2000); -- used with dynamic pl/sql
7865: sql_cursor integer;
7866: l_rows integer;
7859: --
7860: c_indent constant varchar2(35) := 'hrassact.get_expiry_date';
7861: l_payroll_action pay_payroll_actions.payroll_action_id%type;
7862: l_effective_date pay_payroll_actions.effective_date%type;
7863: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
7864: l_expiry_chk_str varchar2(2000); -- used with dynamic pl/sql
7865: sql_cursor integer;
7866: l_rows integer;
7867: --
7890: pay.effective_date
7891: into l_bal_owner_pay_action,
7892: p_bal_owner_eff_date
7893: from pay_assignment_actions asg
7894: , pay_payroll_actions pay
7895: where asg.assignment_action_id = p_bal_owner_asg_actid
7896: and pay.payroll_action_id = asg.payroll_action_id;
7897: --
7898: -- Get the payroll_action_id and eff date for the adjustment if
7906: pay.effective_date
7907: into l_payroll_action,
7908: l_effective_date
7909: from pay_assignment_actions asg
7910: , pay_payroll_actions pay
7911: where asg.assignment_action_id = p_ass_action_id
7912: and pay.payroll_action_id = asg.payroll_action_id;
7913: else
7914: l_payroll_action := l_bal_owner_pay_action;
8071: l_change_flag boolean;
8072: --
8073: c_indent constant varchar2(35) := 'hrassact.feed_balance';
8074: lat_bal_exp_date date;
8075: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8076: bal_adj_exp_date date;
8077: bal_adj_eff_date pay_payroll_actions.effective_date%type;
8078: prev_bal_exp_date date;
8079: p_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8073: c_indent constant varchar2(35) := 'hrassact.feed_balance';
8074: lat_bal_exp_date date;
8075: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8076: bal_adj_exp_date date;
8077: bal_adj_eff_date pay_payroll_actions.effective_date%type;
8078: prev_bal_exp_date date;
8079: p_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8080: exp_bal_exp_date date;
8081: e_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8075: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8076: bal_adj_exp_date date;
8077: bal_adj_eff_date pay_payroll_actions.effective_date%type;
8078: prev_bal_exp_date date;
8079: p_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8080: exp_bal_exp_date date;
8081: e_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8082: --
8083: begin
8077: bal_adj_eff_date pay_payroll_actions.effective_date%type;
8078: prev_bal_exp_date date;
8079: p_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8080: exp_bal_exp_date date;
8081: e_bal_owner_eff_date pay_payroll_actions.effective_date%type;
8082: --
8083: begin
8084: --
8085: if g_debug then
8718: hrassact.gv_dum_qpay := FALSE ;
8719: hr_utility.set_location ('hrassact.ins_dummy_quickpay_action', 30);
8720:
8721: if v_payroll_action_id is not null and v_assignment_action_id is not null then
8722: /*Inserting the action sequence in pay_payroll_actions since
8723: it is not inserted by the previous called api
8724: also inserting the batch_process_mode as DUM_QPAY to indicate
8725: the payrollaction is inserted using this code*/
8726:
8723: it is not inserted by the previous called api
8724: also inserting the batch_process_mode as DUM_QPAY to indicate
8725: the payrollaction is inserted using this code*/
8726:
8727: update pay_payroll_actions
8728: set action_sequence = pay_payroll_actions_s.nextval,
8729: batch_process_mode = 'DUM_QPAY'
8730: where payroll_action_id = v_payroll_action_id
8731: and action_sequence is null;
8724: also inserting the batch_process_mode as DUM_QPAY to indicate
8725: the payrollaction is inserted using this code*/
8726:
8727: update pay_payroll_actions
8728: set action_sequence = pay_payroll_actions_s.nextval,
8729: batch_process_mode = 'DUM_QPAY'
8730: where payroll_action_id = v_payroll_action_id
8731: and action_sequence is null;
8732:
8766:
8767: hr_utility.set_location ('hrassact.ins_dummy_quickpay_action', 70);
8768: /*Updating the payroll action status as complete*/
8769:
8770: update pay_payroll_actions
8771: set action_status = 'C'
8772: where payroll_action_id = v_payroll_action_id;
8773:
8774: hr_utility.set_location ('hrassact.ins_dummy_quickpay_action', 80);