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 957: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_effective_date) + 1;

953: l_last_effective_date := l_last_date.effect_date;
954: CLOSE last_date;
955: --
956: l_assignment_action_id := l_assact_id_for_effect;
957: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_effective_date) + 1;
958: --
959: /* -- p_effective_date <= session_date */
960: if l_next_start_date <= p_effective_date then
961: l_balance := 0;

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

976: l_last_date_earned := l_last_date.earned_date;
977: CLOSE last_date;
978: --
979: l_assignment_action_id := l_assact_id_for_earned;
980: l_next_start_date := hr_jprts.dimension_reset_last_date(p_dimension_name,l_last_date_earned) + 1;
981: --
982: /* -- p_effective_date <= session_date */
983: if l_next_start_date <= p_effective_date then
984: l_balance := 0;

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

1063: AND ptp.time_period_id = ppa.time_period_id;
1064: --
1065: BEGIN
1066: --
1067: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);
1068: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1069: if l_defined_balance_id is not null then
1070: --
1071: l_assignment_action_id := get_latest_action_id(

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

1120: --
1121: /* --Do we need to work out nocopy a value for this dimension/balance combination.
1122: --Used dimension_name in dimension_relevant because of unique column */
1123: --
1124: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);
1125: if l_defined_bal_id is not null then
1126: --
1127: /* -- Run balances will never have a value in pay_assignment_latest_balances
1128: -- table, as they are only used for the duration of the payroll run.

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

1212: AND ptp.time_period_id = ppa.time_period_id;
1213: --
1214: BEGIN
1215: --
1216: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);
1217: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1218: --
1219: if l_defined_balance_id is not null then
1220: --

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

1274: l_defined_bal_id NUMBER;
1275: --
1276: BEGIN
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,

Line 1365: hr_jprts.g_asg_mtd_jp);

1361: --
1362: BEGIN
1363: --
1364: l_defined_balance_id := dimension_relevant( p_balance_type_id,
1365: hr_jprts.g_asg_mtd_jp);
1366: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1367: --
1368: if l_defined_balance_id is not null then
1369: --

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

1419: l_defined_bal_id NUMBER;
1420: --
1421: BEGIN
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,

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

1504: AND ppa.payroll_action_id = paa.payroll_action_id;
1505: --
1506: BEGIN
1507: --
1508: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);
1509: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1510: --
1511: if l_defined_balance_id is not null then
1512: --

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

1560: l_defined_bal_id NUMBER;
1561: --
1562: BEGIN
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,

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

1664: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');
1665: --
1666: BEGIN
1667: --
1668: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);
1669: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1670: --
1671: if l_defined_balance_id is not null then
1672: --

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

1723: --
1724: /* --Do we need to work out nocopy a value for this dimension/balance combination.
1725: --Used dimension_name in dimension_relevant because of unique column */
1726: --
1727: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);
1728: if l_defined_bal_id is not null then
1729: --
1730: /* -- This balances will never have a value in pay_assignment_latest_balances
1731: -- table, as they are only used for the duration of the payroll run.

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

1732: -- We therefore don't need to check the table, time can be saved by
1733: -- simply calling the route code, which is incidentally the most
1734: -- performant (ie simple) route. */
1735: --
1736: -- Remain hr_jprts.asg_fytd_jp function since better than
1737: -- using dimension_reset_date_userdef/calc_bal_date_earned
1738: --
1739: l_balance := hr_jprts.asg_fytd_jp(
1740: p_assignment_action_id,

Line 1739: l_balance := hr_jprts.asg_fytd_jp(

1735: --
1736: -- Remain hr_jprts.asg_fytd_jp function since better than
1737: -- using dimension_reset_date_userdef/calc_bal_date_earned
1738: --
1739: l_balance := hr_jprts.asg_fytd_jp(
1740: p_assignment_action_id,
1741: p_balance_type_id);
1742: --
1743: else

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

1836: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');
1837: --
1838: BEGIN
1839: --
1840: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);
1841: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
1842: --
1843: if l_defined_balance_id is not null then
1844: --

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

1891: l_defined_bal_id NUMBER;
1892: --
1893: BEGIN
1894: --
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(

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

2124: AND ppa.payroll_action_id = paa.payroll_action_id;
2125: --
2126: BEGIN
2127: --
2128: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);
2129: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2130: --
2131: if l_defined_balance_id is not null then
2132: --

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

2182: l_defined_bal_id NUMBER;
2183: --
2184: BEGIN
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,

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

2264: AND paa.payroll_action_id = ppa.payroll_action_id;
2265: --
2266: BEGIN
2267: --
2268: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);
2269: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2270: --
2271: if l_defined_balance_id is not null then
2272: --

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

2320: l_defined_bal_id NUMBER;
2321: --
2322: BEGIN
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,

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

2396: l_defined_balance_id NUMBER;
2397: --
2398: BEGIN
2399: --
2400: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);
2401: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2402: --
2403: if l_defined_balance_id is not null then
2404: --

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

2444: l_defined_bal_id NUMBER;
2445: --
2446: BEGIN
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,

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

2532: AND ptp.time_period_id = ppa.time_period_id;
2533: --
2534: BEGIN
2535: --
2536: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);
2537: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2538: --
2539: if l_defined_balance_id is not null then
2540: --

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

2586: --
2587: /* --Do we need to work out nocopy a value for this dimension/balance combination.
2588: --Used dimension_name in dimension_relevant because of unique column */
2589: --
2590: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);
2591: if l_defined_bal_id is not null then
2592: --
2593: /* -- Run balances will never have a value in pay_assignment_latest_balances
2594: -- table, as they are only used for the duration of the payroll run.

Line 2600: l_balance := hr_jprts.retro_jp(

2596: -- simply calling the route code, which is incidentally the most
2597: -- performant (ie simple) route. */
2598: --
2599: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
2600: l_balance := hr_jprts.retro_jp(
2601: p_assignment_action_id,
2602: p_balance_type_id);
2603: --
2604: else

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

2678: AND ptp.time_period_id = ppa.time_period_id;
2679: --
2680: BEGIN
2681: --
2682: l_defined_balance_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);
2683: /* -- check relevant dimension. if it is not so(defined_balance_id is null), return null */
2684: --
2685: if l_defined_balance_id is not null then
2686: --

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

2733: l_defined_bal_id NUMBER;
2734: --
2735: BEGIN
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,

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

2764: l_defined_bal_id NUMBER;
2765: --
2766: BEGIN
2767: --
2768: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_element_itd);
2769: if l_defined_bal_id is not null then
2770: l_balance := get_latest_element_bal(
2771: p_assignment_action_id,
2772: l_defined_bal_id,

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

2809: l_defined_bal_id NUMBER;
2810: --
2811: BEGIN
2812: --
2813: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_element_ptd);
2814: if l_defined_bal_id is not null then
2815: --
2816: l_balance := get_latest_element_bal(
2817: p_assignment_action_id,

Line 2879: If l_dimension_name = hr_jprts.g_asg_run then

2875: OPEN get_balance_type_id(p_defined_balance_id);
2876: FETCH get_balance_type_id INTO l_balance_type_id, l_dimension_name;
2877: CLOSE get_balance_type_id;
2878: --
2879: If l_dimension_name = hr_jprts.g_asg_run then
2880: l_balance := calc_asg_run_action(
2881: p_assignment_action_id,
2882: l_balance_type_id);
2883: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then

Line 2883: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then

2879: If l_dimension_name = hr_jprts.g_asg_run then
2880: l_balance := calc_asg_run_action(
2881: p_assignment_action_id,
2882: l_balance_type_id);
2883: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then
2884: l_balance := calc_asg_mtd_jp_action(
2885: p_assignment_action_id,
2886: l_balance_type_id);
2887: -- l_dimension_name);

Line 2888: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then

2884: l_balance := calc_asg_mtd_jp_action(
2885: p_assignment_action_id,
2886: l_balance_type_id);
2887: -- l_dimension_name);
2888: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then
2889: l_balance := calc_asg_ytd_jp_action(
2890: p_assignment_action_id,
2891: l_balance_type_id);
2892: -- l_dimension_name);

Line 2900: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then

2896: l_balance := calc_asg_apr2mar_jp_action(
2897: p_assignment_action_id,
2898: l_balance_type_id);
2899: --
2900: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then
2901: l_balance := calc_asg_aug2jul_jp_action(
2902: p_assignment_action_id,
2903: l_balance_type_id);
2904: -- l_dimension_name);

Line 2905: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then

2901: l_balance := calc_asg_aug2jul_jp_action(
2902: p_assignment_action_id,
2903: l_balance_type_id);
2904: -- l_dimension_name);
2905: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then
2906: -- calc_asg_jul2jun_jp_action is necessary
2907: -- this should be used in pay_jp_bal_matrix_by_act_v
2908: l_balance := calc_asg_jul2jun_jp_action(
2909: p_assignment_action_id,

Line 2911: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then

2907: -- this should be used in pay_jp_bal_matrix_by_act_v
2908: l_balance := calc_asg_jul2jun_jp_action(
2909: p_assignment_action_id,
2910: l_balance_type_id);
2911: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then
2912: l_balance := calc_asg_proc_ptd_action(
2913: p_assignment_action_id,
2914: l_balance_type_id);
2915: ELSIF l_dimension_name = hr_jprts.g_asg_itd then

Line 2915: ELSIF l_dimension_name = hr_jprts.g_asg_itd then

2911: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then
2912: l_balance := calc_asg_proc_ptd_action(
2913: p_assignment_action_id,
2914: l_balance_type_id);
2915: ELSIF l_dimension_name = hr_jprts.g_asg_itd then
2916: l_balance := calc_asg_itd_action(p_assignment_action_id,
2917: l_balance_type_id);
2918: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then
2919: l_balance := calc_asg_fytd_jp_action(

Line 2918: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then

2914: l_balance_type_id);
2915: ELSIF l_dimension_name = hr_jprts.g_asg_itd then
2916: l_balance := calc_asg_itd_action(p_assignment_action_id,
2917: l_balance_type_id);
2918: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then
2919: l_balance := calc_asg_fytd_jp_action(
2920: p_assignment_action_id,
2921: l_balance_type_id);
2922: -- l_dimension_name);

Line 2923: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then

2919: l_balance := calc_asg_fytd_jp_action(
2920: p_assignment_action_id,
2921: l_balance_type_id);
2922: -- l_dimension_name);
2923: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then
2924: -- calc_asg_fytd2_jp_action might be necessary
2925: l_balance := calc_asg_fytd2_jp_action(
2926: p_assignment_action_id,
2927: l_balance_type_id);

Line 2929: ELSIF l_dimension_name = hr_jprts.g_retro then

2925: l_balance := calc_asg_fytd2_jp_action(
2926: p_assignment_action_id,
2927: l_balance_type_id);
2928: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
2929: ELSIF l_dimension_name = hr_jprts.g_retro then
2930: l_balance := calc_retro_action(p_assignment_action_id,
2931: l_balance_type_id);
2932: ELSIF l_dimension_name = hr_jprts.g_payment then
2933: l_balance := calc_payment_action(

Line 2932: ELSIF l_dimension_name = hr_jprts.g_payment then

2928: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
2929: ELSIF l_dimension_name = hr_jprts.g_retro then
2930: l_balance := calc_retro_action(p_assignment_action_id,
2931: l_balance_type_id);
2932: ELSIF l_dimension_name = hr_jprts.g_payment then
2933: l_balance := calc_payment_action(
2934: p_assignment_action_id,
2935: l_balance_type_id);
2936: /* -- This function can not call the calculation of Element dimension.

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

2934: p_assignment_action_id,
2935: l_balance_type_id);
2936: /* -- This function can not call the calculation of Element dimension.
2937: -- Because it needs source_id.
2938: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
2939: -- fnd_message.set_name('PAY','This dimension is invalid');
2940: -- fnd_message.raise_error;
2941: --l_balance := NULL;
2942: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then

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

2938: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
2939: -- fnd_message.set_name('PAY','This dimension is invalid');
2940: -- fnd_message.raise_error;
2941: --l_balance := NULL;
2942: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
2943: -- fnd_message.set_name('PAY','This dimension is invalid');
2944: -- fnd_message.raise_error;
2945: -- l_balance := NULL; */
2946: --ELSE the balance must be for a USER-REG level dimension

Line 2993: If l_dimension_name = hr_jprts.g_asg_run then

2989: OPEN get_balance_type_id(p_defined_balance_id);
2990: FETCH get_balance_type_id INTO l_balance_type_id, l_dimension_name;
2991: CLOSE get_balance_type_id;
2992: --
2993: If l_dimension_name = hr_jprts.g_asg_run then
2994: l_balance := calc_asg_run_date(
2995: p_assignment_id,
2996: l_balance_type_id,
2997: p_effective_date);

Line 2998: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then

2994: l_balance := calc_asg_run_date(
2995: p_assignment_id,
2996: l_balance_type_id,
2997: p_effective_date);
2998: ELSIF l_dimension_name = hr_jprts.g_asg_mtd_jp then
2999: l_balance := calc_asg_mtd_jp_date(
3000: p_assignment_id,
3001: l_balance_type_id,
3002: p_effective_date);

Line 3003: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then

2999: l_balance := calc_asg_mtd_jp_date(
3000: p_assignment_id,
3001: l_balance_type_id,
3002: p_effective_date);
3003: ELSIF l_dimension_name = hr_jprts.g_ast_ytd_jp then
3004: l_balance := calc_asg_ytd_jp_date(
3005: p_assignment_id,
3006: l_balance_type_id,
3007: p_effective_date);

Line 3016: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then

3012: p_assignment_id,
3013: l_balance_type_id,
3014: p_effective_date);
3015: --
3016: ELSIF l_dimension_name = hr_jprts.g_asg_aug2jul_jp then
3017: l_balance := calc_asg_aug2jul_jp_date(
3018: p_assignment_id,
3019: l_balance_type_id,
3020: p_effective_date);

Line 3021: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then

3017: l_balance := calc_asg_aug2jul_jp_date(
3018: p_assignment_id,
3019: l_balance_type_id,
3020: p_effective_date);
3021: ELSIF l_dimension_name = hr_jprts.g_asg_jul2jun_jp then
3022: -- calc_asg_jul2jun_jp_date is necessary
3023: -- this should be used in pay_jp_bal_matrix_by_date_v
3024: l_balance := calc_asg_jul2jun_jp_date(
3025: p_assignment_id,

Line 3028: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then

3024: l_balance := calc_asg_jul2jun_jp_date(
3025: p_assignment_id,
3026: l_balance_type_id,
3027: p_effective_date);
3028: ELSIF l_dimension_name = hr_jprts.g_asg_proc_ptd then
3029: l_balance := calc_asg_proc_ptd_date(
3030: p_assignment_id,
3031: l_balance_type_id,
3032: p_effective_date);

Line 3033: ELSIF l_dimension_name = hr_jprts.g_asg_itd then

3029: l_balance := calc_asg_proc_ptd_date(
3030: p_assignment_id,
3031: l_balance_type_id,
3032: p_effective_date);
3033: ELSIF l_dimension_name = hr_jprts.g_asg_itd then
3034: l_balance := calc_asg_itd_date(
3035: p_assignment_id,
3036: l_balance_type_id,
3037: p_effective_date);

Line 3038: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then

3034: l_balance := calc_asg_itd_date(
3035: p_assignment_id,
3036: l_balance_type_id,
3037: p_effective_date);
3038: ELSIF l_dimension_name = hr_jprts.g_asg_fytd_jp then
3039: l_balance := calc_asg_fytd_jp_date(
3040: p_assignment_id,
3041: l_balance_type_id,
3042: p_effective_date);

Line 3043: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then

3039: l_balance := calc_asg_fytd_jp_date(
3040: p_assignment_id,
3041: l_balance_type_id,
3042: p_effective_date);
3043: ELSIF l_dimension_name = hr_jprts.g_asg_fytd2_jp then
3044: -- calc_asg_fytd2_jp_action might be necessary
3045: l_balance := calc_asg_fytd2_jp_date(
3046: p_assignment_id,
3047: l_balance_type_id,

Line 3050: ELSIF l_dimension_name = hr_jprts.g_retro then

3046: p_assignment_id,
3047: l_balance_type_id,
3048: p_effective_date);
3049: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
3050: ELSIF l_dimension_name = hr_jprts.g_retro then
3051: l_balance := calc_retro_date(
3052: p_assignment_id,
3053: l_balance_type_id,
3054: p_effective_date);

Line 3055: ELSIF l_dimension_name = hr_jprts.g_payment then

3051: l_balance := calc_retro_date(
3052: p_assignment_id,
3053: l_balance_type_id,
3054: p_effective_date);
3055: ELSIF l_dimension_name = hr_jprts.g_payment then
3056: l_balance := calc_payment_date(
3057: p_assignment_id,
3058: l_balance_type_id,
3059: p_effective_date);

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

3058: l_balance_type_id,
3059: p_effective_date);
3060: /* -- This function can not call the calculation of Element dimension.
3061: -- Because it needs source_id.
3062: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
3063: -- fnd_message.set_name('PAY','This dimension is invalid');
3064: -- fnd_message.raise_error;
3065: -- l_balance := NULL;
3066: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then

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

3062: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
3063: -- fnd_message.set_name('PAY','This dimension is invalid');
3064: -- fnd_message.raise_error;
3065: -- l_balance := NULL;
3066: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
3067: -- fnd_message.set_name('PAY','This dimension is invalid');
3068: -- fnd_message.raise_error;
3069: -- l_balance := NULL; */
3070: ----

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

3068: -- fnd_message.raise_error;
3069: -- l_balance := NULL; */
3070: ----
3071: -- This comment is no more effective because new function has been added
3072: -- for hr_jprts.g_asg_jul2jun_jp and hr_jprts.g_asg_fytd2_jp
3073: --
3074: ELSE
3075: --This will trap USER-REG level balances
3076: l_balance := calc_balance_date(