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.7.12020000.6 2013/05/27 06:13:48 srannama ship $ */
3: /* =========================================================================
4: Name
5: per_applications_pkg

Line 5: per_applications_pkg

1: PACKAGE BODY PER_APPLICATIONS_PKG as
2: /* $Header: peapp01t.pkb 120.7.12020000.6 2013/05/27 06:13:48 srannama ship $ */
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 2463: hr_utility.set_location('per_applications_pkg.update_row',10);

2459: where person_id = p_person_id
2460: and date_received > p_date_received;
2461:
2462: BEGIN
2463: hr_utility.set_location('per_applications_pkg.update_row',10);
2464:
2465: -- ER FPT
2466: IF (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2467: -- Reverse Terminating the End Application

Line 2481: per_applications_pkg.delete_row(apl.rowid);

2477: where application_id = apl.application_id
2478: and person_id = p_person_id
2479: and assignment_type = 'A';
2480: -- deleting the future APL
2481: per_applications_pkg.delete_row(apl.rowid);
2482:
2483: end loop;
2484:
2485: -- looping through the future PTU records of APL

Line 2676: -- hr_utility.set_location('per_applications_pkg.update_row',20); --Commented to resolve Bug#13934184

2672: appl_attribute20 = p_Appl_Attribute20
2673: WHERE rowid = p_rowid;
2674: end if;*/
2675: -- Bug 3053711 End
2676: -- hr_utility.set_location('per_applications_pkg.update_row',20); --Commented to resolve Bug#13934184
2677: if (SQL%NOTFOUND) then
2678: RAISE NO_DATA_FOUND;
2679: end if;
2680:

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

2677: if (SQL%NOTFOUND) then
2678: RAISE NO_DATA_FOUND;
2679: end if;
2680:
2681: hr_utility.set_location('per_applications_pkg.update_row',30);
2682: --
2683: -- Now maintain the PTU data...
2684: --
2685: -- 3652025: Another package will do the updates when performing a termination.

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

2692: -- terminated application.
2693: --
2694: -- PTU : Following code added for PTU
2695: --
2696: --hr_utility.set_location('per_applications_pkg.update_row',40);
2697:
2698: --Bug No 3891787 starts here
2699: --Open csr_ptu_row1;
2700: --fetch csr_ptu_row1 into l_person_type_id,l_start_date;

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

2717: -- );
2718: --end if;
2719: --close csr_ptu_row1;
2720: --Bug No 3891787 ends here
2721: --hr_utility.set_location('per_applications_pkg.update_row',50);
2722: -- End of PTU Changes
2723: --
2724: -- hr_per_type_usage_internal.maintain_ptu(
2725: -- p_action => 'TERM_APL',

Line 2747: hr_utility.set_location('per_applications_pkg.update_row',60);

2743: -- Bug 10286850
2744: open csr_chk_emp;
2745: fetch csr_chk_emp into l_person_id;
2746: if csr_chk_emp%found then
2747: hr_utility.set_location('per_applications_pkg.update_row',60);
2748: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');
2749: hr_utility.raise_error;
2750: end if;
2751: close csr_chk_emp;

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

2749: hr_utility.raise_error;
2750: end if;
2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2756:
2757: if l_date_end is not null then

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

2750: end if;
2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2756:
2757: if l_date_end is not null then
2758: hr_per_type_usage_internal.cancel_person_type_usage

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

2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2756:
2757: if l_date_end is not null then
2758: hr_per_type_usage_internal.cancel_person_type_usage
2759: (

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

2838: and paa.effective_end_date = p_date_end;
2839: --
2840: begin
2841: --
2842: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 10);
2843: --
2844: -- Termination of applicant
2845: if p_action = 'TERM' then
2846: --

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

2845: if p_action = 'TERM' then
2846: --
2847: l_ass_status := 'TERM_APL';
2848: --
2849: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 20);
2850: --
2851: open csr_get_asg_status;
2852: fetch csr_get_asg_status into l_ass_status_type_id;
2853: close csr_get_asg_status;

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

2871: else
2872: --
2873: l_ass_status := 'ACTIVE_APL';
2874: --
2875: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);
2876: --
2877: open csr_get_asg_status;
2878: fetch csr_get_asg_status into l_ass_status_type_id;
2879: close csr_get_asg_status;

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

2894: close csr_cancel_ass_id;
2895: --
2896: end if;
2897: --
2898: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);
2899: --
2900: end maintain_irc_ass_status;
2901: --
2902: END PER_APPLICATIONS_PKG;

Line 2902: END PER_APPLICATIONS_PKG;

2898: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);
2899: --
2900: end maintain_irc_ass_status;
2901: --
2902: END PER_APPLICATIONS_PKG;