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_GBBAL dependencies on PAY_BALANCE_PKG

Line 604: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,

600: if p_effective_date > l_expiry_date then
601: -- Balance has expired
602: l_balance := 0;
603: else
604: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,
605: p_assignment_action_id);
606: end if;
607: ELSE
608: if p_effective_date >= l_expiry_date then

Line 612: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,

608: if p_effective_date >= l_expiry_date then
609: -- Balance has expired
610: l_balance := 0;
611: else
612: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,
613: p_assignment_action_id);
614: end if;
615: END IF;
616:

Line 723: l_balance := pay_balance_pkg.get_value(

719:
720: IF l_legislation_code is null AND l_dimension_bgid is null then
721: --
722: BEGIN
723: l_balance := pay_balance_pkg.get_value(
724: p_assignment_action_id => p_assignment_action_id,
725: p_defined_balance_id => p_defined_balance_id);
726: EXCEPTION WHEN NO_DATA_FOUND THEN
727: l_balance := null;

Line 784: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,

780:
781:
782: ELSE
783: -- Assignment Action mode call as before
784: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,
785: p_assignment_action_id);
786:
787:
788: END IF;

Line 912: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'

908: l_balance := get_latest_element_bal(p_assignment_action_id,
909: l_defined_bal_id,
910: p_source_id);
911: if l_balance is null then
912: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'
913: , p_source_id);
914: pay_balance_pkg.set_context('SOURCE_TEXT'
915: , p_source_text);
916:

Line 914: pay_balance_pkg.set_context('SOURCE_TEXT'

910: p_source_id);
911: if l_balance is null then
912: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'
913: , p_source_id);
914: pay_balance_pkg.set_context('SOURCE_TEXT'
915: , p_source_text);
916:
917: l_balance := pay_balance_pkg.get_value(l_defined_bal_id, p_assignment_action_id);
918: end if;

Line 917: l_balance := pay_balance_pkg.get_value(l_defined_bal_id, p_assignment_action_id);

913: , p_source_id);
914: pay_balance_pkg.set_context('SOURCE_TEXT'
915: , p_source_text);
916:
917: l_balance := pay_balance_pkg.get_value(l_defined_bal_id, p_assignment_action_id);
918: end if;
919: else l_balance := null;
920: --
921: end if;

Line 947: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'

943: l_balance := get_latest_element_bal(p_assignment_action_id,
944: l_defined_bal_id,
945: p_source_id);
946: if l_balance is null then
947: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'
948: , p_source_id);
949: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
950: p_assignment_action_id);
951: --

Line 949: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

945: p_source_id);
946: if l_balance is null then
947: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'
948: , p_source_id);
949: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
950: p_assignment_action_id);
951: --
952: end if;
953: else l_balance := null;

Line 984: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'

980: l_defined_bal_id,
981: p_source_id);
982: if l_balance is null then
983: --
984: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'
985: , p_source_id);
986: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
987: p_assignment_action_id);
988: end if;

Line 986: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

982: if l_balance is null then
983: --
984: pay_balance_pkg.set_context('ORIGINAL_ENTRY_ID'
985: , p_source_id);
986: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
987: p_assignment_action_id);
988: end if;
989: else l_balance := null;
990: --

Line 1082: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,

1078: l_balance := calc_per_ptd_action(p_assignment_action_id,
1079: l_balance_type_id);
1080: --Else for all other dimensions
1081: Else
1082: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,
1083: p_assignment_action_id);
1084: End If;
1085: --
1086: RETURN l_balance;

Line 1185: pay_balance_pkg.set_context(l_context_name, l_context_value);

1181: FETCH get_context INTO l_context_value, l_context_name;
1182: CLOSE get_context;
1183:
1184: IF l_context_name = 'SOURCE_TEXT' then
1185: pay_balance_pkg.set_context(l_context_name, l_context_value);
1186: END IF;
1187:
1188: -- end bug fix 4311080 */
1189: --

Line 1257: pay_balance_pkg.set_context(j.context_name, j.context_value);

1253: Elsif l_dimension_name like '%_PER_CO_TD_REF_ITD' or l_dimension_name like '%_PER_CO_TD_REF_PTD' then
1254: FOR J IN get_context(l_route_id, l_assignment_action_id, 'SOURCE_TEXT', 'SOURCE_TEXT')
1255: LOOP
1256: IF j.context_name = 'SOURCE_TEXT' then
1257: pay_balance_pkg.set_context(j.context_name, j.context_value);
1258: END IF;
1259: l_balance := balance(l_assignment_action_id, p_defined_balance_id, p_effective_date);
1260: END LOOP;
1261: g_balance := 0;

Line 1271: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,

1267:
1268: /* For Bug 9715069 */
1269: ELSif l_dimension_name like '%_ASG_PEN_YTD' then
1270:
1271: l_balance := pay_balance_pkg.get_value(p_defined_balance_id,
1272: l_assignment_action_id);
1273:
1274: Else
1275: -- For all other dimensions

Line 1315: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

1311: IF l_defined_bal_id IS NOT NULL THEN
1312: --hr_utility.trace('PER - Dimension is relevant');
1313: --
1314: -- Call core balance pkg with the defined balance just retrieved.
1315: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1316: p_assignment_action_id);
1317:
1318: ELSE
1319: --hr_utility.trace('PER - Dimension not relevant');

Line 1532: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

1528: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PROC_YTD');
1529: if l_defined_bal_id is not null then
1530: --
1531: -- Call core balance pkg with the defined balance just retrieved.
1532: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1533: p_assignment_action_id);
1534: --
1535: else l_balance := null;
1536: end if;

Line 1651: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

1647: if l_defined_bal_id is not null then
1648: --
1649: -- Call core balance pkg with the defined balance just retrieved.
1650: --
1651: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1652: p_assignment_action_id);
1653: end if;
1654: --
1655: RETURN l_balance;

Line 1802: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

1798: --
1799: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_YTD');
1800: if l_defined_bal_id is not null then
1801: --
1802: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1803: p_assignment_action_id);
1804: --
1805: else l_balance := null;
1806: end if;

Line 1940: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

1936: --
1937: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_STAT_YTD');
1938: if l_defined_bal_id is not null then
1939: --
1940: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1941: p_assignment_action_id);
1942: --
1943: else l_balance := null;
1944: end if;

Line 2096: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2092: --
2093: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PROC_PTD');
2094: if l_defined_bal_id is not null then
2095: --
2096: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2097: p_assignment_action_id);
2098: --
2099: else l_balance := null;
2100: end if;

Line 2243: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2239: if l_defined_bal_id is not null then
2240: --
2241: -- Call core balance pkg with the defined balance just retrieved.
2242: --
2243: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2244: p_assignment_action_id);
2245: --
2246: else l_balance := null;
2247: end if;

Line 2385: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2381: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_PAYMENTS');
2382: if l_defined_bal_id is not null then
2383: --
2384: -- Call core balance pkg with the defined balance just retrieved.
2385: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2386: p_assignment_action_id);
2387: --
2388: else l_balance := null;
2389: end if;

Line 2504: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2500: if l_defined_bal_id is not null then
2501: --
2502: -- Is there a value in the latest balances table ..
2503: --
2504: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2505: p_assignment_action_id);
2506: --
2507: else l_balance := null;
2508: end if;

Line 2619: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2615: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_TD_ITD');
2616: if l_defined_bal_id is not null then
2617: --
2618: -- Call core balance pkg with the defined balance just retrieved.
2619: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2620: p_assignment_action_id);
2621: --
2622: else l_balance := null;
2623: end if;

Line 2769: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2765: --
2766: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_TRANSFER_PTD');
2767: if l_defined_bal_id is not null then
2768: --
2769: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2770: p_assignment_action_id);
2771: --
2772: else l_balance := null;
2773: end if;

Line 2852: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

2848: --
2849: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_TD_YTD');
2850: if l_defined_bal_id is not null then
2851: --
2852: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2853: p_assignment_action_id);
2854: --
2855: else l_balance := null;
2856: end if;

Line 3032: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

3028: '_ASG_TD_ODD_TWO_YTD');
3029: if l_defined_bal_id is not null then
3030: --
3031: -- Call core balance pkg with the defined balance just retrieved.
3032: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
3033: p_assignment_action_id);
3034: --
3035: else l_balance := null;
3036: end if;

Line 3158: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

3154: '_ASG_TD_EVEN_TWO_YTD');
3155: if l_defined_bal_id is not null then
3156: --
3157: -- Call core balance pkg with the defined balance just retrieved.
3158: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
3159: p_assignment_action_id);
3160: --
3161: else l_balance := null;
3162: end if;