APPS.CSM_USER_EVENT_PKG dependencies on ASG_USER

Line 25: FROM asg_user_pub_resps aupr,

21:
22: CURSOR l_responsibilities_csr (p_resp_id NUMBER, l_user_id IN NUMBER)
23: IS
24: SELECT 1 --R12-Multiple Responsibility
25: FROM asg_user_pub_resps aupr,
26: asg_user asu
27: WHERE aupr.user_name = asu.user_name
28: AND aupr.responsibility_id = p_resp_id
29: AND asu.user_id = l_user_id

Line 26: asg_user asu

22: CURSOR l_responsibilities_csr (p_resp_id NUMBER, l_user_id IN NUMBER)
23: IS
24: SELECT 1 --R12-Multiple Responsibility
25: FROM asg_user_pub_resps aupr,
26: asg_user asu
27: WHERE aupr.user_name = asu.user_name
28: AND aupr.responsibility_id = p_resp_id
29: AND asu.user_id = l_user_id
30: AND aupr.pub_name = 'SERVICEP';

Line 96: FROM asg_user au,

92:
93: CURSOR l_user_csr (p_user_id NUMBER)
94: IS
95: SELECT au.user_id
96: FROM asg_user au,
97: asg_user_pub_resps asg_resp
98: WHERE au.user_id <> p_user_id
99: AND au.enabled = 'Y'
100: AND asg_resp.pub_name = 'SERVICEP'

Line 97: asg_user_pub_resps asg_resp

93: CURSOR l_user_csr (p_user_id NUMBER)
94: IS
95: SELECT au.user_id
96: FROM asg_user au,
97: asg_user_pub_resps asg_resp
98: WHERE au.user_id <> p_user_id
99: AND au.enabled = 'Y'
100: AND asg_resp.pub_name = 'SERVICEP'
101: AND asg_resp.user_name = au.user_name;

Line 286: FROM ASG_USER

282:
283: CURSOR c_get_group(b_user_id NUMBER)
284: IS
285: SELECT GROUP_ID,USER_ID
286: FROM ASG_USER
287: WHERE USER_ID=b_user_id
288: AND USER_ID=OWNER_ID;
289:
290: l_group_id NUMBER;

Line 495: asg_user au

491: FROM po_location_associations_all pla,
492: hz_cust_site_uses_all csu,
493: hz_cust_acct_sites_all cas,
494: csp_rs_cust_relations rcr,
495: asg_user au
496: WHERE csu.site_use_id = pla.site_use_id
497: AND csu.site_use_code = 'SHIP_TO'
498: AND csu.cust_acct_site_id = cas.cust_acct_site_id
499: AND csu.status = 'A'

Line 555: asg_user au

551: SELECT hdr.requirement_header_id,
552: au.resource_id,
553: au.user_id
554: FROM csp_requirement_headers hdr,
555: asg_user au
556: WHERE hdr.resource_id = au.resource_id
557: AND au.resource_id = p_resource_id
558: AND NOT EXISTS
559: (SELECT 1

Line 605: asg_user au

601: line.requirement_line_id,
602: au.user_id
603: FROM csp_requirement_headers hdr,
604: csp_requirement_lines line,
605: asg_user au
606: WHERE hdr.requirement_header_id = line.requirement_header_id
607: AND hdr.resource_id = au.resource_id
608: AND au.resource_id = p_resource_id
609: AND NOT EXISTS

Line 697: FROM asg_user

693:
694: CURSOR l_get_resource_id_csr(p_user_id IN NUMBER)
695: is
696: SELECT user_name,resource_id, NVL(multi_platform,'N')
697: FROM asg_user
698: WHERE user_id = p_user_id;
699:
700: BEGIN
701: CSM_UTIL_PKG.LOG('Entering USER_RESP_INS_INITIALIZER for user_id:' || p_user_id,

Line 1048: CURSOR c_asg_user(l_user_id NUMBER)

1044: l_tab_owner_id asg_download.user_list;
1045: l_tab_access_id asg_download.access_list;
1046: g_pub_item varchar2(30) := 'CSF_M_USER';
1047:
1048: CURSOR c_asg_user(l_user_id NUMBER)
1049: IS
1050: SELECT USER_ID,OWNER_ID,GROUP_ID
1051: FROM
1052: ASG_USER

Line 1052: ASG_USER

1048: CURSOR c_asg_user(l_user_id NUMBER)
1049: IS
1050: SELECT USER_ID,OWNER_ID,GROUP_ID
1051: FROM
1052: ASG_USER
1053: WHERE USER_ID=l_user_id;
1054:
1055: CURSOR c_user_acc(l_user_id NUMBER)
1056: IS

Line 1065: FROM ASG_USER USR,

1061:
1062: CURSOR c_group_users(l_owner_id NUMBER)
1063: IS
1064: SELECT USR.USER_ID,USR.OWNER_ID,ACC.ACCESS_ID
1065: FROM ASG_USER USR,
1066: CSM_USER_ACC ACC
1067: WHERE USR.OWNER_ID=l_owner_id
1068: AND USR.USER_ID = ACC.USER_ID;
1069:

Line 1073: OPEN c_asg_user(p_user_id);

1069:
1070: BEGIN
1071: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1072: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1073: OPEN c_asg_user(p_user_id);
1074: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1075: CLOSE c_asg_user;
1076:
1077: OPEN c_user_acc(p_user_id);

Line 1074: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;

1070: BEGIN
1071: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1072: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1073: OPEN c_asg_user(p_user_id);
1074: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1075: CLOSE c_asg_user;
1076:
1077: OPEN c_user_acc(p_user_id);
1078: FETCH c_user_acc INTO l_user_id;

Line 1075: CLOSE c_asg_user;

1071: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1072: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1073: OPEN c_asg_user(p_user_id);
1074: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1075: CLOSE c_asg_user;
1076:
1077: OPEN c_user_acc(p_user_id);
1078: FETCH c_user_acc INTO l_user_id;
1079: IF c_user_acc%FOUND THEN