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.PER_APPLICATIONS_PKG dependencies on PER_APPLICATIONS_PKG

Line 1: PACKAGE BODY PER_APPLICATIONS_PKG as

1: PACKAGE BODY PER_APPLICATIONS_PKG as
2: /* $Header: peapp01t.pkb 120.0 2005/05/31 05:20:53 appldev noship $ */
3: /* =========================================================================
4: Name
5: per_applications_pkg

Line 5: per_applications_pkg

1: PACKAGE BODY PER_APPLICATIONS_PKG as
2: /* $Header: peapp01t.pkb 120.0 2005/05/31 05:20:53 appldev noship $ */
3: /* =========================================================================
4: Name
5: per_applications_pkg
6: Purpose
7: Supports the Termination Details Block (APL) in the form
8: PERWSTAP - Terminate Applicant.
9: ==========================================================================

Line 106: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',5);

102: --
103: BEGIN
104: p_del_flag := 'N';
105:
106: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',5);
107: hr_utility.set_location(p_date_end,6);
108:
109: BEGIN
110:

Line 131: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',10);

127: END;
128: --
129: IF p_del_flag = 'Y' THEN
130: --
131: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',10);
132: --
133: delete from per_assignment_budget_values_f abv
134: where exists (
135: Select null

Line 151: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',15);

147: END IF;
148:
149: p_del_flag := 'N';
150: --
151: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',15);
152: --
153: -- Check for and update any assignment budget value row(s) where the termination end date occurs during the
154: -- life of the assignment budget value row(s).
155: --

Line 179: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',20);

175: END;
176:
177: IF p_del_flag = 'Y' THEN
178: --
179: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',20);
180: --
181: --
182: -- Start of fix for WWBUG 1408379
183: --

Line 281: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',5);

277: --
278: BEGIN
279: p_del_flag := 'N';
280:
281: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',5);
282:
283: --
284: BEGIN
285:

Line 307: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',10);

303: END;
304:
305: IF p_del_flag = 'Y' THEN
306: --
307: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',10);
308: --
309: --
310: -- Start of fix for WWBUG 1408379
311: --

Line 2259: hr_utility.set_location('per_applications_pkg.update_row',10);

2255: l_date_end date;
2256: l_update_mode varchar2(30);
2257:
2258: BEGIN
2259: hr_utility.set_location('per_applications_pkg.update_row',10);
2260: -- Bug 3053711 Start
2261: -- Added the check if flag = 'Y'
2262: --Commented out for the Bug 4202317
2263: -- if p_Cancellation_Flag = 'Y' then

Line 2336: hr_utility.set_location('per_applications_pkg.update_row',20);

2332: appl_attribute20 = p_Appl_Attribute20
2333: WHERE rowid = p_rowid;
2334: end if;*/
2335: -- Bug 3053711 End
2336: hr_utility.set_location('per_applications_pkg.update_row',20);
2337: if (SQL%NOTFOUND) then
2338: RAISE NO_DATA_FOUND;
2339: end if;
2340:

Line 2341: hr_utility.set_location('per_applications_pkg.update_row',30);

2337: if (SQL%NOTFOUND) then
2338: RAISE NO_DATA_FOUND;
2339: end if;
2340:
2341: hr_utility.set_location('per_applications_pkg.update_row',30);
2342: --
2343: -- Now maintain the PTU data...
2344: --
2345: -- 3652025: Another package will do the updates when performing a termination.

Line 2356: --hr_utility.set_location('per_applications_pkg.update_row',40);

2352: -- terminated application.
2353: --
2354: -- PTU : Following code added for PTU
2355: --
2356: --hr_utility.set_location('per_applications_pkg.update_row',40);
2357:
2358: --Bug No 3891787 starts here
2359: --Open csr_ptu_row1;
2360: --fetch csr_ptu_row1 into l_person_type_id,l_start_date;

Line 2381: --hr_utility.set_location('per_applications_pkg.update_row',50);

2377: -- );
2378: --end if;
2379: --close csr_ptu_row1;
2380: --Bug No 3891787 ends here
2381: --hr_utility.set_location('per_applications_pkg.update_row',50);
2382: -- End of PTU Changes
2383: --
2384: -- hr_per_type_usage_internal.maintain_ptu(
2385: -- p_action => 'TERM_APL',

Line 2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);

2399: open csr_ptu_row;
2400: fetch csr_ptu_row into l_date_end;
2401: close csr_ptu_row;
2402:
2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2406:
2407: hr_per_type_usage_internal.cancel_person_type_usage

Line 2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);

2400: fetch csr_ptu_row into l_date_end;
2401: close csr_ptu_row;
2402:
2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2406:
2407: hr_per_type_usage_internal.cancel_person_type_usage
2408: (

Line 2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);

2401: close csr_ptu_row;
2402:
2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2406:
2407: hr_per_type_usage_internal.cancel_person_type_usage
2408: (
2409: p_effective_date => l_date_end

Line 2490: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 10);

2486: and paa.effective_end_date = p_date_end;
2487: --
2488: begin
2489: --
2490: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 10);
2491: --
2492: -- Termination of applicant
2493: if p_action = 'TERM' then
2494: --

Line 2497: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 20);

2493: if p_action = 'TERM' then
2494: --
2495: l_ass_status := 'TERM_APL';
2496: --
2497: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 20);
2498: --
2499: open csr_get_asg_status;
2500: fetch csr_get_asg_status into l_ass_status_type_id;
2501: close csr_get_asg_status;

Line 2523: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);

2519: else
2520: --
2521: l_ass_status := 'ACTIVE_APL';
2522: --
2523: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);
2524: --
2525: open csr_get_asg_status;
2526: fetch csr_get_asg_status into l_ass_status_type_id;
2527: close csr_get_asg_status;

Line 2546: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);

2542: close csr_cancel_ass_id;
2543: --
2544: end if;
2545: --
2546: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);
2547: --
2548: end maintain_irc_ass_status;
2549: --
2550: END PER_APPLICATIONS_PKG;

Line 2550: END PER_APPLICATIONS_PKG;

2546: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);
2547: --
2548: end maintain_irc_ass_status;
2549: --
2550: END PER_APPLICATIONS_PKG;