APPS.FND_SECURITY_GROUPS_API dependencies on FND_SECURITY_GROUPS

Line 1: package body Fnd_Security_Groups_Api as

1: package body Fnd_Security_Groups_Api as
2: /* $Header: AFSCGPAB.pls 115.4 99/07/16 23:28:29 porting sh $ */
3:
4: --
5: -- Generic_Error (Internal)

Line 38: from FND_SECURITY_GROUPS

34: dummy number;
35: begin
36: select count(1)
37: into dummy
38: from FND_SECURITY_GROUPS
39: where SECURITY_GROUP_ID = Id_Exists.security_group_id;
40:
41: return(TRUE);
42: exception

Line 46: Generic_Error('FND_SECURITY_GROUPS_API.ID_EXISTS',

42: exception
43: when no_data_found then
44: return(FALSE);
45: when others then
46: Generic_Error('FND_SECURITY_GROUPS_API.ID_EXISTS',
47: sqlcode, sqlerrm);
48: end Id_Exists;
49:
50: --

Line 66: from FND_SECURITY_GROUPS

62: dummy number;
63: begin
64: select 1
65: into dummy
66: from FND_SECURITY_GROUPS
67: where SECURITY_GROUP_KEY = Key_Exists.security_group_key;
68:
69: return(TRUE);
70: exception

Line 74: Generic_Error('FND_SECURITY_GROUPS_API.KEY_EXISTS',

70: exception
71: when no_data_found then
72: return(FALSE);
73: when others then
74: Generic_Error('FND_SECURITY_GROUPS_API.KEY_EXISTS',
75: sqlcode, sqlerrm);
76: end Key_Exists;
77:
78: --

Line 94: from FND_SECURITY_GROUPS_VL

90: dummy number;
91: begin
92: select 1
93: into dummy
94: from FND_SECURITY_GROUPS_VL
95: where SECURITY_GROUP_NAME = Name_Exists.security_group_name;
96:
97: return(TRUE);
98: exception

Line 102: Generic_Error('FND_SECURITY_GROUPS_API.NAME_EXISTS',

98: exception
99: when no_data_found then
100: return(FALSE);
101: when others then
102: Generic_Error('FND_SECURITY_GROUPS_API.NAME_EXISTS',
103: sqlcode, sqlerrm);
104: end Name_Exists;
105:
106: --

Line 127: select FND_SECURITY_GROUPS_S.NEXTVAL

123: security_group_id number;
124: row_id varchar2(64);
125: begin
126: -- Pull of a new id from sequence
127: select FND_SECURITY_GROUPS_S.NEXTVAL
128: into security_group_id
129: from SYS.DUAL;
130:
131: -- Insert new row in security groups

Line 132: Fnd_Security_Groups_Pkg.Insert_Row(

128: into security_group_id
129: from SYS.DUAL;
130:
131: -- Insert new row in security groups
132: Fnd_Security_Groups_Pkg.Insert_Row(
133: row_id,
134: security_group_id,
135: security_group_key,
136: security_group_name,

Line 147: Generic_Error('FND_SECURITY_GROUPS_API.CREATE_GROUP',

143:
144: return security_group_id;
145: exception
146: when others then
147: Generic_Error('FND_SECURITY_GROUPS_API.CREATE_GROUP',
148: sqlcode, sqlerrm);
149: end Create_Group;
150:
151: --

Line 170: from FND_SECURITY_GROUPS FSG

166: -- Get id of group.
167: -- Allow no_data_found error to trickle up.
168: select FSG.SECURITY_GROUP_ID
169: into security_group_id
170: from FND_SECURITY_GROUPS FSG
171: where FSG.SECURITY_GROUP_KEY = Update_Group.security_group_key;
172:
173: Fnd_Security_Groups_Pkg.Update_Row(
174: security_group_id,

Line 173: Fnd_Security_Groups_Pkg.Update_Row(

169: into security_group_id
170: from FND_SECURITY_GROUPS FSG
171: where FSG.SECURITY_GROUP_KEY = Update_Group.security_group_key;
172:
173: Fnd_Security_Groups_Pkg.Update_Row(
174: security_group_id,
175: security_group_key,
176: security_group_name,
177: description,

Line 183: Generic_Error('FND_SECURITY_GROUPS_API.UPDATE_GROUP',

179: Fnd_Global.User_Id,
180: Fnd_Global.Login_Id);
181: exception
182: when others then
183: Generic_Error('FND_SECURITY_GROUPS_API.UPDATE_GROUP',
184: sqlcode, sqlerrm);
185: end Update_Group;
186:
187: end Fnd_Security_Groups_Api;

Line 187: end Fnd_Security_Groups_Api;

183: Generic_Error('FND_SECURITY_GROUPS_API.UPDATE_GROUP',
184: sqlcode, sqlerrm);
185: end Update_Group;
186:
187: end Fnd_Security_Groups_Api;