APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 8: l_user_tab asg_download.user_list;

4: procedure Refresh_Acc_upd_Del (p_user_id NUMBER, p_resp_id NUMBER,p_lrd DATE)
5: IS
6:
7: l_mark_dirty boolean;
8: l_user_tab asg_download.user_list;
9: l_acc_tab asg_download.access_list;
10:
11: CURSOR l_deletes_cur IS
12: SELECT ACCESS_ID,USER_ID

Line 9: l_acc_tab asg_download.access_list;

5: IS
6:
7: l_mark_dirty boolean;
8: l_user_tab asg_download.user_list;
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

Line 41: l_mark_dirty := asg_download.mark_dirty(

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
44: , p_userid_list => l_user_tab
45: , p_dml_type => 'D'

Line 55: l_mark_dirty := asg_download.mark_dirty(

51: FETCH l_updates_cur BULK COLLECT INTO l_acc_tab,l_user_tab;
52: CLOSE l_updates_cur;
53:
54: IF l_acc_tab.COUNT > 0 THEN
55: l_mark_dirty := asg_download.mark_dirty(
56: P_PUB_ITEM => 'CSF_M_STATE_TRANSITIONS'
57: , p_accessList => l_acc_tab
58: , p_userid_list => l_user_tab
59: , p_dml_type => 'U'

Line 70: l_user_tab asg_download.user_list;

66: IS
67:
68: l_mark_dirty boolean;
69:
70: l_user_tab asg_download.user_list;
71: l_acc_tab asg_download.access_list;
72: l_str_tab asg_download.access_list;
73:
74: CURSOR l_inserts_cur IS

Line 71: l_acc_tab asg_download.access_list;

67:
68: l_mark_dirty boolean;
69:
70: l_user_tab asg_download.user_list;
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

Line 72: l_str_tab asg_download.access_list;

68: l_mark_dirty boolean;
69:
70: l_user_tab asg_download.user_list;
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

Line 102: l_mark_dirty := asg_download.mark_dirty(

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:
102: l_mark_dirty := asg_download.mark_dirty(
103: P_PUB_ITEM => 'CSF_M_STATE_TRANSITIONS'
104: , p_accessList => l_acc_tab
105: , p_userid_list => l_user_tab
106: , p_dml_type => 'I'