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 1309: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,

1305: IF l_defined_bal_id IS NOT NULL THEN
1306: --hr_utility.trace('PER - Dimension is relevant');
1307: --
1308: -- Call core balance pkg with the defined balance just retrieved.
1309: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1310: p_assignment_action_id);
1311:
1312: ELSE
1313: --hr_utility.trace('PER - Dimension not relevant');

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

1522: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PROC_YTD');
1523: if l_defined_bal_id is not null then
1524: --
1525: -- Call core balance pkg with the defined balance just retrieved.
1526: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1527: p_assignment_action_id);
1528: --
1529: else l_balance := null;
1530: end if;

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

1641: if l_defined_bal_id is not null then
1642: --
1643: -- Call core balance pkg with the defined balance just retrieved.
1644: --
1645: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1646: p_assignment_action_id);
1647: end if;
1648: --
1649: RETURN l_balance;

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

1792: --
1793: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_YTD');
1794: if l_defined_bal_id is not null then
1795: --
1796: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1797: p_assignment_action_id);
1798: --
1799: else l_balance := null;
1800: end if;

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

1930: --
1931: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_STAT_YTD');
1932: if l_defined_bal_id is not null then
1933: --
1934: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
1935: p_assignment_action_id);
1936: --
1937: else l_balance := null;
1938: end if;

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

2086: --
2087: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PROC_PTD');
2088: if l_defined_bal_id is not null then
2089: --
2090: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2091: p_assignment_action_id);
2092: --
2093: else l_balance := null;
2094: end if;

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

2233: if l_defined_bal_id is not null then
2234: --
2235: -- Call core balance pkg with the defined balance just retrieved.
2236: --
2237: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2238: p_assignment_action_id);
2239: --
2240: else l_balance := null;
2241: end if;

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

2375: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_PAYMENTS');
2376: if l_defined_bal_id is not null then
2377: --
2378: -- Call core balance pkg with the defined balance just retrieved.
2379: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2380: p_assignment_action_id);
2381: --
2382: else l_balance := null;
2383: end if;

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

2494: if l_defined_bal_id is not null then
2495: --
2496: -- Is there a value in the latest balances table ..
2497: --
2498: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2499: p_assignment_action_id);
2500: --
2501: else l_balance := null;
2502: end if;

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

2609: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_TD_ITD');
2610: if l_defined_bal_id is not null then
2611: --
2612: -- Call core balance pkg with the defined balance just retrieved.
2613: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2614: p_assignment_action_id);
2615: --
2616: else l_balance := null;
2617: end if;

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

2759: --
2760: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_TRANSFER_PTD');
2761: if l_defined_bal_id is not null then
2762: --
2763: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2764: p_assignment_action_id);
2765: --
2766: else l_balance := null;
2767: end if;

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

2842: --
2843: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_TD_YTD');
2844: if l_defined_bal_id is not null then
2845: --
2846: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
2847: p_assignment_action_id);
2848: --
2849: else l_balance := null;
2850: end if;

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

3022: '_ASG_TD_ODD_TWO_YTD');
3023: if l_defined_bal_id is not null then
3024: --
3025: -- Call core balance pkg with the defined balance just retrieved.
3026: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
3027: p_assignment_action_id);
3028: --
3029: else l_balance := null;
3030: end if;

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

3148: '_ASG_TD_EVEN_TWO_YTD');
3149: if l_defined_bal_id is not null then
3150: --
3151: -- Call core balance pkg with the defined balance just retrieved.
3152: l_balance := pay_balance_pkg.get_value(l_defined_bal_id,
3153: p_assignment_action_id);
3154: --
3155: else l_balance := null;
3156: end if;