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

Line 1: Package Body HR_SECURITY_INTERNAL as

1: Package Body HR_SECURITY_INTERNAL as
2: /* $Header: pesecbsi.pkb 120.24.12020000.4 2013/03/05 06:33:05 swrajapa ship $ */
3:
4: --
5: -- Stores details of what security permission have been cached for a

Line 21: g_PACKAGE CONSTANT VARCHAR2(23) := 'hr_security_internal.';

17:
18: --
19: -- Package Private Constants
20: --
21: g_PACKAGE CONSTANT VARCHAR2(23) := 'hr_security_internal.';
22:
23: --
24: -- Package Private Variables
25: --

Line 527: null,:l_true,hr_security_internal.evaluate_custom(

523: end if;
524: --
525: l_inst_str := ' select sec.security_profile_id '; --
526: l_comm_str := ' decode(sec.custom_restriction_flag,:l_Restrict,:l_true,:l_U,:l_FALSE,
527: null,:l_true,hr_security_internal.evaluate_custom(
528: :p_assignment_id , sec.restriction_text,
529: to_date(to_char(:p_effective_date, ''dd/mm/yyyy'')
530: , ''dd/mm/yyyy''))) = :l_true and not exists (
531: select 1 from per_person_list ppl

Line 2620: ' hr_security_internal.evaluate_custom(

2616: and sec.view_all_flag = :l_Restrict and ';
2617: --
2618: l_exec_str := l_inst_str||l_from_str||' where '||
2619: l_bggr_str||l_asgt_str||l_cond_str||
2620: ' hr_security_internal.evaluate_custom(
2621: :p_assignment_id,sec.restriction_text,
2622: to_date(to_char(:p_effective_date, ''dd/mm/yyyy'')
2623: , ''dd/mm/yyyy'')) = :l_true and not exists (
2624: select 1 from per_person_list ppl

Line 3827: AND hr_security_internal.show_organization

3823: FROM hr_all_positions_f hapf
3824: WHERE hapf.position_id = p_position_id
3825: AND p_effective_date BETWEEN
3826: hapf.effective_start_date AND hapf.effective_end_date
3827: AND hr_security_internal.show_organization
3828: (hapf.organization_id) = 'TRUE';
3829:
3830: BEGIN
3831:

Line 3881: AND hr_security_internal.show_organization

3877: FROM hr_all_positions_f hapf
3878: WHERE hapf.position_id = p.subordinate_position_id
3879: AND p_effective_date BETWEEN
3880: hapf.effective_start_date AND hapf.effective_end_date
3881: AND hr_security_internal.show_organization
3882: (hapf.organization_id) = 'TRUE');
3883:
3884: --
3885: -- Get all the positions in the hierarchy given a top

Line 4662: 'hr_security_internal.show_organization(hr_asg.organization_id) = ''TRUE''';

4658: l_emp_str VARCHAR2(32) := 'hr_asg.assignment_type = ''E''';
4659: l_cwk_str VARCHAR2(32) := 'hr_asg.assignment_type = ''C''';
4660: l_apl_str VARCHAR2(32) := 'hr_asg.assignment_type = ''A''';
4661: l_org_str VARCHAR2(150) :=
4662: 'hr_security_internal.show_organization(hr_asg.organization_id) = ''TRUE''';
4663: l_pos_str VARCHAR2(150) :=
4664: '(hr_asg.position_id IS NULL OR hr_security_internal.show_position(hr_asg.position_id) = ''TRUE'')';
4665: l_pay_str VARCHAR2(150) :=
4666: '(hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')';

Line 4664: '(hr_asg.position_id IS NULL OR hr_security_internal.show_position(hr_asg.position_id) = ''TRUE'')';

4660: l_apl_str VARCHAR2(32) := 'hr_asg.assignment_type = ''A''';
4661: l_org_str VARCHAR2(150) :=
4662: 'hr_security_internal.show_organization(hr_asg.organization_id) = ''TRUE''';
4663: l_pos_str VARCHAR2(150) :=
4664: '(hr_asg.position_id IS NULL OR hr_security_internal.show_position(hr_asg.position_id) = ''TRUE'')';
4665: l_pay_str VARCHAR2(150) :=
4666: '(hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')';
4667: -- '(hr_asg.payroll_id IS NULL OR hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')'; -- Modified the statement for bug 11737636.
4668:

Line 4666: '(hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')';

4662: 'hr_security_internal.show_organization(hr_asg.organization_id) = ''TRUE''';
4663: l_pos_str VARCHAR2(150) :=
4664: '(hr_asg.position_id IS NULL OR hr_security_internal.show_position(hr_asg.position_id) = ''TRUE'')';
4665: l_pay_str VARCHAR2(150) :=
4666: '(hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')';
4667: -- '(hr_asg.payroll_id IS NULL OR hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')'; -- Modified the statement for bug 11737636.
4668:
4669: --- Bug # 12739699 ---
4670: l_paaf_name varchar2(30) := 'per_all_assignments_f';

Line 4667: -- '(hr_asg.payroll_id IS NULL OR hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')'; -- Modified the statement for bug 11737636.

4663: l_pos_str VARCHAR2(150) :=
4664: '(hr_asg.position_id IS NULL OR hr_security_internal.show_position(hr_asg.position_id) = ''TRUE'')';
4665: l_pay_str VARCHAR2(150) :=
4666: '(hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')';
4667: -- '(hr_asg.payroll_id IS NULL OR hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')'; -- Modified the statement for bug 11737636.
4668:
4669: --- Bug # 12739699 ---
4670: l_paaf_name varchar2(30) := 'per_all_assignments_f';
4671: --- Bug # 12739699 ---

Line 9283: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PER_FROM_SECURITY_LIST';

9279: PROCEDURE delete_per_from_security_list(P_PERSON_ID IN number)
9280: IS
9281: --
9282: -- bug fix 3760559. l_proc size increased to 80.
9283: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PER_FROM_SECURITY_LIST';
9284: begin
9285: hr_utility.set_location('Entering:'|| l_proc, 10);
9286: delete from per_person_list l
9287: where l.person_id = P_PERSON_ID;

Line 9301: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.ADD_ORG_TO_SECURITY_LIST';

9297: PROCEDURE add_org_to_security_list(p_security_profile_id in number,
9298: p_organization_id in number)
9299: IS
9300: --
9301: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.ADD_ORG_TO_SECURITY_LIST';
9302: --
9303: p_program_id number;
9304: p_request_id number;
9305: p_program_application_id number;

Line 9350: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_ORG_FROM_SECURITY_LIST';

9346: -- ----------------------------------------------------------------------------
9347: PROCEDURE delete_org_from_security_list(P_Organization_Id in number)
9348: IS
9349: --
9350: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_ORG_FROM_SECURITY_LIST';
9351: begin
9352: hr_utility.set_location('Entering:'|| l_proc, 10);
9353: DELETE FROM PER_ORGANIZATION_LIST
9354: WHERE organization_id = P_Organization_Id;

Line 9369: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.ADD_POS_TO_SECURITY_LIST';

9365: PROCEDURE add_pos_to_security_list(p_security_profile_id in number,
9366: p_position_id in number)
9367: IS
9368: --
9369: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.ADD_POS_TO_SECURITY_LIST';
9370: --
9371: begin
9372: --
9373: insert into per_position_list

Line 9387: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_POS_FROM_SECURITY_LIST';

9383: -- ----------------------------------------------------------------------------
9384: PROCEDURE delete_pos_from_security_list(p_position_Id in number)
9385: IS
9386: --
9387: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_POS_FROM_SECURITY_LIST';
9388: begin
9389: hr_utility.set_location('Entering:'|| l_proc, 10);
9390: DELETE FROM PER_POSITION_LIST
9391: WHERE position_id = p_position_Id;

Line 9403: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PAY_FROM_SECURITY_LIST';

9399: -- ----------------------------------------------------------------------------
9400: PROCEDURE delete_pay_from_security_list(p_payroll_id number)
9401: IS
9402: --
9403: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PAY_FROM_SECURITY_LIST';
9404: begin
9405: hr_utility.set_location('Entering:'|| l_proc, 10);
9406: DELETE FROM PAY_PAYROLL_LIST
9407: WHERE payroll_id = p_payroll_id;

Line 9421: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.POPULATE_ASG_PERF_TABLE';

9417: ,retcode OUT NOCOPY VARCHAR2
9418: ,p_table IN VARCHAR2)
9419: IS
9420: --
9421: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.POPULATE_ASG_PERF_TABLE';
9422: begin
9423: fnd_file.put_line(fnd_file.log,'==========================================');
9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');

Line 9458: END hr_security_internal;

9454: errbuf := errbuf||SQLERRM;
9455: END populate_asg_perf_table;
9456: --
9457:
9458: END hr_security_internal;