DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on HRASSACT

Line 5439: hrassact.inassact procedure to insert the corresponding assignment action

5435: The balance routes are all driven off assignment action id. So, when a
5436: balance is required for a particular date, a payroll action and assignment
5437: action are temporarily created. This is done by setting a savepoint,
5438: inserting a dummy payroll action for the required date, and calling the
5439: hrassact.inassact procedure to insert the corresponding assignment action
5440: and shuffle any later assignment actions along. The get_value
5441: function is then called with the dummy assignment action, which returns the
5442: balance value for the required date. A rollback then removes the temporary
5443: payroll action and assignment action.

Line 5625: hrassact.inassact (pactid => l_pay_action_id,

5621: --
5622: if g_debug then
5623: hr_utility.set_location ('pay_balance_pkg.get_value', 25);
5624: end if;
5625: hrassact.inassact (pactid => l_pay_action_id,
5626: asgid => p_assignment_id,
5627: p_asg_lock => l_asg_lock);
5628: --
5629: -- retrieve the assignment action id:

Line 5967: if HRASSACT.CHECK_LATEST_BALANCES = TRUE then

5963: if g_debug then
5964: hr_utility.set_location('Entering: pay_balance_pkg.invalidate_run_balances',5);
5965: end if;
5966: --
5967: if HRASSACT.CHECK_LATEST_BALANCES = TRUE then
5968: --
5969: for each_row in get_def_bals(p_balance_type_id, p_input_value_id) loop
5970: --
5971: if l_rrv_found = -1 then

Line 10183: -- This procedure sets the HRASSACT CHECK_LATEST_BALANCES global

10179: hr_utility.set_location('Leaving: pay_balance_pkg.initialise_run_balance', 120);
10180: end initialise_run_balance;
10181: --------------------------------------------------------------------------
10182: -- procedure set_check_latest_balances
10183: -- This procedure sets the HRASSACT CHECK_LATEST_BALANCES global
10184: -- so that latest and run level balances ARE looked for
10185: --------------------------------------------------------------------------
10186: procedure set_check_latest_balances
10187: is

Line 10195: HRASSACT.CHECK_LATEST_BALANCES := TRUE;

10191: if g_debug then
10192: hr_utility.set_location('Entering: pay_balance_pkg.set_check_latest_balances',5);
10193: end if;
10194: --
10195: HRASSACT.CHECK_LATEST_BALANCES := TRUE;
10196: --
10197: if g_debug then
10198: hr_utility.set_location('Exiting: pay_balance_pkg.set_check_latest_balances',5);
10199: end if;

Line 10204: -- This procedure sets the HRASSACT CHECK_LATEST_BALANCES global

10200: --
10201: end set_check_latest_balances;
10202: --------------------------------------------------------------------------
10203: -- procedure unset_check_latest_balances
10204: -- This procedure sets the HRASSACT CHECK_LATEST_BALANCES global
10205: -- so that latest and run level balances ARE NOT looked for
10206: --------------------------------------------------------------------------
10207: procedure unset_check_latest_balances
10208: is

Line 10216: HRASSACT.CHECK_LATEST_BALANCES := FALSE;

10212: if g_debug then
10213: hr_utility.set_location('Entering: pay_balance_pkg.unset_check_latest_balances',5);
10214: end if;
10215: --
10216: HRASSACT.CHECK_LATEST_BALANCES := FALSE;
10217: --
10218: if g_debug then
10219: hr_utility.set_location('Exiting: pay_balance_pkg.unset_check_latest_balances',5);
10220: end if;

Line 10349: udca hrassact.context_details;

10345: leg_code per_business_groups_perf.legislation_code%type;
10346: l_found boolean;
10347: cxt_id number;
10348:
10349: udca hrassact.context_details;
10350:
10351:
10352: begin
10353: if g_debug then

Line 10354: hr_utility.set_location('hrassact.reversal',50);

10350:
10351:
10352: begin
10353: if g_debug then
10354: hr_utility.set_location('hrassact.reversal',50);
10355: end if;
10356: --
10357: select paa.assignment_id,
10358: ppa.effective_date,

Line 10380: hr_utility.set_location('hrassact.reversal',55);

10376: p_delta => null);
10377: --
10378: --
10379: if g_debug then
10380: hr_utility.set_location('hrassact.reversal',55);
10381: end if;
10382: --
10383: -- 2nd the group level run balances
10384: --

Line 10386: hr_utility.set_location('hrassact.reversal',60);

10382: --
10383: -- 2nd the group level run balances
10384: --
10385: if g_debug then
10386: hr_utility.set_location('hrassact.reversal',60);
10387: end if;
10388: --
10389: pay_balance_pkg.create_all_group_balances(l_pactid,
10390: 'ALL',

Line 10448: hr_utility.set_location('hrassact.reversal', 70);

10444: --
10445: -- delete latest balances
10446: --
10447: if g_debug then
10448: hr_utility.set_location('hrassact.reversal', 70);
10449: end if;
10450:
10451: --
10452: -- NB could enhance to

Line 10457: hrassact.del_latest_balances(l_asg_id, l_eff_date, null);

10453: -- loop for each reversal run result and run
10454: -- del_latest_balances(l_asg_id, l_eff_date, null, l_element_type_id);
10455: -- to minimise loss of latest balances
10456: --
10457: hrassact.del_latest_balances(l_asg_id, l_eff_date, null);
10458: else
10459: --
10460: -- Support maintenance of latest balances
10461: --

Line 10463: hr_utility.set_location('hrassact.reversal', 80);

10459: --
10460: -- Support maintenance of latest balances
10461: --
10462: if g_debug then
10463: hr_utility.set_location('hrassact.reversal', 80);
10464: end if;
10465: --
10466: hr_utility.trace('leg_code: '||leg_code);
10467: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'

Line 10566: hrassact.get_cache_context('PAYROLL_ID', cxt_id);

10562: l_org_needed) loop
10563:
10564: -- Load the udca with the context values
10565: udca.sz := 1;
10566: hrassact.get_cache_context('PAYROLL_ID', cxt_id);
10567: udca.cxt_id(udca.sz) := cxt_id;
10568: udca.cxt_name(udca.sz) := 'PAYROLL_ID';
10569: udca.cxt_value(udca.sz) := rr.payroll_id;
10570: udca.sz := udca.sz + 1;

Line 10571: hrassact.get_cache_context('ORIGINAL_ENTRY_ID', cxt_id);

10567: udca.cxt_id(udca.sz) := cxt_id;
10568: udca.cxt_name(udca.sz) := 'PAYROLL_ID';
10569: udca.cxt_value(udca.sz) := rr.payroll_id;
10570: udca.sz := udca.sz + 1;
10571: hrassact.get_cache_context('ORIGINAL_ENTRY_ID', cxt_id);
10572: udca.cxt_id(udca.sz) := cxt_id;
10573: udca.cxt_name(udca.sz) := 'ORIGINAL_ENTRY_ID';
10574: udca.cxt_value(udca.sz) := rr.original_entry_id;
10575: if rr.tax_unit_id is not null then

Line 10577: hrassact.get_cache_context('TAX_UNIT_ID', cxt_id);

10573: udca.cxt_name(udca.sz) := 'ORIGINAL_ENTRY_ID';
10574: udca.cxt_value(udca.sz) := rr.original_entry_id;
10575: if rr.tax_unit_id is not null then
10576: udca.sz := udca.sz + 1;
10577: hrassact.get_cache_context('TAX_UNIT_ID', cxt_id);
10578: udca.cxt_id(udca.sz) := cxt_id;
10579: udca.cxt_name(udca.sz) := 'TAX_UNIT_ID';
10580: udca.cxt_value(udca.sz) := rr.tax_unit_id;
10581: end if;

Line 10584: hrassact.get_cache_context('JURISDICTION_CODE', cxt_id);

10580: udca.cxt_value(udca.sz) := rr.tax_unit_id;
10581: end if;
10582: if rr.jurisdiction_code is not null then
10583: udca.sz := udca.sz + 1;
10584: hrassact.get_cache_context('JURISDICTION_CODE', cxt_id);
10585: udca.cxt_id(udca.sz) := cxt_id;
10586: udca.cxt_name(udca.sz) := 'JURISDICTION_CODE';
10587: udca.cxt_value(udca.sz) := rr.jurisdiction_code;
10588: end if;

Line 10591: hrassact.get_cache_context('SOURCE_ID', cxt_id);

10587: udca.cxt_value(udca.sz) := rr.jurisdiction_code;
10588: end if;
10589: if rr.source_id is not null then
10590: udca.sz := udca.sz + 1;
10591: hrassact.get_cache_context('SOURCE_ID', cxt_id);
10592: udca.cxt_id(udca.sz) := cxt_id;
10593: udca.cxt_name(udca.sz) := 'SOURCE_ID';
10594: udca.cxt_value(udca.sz) := rr.source_id;
10595: end if;

Line 10598: hrassact.get_cache_context('SOURCE_TEXT', cxt_id);

10594: udca.cxt_value(udca.sz) := rr.source_id;
10595: end if;
10596: if rr.source_text is not null then
10597: udca.sz := udca.sz + 1;
10598: hrassact.get_cache_context('SOURCE_TEXT', cxt_id);
10599: udca.cxt_id(udca.sz) := cxt_id;
10600: udca.cxt_name(udca.sz) := 'SOURCE_TEXT';
10601: udca.cxt_value(udca.sz) := rr.source_text;
10602: end if;

Line 10605: hrassact.get_cache_context('SOURCE_TEXT2', cxt_id);

10601: udca.cxt_value(udca.sz) := rr.source_text;
10602: end if;
10603: if rr.source_text2 is not null then
10604: udca.sz := udca.sz + 1;
10605: hrassact.get_cache_context('SOURCE_TEXT2', cxt_id);
10606: udca.cxt_id(udca.sz) := cxt_id;
10607: udca.cxt_name(udca.sz) := 'SOURCE_TEXT2';
10608: udca.cxt_value(udca.sz) := rr.source_text2;
10609: end if;

Line 10612: hrassact.get_cache_context('SOURCE_NUMBER', cxt_id);

10608: udca.cxt_value(udca.sz) := rr.source_text2;
10609: end if;
10610: if rr.source_number is not null then
10611: udca.sz := udca.sz + 1;
10612: hrassact.get_cache_context('SOURCE_NUMBER', cxt_id);
10613: udca.cxt_id(udca.sz) := cxt_id;
10614: udca.cxt_name(udca.sz) := 'SOURCE_NUMBER';
10615: udca.cxt_value(udca.sz) := rr.source_number;
10616: end if;

Line 10619: hrassact.get_cache_context('SOURCE_NUMBER2', cxt_id);

10615: udca.cxt_value(udca.sz) := rr.source_number;
10616: end if;
10617: if rr.source_number2 is not null then
10618: udca.sz := udca.sz + 1;
10619: hrassact.get_cache_context('SOURCE_NUMBER2', cxt_id);
10620: udca.cxt_id(udca.sz) := cxt_id;
10621: udca.cxt_name(udca.sz) := 'SOURCE_NUMBER2';
10622: udca.cxt_value(udca.sz) := rr.source_number2;
10623: end if;

Line 10626: hrassact.get_cache_context('ORGANIZATION_ID', cxt_id);

10622: udca.cxt_value(udca.sz) := rr.source_number2;
10623: end if;
10624: if rr.organization_id is not null then
10625: udca.sz := udca.sz + 1;
10626: hrassact.get_cache_context('ORGANIZATION_ID', cxt_id);
10627: udca.cxt_id(udca.sz) := cxt_id;
10628: udca.cxt_name(udca.sz) := 'ORGANIZATION_ID';
10629: udca.cxt_value(udca.sz) := rr.organization_id;
10630: end if;

Line 10633: hrassact.get_cache_context('LOCAL_UNIT_ID', cxt_id);

10629: udca.cxt_value(udca.sz) := rr.organization_id;
10630: end if;
10631: if rr.local_unit_id is not null then
10632: udca.sz := udca.sz + 1;
10633: hrassact.get_cache_context('LOCAL_UNIT_ID', cxt_id);
10634: udca.cxt_id(udca.sz) := cxt_id;
10635: udca.cxt_name(udca.sz) := 'LOCAL_UNIT_ID';
10636: udca.cxt_value(udca.sz) := rr.local_unit_id;
10637: end if;

Line 10640: hrassact.get_cache_context('TAX_GROUP', cxt_id);

10636: udca.cxt_value(udca.sz) := rr.local_unit_id;
10637: end if;
10638: if l_tax_group is not null then
10639: udca.sz := udca.sz + 1;
10640: hrassact.get_cache_context('TAX_GROUP', cxt_id);
10641: udca.cxt_id(udca.sz) := cxt_id;
10642: udca.cxt_name(udca.sz) := 'TAX_GROUP';
10643: udca.cxt_value(udca.sz) := l_tax_group;
10644: end if;

Line 10648: hrassact.maintain_lat_bal(assactid => p_asg_action,

10644: end if;
10645:
10646: -- call balance maintenance code
10647:
10648: hrassact.maintain_lat_bal(assactid => p_asg_action,
10649: rrid => rr.run_result_id,
10650: eentryid => null,
10651: effdate => l_eff_date,
10652: udca => udca,

Line 10660: hr_utility.set_location('Leaving: hrassact.reversal', 100);

10656:
10657: end if;
10658: --
10659: if g_debug then
10660: hr_utility.set_location('Leaving: hrassact.reversal', 100);
10661: end if;
10662:
10663: end maintain_balances_for_action;
10664: --