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 1133: l_balance := pay_balance_pkg.get_value(

1129: -- We therefore don't need to check the table, time can be saved by
1130: -- simply calling the route code, which is incidentally the most
1131: -- performant (ie simple) route. */
1132: --
1133: l_balance := pay_balance_pkg.get_value(
1134: l_defined_bal_id,
1135: p_assignment_action_id);
1136: --
1137: else l_balance := null;

Line 1281: l_balance := pay_balance_pkg.get_value(

1277: --
1278: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);
1279: --
1280: if l_defined_bal_id is not null then
1281: l_balance := pay_balance_pkg.get_value(
1282: l_defined_bal_id,
1283: p_assignment_action_id);
1284: --
1285: else

Line 1426: l_balance := pay_balance_pkg.get_value(

1422: --
1423: l_defined_bal_id := dimension_relevant(p_balance_type_id,hr_jprts.g_asg_mtd_jp);
1424: --
1425: if l_defined_bal_id is not null then
1426: l_balance := pay_balance_pkg.get_value(
1427: l_defined_bal_id,
1428: p_assignment_action_id);
1429: --
1430: else

Line 1567: l_balance := pay_balance_pkg.get_value(

1563: --
1564: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);
1565: --
1566: if l_defined_bal_id is not null then
1567: l_balance := pay_balance_pkg.get_value(
1568: l_defined_bal_id,
1569: p_assignment_action_id);
1570: --
1571: else

Line 1899: l_balance := pay_balance_pkg.get_value(

1895: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);
1896: --
1897: if l_defined_bal_id is not null then
1898: --
1899: l_balance := pay_balance_pkg.get_value(
1900: l_defined_bal_id,
1901: p_assignment_action_id);
1902: --
1903: else

Line 2046: l_balance := pay_balance_pkg.get_value(

2042: l_defined_bal_id := dimension_relevant(p_balance_type_id, pyjpexc.c_asg_aprtd);
2043: --
2044: if l_defined_bal_id is not null then
2045: --
2046: l_balance := pay_balance_pkg.get_value(
2047: l_defined_bal_id,
2048: p_assignment_action_id);
2049: --
2050: else

Line 2189: l_balance := pay_balance_pkg.get_value(

2185: --
2186: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);
2187: --
2188: if l_defined_bal_id is not null then
2189: l_balance := pay_balance_pkg.get_value(
2190: l_defined_bal_id,
2191: p_assignment_action_id);
2192: --
2193: else

Line 2327: l_balance := pay_balance_pkg.get_value(

2323: --
2324: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);
2325: --
2326: if l_defined_bal_id is not null then
2327: l_balance := pay_balance_pkg.get_value(
2328: l_defined_bal_id,
2329: p_assignment_action_id);
2330: --
2331: else

Line 2451: l_balance := pay_balance_pkg.get_value(

2447: --
2448: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);
2449: --
2450: if l_defined_bal_id is not null then
2451: l_balance := pay_balance_pkg.get_value(
2452: l_defined_bal_id,
2453: p_assignment_action_id);
2454: --
2455: else

Line 2740: l_balance := pay_balance_pkg.get_value(

2736: --
2737: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);
2738: --
2739: if l_defined_bal_id is not null then
2740: l_balance := pay_balance_pkg.get_value(
2741: l_defined_bal_id,
2742: p_assignment_action_id);
2743: --
2744: else

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

2775: --
2776: -- Fix bug#3083339: Set context to identify element name in the element level
2777: -- dimension rows.
2778: --
2779: -- This set source_id will be used in pay_balance_pkg.get_value function.
2780: pay_balance_pkg.set_context(
2781: p_context_name => 'ORIGINAL_ENTRY_ID',
2782: p_context_value => p_source_id);
2783: --

Line 2780: pay_balance_pkg.set_context(

2776: -- Fix bug#3083339: Set context to identify element name in the element level
2777: -- dimension rows.
2778: --
2779: -- This set source_id will be used in pay_balance_pkg.get_value function.
2780: pay_balance_pkg.set_context(
2781: p_context_name => 'ORIGINAL_ENTRY_ID',
2782: p_context_value => p_source_id);
2783: --
2784: l_balance := pay_balance_pkg.get_value(

Line 2784: l_balance := pay_balance_pkg.get_value(

2780: pay_balance_pkg.set_context(
2781: p_context_name => 'ORIGINAL_ENTRY_ID',
2782: p_context_value => p_source_id);
2783: --
2784: l_balance := pay_balance_pkg.get_value(
2785: l_defined_bal_id,
2786: p_assignment_action_id);
2787: end if;
2788: else

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

2818: l_defined_bal_id,
2819: p_source_id);
2820: if l_balance is null then
2821: --
2822: -- This set source_id will be used in pay_balance_pkg.get_value function.
2823: pay_balance_pkg.set_context(
2824: p_context_name => 'ORIGINAL_ENTRY_ID',
2825: p_context_value => p_source_id);
2826: l_balance := pay_balance_pkg.get_value(

Line 2823: pay_balance_pkg.set_context(

2819: p_source_id);
2820: if l_balance is null then
2821: --
2822: -- This set source_id will be used in pay_balance_pkg.get_value function.
2823: pay_balance_pkg.set_context(
2824: p_context_name => 'ORIGINAL_ENTRY_ID',
2825: p_context_value => p_source_id);
2826: l_balance := pay_balance_pkg.get_value(
2827: l_defined_bal_id,

Line 2826: l_balance := pay_balance_pkg.get_value(

2822: -- This set source_id will be used in pay_balance_pkg.get_value function.
2823: pay_balance_pkg.set_context(
2824: p_context_name => 'ORIGINAL_ENTRY_ID',
2825: p_context_value => p_source_id);
2826: l_balance := pay_balance_pkg.get_value(
2827: l_defined_bal_id,
2828: p_assignment_action_id);
2829: --l_balance := hr_routes.element_ptd(
2830: -- p_assignment_action_id,