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

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: package body pay_kr_yea_sshr_utils_pkg
2: /* $Header: pykryutl.pkb 120.28.12020000.3 2013/01/08 12:45:00 scireddy ship $ */
3: as
4: --------------------------------------------------------------
5: g_debug boolean := hr_utility.debug_enabled;
6: --------------------------------------------------------------
7:
8: CURSOR csr_get_def_bal_id(p_bal_name IN varchar2) is
9: select pdb.defined_balance_id

Line 583: hr_utility.set_location(l_proc_name, 10);

579: p_return_status := 'S';
580: --
581: --
582: if g_debug then
583: hr_utility.set_location(l_proc_name, 10);
584: end if;
585: --
586: --
587: if p_effective_date is null then

Line 1282: hr_utility.set_location('pay_kr_yea_sshr_utils_pkg.update_allowed', 10);

1278: --
1279: begin
1280:
1281: if g_debug then
1282: hr_utility.set_location('pay_kr_yea_sshr_utils_pkg.update_allowed', 10);
1283: end if;
1284:
1285: l_update_allowed := 'N';
1286: l_entry_start_date := null;

Line 1294: hr_utility.trace('YEA Run Exists = '||l_flag);

1290: open csr_yea_exist;
1291: fetch csr_yea_exist into l_flag;
1292:
1293: if g_debug then
1294: hr_utility.trace('YEA Run Exists = '||l_flag);
1295: end if;
1296:
1297: if csr_yea_exist%NOTFOUND then
1298:

Line 1305: hr_utility.trace('fetching emp org entry period');

1301: fetch csr_emp_org_id into l_emp_org_id;
1302: close csr_emp_org_id;
1303:
1304: if g_debug then
1305: hr_utility.trace('fetching emp org entry period');
1306: end if;
1307:
1308: open csr_emp_org_entry_period(l_emp_org_id);
1309: fetch csr_emp_org_entry_period into

Line 1317: hr_utility.trace('Emp org entry period not found.');

1313: close csr_emp_org_entry_period;
1314:
1315: if l_entry_start_date is null then
1316: if g_debug then
1317: hr_utility.trace('Emp org entry period not found.');
1318: hr_utility.trace('Fetching Entry Period from Hierarchy.');
1319: end if;
1320:
1321: -- check for periods of parent organizations in hierarchy

Line 1318: hr_utility.trace('Fetching Entry Period from Hierarchy.');

1314:
1315: if l_entry_start_date is null then
1316: if g_debug then
1317: hr_utility.trace('Emp org entry period not found.');
1318: hr_utility.trace('Fetching Entry Period from Hierarchy.');
1319: end if;
1320:
1321: -- check for periods of parent organizations in hierarchy
1322: open csr_org_struct_version;

Line 1329: hr_utility.trace('Struct Version ID : ' || l_struct_version_id);

1325:
1326: -- check if primary hierarchy is defined
1327: if l_struct_version_id is not null then
1328: if g_debug then
1329: hr_utility.trace('Struct Version ID : ' || l_struct_version_id);
1330: end if;
1331:
1332: open csr_hierarchy_entry_period(l_struct_version_id,l_emp_org_id);
1333:

Line 1346: hr_utility.trace('Entry period of Hierarchy not found.');

1342: -- 4657745
1343: -- if entry period not found in Hierarchy, check BG Entry period
1344: if l_entry_start_date is null then
1345: if g_debug then
1346: hr_utility.trace('Entry period of Hierarchy not found.');
1347: hr_utility.trace('Fetching Entry Period from BG.');
1348: end if;
1349:
1350: -- check for entry period of the BG

Line 1347: hr_utility.trace('Fetching Entry Period from BG.');

1343: -- if entry period not found in Hierarchy, check BG Entry period
1344: if l_entry_start_date is null then
1345: if g_debug then
1346: hr_utility.trace('Entry period of Hierarchy not found.');
1347: hr_utility.trace('Fetching Entry Period from BG.');
1348: end if;
1349:
1350: -- check for entry period of the BG
1351: open csr_bg_entry_period;

Line 1369: hr_utility.trace('l_entry_start_date = '|| l_entry_start_date);

1365:
1366: end if; -- emp org period exists.
1367:
1368: if g_debug then
1369: hr_utility.trace('l_entry_start_date = '|| l_entry_start_date);
1370: hr_utility.trace('l_entry_end_date = '|| l_entry_end_date);
1371: hr_utility.trace('l_update_cut_off_date = '|| l_update_cut_off_date);
1372: end if;
1373:

Line 1370: hr_utility.trace('l_entry_end_date = '|| l_entry_end_date);

1366: end if; -- emp org period exists.
1367:
1368: if g_debug then
1369: hr_utility.trace('l_entry_start_date = '|| l_entry_start_date);
1370: hr_utility.trace('l_entry_end_date = '|| l_entry_end_date);
1371: hr_utility.trace('l_update_cut_off_date = '|| l_update_cut_off_date);
1372: end if;
1373:
1374:

Line 1371: hr_utility.trace('l_update_cut_off_date = '|| l_update_cut_off_date);

1367:
1368: if g_debug then
1369: hr_utility.trace('l_entry_start_date = '|| l_entry_start_date);
1370: hr_utility.trace('l_entry_end_date = '|| l_entry_end_date);
1371: hr_utility.trace('l_update_cut_off_date = '|| l_update_cut_off_date);
1372: end if;
1373:
1374:
1375: -- compare employees effective entry period with current date

Line 1400: hr_utility.trace('Assgn Level Update Allowed = '||l_update_allowed);

1396: l_update_allowed := 'N';
1397: end if; -- assignment level update allowed
1398:
1399: if g_debug then
1400: hr_utility.trace('Assgn Level Update Allowed = '||l_update_allowed);
1401: end if;
1402:
1403: end if; -- compare current date with entry period
1404:

Line 2629: hr_utility.trace('p_statutory = '||to_char(p_statutory));

2625: end;
2626: --
2627: begin
2628: --
2629: hr_utility.trace('p_statutory = '||to_char(p_statutory));
2630: hr_utility.trace('p_political = '||to_char(p_political));
2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));

Line 2630: hr_utility.trace('p_political = '||to_char(p_political));

2626: --
2627: begin
2628: --
2629: hr_utility.trace('p_statutory = '||to_char(p_statutory));
2630: hr_utility.trace('p_political = '||to_char(p_political));
2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));
2634: hr_utility.trace('p_specified = '||to_char(p_specified));

Line 2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));

2627: begin
2628: --
2629: hr_utility.trace('p_statutory = '||to_char(p_statutory));
2630: hr_utility.trace('p_political = '||to_char(p_political));
2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));
2634: hr_utility.trace('p_specified = '||to_char(p_specified));
2635: hr_utility.trace('p_tax_law = '||to_char(p_tax_law));

Line 2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));

2628: --
2629: hr_utility.trace('p_statutory = '||to_char(p_statutory));
2630: hr_utility.trace('p_political = '||to_char(p_political));
2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));
2634: hr_utility.trace('p_specified = '||to_char(p_specified));
2635: hr_utility.trace('p_tax_law = '||to_char(p_tax_law));
2636:

Line 2633: hr_utility.trace('p_religious = '||to_char(p_religious));

2629: hr_utility.trace('p_statutory = '||to_char(p_statutory));
2630: hr_utility.trace('p_political = '||to_char(p_political));
2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));
2634: hr_utility.trace('p_specified = '||to_char(p_specified));
2635: hr_utility.trace('p_tax_law = '||to_char(p_tax_law));
2636:
2637: -- Statutory Donation

Line 2634: hr_utility.trace('p_specified = '||to_char(p_specified));

2630: hr_utility.trace('p_political = '||to_char(p_political));
2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));
2634: hr_utility.trace('p_specified = '||to_char(p_specified));
2635: hr_utility.trace('p_tax_law = '||to_char(p_tax_law));
2636:
2637: -- Statutory Donation
2638: l_asg_info_id := null;

Line 2635: hr_utility.trace('p_tax_law = '||to_char(p_tax_law));

2631: hr_utility.trace('p_esoa = '||to_char(p_esoa));
2632: hr_utility.trace('p_pledt = '||to_char(p_pledt));
2633: hr_utility.trace('p_religious = '||to_char(p_religious));
2634: hr_utility.trace('p_specified = '||to_char(p_specified));
2635: hr_utility.trace('p_tax_law = '||to_char(p_tax_law));
2636:
2637: -- Statutory Donation
2638: l_asg_info_id := null;
2639: open csr_check_data('10');