APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on CSM_STATE_TRANSITIONS_ACC

Line 13: FROM CSM_STATE_TRANSITIONS_ACC acc

9: l_acc_tab asg_download.access_list;
10:
11: CURSOR l_deletes_cur IS
12: SELECT ACCESS_ID,USER_ID
13: FROM CSM_STATE_TRANSITIONS_ACC acc
14: WHERE acc.USER_ID = p_user_id
15: AND STATE_TRANSITION_ID not in (SELECT STATE_TRANSITION_ID
16: FROM JTF_STATE_TRANSITIONS trn
17: WHERE RULE_ID IN (SELECT sresp.RULE_ID

Line 26: CSM_STATE_TRANSITIONS_ACC acc

22:
23: CURSOR l_updates_cur IS
24: SELECT acc.ACCESS_ID,acc.USER_ID
25: FROM JTF_STATE_TRANSITIONS trn,
26: CSM_STATE_TRANSITIONS_ACC acc
27: WHERE trn.state_transition_id = acc.state_transition_id
28: AND acc.user_id = p_user_id AND trn.LAST_UPDATE_DATE > p_lrd;
29:
30: BEGIN

Line 39: DELETE FROM CSM_STATE_TRANSITIONS_ACC WHERE ACCESS_ID=l_acc_tab(I);

35: CLOSE l_deletes_cur;
36:
37: IF l_acc_tab.COUNT > 0 THEN
38: FORALL I IN 1..l_acc_tab.COUNT
39: DELETE FROM CSM_STATE_TRANSITIONS_ACC WHERE ACCESS_ID=l_acc_tab(I);
40:
41: l_mark_dirty := asg_download.mark_dirty(
42: P_PUB_ITEM => 'CSF_M_STATE_TRANSITIONS'
43: , p_accessList => l_acc_tab

Line 75: SELECT CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL,p_user_id,trn.state_transition_id

71: l_acc_tab asg_download.access_list;
72: l_str_tab asg_download.access_list;
73:
74: CURSOR l_inserts_cur IS
75: SELECT CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL,p_user_id,trn.state_transition_id
76: FROM JTF_STATE_TRANSITIONS trn
77: WHERE trn.RULE_ID IN (SELECT sresp.RULE_ID
78: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
79: WHERE sresp.RULE_ID = srule.RULE_ID

Line 82: AND not exists (SELECT 1 FROM CSM_STATE_TRANSITIONS_ACC acc

78: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
79: WHERE sresp.RULE_ID = srule.RULE_ID
80: AND srule.STATE_TYPE = 'TASK_STATUS'
81: AND RESPONSIBILITY_ID = p_resp_id )
82: AND not exists (SELECT 1 FROM CSM_STATE_TRANSITIONS_ACC acc
83: WHERE user_id = p_user_id
84: AND trn.state_transition_id=acc.state_transition_id);
85:
86: BEGIN

Line 97: INSERT INTO CSM_STATE_TRANSITIONS_ACC(access_id,STATE_TRANSITION_ID, USER_ID, CREATED_BY,

93: RETURN;
94: END IF;
95:
96: FORALL I IN 1..l_acc_tab.COUNT
97: INSERT INTO CSM_STATE_TRANSITIONS_ACC(access_id,STATE_TRANSITION_ID, USER_ID, CREATED_BY,
98: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
99: VALUES (l_acc_tab(I), l_str_tab(I), l_user_tab(I), fnd_global.user_id,
100: sysdate, fnd_global.user_id, sysdate,fnd_global.user_id);
101: