DBA Data[Home] [Help]

APPS.HR_JPBAL dependencies on PAY_BALANCE_PKG

Line 523: l_balance := pay_balance_pkg.get_value(

519: hr_jprts.g_asg_itd,
520: hr_jprts.g_payment,
521: hr_jprts.g_asg_fytd2_jp
522: ) then
523: l_balance := pay_balance_pkg.get_value(
524: p_defined_balance_id,
525: p_assignment_action_id);
526: --
527: elsif l_dimension_name = hr_jprts.g_retro then

Line 558: -- pay_balance_pkg.get_value cannot be used for user defined dimension.

554: l_to_date,
555: l_action_sequence);
556: --
557: -- User Defined Dimension
558: -- pay_balance_pkg.get_value cannot be used for user defined dimension.
559: -- route refer to pay_jp_balances_v(call hr_jpbal.balance this code).
560: --
561: -- rtrim is used for support dimension that was created before bug2597843 fix.
562: --

Line 1153: l_balance := pay_balance_pkg.get_value(

1149: -- We therefore don't need to check the table, time can be saved by
1150: -- simply calling the route code, which is incidentally the most
1151: -- performant (ie simple) route. */
1152: --
1153: l_balance := pay_balance_pkg.get_value(
1154: l_defined_bal_id,
1155: p_assignment_action_id);
1156: --
1157: else l_balance := null;

Line 1301: l_balance := pay_balance_pkg.get_value(

1297: --
1298: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);
1299: --
1300: if l_defined_bal_id is not null then
1301: l_balance := pay_balance_pkg.get_value(
1302: l_defined_bal_id,
1303: p_assignment_action_id);
1304: --
1305: else

Line 1446: l_balance := pay_balance_pkg.get_value(

1442: --
1443: l_defined_bal_id := dimension_relevant(p_balance_type_id,hr_jprts.g_asg_mtd_jp);
1444: --
1445: if l_defined_bal_id is not null then
1446: l_balance := pay_balance_pkg.get_value(
1447: l_defined_bal_id,
1448: p_assignment_action_id);
1449: --
1450: else

Line 1587: l_balance := pay_balance_pkg.get_value(

1583: --
1584: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);
1585: --
1586: if l_defined_bal_id is not null then
1587: l_balance := pay_balance_pkg.get_value(
1588: l_defined_bal_id,
1589: p_assignment_action_id);
1590: --
1591: else

Line 1919: l_balance := pay_balance_pkg.get_value(

1915: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);
1916: --
1917: if l_defined_bal_id is not null then
1918: --
1919: l_balance := pay_balance_pkg.get_value(
1920: l_defined_bal_id,
1921: p_assignment_action_id);
1922: --
1923: else

Line 2066: l_balance := pay_balance_pkg.get_value(

2062: l_defined_bal_id := dimension_relevant(p_balance_type_id, pyjpexc.c_asg_aprtd);
2063: --
2064: if l_defined_bal_id is not null then
2065: --
2066: l_balance := pay_balance_pkg.get_value(
2067: l_defined_bal_id,
2068: p_assignment_action_id);
2069: --
2070: else

Line 2209: l_balance := pay_balance_pkg.get_value(

2205: --
2206: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);
2207: --
2208: if l_defined_bal_id is not null then
2209: l_balance := pay_balance_pkg.get_value(
2210: l_defined_bal_id,
2211: p_assignment_action_id);
2212: --
2213: else

Line 2347: l_balance := pay_balance_pkg.get_value(

2343: --
2344: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);
2345: --
2346: if l_defined_bal_id is not null then
2347: l_balance := pay_balance_pkg.get_value(
2348: l_defined_bal_id,
2349: p_assignment_action_id);
2350: --
2351: else

Line 2471: l_balance := pay_balance_pkg.get_value(

2467: --
2468: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);
2469: --
2470: if l_defined_bal_id is not null then
2471: l_balance := pay_balance_pkg.get_value(
2472: l_defined_bal_id,
2473: p_assignment_action_id);
2474: --
2475: else

Line 2760: l_balance := pay_balance_pkg.get_value(

2756: --
2757: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);
2758: --
2759: if l_defined_bal_id is not null then
2760: l_balance := pay_balance_pkg.get_value(
2761: l_defined_bal_id,
2762: p_assignment_action_id);
2763: --
2764: else

Line 2799: -- This set source_id will be used in pay_balance_pkg.get_value function.

2795: --
2796: -- Fix bug#3083339: Set context to identify element name in the element level
2797: -- dimension rows.
2798: --
2799: -- This set source_id will be used in pay_balance_pkg.get_value function.
2800: pay_balance_pkg.set_context(
2801: p_context_name => 'ORIGINAL_ENTRY_ID',
2802: p_context_value => p_source_id);
2803: --

Line 2800: pay_balance_pkg.set_context(

2796: -- Fix bug#3083339: Set context to identify element name in the element level
2797: -- dimension rows.
2798: --
2799: -- This set source_id will be used in pay_balance_pkg.get_value function.
2800: pay_balance_pkg.set_context(
2801: p_context_name => 'ORIGINAL_ENTRY_ID',
2802: p_context_value => p_source_id);
2803: --
2804: l_balance := pay_balance_pkg.get_value(

Line 2804: l_balance := pay_balance_pkg.get_value(

2800: pay_balance_pkg.set_context(
2801: p_context_name => 'ORIGINAL_ENTRY_ID',
2802: p_context_value => p_source_id);
2803: --
2804: l_balance := pay_balance_pkg.get_value(
2805: l_defined_bal_id,
2806: p_assignment_action_id);
2807: end if;
2808: else

Line 2842: -- This set source_id will be used in pay_balance_pkg.get_value function.

2838: l_defined_bal_id,
2839: p_source_id);
2840: if l_balance is null then
2841: --
2842: -- This set source_id will be used in pay_balance_pkg.get_value function.
2843: pay_balance_pkg.set_context(
2844: p_context_name => 'ORIGINAL_ENTRY_ID',
2845: p_context_value => p_source_id);
2846: l_balance := pay_balance_pkg.get_value(

Line 2843: pay_balance_pkg.set_context(

2839: p_source_id);
2840: if l_balance is null then
2841: --
2842: -- This set source_id will be used in pay_balance_pkg.get_value function.
2843: pay_balance_pkg.set_context(
2844: p_context_name => 'ORIGINAL_ENTRY_ID',
2845: p_context_value => p_source_id);
2846: l_balance := pay_balance_pkg.get_value(
2847: l_defined_bal_id,

Line 2846: l_balance := pay_balance_pkg.get_value(

2842: -- This set source_id will be used in pay_balance_pkg.get_value function.
2843: pay_balance_pkg.set_context(
2844: p_context_name => 'ORIGINAL_ENTRY_ID',
2845: p_context_value => p_source_id);
2846: l_balance := pay_balance_pkg.get_value(
2847: l_defined_bal_id,
2848: p_assignment_action_id);
2849: --l_balance := hr_routes.element_ptd(
2850: -- p_assignment_action_id,