APPS.HRASSACT dependencies on PAY_CORE_UTILS

Line 56: 22-Nov-2010 priupadh 115.151 10212578 Modified maintain_lat_bal now calling pay_core_utils.get_legislation_rule

52: 23digits 36decimals as result value for customer exceeded
53: 21digits before decimal.
54: 16-Jun-2011 vpallapo 115.152 12356133 Performance fix, added hints to force indexes and avoid full table scans
55: while inserting into pay_assignment_actions.
56: 22-Nov-2010 priupadh 115.151 10212578 Modified maintain_lat_bal now calling pay_core_utils.get_legislation_rule
57: for leg rule 'BAL_ADJ_LAT_BAL'
58: 22-Apr-2010 phattarg 115.150 9089219 Removed ORDERED hint from cursor albc_selective
59: in hrassact.del_latest_balances.
60: 21-Apr-2010 phattarg 115.149 8994425 Corrected the behavior of trash_latest_balances procedure

Line 673: g_dynamic_contexts pay_core_utils.t_contexts_tab;

669: g_context_cache context_cache_type;
670: contexts_cached boolean := FALSE;
671: g_lat_bal_check_mode pay_action_parameters.parameter_value%TYPE := null;
672: g_debug boolean := hr_utility.debug_enabled;
673: g_dynamic_contexts pay_core_utils.t_contexts_tab;
674: --
675: --
676: --
677: /*------------------------ val_pact_rr_rules ---------------------------*/

Line 5456: select pay_core_utils.get_process_path(assactid)

5452: from pay_assignment_actions act
5453: where act.payroll_action_id = pactid
5454: and act.assignment_id = asgid;
5455: --
5456: select pay_core_utils.get_process_path(assactid)
5457: into l_process_path
5458: from dual;
5459: -- need to set process path for reversals
5460: update pay_assignment_actions

Line 5682: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'

5678: -- -1 as before.
5679: -- Need to get input_value name for SOURCE_ID and SOURCE_NUMBER
5680: --
5681: hr_utility.trace('leg_code: '||leg_code);
5682: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'
5683: ,leg_code
5684: ,l_src_iv
5685: ,l_iv_found);
5686: if (not l_iv_found) then

Line 5693: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER'

5689: l_si_needed := 'Y';
5690: hr_utility.trace('l_src_iv: '||l_src_iv);
5691: end if;
5692: --
5693: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER'
5694: ,leg_code
5695: ,l_src_num
5696: ,l_num_found);
5697: if (not l_num_found) then

Line 5704: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2'

5700: l_sn_needed := 'Y';
5701: hr_utility.trace('l_src_num: '||l_src_num);
5702: end if;
5703: --
5704: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2'
5705: ,leg_code
5706: ,l_src_num2
5707: ,l_num_found);
5708: if (not l_num_found) then

Line 5715: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID'

5711: l_sn2_needed := 'Y';
5712: hr_utility.trace('l_src_num2: '||l_src_num2);
5713: end if;
5714: --
5715: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID'
5716: ,leg_code
5717: ,l_org_id_iv
5718: ,l_num_found);
5719: if (not l_num_found) then

Line 6240: pay_core_utils.get_dynamic_contexts(p_busgrp,

6236: if g_debug then
6237: hr_utility.set_location(c_indent,10);
6238: end if;
6239: udca.sz := 0;
6240: pay_core_utils.get_dynamic_contexts(p_busgrp,
6241: g_dynamic_contexts);
6242: --
6243: --
6244: -- Get Payroll ID and Action Type

Line 6432: pay_core_utils.assert_condition('set_action_context:1',

6428: and hoi.org_information1 = 'HR_PAYEE';
6429:
6430: exception
6431: when no_data_found then
6432: pay_core_utils.assert_condition('set_action_context:1',
6433: 1 = 2);
6434: end;
6435: end if;
6436: --

Line 6827: pay_core_utils.get_leg_context_iv_name

6823: end if;
6824:
6825:
6826: -- calc jur code name
6827: pay_core_utils.get_leg_context_iv_name
6828: ('JURISDICTION_CODE',
6829: legcode,
6830: l_jc_name,
6831: l_found);

Line 6839: pay_core_utils.get_legislation_rule('RR_SPARSE',

6835: end if;
6836:
6837:
6838: -- set rr sparse leg_rule
6839: pay_core_utils.get_legislation_rule('RR_SPARSE',
6840: legcode,
6841: l_rule_mode,
6842: l_found
6843: );

Line 6851: pay_core_utils.get_upgrade_status(busgrp,

6847:
6848: if upper(l_rule_mode)='Y'
6849: then
6850: -- Confirm Enabling Upgrade has been made by customer
6851: pay_core_utils.get_upgrade_status(busgrp,
6852: 'ENABLE_RR_SPARSE',
6853: l_status);
6854:
6855: if upper(l_status)='N'

Line 6868: pay_core_utils.get_upgrade_status(busgrp,

6864: else
6865: l_rr_sparse :=FALSE;
6866: end if;
6867: --
6868: pay_core_utils.get_upgrade_status(busgrp,
6869: 'RR_SPARSE_JC',
6870: l_status);
6871: --
6872: if upper(l_status)='Y'

Line 8437: pay_core_utils.get_legislation_rule('BAL_ADJ_LAT_BAL',pay_core_utils.get_legislation_code(bus_grp_id),l_rule_mode,leg_rule_found);

8433: if g_ba_lat_bal_maintenance is null then
8434:
8435: /*Bug 10212578 12.2 Begin */
8436: leg_rule_found := FALSE;
8437: pay_core_utils.get_legislation_rule('BAL_ADJ_LAT_BAL',pay_core_utils.get_legislation_code(bus_grp_id),l_rule_mode,leg_rule_found);
8438:
8439: if leg_rule_found = FALSE then
8440: l_rule_mode := 'N';
8441: end if;

Line 8494: pay_core_utils.get_upgrade_status(p_bus_grp_id=> bus_grp_id,

8490: -- return contents of udca
8491: bal_context_string := get_contexts(udca);
8492:
8493:
8494: pay_core_utils.get_upgrade_status(p_bus_grp_id=> bus_grp_id,
8495: p_short_name=> 'SINGLE_BAL_TABLE',
8496: p_status=>l_status);
8497:
8498: if (l_status='N')

Line 8638: and pay_core_utils.get_process_path(child_asg.assignment_action_id)

8634: and child_asg.source_action_id is not null
8635: and child_asg.assignment_id=mast_asg.assignment_id
8636: and child_asg.payroll_action_id=mast_asg.payroll_action_id
8637: and child_asg.action_status<>'B'
8638: and pay_core_utils.get_process_path(child_asg.assignment_action_id)
8639: =rev_asg.process_path
8640: and rev_asg.assignment_action_id=p_act_id
8641: and pai.locking_action_id=p_act_id
8642: and pai.locked_action_id=child_asg.assignment_action_id;