12: x_error_message OUT NOCOPY VARCHAR2
13: )
14: IS
15:
16: l_owner_id asg_user.owner_id%TYPE := NULL;
17: l_rel_owner_id asg_user.owner_id%TYPE := 0;
18: l_rel_user_id asg_user.owner_id%TYPE := NULL;
19: l_rel_grp_type VARCHAR2(1) := 'R';
20: l_return_status VARCHAR2(3000);
13: )
14: IS
15:
16: l_owner_id asg_user.owner_id%TYPE := NULL;
17: l_rel_owner_id asg_user.owner_id%TYPE := 0;
18: l_rel_user_id asg_user.owner_id%TYPE := NULL;
19: l_rel_grp_type VARCHAR2(1) := 'R';
20: l_return_status VARCHAR2(3000);
21: l_error_message VARCHAR2(3000) := NULL;
14: IS
15:
16: l_owner_id asg_user.owner_id%TYPE := NULL;
17: l_rel_owner_id asg_user.owner_id%TYPE := 0;
18: l_rel_user_id asg_user.owner_id%TYPE := NULL;
19: l_rel_grp_type VARCHAR2(1) := 'R';
20: l_return_status VARCHAR2(3000);
21: l_error_message VARCHAR2(3000) := NULL;
22: l_rel_return_status VARCHAR2(3000);
27:
28: CURSOR csr_grp_owner_id(p_group_id IN NUMBER)
29: IS
30: SELECT au.owner_id
31: FROM asg_user au
32: WHERE au.group_id = p_group_id
33: AND au.user_id = au.owner_id
34: AND au.enabled = 'Y';
35:
35:
36: CURSOR csr_rel_grp(p_related_group_id IN NUMBER)
37: IS
38: SELECT au.owner_id
39: FROM asg_user au
40: WHERE au.group_id = p_related_group_id
41: AND au.user_id = au.owner_id
42: AND au.enabled = 'Y';
43:
226: )
227: IS
228:
229: l_rel_group_id_tbl l_group_id_tbl_type;
230: l_owner_id asg_user.owner_id%TYPE := NULL;
231: l_rel_user_id asg_user.user_id%TYPE := NULL;
232: l_rel_owner_id asg_user.owner_id%TYPE := 0;
233: l_rel_group_id asg_user.group_id%TYPE := NULL;
234: l_rel_grp_type VARCHAR2(1) := 'R';
227: IS
228:
229: l_rel_group_id_tbl l_group_id_tbl_type;
230: l_owner_id asg_user.owner_id%TYPE := NULL;
231: l_rel_user_id asg_user.user_id%TYPE := NULL;
232: l_rel_owner_id asg_user.owner_id%TYPE := 0;
233: l_rel_group_id asg_user.group_id%TYPE := NULL;
234: l_rel_grp_type VARCHAR2(1) := 'R';
235: l_return_status VARCHAR2(3000);
228:
229: l_rel_group_id_tbl l_group_id_tbl_type;
230: l_owner_id asg_user.owner_id%TYPE := NULL;
231: l_rel_user_id asg_user.user_id%TYPE := NULL;
232: l_rel_owner_id asg_user.owner_id%TYPE := 0;
233: l_rel_group_id asg_user.group_id%TYPE := NULL;
234: l_rel_grp_type VARCHAR2(1) := 'R';
235: l_return_status VARCHAR2(3000);
236: l_error_message VARCHAR2(3000) := NULL;
229: l_rel_group_id_tbl l_group_id_tbl_type;
230: l_owner_id asg_user.owner_id%TYPE := NULL;
231: l_rel_user_id asg_user.user_id%TYPE := NULL;
232: l_rel_owner_id asg_user.owner_id%TYPE := 0;
233: l_rel_group_id asg_user.group_id%TYPE := NULL;
234: l_rel_grp_type VARCHAR2(1) := 'R';
235: l_return_status VARCHAR2(3000);
236: l_error_message VARCHAR2(3000) := NULL;
237: l_rel_return_status VARCHAR2(3000);
242:
243: CURSOR csr_grp_owner_id(p_group_id IN NUMBER)
244: IS
245: SELECT au.owner_id
246: FROM asg_user au
247: WHERE au.group_id = p_group_id
248: AND au.user_id = au.owner_id
249: AND au.enabled = 'Y';
250:
250:
251: CURSOR csr_rel_grp(p_group_id IN NUMBER)
252: IS
253: SELECT au.owner_id
254: FROM asg_user au
255: WHERE au.group_id = p_group_id
256: AND au.user_id = au.owner_id
257: AND au.enabled = 'Y';
258:
460:
461: IS
462:
463: l_rel_group_id_tbl l_group_id_tbl_type;
464: l_owner_id asg_user.owner_id%TYPE := NULL;
465: l_msg_data VARCHAR2(3000);
466: l_sqlerrmsg VARCHAR2(3000);
467: l_sqlerrno VARCHAR2(20);
468: l_error_message VARCHAR2(3000);
469:
470: CURSOR csr_get_owner_id (p_group_id IN NUMBER)
471: IS
472: SELECT au.owner_id
473: FROM asg_user au
474: WHERE au.group_id = p_group_id
475: AND au.user_id = au.owner_id
476: AND au.enabled = 'Y';
477: