APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on JTF_STATE_RESPONSIBILITIES

Line 8: p_resp_id jtf_state_responsibilities.responsibility_id%TYPE)

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

Line 13: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;

9: IS
10:
11: l_mark_dirty boolean;
12:
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;

Line 20: p_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE)

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
24: WHERE acc.USER_ID = p_user_id

Line 30: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule

26: (SELECT STATE_TRANSITION_ID
27: FROM JTF_STATE_TRANSITIONS trn
28: WHERE RULE_ID IN
29: (SELECT sresp.RULE_ID
30: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
31: WHERE RESPONSIBILITY_ID = p_responsibility_id
32: AND sresp.RULE_ID = srule.RULE_ID
33: AND srule.STATE_TYPE = 'TASK_STATUS' -- IN ('TASK_STATUS', 'SR_STATUS') AND APPLICATION_ID IN (513, 170)
34: )

Line 156: p_resp_id jtf_state_responsibilities.responsibility_id%TYPE)

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

Line 163: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;

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

Line 180: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule

176: 'SELECT trn.state_transition_id, trn.last_update_date
177: FROM JTF_STATE_TRANSITIONS trn
178: WHERE trn.RULE_ID IN
179: (SELECT sresp.RULE_ID
180: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
181: WHERE sresp.RULE_ID = srule.RULE_ID
182: AND srule.STATE_TYPE = ''TASK_STATUS''
183: AND RESPONSIBILITY_ID = :1 ) '
184: || ' AND trn.state_transition_id not in

Line 249: p_respid jtf_state_responsibilities.responsibility_id%TYPE)

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
253:

Line 284: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;

280: IS
281: PRAGMA AUTONOMOUS_TRANSACTION;
282: l_sqlerrno varchar2(20);
283: l_sqlerrmsg varchar2(2000);
284: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;
285: l_run_date DATE;
286: l_user_id NUMBER;
287:
288: CURSOR l_omfs_palm_resources_csr is