DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_BALANCE_PKG

Line 473: pay_balance_pkg.get_value_lock

469: l_asg_balance_time,
470: l_asg_vdate_cursor);
471: --
472: l_balance_value := l_balance_value +
473: pay_balance_pkg.get_value_lock
474: (l_defined_balance_id,
475: l_asg_id,
476: l_virtual_date,
477: l_run_route_bool,

Line 492: l_balance_value := pay_balance_pkg.get_value_lock

488: --
489: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 50);
490: l_defined_balance_id := get_defined_balance(p_balance_name,
491: p_database_suffix);
492: l_balance_value := pay_balance_pkg.get_value_lock
493: (l_defined_balance_id,
494: p_assignment_id,
495: p_virtual_date,
496: l_run_route_bool,

Line 508: l_balance_value := pay_balance_pkg.get_value_lock

504: --
505: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 60);
506: l_defined_balance_id := get_defined_balance(p_balance_name,
507: p_database_suffix);
508: l_balance_value := pay_balance_pkg.get_value_lock
509: (l_defined_balance_id,
510: p_assignment_id,
511: p_virtual_date,
512: l_run_route_bool,

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

561: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 10);
562: --
563: l_defined_balance_id := get_defined_balance(p_balance_name,
564: p_database_suffix);
565: l_balance_value := pay_balance_pkg.get_value (l_defined_balance_id,
566: p_assignment_action_id,
567: l_run_route_bool,
568: FALSE
569: );

Line 686: return pay_balance_pkg.get_value (l_defined_balance_id,

682: l_defined_balance_id := get_defined_balance(p_balance_name,
683: p_dimension_suffix);
684: IF p_dimension_suffix not like '%PAY%' THEN
685: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 30);
686: return pay_balance_pkg.get_value (l_defined_balance_id,
687: p_assignment_action_id,
688: l_run_route_bool,
689: FALSE
690: );

Line 693: return pay_balance_pkg.get_value (l_defined_balance_id,

689: FALSE
690: );
691: ELSE /* If payments dimension then must execute DB item 395029 */
692: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 40);
693: return pay_balance_pkg.get_value (l_defined_balance_id,
694: p_assignment_action_id,
695: true );
696: -- END IF;
697: end if;

Line 722: return pay_balance_pkg.get_value_lock

718: l_defined_balance_id := get_defined_balance(p_balance_name,
719: p_dimension_suffix);
720: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',
721: 60);
722: return pay_balance_pkg.get_value_lock
723: (l_defined_balance_id,
724: p_assignment_id,
725: p_virtual_date,
726: l_run_route_bool,

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

1003: -- them up front
1004: --
1005: hr_utility.set_location('pay_tax_bals_pkg',30);
1006: --
1007: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1008: IF p_jd_context IS NOT NULL THEN
1009: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1011: '-'||substr(p_jd_context,13,5));

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

1006: --
1007: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1008: IF p_jd_context IS NOT NULL THEN
1009: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1011: '-'||substr(p_jd_context,13,5));
1012: ELSE
1013: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1014: END IF;

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

1009: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1011: '-'||substr(p_jd_context,13,5));
1012: ELSE
1013: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1014: END IF;
1015: END IF;
1016: --
1017: hr_utility.set_location('pay_tax_bals_pkg',40);

Line 1253: pay_balance_pkg.set_context('DATE_EARNED',

1249: l_count number;
1250: l_found boolean;
1251: check_asg number;
1252: begin
1253: pay_balance_pkg.set_context('DATE_EARNED',
1254: fnd_date.date_to_canonical(l_virtual_date));
1255: pay_balance_pkg.set_context('BALANCE_DATE',
1256: fnd_date.date_to_canonical(l_virtual_date));
1257: select business_group_id

Line 1255: pay_balance_pkg.set_context('BALANCE_DATE',

1251: check_asg number;
1252: begin
1253: pay_balance_pkg.set_context('DATE_EARNED',
1254: fnd_date.date_to_canonical(l_virtual_date));
1255: pay_balance_pkg.set_context('BALANCE_DATE',
1256: fnd_date.date_to_canonical(l_virtual_date));
1257: select business_group_id
1258: into l_bg_id
1259: from hr_organization_units