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,
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,
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,
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,
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,
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,
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
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: );
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:
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,
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,
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,
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,
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,
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,
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
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: );
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: