1 Package HR_SECURITY_ORGANIZATION_API as
2 /* $Header: pepsoapi.pkh 120.2.12010000.2 2008/08/06 09:30:10 ubhat ship $ */
3 /*#
4 * This package contains apis for organization level security maintenance.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Organization Security
8 */
9 -- ----------------------------------------------------------------------------
10 -- |-------------------< create_security_organization >-----------------------|
11 -- ----------------------------------------------------------------------------
12 --
13 -- {Start Of Comments}
14 /*#
15 * This API is used to include or exclude an organization from a security
16 * Profile.
17 *
18 * <p><b>Licensing</b><br>
19 * This API is licensed for use with Human Resources.
20 *
21 * <p><b>Prerequisites</b><br>
22 * The security profile id and organization id must already exist.
23 *
24 * <p><b>Post Success</b><br>
25 * Includes or Excludes the organization .
26 *
27 * <p><b>Post Failure</b><br>
28 * The API doesn't include or exclude an organization from the security
29 * Profile.
30 *
31 * @param p_validate If true, then validation alone will be performed and
32 * the database will remain unchanged. If false and all validation checks pass,
33 * then the database will be modified.
34 * @param p_security_profile_id Security profile id.
35 * @param p_organization_id Organization id.
36 * @param p_entry_type If entry type is I, then the organization is included
37 * into the security profile. If E then the organization will be excluded
38 * from the security profile.
39 * @param p_security_organization_id Security Organization id.
40 * @param p_object_version_number If p_validate is false, then set to the
41 * version number of the security organization created. If p_validate is true,
42 * then set to null.
43 * @rep:displayname Create Organization Security
44 * @rep:category BUSINESS_ENTITY PER_SECURITY_PROFILE
45 * @rep:lifecycle active
46 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
47 * @rep:scope public
48 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
49 */
50 --
51 -- {End Of Comments}
52 --
53 --
54 procedure create_security_organization
55 ( p_validate in boolean default false
56 , p_security_profile_id in number
57 , p_organization_id in number
58 , p_entry_type in varchar2
59 , p_security_organization_id out nocopy number
60 , p_object_version_number out nocopy number
61 );
62 --
63 -- ----------------------------------------------------------------------------
64 -- |-----------------< update_security_organization >-------------------------|
65 -- ----------------------------------------------------------------------------
66 --
67 -- {Start Of Comments}
68 /*#
69 * This API updates the organization security.
70 *
71 * <p><b>Licensing</b><br>
72 * This API is licensed for use with Human Resources.
73 *
74 * <p><b>Prerequisites</b><br>
75 * The security profile id,security organization id and organization id
76 * must already exist.
77 *
78 * <p><b>Post Success</b><br>
79 * Updates the organization security
80 *
81 * <p><b>Post Failure</b><br>
82 * The API doesn't update the organization security.
83 *
84 * @param p_validate If true, then validation alone will be performed and
85 * the database will remain unchanged. If false and all validation checks pass,
86 * then the database will be modified.
87 * @param p_security_profile_id Security profile id.
88 * @param p_organization_id Organization id.
89 * @param p_entry_type If entry type is I, then the organization is included
90 * into the security profile .If E then the organization will be excluded
91 * from the security profile.
92 * @param p_security_organization_id Security organization id.
93 * @param p_object_version_number If p_validate is false, then set to the
94 * version number of the security organization updated. If p_validate is true,
95 * then set to null.
96 * @rep:displayname Update Organization Security
97 * @rep:category BUSINESS_ENTITY PER_SECURITY_PROFILE
98 * @rep:lifecycle active
99 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
100 * @rep:scope public
101 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
102 */
103 --
104 -- {End Of Comments}
105 --
106 --
107
108 procedure update_security_organization
109 (
110 p_validate in boolean default false
111 , p_security_profile_id in number default hr_api.g_number
112 , p_organization_id in number default hr_api.g_number
113 , p_entry_type in varchar2 default hr_api.g_varchar2
114 , p_security_organization_id in number
115 , p_object_version_number in out nocopy number
116 );
117 --
118 -- ----------------------------------------------------------------------------
119 -- |-----------------< delete_security_organization >-------------------------|
120 -- ----------------------------------------------------------------------------
121 --
122 -- {Start Of Comments}
123 /*#
124 * This API deletes the organization security.
125 *
126 * <p><b>Licensing</b><br>
127 * This API is licensed for use with Human Resources.
128 *
129 * <p><b>Prerequisites</b><br>
130 * Security organization id must already exist.
131 *
132 * <p><b>Post Success</b><br>
133 * Deletes the organization from the security profile.
134 *
135 * <p><b>Post Failure</b><br>
136 * Doesn't delete the organization from the security profile.
137 *
138 * @param p_validate If true, then validation alone will be performed and
139 * the database will remain unchanged. If false and all validation checks pass,
140 * then the database will be modified.
141 * @param p_security_organization_id Security organization id
142 * @param p_object_version_number If p_validate is false, then set to the
143 * version number of the security organization deleted. If p_validate is true,
144 * then set to null.
145 * @rep:displayname Delete Organization Security
146 * @rep:category BUSINESS_ENTITY PER_SECURITY_PROFILE
147 * @rep:lifecycle active
148 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
149 * @rep:scope public
150 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
151 */
152 --
153 -- {End Of Comments}
154 --
155
156 procedure delete_security_organization
157 (
158 p_validate in boolean default false
159 , p_security_organization_id in number
160 , p_object_version_number in number
161 );
162 --
163 end HR_SECURITY_ORGANIZATION_API;