1 Package per_sec_profile_asg_api AUTHID CURRENT_USER as
2 /* $Header: peaspapi.pkh 115.1 2003/09/16 01:13 vkonda noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< create_security_profile_asg >---------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Assigns security profiles for an assignment.
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate No Boolean Assigns a security profile to
18 -- an assignment if the value is
19 -- true.
20 -- p_user_id Yes Number user id for which the security
21 -- profile is attached.
22 -- p_security_group_id Yes Number The security group of the
23 -- responsibility
24 -- p_business_group_id Yes Number Business group id
25 -- p_security_profile_id Yes Number id of the security profile
26 -- being attached.
27 -- p_responsibility_id Yes Number Responsibility for which the
28 -- profile is being set.
29 -- p_responsibility_application_i Yes Number Application id of the
30 -- responsibility.
31 -- p_start_date Yes Date Start date of the assignment
32 -- p_end_date Yes Date End date of the assignment
33 --
34 -- Post Success:
35 -- A security profile is attached to an user / responsibility .
36
37 -- Out Parameters:
38 -- Name Type Description
39 -- p_sec_profile_assignment_id Number Id of the row created for the
40 -- new assignment.
41 -- p_object_version_number Number Object version number of the row
42 -- created.
43 -- Post Failure:
44 -- Security profile is not assigned and raises an application error.
45 --
46 -- Access Status:
47 -- Public.
48 --
49 -- {End Of Comments}
50 --
51 procedure create_security_profile_asg
52 (p_validate in boolean default false,
53 p_sec_profile_assignment_id out nocopy number,
54 p_user_id in number,
55 p_security_group_id in number,
56 p_business_group_id in number,
57 p_security_profile_id in number,
58 p_responsibility_id in number,
59 p_responsibility_application_i in number,
60 p_start_date in date,
61 p_end_date in date default null,
62 p_object_version_number out nocopy number
63 );
64
65 --
66 -- ----------------------------------------------------------------------------
67 -- |-----------------------< update_security_profile_asg >---------------------|
68 -- ----------------------------------------------------------------------------
69 -- {Start Of Comments}
70 --
71 -- Description:
72 -- Assigns security profiles for an assignment.
73 --
74 -- Prerequisites:
75 --
76 --
77 -- In Parameters:
78 -- Name Reqd Type Description
79 -- p_validate No Boolean updates an assignment of the
80 -- security profile if the value is
81 -- true.
82 -- p_sec_profile_assignment_id Yes Number Id of the assignment being updated.
83 -- p_start_date Yes Date Start date of the assignment
84 -- p_end_date Yes Date End date of the assignment
85 --
86 -- Post Success:
87 -- A security profile attached to an user / responsibility is updated.
88
89 -- Out Parameters:
90 -- Name Type Description
91 -- p_object_version_number Number Object version number of the
92 -- updated assignment.
93 -- Post Failure:
94 -- Security profile is not updated and raises an application error.
95 --
96 -- Access Status:
97 -- Public.
98 --
99 -- {End Of Comments}
100 --
101 procedure update_security_profile_asg
102 (p_validate in boolean default false,
103 p_sec_profile_assignment_id in number,
104 p_user_id in number,
105 p_security_group_id in number,
106 p_business_group_id in number,
110 p_start_date in date,
107 p_security_profile_id in number,
108 p_responsibility_id in number,
109 p_responsibility_application_i in number,
111 p_end_date in date,
115
112 p_object_version_number in out nocopy number
113 );
114 --
116 end per_sec_profile_asg_api;