eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JPBAL dependencies on HR_JPRTS

Line 58: l_owner_period_end_date := hr_jprts.dimension_reset_last_date(

54: --
55: IF l_dimension_date_type = 'EFFECTIVE_DATE' THEN
56: hr_utility.trace('Date Type : EFFECTIVE_DATE');
57: --
58: l_owner_period_end_date := hr_jprts.dimension_reset_last_date(
59: p_dimension_name,
60: p_owner_effective_date);
61: --
62: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));

Line 91: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN

87: pay_payroll_actions ppa_user
88: where ppa_user.payroll_action_id = p_user_payroll_action_id
89: and ppa_owner.payroll_action_id = p_owner_payroll_action_id;
90: --
91: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN
92: l_owner_period_end_date := hr_jprts.dim_reset_last_date_userdef(
93: p_dimension_name,
94: l_owner_date_earned,
95: 'FLEX',

Line 92: l_owner_period_end_date := hr_jprts.dim_reset_last_date_userdef(

88: where ppa_user.payroll_action_id = p_user_payroll_action_id
89: and ppa_owner.payroll_action_id = p_owner_payroll_action_id;
90: --
91: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN
92: l_owner_period_end_date := hr_jprts.dim_reset_last_date_userdef(
93: p_dimension_name,
94: l_owner_date_earned,
95: 'FLEX',
96: null,

Line 99: l_owner_period_end_date := hr_jprts.dimension_reset_last_date(

95: 'FLEX',
96: null,
97: l_business_group_id);
98: ELSE
99: l_owner_period_end_date := hr_jprts.dimension_reset_last_date(
100: p_dimension_name,
101: l_owner_date_earned);
102: END IF;
103: --

Line 158: p_expiry_information := hr_jprts.dimension_reset_last_date(

154: --
155: IF l_dimension_date_type = 'EFFECTIVE_DATE' THEN
156: hr_utility.trace('Date Type : EFFECTIVE_DATE');
157: --
158: p_expiry_information := hr_jprts.dimension_reset_last_date(
159: p_dimension_name,
160: p_owner_effective_date);
161: --
162: -- Bug.2597843. DATE_EARNED expiry checking.

Line 176: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN

172: l_business_group_id,
173: l_owner_date_earned;
174: close csr_business_group;
175: --
176: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN
177: p_expiry_information := hr_jprts.dim_reset_last_date_userdef(
178: p_dimension_name,
179: l_owner_date_earned,
180: 'FLEX',

Line 177: p_expiry_information := hr_jprts.dim_reset_last_date_userdef(

173: l_owner_date_earned;
174: close csr_business_group;
175: --
176: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN
177: p_expiry_information := hr_jprts.dim_reset_last_date_userdef(
178: p_dimension_name,
179: l_owner_date_earned,
180: 'FLEX',
181: null,

Line 184: p_expiry_information := hr_jprts.dimension_reset_last_date(

180: 'FLEX',
181: null,
182: l_business_group_id);
183: ELSE
184: p_expiry_information := hr_jprts.dimension_reset_last_date(
185: p_dimension_name,
186: l_owner_date_earned);
187: END IF;
188: ELSE

Line 513: hr_jprts.g_asg_run,

509: l_dimension_name;
510: CLOSE balance_dimension;
511: --
512: if l_dimension_name in (
513: hr_jprts.g_asg_run,
514: hr_jprts.g_asg_mtd_jp,
515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,

Line 514: hr_jprts.g_asg_mtd_jp,

510: CLOSE balance_dimension;
511: --
512: if l_dimension_name in (
513: hr_jprts.g_asg_run,
514: hr_jprts.g_asg_mtd_jp,
515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,

Line 515: hr_jprts.g_ast_ytd_jp,

511: --
512: if l_dimension_name in (
513: hr_jprts.g_asg_run,
514: hr_jprts.g_asg_mtd_jp,
515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
519: hr_jprts.g_asg_itd,

Line 516: hr_jprts.g_asg_aug2jul_jp,

512: if l_dimension_name in (
513: hr_jprts.g_asg_run,
514: hr_jprts.g_asg_mtd_jp,
515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
519: hr_jprts.g_asg_itd,
520: hr_jprts.g_payment,

Line 517: hr_jprts.g_asg_jul2jun_jp,

513: hr_jprts.g_asg_run,
514: hr_jprts.g_asg_mtd_jp,
515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
519: hr_jprts.g_asg_itd,
520: hr_jprts.g_payment,
521: hr_jprts.g_asg_fytd2_jp

Line 518: hr_jprts.g_asg_proc_ptd,

514: hr_jprts.g_asg_mtd_jp,
515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
519: hr_jprts.g_asg_itd,
520: hr_jprts.g_payment,
521: hr_jprts.g_asg_fytd2_jp
522: ) then

Line 519: hr_jprts.g_asg_itd,

515: hr_jprts.g_ast_ytd_jp,
516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
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(

Line 520: hr_jprts.g_payment,

516: hr_jprts.g_asg_aug2jul_jp,
517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
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,

Line 521: hr_jprts.g_asg_fytd2_jp

517: hr_jprts.g_asg_jul2jun_jp,
518: hr_jprts.g_asg_proc_ptd,
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);

Line 527: elsif l_dimension_name = hr_jprts.g_retro 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
528: l_balance := hr_jprts.retro_jp(
529: p_assignment_action_id,
530: l_balance_type_id);
531: --

Line 528: l_balance := hr_jprts.retro_jp(

524: p_defined_balance_id,
525: p_assignment_action_id);
526: --
527: elsif l_dimension_name = hr_jprts.g_retro then
528: l_balance := hr_jprts.retro_jp(
529: p_assignment_action_id,
530: l_balance_type_id);
531: --
532: -- This function can not call the calculation of Element dimension because it needs source_id.

Line 536: hr_jprts.g_element_itd,

532: -- This function can not call the calculation of Element dimension because it needs source_id.
533: --
534: --
535: elsif l_dimension_name in (
536: hr_jprts.g_element_itd,
537: hr_jprts.g_element_ptd) then
538: fnd_message.set_name('PAY', 'This dimension is invalid');
539: fnd_message.raise_error;
540: --

Line 537: hr_jprts.g_element_ptd) then

533: --
534: --
535: elsif l_dimension_name in (
536: hr_jprts.g_element_itd,
537: hr_jprts.g_element_ptd) then
538: fnd_message.set_name('PAY', 'This dimension is invalid');
539: fnd_message.raise_error;
540: --
541: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp then

Line 541: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp then

537: hr_jprts.g_element_ptd) then
538: fnd_message.set_name('PAY', 'This dimension is invalid');
539: fnd_message.raise_error;
540: --
541: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp then
542: l_from_date := hr_jprts.dimension_reset_date_userdef(
543: l_dimension_name,
544: l_date_earned,
545: 'FLEX',

Line 542: l_from_date := hr_jprts.dimension_reset_date_userdef(

538: fnd_message.set_name('PAY', 'This dimension is invalid');
539: fnd_message.raise_error;
540: --
541: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp then
542: l_from_date := hr_jprts.dimension_reset_date_userdef(
543: l_dimension_name,
544: l_date_earned,
545: 'FLEX',
546: null,

Line 550: l_balance := hr_jprts.calc_bal_date_earned(

546: null,
547: l_business_group_id);
548: l_to_date := l_date_earned;
549: --
550: l_balance := hr_jprts.calc_bal_date_earned(
551: l_assignment_id,
552: l_balance_type_id,
553: l_from_date,
554: l_to_date,

Line 571: l_from_date := hr_jprts.dimension_reset_date(

567: l_dimension_jp_type := rtrim(substrb(rpad(l_dimension_name, 44), -14));
568: --
569: IF l_dimension_jp_type = 'EFFECTIVE_DATE' THEN
570: --
571: l_from_date := hr_jprts.dimension_reset_date(
572: l_dimension_name,
573: l_effective_date);
574: l_to_date := l_effective_date;
575: --

Line 576: l_balance := hr_jprts.calc_bal_eff_date(

572: l_dimension_name,
573: l_effective_date);
574: l_to_date := l_effective_date;
575: --
576: l_balance := hr_jprts.calc_bal_eff_date(
577: l_assignment_id,
578: l_balance_type_id,
579: l_from_date,
580: l_to_date,

Line 584: l_from_date := hr_jprts.dimension_reset_date(

580: l_to_date,
581: l_action_sequence);
582: elsif l_dimension_jp_type = 'DATE_EARNED' then
583: --
584: l_from_date := hr_jprts.dimension_reset_date(
585: l_dimension_name,
586: l_date_earned);
587: l_to_date := l_date_earned;
588: --

Line 589: l_balance := hr_jprts.calc_bal_date_earned(

585: l_dimension_name,
586: l_date_earned);
587: l_to_date := l_date_earned;
588: --
589: l_balance := hr_jprts.calc_bal_date_earned(
590: l_assignment_id,
591: l_balance_type_id,
592: l_from_date,
593: l_to_date,

Line 977: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_effective_date) + 1;

973: l_last_effective_date := l_last_date.effect_date;
974: CLOSE last_date;
975: --
976: l_assignment_action_id := l_assact_id_for_effect;
977: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_effective_date) + 1;
978: --
979: /* -- p_effective_date <= session_date */
980: if l_next_start_date <= p_effective_date then
981: l_balance := 0;

Line 1000: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_date_earned) + 1;

996: l_last_date_earned := l_last_date.earned_date;
997: CLOSE last_date;
998: --
999: l_assignment_action_id := l_assact_id_for_earned;
1000: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_date_earned) + 1;
1001: --
1002: /* -- p_effective_date <= session_date */
1003: if l_next_start_date <= p_effective_date then
1004: l_balance := 0;

Line 1087: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);

1083: AND ptp.time_period_id = ppa.time_period_id;
1084: --
1085: BEGIN
1086: --
1087: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);
1088: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1089: if l_defined_balance_id is not null then
1090: --
1091: l_assignment_action_id := get_latest_action_id(

Line 1144: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);

1140: --
1141: /* --Do we need to work out nocopy a value for this dimension/balance combination.
1142: --Used dimension_name in dimension_relevant because of unique column */
1143: --
1144: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);
1145: if l_defined_bal_id is not null then
1146: --
1147: /* -- Run balances will never have a value in pay_assignment_latest_balances
1148: -- table, as they are only used for the duration of the payroll run.

Line 1236: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);

1232: AND ptp.time_period_id = ppa.time_period_id;
1233: --
1234: BEGIN
1235: --
1236: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);
1237: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1238: --
1239: if l_defined_balance_id is not null then
1240: --

Line 1298: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);

1294: l_defined_bal_id NUMBER;
1295: --
1296: BEGIN
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,

Line 1385: hr_jprts.g_asg_mtd_jp);

1381: --
1382: BEGIN
1383: --
1384: l_defined_balance_id := dimension_relevant( p_balance_type_id,
1385: hr_jprts.g_asg_mtd_jp);
1386: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1387: --
1388: if l_defined_balance_id is not null then
1389: --

Line 1443: l_defined_bal_id := dimension_relevant(p_balance_type_id,hr_jprts.g_asg_mtd_jp);

1439: l_defined_bal_id NUMBER;
1440: --
1441: BEGIN
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,

Line 1528: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);

1524: AND ppa.payroll_action_id = paa.payroll_action_id;
1525: --
1526: BEGIN
1527: --
1528: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);
1529: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1530: --
1531: if l_defined_balance_id is not null then
1532: --

Line 1584: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);

1580: l_defined_bal_id NUMBER;
1581: --
1582: BEGIN
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,

Line 1688: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);

1684: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');
1685: --
1686: BEGIN
1687: --
1688: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);
1689: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1690: --
1691: if l_defined_balance_id is not null then
1692: --

Line 1747: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);

1743: --
1744: /* --Do we need to work out nocopy a value for this dimension/balance combination.
1745: --Used dimension_name in dimension_relevant because of unique column */
1746: --
1747: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);
1748: if l_defined_bal_id is not null then
1749: --
1750: /* -- This balances will never have a value in pay_assignment_latest_balances
1751: -- table, as they are only used for the duration of the payroll run.

Line 1756: -- Remain hr_jprts.asg_fytd_jp function since better than

1752: -- We therefore don't need to check the table, time can be saved by
1753: -- simply calling the route code, which is incidentally the most
1754: -- performant (ie simple) route. */
1755: --
1756: -- Remain hr_jprts.asg_fytd_jp function since better than
1757: -- using dimension_reset_date_userdef/calc_bal_date_earned
1758: --
1759: l_balance := hr_jprts.asg_fytd_jp(
1760: p_assignment_action_id,

Line 1759: l_balance := hr_jprts.asg_fytd_jp(

1755: --
1756: -- Remain hr_jprts.asg_fytd_jp function since better than
1757: -- using dimension_reset_date_userdef/calc_bal_date_earned
1758: --
1759: l_balance := hr_jprts.asg_fytd_jp(
1760: p_assignment_action_id,
1761: p_balance_type_id);
1762: --
1763: else

Line 1860: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);

1856: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');
1857: --
1858: BEGIN
1859: --
1860: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);
1861: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1862: --
1863: if l_defined_balance_id is not null then
1864: --

Line 1915: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);

1911: l_defined_bal_id NUMBER;
1912: --
1913: BEGIN
1914: --
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(

Line 2148: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);

2144: AND ppa.payroll_action_id = paa.payroll_action_id;
2145: --
2146: BEGIN
2147: --
2148: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);
2149: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2150: --
2151: if l_defined_balance_id is not null then
2152: --

Line 2206: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);

2202: l_defined_bal_id NUMBER;
2203: --
2204: BEGIN
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,

Line 2288: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);

2284: AND paa.payroll_action_id = ppa.payroll_action_id;
2285: --
2286: BEGIN
2287: --
2288: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);
2289: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2290: --
2291: if l_defined_balance_id is not null then
2292: --

Line 2344: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);

2340: l_defined_bal_id NUMBER;
2341: --
2342: BEGIN
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,

Line 2420: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);

2416: l_defined_balance_id NUMBER;
2417: --
2418: BEGIN
2419: --
2420: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);
2421: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2422: --
2423: if l_defined_balance_id is not null then
2424: --

Line 2468: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);

2464: l_defined_bal_id NUMBER;
2465: --
2466: BEGIN
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,

Line 2556: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);

2552: AND ptp.time_period_id = ppa.time_period_id;
2553: --
2554: BEGIN
2555: --
2556: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);
2557: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2558: --
2559: if l_defined_balance_id is not null then
2560: --

Line 2610: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);

2606: --
2607: /* --Do we need to work out nocopy a value for this dimension/balance combination.
2608: --Used dimension_name in dimension_relevant because of unique column */
2609: --
2610: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);
2611: if l_defined_bal_id is not null then
2612: --
2613: /* -- Run balances will never have a value in pay_assignment_latest_balances
2614: -- table, as they are only used for the duration of the payroll run.

Line 2620: l_balance := hr_jprts.retro_jp(

2616: -- simply calling the route code, which is incidentally the most
2617: -- performant (ie simple) route. */
2618: --
2619: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
2620: l_balance := hr_jprts.retro_jp(
2621: p_assignment_action_id,
2622: p_balance_type_id);
2623: --
2624: else

Line 2702: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);

2698: AND ptp.time_period_id = ppa.time_period_id;
2699: --
2700: BEGIN
2701: --
2702: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);
2703: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2704: --
2705: if l_defined_balance_id is not null then
2706: --

Line 2757: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);

2753: l_defined_bal_id NUMBER;
2754: --
2755: BEGIN
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,

Line 2788: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_element_itd);

2784: l_defined_bal_id NUMBER;
2785: --
2786: BEGIN
2787: --
2788: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_element_itd);
2789: if l_defined_bal_id is not null then
2790: l_balance := get_latest_element_bal(
2791: p_assignment_action_id,
2792: l_defined_bal_id,

Line 2833: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_element_ptd);

2829: l_defined_bal_id NUMBER;
2830: --
2831: BEGIN
2832: --
2833: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_element_ptd);
2834: if l_defined_bal_id is not null then
2835: --
2836: l_balance := get_latest_element_bal(
2837: p_assignment_action_id,

Line 2899: If l_dimension_name = hr_jprts.g_asg_run then

2895: OPEN get_balance_type_id(p_defined_balance_id);
2896: FETCH get_balance_type_id INTO l_balance_type_id, l_dimension_name;
2897: CLOSE get_balance_type_id;
2898: --
2899: If l_dimension_name = hr_jprts.g_asg_run then
2900: l_balance := calc_asg_run_action(
2901: p_assignment_action_id,
2902: l_balance_type_id);
2903: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then

Line 2903: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then

2899: If l_dimension_name = hr_jprts.g_asg_run then
2900: l_balance := calc_asg_run_action(
2901: p_assignment_action_id,
2902: l_balance_type_id);
2903: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then
2904: l_balance := calc_asg_mtd_jp_action(
2905: p_assignment_action_id,
2906: l_balance_type_id);
2907: -- l_dimension_name);

Line 2908: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then

2904: l_balance := calc_asg_mtd_jp_action(
2905: p_assignment_action_id,
2906: l_balance_type_id);
2907: -- l_dimension_name);
2908: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then
2909: l_balance := calc_asg_ytd_jp_action(
2910: p_assignment_action_id,
2911: l_balance_type_id);
2912: -- l_dimension_name);

Line 2920: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then

2916: l_balance := calc_asg_apr2mar_jp_action(
2917: p_assignment_action_id,
2918: l_balance_type_id);
2919: --
2920: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then
2921: l_balance := calc_asg_aug2jul_jp_action(
2922: p_assignment_action_id,
2923: l_balance_type_id);
2924: -- l_dimension_name);

Line 2925: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then

2921: l_balance := calc_asg_aug2jul_jp_action(
2922: p_assignment_action_id,
2923: l_balance_type_id);
2924: -- l_dimension_name);
2925: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then
2926: -- calc_asg_jul2jun_jp_action is necessary
2927: -- this should be used in pay_jp_bal_matrix_by_act_v
2928: l_balance := calc_asg_jul2jun_jp_action(
2929: p_assignment_action_id,

Line 2931: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then

2927: -- this should be used in pay_jp_bal_matrix_by_act_v
2928: l_balance := calc_asg_jul2jun_jp_action(
2929: p_assignment_action_id,
2930: l_balance_type_id);
2931: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then
2932: l_balance := calc_asg_proc_ptd_action(
2933: p_assignment_action_id,
2934: l_balance_type_id);
2935: ELSIF l_dimension_name = hr_jprts.g_asg_itd then

Line 2935: ELSIF l_dimension_name = hr_jprts.g_asg_itd then

2931: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then
2932: l_balance := calc_asg_proc_ptd_action(
2933: p_assignment_action_id,
2934: l_balance_type_id);
2935: ELSIF l_dimension_name = hr_jprts.g_asg_itd then
2936: l_balance := calc_asg_itd_action(p_assignment_action_id,
2937: l_balance_type_id);
2938: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then
2939: l_balance := calc_asg_fytd_jp_action(

Line 2938: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then

2934: l_balance_type_id);
2935: ELSIF l_dimension_name = hr_jprts.g_asg_itd then
2936: l_balance := calc_asg_itd_action(p_assignment_action_id,
2937: l_balance_type_id);
2938: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then
2939: l_balance := calc_asg_fytd_jp_action(
2940: p_assignment_action_id,
2941: l_balance_type_id);
2942: -- l_dimension_name);

Line 2943: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then

2939: l_balance := calc_asg_fytd_jp_action(
2940: p_assignment_action_id,
2941: l_balance_type_id);
2942: -- l_dimension_name);
2943: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then
2944: -- calc_asg_fytd2_jp_action might be necessary
2945: l_balance := calc_asg_fytd2_jp_action(
2946: p_assignment_action_id,
2947: l_balance_type_id);

Line 2949: ELSIF l_dimension_name = hr_jprts.g_retro then

2945: l_balance := calc_asg_fytd2_jp_action(
2946: p_assignment_action_id,
2947: l_balance_type_id);
2948: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
2949: ELSIF l_dimension_name = hr_jprts.g_retro then
2950: l_balance := calc_retro_action(p_assignment_action_id,
2951: l_balance_type_id);
2952: ELSIF l_dimension_name = hr_jprts.g_payment then
2953: l_balance := calc_payment_action(

Line 2952: ELSIF l_dimension_name = hr_jprts.g_payment then

2948: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
2949: ELSIF l_dimension_name = hr_jprts.g_retro then
2950: l_balance := calc_retro_action(p_assignment_action_id,
2951: l_balance_type_id);
2952: ELSIF l_dimension_name = hr_jprts.g_payment then
2953: l_balance := calc_payment_action(
2954: p_assignment_action_id,
2955: l_balance_type_id);
2956: /* -- This function can not call the calculation of Element dimension.

Line 2958: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then

2954: p_assignment_action_id,
2955: l_balance_type_id);
2956: /* -- This function can not call the calculation of Element dimension.
2957: -- Because it needs source_id.
2958: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
2959: -- fnd_message.set_name('PAY','This dimension is invalid');
2960: -- fnd_message.raise_error;
2961: --l_balance := NULL;
2962: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then

Line 2962: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then

2958: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
2959: -- fnd_message.set_name('PAY','This dimension is invalid');
2960: -- fnd_message.raise_error;
2961: --l_balance := NULL;
2962: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
2963: -- fnd_message.set_name('PAY','This dimension is invalid');
2964: -- fnd_message.raise_error;
2965: -- l_balance := NULL; */
2966: --ELSE the balance must be for a USER-REG level dimension

Line 3013: If l_dimension_name = hr_jprts.g_asg_run then

3009: OPEN get_balance_type_id(p_defined_balance_id);
3010: FETCH get_balance_type_id INTO l_balance_type_id, l_dimension_name;
3011: CLOSE get_balance_type_id;
3012: --
3013: If l_dimension_name = hr_jprts.g_asg_run then
3014: l_balance := calc_asg_run_date(
3015: p_assignment_id,
3016: l_balance_type_id,
3017: p_effective_date);

Line 3018: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then

3014: l_balance := calc_asg_run_date(
3015: p_assignment_id,
3016: l_balance_type_id,
3017: p_effective_date);
3018: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then
3019: l_balance := calc_asg_mtd_jp_date(
3020: p_assignment_id,
3021: l_balance_type_id,
3022: p_effective_date);

Line 3023: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then

3019: l_balance := calc_asg_mtd_jp_date(
3020: p_assignment_id,
3021: l_balance_type_id,
3022: p_effective_date);
3023: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then
3024: l_balance := calc_asg_ytd_jp_date(
3025: p_assignment_id,
3026: l_balance_type_id,
3027: p_effective_date);

Line 3036: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then

3032: p_assignment_id,
3033: l_balance_type_id,
3034: p_effective_date);
3035: --
3036: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then
3037: l_balance := calc_asg_aug2jul_jp_date(
3038: p_assignment_id,
3039: l_balance_type_id,
3040: p_effective_date);

Line 3041: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then

3037: l_balance := calc_asg_aug2jul_jp_date(
3038: p_assignment_id,
3039: l_balance_type_id,
3040: p_effective_date);
3041: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then
3042: -- calc_asg_jul2jun_jp_date is necessary
3043: -- this should be used in pay_jp_bal_matrix_by_date_v
3044: l_balance := calc_asg_jul2jun_jp_date(
3045: p_assignment_id,

Line 3048: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then

3044: l_balance := calc_asg_jul2jun_jp_date(
3045: p_assignment_id,
3046: l_balance_type_id,
3047: p_effective_date);
3048: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then
3049: l_balance := calc_asg_proc_ptd_date(
3050: p_assignment_id,
3051: l_balance_type_id,
3052: p_effective_date);

Line 3053: ELSIF l_dimension_name = hr_jprts.g_asg_itd then

3049: l_balance := calc_asg_proc_ptd_date(
3050: p_assignment_id,
3051: l_balance_type_id,
3052: p_effective_date);
3053: ELSIF l_dimension_name = hr_jprts.g_asg_itd then
3054: l_balance := calc_asg_itd_date(
3055: p_assignment_id,
3056: l_balance_type_id,
3057: p_effective_date);

Line 3058: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then

3054: l_balance := calc_asg_itd_date(
3055: p_assignment_id,
3056: l_balance_type_id,
3057: p_effective_date);
3058: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then
3059: l_balance := calc_asg_fytd_jp_date(
3060: p_assignment_id,
3061: l_balance_type_id,
3062: p_effective_date);

Line 3063: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then

3059: l_balance := calc_asg_fytd_jp_date(
3060: p_assignment_id,
3061: l_balance_type_id,
3062: p_effective_date);
3063: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then
3064: -- calc_asg_fytd2_jp_action might be necessary
3065: l_balance := calc_asg_fytd2_jp_date(
3066: p_assignment_id,
3067: l_balance_type_id,

Line 3070: ELSIF l_dimension_name = hr_jprts.g_retro then

3066: p_assignment_id,
3067: l_balance_type_id,
3068: p_effective_date);
3069: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
3070: ELSIF l_dimension_name = hr_jprts.g_retro then
3071: l_balance := calc_retro_date(
3072: p_assignment_id,
3073: l_balance_type_id,
3074: p_effective_date);

Line 3075: ELSIF l_dimension_name = hr_jprts.g_payment then

3071: l_balance := calc_retro_date(
3072: p_assignment_id,
3073: l_balance_type_id,
3074: p_effective_date);
3075: ELSIF l_dimension_name = hr_jprts.g_payment then
3076: l_balance := calc_payment_date(
3077: p_assignment_id,
3078: l_balance_type_id,
3079: p_effective_date);

Line 3082: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then

3078: l_balance_type_id,
3079: p_effective_date);
3080: /* -- This function can not call the calculation of Element dimension.
3081: -- Because it needs source_id.
3082: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
3083: -- fnd_message.set_name('PAY','This dimension is invalid');
3084: -- fnd_message.raise_error;
3085: -- l_balance := NULL;
3086: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then

Line 3086: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then

3082: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
3083: -- fnd_message.set_name('PAY','This dimension is invalid');
3084: -- fnd_message.raise_error;
3085: -- l_balance := NULL;
3086: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
3087: -- fnd_message.set_name('PAY','This dimension is invalid');
3088: -- fnd_message.raise_error;
3089: -- l_balance := NULL; */
3090: ----

Line 3092: -- for hr_jprts.g_asg_jul2jun_jp and hr_jprts.g_asg_fytd2_jp

3088: -- fnd_message.raise_error;
3089: -- l_balance := NULL; */
3090: ----
3091: -- This comment is no more effective because new function has been added
3092: -- for hr_jprts.g_asg_jul2jun_jp and hr_jprts.g_asg_fytd2_jp
3093: --
3094: ELSE
3095: --This will trap USER-REG level balances
3096: l_balance := calc_balance_date(