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_STATE_TRANSITION_EVENT_PKG dependencies on CSM_STATE_TRANSITIONS_ACC

Line 17: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;

13: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;
14: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_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

Line 23: FROM CSM_STATE_TRANSITIONS_ACC acc

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
24: WHERE acc.USER_ID = p_user_id
25: AND STATE_TRANSITION_ID not in
26: (SELECT STATE_TRANSITION_ID
27: FROM JTF_STATE_TRANSITIONS trn

Line 58: DELETE FROM CSM_STATE_TRANSITIONS_ACC

54: -- Since access_id's are sequence based, we do not need to pass pk values for delete
55: l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE);
56:
57: --delete from ACC
58: DELETE FROM CSM_STATE_TRANSITIONS_ACC
59: WHERE USER_ID = p_user_id
60: AND STATE_TRANSITION_ID = l_state_transition_id;
61:
62: END LOOP;

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 88: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;

84: l_mark_dirty boolean;
85:
86: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;
87: l_last_update_date JTF_STATE_TRANSITIONS.LAST_UPDATE_DATE%TYPE;
88: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;
89: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
90: l_dsql varchar2(2048);
91: l_bind_count NUMBER :=1;
92:

Line 98: CSM_STATE_TRANSITIONS_ACC acc

94:
95: l_dsql :=
96: 'SELECT trn.state_transition_id, trn.last_update_date, acc.ACCESS_ID
97: FROM JTF_STATE_TRANSITIONS trn,
98: CSM_STATE_TRANSITIONS_ACC acc
99: WHERE trn.state_transition_id = acc.state_transition_id
100: AND acc.user_id = :1 AND trn.LAST_UPDATE_DATE > acc.LAST_UPDATE_DATE';
101:
102: IF p_access_id IS NOT NULL THEN

Line 127: UPDATE CSM_STATE_TRANSITIONS_ACC

123: l_access_id, p_user_id,
124: ASG_DOWNLOAD.UPD, sysdate);
125:
126: --update ACC
127: UPDATE CSM_STATE_TRANSITIONS_ACC
128: SET LAST_UPDATE_DATE = l_last_update_date
129: WHERE ACCESS_ID = l_access_id
130: AND USER_ID = p_user_id;
131:

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 164: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;

160:
161: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;
162: l_last_update_date JTF_STATE_TRANSITIONS.LAST_UPDATE_DATE%TYPE;
163: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;
164: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;
165: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
166: l_dsql varchar2(2048);
167: l_bind_count NUMBER :=2;
168: BEGIN

Line 186: FROM CSM_STATE_TRANSITIONS_ACC acc

182: AND srule.STATE_TYPE = ''TASK_STATUS''
183: AND RESPONSIBILITY_ID = :1 ) '
184: || ' AND trn.state_transition_id not in
185: (SELECT state_transition_id
186: FROM CSM_STATE_TRANSITIONS_ACC acc
187: WHERE user_id = :2)';
188:
189: IF p_access_id IS NOT NULL THEN
190: l_dsql := l_dsql || ' AND trn.STATE_TRANSITION_ID = :3';

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 219: INSERT INTO CSM_STATE_TRANSITIONS_ACC(access_id,

215: l_access_id, p_user_id,
216: ASG_DOWNLOAD.INS, sysdate);
217:
218: --insert into ACC
219: INSERT INTO CSM_STATE_TRANSITIONS_ACC(access_id,
220: STATE_TRANSITION_ID, USER_ID, CREATED_BY,
221: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
222: LAST_UPDATE_LOGIN)
223: VALUES (l_access_id, l_state_transition_id, p_user_id, fnd_global.user_id,

Line 236: Refreshes the CSM_STATE_TRANSITIONS_ACC table by comparing with the

232: END Refresh_Acc_Ins;
233:
234:
235: /**
236: Refreshes the CSM_STATE_TRANSITIONS_ACC table by comparing with the
237: backend table for deletes, updates and inserts.
238: Also adds corresponding entries in to SDQ
239:
240: Arguments:

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

Line 268: Refreshes the CSM_STATE_TRANSITIONS_ACC table by comparing with the

264: END;
265:
266:
267: /**
268: Refreshes the CSM_STATE_TRANSITIONS_ACC table by comparing with the
269: backend table for deletes, updates and inserts.
270: Also adds corresponding entries in to SDQ
271:
272: Arguments: