APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 46: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

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;
47: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
48: l_tab_cas_id l_num_tab_type;
49: l_markdirty BOOLEAN;
50: l_e VARCHAR2(4000);

Line 47: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

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;
47: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
48: l_tab_cas_id l_num_tab_type;
49: l_markdirty BOOLEAN;
50: l_e VARCHAR2(4000);
51: l_r varchar2(10);

Line 68: l_markdirty := asg_download.mark_dirty(

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

Line 100: l_markdirty := asg_download.mark_dirty(

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

Line 126: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

122:
123: type r_cursor is REF CURSOR;
124: c_ins_cur r_cursor;
125:
126: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
127: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
128: l_tab_cas_id l_num_tab_type;
129: l_e VARCHAR2(4000);
130: l_r varchar2(10);

Line 127: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

123: type r_cursor is REF CURSOR;
124: c_ins_cur r_cursor;
125:
126: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
127: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
128: l_tab_cas_id l_num_tab_type;
129: l_e VARCHAR2(4000);
130: l_r varchar2(10);
131: BEGIN

Line 158: l_markdirty := asg_download.mark_dirty(

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

Line 255: l_accessid_lst asg_download.access_list;

251: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
252: l_sqlerrno varchar2(20);
253: l_sqlerrmsg varchar2(2000);
254: l_markdirty BOOLEAN;
255: l_accessid_lst asg_download.access_list;
256: l_userid_lst asg_download.user_list;
257: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
258:
259: BEGIN

Line 256: l_userid_lst asg_download.user_list;

252: l_sqlerrno varchar2(20);
253: l_sqlerrmsg varchar2(2000);
254: l_markdirty BOOLEAN;
255: l_accessid_lst asg_download.access_list;
256: l_userid_lst asg_download.user_list;
257: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
258:
259: BEGIN
260: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);

Line 274: l_markdirty := asg_download.mark_dirty( g_pub_item,l_accessid_lst ,l_userid_lst, 'U', sysdate );

270:
271: FETCH c_cust_accnt_upd BULK COLLECT INTO l_accessid_lst,l_userid_lst LIMIT 1000;
272: EXIT WHEN l_accessid_lst.COUNT=0;
273:
274: l_markdirty := asg_download.mark_dirty( g_pub_item,l_accessid_lst ,l_userid_lst, 'U', sysdate );
275:
276: COMMIT;
277: END LOOP;
278: