APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on CSM_HZ_CUST_ACCT_SITES_ALL_ACC

Line 20: FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc

16: IS
17:
18: CURSOR c_del_cur IS
19: select ACCESS_ID, USER_ID
20: FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc
21: WHERE NOT EXISTS(SELECT 1 from hz_cust_acct_sites_all hcas
22: WHERE acc.cust_acct_site_id=hcas.cust_acct_site_id
23: AND hcas.status='A'
24: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu

Line 42: AND NOT EXISTS(SELECT 1 FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc

38: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu
39: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
40: AND hcsu.site_use_code='SHIP_TO'
41: AND hcsu.status='A')
42: AND NOT EXISTS(SELECT 1 FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc
43: WHERE acc.cust_acct_site_id=hcas.cust_acct_site_id
44: AND acc.user_id=ps.user_id);
45:
46: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 65: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,

61:
62: FETCH c_del_cur BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
63: EXIT WHEN l_tab_access_id.COUNT = 0;
64:
65: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,
66: 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD', FND_LOG.LEVEL_PROCEDURE);
67:
68: l_markdirty := asg_download.mark_dirty(
69: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'

Line 77: DELETE FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC WHERE access_id = l_tab_access_id(i);

73: , P_TIMESTAMP => sysdate
74: );
75:
76: FORALL i IN 1..l_tab_access_id.COUNT
77: DELETE FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC WHERE access_id = l_tab_access_id(i);
78:
79: COMMIT;
80: END LOOP;
81: CLOSE c_del_cur;

Line 95: INSERT INTO CSM_HZ_CUST_ACCT_SITES_ALL_ACC(ACCESS_ID,USER_ID,CUST_ACCT_SITE_ID,

91: FETCH c_ins_cur BULK COLLECT INTO l_tab_access_id,l_tab_cas_id,l_tab_user_id LIMIT 1000;
92: EXIT WHEN l_tab_access_id.COUNT=0;
93:
94: FORALL I IN 1..l_tab_access_id.COUNT
95: INSERT INTO CSM_HZ_CUST_ACCT_SITES_ALL_ACC(ACCESS_ID,USER_ID,CUST_ACCT_SITE_ID,
96: COUNTER,created_by, creation_date, last_updated_by, last_update_date )
97: VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_cas_id(I),
98: 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
99:

Line 108: CSM_UTIL_PKG.LOG('Bulk Inserted ' || l_tab_access_id.count || ' records into CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,

104: , p_dml_type => 'I'
105: , P_TIMESTAMP => sysdate
106: );
107:
108: CSM_UTIL_PKG.LOG('Bulk Inserted ' || l_tab_access_id.count || ' records into CSM_HZ_CUST_ACCT_SITES_ALL_ACC' ,
109: 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_UPD',FND_LOG.LEVEL_PROCEDURE);
110: COMMIT;
111: END LOOP;
112: CLOSE c_ins_cur;

Line 144: AND NOT EXISTS(SELECT 1 FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc

140: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu
141: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
142: AND hcsu.site_use_code='SHIP_TO'
143: AND hcsu.status='A')
144: AND NOT EXISTS(SELECT 1 FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc
145: WHERE acc.cust_acct_site_id=hcas.cust_acct_site_id
146: AND acc.user_id=p_user_id);
147:
148:

Line 152: INSERT INTO CSM_HZ_CUST_ACCT_SITES_ALL_ACC(ACCESS_ID,USER_ID,CUST_ACCT_SITE_ID,

148:
149: FETCH c_ins_cur BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_cas_id;
150:
151: FORALL I IN 1..l_tab_access_id.COUNT
152: INSERT INTO CSM_HZ_CUST_ACCT_SITES_ALL_ACC(ACCESS_ID,USER_ID,CUST_ACCT_SITE_ID,
153: COUNTER,created_by, creation_date, last_updated_by, last_update_date )
154: VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_cas_id(I),
155: 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
156: