DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on WF_LOCAL_USER_ROLES

Line 171: p_user_name IN wf_local_user_roles.user_name%TYPE,

167:
168: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

Line 172: p_role_name IN wf_local_user_roles.role_name%TYPE,

168: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

Line 173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,

169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,

Line 174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,

170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,
178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

Line 175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,
178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
179: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

Line 176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,
178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
179: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
180: x_return_status OUT NOCOPY VARCHAR2,

Line 177: p_start_date IN wf_local_user_roles.start_date%TYPE,

173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,
178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
179: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_return_message OUT NOCOPY VARCHAR2

Line 178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,
178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
179: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_return_message OUT NOCOPY VARCHAR2
182: );

Line 179: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

175: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
176: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
177: p_start_date IN wf_local_user_roles.start_date%TYPE,
178: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
179: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_return_message OUT NOCOPY VARCHAR2
182: );
183:

Line 210: p_user_name IN wf_local_user_roles.user_name%TYPE,

206:
207: PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

Line 211: p_role_name IN wf_local_user_roles.role_name%TYPE,

207: PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

Line 212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,

208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,

Line 213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,

209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,
217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

Line 214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,
217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
218: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

Line 215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,
217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
218: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,

Line 216: p_start_date IN wf_local_user_roles.start_date%TYPE,

212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,
217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
218: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_return_message OUT NOCOPY VARCHAR2

Line 217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,
217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
218: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_return_message OUT NOCOPY VARCHAR2
221: );

Line 218: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

214: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
215: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
216: p_start_date IN wf_local_user_roles.start_date%TYPE,
217: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
218: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_return_message OUT NOCOPY VARCHAR2
221: );
222: