1 package FND_SECURITY_GROUPS_PKG as
2 /* $Header: AFSCGRPS.pls 120.3 2006/02/13 01:50:20 stadepal ship $ */
3 /*#
4 * Table Handler to insert or update data in FND_SECURITY_GROUPS table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Security Group
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_USER
11 */
12
13
14 procedure INSERT_ROW (
15 X_ROWID in out nocopy VARCHAR2,
16 X_SECURITY_GROUP_ID in NUMBER,
17 X_SECURITY_GROUP_KEY in VARCHAR2,
18 X_SECURITY_GROUP_NAME in VARCHAR2,
19 X_DESCRIPTION in VARCHAR2,
20 X_CREATION_DATE in DATE,
21 X_CREATED_BY in NUMBER,
22 X_LAST_UPDATE_DATE in DATE,
23 X_LAST_UPDATED_BY in NUMBER,
24 X_LAST_UPDATE_LOGIN in NUMBER);
25
26 procedure LOCK_ROW (
27 X_SECURITY_GROUP_ID in NUMBER,
28 X_SECURITY_GROUP_KEY in VARCHAR2,
29 X_SECURITY_GROUP_NAME in VARCHAR2,
30 X_DESCRIPTION in VARCHAR2);
31
32 /*#
33 * Updates Security Group data -- Security_Group_Name & Description and also
34 * calls fnd_user_resp_groups_api.sync_roles_all_resps api if there's a
35 * change in Security_Group_name to update the security group name in the
36 * display name of all the roles for this security group key.
37 * @param x_security_group_id Security Group Id, Primary Key of the table
38 * @param x_security_group_key Security Group Key, Unique Key of the table
39 * @param x_security_group_name Security Group Name
40 * @param x_description Description
41 * @param x_last_update_date Date on which record is updated
42 * @param x_last_updated_by User_Id of the User that has updated the record
43 * @param x_last_update_login Last Update Login
44 * @rep:scope public
45 * @rep:lifecycle active
46 * @rep:displayname Update Security Group
47 * @rep:compatibility S
48 */
49 procedure UPDATE_ROW (
50 X_SECURITY_GROUP_ID in NUMBER,
51 X_SECURITY_GROUP_KEY in VARCHAR2,
52 X_SECURITY_GROUP_NAME in VARCHAR2,
53 X_DESCRIPTION in VARCHAR2,
54 X_LAST_UPDATE_DATE in DATE,
55 X_LAST_UPDATED_BY in NUMBER,
56 X_LAST_UPDATE_LOGIN in NUMBER);
57
58 procedure LOAD_ROW (
59 X_SECURITY_GROUP_KEY in VARCHAR2,
60 X_OWNER in VARCHAR2,
61 X_SECURITY_GROUP_NAME in VARCHAR2,
62 X_DESCRIPTION in VARCHAR2);
63
64 procedure TRANSLATE_ROW (
65 X_SECURITY_GROUP_KEY in VARCHAR2,
66 X_OWNER in VARCHAR2,
67 X_SECURITY_GROUP_NAME in VARCHAR2,
68 X_DESCRIPTION in VARCHAR2);
69
70 procedure DELETE_ROW (
71 X_SECURITY_GROUP_ID in NUMBER);
72
73 procedure ADD_LANGUAGE;
74
75 -- Overloaded Routines!!
76
77 /*#
78 * Creates or updates Security Group data as appropriate.
79 * @param x_security_group_key Security Group Key
80 * @param x_owner Owner Name
81 * @param x_security_group_name Security Group Name
82 * @param x_description Description
83 * @param x_custom_mode Custom Mode
84 * @param x_last_update_date Insert/Update Date
85 * @rep:scope public
86 * @rep:lifecycle active
87 * @rep:displayname Create/Update Security Group
88 * @rep:compatibility S
89 */
90 procedure LOAD_ROW (
91 X_SECURITY_GROUP_KEY in VARCHAR2,
92 X_OWNER in VARCHAR2,
93 X_SECURITY_GROUP_NAME in VARCHAR2,
94 X_DESCRIPTION in VARCHAR2,
95 X_CUSTOM_MODE in VARCHAR2,
96 X_LAST_UPDATE_DATE in VARCHAR2);
97
98 procedure TRANSLATE_ROW (
99 X_SECURITY_GROUP_KEY in VARCHAR2,
100 X_OWNER in VARCHAR2,
101 X_SECURITY_GROUP_NAME in VARCHAR2,
102 X_DESCRIPTION in VARCHAR2,
103 X_CUSTOM_MODE in VARCHAR2,
104 X_LAST_UPDATE_DATE in VARCHAR2);
105
106 end FND_SECURITY_GROUPS_PKG;