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.BEN_CWB_PERSON_INFO_PKG dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_person_info_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: g_fte_factor VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
11: g_salary_survey_id number := null; --Change to right value when implementing.
12: --
13: cursor c_sal_info(v_assignment_id number,

Line 84: hr_utility.set_location('Entering:'|| l_proc, 10);

80: --
81: begin
82: --
83: if g_debug then
84: hr_utility.set_location('Entering:'|| l_proc, 10);
85: end if;
86: --
87: open c_sal_info(p_assignment_id, p_effective_date);
88: fetch c_sal_info into l_sal_info;

Line 92: hr_utility.set_location(l_proc, 99);

88: fetch c_sal_info into l_sal_info;
89: close c_sal_info;
90: --
91: if g_debug then
92: hr_utility.set_location(l_proc, 99);
93: end if;
94: --
95: return l_sal_info;
96: end get_salary_info;

Line 113: hr_utility.set_location('Entering:'|| l_proc, 10);

109: --
110: begin
111: --
112: if g_debug then
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: end if;
115: --
116: open c_survey_info(p_job_id, p_effective_date);
117: fetch c_survey_info into l_survey_info;

Line 121: hr_utility.set_location(l_proc, 99);

117: fetch c_survey_info into l_survey_info;
118: close c_survey_info;
119: --
120: if g_debug then
121: hr_utility.set_location(l_proc, 99);
122: end if;
123: --
124: return l_survey_info;
125: end get_survey_info;

Line 144: hr_utility.set_location('Entering:'|| l_proc, 10);

140: --
141: begin
142: --
143: if g_debug then
144: hr_utility.set_location('Entering:'|| l_proc, 10);
145: end if;
146: --
147: select trunc(sum(months_between(
148: decode(asgjob.effective_end_date,

Line 159: hr_utility.set_location(l_proc, 99);

155: and asgjob.job_id = p_job_id
156: and asgjob.effective_start_date <= p_asg_effective_start_date;
157: --
158: if g_debug then
159: hr_utility.set_location(l_proc, 99);
160: end if;
161: --
162: return l_years_in_job;
163: end;

Line 182: hr_utility.set_location('Entering:'|| l_proc, 10);

178: --
179: begin
180: --
181: if g_debug then
182: hr_utility.set_location('Entering:'|| l_proc, 10);
183: end if;
184: --
185: select trunc(sum(months_between(
186: decode(asgpos.effective_end_date,

Line 197: hr_utility.set_location(l_proc, 99);

193: and asgpos.position_id = p_position_id
194: and asgpos.effective_start_date <= p_asg_effective_start_date;
195: --
196: if g_debug then
197: hr_utility.set_location(l_proc, 99);
198: end if;
199: --
200: return l_years_in_position;
201: end;

Line 220: hr_utility.set_location('Entering:'|| l_proc, 10);

216: --
217: begin
218: --
219: if g_debug then
220: hr_utility.set_location('Entering:'|| l_proc, 10);
221: end if;
222: --
223: select trunc(sum(months_between(
224: decode(asggrd.effective_end_date,

Line 235: hr_utility.set_location(l_proc, 99);

231: and asggrd.grade_id = p_grade_id
232: and asggrd.effective_start_date <= p_asg_effective_start_date;
233: --
234: if g_debug then
235: hr_utility.set_location(l_proc, 99);
236: end if;
237: --
238: return l_years_in_grade;
239: end; -- get_years_in_grade

Line 256: hr_utility.set_location('Entering:'|| l_proc, 10);

252: --
253: begin
254: --
255: if g_debug then
256: hr_utility.set_location('Entering:'|| l_proc, 10);
257: end if;
258: --
259: select fnd_number.canonical_to_number(minimum) into l_grd_min_val
260: from pay_grade_rules_f grdrule

Line 267: hr_utility.set_location(l_proc, 99);

263: and p_effective_date between grdrule.effective_start_date
264: and grdrule.effective_end_date;
265: --
266: if g_debug then
267: hr_utility.set_location(l_proc, 99);
268: end if;
269: --
270: return l_grd_min_val;
271: end; -- get_grd_min_val

Line 289: hr_utility.set_location('Entering:'|| l_proc, 10);

285: --
286: begin
287: --
288: if g_debug then
289: hr_utility.set_location('Entering:'|| l_proc, 10);
290: end if;
291: --
292: select fnd_number.canonical_to_number(maximum) into l_grd_max_val
293: from pay_grade_rules_f grdrule

Line 300: hr_utility.set_location(l_proc, 99);

296: and p_effective_date between grdrule.effective_start_date
297: and grdrule.effective_end_date;
298: --
299: if g_debug then
300: hr_utility.set_location(l_proc, 99);
301: end if;
302: --
303: return l_grd_max_val;
304: end; -- get_grd_max_val

Line 322: hr_utility.set_location('Entering:'|| l_proc, 10);

318: --
319: begin
320: --
321: if g_debug then
322: hr_utility.set_location('Entering:'|| l_proc, 10);
323: end if;
324: --
325: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point
326: from pay_grade_rules_f grdrule

Line 333: hr_utility.set_location(l_proc, 99);

329: and p_effective_date between grdrule.effective_start_date
330: and grdrule.effective_end_date;
331: --
332: if g_debug then
333: hr_utility.set_location(l_proc, 99);
334: end if;
335: --
336: return l_grd_mid_point;
337: end; -- get_grd_mid_point

Line 753: hr_utility.set_location('Entering:'|| l_proc, 10);

749: 'refresh_person_info';
750: ben_manage_cwb_life_events.g_error_log_rec.step_number := 211;
751: --
752: if g_debug then
753: hr_utility.set_location('Entering:'|| l_proc, 10);
754: end if;
755: --
756: -- get the performance_rating_type from pl_dsgn. This value is same
757: -- for all plans and oipls in a group plan.

Line 796: hr_utility.set_location(l_proc, 20);

792: l_from_benmngle := 'N';
793: end if;
794: --
795: if g_debug then
796: hr_utility.set_location(l_proc, 20);
797: end if;
798: --
799: -- Open the cursor and update the details in ben_cwb_person_info
800: -- It always should return only one row, but using the for to avoid

Line 1043: hr_utility.set_location(l_proc, 30);

1039: ,appraisal_id = perinfo_rec.appraisal_id
1040: where group_per_in_ler_id = perinfo_rec.group_per_in_ler_id;
1041: --
1042: if g_debug then
1043: hr_utility.set_location(l_proc, 30);
1044: end if;
1045: --
1046: else
1047: -- The record does not exist. So insert the new record

Line 1402: hr_utility.set_location(l_proc, 40);

1398: ,perinfo_rec.appraisal_id
1399: );
1400: --
1401: if g_debug then
1402: hr_utility.set_location(l_proc, 40);
1403: end if;
1404: --
1405: -- ************ audit changes ****************** --
1406: ben_cwb_audit_api.create_per_record

Line 1432: hr_utility.set_location(l_proc, 50);

1428: if p_called_from_benmngle and not(l_rec_modified) and
1429: l_cpi_effective_date is null then
1430: --
1431: if g_debug then
1432: hr_utility.set_location(l_proc, 50);
1433: end if;
1434: --
1435: if l_assignment_id is not null then
1436: insert into ben_cwb_person_info

Line 1460: hr_utility.set_location(l_proc, 60);

1456: ben_cwb_audit_api.create_per_record
1457: (p_per_in_ler_id => p_group_per_in_ler_id);
1458: -- ********************************************* --
1459: if g_debug then
1460: hr_utility.set_location(l_proc, 60);
1461: end if;
1462: --
1463: end if;
1464: --

Line 1468: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1464: --
1465: end if;
1466: --
1467: if g_debug then
1468: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1469: end if;
1470: --
1471: end; -- of refresh_person_info
1472: --

Line 1494: hr_utility.set_location('Entering:'|| l_proc, 10);

1490: --
1491: begin
1492: --
1493: if g_debug then
1494: hr_utility.set_location('Entering:'|| l_proc, 10);
1495: end if;
1496: --
1497: -- for each record in csr_pil
1498: for pil in csr_pil loop

Line 1501: hr_utility.set_location(l_proc, 20);

1497: -- for each record in csr_pil
1498: for pil in csr_pil loop
1499: --
1500: if g_debug then
1501: hr_utility.set_location(l_proc, 20);
1502: end if;
1503: --
1504: refresh_person_info(p_group_per_in_ler_id => pil.per_in_ler_id
1505: ,p_effective_date => p_effective_date);

Line 1516: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1512: --
1513: end loop;
1514: --
1515: if g_debug then
1516: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1517: end if;
1518: --
1519: end;
1520: --

Line 1539: hr_utility.set_location('Entering:'|| l_proc, 10);

1535: --
1536: begin
1537: --
1538: if g_debug then
1539: hr_utility.set_location('Entering:'|| l_proc, 10);
1540: end if;
1541: --
1542: if p_salary is not null then
1543: if p_salary < p_min then

Line 1559: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1555: end if;
1556: end if;
1557: --
1558: if g_debug then
1559: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1560: end if;
1561: --
1562: return l_return_value;
1563: --

Line 1585: hr_utility.set_location('Entering:'|| l_proc, 10);

1581: --
1582: begin
1583: --
1584: if g_debug then
1585: hr_utility.set_location('Entering:'|| l_proc, 10);
1586: end if;
1587: --
1588: if p_salary is not null and l_step is not null then
1589: if p_salary < p_min then

Line 1607: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1603: end if;
1604: end if;
1605: --
1606: if g_debug then
1607: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1608: end if;
1609: --
1610: return l_return_value;
1611: --

Line 1633: hr_utility.set_location('Entering:'|| l_proc, 10);

1629: --
1630: begin
1631: --
1632: if g_debug then
1633: hr_utility.set_location('Entering:'|| l_proc, 10);
1634: end if;
1635: --
1636: if p_salary is not null and l_step is not null then
1637: if p_salary < p_min then

Line 1665: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1661: end if;
1662: end if;
1663: --
1664: if g_debug then
1665: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1666: end if;
1667: --
1668: return l_return_value;
1669: --

Line 1694: hr_utility.set_location('Entering:'|| l_proc, 10);

1690: --
1691: begin
1692: --
1693: if g_debug then
1694: hr_utility.set_location('Entering:'|| l_proc, 10);
1695: end if;
1696: --
1697: if l_range = 0 then
1698: return l_return_val;

Line 1704: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1700: --
1701: l_return_val := round((l_min_to_sal / l_range * 100),1);
1702: --
1703: if g_debug then
1704: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1705: end if;
1706: --
1707: return l_return_val;
1708: --

Line 1725: hr_utility.set_location('Entering:'|| l_proc, 10);

1721: --
1722: begin
1723: --
1724: if g_debug then
1725: hr_utility.set_location('Entering:'|| l_proc, 10);
1726: end if;
1727: --
1728: if p_salary is null or p_mid is null or p_mid <= 0 then
1729: return null;

Line 1754: hr_utility.set_location('Entering:'|| l_proc, 10);

1750: --
1751: begin
1752: --
1753: if g_debug then
1754: hr_utility.set_location('Entering:'|| l_proc, 10);
1755: end if;
1756: --
1757: select pl.effective_date into l_effective_date
1758: from ben_cwb_pl_dsgn pl

Line 1776: hr_utility.set_location(l_proc, 30);

1772: l_effective_date := null;
1773: end if;
1774: --
1775: if g_debug then
1776: hr_utility.set_location(l_proc, 30);
1777: end if;
1778: --
1779: -- call refresh_person_info
1780: refresh_person_info(p_group_per_in_ler_id => p_group_per_in_ler_id

Line 1784: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1780: refresh_person_info(p_group_per_in_ler_id => p_group_per_in_ler_id
1781: ,p_effective_date => l_effective_date);
1782: --
1783: if g_debug then
1784: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1785: end if;
1786: --
1787: end;
1788: --

Line 1815: hr_utility.set_location('Entering:'|| l_proc, 10);

1811: --
1812: begin
1813: --
1814: if g_debug then
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: end if;
1817: --
1818: open csr_currency;
1819: fetch csr_currency into l_currency;

Line 1823: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1819: fetch csr_currency into l_currency;
1820: close csr_currency;
1821: --
1822: if g_debug then
1823: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1824: end if;
1825: --
1826: return l_currency;
1827: end;