DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_BALANCE_PKG

Line 486: pay_balance_pkg.get_value_lock

482: l_asg_balance_time,
483: l_asg_vdate_cursor);
484: --
485: l_balance_value := l_balance_value +
486: pay_balance_pkg.get_value_lock
487: (l_defined_balance_id,
488: l_asg_id,
489: l_virtual_date,
490: l_run_route_bool,

Line 505: l_balance_value := pay_balance_pkg.get_value_lock

501: --
502: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 50);
503: l_defined_balance_id := get_defined_balance(p_balance_name,
504: p_database_suffix);
505: l_balance_value := pay_balance_pkg.get_value_lock
506: (l_defined_balance_id,
507: p_assignment_id,
508: p_virtual_date,
509: l_run_route_bool,

Line 521: l_balance_value := pay_balance_pkg.get_value_lock

517: --
518: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 60);
519: l_defined_balance_id := get_defined_balance(p_balance_name,
520: p_database_suffix);
521: l_balance_value := pay_balance_pkg.get_value_lock
522: (l_defined_balance_id,
523: p_assignment_id,
524: p_virtual_date,
525: l_run_route_bool,

Line 578: l_balance_value := pay_balance_pkg.get_value (l_defined_balance_id,

574: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 10);
575: --
576: l_defined_balance_id := get_defined_balance(p_balance_name,
577: p_database_suffix);
578: l_balance_value := pay_balance_pkg.get_value (l_defined_balance_id,
579: p_assignment_action_id,
580: l_run_route_bool,
581: FALSE
582: );

Line 699: return pay_balance_pkg.get_value (l_defined_balance_id,

695: l_defined_balance_id := get_defined_balance(p_balance_name,
696: p_dimension_suffix);
697: IF p_dimension_suffix not like '%PAY%' THEN
698: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 30);
699: return pay_balance_pkg.get_value (l_defined_balance_id,
700: p_assignment_action_id,
701: l_run_route_bool,
702: FALSE
703: );

Line 706: return pay_balance_pkg.get_value (l_defined_balance_id,

702: FALSE
703: );
704: ELSE /* If payments dimension then must execute DB item 395029 */
705: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 40);
706: return pay_balance_pkg.get_value (l_defined_balance_id,
707: p_assignment_action_id,
708: true );
709: -- END IF;
710: end if;

Line 735: return pay_balance_pkg.get_value_lock

731: l_defined_balance_id := get_defined_balance(p_balance_name,
732: p_dimension_suffix);
733: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',
734: 60);
735: return pay_balance_pkg.get_value_lock
736: (l_defined_balance_id,
737: p_assignment_id,
738: p_virtual_date,
739: l_run_route_bool,

Line 1076: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);

1072: -- them up front
1073: --
1074: hr_utility.set_location('pay_tax_bals_pkg',30);
1075: --
1076: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1077: IF p_jd_context IS NOT NULL THEN
1078: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1079: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1080: '-'||substr(p_jd_context,13,5));

Line 1079: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||

1075: --
1076: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1077: IF p_jd_context IS NOT NULL THEN
1078: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1079: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1080: '-'||substr(p_jd_context,13,5));
1081: ELSE
1082: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1083: END IF;

Line 1082: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);

1078: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1079: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1080: '-'||substr(p_jd_context,13,5));
1081: ELSE
1082: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1083: END IF;
1084: END IF;
1085: --
1086: hr_utility.set_location('pay_tax_bals_pkg',40);

Line 1344: pay_balance_pkg.set_context('DATE_EARNED',

1340: l_count number;
1341: l_found boolean;
1342: check_asg number;
1343: begin
1344: pay_balance_pkg.set_context('DATE_EARNED',
1345: fnd_date.date_to_canonical(l_virtual_date));
1346: pay_balance_pkg.set_context('BALANCE_DATE',
1347: fnd_date.date_to_canonical(l_virtual_date));
1348: select business_group_id

Line 1346: pay_balance_pkg.set_context('BALANCE_DATE',

1342: check_asg number;
1343: begin
1344: pay_balance_pkg.set_context('DATE_EARNED',
1345: fnd_date.date_to_canonical(l_virtual_date));
1346: pay_balance_pkg.set_context('BALANCE_DATE',
1347: fnd_date.date_to_canonical(l_virtual_date));
1348: select business_group_id
1349: into l_bg_id
1350: from hr_organization_units