APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on CSM_STATE_TRANSITIONS_ACC_S

Line 81: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE)

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;
85:

Line 155: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE,

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:
159: l_mark_dirty boolean;

Line 208: SELECT CSM.CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;

204: FETCH l_inserts_cur INTO l_state_transition_id, l_last_update_date;
205: EXIT WHEN l_inserts_cur%NOTFOUND;
206:
207: IF p_access_id IS NULL THEN
208: SELECT CSM.CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
209: ELSE
210: l_access_id := p_access_id;
211: END IF;
212:

Line 248: p_access_id CSM_STATE_TRANSITIONS_ACC.state_transition_id%TYPE,

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:
252: BEGIN