APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 15: l_pkvalueslist asg_download.pk_list;

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:
19: CURSOR l_deletes_cur(p_user_id asg_user.user_id%TYPE,

Line 16: l_null_pkvalueslist asg_download.pk_list;

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:
19: CURSOR l_deletes_cur(p_user_id asg_user.user_id%TYPE,
20: p_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE)

Line 53: -- l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE, l_pkvalueslist);

49: l_pkvalueslist(1) := l_state_transition_id;
50:
51: --mark dirty the SDQ
52: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
53: -- l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE, l_pkvalueslist);
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

Line 55: l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE);

51: --mark dirty the SDQ
52: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
53: -- l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE, l_pkvalueslist);
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

Line 124: ASG_DOWNLOAD.UPD, sysdate);

120:
121: --mark dirty the SDQ
122: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
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

Line 216: ASG_DOWNLOAD.INS, sysdate);

212:
213: --mark dirty the SDQ
214: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
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,