eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

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 21: WHERE NOT EXISTS(SELECT 1 from hz_cust_acct_sites_all hcas

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
25: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id

Line 35: from hz_cust_acct_sites_all hcas,CSM_PARTY_SITES_ACC ps

31:
32: CURSOR c_ins_cur
33: IS
34: select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, hcas.cust_acct_site_id,ps.user_id
35: from hz_cust_acct_sites_all hcas,CSM_PARTY_SITES_ACC ps
36: WHERE ps.PARTY_SITE_ID=hcas.party_site_id
37: AND hcas.status='A'
38: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu
39: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id

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 69: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'

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'
70: , p_accessList => l_tab_access_id
71: , p_userid_list => l_tab_user_id
72: , p_dml_type => 'D'
73: , P_TIMESTAMP => sysdate

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 101: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'

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:
100: l_markdirty := asg_download.mark_dirty(
101: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'
102: , p_accessList => l_tab_access_id
103: , p_userid_list => l_tab_user_id
104: , p_dml_type => 'I'
105: , P_TIMESTAMP => sysdate

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 136: from hz_cust_acct_sites_all hcas

132:
133: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);
134:
135: OPEN c_ins_cur FOR select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, p_user_id,hcas.cust_acct_site_id
136: from hz_cust_acct_sites_all hcas
137: where hcas.party_site_id = p_party_site_id
138: AND hcas.status='A' --download only active ones
139: And ORG_ID=p_org_id
140: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu

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:

Line 159: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'

155: 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate);
156:
157: IF l_tab_access_id.COUNT > 0 THEN
158: l_markdirty := asg_download.mark_dirty(
159: P_PUB_ITEM => 'CSM_HZ_CUST_ACCT_SITES_ALL'
160: , p_accessList => l_tab_access_id
161: , p_userid_list => l_tab_user_id
162: , p_dml_type => 'I'
163: , P_TIMESTAMP => sysdate