[Home] [Help]
PACKAGE: APPS.PER_SECURITY_PROFILES_PKG
Source
1 PACKAGE PER_SECURITY_PROFILES_PKG as
2 /* $Header: peser01t.pkh 120.0.12000000.1 2007/01/22 04:22:53 appldev noship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Security_Profile_Id IN OUT NOCOPY NUMBER,
6 X_Business_Group_Id NUMBER,
7 X_Position_Id NUMBER,
8 X_Organization_Id NUMBER,
9 X_Position_Structure_Id NUMBER,
10 X_Organization_Structure_Id NUMBER,
11 X_Include_Top_Org_Flag VARCHAR2,
12 X_Include_Top_Position_Flag VARCHAR2,
13 X_Security_Profile_Name VARCHAR2,
14 X_View_All_Applicants_Flag VARCHAR2,
15 X_View_All_Employees_Flag VARCHAR2,
16 X_View_All_Flag VARCHAR2,
17 X_View_All_Organizations_Flag VARCHAR2,
18 X_View_All_Payrolls_Flag VARCHAR2,
19 X_View_All_Positions_Flag VARCHAR2,
20 X_View_All_Cwk_Flag VARCHAR2,
21 X_View_All_Contacts_Flag VARCHAR2,
22 X_View_All_Candidates_Flag VARCHAR2,
23 X_Include_Exclude_Payroll_Flag VARCHAR2,
24 X_Reporting_Oracle_Username VARCHAR2,
25 X_Allow_Granted_Users_Flag VARCHAR2,
26 X_Restrict_By_Supervisor_Flag VARCHAR2,
27 X_Supervisor_Levels NUMBER,
28 X_Exclude_Secondary_Asgs_Flag VARCHAR2,
29 X_Exclude_Person_Flag VARCHAR2,
30 X_Named_Person_Id NUMBER,
31 X_Custom_Restriction_Flag VARCHAR2,
32 X_Restriction_Text VARCHAR2,
33 X_Exclude_Business_Groups_Flag VARCHAR2,
34 X_Org_Security_Mode VARCHAR2,
35 X_Restrict_On_Individual_Asg VARCHAR2,
36 X_Top_Organization_Method VARCHAR2,
37 X_Top_Position_Method VARCHAR2,
38 X_Request_Id NUMBER,
39 X_Program_Application_Id NUMBER,
40 X_Program_Id NUMBER,
41 X_Program_Update_date DATE
42 );
43
44 PROCEDURE Lock_Row (X_Rowid VARCHAR2,
45 X_Security_Profile_Id NUMBER,
46 X_Business_Group_Id NUMBER,
47 X_Position_Id NUMBER,
48 X_Organization_Id NUMBER,
49 X_Position_Structure_Id NUMBER,
50 X_Organization_Structure_Id NUMBER,
51 X_Include_Top_Org_Flag VARCHAR2,
52 X_Include_Top_Position_Flag VARCHAR2,
53 X_Security_Profile_Name VARCHAR2,
54 X_View_All_Applicants_Flag VARCHAR2,
55 X_View_All_Employees_Flag VARCHAR2,
56 X_View_All_Flag VARCHAR2,
57 X_View_All_Organizations_Flag VARCHAR2,
58 X_View_All_Payrolls_Flag VARCHAR2,
59 X_View_All_Positions_Flag VARCHAR2,
60 X_View_All_Cwk_Flag VARCHAR2,
61 X_View_All_Contacts_Flag VARCHAR2,
62 X_View_All_Candidates_Flag VARCHAR2,
63 X_Include_Exclude_Payroll_Flag VARCHAR2,
64 X_Reporting_Oracle_Username VARCHAR2,
65 X_Allow_Granted_Users_Flag VARCHAR2,
66 X_Restrict_By_Supervisor_Flag VARCHAR2,
67 X_Supervisor_Levels NUMBER,
68 X_Exclude_Secondary_Asgs_Flag VARCHAR2,
69 X_Exclude_Person_Flag VARCHAR2,
70 X_Named_Person_Id NUMBER,
71 X_Custom_Restriction_Flag VARCHAR2,
72 X_Restriction_Text VARCHAR2,
73 X_Exclude_Business_Groups_Flag VARCHAR2,
74 X_Org_Security_Mode VARCHAR2,
75 X_Restrict_On_Individual_Asg VARCHAR2,
76 X_Top_Organization_Method VARCHAR2,
77 X_Top_Position_Method VARCHAR2
78 );
79
80 PROCEDURE Update_Row(X_Rowid VARCHAR2,
81 X_Security_Profile_Id NUMBER,
82 X_Business_Group_Id NUMBER,
83 X_Position_Id NUMBER,
84 X_Organization_Id NUMBER,
85 X_Position_Structure_Id NUMBER,
86 X_Organization_Structure_Id NUMBER,
87 X_Include_Top_Org_Flag VARCHAR2,
88 X_Include_Top_Position_Flag VARCHAR2,
89 X_Security_Profile_Name VARCHAR2,
90 X_View_All_Applicants_Flag VARCHAR2,
91 X_View_All_Employees_Flag VARCHAR2,
92 X_View_All_Flag VARCHAR2,
93 X_View_All_Organizations_Flag VARCHAR2,
94 X_View_All_Payrolls_Flag VARCHAR2,
95 X_View_All_Positions_Flag VARCHAR2,
96 X_View_All_Cwk_Flag VARCHAR2,
97 X_View_All_Contacts_Flag VARCHAR2,
98 X_View_All_Candidates_Flag VARCHAR2,
99 X_Include_Exclude_Payroll_Flag VARCHAR2,
100 X_Reporting_Oracle_Username VARCHAR2,
101 X_Allow_Granted_Users_Flag VARCHAR2,
102 X_Restrict_By_Supervisor_Flag VARCHAR2,
103 X_Supervisor_Levels NUMBER,
104 X_Exclude_Secondary_Asgs_Flag VARCHAR2,
105 X_Exclude_Person_Flag VARCHAR2,
106 X_Named_Person_Id NUMBER,
107 X_Custom_Restriction_Flag VARCHAR2,
108 X_Restriction_Text VARCHAR2,
109 X_Exclude_Business_Groups_Flag VARCHAR2,
110 X_Org_Security_Mode VARCHAR2,
111 X_Restrict_On_Individual_Asg VARCHAR2,
112 X_Top_Organization_Method VARCHAR2,
113 X_Top_Position_Method VARCHAR2,
114 X_Request_Id NUMBER,
115 X_Program_Application_Id NUMBER,
116 X_Program_Id NUMBER,
117 X_Program_Update_Date DATE
118 );
119
120 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
121
122 procedure check_uniqueness(
123 p_security_profile_name varchar2,
124 p_row_id varchar2);
125
126 procedure chk_reporting_username_unique(
127 p_reporting_oracle_username varchar2,
128 p_row_id varchar2,
129 p_is_base_user IN OUT NOCOPY varchar2);
130
131 procedure pre_delete_validation(
132 p_security_profile_id number,
133 p_view_all_flag varchar2,
134 p_secgen_warn IN OUT NOCOPY varchar2);
135
136 function check_sql_fragment(p_restriction_text VARCHAR2)
137 return boolean;
138
139 -- Bug fix 2809163
140 -- ----------------------------------------------------------------------------
141 -- |-------------------< check_assigned_sec_profile >----------------------|
142 -- ----------------------------------------------------------------------------
143 -- {Start Of Comments}
144 --
145 -- Description:
146 -- This procedure will check that, the given security profile id is
147 -- already assigned as any system profile value
148 --
149 -- Prerequisites:
150 -- A valid security profile should be existing
151 --
152 -- In Parameters:
153 -- Name Reqd Type Description
154 -- p_security_profile_id yes number Security profile id to
155 -- be deleted
156 -- Post Success:
157 -- User will be stopped from deleting the security profile which is
158 -- already used as system profile value
159 --
160 -- Post Failure:
161 -- None.
162 --
163 -- Access Status:
164 -- Internal developement use.
165 --
166 -- {End Of Comments}
167 -- ----------------------------------------------------------------------------
168 procedure check_assigned_sec_profile(p_security_profile_id number);
169 --
170
171 END PER_SECURITY_PROFILES_PKG;