APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on JTF_STATE_TRANSITIONS

Line 14: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;

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

Line 27: FROM JTF_STATE_TRANSITIONS trn

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

Line 86: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;

82: IS
83:
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);

Line 87: l_last_update_date JTF_STATE_TRANSITIONS.LAST_UPDATE_DATE%TYPE;

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

Line 97: FROM JTF_STATE_TRANSITIONS trn,

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

Line 161: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;

157: IS
158:
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;

Line 162: l_last_update_date JTF_STATE_TRANSITIONS.LAST_UPDATE_DATE%TYPE;

158:
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);

Line 177: FROM JTF_STATE_TRANSITIONS trn

173: RAISE l_no_status_transition_resp;
174: END IF;
175: l_dsql :=
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