eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_GROUP_DOWNLOAD_PUB dependencies on ASG_USER

Line 16: l_owner_id asg_user.owner_id%TYPE := NULL;

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

Line 17: l_rel_owner_id asg_user.owner_id%TYPE := 0;

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;

Line 18: l_rel_user_id asg_user.owner_id%TYPE := 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);

Line 31: FROM asg_user au

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:

Line 39: FROM asg_user au

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:

Line 230: l_owner_id asg_user.owner_id%TYPE := NULL;

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';

Line 231: l_rel_user_id asg_user.user_id%TYPE := NULL;

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

Line 232: l_rel_owner_id asg_user.owner_id%TYPE := 0;

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;

Line 233: l_rel_group_id asg_user.group_id%TYPE := 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);

Line 246: FROM asg_user au

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:

Line 254: FROM asg_user au

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:

Line 464: l_owner_id asg_user.owner_id%TYPE := NULL;

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

Line 473: FROM asg_user au

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: