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_DELETE_UNWANTED_SEC_PROF dependencies on PER_SECURITY_PROFILES

Line 8: ,p_security_profile_name IN per_security_profiles.security_profile_name%TYPE DEFAULT NULL) IS

4: (errbuf IN OUT NOCOPY varchar2
5: ,retcode IN OUT NOCOPY number
6: ,p_report IN varchar2 DEFAULT 'Y'
7: ,p_del_all_sec_profile IN varchar2 DEFAULT NULL
8: ,p_security_profile_name IN per_security_profiles.security_profile_name%TYPE DEFAULT NULL) IS
9: l_strong_delete varchar2(1);
10: l_proc varchar2(100);
11: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
12: CURSOR csr_security_prof_name IS

Line 11: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

7: ,p_del_all_sec_profile IN varchar2 DEFAULT NULL
8: ,p_security_profile_name IN per_security_profiles.security_profile_name%TYPE DEFAULT NULL) IS
9: l_strong_delete varchar2(1);
10: l_proc varchar2(100);
11: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
12: CURSOR csr_security_prof_name IS
13: SELECT psp.security_profile_id
14: FROM per_security_profiles psp
15: WHERE psp.security_profile_name = p_security_profile_name;

Line 14: FROM per_security_profiles psp

10: l_proc varchar2(100);
11: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
12: CURSOR csr_security_prof_name IS
13: SELECT psp.security_profile_id
14: FROM per_security_profiles psp
15: WHERE psp.security_profile_name = p_security_profile_name;
16: l_wanted varchar2(1);
17: BEGIN
18: l_proc := 'per_delete_unwanted_sec_prof.concurrent_process';

Line 112: FROM per_security_profiles

108: PROCEDURE show_unwanted_sec_prof IS
109: CURSOR c_security_profile IS
110: SELECT security_profile_id
111: ,security_profile_name
112: FROM per_security_profiles
113: WHERE reporting_oracle_username IS NULL
114: AND view_all_flag <> 'Y';
115: CURSOR c_sec_profile_assignments
116: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

Line 116: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

112: FROM per_security_profiles
113: WHERE reporting_oracle_username IS NULL
114: AND view_all_flag <> 'Y';
115: CURSOR c_sec_profile_assignments
116: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
117: SELECT responsibility_id
118: FROM per_sec_profile_assignments
119: WHERE security_profile_id = p_security_profile_id;
120: CURSOR c_responsibility

Line 137: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

133: AND sysdate BETWEEN start_date
134: AND nvl (end_date
135: ,hr_general.end_of_time);
136: CURSOR c_sec_profile
137: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
138: SELECT level_value
139: FROM fnd_profile_option_values
140: WHERE profile_option_id =
141: (

Line 149: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

145: )
146: AND level_id = '10003'
147: AND profile_option_value = to_char (p_security_profile_id);
148: CURSOR c_sec_usr_profile
149: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
150: SELECT level_value
151: FROM fnd_profile_option_values
152: WHERE profile_option_id =
153: (

Line 161: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

157: )
158: AND level_id = '10004'
159: AND profile_option_value = to_char (p_security_profile_id);
160: CURSOR c_sec_profile_site
161: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
162: SELECT 'Y'
163: FROM fnd_profile_option_values
164: WHERE profile_option_id =
165: (

Line 173: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

169: )
170: AND level_id = '10001'
171: AND profile_option_value = to_char (p_security_profile_id);
172: CURSOR c_mo_profile
173: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
174: SELECT level_value
175: FROM fnd_profile_option_values
176: WHERE profile_option_id =
177: (

Line 185: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

181: )
182: AND level_id = '10003'
183: AND profile_option_value = to_char (p_security_profile_id);
184: CURSOR c_mo_profile_site
185: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
186: SELECT 'Y'
187: FROM fnd_profile_option_values
188: WHERE profile_option_id =
189: (

Line 196: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

192: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
193: )
194: AND level_id = '10001'
195: AND profile_option_value = to_char (p_security_profile_id);
196: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
197: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;
198: l_valid varchar2(1);
199: l_active varchar2(1);
200: l_profile_counter positive DEFAULT 1;

Line 331: ,p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

327: END show_unwanted_sec_prof;
328:
329: PROCEDURE del_sec_prof
330: (p_strong_delete IN varchar2
331: ,p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
332: CURSOR c_security_profile
333: (l_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
334: SELECT rowid
335: ,security_profile_id

Line 333: (l_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

329: PROCEDURE del_sec_prof
330: (p_strong_delete IN varchar2
331: ,p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
332: CURSOR c_security_profile
333: (l_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
334: SELECT rowid
335: ,security_profile_id
336: ,view_all_flag
337: FROM per_security_profiles

Line 337: FROM per_security_profiles

333: (l_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
334: SELECT rowid
335: ,security_profile_id
336: ,view_all_flag
337: FROM per_security_profiles
338: WHERE security_profile_id = l_security_profile_id;
339: l_secgen_warn varchar2(1) DEFAULT 'N';
340: l_proc varchar2(100);
341: BEGIN

Line 363: per_security_profiles_pkg.pre_delete_validation (csr_security_profile.security_profile_id

359: IF p_strong_delete <> 'Y' THEN
360: hr_utility.set_location (l_proc
361: ,30);
362:
363: per_security_profiles_pkg.pre_delete_validation (csr_security_profile.security_profile_id
364: ,csr_security_profile.view_all_flag
365: ,l_secgen_warn);
366:
367: hr_utility.set_location (l_proc

Line 380: per_security_profiles_pkg.check_assigned_sec_profile (csr_security_profile.security_profile_id);

376:
377: hr_utility.set_location (l_proc
378: ,100);
379:
380: per_security_profiles_pkg.check_assigned_sec_profile (csr_security_profile.security_profile_id);
381: ELSE
382: hr_utility.set_location (l_proc
383: ,60);
384:

Line 394: per_security_profiles_pkg.delete_row (csr_security_profile.rowid);

390:
391: hr_utility.set_location (l_proc
392: ,80);
393:
394: per_security_profiles_pkg.delete_row (csr_security_profile.rowid);
395:
396: hr_utility.set_location (l_proc
397: ,90);
398: END LOOP;

Line 405: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

401: ,90);
402: END del_sec_prof;
403:
404: PROCEDURE strong_delete_sec_prof
405: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
406: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
407: l_proc varchar2(100);
408: BEGIN
409: l_proc := 'per_delete_unwanted_sec_prof.strong_delete_sec_prof';

Line 406: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

402: END del_sec_prof;
403:
404: PROCEDURE strong_delete_sec_prof
405: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
406: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
407: l_proc varchar2(100);
408: BEGIN
409: l_proc := 'per_delete_unwanted_sec_prof.strong_delete_sec_prof';
410:

Line 560: FROM per_security_profiles

556: (p_strong_delete IN varchar2) IS
557: CURSOR c_security_profile IS
558: SELECT security_profile_id
559: ,security_profile_name
560: FROM per_security_profiles
561: WHERE reporting_oracle_username IS NULL
562: AND view_all_flag <> 'Y';
563: CURSOR c_sec_profile_assignments
564: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

Line 564: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

560: FROM per_security_profiles
561: WHERE reporting_oracle_username IS NULL
562: AND view_all_flag <> 'Y';
563: CURSOR c_sec_profile_assignments
564: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
565: SELECT responsibility_id
566: FROM per_sec_profile_assignments
567: WHERE security_profile_id = p_security_profile_id;
568: CURSOR c_responsibility

Line 585: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

581: AND sysdate BETWEEN start_date
582: AND nvl (end_date
583: ,hr_general.end_of_time);
584: CURSOR c_sec_profile
585: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
586: SELECT level_value
587: FROM fnd_profile_option_values
588: WHERE profile_option_id =
589: (

Line 597: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

593: )
594: AND level_id = '10003'
595: AND profile_option_value = to_char (p_security_profile_id);
596: CURSOR c_sec_usr_profile
597: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
598: SELECT level_value
599: FROM fnd_profile_option_values
600: WHERE profile_option_id =
601: (

Line 609: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

605: )
606: AND level_id = '10004'
607: AND profile_option_value = to_char (p_security_profile_id);
608: CURSOR c_sec_profile_site
609: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
610: SELECT 'Y'
611: FROM fnd_profile_option_values
612: WHERE profile_option_id =
613: (

Line 621: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

617: )
618: AND level_id = '10001'
619: AND profile_option_value = to_char (p_security_profile_id);
620: CURSOR c_mo_profile
621: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
622: SELECT level_value
623: FROM fnd_profile_option_values
624: WHERE profile_option_id =
625: (

Line 633: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

629: )
630: AND level_id = '10003'
631: AND profile_option_value = to_char (p_security_profile_id);
632: CURSOR c_mo_profile_site
633: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
634: SELECT 'Y'
635: FROM fnd_profile_option_values
636: WHERE profile_option_id =
637: (

Line 644: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

640: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
641: )
642: AND level_id = '10001'
643: AND profile_option_value = to_char (p_security_profile_id);
644: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
645: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;
646: l_valid varchar2(1);
647: l_active varchar2(1);
648: l_profile_counter positive DEFAULT 1;

Line 784: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) RETURN varchar2 IS

780: ,60);
781: END del_all_unwanted_sec_prof;
782:
783: FUNCTION check_unwanted_sec_prof
784: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) RETURN varchar2 IS
785: CURSOR c_security_profile IS
786: SELECT security_profile_id
787: FROM per_security_profiles
788: WHERE reporting_oracle_username IS NULL

Line 787: FROM per_security_profiles

783: FUNCTION check_unwanted_sec_prof
784: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) RETURN varchar2 IS
785: CURSOR c_security_profile IS
786: SELECT security_profile_id
787: FROM per_security_profiles
788: WHERE reporting_oracle_username IS NULL
789: AND view_all_flag <> 'Y'
790: AND security_profile_id = p_security_profile_id;
791: CURSOR c_sec_profile_assignments

Line 792: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

788: WHERE reporting_oracle_username IS NULL
789: AND view_all_flag <> 'Y'
790: AND security_profile_id = p_security_profile_id;
791: CURSOR c_sec_profile_assignments
792: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
793: SELECT responsibility_id
794: FROM per_sec_profile_assignments
795: WHERE security_profile_id = p_security_profile_id;
796: CURSOR c_responsibility

Line 813: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

809: AND sysdate BETWEEN start_date
810: AND nvl (end_date
811: ,hr_general.end_of_time);
812: CURSOR c_sec_profile
813: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
814: SELECT level_value
815: FROM fnd_profile_option_values
816: WHERE profile_option_id =
817: (

Line 825: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

821: )
822: AND level_id = '10003'
823: AND profile_option_value = to_char (p_security_profile_id);
824: CURSOR c_sec_usr_profile
825: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
826: SELECT level_value
827: FROM fnd_profile_option_values
828: WHERE profile_option_id =
829: (

Line 837: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

833: )
834: AND level_id = '10004'
835: AND profile_option_value = to_char (p_security_profile_id);
836: CURSOR c_sec_profile_site
837: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
838: SELECT 'Y'
839: FROM fnd_profile_option_values
840: WHERE profile_option_id =
841: (

Line 849: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

845: )
846: AND level_id = '10001'
847: AND profile_option_value = to_char (p_security_profile_id);
848: CURSOR c_mo_profile
849: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
850: SELECT level_value
851: FROM fnd_profile_option_values
852: WHERE profile_option_id =
853: (

Line 861: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS

857: )
858: AND level_id = '10003'
859: AND profile_option_value = to_char (p_security_profile_id);
860: CURSOR c_mo_profile_site
861: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
862: SELECT 'Y'
863: FROM fnd_profile_option_values
864: WHERE profile_option_id =
865: (

Line 872: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

868: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
869: )
870: AND level_id = '10001'
871: AND profile_option_value = to_char (p_security_profile_id);
872: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
873: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;
874: l_valid varchar2(1);
875: l_active varchar2(1);
876: l_proc varchar2(100);