APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on ASG_USER

Line 6: procedure Refresh_Acc_Del (p_user_id asg_user.user_id%TYPE,

2: /* $Header: csmestrb.pls 120.7 2008/02/07 06:52:55 anaraman ship $ */
3:
4: l_no_status_transition_resp EXCEPTION;
5:
6: procedure Refresh_Acc_Del (p_user_id asg_user.user_id%TYPE,
7: p_user_name asg_user.user_name%TYPE,
8: p_resp_id jtf_state_responsibilities.responsibility_id%TYPE)
9: IS
10:

Line 7: p_user_name asg_user.user_name%TYPE,

3:
4: l_no_status_transition_resp EXCEPTION;
5:
6: procedure Refresh_Acc_Del (p_user_id asg_user.user_id%TYPE,
7: p_user_name asg_user.user_name%TYPE,
8: p_resp_id jtf_state_responsibilities.responsibility_id%TYPE)
9: IS
10:
11: l_mark_dirty boolean;

Line 19: CURSOR l_deletes_cur(p_user_id asg_user.user_id%TYPE,

15: l_pkvalueslist asg_download.pk_list;
16: l_null_pkvalueslist asg_download.pk_list;
17: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;
18:
19: CURSOR l_deletes_cur(p_user_id asg_user.user_id%TYPE,
20: p_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE)
21: IS
22: SELECT STATE_TRANSITION_ID, ACCESS_ID
23: FROM CSM_STATE_TRANSITIONS_ACC acc

Line 80: procedure Refresh_Acc_Upd (p_user_id asg_user.user_id%TYPE,

76: p_user_id User_ID of the user for whom to refresh
77: p_access_id: The access_id to be refreshed. If null, then whole ACC table
78: is refreshed
79: */
80: procedure Refresh_Acc_Upd (p_user_id asg_user.user_id%TYPE,
81: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE)
82: IS
83:
84: l_mark_dirty boolean;

Line 153: p_user_id asg_user.user_id%TYPE,

149: p_access_id: The access_id to be refreshed. If null, then whole ACC table
150: is refreshed
151: */
152: procedure Refresh_Acc_Ins (
153: p_user_id asg_user.user_id%TYPE,
154: p_user_name asg_user.user_name%TYPE,
155: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE,
156: p_resp_id jtf_state_responsibilities.responsibility_id%TYPE)
157: IS

Line 154: p_user_name asg_user.user_name%TYPE,

150: is refreshed
151: */
152: procedure Refresh_Acc_Ins (
153: p_user_id asg_user.user_id%TYPE,
154: p_user_name asg_user.user_name%TYPE,
155: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE,
156: p_resp_id jtf_state_responsibilities.responsibility_id%TYPE)
157: IS
158:

Line 246: procedure Refresh_Acc (p_user_id asg_user.user_id%TYPE,

242: for all the users
243: p_access_id: The access_id to be refreshed. If null, then whole ACC table
244: is refreshed
245: */
246: procedure Refresh_Acc (p_user_id asg_user.user_id%TYPE,
247: p_user_name asg_user.user_name%TYPE,
248: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE,
249: p_respid jtf_state_responsibilities.responsibility_id%TYPE)
250: IS

Line 247: p_user_name asg_user.user_name%TYPE,

243: p_access_id: The access_id to be refreshed. If null, then whole ACC table
244: is refreshed
245: */
246: procedure Refresh_Acc (p_user_id asg_user.user_id%TYPE,
247: p_user_name asg_user.user_name%TYPE,
248: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE,
249: p_respid jtf_state_responsibilities.responsibility_id%TYPE)
250: IS
251:

Line 291: FROM asg_user_pub_resps pubresp

287:
288: CURSOR l_omfs_palm_resources_csr is
289: --R12 For multiple responsibility
290: select usr.user_id, usr.user_name
291: FROM asg_user_pub_resps pubresp
292: , asg_user usr
293: WHERE usr.enabled = 'Y'
294: AND pubresp.user_name = usr.user_name
295: AND usr.user_id=usr.owner_id

Line 292: , asg_user usr

288: CURSOR l_omfs_palm_resources_csr is
289: --R12 For multiple responsibility
290: select usr.user_id, usr.user_name
291: FROM asg_user_pub_resps pubresp
292: , asg_user usr
293: WHERE usr.enabled = 'Y'
294: AND pubresp.user_name = usr.user_name
295: AND usr.user_id=usr.owner_id
296: AND pubresp.pub_name ='SERVICEP';